# Google Ads to BigQuery

# Introduction

The module integrates with the Google Ads API in order to download data and save it in Google BigQuery. How is the module different from Google Ads Data Transfer offered by Google BigQuery? Data can be downloaded from the present day. The Google Ads Data Transfer module available in Google BigQuery does not download today data.

# An example of operation

  1. You are configuring the Google Ads module
  2. You are using the module to automatically combine costs with Google Analytics data
  3. You run reports that show the cost attributed to products, even if they come from brand campaigns
  4. You optimize your campaigns based on the cost and sales effectiveness of your products

# Configuration

# Before you start

Access to your Google Ads advertising account

NOTE to use this module, you must have access to a Google Ads advertising account.

# Start creating the module

From the menu on the left, select the "Collect" tab, then click the "Add new Pipeline" button.

image alt text

Select "Google Ads" from the list of available modules

image alt text

# Initial settings

In the first step, we only have one field to fill.

Pipeline name- the name of our module. It will be visible under this name elsewhere on the platform.

image alt text

# Authorization with Google Ads

In the next step, we need to grant WitCloud access to BigQuery and our Google Ads service. It is necessary for WitCloud to be able to download data and settings for the service.

To do this, press the "Sign in with Google" button

image alt text

Then, in a new window, select an email from the list that has access to the Google Analytics service that we want to set up in WitCloud. After selecting, a window will appear with the accesses that we have to grant. Confirm your choice by clicking the "allow" button.

After proper authorization, select our email from the list, and then the Google Ads account whose data we want to export to BigQuery.

The WitCloud Google Ads module provides 2 methods of retrieving data from the Google Ads system. The first one is data download via API, which does not require further configuration. The data will appear according to the schedule you set in the WitCloud dataset. It is possible to collect historical and current data (as of today). You can select a maximum of 5 accounts.

image alt text

The second method is to download data via BigQuery Data Transfer. Google Cloud provides the functionality to automatically export data from Google Ads to BigQuery. The transfer itself is free and allows you to export an unlimited number of accounts,including manager accounts.

Instructions on how to configure such a transfer can be found at this link: Google Ads Data Transfer (opens new window)

After configuring the transfer, we select the Google Cloud project and the dataset where Google Ads data is collected.

image alt text

Ready! After pressing the Create button, the module configuration will be saved.

# Setting the module in the schedule

Your Google Ads module is already created in WitCloud 📊. The last step is to establish a schedule and include our module in it. You can read about how to do it here link (opens new window)

Last updated: 4/15/2021, 12:30:11 PM