Google Ads data into your data warehouse in minutes

Automate Google Ads from a single space with no code

Google Ads is an online advertising platform that allows businesses to create and display ads to potential customers.

Google Ads, formerly known as Google AdWords, is a pay-per-click (PPC) advertising platform that enables businesses to create and display ads to potential customers when they search for specific products or services on Google. Advertisers bid on specific keywords and pay for each click on their ads, with the cost per click (CPC) varying depending on the competition for the keyword. Google Ads also offers a range of targeting options, including location, demographics, and interests, allowing businesses to reach their ideal audience. Additionally, Google Ads provides detailed analytics and reporting, allowing advertisers to track the performance of their ads and make data-driven decisions to optimize their campaigns.

Prerequisites

To obtain the required settings for connecting to Google Ads, follow these steps:

1. OAuth identity provider authorization endpoint used to create and refresh tokens: This endpoint is specific to the identity provider you are using. You can find this information in the documentation provided by the identity provider.

2. OAuth scopes we need to request access to: The required OAuth scopes depend on the specific actions you want to perform in Google Ads. You can find a list of available scopes in the Google Ads API documentation.

3. Access Token: To obtain an access token, you need to authenticate with Google using OAuth 2.0. Once you have authenticated, you will receive an access token that you can use to make API requests. You can find more information on how to obtain an access token in the Google Ads API documentation.

4. OAuth Refresh Token: The refresh token is obtained during the initial authentication process and is used to obtain a new access token when the current one expires. You can find more information on how to obtain a refresh token in the Google Ads API documentation.

5. Developer Token: The developer token is a unique identifier that is used to track API usage and ensure compliance with Google Ads policies. You can obtain a developer token by creating a Google Ads account and registering for the API.

6. Customer Id: The customer ID is a unique identifier for each Google Ads account. You can find your customer ID in the Google Ads UI or by using the Google Ads API.

Settings

Start Date

ISO start date for all of the streams that use date-based filtering. Defaults to 90 days before the current day.

End Date

ISO end date for all of the streams that use date-based filtering. Defaults to the current day.

Customer Id

DEPRECATED: use customer_ids

Get data for a customer by the provided ID. Defaults to all customers accessible to the authenticated principal.

Login Customer Id

If authenticated as a manager account, login_customer_id should be set to the customer ID of the manager account. Read about the login customer ID concept for more info.

Customer IDs

Get data for the provided customers only, rather than all accessible customers. Takes precedence over customer_id.

Enable Click View Report Stream

Enable the click view report stream (requires certain permissions to be set for your Google Ads account(s)). Not enabled (false) by default.

Custom Queries

A list of custom queries to run. Each query will be assigned a stream with the name specified in the name field.

Custom query definition:

• name (required)`

  The name to assign to the query stream.

• query (required)

  A custom defined GAQL query for building the report (do not include segments.date filter in the query - it is automatically added).

  For more information, refer to Google's documentation.

• add_date_filter_to_query (default: true)

  Whether to add date filter to the query

• primary_keys (default: [] i.e. no primary keys)

  Properties name(s) to use as the stream primary key(s).

  Note that this tap performs schema flattening automatically, so both top-level and nested properties (in the form <parent_property>__<child_property) can be referenced.

• replication_method (default: INCREMENTAL, possible values: [INCREMENTAL | FULL_TABLE])

  Stream replication method.

• replication_key (required when replication_method is set to INCREMENTAL)

  Properties name(s) to use as the stream replication key.

  Note that this tap performs schema flattening automatically, so both top-level and nested properties (in the form <parent_property>__<child_property) can be referenced.