Customer Loyalty πŸ’Ž Built for Sidekick ⚑ Sidekick does this for you
shopify sidekick segments aov

Segment Customers by Above-Average Order Value

Build a segment of customers whose average order value exceeds the store average, to target with bundle and upsell campaigns.

πŸ“‹ Prompt
Run in Sidekick
First, pull my store’s overall average order value over the last [PERIOD_MONTHS] months via ShopifyQL.

Then create a customer segment named [SEGMENT_NAME] for customers whose personal average order value is at least [MULTIPLIER]x the store average.

Segment filter:

  Average order value >= $[COMPUTED_THRESHOLD] (fill in using the store average times the multiplier)
  Number of orders >= [MIN_ORDERS]


Report the segment size and the [NUMBER] products most commonly appearing in their orders.

Draft β€” but do not send β€” a Shopify Messaging email to this segment introducing [BUNDLE_OR_UPSELL_OFFER], framed around getting more from a single order rather than a discount, since this group already spends above average per order and a price cut isn’t the right lever.

If the segment is smaller than [MIN_EXPECTED_SIZE], lower the multiplier to [ALTERNATE_MULTIPLIER]x and show me both segment sizes so I can choose the cutoff.

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
πŸš€

Joy Loyalty

Sidekick can tag customers and issue discount codes, but Shopify has no native points ledger. Joy runs the points, tiers, and redemption side.

Install Joy Loyalty β€” Free →