Amazon Vendor Central Data Connector User Guide

Amazon Vendor Central Data Connector User Guide

Info
Amazon Vendor Central is Amazon's portal for vendors who sell their products wholesale directly to Amazon. This guide will help you connect your Amazon Vendor Central account to Power My Analytics, enabling you to automate the collection of your vendor sales, inventory, traffic, and forecasting data and create insightful reports.

Prerequisites

Before connecting Amazon Vendor Central to Power My Analytics:

  • You must have an active Amazon Vendor Central account
  • You must be able to sign in with the Amazon credentials that have access to your Vendor Central account (Power My Analytics authenticates via single sign-on with Amazon)
Alert
The Amazon Vendor Central connector reports first-party (1P) vendor data only. If you sell on Amazon as a third-party (3P) seller, use the Amazon Seller Central connector instead.

Adding Amazon Vendor Central as a Data Source

  1. Log in to your Power My Analytics Hub
  2. Navigate to Sources in the main menu
  3. Click + Add New Source
  4. Select Amazon Vendor Central from the gallery
  5. Assign a memorable name to the account
  6. Click Connect to authenticate via Amazon single sign-on
  7. Approve the required permissions in the consent pop-up

For a detailed walkthrough, see How to Connect to Amazon Vendor Central.

Creating a Data Studio Report

Follow these steps to create a Data Studio report using your Amazon Vendor Central data:

  1. After adding Amazon Vendor Central as a data source, go to Reports > Data Studio
  2. Select Amazon Vendor Central under Create Data Studio Report (this will open the official Data Studio application in a new window)
  3. Google Data Studio Configuration:
    • Step 1: Name your data source (e.g., "Amazon Vendor Central - [Organization Name]"), choose your Power My Analytics hub from the dropdown, optionally leave "Use report template for new reports" checked for the PMA demo template, and click Next
    • Step 2: Under User Account, select your Amazon Vendor Central account (for real data) or "Sample Account" (for sample data), then click Connect (top right) to complete the configuration
    • Step 3: Click Create Report (top right)

For a quick start, you can use our pre-built Amazon Vendor Central demo template.

Key Reports and Fields

Popular metrics and dimensions available in Amazon Vendor Central reports include:

  • Sales Report Metrics: Ordered Revenue Amount, Shipped Revenue Amount, Ordered Units, Shipped Units, Shipped Cogs Amount, Customer Returns
  • Sales Report Dimensions: Asin, Ordered Revenue Currency Code, Shipped Revenue Currency Code
  • Inventory Report Metrics: Sellable On Hand Inventory Units, Sellable On Hand Inventory Cost Amount, Unsellable On Hand Inventory Units, Unsellable On Hand Inventory Cost Amount, Aged90plus Days Sellable Inventory Units
  • Forecasting Report Metrics: Mean Forecast Units, P70forecast Units, P80forecast Units, P90forecast Units
  • Shared Dimensions: Asin, Marketplace ID, Start Date, End Date

For a complete list of available Amazon Vendor Central fields, refer to the Schema Explorer.

Limitations and Important Considerations

  • Backfilling: Up to 2 years of historical data is available. Power My Analytics backfills the full 2 years when you first connect your Amazon Vendor Central account as a data source.
  • Data availability: Amazon publishes Vendor Central data on a delay, so your most recent dates will normally sit 3 to 4 days behind today. See below.
  • Forecasting history: Amazon supplies only the most recent forecast. Historical forecast data cannot be requested, so your Forecasting Report will not build up a history of past forecasts over time.

Amazon's Data Availability Delay

Amazon does not release Vendor Central reporting data immediately. Amazon's published availability targets for the reports PMA collects are:
  • Vendor Sales and Vendor Traffic (daily periods): 72 hours after the reporting period closes.
  • Vendor Sales and Vendor Traffic (weekly periods ending Saturday): end of the day Monday, 48 hours after the period closes.
  • Vendor Forecasting: refreshed within 72 hours after the week ends.
  • Vendor Inventory: Amazon does not publish an availability target; in practice this report follows the same 3 to 4 day pattern.
So a report you open on a Thursday will often end on the previous Sunday or Monday. Some periods take longer than Amazon's stated targets, and delays of up to a week are occasionally reported.
Alert
No setting in Power My Analytics can retrieve data that Amazon has not yet published. Changing your sync time, widening your report's date range, or running a manual backfill will not pull days that Amazon has not released. Those days will fill in on their own once Amazon publishes them.
Notes
If you add the PMA Maximum Cached Data Date metadata field to a Vendor Central report, expect it to read a few days newer than your most recent row of data. That field describes the cached data behind your report rather than the row it sits beside, so the gap is expected here and does not mean data is missing. See What Fields Are Available In PMA's Connectors?
For how other connectors behave, see Understanding Data Delays.

Troubleshooting

Please see our Basic Troubleshooting article for help with common issues that may affect the Amazon Vendor Central connector.