Amazon Selling Partner - Reports

Any instance where an entry in the below configuration has a leading $ represents a parameter that needs to be replaced with a static value.

Parameters in this document:

• $client_id, $client_secret and $refresh_token - The Client ID, Client Secret, and Refresh Token are all obtained as part of the Authorization and Authentication steps of developing your Amazon application for API access. These three parameters should be available to you in the Developer Console upon completion of the steps outlined in the Before You Start section of the Amazon Selling Partner home page.
• $marketplace_ids - The Marketplace IDs represent the market(s) for which data is being pulled from the API. For a list of valid Marketplace ID's, visit here. Note that this can be a list of multiple Marketplace IDs, or just a single value, depending on the use case. When entering multiple values, they should be entered as a comma separated list (e.g. A2EUQ1WTGCTBG2,ATVPDKIKX0DER).
• $report_type - The Report Type represents the Amazon Selling Partner report that is being ingested. Values for this parameter can be found here, with the following links going directly to each sub-section of report types:
  • Analytics Reports
  • Inventory Report Type Values
  • Order Report Type Values
  • Returns Report Type Values
  • Performance Report Type Values
  • Settlement Report Type Values
  • Fulfillment by Amazon (FBA) Report Type Values
  • Tax Report Type Values
  • Invoice Data Report Type Values
  • Browse Tree Report Type Values
  • Easy Ship Report Type Values
  • Amazon Business Report Type Values
  • B2B Product Opportunities Report Type Values
  • Regulatory Compliance Report Type Values

Destination table naming convention is ultimately up to you as the data owner. We recommend using a naming convention that clearly describes the report being ingested. For example, when collecting the FBA Amazon Fulfilled Inventory Report, using such a table name as amazon_fba_fulfilled_inventory_report.

The Primary Key represents the unique identifier for a given report, plus the field __file_base_name as this will ensure that each file is treated as part of the uniqueness check. For example, when ingesting the FBA Amazon Fulfilled Inventory Report, the Primary Key is {__file_base_name}-{seller-sku}.

When entering a column value to the incremental key feature, you will need to use the following format: YYYY-MM-DD