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