Can you please check the below code I tried with the sample data it was working
WITH data AS (
SELECT
row_num,
step,
conversion,
LN(conversion) AS ln_conversion
FROM `my_dataset.conversion_table`
)
SELECT
row_num,
step,
conversion,
-- The exponent of the cumulative sum of ln_conversion is our running product
EXP(
SUM(ln_conversion) OVER (
ORDER BY row_num
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
)
) AS total_conversion
FROM data
ORDER BY row_num;