Skip to content
No description or website provided.
Python
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.circleci Update pip after creating the virtualenv (#59) Jan 22, 2020
.github
tap_adwords Allow for setting custom primary keys on reports (#58) Jan 23, 2020
.gitignore
CHANGELOG.md
LICENSE Initial commit Apr 3, 2017
MANIFEST.in
README.md Allow for setting custom primary keys on reports (#58) Jan 23, 2020
setup.py

README.md

tap-adwords

This is a Singer tap that produces JSON-formatted data following the Singer spec.

This tap:

Quick start

Install

We recommend using a virtualenv:

> virtualenv -p python3 venv
> source venv/bin/activate
> pip install tap-adwords

Get Access to the AdWords API

To use the AdWords API, you must request and be granted access. https://developers.google.com/adwords/api/docs/guides/signup

Set up OAuth2 authentication

The Tap will need to access user data and contact Google services on your behalf. Authentication via OAuth2 allows your app to operate on behalf of your account. To enable your app to access the API, you need an OAuth2 client ID and client secret.

Read Google's guide on getting your OAuth2 client ID and client secret.

https://developers.google.com/adwords/api/docs/guides/first-api-call#set_up_oauth2_authentication

Create the config file

The AdWords Tap will use the developer token and OAuth properties from the previous steps. Additionally you will need:

start_date - an initial date for the Tap to extract AdWords data
user_agent - used in requests made to the AdWords API
customer_ids - A comma-separated list of AdWords account IDs to replicate data from

The following is an example of the required configuration

{"developer_token": "",
 "oauth_client_id": "",
 "oauth_client_secret": "",
 "refresh_token": "",
 "start_date": "",
 "user_agent": "",
 "customer_ids": ""}

Create a properties file

The properties file will indicate what streams and fields to replicate from the AdWords API. The Tap takes advantage of the Singer best practices for schema discovery and property selection.

[Optional] Create the initial state file

You can provide JSON file that contains a date for the streams to force the application to only fetch data newer than those dates. If you omit the file it will fetch all data for the selected streams.

{"campaigns_12345":"2017-01-01T00:00:00Z",
 "CLICK_PERFORMANCE_REPORT_12345":"2017-01-01T00:00:00Z",
 "CRITERIA_PERFORMANCE_REPORT_12345":"2017-01-01T00:00:00Z"}

Run the Tap

tap-adwords -c config.json -p properties.json -s state.json

Metadata Reference

tap-adwords uses some custom metadata keys:

  • behavior - The “fieldBehavior” value from the Google Adwords API. Either "attribute", "metric", or "segment". (discoverable)
  • fieldExclusions - Indicates which other fields may not be selected when this field is selected. If you invoke the tap with selections that violate fieldExclusion rules, the tap will fail. (discoverable)
  • tap-adwords.report-key-properties - Is user set and indicates which fields to output as "key_properties" in the stream's SCHEMA message. (nondiscoverable)

Copyright © 2017 Stitch

You can’t perform that action at this time.