Analytics
💎 Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
analytics
anomaly-detection
Report Week-over-Week Sales Anomalies
Flag any week where revenue, orders, or a key product's sales moved outside the normal range versus recent history.
📋 Prompt
Scan my weekly sales for [LAST 12 WEEKS] and flag any week that’s a statistical outlier versus the trailing average. What to check per week: Total revenue vs the trailing 8-week average and standard deviation Order count vs the same trailing average Revenue for each of my top 10 products vs their own trailing 8-week average Flag as an anomaly: Any week where total revenue or order count is more than [20]% above or below the trailing average Any top product with a single week more than [50]% above or below its own trailing average For each flagged anomaly, note: The size of the deviation A plausible cause if one is visible in the data (a discount code spike, a specific product going out of stock, an unusually large single order, a holiday) Output format: Table: week, metric, value, trailing average, % deviation, flagged (yes/no), likely cause if known Deliverables: The flagged rows only (skip normal weeks) A short summary: how many anomalies this window, and whether they were mostly positive (spikes worth understanding and repeating) or negative (drops worth investigating)
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions