Free Claude Skill
Meta Ads · wasted spend audit

Claude Ads
Leak Audit

Export your Ads Manager report. Drop it into Claude. In 15 minutes, see every leak ranked by dollars wasted, what to pause today and where to move the money.

Free. Works on any Claude plan. Your report stays in your own Claude chat.

you → ads_manager_export.csv
↓
  • $Spend scanned + wasted spend found
  • 01Dead creatives still spending
  • 02Ad sets with spend and zero sales
  • 03CAC creep hidden by blended ROAS
  • 04Placements eating budget
  • 05Pause list + where to move money
  • 067-day fix plan
The 12 leak checks

Every dollar gets a job or a verdict.

Each check has a clear threshold and a clear way to count the money. Every dollar is counted once, under one leak, so the total is real, not inflated.

01

Dead creatives

Frequency 4+ and link CTR down 30%+ from its best week, still spending.

02

Zero-sale spenders

Ads and ad sets that spent 2× your target CAC with no conversion.

03

CAC creep

Ad sets at 1.5× target CAC or worse, hidden behind a "fine" account average.

04

Placement drain

Placements taking 5%+ of an ad set's spend with zero or 2× worse results.

05

Learning limited

Ad sets that will never exit learning, and what they cost you.

06

Budget on losers

Spend share 1.5× bigger than conversion share while a better ad set waits.

07

Audience saturation

Prospecting frequency 3+ with CPM climbing week over week.

08

Rising costs

CAC up 40%+ from first to last week at the same or higher spend.

09

Weak hooks

Bottom 25% link CTR ads that still take a real share of the budget.

10

Starved winners

Your cheapest conversions getting under 10% of the spend. Where the money goes.

11

Fragmented structure

Too many ad sets splitting too few conversions to ever learn.

12

Ad overload

6+ ads in one ad set where 2 of them take 80% of the spend.

How to use it

Export. Drop. Fix.

Step 1

Export from Ads Manager

3 files give the full audit. File A alone already finds most leaks.

  1. Ads tab, last 30 days. Columns → Customize: spend, impressions, reach, frequency, CPM, link clicks, link CTR, results, cost per result, purchases, cost per purchase, purchase ROAS, delivery.
  2. Reports → Export table data → CSV. That's File A.
  3. Breakdown → By Time → Week, export again. File B.
  4. Ad sets tab, Breakdown → By Delivery → Placement, export. File C.
Step 2

Run it in Claude

Install the skill once, or copy the prompt from the builder below.

  1. Download ads-leak-audit.zip. Don't unzip it.
  2. Claude → Settings → Capabilities: turn on Code execution and file creation.
  3. Customize → Skills → + → Create skill → Upload a skill, upload the ZIP.
  4. New chat: attach your files and send Run the ads leak audit. Target CAC: $40
↓ Download the skill
Prompt builder

No skill? Copy the prompt.

Works in Claude, ChatGPT or Gemini. Attach your export files in the same message.

Files I'm attaching

      
Paste into a new chat and attach your export files.
Real example

One run on a sample account.

A test export with 8 ad sets and 14 ads, target CAC $40. Every number below was computed from the file with the skill's rules.

$21,130

Spend scanned

Last 30 days · 561 purchases

$5,826

Wasted spend found

27.6% of the budget

8

Leaks found

Across 6 leak types

$37.7

Account CAC

Looks fine. It isn't.

Leak table, ranked by $ wasted
#LeakWhereEvidenceWastedAction
1Placement drainBroad 25-45 · Audience Network$1,456 spent (14% of ad set), 0 purchases$1,456Exclude Audience Network
2Zero-sale spenderTest | Yoga interests$1,280 spent (32× target CAC), 0 purchases$1,280Pause today
3Budget on losersInterests Fitness21% of campaign spend, 14% of purchases, CAC $58$1,050Cut budget 40%
4CAC creepRT | IG engagers 60dCAC $81, 2× target, frequency 4.1$660Pause, keep RT Website
5Learning limitedTest | Runners9 purchases in 30 days, CAC $98$520Merge into Broad
6Dead creativeCarousel BestsellersFrequency 6.1, CTR 1.6% → 0.85%$360Replace creative
7Dead creativeVideo Founder storyFrequency 5.4, CTR 1.5% → 0.80%$280Replace creative
8Learning limitedTest | Pilates6 purchases in 30 days, CAC $77$220Merge into Broad

Pause today

  • Ad set Test | Yoga interests
  • Ad set RT | IG engagers 60d
  • Audience Network in Broad 25-45
  • Ads Carousel Bestsellers, Video Founder story

Move the money

  • LAL 1% Buyers: CAC $22, only 7% of campaign spend. Main home for freed budget.
  • RT | Website 30d: CAC $17.50, already the main retargeting ad set. Hold, don't overspend.
  • Scale +20–30% per step, every 2–3 days.

7-day fix plan

  • Day 1Pause list, exclude placement
  • Day 2Cut Interests Fitness 40%
  • Day 3Merge test ad sets into Broad
  • Day 4Launch 2 new creatives
  • Day 7Re-run the audit, compare
Get more out of it

Six things media buyers know.

Always give a target CAC

Without it, the audit compares you to your own average. That hides the leaks you got used to.

Export by week

File B is what catches dead creatives and rising costs before they eat a full month.

Fix tracking first

If conversions don't add up, every other number is a guess. The audit checks this first.

Don't pause on 2 days

Under 3 days or 1× CAC of spend, it's "watch", not "pause". The skill follows this rule.

Re-run every week

Send next week's export and ask "what changed". You'll see wasted spend going down, or not.

Move money slowly

+20–30% per step. Doubling a winner's budget overnight resets learning and kills it.

Appendix

The full master prompt.

Copy everything below into a new chat, attach your export files and fill in your target CAC.


Found the leaks?
Let's fix them.

RA Agency runs performance campaigns end-to-end on Telegram Ads, Meta and Google: creatives, copy, analytics and scaling. One goal: return on ad spend.

Telegram AdsLive within 24 hours once your product and tracking are ready.
Meta AdsCreative testing across angles and funnel stages, then careful scaling.
Google AdsSearch and PMax with real-time analytics on every channel.
Book a free account review →
ROI or DIE