Customer Loyalty 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick segments ltv shopifyql

Build a Top-Spend Segment for High-LTV Customers

Create a segment of customers in the top percentile of lifetime spend and pull a ShopifyQL report on what makes them different.

📋 Prompt
Run in Sidekick
Create a customer segment named [SEGMENT_NAME] for my highest lifetime-value customers.

Segment filter:

  Total amount spent (all-time) >= $[LTV_THRESHOLD]
  Customer status = enabled (excludes disabled/archived accounts)


Then run a ShopifyQL query comparing this segment to the rest of my customer base on:

  Average order value
  Average number of orders
  Top [NUMBER] products or collections by revenue within this segment
  Average days between orders


Summarize what distinguishes this segment from typical customers — order frequency, order size, tenure, or product mix — so I know what to reinforce with my broader base.

If the segment ends up smaller than [MIN_EXPECTED_SIZE] customers, suggest a lower spend threshold and show me the resulting segment size at $[ALTERNATE_LTV_THRESHOLD] so I can pick the cutoff that gives a workable target list.

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 →