Customer Loyalty
π Built for Sidekick
β‘ Sidekick does this for you
shopify
sidekick
segments
refunds
risk
Segment Customers with Above-Average Refund Rates
Build a segment of customers whose refund rate exceeds the store average, to flag for review before future discount or VIP offers.
π Prompt
First, pull my storeβs overall refund rate (refunded order value divided by total order value) over the last [PERIOD_MONTHS] months via ShopifyQL. Then create a customer segment named [SEGMENT_NAME] for customers whose personal refund rate is at least [MULTIPLIER]x the store average. Segment filter: Number of orders >= [MIN_ORDERS] (avoid flagging someone off a single refunded order) Refunded order value / total order value >= [COMPUTED_THRESHOLD_PERCENT]% Report the segment size, their combined refund value over the period, and the [NUMBER] products most commonly refunded within this group β a product pattern might point to a quality or sizing issue rather than a customer pattern. Tag every customer in this segment [REVIEW_TAG] so my team can manually review before including them in any future VIP tier, loyalty reward, or high-trust offer like early access β I donβt want to reward an above-average refund rate by accident. Do not send anything or take any other action on these accounts.
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 →