Claude-Powered Campaign Dashboard for Apex Roofing
A Dallas roofing company was spending $18K/month across Google, Meta, and Nextdoor with no unified view of performance. We ran their campaigns and built a Claude-powered dashboard that consolidated everything — saving 14 hours a week in reporting.
The Challenge
Apex Roofing's marketing manager was manually pulling reports from three ad platforms every week, spending 14+ hours building spreadsheets. There was no way to see blended ROAS, compare channel performance, or make fast budget decisions. Meanwhile, their campaigns were under-optimised due to slow feedback loops.
Our Solution
We took over campaign management across Google Local Service Ads, Meta, and Nextdoor — restructuring audiences, ad copy, and bidding strategies. In parallel, we built a Claude-powered reporting dashboard that pulls live data from all three platform APIs, calculates blended ROAS, flags underperforming ad sets, and generates a plain-English weekly summary using Claude — automatically delivered every Monday morning.
Tech Stack
Service
Digital Marketing
Need something similar?
Let's discuss how we can deliver results like this for your business.
Get in TouchThe Outcomes
Blended ROAS improved from 2.1x to 4.8x in 3 months
14 hours/week of manual reporting eliminated
Cost per booked job reduced from $380 to $164
Claude-generated weekly summary delivered every Monday
“I used to dread Monday reporting. Now I get a clear summary in my inbox telling me exactly what worked and what to change. It's like having an analyst on the team.”
Derek Hartmann
Marketing Manager, Apex Roofing Co.
Explore more work
See other projects we've delivered.