Four months and $4,800 to learn that the campaign geography was structurally misaligned from day one. The assumption doing the most work here was that the agency would underwrite the market before building the campaign. Most PPC agencies in this space do not. They are paid to run ads, and the offer feasibility analysis sits outside what they consider their scope. That is a gap in how the engagement was scoped, not necessarily negligence, though the two are hard to separate when the rep knew the zip and said nothing.
The risk you did not name: even with a correctly scoped zip, you still need a feedback loop from lead quality back to campaign targeting. Median list price is the blunt version of this, but the sharper version is what percentage of leads in a given geography have enough equity to accept a discount-to-ARV offer. That number varies significantly within a single zip and shifts with market conditions. An agency that cannot pull that into their targeting criteria, or at minimum flag it in onboarding, is going to burn spend regardless of zip selection.
Going forward, the pre-campaign checklist needs to include median list price, estimated equity distribution, and owner-occupancy rate for the target geography before you approve any creative or budget. Some agencies will do this if you ask for it in writing as a condition of the engagement. Some will not, which tells you something.
One structural fix: split the accountability. You own the market underwriting, the agency owns the platform execution, and those two things get reconciled before spend starts. It adds friction up front and saves the kind of friction you just experienced.
What was the equity profile like in that zip? If the median list price was the problem, it may be that the zip skews toward low-equity or recently purchased inventory, which is a different problem than price point alone and points to a different targeting fix.