You already know that keeping a customer is cheaper than finding a new one. But most small stores don’t have a system for spotting when a good customer is about to leave. They just notice the silence. Here’s a Shopify Flow recipe that flags customers at risk of churning before they disappear.
The Problem: Silent Churn
Your best customers don’t announce they’re leaving. They just stop buying. Maybe they had one bad experience. Maybe a competitor caught their eye. Maybe life got busy. Whatever the reason, by the time you notice they’re gone, it’s too late to win them back.
The fix is simple: set up an automated trigger that identifies customers whose purchasing pattern has changed and flags them for your attention. Not a generic “we miss you” email. A real flag on the customer record that says “this person might be slipping away.”
The Churn-Flag Recipe
This Flow recipe watches for customers who used to order regularly but haven’t placed an order in a while. When it detects the pattern, it tags the customer so you can take action.
Setup
- Trigger: “Schedule” (set to run daily, or weekly if your order volume is low).
- Get customer data: Use the “Get customer data” action. This pulls all customers who have placed at least 2 orders.
- Add condition: “Customer last order date” is “before” the current date minus your threshold. For most stores, this is 60-90 days. If a customer who typically orders monthly hasn’t ordered in 60 days, something’s changed.
- Add condition: “Customer orders count” is “greater than” 1. This ensures you’re only flagging repeat customers, not one-time buyers who were never really “yours” to lose.
- Condition: “Customer tags” does “not contain” “churn-risk.” This prevents re-tagging the same customer every day.
- Action: “Add customer tags” with the tag “churn-risk.”
- Optional action: “Send email” to yourself with the customer’s name, email, last order date, and total orders. This gives you a daily or weekly list of at-risk customers to review.
What to Do With the Flag
The tag itself doesn’t do anything. That’s the point. It’s a signal, not an action. What you do with the signal is where the value is.
Here are three effective responses:
- Personal outreach: Send a brief, genuine email. Not a discount. Just a “hey, noticed you haven’t been around, is everything okay?” This alone has a surprisingly high response rate.
- Targeted offer: If personal outreach doesn’t get a response, add a second Flow that waits 7 days after the “churn-risk” tag and sends a targeted discount or free shipping offer.
- Product recommendation: Use their order history to suggest something they haven’t tried yet. “You loved X. We just launched Y. Thought of you.”
Variations on the Recipe
Adjust the thresholds based on your store’s typical purchase cycle:
- High-frequency stores (grocery, supplements, consumables): Set the threshold to 30-45 days. If they usually order monthly, 45 days is a red flag.
- Mid-frequency stores (fashion, home goods): 60-90 days is your window.
- Low-frequency stores (furniture, electronics): 180+ days. Don’t flag someone for not buying a sofa every month.
The key metric is your average order interval. Set the threshold at roughly 2-3x that interval. If customers typically order every 30 days, flag at 60-90 days. If every 90 days, flag at 180-270.
Don’t Automate the Relationship
One caution: don’t set up an automated discount email as your only churn response. It trains customers to wait for discounts, and it removes the personal touch that actually retains people. Use Flow to flag, not to replace your judgment.
The best churn prevention is still a human deciding how to respond. Flow just makes sure you see the signal in time to act on it.
Want more like this? Join MOKU CLUB for free. Weekly resources, early access to new guides, and occasional templates you can actually use. Join below.
