Context
Multi-location healthcare enterprise: 17 open practices across the US, investing roughly $9M a year in direct media.
The problem
Compare return on advertising across every location, and find where budget is working hardest and where it needs attention.
Technical approach
A year-over-year dashboard: 2025 actuals vs the 2026 outlook (actuals through August plus projection) for spend, collections and ROI.
Business value
2025 vs 2026 by location
Full-year 2025 actual vs 2026 outlook
Year-over-year change
Growth in green, decline in orange. Sorted by change.
Return on ad spend by location
Collections per $1 of direct media spend: 2025 actual vs 2026 outlook. Sorted by 2026 return.
Positive achievements & insights
Top 5 by collections growth
Top 5 by ROI improvement
2026 monthly collections, all locations
Budget allocation efficiency
2026 outlook: ad spend (x) vs collections (y). Dashed lines mark the 17-location averages; dot size = ROI.
- Stars lower spend, higher collections
- Cash Cows higher spend, higher collections
- Question Marks lower spend, lower collections
- Dogs higher spend, lower collections
Method. 2025 is a 53-week year; 2026 spend = 4-4-5 monthly actuals through August, September to date, and projected Oct–Dec. 2026 collections = the finance estimate for end of week 52 (actual Jan–Aug: ). Like-for-like Jan–Aug spend is also reported. ROI = collections ÷ direct media spend. Location names are anonymised.