Blog/Meta Ads

Facebook Ads Report Template: Campaigns, Creative and Results

Download a Facebook Ads report template with a campaign CSV, printable example, attribution notes and a decision log for your weekly Meta review.

Meta Ads
Jasper Shine
Jasper Shine
·
7 min read
·
November 16, 2026

A Facebook Ads report should show what you spent, which result you paid for and what needs attention next. It should also preserve the attribution setting, reporting period and account currency, so the next person can reproduce the numbers.

Use the campaign input CSV and printable report example below. The CSV contains blank input fields. The HTML example contains clearly labeled synthetic data and an editable decision log. Neither file connects to an account or changes an ad.

To use the printable example, download the HTML file and open it in your browser. Edit the highlighted fields, then print it or save a PDF. Edits stay in that open page; the file does not save them automatically.

What to include in a Facebook Ads report

Use a short summary followed by the campaign detail needed to support it. Facebook and Instagram delivery can appear in the same Meta ad account. State whether the report covers the whole account or only Facebook placements; the title alone doesn't define the scope.

Report sectionIncludeThe decision it supports
ScopeAccount, dates, currency, time zone and placement filterWhether the comparison is valid
PerformanceSpend, selected result, cost per result and prior periodWhether performance meets the objective
Campaign detailCampaign IDs, objectives and result definitionsWhere the change occurred
Creative reviewAd IDs, spend, outcomes and relevant engagement metricsWhich concepts need investigation
Measurement notesAttribution settings, refresh time and missing fieldsHow much confidence to place in the result
Decision logProposed action, evidence, owner and review dateWhat happens after the report

Select the outcome for the campaign before filling the result column. Purchases, leads, landing page views and messaging conversations describe different actions. Don't create an account-level cost per result by mixing all four.

Meta's current ad set reference distinguishes objectives, destinations and optimization goals, including landing page views and link clicks. Retain that distinction when comparing traffic campaigns with sales or lead campaigns. Meta's ad set reference.

Fill the campaign template

Import the CSV into a new Google Sheet or Excel workbook. Keep one row per campaign and reporting period, using campaign IDs as the stable key. Add the campaign name for readability. A renamed campaign should still match the same ID in the previous period.

The downloadable input includes these reporting columns:

ColumnWhat to enter
Period start and Period endInclusive dates used in the source export
Account ID and Campaign IDIdentifiers from Meta
Currency and Time zoneAccount settings
Objective and Result typeThe campaign objective and exact outcome being evaluated
Amount spentSpend for this campaign and period
Impressions and Link clicksMatching source metrics, without mixing click definitions
Landing page viewsThe exported value when available
Results and Purchase conversion valueOutcome count and relevant purchase value
Attribution settingThe setting used for the result metrics
Retrieved at and SourceExport timestamp and location of the source evidence

Keep unavailable values blank and explain why in the notes. A blank purchase value for a lead campaign is appropriate. Entering zero would suggest that purchase value was measured and none occurred.

Use the same campaign scope for the previous period. If a campaign launched midway through the week, mention the shorter delivery period. If the report excludes paused campaigns, say so; excluding a campaign that spent earlier in the period can understate total spend.

The printable HTML file is a worked example. Its editable fields let you replace the scope, summary, campaign rows and decision log before printing. Browser edits aren't persistent: print or save your finished copy before closing the page.

Calculate account metrics from totals

Calculate a rate from the totals that define it. Don't average campaign rates when the campaign volumes differ.

MetricCalculationRequired check
CPMAmount spent / impressions x 1,000Impressions must be greater than zero
Link CTRLink clicks / impressions x 100Label this as link CTR
Cost per link clickAmount spent / link clicksUse link clicks, not all clicks
Cost per resultAmount spent / selected resultsAll rows must use the same result definition
Purchase ROASPurchase conversion value / amount spentValue and spend must share a currency and scope

Match each template column to the corresponding field in your Meta export before calculating rates. If a denominator is zero, leave the calculated metric unavailable instead of returning zero.

