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