The smarter way to connect Facebook Ads data into BigQuery



Stop wasting hours on CSV exports or writing custom scripts. With Supermetrics, you can automatically move your Facebook Ads data into BigQuery and build scalable, analysis-ready datasets — in minutes not hours.



Get started now

✓ Automate reporting

✓ Analyze performance

✓ Optimize campaigns

Trusted by 200,000+ companies in 120 countries

Get Google Analytics data to into Looker Studio in 4 simple steps

  • Step 1 - Connect to a data source (e.g. Facebook Ads)
  • Step 2 - Connect to BigQuery
  • Step 3 - Create a transfer
  • Step 4 - Automate your report

Automate your Facebook Ads to BigQuery

Join 200,000+ marketers who’ve already saved hours every week with Supermetrics.

Get started

What data can you send from Facebook Ads data to BigQuery

With the Supermetrics connector, you can bring all the key Facebook Ads data fields into BigQuery, including:

  • Campaign performance: Spend, impressions, reach, clicks, CTR, CPC, CPM, conversions
  • Audience insights: Age, gender, location, device, placement, publisher platform
  • Creative data: Headlines, ad text, visuals, CTAs, engagement metrics
  • Conversion events: Purchases, leads, registrations, add-to-cart, and custom events
  • Lead form data: IDs, contact details, timestamps, and custom fields

This gives you everything you need to build dashboards that track ROI, analyze audiences, optimize creatives, and monitor results in real time.

Get started now

No credit card needed

No credit card needed


Templates to help you get started in as quick as 5 minutes

Why build from scratch? Our ready-to-use templates give you instant insights into your performance, saving hours of dashboard creation.

Ad report template for Looker Studio

Track your paid advertising campaigns with our comprehensive template. Connect it to your data storage—either BigQuery or Supermetrics Storage—to pull in data from your paid media sources, providing a central access point to analyze key metrics like cost, clicks, and conversions in Looker Studio.

Get the template

Facebook & Instagram (Meta) Ads report template for Looker Studio

Optimize your campaigns with data-driven insights using this powerful Facebook & Instagram Ads template or go beyond and also analyze your WhatsApp and Messenger Ads data.

Get the template

See all Facebook Ads reporting templates


Easily track your Facebook Ads performance with reporting templates powered by Supermetrics connectors. Monitor traffic, engagement, and audience insights - all in one place.

See all templates

The fastest, most reliable way to move your marketing data


Fastest refreshes

Hourly updates so you catch issues instantly.

No data sampling

Get 100% of your data with no limits or missing fields.

Secure & compliant

SOC 2 Type II, SSO and regional hosting keep every record secure.

Custom fit

Composable building blocks fit any organization and scale with growth.

Expert support

24/5 support across time zones when you need it.

Request demo

No credit card needed

No credit card needed


“Supermetrics has brought the marketing team, data team, and analytics team closer together and it’s been the core backbone of how to get our data infrastructure in place.”

Nidhi Parikh
Nidhi Parikh
Marketing Effectiveness Manager - Europe, APAC & LATAM at Electrolux

“I'd say we save easily over 100 hours every month by using Supermetrics. The leadership team sees the value of the product as we can now get reports on their desk every Monday with more KPIs and quicker than before.”

Mickaël Zollet
Mickaël Zollet
Head of Marketing Operations at Le Figaro

“With the adoption of Supermetrics, the team now has the freedom to interact directly with the data, breaking away from the limitations of black box analytics. This empowers them to explore and manage their reports themselves.”

Pascal Coulier
Pascal Coulier
Ecommerce & Omnichannel Marketing at HP

Faster insights, less manual work


Transform the way you report on Facebook Ads with real-time BigQuery dashboards powered by Supermetrics.


Get started