For example, the synthetic report has two purchase campaigns. Campaign A spends 600 USD for 12 purchases and 1,200 USD in purchase value. Campaign B spends 400 USD for 4 purchases and 600 USD in value. Combined spend is 1,000 USD, purchases are 16, cost per purchase is 62.50 USD and purchase ROAS is 1.8.

Averaging campaign cost per purchase would produce 75 USD, which is wrong for the combined account. The correct calculation uses 1,000 divided by 16.

Treat purchase ROAS as a reported advertising metric. Check whether reported purchase value reflects refunds, then account for product costs, agency fees and other expenses when assessing profit. Use the business's actual margin and order records.

Add a creative and placement review

Keep creative detail focused on the question the buyer can act on. For each ad under review, record its ID, concept, format, spend, selected result and cost per result. Add a preview link or approved thumbnail if the report's audience has permission to view it.

Compare ads serving a similar objective and conversion definition. A video optimized for engagement and an ad optimized for purchases aren't a clean creative test. Budget allocation, audience, delivery dates and placement can also differ.

Use a separate placement view when you need to understand Facebook versus Instagram delivery. Don't stack campaign totals and placement totals into one sum. They describe overlapping activity at different levels.

Meta documents restrictions on Insights breakdowns and off-Meta action metrics. A missing breakdown result can reflect an unsupported combination, rather than zero performance. Keep the unsegmented total and note what the breakdown cannot show. Meta's Insights breakdown guidance.

For recurring performance questions, the Meta Ads MCP guide covers connected account analysis. Our Meta ROAS diagnosis guide provides a separate investigation structure when the report flags a decline.

Check attribution and data quality

Preserve the attribution window and reporting-time settings with each export. Meta's Insights reference exposes these as separate parameters; changing either can change the reported outcomes for the same apparent date range. Meta's Ads Insights reference.

Avoid adding together results from separate attribution-window views. Those views can overlap. If you show multiple windows, place them side by side with explicit labels.

Reach needs its own treatment too. The same person may appear in several campaign audiences or on several days. Use the source's reach value for the requested scope instead of summing daily or campaign reach and calling the result unique people. Frequency should use the matching scope.

Before sharing, compare report spend with Ads Manager using the same account, dates and filters. Check the largest campaign and one smaller campaign manually. Confirm that an empty import hasn't replaced a populated period and that the CSV didn't convert an identifier into scientific notation.

The final summary should separate a finding from a suspected explanation. "Cost per purchase was 62.50 USD for November 2 to 8" is a measurable statement in this synthetic example. "The creative is exhausted" requires more evidence than this result alone. Record the next check in the decision log.

How Hyper helps

Hyper combines customizable marketing agents with connected accounts, research, creative production and analytics. Its Meta Ads integration documents campaign and ad performance reads, and its Google Sheets integration supports reading and updating report ranges.

Give the agent the template, account ID, date range and result definition. Ask it to reconcile spend, prepare the summary and identify the evidence behind each proposed action. Ask for a report draft and review it against Ads Manager. If the findings call for new creative or supported campaign changes, scope that work separately.

For teams reporting across several channels, our agency reporting tools guide covers the broader reporting setup.

Autonomous marketing

Grow your business faster with AI agents

  • Automates Google, Meta + 5 more platforms
  • Handles your SEO end to end
  • Improves website conversions
  • Runs social media for you

Frequently asked questions

Q: Does this Facebook Ads report include Instagram?

It can. State whether your export covers the entire Meta ad account or a Facebook-only placement filter. Use a separate placement breakdown when you need to show Facebook and Instagram independently.

Q: Can I use the CSV in Google Sheets or Excel?

Yes. Import it into a new sheet and preserve account and campaign IDs as text. The CSV contains input columns. Apply the calculations in this article after importing your account data.

Q: Why does the report differ from Ads Manager?

Check dates, time zone, campaign filters, result definition, attribution settings, reporting time and extraction time. Compare an unsegmented account total before investigating breakdown differences.

Q: Are the example CPA and ROAS numbers benchmarks?

No. They are synthetic arithmetic examples that explain the template. They are not Hyper customer results, expected performance or recommended targets.

AI Agents for Marketing Magic