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
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
- 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
π
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 →