Facebook Ads Report: Spend, Results and ROAS by Campaign

Build a Facebook ads report from your Meta ad accounts: spend, reach, clicks, purchases and ROAS by campaign, with a sample table and suggested charts.

Summary

A Facebook ads report shows spend, reach, clicks, conversions and ROAS by campaign, ad set or ad, for Facebook and Instagram together. Connect your Meta ad accounts to Better Analyst and ask for it in plain English. Access is read-only, and each answer comes from the Insights API using Meta's default attribution settings.

On this page
  1. Who this report is for
  2. What the report includes
  3. How to build it in Better Analyst from Meta Ads
  4. Questions to ask
  5. Sample output
  6. Charts to use
  7. Keep it up to date
  8. Further reading
  9. FAQ

Who this report is for

Agency account managers and in-house marketers who report on Meta results each week or month and want to stop exporting from Ads Manager and rebuilding the same spreadsheet.

What the report includes

Metrics and dimensions in this report
MetricSource fieldWhy it matters
Campaigncampaign_nameThe level most reports start from, and the place where budget is usually set.
Amount spentspendTotal spend in the ad account's currency.
ReachreachHow many people saw the ads at least once.
FrequencyfrequencyAverage impressions per person, an early sign of audience fatigue.
ClicksclicksThe traffic bought, and the base for cost per click and click-through rate.
CTRctrHow well the creative earns attention, compared across campaigns.
Purchasesactions.purchaseConversions come back as one column per action type, so purchases have their own column.
Purchase ROASpurchase_roas.omni_purchaseReturn on ad spend as Meta reports it for purchases.

How to build it in Better Analyst from Meta Ads

  1. Open Connectors in Better Analyst and choose Meta Ads.
  2. Click Continue with Facebook, then choose the businesses and ad accounts to share and confirm the permissions.
  3. Select the ad accounts you want to analyze and click Save.
  4. Attach an account to a chat and ask for spend, reach, clicks, purchases and ROAS by campaign for last month.
  5. Ask for a daily series of the same report, then turn it into a dashboard that refreshes on a schedule.

Questions to ask

  • “How much did we spend on Meta ads last month, by campaign, with purchases and ROAS?”
  • “Show daily spend and purchases for the last 30 days.”
  • “Which ad sets have the highest frequency and falling CTR this month?”
  • “Compare this month with last month by campaign.”
  • “Which ads drive the most leads, and what does each lead cost?”

Sample output

Sample data for illustration, not real account data.

Sample data: Meta Ads results by campaign for one month (illustrative, not a real ad account)
CampaignSpendReachFrequencyCTRPurchasesROAS
Prospecting - Broad$8,420412,0001.91.2%1642.4
Retargeting - 30 days$2,18048,3005.62.1%1215.8
Catalog - Advantage+$5,640226,0002.41.6%1733.7
Creative test - UGC$1,25091,5001.31.8%221.9

Charts to use

  • Spend and ROAS by campaign (Combo chart): Where the money goes and what each campaign returns, on one view.
  • Daily spend and purchases (Line chart): How results move with spend, without labels crowding the lines.
  • Frequency by ad set (Horizontal bar chart): Which audiences are seeing the same ads most often.

Keep it up to date

A dashboard refreshes on its schedule, and rolling ranges such as the last 30 days move forward in the ad account's time zone. A Data Flow can deliver the report to Google Sheets or a database, and an alert can watch daily spend.

Further reading

Try Better Analyst free

Frequently asked questions

Does this include Instagram ads?
Yes. Anything run through Meta Ads Manager is included: Facebook, Instagram, Messenger and Audience Network placements. Ask for a placement breakdown to separate them.
Can Better Analyst change my campaigns?
No. It only reads Insights reports and the list of ad accounts you share, and it can't create, edit, pause or delete anything.
Why don't my numbers match Ads Manager?
Check the date range, the time zone and the attribution setting first. Better Analyst uses Meta's default attribution settings and the ad account's time zone, while an Ads Manager view may be set differently.
How long does the connection last?
Meta sign-ins last about 60 days and renew while you keep using the connector. If one expires, scheduled refreshes pause with a notice until you continue with Facebook again.