Integration of Google Ads with BigQuery



📢 Introduction

This module connects directly to the Google Ads API, continuously pulling campaign‑level, click‑level and shopping‑level metrics into Google Cloud BigQuery. Centralising your data in BigQuery lets you join it with web analytics, CRM or finance data and build truly end‑to‑end performance reporting.


📝 Configuration Guide

Follow the steps below to connect Google Ads with BigQuery. Once the setup is finished, your ad data will start flowing into your BigQuery project automatically.

💡 Tip: Make sure the Google account you authorise has admin access (or at least “standard” with API access enabled) in the Google Ads account you want to export.

🔧 Module Setup

In the WitCloud sidebar, open Collect → click Create data collect.





From the list of integrations choose Google Ads.





Give the collect a descriptive name, e.g. "Google Ads Collect".





🔑 Authorization

💡 Tip: If you have already created a Google Ads token and it still has the correct scopes, simply pick it from the drop‑down and skip this step.

Click Authorize.





In the Google consent window:

  • Select the Google account you want to use.
  • Click Continue.
  • Grant the permission “See, edit, create and delete your Google Ads accounts and data.”
  • Click Allow.





Back in WitCloud, choose the Google Ads account (CID) you wish to export.




⏳ Historical Data & Scheduling

Select the date range for which you want to fetch historical data.




During the initial setup, you can retrieve data going back up to 12 months, with the possibility of importing older data.


A data synchronization schedule will be created automatically. More information on this topic can be found here.


Click Create to complete the configuration.


Done! Your Google Ads data will now be mirrored to BigQuery, keeping campaign performance, shopping feeds and label data up‑to‑date without manual exports.


📊 Data Schema

Expand the tables below to view (or later fill in) the full data schema collected from Google Ads.


🔎 Click to view the data schema for the gads_campaign_conversion_stats table
🔎 Click to view the data schema for the gads_campaign_stats table
🔎 Click to view the data schema for the gads_click_stats table
🔎 Click to view the data schema for the gads_criteria_basic_stats table
🔎 Click to view the data schema for the gads_labels table
🔎 Click to view the data schema for the gads_shopping_stats table