Export Facebook Ads to BigQuery
Your Facebook and Instagram ad results in a BigQuery table in your own project.
- Loaded on your schedule.
- Partitioned by
date, published in one step. - Ready-made reports, or your own fields.
Start your free 30-day trial No credit card required
New pipeline
Export data from
- Facebook Ads

- Facebook Lead Ads

- Google Ads

- Google Analytics 4

- Google BigQuery

- Google Sheets

- RTB House

- TikTok Ads

To
- Google BigQuery

- Google Sheets

Set it up once
- Connect Facebook. Pipelinica asks to read your ads and your e-mail address.
- Pick the ad account and a ready-made report, or tick your own fields.
- Pick the project, dataset, table name and schedule. The Google account needs BigQuery Data Editor and Job User.
What you get in Google BigQuery
- A table in your own project, partitioned by
date. - Each run is staged, then published in one step, so queries never see half a load.
- New fields add columns; nothing you have is removed.
- Every run reloads at least the last 30 days, so results that arrive late still count.
What you can export from Facebook Ads
Report types: Ads, Ad sets, Campaigns, Account.
Ready-made reports
- Basic Metrics + All actions
- Basic Metrics + All actions (+IDs)
- Basic Metrics + All actions divided by Gender and Age
- Basic Metrics + All actions divided by Country
- Basic Metrics + All actions divided by Platform and Placement
- Video
See all 37 Facebook Ads fields
Dimensions
- Date
- Account ID
- Account name
- Account currency
- Objective
- Campaign ID
- Campaign name
- Ad set ID
- Ad set name
- Ad ID
- Ad name
- Age
- Gender
- Country
- Region
- Device platform
- Platform
- Placement
- Impression device
Metrics
- Impressions
- Clicks (all)
- Link clicks
- Amount spent
- Reach
- Frequency
- Outbound clicks
- Video plays
- Video plays at 25%
- Video plays at 50%
- Video plays at 75%
- Video plays at 95%
- Video plays at 100%
- ThruPlays
- 30-second video plays
- Video average play time
- Actions (a column per action type)
- Action values (a column per action type)
Ratios
Not exported, as rows can't add them up: the setup shows the formula for each.
- CTR (all), %
- CPC (all)
- CPM (cost per 1,000 impressions)
- CTR (link click-through rate), %
- CPC (cost per link click)
- Outbound CTR (click-through rate), %
- Cost per outbound click
- Cost per ThruPlay
- Cost per lead
- Cost per purchase
- Purchase ROAS (return on ad spend)
Questions
Does it include Instagram ads?
Yes. Facebook Ads covers every ad you run in Meta Ads Manager. Add the Platform breakdown to split the results into Facebook, Instagram, Messenger, Audience Network and Threads.
Do I need my own Facebook app or access token?
No. You sign in with Facebook during the setup, and Pipelinica keeps the connection.
Can several accounts go into one table?
Each pipeline loads one Facebook Ads account into its own table, and two pipelines can't share a table. To query accounts together, put a view with UNION ALL over their tables.
What are the column names and types?
Names are made safe for BigQuery, so purchase.actions becomes purchase_actions. Counts arrive as INT64, decimals such as spend as FLOAT64, the day as DATE, names and IDs as STRING.
Do I need a credit card for the trial?
No. You choose a plan when the trial ends.
More exports: Export Facebook Ads to Google Sheets · All connectors
What is the difference between different plans?
Our plans best suit businesses and agencies that want to improve their reporting automation.
-
Starter
$2 / month
- Up to 1 active pipeline
- Up to 7 days of backfill
- Refresh data once a day
- Refresh data every 6 hours
- Manual data refresh
-
Basic
$9 / month
- Up to 5 active pipelines
- Up to 31 days of backfill
- Refresh data once a day
- Refresh data every 6 hours
- Manual data refresh
-
Pro
$49 / month
- Up to 30 active pipelines
- Up to 365 days of backfill
- Refresh data once a day
- Refresh data every 6 hours
- Manual data refresh
-
Premium
$99 / month
- Up to 90 active pipelines
- Up to 3 years of backfill
- Refresh data once a day
- Refresh data every 6 hours
- Manual data refresh