Set up process #

Example Configuration #

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

  # Learn more about the configuration options at https://cql.ink/googleads_source
  spec:
    # required
    developer_token: "${GOOGLE_ADS_DEVELOPER_TOKEN}"

Authentication #

OAuth 2.0 #

• 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 #

Configuration Reference #

• 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)

  A best effort maximum number of Go routines to use. Lower this number to reduce memory usage.
• scheduler (string) (optional) (default: dfs) The scheduler to use when determining the priority of resources to sync. Supported values are dfs (depth-first search), round-robin, shuffle and shuffle-queue.

  For more information about this, see performance tuning.

Google Ads OAuth spec #

• 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.