You can't use this until you register with us!

Description

Obtain data from Google Ads and load it into BigQuery.

Purchasing Options

Google Ads to BigQuery Loader - $149.99 / month

Available Actions

Load Data

Execute a Google Ads Query and store the results in a table in BigQuery.

Variables

Source Parameters
gcp_connection required

Credentials to use to access the Google Cloud Platform account with Google Ads data.

gads_connection required

Credentials to use to access the Google Ads accounts.

customer_ids required

Comma separated list of the customer ids associated with the Google Ads accounts.

gads_query required

Query to return the Google Ads data desired.

user_params

Parameters to use in your Google Ads Query, if any. Refer to slide out help for more information.


Destination Parameters
bigquery_connection required

Credentials to use to access the Google Cloud Platform account with the BigQuery database.

project_id required

Specify the unique identifier of the Google Cloud project that contains the dataset where the data will be loaded.

dataset required

Specify the name of the dataset that contains the table where the data will be loaded.

bigquery_table required

Specify the name of the table where the data will be loaded.

region

Optionally specify the region where the dataset is located.

fields_mapping required

Mapping between Google Ads field values and BigQuery columns.


Range Parameters
range_start_point required

Date where the download of your data should begin. This field will automatically be updated after each increment is processed.

range_data_offset

Fixed amount to adjust the Next Run Start Point.

range_end_point_query

SQL Query to execute against the BigQuery database to determine the end point of the data to download. Leave this field blank to download all data with a date after the Next Run Start Point.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.