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)

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.

Troubleshooting

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