Data request for small churned segment
complete
Teri Rosenbaum
We're still trying to retroactively assign dollar amounts to each home club and get a reliable monthly total for each from the start of the year through to now. We have a list of ~300 users that do not have a home club assigned, most of which appear to be churned 'inactive users'.
If I share the list of user emails, would you be able to (i) match the emails with users in the DB and (ii) return all affiliated data for that user? This is so we can make an educated call on what home club they were a part of and how much they paid over time. (If there is no user record affiliated, they can be ignored for this exercise.)
(I would do this myself on Grafana but the churn table I have access to does not export the right data - we're looking for as much data on geo (which we have) but also on subscription type, payment interval, payment amounts, etc (which we do not have). )
Yayem
marked this post as
complete
Teri Rosenbaum
Very helpful, thanks - doing now
Yayem
We can’t manually match or reconstruct revenue history on our side, as we don't store user transactions in our database. The most reliable source of truth for this is Stripe — both the original account (pre-migration) and the new account.
Stripe logs every transaction ever processed, including subscription type, interval, amount, invoice data, and timestamps. You can pull this all directly:
Go to Stripe → Payments → Transactions
Filter by date range (e.g., Jan 1 → today)
Export the full CSV
Repeat for the old and new Stripe accounts
Join those exports against your email list to determine home club and payment history.
Sharing a screenshot of where to pull the exports if helpful.