Skip to content

dbt-labs/tap-amazon-advertising

Repository files navigation

tap-amazon-advertising

Author: Drew Banin ([email protected])

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

It:

  • Generates a catalog of available data in the Amazon Advertising API
  • Extracts the following resources:
    • portfolios
    • profiles
    • ad groups
    • ad groups: biddable keywords
    • ad groups: negative keywords
    • campaigns:
    • campaigns: negative keywords
    • product ads
    • sponsored products report: product ads
    • sponsored brands report: ad groups
    • sponsored brands report: campaigns
    • sponsored brands report: keywords

Quick Start

  1. Install
git clone [email protected]:fishtown-analytics/tap-amazon-advertising.git
cd tap-amazon-advertising
pip install .
  1. Get credentials from Amazon

In addition to a client id and secret, you'll also need to obtain a refresh token for an authorized amazon advertising user. This can be accomplished by running the get_refresh_token.py script located in the root of this repository.

  1. Create the config file.

There is a template you can use at config.json.example, just copy it to config.json in the repo root and insert your credentials.

  1. Run the application to generate a catalog.
tap-amazon-advertising -c config.json --discover > catalog.json
  1. Select the tables you'd like to replicate

Step 4 a file called catalog.json that specifies all the available endpoints and fields. You'll need to open the file and select the ones you'd like to replicate. See the Singer guide on Catalog Format for more information on how tables are selected.

  1. Run it!
tap-amazon-advertising -c config.json --catalog catalog.json

Copyright © 2019 Fishtown Analytics

About

Singer.io tap for Amazon Advertising

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages