The Key Insight
The campaign answered the acquisition question it was funded to answer: $3,389 bought 56 electrical panel upgrade inquiries at $60.51 each, and 17 of them reached a Booked status in the client's tracker. What the same data also shows is where the money actually stopped - and it was not in the ad account.
Three things drove it.
The channel repeated itself after a month off. The campaign ran as two separate flights with a 29-day pause between them. Flight one, July 29 - August 24: $1,909 and 31 leads at $62. Flight two, September 22 - October 23: $1,480 and 25 leads at $59. Same offer, same audience settings, restarted from cold - and the cost per lead landed within three dollars of itself. A channel that reproduces its own number after a pause is one you can plan a budget around; a single good month is not.
The weekly spread matters more than the average. The $60.51 average hides a four-fold range. The best full week, October 2-8, bought 14 leads at $30. The two weeks either side of it ran $107 and $112 on similar budgets, and the closing week of the first flight ran $99. Nothing structural changed between them. That spread is where the next dollar of optimisation lives - and because the workbook has no ad-level breakdown, identifying which creative earned the $30 week is exactly what the next test has to be built to answer.
The leak was after the form, not before it. Seventeen of 56 records - 30.4% - reached Booked, which is $199.32 of ad spend per booked appointment on a service the client prices at $4,000-$5,000. Yet the project retrospective records no closed deals. The tracker notes say why: estimates issued in the $2K-$7K range and left unanswered, jobs blocked behind a meter-spot request, homeowners who had already had the work done elsewhere. Those are sales and operations problems with sales and operations fixes. More traffic would not have touched any of them.
And the honest limit of this report: it measures acquisition, not revenue. Spend, impressions, reach, leads and booking status are recorded; clicks, CTR, CPC and CPM are not, and the revenue and ROAS columns were never filled. So this case can prove what a panel-upgrade lead costs in Los Angeles and how many of them a sales team can get on the calendar. It cannot prove what any of them were worth. The next version of this campaign is not a bigger budget - it is ad-level reporting so the $30 week can be repeated, a faster and firmer follow-up on issued estimates, and closed-won revenue in a CRM so the next $3,000 can be judged on signed jobs instead of booked slots.