Back to plugin list
googleads
Official
Premium

Google Ads

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

Publisher

cloudquery

Latest version

v3.2.3

Type

Source

Platforms
Date Published

Mar 12, 2024

Price per 1M rows

$100

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
spec:
  name: googleads
  path: cloudquery/googleads
  registry: cloudquery
  version: "v3.2.3"
  tables: ["*"]
  destinations: ["postgresql"]

  spec:
    # 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 https://www.googleapis.com/auth/adwords 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 https://www.googleapis.com/auth/adwords 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 https://www.googleapis.com/auth/adwords scope to execute API calls.
  • access_token (string) (optional)
    An access token that you generated authorizing for https://www.googleapis.com/auth/adwords 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.


Subscribe to product updates

Be the first to know about new features.