Customer Loyalty 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick segments churn retention

Build an At-Risk Churn Segment from Declining Order Frequency

Identify repeat customers whose ordering pace has slowed relative to their own history, flagging churn risk before they go fully lapsed.

📋 Prompt
Run in Sidekick
I want to catch customers who are slowing down before they go fully dormant, not just after.

Pull a ShopifyQL report for customers with at least [MIN_ORDERS] orders, showing each customer’s average days between their first [MIN_ORDERS] orders versus the days since their most recent order.

Flag anyone where days-since-last-order is at least [SLOWDOWN_MULTIPLIER]x their historical average gap between orders — meaning they’re overdue relative to their own normal pace, even if the absolute day count looks low.

Create a customer segment named [SEGMENT_NAME] from that flagged list, filtered on:

  Number of orders >= [MIN_ORDERS]
  Days since last order > [ABSOLUTE_DAY_FLOOR] (so we don’t flag someone who ordered a week ago)


Report the segment size and combined historical revenue at risk.

Tag every customer in this segment [AT_RISK_TAG], and note that this tag should be re-evaluated whenever I re-run this prompt, since a customer who reorders should drop out automatically next time the segment refreshes.

Do not draft or send a win-back offer yet — I want to review the list first since this is a softer signal than a hard lapsed-days cutoff and I want to sanity-check false positives.

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 →