Mock interview. You're interviewing for a product analyst job on a short-video app. The interviewer says: "Our watch time dashboard had an ugly dip in April. Walk me through how you'd figure out what happened." You have the views table, which records the viewer's device (android or ios).
"Show average watch time per view, week by week, from the week of 2 March to the week of 27 April, with the percentage change from the week before."
Expected output
avg_watch_sec rounded to 1 decimal; pct_change rounded to 1 decimal, empty for the first week; sorted by week_startExample of the shape (made-up values):
| week_start | avg_watch_sec | pct_change |
|---|---|---|
| 2026-03-02 | 30.0 | |
| 2026-03-09 | 33.0 | 10.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.