This page received its last significant update on 4/30/2020
The most up to date information can be found on the homepage, as well as any pages that don't show this warning.
The Google Ads extractor pulls raw data from Google's AdWords API and extracts the following resources from a Google Ads account:
Note that Smart Campaigns are not supported, and their performance data is not available to Meltano.
For more information you can check the documentation for tap-adwords.
In order to access your Google Ads data, you will need the following:
One or more Google Ads Account IDs to extract data from.
To get your Account ID(s):
Remove the dashes before you enter the ID in Meltano:
If you want to extract data from multiple Ad Accounts, repeat the steps above to find the IDs (without dashes), and enter them in Meltano separated by commas (
The Refresh Token generated through the OAuth flow run using your OAuth Client and your Developer Token.
The Google account you connect needs to have access to your Ads Account.
If you want to manually generate a Refresh Token, check out Google's documentation.
This property determines how much historical data will be extracted.
Please be aware that the larger the time period and amount of data, the longer the initial extraction can be expected to take.
Please note that this extractor requires advanced configuration for self-hosted Meltano instances.
If you do not have (1) a developer token for your Google Ads Account and (2) an approved Google OAuth Client, the process that you have to go through to generate those may take between one and four weeks.
In order for the extractor to properly authenticate on Google APIs, it requires to be able to acquire new access tokens. The following variables are required for the authentication flow:
.envfile in a text editor
export OAUTH_GOOGLE_ADWORDS_DEVELOPER_TOKEN=<developer_token> export OAUTH_GOOGLE_ADWORDS_CLIENT_ID=<client_id> export OAUTH_GOOGLE_ADWORDS_CLIENT_SECRET=<client_secret>
Open your Meltano instance and click "Pipelines" in the top navigation bar. You should now see the Extractors page, which contains various options for connecting your data sources.
Let's install the Google Ads Extractor by clicking on the
Install button inside its card.
On the configuration modal we want to enter all the fields descibed in the Google Ads Setup section.
meltano add extractor tap-adwords
If you are successful, you should see
Added and installed extractors 'tap-adwords' in your terminal.
.envfile in a text editor
export TAP_ADWORDS_REFRESH_TOKEN="" export TAP_ADWORDS_USER_AGENT="" export TAP_ADWORDS_CUSTOMER_IDS="" export TAP_ADWORDS_START_DATE="2020-01-01T00:00:00Z"
export TAP_ADWORDS_END_DATE="2020-02-17T00:00:00Z" export TAP_ADWORDS_CONVERSION_WINDOW_DAYS=""
TAP_ADWORDS_CONVERSION_WINDOW_DAYS sets how many days before the start_date to fetch data for Performance Reports (default: 0)
Check the README for more details.