ETL Google Ads data to Google BigQuery

Google’s famous product, an online advertising platform Google Ads helps advertisers display ads both in the results of search engines like Google Search and on non-search websites, mobile apps, and videos.

The Google Ads platform runs on pay-per-click (PPC) advertising and enables flexibility for client budgets with bidding strategies.

To analyse your marketing campaigns performance transfer your Google Ads data to BigQuery with Renta in 4 clicks. 

Simple integration configuration

How to set configuration:

  1. Select Google Ads from the list of available integrations
  2. Fill in your Google Ads account
  3. Indicate which data you need to retrieve
  4. Add your data warehousing

This is all you have to do to get your data to BigQuery and start working on your reports.

Data structure of the Google Ads API

Renta supports 47 standard methods of exporting statistics from an ad account.

Below are some supported report types.

Ad performance

The Account Performance report includes all statistics aggregated by default at the account level, one row per account. If other segment fields are used, you may get more than one row per account.

AdGroup performance

The Ad Group Performance report includes all statistics aggregated by default at the ad group level, one row per ad group. If other segment fields are used, you may get more than one row per ad group.

Campaign performance

The Campaigns Performance report includes all statistics aggregated by default at the campaign level, one row per campaign. If other segment fields are used, you may get more than one row per campaign.

Account performance

The Account Performance report includes all statistics aggregated by default at the account level, one row per account. If other segment fields are used, you may get more than one row per account.

Geo performance

The Geo Performance report includes all statistics aggregated at the country/territory level, one row per country/territory. If other segment fields are used, you may get more than one row per country/territory.

Search query performance

The Search Terms report includes all statistics aggregated at the search terms level, one row per combination of search terms. If other segment fields are used, you may get more than one row per combination of search terms