Analytics 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick analytics seasonality

Report Year-over-Year Seasonality Comparison

Compare this year's sales pattern to last year's for the same calendar window to separate seasonal effects from real growth or decline.

📋 Prompt
Run in Sidekick
Compare sales for [DATE RANGE, e.g. NOV 1 - DEC 31] this year against the exact same calendar dates last year.

Per week within the range:

  Revenue this year vs revenue same week last year
  % change year over year
  Order count and AOV, same comparison


Analysis:

  Is this year’s pattern tracking ahead of, in line with, or behind last year’s for the same seasonal window?
  Which specific week shows the largest YoY gap (positive or negative), and what changed that week (a promotion, a product launch, a stockout, a different calendar date for a holiday)?
  Top 10 products this year vs top 10 products in the same window last year — has the seasonal bestseller list shifted?


Output format:

  Table: week, revenue this year, revenue last year, % change, orders, AOV
  Two top-10 product lists side by side


Deliverables:

  Both outputs
  A clear headline number: total revenue this window vs the same window last year, % change
  Flag anything that looks like a calendar-alignment issue (e.g. a holiday falling on a different day of week) rather than a real performance change, so the comparison isn’t misread

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