Meta Ads Export Audit: Funnel Leaks and Wasted Spend
Turn a Meta Ads Manager CSV into a cleaned funnel diagnosis, margin-based verdicts, and fixes ranked by dollar impact.
Before & after
Same prompt, same agent — the only difference is the skill.
I can review your Meta Ads performance. To give you meaningful insights, I'll need to see the CSV file and understand a few things about your account. What are your main campaign goals - lead generation, conversions, brand awareness? What's your current monthly ad spend? Are you running campaigns across Facebook and Instagram, or just one platform? What time period does this report cover? Once I have those details, I can walk you through what I'm seeing in terms of engagement, click-through rates, and spend efficiency, and we can discuss potential optimizations.
META ADS PERFORMANCE AUDIT FUNNEL ANALYSIS: Impressions: 2.4M | CTR: 1.2% (benchmark: 2.8%) → Clicks: 28.8K | CPC: $0.82 (benchmark: $0.55) → Adds to Cart: 3,200 | CTACR: 11.1% (benchmark: 8.5%) → Purchases: 240 | CPA: $112 (benchmark: $68) FUNNEL BOTTLENECKS: 1. CTR gap: -1.6% = 38.4K lost clicks at no extra cost (if creative improved) 2. Conversion rate: 7.5% (target: 12%) - likely landing page friction 3. CPM efficiency: $22 (your) vs $16 (benchmark) - audience overlap CREATIVE PERFORMANCE SCORES (out of 10): Video Ad A (dancing workout): 8.2 - Stop scrolling power high, converts 18% Video Ad B (testimonial): 5.1 - Tired format, converts 6% Static carousel: 4.8 - Low engagement, recommend pause Reel Ad: 7.4 - Good performance, scale up 30% WASTED SPEND IDENTIFIED: • Static carousel: $4,200 spend for $650 revenue (loss: -$3,550) • Audience overlap: 340K impressions duplicated across Ad Sets A & B • Pause audience: 65+ age group (CTR 0.3%, 12x lower cost-per-sale) PRIORITY ACTIONS (ROI impact): 1. IMMEDIATE: Pause static carousel (save $1,400/week) 2. WEEK 1: Split overlapping audiences, geo-target to high-LTV regions (+25% ROAS) 3. WEEK 2: Increase Video Ad A budget 50%, reduce Ad B 70% 4. ONGOING: Test landing page variants (current conversion leakage: $8K/month) FULL REPORT: 24 charts, audience segments, creative DNA analysis available
About this skill
Your Meta spend keeps climbing, ROAS keeps sliding, and the Ads Manager export is 40 columns of numbers that don't tell you why. This skill reads the export the way an experienced media buyer does. It cleans out the traps that make most analyses wrong, finds the exact funnel stage that's leaking, and tells you which ad sets to cut, fix, or hold, along with what each move is worth in dollars.
What it does
- Cleans the export before doing any math: drops totals rows, refuses to add up mixed result types or deduplicated reach, and flags mixed attribution settings
- Breaks CPA into CPM x link CTR x conversion rate so you can see whether rising costs come from the auction, the creative, or the landing page
- Walks the funnel from impression to link click, landing page view, add to cart, and purchase, and names the likely cause of the biggest drop-off
- Judges every result against your breakeven CPA and ROAS, calculated from your margin, instead of made-up industry averages
- Won't call an ad a loser before it has spent enough to judge, and only calls creative fatigue when daily data shows it
- Ranks actions by estimated dollar impact, with the assumption behind each estimate stated
What you get
A compact audit with: scope and breakeven targets, a one-line headline, a text funnel showing where it leaks, a segment table with a verdict per ad set, a creative read, ranked actions with dollar estimates, and what to watch next. If you don't have an export yet, you get the exact export settings to pull.
Best for
DTC founders, in-house marketers, and freelance media buyers running Facebook and Instagram ads who have the numbers but need a clear, defensible answer on where the money is going.
SKILL.md preview
---
name: meta-ads-export-audit
description: Audits Meta (Facebook/Instagram) Ads Manager exports. It cleans the CSV, breaks CPA into CPM, link CTR, and conversion rate, finds the funnel stage that is leaking, judges results against margin-based breakeven, and ranks fixes by dollar impact. Use when the user says "analyze my Meta ads CSV", "audit my Facebook ads", "why is my CPA going up", "my ROAS dropped and I don't know why", "which ads should I kill", "my Facebook ads keep spending with no sales", "is this CTR good", or pastes an Ads Manager export.
---
# Meta Ads Export Audit: Funnel Leaks and Wasted Spend
… (sign up to view the full skill)More marketing & growth skills
View all Marketing & Growth skills →Paid Ads Campaign Planning and ROAS/CPA Diagnosis
Plans paid campaigns on Google, Meta, LinkedIn and X from break-even math, writes ads, and finds the metric behind a ROAS or CPA drop.
Scheduled Marketing Loop Spec for AI Agents
Designs a recurring marketing loop an AI agent runs on schedule: fresh inputs, ledger, approval gates, metrics, kill rules, run prompt.
App Store Screenshot Headlines That Convert
Screenshot captions for App Store and Google Play, mined from your app's code: ordered headlines, alternates, and A/B test ideas.
Analytics Audit: Reconcile Numbers, Fix Tracking
Finds which number is true when your dashboards disagree, sizes every gap, and builds tracking around the decision you have to make.