Back to plugin list

Google Ads

The CloudQuery Google Ads plugin for CloudQuery pulls configuration from Google Ads API and loads it into any supported CloudQuery destination



Latest version




Date Published

Price per 1M rows

Starting from $15

monthly free quota

1M rows

Set up process #

brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync googleads.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview #

The Google Ads source plugin extracts information from Google Ads API and loads it into any supported CloudQuery destination (e.g. PostgreSQL, BigQuery, Snowflake, and more).

Example Configuration #

kind: source
  name: googleads
  path: cloudquery/googleads
  registry: cloudquery
  version: "v3.6.0"
  tables: ["*"]
  destinations: ["postgresql"]

    # required
    developer_token: "${GOOGLE_ADS_DEVELOPER_TOKEN}"

Authentication #

Google Ads API authentication is based on OAuth 2.0 authorization along with Developer Token.
Two methods are supported: OAuth 2.0 and Application Default Credentials.
Note: See the official documentation describing different authorization options.

OAuth 2.0 #

The following options are available when using OAuth:
  • Using an existing access token
    This token should be authorized for scope (e.g. by using OAuth 2.0 Playground).
  • Using OAuth client ID & client secret
    You can get your own OAuth credentials using this guide.

Application Default Credentials #

Note: You will still need to authorize these credentials for scope.
Available options are all the same options described here in detail.

Configuration Reference #

This is the (nested) spec used by the Google Ads source plugin:
  • developer_token (string) (required)
    A Google Ads Developer Token.
  • login_customer_id (string) (optional)
    Google Ads Login customer ID.
    Format: digits either with or without hyphen (-).
    This parameter allows to specify the root account to fetch data from (as well as linked accounts). If omitted, the accessible accounts are listed and used instead.
    Note: As Google Ads API doesn't allow obtaining the current account ID, you can set this parameter to the account ID you generate Developer Token from. This way you'll be able to fetch the data from the root management account as well.
  • customers ([]string) (optional)
    Fetch the data only from the specified accounts. If account ID specified is a management account, the data will be fetched both from this account and all accounts accessible from it.
    Format: digits either with or without hyphen (-).
  • oauth (OAuth spec) (optional)
  • concurrency (integer) (optional) (default: 10000)
    Number of resources to sync in parallel.

Google Ads OAuth spec #

Google Ads API requires OAuth authorization for scope to execute API calls.
  • access_token (string) (optional)
    An access token that you generated authorizing for scope (e.g., by using OAuth 2.0 Playground).
  • client_id (string) (optional)
    OAuth 2.0 Client ID.
  • client_secret (string) (optional)
    OAuth 2.0 Client secret.

© 2024 CloudQuery, Inc. All rights reserved.