January 12, 2021 17:35

Google Ads Integration

In this article, we’ll integrate a Google Ads data source with Y42.

On our platform you can configure your Google Ads integration to query all of your Google Ads accounts and combine them into a single table per report. It is also possible to load data from different Google Ads accounts by selecting the desired accounts and reports you would like to import into Y42.

You can find the list of available reports and the available columns, dimension, and metrics for each report on Google Ads API documentation.

A guide on how to best understand and use the data from the API is available here on the Google Ads Raw Data Guide.

Overview

Authentication: OAuth

Settings: Historical Date selection, Account selection

Schema type: Fixed

Update Type: Full import and incremental

Authentication

OAuth doesn’t share password data but instead uses authorization tokens to prove an identity between you and the service provider. OAuth is an authentication protocol that allows you to approve one application interacting with another on your behalf without giving away your password. For instance, when you tell tell Facebook that it’s OK for another application or website to access your profile. To sum up, you only need to have an existing account to authorize the access.

Import Settings

By default the historical date will be set to one year ago. Refer to your own datasource to decide from which exact date you would want to retrieve data.

Account types

Google Ads has two types of accounts: Manager and Client. Each account type has its own level of access and permissions. Our integration allows to connect both types of accounts.

A Manager account is a Google Ads account type meant to be used by advertisers or agencies that potentially need to manager multiple client accounts. It is possible to pull data from the other client level accounts with a Manager account type.

Note: However, during the import settings, you would still need to select all the accounts from which you'd like to extract data from.

A client account, on the other hand, would only have access to information stored within their account. If you are using a client account, by default it will not have access to the API. In this case, to get the API access, your client account needs to be associated with the manager account. After this setup, you will then be able to retrieve data using your client account. If no Google Ads manager account has been set up yet, you can do so by following these instruction on Google Ads Help page.

Schema

You can find the full list of available reports and their columns/dimensions/metrics you are able to import to your Y42 instance on Google Ads documentation.

Note: When setting up integration and importing the relevant tables and columns, be aware that Google Ads reports have some limitation. You may discover that some column selection combinations are not possible. This is why we recommend that instead of importing all possible tables and columns, you refer to the Google Ads API documentation above and find out which specific reports and columns are needed from your side.

Because of this limitation, you may need to set up two different imports within one integration to retrieve the desired data and avoid this Google Ads API constraint.

You can find a column selection recommendation here.

Updating your data

You have the option of scheduling Full imports or Incremental Imports by the month, weeks, days, and even by the hour. With the incremental import you will only add the new rows to that table, while a full import will actually re-import the entire table completely.

Incremental imports significantly increase the import speed, we import your table incrementally based on the last imported state e.g. id - If the table does not have a state, a full import will be triggered - This is done automatically.

We recommend therefore to schedule an incremental import regularly, but also schedule a full import with a certain frequency -- this is because only the full import will guarantee that old rows that have been updated on the data source will also get updated on your Y42 integration destination.

Google Ads Setup Guide:

Note: In order to connect your Google Ads account with Y42, you will need to have a Google Account.

On Integrate, click on "Add..." to search for Google Ads and select it.
Name your integration.
Click Authorize and log into your Google account.
After authentication, you are good to go and start importing your tables.
Choose from which point onwards in time to import your data.
Add in your Google Ads Account and press Select.
Select the tables you need and click import. You can start accessing the tables once the status is “Ready”. You can find a recommendation of tables and columns here.

Note: You can always import and reimport other tables as well, or delete them.

Was this article helpful?

1 out of 1 found this helpful