Integration of Google Ads with BigQuery

Learn how to connect Google Ads to Google BigQuery using WitCloud and automatically fetch campaign, click, cost, shopping and conversion data.

Updated

Introduction

This module integrates with the Google Ads API, enabling you to collect campaign, click, criteria, shopping, conversion and label data and store it in Google Cloud BigQuery. Having it in BigQuery lets you join Google Ads data with web analytics, CRM or finance data for end-to-end performance reporting.

Configuration guide

Follow the steps below to connect Google Ads with BigQuery. Once the setup is complete, your data will be automatically transferred to your BigQuery project.

Authorize with a Google account that has access to the Google Ads accounts you want to export. Only the accounts that account can reach are offered in the account list.

Module setup

Go to the Integrations section in the menu > Click Add integration.

Integrations list with the Add integration button

Select Google Ads from the list of available integrations.

Integration catalog filtered to Google Ads

Enter the Collect name, e.g., "Google Ads PL".

Collect name field filled in with the example name Google Ads PL

Authorization

If you have already authorized Google Ads and the token has the Google Ads permission, simply pick it from the Select Google Ads authorization drop-down and skip this step.

Click Authorize.

Authorize button next to the Select Google Ads authorization field

A Google window opens. Choose the Google account you want to use and allow WitCloud to access it. WitCloud asks for two permissions: to manage your Google Ads accounts and data (the Google Ads API permission, shown by Google as "See, edit, create and delete your Google Ads accounts and data"), and to see your basic Google profile, which gives the authorization its name in the drop-down. When the window closes, the new authorization is selected for you.

Accounts

Open the Select accounts drop-down and choose the Google Ads accounts to export. Accounts are listed as name (account ID). Manager accounts are not listed, only the accounts that hold the data, including client accounts under a manager account.

Select accounts drop-down open with example Google Ads accounts

You can select several accounts.

Select accounts field with two example Google Ads accounts selected

Each selected account becomes a separate data collect named "<Collect name> - <account name (ID)>", with its own set of BigQuery tables. All of them use the settings you enter below.

Advanced settings

Click Show advanced settings to choose the Tables to collect. All six tables are selected by default and at least one must stay selected. Remove the ones you do not need: they are not filled with data.

Advanced settings open with the Tables to collect field

Table to collectWhat it holds
click_statsClicks with the Google Click ID (GCLID), campaign, ad group, device and network
criteria_basic_statsKeyword performance by day: impressions, clicks, cost, conversions
campaign_statsCampaign performance by day: impressions, clicks, cost, conversions, Active View
campaign_conversion_statsCampaign conversions split by conversion action
shopping_statsShopping performance by product
labelsLabels with the campaigns they are assigned to

Google Ads provides click-level data only for the last 90 days. Older days are skipped in click_stats, including during the historical import.

Click Next to continue.

Historical data and scheduling

Enter the number of days of historical data to fetch in the Historical Data field (required, up to 365).

Historical Data field filled in with 365 days

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

Click Create to complete the configuration.

Data collection settings with the Create button

Done! Your Google Ads data will now be loaded into BigQuery on the schedule, without manual exports.

Data schema

Each table is created per account, as gads_<table>_<account ID>, for example gads_campaign_stats_1000000001. The tables below show the columns of every table.

