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

Report Revenue vs COGS Trend

Chart revenue against cost of goods sold over time to see if margin is expanding or compressing.

📋 Prompt
Run in Sidekick
Pull revenue and cost of goods sold (COGS) side by side for [LAST 6 MONTHS / LAST 12 MONTHS], grouped by [WEEK / MONTH].

What to calculate per period:

  Gross revenue (net of refunds and cancellations)
  COGS (sum of cost-per-item × units sold, from saved product costs)
  Gross margin $ and gross margin %
  Period-over-period % change in each


Analysis:

  Is gross margin % expanding, holding steady, or compressing over the window?
  Which period had the sharpest margin compression, and what changed that period (higher discounting, a shift toward lower-margin products, higher-cost inventory)?
  Is COGS growing faster or slower than revenue?


Output format:

  Table: period, revenue, COGS, margin $, margin %
  Simple line-chart-ready data series for revenue vs COGS


Deliverables:

  The table and chart-ready data
  A 3-4 sentence summary naming the trend direction and most likely cause
  Flag if any period’s margin % is unreliable because too many order lines are missing a cost-per-item value

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