Marketing director at a 5-location medspa group, $10M combined revenue, $40k/mo blended ad spend. Came from B2B performance marketing in 2024. I build a quarterly LTV recovery spreadsheet that has caught things HubSpot, Boulevard, and Mangomint reports don't tell me directly. Sharing because most medspa marketers in my band aren't doing this work, and the platforms aren't going to do it for you. The spreadsheet structure (5 tabs). Tab 1: active cohort retention by location. For each location: count of active clients (treatment in last 12 months). Of those, count of clients with a treatment in the natural cycle (3-4 months for Botox, 6-12 for filler, monthly for facials). The retention rate is `clients-with-cycle-treatment / total-active`. We tracked this quarterly. The spread across our 5 locations was 41% to 67%. Wider than I'd expected. The high-retention location (67%) had a heavy membership mix and a particularly engaged community.…