Mini-App · Advertising
Check Meta Ads Cost per Result and CTR by Campaign
For small business owners and marketers who run Meta (Facebook and Instagram) ads and want to see which campaigns cost too much. Upload a daily campaign export from Ads Manager as CSV and set the most you will pay per result.
You get one row per campaign plus a TOTAL row, with spend, results, cost per result and CTR. Campaigns over your limit, or with spend and no results, are flagged. A bar chart shows which campaigns are over or within your limit.
Meta Ads daily campaign export
Your file stays private to you. One free try without an account; then 2 credits a run.
A real result, on the sample file
Grouped 1278 daily rows by campaign for 2025-07-01 to 2026-08-30: 3 campaigns, 2 flagged (cost per result above 40 USD, or spend with no results; 0 with no results shown as blank cost per result and not drawn on the chart). Blank Results counted as 0; cost per result = total spend / results; average CTR is pooled (clicks / impressions); mean daily CTR is the simple average of the daily CTR column. TOTAL row uses overall sums.
| Campaign name | Days | Total Amount spent (USD) | Impressions | Link clicks | Results | Cost per result (USD) | Average CTR (%) | Mean daily CTR (%) | Result indicator | Above threshold |
|---|---|---|---|---|---|---|---|---|---|---|
| Prospecting - Lookalike | 426 | 36351.92 | 2047527 | 22525 | 588 | 61.82 | 1.1 | 1.1 | actions:offsite_conversion.fb_pixel_purchase | Yes |
| Catalog Sales | 426 | 28488.01 | 1809119 | 23521 | 621 | 45.87 | 1.3 | 1.3 | actions:offsite_conversion.fb_pixel_purchase | Yes |
| Retargeting - 30d | 426 | 18135.45 | 1107753 | 19943 | 495 | 36.64 | 1.8 | 1.8 | actions:offsite_conversion.fb_pixel_purchase | No |
| TOTAL | 1278 | 82975.38 | 4964399 | 65989 | 1704 | 48.69 | 1.33 | 1.4 | actions:offsite_conversion.fb_pixel_purchase | Yes |
How to use it
- 1In Meta Ads Manager, export the campaign report broken down by day as CSV, with Amount spent, Impressions, Link clicks, CTR (link), Results and Result indicator columns.
- 2Check that the export covers the date range you want and that spend is in USD.
- 3Set the maximum cost per result you accept. Campaigns above it are flagged, and so are campaigns that spent money but got no results.
- 4Read the table from most expensive to cheapest cost per result, then check the 'Above threshold' column and the TOTAL row at the bottom.
Common questions
What file do I need and which columns must it have?
A CSV exported from Meta Ads Manager with the campaign report broken down by day. It needs Campaign name, Day, Impressions, Amount spent (USD), Link clicks, CTR (link click-through rate), Results and Result indicator.
What if a column in my export is named differently?
Meta sometimes renames columns or adds the currency to the name, for example Amount spent (EUR). Rename the column in your spreadsheet to match the names listed above before uploading. Also check that spend is in USD so cost per result compares correctly with your limit.
How is a campaign flagged, and what is the default limit?
A campaign is flagged when its total spend divided by its total results is above your maximum cost per result. The default is 40, and you can change it. Campaigns that spent money but got zero results are flagged too.
Is my data kept private, and what does it cost?
Your file is used only to build your report and is not shared. Each run of this tool costs 2 credits.