Data schema for gads_campaign_conversion_stats
Field NameModeType
ExternalCustomerIdNULLABLESTRING
AccountDescriptiveNameNULLABLESTRING
CampaignIdNULLABLESTRING
CampaignNameNULLABLESTRING
ConversionActionNULLABLESTRING
ConversionActionCategoryNULLABLESTRING
ConversionActionNameNULLABLESTRING
AdNetworkType1NULLABLESTRING
AdNetworkType2NULLABLESTRING
ConversionValueNULLABLEFLOAT
ConversionsNULLABLEFLOAT
AllConversionsNULLABLEFLOAT
AllConversionsValueNULLABLEFLOAT
DateNULLABLEDATE
DayOfWeekNULLABLESTRING
DeviceNULLABLESTRING
MonthNULLABLEDATE
MonthOfYearNULLABLESTRING
QuarterNULLABLEDATE
WeekNULLABLEDATE
YearNULLABLEINTEGER
CampaignStatusNULLABLESTRING
CurrencyNULLABLESTRING
Data schema for gads_campaign_stats
Field NameModeType
ExternalCustomerIdNULLABLESTRING
AccountDescriptiveNameNULLABLESTRING
BaseCampaignIdNULLABLESTRING
CampaignGroupIdNULLABLESTRING
CampaignIdNULLABLESTRING
CampaignNameNULLABLESTRING
ActiveViewCpmNULLABLEFLOAT
ActiveViewCtrNULLABLEFLOAT
ActiveViewImpressionsNULLABLEINTEGER
ActiveViewMeasurabilityNULLABLEFLOAT
ActiveViewMeasurableCostNULLABLEFLOAT
ActiveViewMeasurableImpressionsNULLABLEINTEGER
ActiveViewViewabilityNULLABLEFLOAT
AdNetworkType1NULLABLESTRING
AdNetworkType2NULLABLESTRING
AverageCostNULLABLEFLOAT
AverageCpcNULLABLEFLOAT
AverageCpmNULLABLEFLOAT
AveragePositionNULLABLESTRING
ClickTypeNULLABLESTRING
ClicksNULLABLEINTEGER
ConversionRateNULLABLEFLOAT
ConversionValueNULLABLEFLOAT
ConversionsNULLABLEFLOAT
AllConversionsNULLABLEFLOAT
CostNULLABLEFLOAT
CostPerConversionNULLABLEFLOAT
CtrNULLABLEFLOAT
DateNULLABLEDATE
DayOfWeekNULLABLESTRING
DeviceNULLABLESTRING
ImpressionsNULLABLEINTEGER
InteractionRateNULLABLEFLOAT
InteractionTypesNULLABLESTRING
InteractionsNULLABLEINTEGER
MonthNULLABLEDATE
MonthOfYearNULLABLESTRING
QuarterNULLABLEDATE
SlotNULLABLESTRING
ValuePerConversionNULLABLEFLOAT
WeekNULLABLEDATE
YearNULLABLEINTEGER
CampaignStatusNULLABLESTRING
CurrencyNULLABLESTRING
Data schema for gads_click_stats
Field NameModeType
ExternalCustomerIdNULLABLESTRING
AccountDescriptiveNameNULLABLESTRING
CampaignIdNULLABLESTRING
CampaignNameNULLABLESTRING
AdGroupIdNULLABLESTRING
AdGroupNameNULLABLESTRING
CreativeIdNULLABLESTRING
CriteriaIdNULLABLESTRING
GclIdNULLABLESTRING
UserListIdNULLABLESTRING
AdNetworkType1NULLABLESTRING
AdNetworkType2NULLABLESTRING
ClicksNULLABLEINTEGER
CriteriaParametersNULLABLESTRING
KeywordMatchTypeNULLABLESTRING
PageNULLABLEINTEGER
SlotNULLABLESTRING
DeviceNULLABLESTRING
CurrencyNULLABLESTRING
Data schema for gads_criteria_basic_stats
Field NameModeType
ExternalCustomerIdNULLABLESTRING
AccountDescriptiveNameNULLABLESTRING
CampaignIdNULLABLESTRING
CampaignNameNULLABLESTRING
AdGroupIdNULLABLESTRING
AdGroupNameNULLABLESTRING
IdNULLABLESTRING
CriteriaNULLABLESTRING
ActiveViewImpressionsNULLABLEINTEGER
ActiveViewMeasurabilityNULLABLEFLOAT
ActiveViewMeasurableCostNULLABLEFLOAT
ActiveViewMeasurableImpressionsNULLABLEINTEGER
ActiveViewViewabilityNULLABLEFLOAT
AdNetworkType1NULLABLESTRING
AdNetworkType2NULLABLESTRING
AveragePositionNULLABLESTRING
ClicksNULLABLEINTEGER
ConversionValueNULLABLEFLOAT
ConversionsNULLABLEFLOAT
CostNULLABLEFLOAT
CrossDeviceConversionsNULLABLESTRING
DateNULLABLEDATE
DeviceNULLABLESTRING
ImpressionsNULLABLEINTEGER
InteractionTypesNULLABLESTRING
InteractionsNULLABLEINTEGER
ViewThroughConversionsNULLABLEINTEGER
CurrencyNULLABLESTRING
Data schema for gads_labels
Field NameModeType
IdNULLABLESTRING
NameNULLABLESTRING
CustomerIdNULLABLESTRING
CampaignIdNULLABLESTRING
CampaignNameNULLABLESTRING
Data schema for gads_shopping_stats
Field NameModeType
ExternalCustomerIdNULLABLESTRING
AccountDescriptiveNameNULLABLESTRING
CampaignIdNULLABLESTRING
CampaignNameNULLABLESTRING
AdGroupIdNULLABLESTRING
AdGroupNameNULLABLESTRING
AdNetworkTypeNULLABLESTRING
ClickTypeNULLABLESTRING
ConversionActionNULLABLESTRING
ConversionActionCategoryNULLABLESTRING
ConversionActionNameNULLABLESTRING
DateNULLABLEDATE
DayOfWeekNULLABLESTRING
DeviceNULLABLESTRING
ExternalConversionSourceNULLABLESTRING
MonthNULLABLESTRING
ProductAggregatorIdNULLABLESTRING
ProductBiddingCategoryLevel1NULLABLESTRING
ProductBiddingCategoryLevel2NULLABLESTRING
ProductBiddingCategoryLevel3NULLABLESTRING
ProductBiddingCategoryLevel4NULLABLESTRING
ProductBiddingCategoryLevel5NULLABLESTRING
ProductBrandNULLABLESTRING
ProductChannelNULLABLESTRING
ProductChannelExclusivityNULLABLESTRING
ProductConditionNULLABLESTRING
ProductCountryNULLABLESTRING
ProductCustomAttribute0NULLABLESTRING
ProductCustomAttribute1NULLABLESTRING
ProductCustomAttribute2NULLABLESTRING
ProductCustomAttribute3NULLABLESTRING
ProductCustomAttribute4NULLABLESTRING
ProductItemIdNULLABLESTRING
ProductLanguageNULLABLESTRING
ProductMerchantIdNULLABLESTRING
ProductStoreIdNULLABLESTRING
ProductTitleNULLABLESTRING
ProductTypeL1NULLABLESTRING
ProductTypeL2NULLABLESTRING
ProductTypeL3NULLABLESTRING
ProductTypeL4NULLABLESTRING
ProductTypeL5NULLABLESTRING
QuarterNULLABLEDATE
WeekNULLABLEDATE
YearNULLABLESTRING
AllConversionsNULLABLEFLOAT
AllConversionsFromInteractionsRateNULLABLEFLOAT
AllConversionsValueNULLABLEFLOAT
AverageCpcNULLABLEFLOAT
ClicksNULLABLEINTEGER
ConversionsNULLABLEFLOAT
ConversionsFromInteractionsRateNULLABLEFLOAT
ConversionsValueNULLABLEFLOAT
CostMicrosNULLABLEINTEGER
CostPerAllConversionsNULLABLEFLOAT
CostPerConversionNULLABLEFLOAT
CrossDeviceConversionsNULLABLEFLOAT
CtrNULLABLEFLOAT
ImpressionsNULLABLEINTEGER
SearchAbsoluteTopImpressionShareNULLABLEFLOAT
SearchClickShareNULLABLEFLOAT
SearchImpressionShareNULLABLEFLOAT
ValuePerAllConversionsNULLABLEFLOAT
ValuePerConversionNULLABLEFLOAT
CurrencyNULLABLESTRING