Breakdown Report Analyzer for Meta Ads

How to analyze a Meta Ads breakdown

A Meta Ads breakdown splits your results by placement, age, gender, device or region. This analyzer adds up an Ads Manager export and shows each segment's share of spend, share of results and cost per result next to the average. It follows Meta's breakdowns, metrics and filtering page and its breakdown effect article, so it never tells you to switch off a placement only because its average cost looks high.

1. Choose a breakdown in Ads Manager. Open the Breakdown menu between Columns and Reports and pick one, such as Placement or Age and gender. Keep Results and Amount spent in your columns.
2. Export and drop the file in. CSV and Excel both work, in any currency and with decimal commas. Summary rows are skipped.
3. Check the columns. The breakdown columns, spend and results are found by name. Add a result indicator column if your file mixes campaigns with different goals.
4. Read the charts with the note on top. Orange bars cost more per result than your average. That is a question to test, not proof of waste.
5. Compare inside each ad set. Switch the option to see segments within each ad set or campaign — the level Meta says to judge results at.

Why averages mislead in breakdowns

In Meta's own example, a campaign ran on Facebook Stories and Instagram Stories with a $500 budget. Facebook Stories started cheaper, but its cost rose faster as more was spent there. After a small test on each, the system shifted the remaining $400 to Instagram Stories, which ended with $450 of the spend. At the end Instagram Stories showed $1.46 per result and Facebook Stories $1.10 — yet Meta explains that the shift drove more results overall, because the cost on Facebook Stories was climbing faster. A breakdown table only shows averages, not the cost of the next result.

What to do next in Ads Manager

1. Start from the total. Note the cost per result of the campaign (with Advantage+ campaign budget) or of each ad set. That is the number any change must improve.
2. Look for real outliers. A segment that spends a lot over a long period with no results at all is worth a test. One that is simply above average is usually not.
3. Test, don't cut everywhere. Duplicate one ad set, remove the segment there only, and run both side by side. Compare the ad sets' total cost per result.
4. Check the creative per placement (our advice). If Stories or Reels look expensive, first make sure the ad was made for a vertical, full-screen space. A better-fitting version is a cheaper test than removing the placement.
5. Check tracking for missing results. If a breakdown shows website purchases as zero, make sure you used a breakdown that returns website conversions.

Common Meta breakdown problems

Breakdown rows don't match the campaign total

Platform, placement and device numbers are estimates. Small gaps against the total are expected. Meta may also use statistical modeling when conversion data is missing.

Purchases show as zero by region or time of day

Those breakdowns don't return website conversions. Use Country, Age, Gender, Placement, Platform or Impression device instead.

“Uncategorized” rows

Conversions Meta could not assign to one segment land here. They belong in your totals, but you can't target or exclude “Uncategorized”.

Gender shown as “not specified”

These are people who don't list a gender. Keep them in the total; they are not a separate audience you can bid on.

Results from different goals added together

A file with a leads campaign and a traffic campaign mixes leads with link clicks in one Results column. The analyzer uses the result indicator to keep only the result type with the most spend and tells you what it left out.

Can't pick two breakdowns from the same group

In Ads Manager you can't combine two breakdowns from the same group, and Age, Country and Placement all sit under By delivery. Pair one delivery breakdown with a time breakdown such as Day, or export two files.