# 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 Data Coleect 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.

Collect 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 module of Google Ads allows you to retrieve data from the Google Ads system by extracting data from the API that does not require any further configuration. The data is displayed in the WitCloud dataset according to a set schedule. It is possible to obtain historical and current data (from today). Up to 5 accounts can be selected.

image alt text

In the next step, select the time period for which the data should be downloaded.

image alt text

Ready! After pressing the Finish 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: 2022-05-26T09:18:07.000Z