Sqlism
Loading…
Marketing & Ads · Ticket #3

7-day moving average of ad spend

Mid Pro 13 min
marketing-analytics Brandly
Ritu AgarwalMarketing Director
For the spend dashboard, can you add a **7-day moving average** of daily spend for the first two weeks of September? Daily numbers are too jumpy.

This ticket is part of Sqlism Pro

See how Kunal Mehra handles it from start to finish:

  • The clarifying questions and the manager's answers
  • Step-by-step thinking behind the query
  • The buggy first draft, why it's wrong, and the fix, all runnable
  • A “your turn” editor that checks your answer

One-time payment. Unlocks every Pro ticket, tool, quiz level and interview topic.

Or try a free Marketing & Ads ticket: CTR and cost per click by channel