Datapipe
Ad insights
A Facebook Ads report of ad insights.
Coming soon
Facebook Ads for agencies and in-house teams
Paid social teams use Facebook Ads in Datapipe to see reach, spend, and purchases by campaign once Meta approves the app.
This page is not indexed yet. It does not have a reviewed integration record.
Connection
Coming soon
Coming soon. Meta app review is required before ad insights can be read.
Fields
Standard fields on the Marketing API insights edge. Breakdowns and action breakdowns that an ad account has not enabled are not listed. This connector still needs Meta app review before it can run live. Source: https://developers.facebook.com/docs/marketing-api/insights. Read on 2026-10-27. 26 fields.
Synced today
- Date
date_start - Campaign
campaign_name - Objective
objective - Impressions
impressions - Reach
reach - Clicks
clicks - Spend
spend - Purchases
purchases
Advertising
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Impressions · Synced today | impressions | Times the ads were shown. | metric · integer | Advertising | Impressions |
| Reach · Synced today | reach | People who saw the ads. | metric · integer | Advertising | |
| Clicks · Synced today | clicks | All clicks. | metric · integer | Advertising | Clicks |
| Unique clicks | unique_clicks | People who clicked. | metric · integer | Advertising | |
| CTR | ctr | Clicks divided by impressions. | metric · percent | Advertising | |
| CPC | cpc | Cost per click. | metric · number | Advertising | |
| CPM | cpm | Cost per 1,000 impressions. | metric · number | Advertising | |
| Spend · Synced today | spend | Amount spent. | metric · number | Advertising | Spend |
| Link clicks | inline_link_clicks | Clicks on links in the ad. | metric · integer | Advertising |
Dimensions
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Account id | account_id | The ad account id. | dimension · string | Dimensions | |
| Account | account_name | The ad account name. | dimension · string | Dimensions | |
| Ad set id | adset_id | The ad set id. | dimension · string | Dimensions | |
| Ad set | adset_name | The ad set name. | dimension · string | Dimensions | |
| Ad id | ad_id | The ad id. | dimension · string | Dimensions | |
| Ad | ad_name | The ad name. | dimension · string | Dimensions | |
| Objective · Synced today | objective | The campaign objective. | dimension · string | Dimensions | |
| Buying type | buying_type | Auction or reservation. | dimension · string | Dimensions |
Ecommerce
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Purchase ROAS | purchase_roas | Purchase return on ad spend. | metric · number | Ecommerce |
Metrics
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Frequency | frequency | Average times each person saw the ads. | metric · number | Metrics | |
| Actions | actions | Actions such as purchases, grouped by action type. | metric · integer | Metrics | |
| Action values | action_values | Value of those actions. | metric · number | Metrics |
Technology
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Cost per action | cost_per_action_type | Cost for each action type. | metric · number | Technology |
Time
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Date start · Synced today | date_start | The first day in the result row. | dimension · date | Time | |
| Date stop | date_stop | The last day in the result row. | dimension · date | Time |
Traffic
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Campaign id | campaign_id | The campaign id. | dimension · string | Traffic | |
| Campaign · Synced today | campaign_name | The campaign name. | dimension · string | Traffic |
Cross-channel metrics
Spend, Impressions, Clicks, Conversions, and Revenue roll up on All channels when a field maps to them. ROAS is revenue divided by spend. CPA is spend divided by conversions. The Cross-channel column above shows the match.
Example reports
Destinations
Facebook Ads to Google Sheets
A sheet you can open, share, and refresh.
Included on every plan.
Facebook Ads to Looker Studio
Charts that read the Google Sheet this integration keeps up to date.
Included on every plan. Looker reads the sheet. There is no separate Looker install.
Facebook Ads to BigQuery
A warehouse table for the same columns.
Pro and Agency plans.
Facebook Ads to AI and MCP
Ask a question in plain English, or let another tool read the report through MCP.
Included on every plan. An AI key is optional.
Facebook Ads to the API
Download the rows as CSV or JSON from the report.
Included on every plan.
Facebook Ads to Google Drive
CSV, Excel, and an optional JSON file in a Drive folder you pick. Each client gets a Datapipe folder. The file can overwrite itself or keep the date in the name.
Included on every plan. Drive API v3 with the drive.file scope only. Enable the Google Drive API in the GCP project. Hourly, daily, or weekly.
How to connect
- Create a free account.
- Open Connections. This source is marked Coming soon.
- You can still build a sample report so the destination and the schedule are ready.
- The owner turns the live connection on after the platform approves the app.
Refresh by plan
| Plan | Refresh | BigQuery | Price |
|---|---|---|---|
| Free | Daily | No | $0/mo |
| Starter | Daily | No | $15/mo |
| Pro | Hourly | Yes | $49/mo |
| Agency | 15 minutes | Yes | $149/mo |
FAQ
Is the Facebook Ads connection live?
Coming soon. Meta app review is required before ad insights can be read.
Do I have to talk to sales?
No. Create an account, connect the source, and the first report is on Home. Sample numbers stay available when a key is missing.
How often do the numbers refresh?
Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts and hourly on the rest. We keep the history for you: 90 days on Free, and for as long as you subscribe on paid plans. No warehouse to set up.
Which fields are synced today?
The list marks Synced today on the fields the current connector pulls. The rest of the list is what the platform publishes, so you can see it before you sign up.