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

  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 →