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
Run in Sidekick
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

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions