Investigate a Drop in Sales
GoogleData Analyst · Onsite
Last updated
Use a structured sales-drop investigation covering metric definitions, data quality, funnel decomposition, segmentation, and causal evidence.
Investigate a Drop in Sales
Sales have dropped. How would you investigate the cause and decide what to do next? Begin by clarifying the sales definition and comparison period. Explain how you would break down the metric, prioritize hypotheses, and separate a data problem from a real business change. No company, product, or numerical dataset is specified.
Hints
Hint 1
Check what the total contains: Gross order value, recognized revenue, and net revenue can move differently when refunds or timing change.
Follow-up questions
- What if total sales fell but conversion rose?
- How would a change in customer mix alter your interpretation of average order value?
Solution walkthrough is for members
Get the full walkthrough with reference code and complexity analysis, plus Kitty Coach at 300 messages a day. Hints, the code runner and community answers stay free.