How-to guides

How to get ad data into BigQuery and other destinations

Step-by-step help for sending Facebook Ads data to BigQuery by Google's transfer, a connector or a script, and for checking the first load.

Land a first table in BigQuery in a safe order and know what to check afterward.

2 practical guides

Choose the question closest to yours.

New to the topic? Begin with the first guide. Otherwise, go straight to the question you need to answer.

Start here · Practical guide

How to connect Facebook Ads to BigQuery: Google's transfer, a connector or a script

Read the guide →

Guide preview

How to connect Facebook Ads to BigQuery three ways: Google's transfer, a no-code connector or a script, with the limits and first-load checks for each.

Bottom line: There are three routes: Google's BigQuery Data Transfer Service for Facebook Ads, a no-code connector such as Windsor.ai, or a script on the Marketing API. Pick by refresh needs, number of ad accounts and who keeps the access tokens alive.

Practical guide

What is Windsor.ai: a no-code data connector for ad, analytics and CRM data

Read the guide →

Guide preview

What Windsor.ai is, how it moves ad and analytics data into Looker Studio, Sheets and BigQuery, which terms its plans use and when to skip it.

Bottom line: Windsor.ai is a data integration service that collects data from ad, analytics, CRM and e-commerce platforms and delivers it to spreadsheets, reporting tools, warehouses or AI assistants. It moves data; the charts are built in the destination.