Analytics
π Built for Sidekick
β‘ Sidekick does this for you
shopify
sidekick
analytics
customers
Report Sales by Customer Segment
Compare revenue, AOV, and order frequency across existing customer segments to find the segments worth doubling down on.
π Prompt
Compare sales performance across my existing customer segments for [LAST 90 DAYS]. Per segment: Number of customers in the segment Total revenue from the segment in the period Number of orders AOV Revenue per customer % of total store revenue the segment represents If I donβt have useful segments defined yet, first build these segments from order history, then run the same comparison: VIP (top 10% by lifetime spend) One-time buyers Repeat buyers (2+ orders) Lapsed (no order in 180+ days but had at least one before that) Output format: Table: segment, customer count, revenue, orders, AOV, revenue per customer, % of total revenue Deliverables: The table Identify which segment has the highest revenue-per-customer (the segment worth protecting/rewarding) and which segment represents the largest untapped revenue if converted to repeat buyers One targeting idea per segment based on its numbers, not generic advice
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