SQL Cumulative and Rolling Metrics | Dataford Interview Questions

Given a table of daily experiment results, how would you compute cumulative conversion rate and a 7-day rolling average in SQL?

Use the provided daily results table. Treat a day with zero exposures or missing conversions as having no daily conversion rate, while cumulative totals should continue across all dates.

Output

One row per experiment date, ordered chronologically.
Columns: experiment_date, exposures, conversions, daily_conversion_rate, cumulative_conversion_rate, and rolling_7_day_avg.
Rates should be rounded to six decimal places.

Schema

daily_experiment_results

Column	Type	Description
experiment_datePK	DATE	Date of the experiment result
exposures	INT	Number of users exposed on the date
conversions	INT	Number of exposed users who converted

Your question is SQL Cumulative and Rolling Metrics. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem