Analytics
π Built for Sidekick
β‘ Sidekick does this for you
shopify
sidekick
analytics
pricing
Report Price-Point Performance
Group products into price bands and compare units, revenue, and margin per band to find the sweet spot.
π Prompt
Group all products into price bands and report performance per band for [LAST 90 DAYS]. Price bands (adjust to fit the catalog): Under [$25] [$25]-[$50] [$50]-[$100] [$100]-[$200] Over [$200] Per band: Number of products in the band Units sold Total revenue % of total revenue the band represents Average gross margin % for products in the band (using cost-per-item) Conversion rate for product pages in this band, if available Analysis: Which price band generates the most revenue? The most margin dollars? Which band has the best margin % β is the storeβs most profitable price point also its highest-volume one, or are they different? Are there gaps β price bands with very few products but strong per-unit performance, suggesting room to add more SKUs there? Output format: Table: price band, product count, units sold, revenue, % of total, avg margin % Deliverables: The table A clear recommendation on which price band deserves more catalog investment (new products, more marketing push) based on the volume-vs-margin tradeoff shown in the data
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