Customer Loyalty
π Built for Sidekick
β‘ Sidekick does this for you
shopify
sidekick
segments
aov
high-value
Segment Customers Who Placed One Unusually Large Order
Identify customers whose single order far exceeds typical order value, a distinct pattern from steady high-AOV repeat buyers.
π Prompt
Pull my storeβs average order value over the last [PERIOD_MONTHS] months via ShopifyQL. Create a customer segment named [SEGMENT_NAME] for customers whose largest single order was at least [MULTIPLIER]x the store average order value. Segment filter: Highest single order value >= $[COMPUTED_THRESHOLD] Number of orders <= [MAX_ORDERS] (to isolate one-off big spenders from steady heavy buyers, a different segment) Report the segment size, and whether that large order included a discount code, a bulk quantity of one product, or a mix of products β that pattern tells me if this was likely a corporate/event purchase versus an unusually generous personal splurge. Draft β do not send β a Shopify Messaging email to this segment following up on that order: if it looks like a corporate or bulk purchase, mention [WHOLESALE_OR_BULK_PROGRAM_NAME]; otherwise, thank them and recommend [COMPLEMENTARY_PRODUCT] at a smaller price point, since a repeat of that exact order size may be unrealistic to expect.
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 →