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

  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 →