Google AdWords connector

Overview

The Etlworks Google AdWords connector allows you to extract marketing data from Google Ads using the AdWords Query Language (AWQL). You can then load this data into any destination supported by Etlworks, such as databases, cloud storage, or web APIs.

Learn more: Get started with Google AdWords

What Is AWQL?

AWQL (AdWords Query Language) is a SQL-like language used to query Google Ads reporting data. It supports powerful filtering, ordering, and column selection across a wide range of Google Ads report types.

Creating a Connection

To connect to Google Ads:

1. Go to Connections, click +.

2. Search for Google AdWords.

3. Select the Google AdWords connector from the gallery.

Authentication

The connector uses OAuth 2.0 for authentication.

• You will be prompted to Sign in with Google during setup.

• Etlworks supports the OAuth2 Web Server Flow for secure, delegated access.

Read more about OAuth2 with Google Services in Etlworks

Required Parameters

• Google AdWords Account ID

  Your unique Ads account ID.

  Find your Google Ads Account ID

• OAuth Token

  Obtained during OAuth2 authentication. Automatically managed by Etlworks after sign-in.

• Developer Token

  You need a valid developer token from your Google Ads Manager account.

  Apply for a developer token

• AWQL Query

  The actual SQL-like query to extract data from Google Ads.

  Explore AWQL syntax and sample queries

Related Articles

• Get started with Google AdWords

• Connecting to Google Services