$186k of ad spend later, one channel turns out to be carrying all of it
Until March I could tell you what we spent and how many leads came in and nothing in between. The agency reported cost per lead by channel, monthly, and I signed off on it for three quarters like a fool.
Context: I sit on the capital side of a small acquisitions operation buying single family in two metros. Marketing runs through one agency, $6,500 a month retainer plus media. Total for the twelve months, $186,400 media, $78,000 retainer.
What I built, over about six weeks: a tracking number per campaign rather than per channel, a required source field at lead intake that the CRM won't let you skip, and a monthly reconciliation where every closed file gets tied back to its originating lead ID. Boring plumbing. The hard part was that dispositions and acquisitions had been overwriting the source field when a lead got reassigned, so three months of history was garbage and I backfilled it out of call recordings and email timestamps.
The result, which I did not expect to be this lopsided: Google search took about a third of media and produced most of the closings. Facebook lead forms took the largest single share of media and produced a small handful, and two of those had touched a search ad first. Cost per closed deal on search was under $4,000. On social it was north of $22,000 on the deals it could claim outright.
We cut social to a small remarketing budget, moved the money to search and to an SEO retainer we'd been paying for and never measured, and restructured the agency deal to a lower base plus a fee per signed contract. Blended cost per closed deal for the last four months is running around $5,100 against $8,470 for the twelve month period.
The agency did not fight the restructure, which told me they'd been waiting for a client to ask.