The problem with subscription CSVs
If you run subscriptions on Shopify, you already know: the CSV exports are a mess. Duplicate customer rows everywhere. Cancel reasons that say "too expensive" in one row and "too pricey" in the next. You end up spending hours in Excel just to get a number you trust.
We kept hearing this from DTC brands. Not as an abstract complaint, but as a specific, recurring time sink. Someone on the team exports the data, spends a morning deduplicating it, and still isn't sure the MRR number is right.
What we built
This update does three things:
- Merges duplicate customer records automatically. If the same person has two subscriptions, they show up as one row with the correct combined revenue.
- Groups cancel reasons that mean the same thing. "Too expensive," "too pricey," and "cost" all become one category, so your churn reports actually make sense.
- Generates monthly retention reports without the spreadsheet gymnastics. You get a report in minutes instead of a morning.
How it looks in practice
A coffee brand we work with had a customer named Maya with separate rows for her coffee and matcha subscriptions. Their MRR spreadsheet counted her twice in some months, not at all in others. After running the cleanup, Maya shows up once with a combined MRR of $49.90.
Same brand had 23 different cancel reason labels that really boiled down to 6 categories. Once those were grouped, they could actually see that "shipping delays" was their biggest churn driver, not price. That was hidden before.
Who this is for
DTC subscription businesses on Shopify. Coffee, skincare, supplements, whatever. If you're exporting CSVs from Recharge or similar and manually cleaning them, this replaces that process.
You get automated cohort analysis, fewer spreadsheet hours, and fewer errors from manual data entry. The boring stuff gets handled so you can spend that time on the parts of the business that actually need a human.