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
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
- 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