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
Run in Sidekick
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

  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