Datapipe
Paid media managers
Check spend and return by campaign every morning.
Read & reportRead-only source
See your Facebook Ads numbers in Claude.
Read campaign and ad results from one authorized Meta ad account, with explicit currency, timezone and attribution rules.
- Spend, purchases and ROAS by campaign in one sheet
- Find the campaigns that cost more than they return
- Facebook and Instagram ads in the same project as your store and site
ClaudeStart free Connect Facebook Ads
Updated November 2026
| Campaign | Spend | Clicks |
|---|---|---|
| Spring sale | $80.00 | 860 |
| Retargeting | $125.50 | 410 |
| Brand search | $42.00 | 155 |
- SetupSign in, no key to copy
- Reads22 metrics and 22 ways to split them
- ChangesNone, read-only
- RefreshDaily to every 15 minutes
Who uses Datapipe with Facebook Ads
Ecommerce owners
See which ads actually bring orders.
Agencies
Send each client a clear ad report every month, without exporting.
What you can do with Facebook Ads
Read and report
Read account, campaign, ad-set and ad insights through the implemented reporting adapter.
- Impressions
- Reach
- Spend
- Click rate
- and 6 more
Read-only source
Datapipe reads Facebook Ads data for reports. It never changes anything in Facebook Ads.
Full read details
Keep spend, conversions, native action arrays and supported breakdowns attached to the selected account and reporting dates. Reach and unique counts are not additive. Public availability is enabled separately from Meta App Review; actual token permissions and provider account roles still apply. This reporting source enables no campaign changes.
Examples for your team
Prepare a paid-social performance review
Keep impressions, clicks and spend beside the selected account currency and reporting dates.
- Scheduled refresh
- Latest Facebook Ads data
- Updated report
Limit: Compare Facebook and Instagram delivery using supported breakdowns without treating unique reach as an additive total.
Explain conversion attribution
Review the supported purchase action types and values with the selected attribution settings.
- Scheduled refresh
- Latest Facebook Ads data
- Updated report
Limit: Preserve missing conversion values instead of substituting zero or combining overlapping purchase categories.
Before you connect
What you need
Sign in with Facebook.
Read-only
Read access only. Datapipe never changes anything in Facebook Ads.
Limits and exclusions
Reach is not additive; account currency, timezone and attribution settings remain explicit. Public availability is enabled separately from Meta App Review; actual token permissions and provider account roles still apply.
Full details and limits
Meta permissions, account access and review status apply to every read. Connect Facebook and select each ad account explicitly. Reach is not additive; account currency, timezone and attribution settings remain explicit.
Metrics and dimensions
22 metrics and 22 ways to split them.
Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.
No fields match. Try another search or choose All.
Send Facebook Ads data anywhere
Google SheetsA sheet that refreshes every morning.
Data StudioCharts that read the same numbers.
BigQueryA warehouse table for the same columns.
Excel / CSVA Drive file you can open in Excel.ClaudeAsk Claude about these numbers in a sentence.
ChatGPTAsk ChatGPT about these numbers in a sentence.
APIRead the same rows from your own tool.Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.Ask AI about your data
Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.
Which ad campaigns in Facebook Ads exceeded their daily target spend with ROAS below threshold?
Two retargeting ad sets spent $1,420 with a 0.82x ROAS, flagged for immediate bid reduction or pause.
Better than exporting by hand
- It refreshes on its own, so nobody pastes in a new export.
- Each campaign can be its own row.
- Spend sits next to results, so a costly campaign is obvious.
- The same numbers can be split by who they came from.
- You can keep a row per day instead of one lump sum.
- See whether it ran on a phone, a feed, or another placement.
What can you do with this data?
Explore all use cases →Start from a goal
Ads ROAS by campaign
Spend, purchases, and return for each campaign.
Use this template →Meta Ads dashboard
Five-page Data Studio dashboard with daily ad and placement data, purchases, ROAS and video creative performance.
Use this template →Meta ad performance
Facebook and Instagram ad performance by account, campaign, ad set, or ad.
Use this template →Meta ads sample
Sample Facebook and Instagram ads.
Use this template →How it works
Sign in with Facebook.
Pick where it goes. This one sends the numbers to Claude.
You're done. It refreshes every day.
Sample report
Sample range Oct 1–Oct 29. Each row is one campaign.
| Campaign | Spend | Clicks | Impressions | Purchases | Purchase value | CPA | ROAS |
|---|---|---|---|---|---|---|---|
| Spring sale | $80.00 | 860 | 12,480 | 18 | $420.00 | $4.44 | 5.3 |
| Retargeting | $125.50 | 410 | 8,240 | 32 | $980.00 | $3.92 | 7.8 |
| Brand search | $42.00 | 155 | 3,110 | 6 | $160.00 | $7.00 | 3.8 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Available now. Connect Facebook and select an ad account. Meta permissions, account access and review status still apply.
Works well with Facebook Ads
Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.
Facebook Ads + Shopify“Is ad spend rising faster than orders?”See Shopify →
Facebook Ads + Google Analytics“Do ad clicks show up as site visits?”See Google Analytics →
Facebook Ads + HubSpot“Did the new campaign bring more deals?”See HubSpot →
Facebook Ads + Stripe“How does ad spend compare with the revenue you collected?”See Stripe →Questions
Free to start. Paid plans add more data sources and refresh faster.
Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.
No. Name a project, add a data source, then choose a report and destination.
OAuth means you sign in with the service and grant access, without pasting an API key. Datapipe works with multiple partners to provide that sign-in. Some partners already provide it. Some integrations are API-only at present, so you paste a key or token. OAuth is coming soon for some. Some partners do not provide OAuth at all. The setup steps on each integration page say how that source connects. Signing in is only how the connection is made. It is not permission to change records. Where a source supports changes, those writes stay off until the workspace owner turns specific actions on and approves each one. We do not promise OAuth on every source, and we do not share dates.
This integration is read-only in Datapipe. You can report on Facebook Ads, send the reports to your destinations and ask an AI assistant about them. Datapipe never changes anything in Facebook Ads.
This page lists 22 metrics and 22 ways to split them. You pick the columns when you build the report.
Available rows depend on the connected account, selected report type, its date rules and provider limits. Current-inventory reports show current records rather than earlier historical states.
The report uses the window already set on the ad account. Changing it there changes the next refresh.
One for each Facebook Ads account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.
Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.
Try Facebook Ads with sample data first
Build the report first, then add Facebook Ads when you are ready.