# Facebook Ads Report: Spend, Results and ROAS by Campaign

- URL: https://betteranalyst.com/data-connectors/meta-ads/facebook-ads-report
- Published: 2026-11-16
- Updated: 2026-11-16
- Author: David Bressler, Founder (https://betteranalyst.com/authors/david-bressler)

> **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.

Data source: [Meta Ads](https://betteranalyst.com/data-connectors/meta-ads)

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.

## 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*

| 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

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)*

| 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

- [Meta Ads connector](https://betteranalyst.com/data-connectors/meta-ads)
- [Meta Ads connector setup docs](https://betteranalyst.com/docs/connectors/meta-ads)
- [Meta Ads reporting](https://betteranalyst.com/solutions/meta-ads-reporting)
- [CPM formula](https://betteranalyst.com/metrics/cpm)
- [Web dashboards](https://betteranalyst.com/product/dashboards)

[Try Better Analyst free](https://betteranalyst.com/signup)

## 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.

## Related reports

- [Meta Ads ROAS by Campaign, Audience and Placement](https://betteranalyst.com/data-connectors/meta-ads/roas-report)
- [Google Ads Report Template: Metrics, Layout and Example](https://betteranalyst.com/data-connectors/google-ads/report-template)
- [Ad Spend Pacing Report in Google Sheets: Budget vs Spend](https://betteranalyst.com/data-connectors/google-sheets/ad-spend-pacing-report)
