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