Analytics
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
analytics
discounts
Report First-Order Discount Dependency
Measure what share of new customers only convert with a discount code, and whether those customers come back at full price later.
📋 Prompt
Report how dependent first-time purchases are on a discount code, for new customers acquired in [LAST 90 DAYS]. What to calculate: % of first orders that used a discount code vs full price Average discount % applied on first orders AOV of discounted first orders vs full-price first orders Follow-through check: Of customers whose first order was discounted, what % placed a 2nd order? Of that 2nd order, what % also used a discount code (still price-sensitive) vs paid full price (discount successfully converted them into a full-value customer)? Same follow-through numbers for customers whose first order was full-price, for comparison Output format: Summary: % of first orders discounted, average discount % Table comparing discounted-first-order customers vs full-price-first-order customers: repeat rate, % of repeat orders still discounted, average lifetime orders so far Deliverables: The comparison table A clear read on whether the current first-order discount is acquiring customers who convert to full-price repeat buyers, or mostly attracting one-time deal-seekers who never return without another discount
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