Member data for an investor education membership lived in three tools. Retention numbers only existed when someone asked. I built one system that shows it automatically, every day.
AUTO REFRESH
DailyInstead of on request.
Views fed
~18Running off one workbook.
"It refuses to guess."The best part of this system is that the data that can't be matched gets labeled, not filled in.
Before and after
01
BeforeThree tools, no shared view. Numbers on request.
AfterOne shared view. Every report reads from the same numbers, every day.
One
BOOK
Every report reads from the same numbers
The system
02
Recreated. Flow is accurate, data is not shown.
What changed
03
→
At-risk members caught earlier
A churn-risk score flagged warning signs early: dropping engagement, no check-ins booked, failed payments and support tickets.
→
Hours back every week
Manual status work replaced by the daily briefing.
Looking back
I'd bring the rest of the team in earlier, to hear their ideas and problems up front. Adoption would have gone smoother.