Back to plugin list
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.8.0
Type
Source
Platforms
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
2. Create source and destination configs
Plugin configurationOverview #
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.8.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 #
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 tokenThis 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 secretYou can get your own OAuth credentials using this guide.
Application Default Credentials #
See the official Application Default Credentials guide.
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
)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 aredfs
(depth-first search),round-robin
,shuffle
andshuffle-queue
.For more information about this, see performance tuning.
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 forhttps://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.