Local Leap Media

Media Buying Audit & Optimization Playbook

The rules of thumb for auditing a live client account and deciding what to scale, what to optimize, and how to troubleshoot. Distilled from the 2026-06-29 media-buying training call (Sean + Tasneem onboarding a new media buyer).

This is the companion to Media Buyer Launch Playbook. That one covers getting a new client live. This one covers everything after launch — the recurring audit you run when an account needs attention.

How to use it: run the audit process first, then apply the three rule sets (scaling, optimizing, troubleshooting). The one-glance cheat sheet at the bottom is the fast reference once you know the account.


The Audit Process — do this every time

  1. Open both sources side by side. The Profit & Loss Sheet (Imported tab) and Facebook Ads Manager. The sheet is the source of truth for appointments — Ads Manager's lead and CPL counts can be wrong (the sheet often shows more leads than Ads Manager). If a number looks too low, a setter may not have linked the appointment yet — check with the setter before reacting.
  2. Decide: is it a volume problem or a quality problem? Volume = not enough leads coming in. Quality = leads come in but no one answers or books (no response, bad number). It can also be a market problem — some accounts only get cut after many failed tries.
  3. Run the AI analysis. Export the Imported tab as a CSV. Use the team's standard analysis prompt (shared by Sean directly — ask him if you don't have it). It teaches the AI the campaign / ad set / ad structure and what "scheduled" vs "canceled" means. Set the start row to your date window (for example, June 1). Use Claude or ChatGPT — not Gemini (its analysis is unreliable). The output shows which ads produced leads, and which of those leads became appointments.
  4. Look at the live ads for context. Filter to ads that got at least one lead in the last 30 days. Find the ad driving the appointments — it is usually also where most of the leads come from. That ad is your winner. Everything else is measured against it.
  5. Account location note. Most accounts live on Home Project Pal. QPS is a franchise — multiple accounts, not all in one place. Confirm you are in the right account first.

Reading the Kill Switch (lead quality)

Kill-switch reasons fall into two buckets. Only the first bucket is the media buyer's job to fix.

In your control — each one points to a fix

Reason What it usually means Fix
Out of range Radius or location question is wrong Fix the geo (radius / location qualifier)
Job too small Creative is making people think it is a repair or small job Fix the creative message
Price shopper Mostly out of your hands, but the ad can be attracting bargain hunters Watch for a pattern
Bad number Wrong or fake number — often autofill junk Test the WhatsApp-number fix (see Troubleshooting)
No response Never answers — often autofill junk Test the WhatsApp-number fix (see Troubleshooting)

Out of your control — ignore these for ad decisions

Callback · Duplicate · Change mind · Canceled · Booked by company.

React to patterns, not single cases. One "job too small" is noise. A cluster of them means the creative is sending the wrong signal.


Scaling — rules of thumb


Optimizing — rules of thumb


Troubleshooting — rules of thumb


One-Glance Cheat Sheet

What you see Usually means Do this
Winner ad stuck on a small budget Underfed Scale budget (if cost-per-appointment is scalable)
Cost-per-appointment well under ~$150 Room to scale Increase budget
Cost-per-appointment near the appointment's value Too close for comfort Scale carefully; fix booking rate first
CPL rising over 1–2 weeks Ad fatigue Refresh creative or raise budget to re-enter learning — don't auto-kill
High clicks / CTR but no leads Wrong or unserious audience Pause it; move budget to what converts
High CPM alone Warning only Check leads / appointments before killing
Pattern of "out of range" Geo is wrong Fix radius / location question
Pattern of "job too small" Creative signals a small / repair job Fix the creative message
Pattern of "no response" / "bad number" Autofilled junk numbers Add manual WhatsApp field; test
Image number ≠ copy number Mismatch hurting the offer Align image + copy, relaunch
Two campaigns, one asset each Competing for the same audience Merge into one ABO campaign
Two price offers to the same audience Cannibalization Make the higher offer visually distinct

Worked Examples (from the training call)

QPS Charleston — volume + quality problem

Weathermasters — engagement without conversion