Facebook Ads Report: Spend, Results and ROAS by Campaign
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
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
| Metric | Source field | Why it matters |
|---|---|---|
| Campaign | campaign_name | The level most reports start from, and the place where budget is usually set. |
| Amount spent | spend | Total spend in the ad account's currency. |
| Reach | reach | How many people saw the ads at least once. |
| Frequency | frequency | Average impressions per person, an early sign of audience fatigue. |
| Clicks | clicks | The traffic bought, and the base for cost per click and click-through rate. |
| CTR | ctr | How well the creative earns attention, compared across campaigns. |
| Purchases | actions.purchase | Conversions come back as one column per action type, so purchases have their own column. |
| Purchase ROAS | purchase_roas.omni_purchase | Return on ad spend as Meta reports it for purchases. |
How to build it in Better Analyst from Meta Ads
- Open Connectors in Better Analyst and choose Meta Ads.
- Click Continue with Facebook, then choose the businesses and ad accounts to share and confirm the permissions.
- Select the ad accounts you want to analyze and click Save.
- Attach an account to a chat and ask for spend, reach, clicks, purchases and ROAS by campaign for last month.
- 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.
| Campaign | Spend | Reach | Frequency | CTR | Purchases | ROAS |
|---|---|---|---|---|---|---|
| Prospecting - Broad | $8,420 | 412,000 | 1.9 | 1.2% | 164 | 2.4 |
| Retargeting - 30 days | $2,180 | 48,300 | 5.6 | 2.1% | 121 | 5.8 |
| Catalog - Advantage+ | $5,640 | 226,000 | 2.4 | 1.6% | 173 | 3.7 |
| Creative test - UGC | $1,250 | 91,500 | 1.3 | 1.8% | 22 | 1.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
Frequently asked questions
Does this include Instagram ads?
Can Better Analyst change my campaigns?
Why don't my numbers match Ads Manager?
How long does the connection last?
Related reports
Meta Ads ROAS by Campaign, Audience and Placement
Build a Meta Ads ROAS report by campaign, age, gender, country and placement, with purchases and conversion value, and see why it differs from Google Ads.
Google Ads Report Template: Metrics, Layout and Example
A Google Ads report template for clients or your team: which metrics to include, a sample table and charts, and how to build it from your live account.
Ad Spend Pacing Report in Google Sheets: Budget vs Spend
Track ad spend pacing from Google Sheets: spend to date vs prorated monthly budget by platform and campaign, projected month-end spend, and pacing alerts.