With our Power BI Amazon Overview Report template you can visualize your Amazon Seller Central / Amazon MWS data in Power BI. You only need to connect your data to Windsor.ai and enter your API Key given in the process of registration. You’ll have access to your Amazon MWS data and the whole process should not take you more than 5 minutes.
As a prerequisite to getting started you’ll need access to Amazon MWS. Please make sure that you have the necessary user rights.
The full list of supported metrics and dimensions is below. In case you have other fields which are currently not shown in the dashboard or the connector, contact us via chat and we’ll get them added for you.
Metrics used in this report are:
- date,
- product,
- transactions,
- transactionrevenue,
- marketplace,
- item_status,
- quantity,
- item_price,
- last_updated_date,
- order_status,
- fulfillment_channel,
- sales_channel,
- order_channel,
- item_promotion_discount,
- ship_city,
- ship_state,
- ship_postal_code,
- ship_country.
Full list of available metrics and dimensions for advanced users:
| Name | Description |
|---|---|
| Product Name | The Product Name |
| Product Name | The Product Name (Duplicate of Product) |
| Date | The Order Date |
| Transactions | The Number of Transactions (Duplicate of Quantity) |
| Product Quantity | The Product Quantity |
| Transaction Revenue | The Transaction Revenue (Duplicate of Item Price) |
| Item Price | The Price of the Item |
| Amazon Order ID | The Amazon Order ID |
| Merchant Order ID | The Merchant Order ID |
| Last Updated Date | Last Updated Date |
| Order Status | The Order Status |
| Fulfillment Channel | The Fulfillment Channel |
| Sales Channel | The Sales Channel |
| Order Channel | The Order Channel |
| Shipping Service Level | The Shipping Service Level |
| Item Status | The Status of the Item |
| Item Tax | The Tax of the Item |
| Shipping Price | The Shipping Price |
| Shipping Tax | The Shipping Tax |
| Gift Wrap Price | The Price of the Gift Wrap |
| Gift Wrap Tax | The Tax of the Gift Wrap |
| Item Promotion Discount | The Promotion Discount |
| Shipping Promotion Discount | The Shipping Promotion Discount |
| Shipping City | The Shipping City |
| Shipping State | The Shipping State |
| Shipping Postal Code | The Shipping Postal Code |
| Shipping Country | The Shipping Country |
| Promotion ID | The Promotion ID |
| Is business order | Whether or not this is a business order |
| Purchaser Order Number | The Purchaser Order Number |
| Price Designation | The Price Designation |
| Marketplace | The Amazon Seller Central Marketplace |
| Sold by Amazon Business EU SARL | Is true if the items in this order were bought and re-sold by Amazon Business EU SARL (ABEU) |
Report queries the data through our connector and makes it available in real-time.
At the moment you can use our template for the Desktop version of Power BI. Of course, once you save it in Power BI Desktop, you can publish the report to your web services.
To get started
- Register or login if you already have an account.
- Select Amazon account from the dropdown and remember to grant access.
- After completing the process of registering and connecting your data from Step 1
2. Download Power BI Desktop Template: Amazon Overview Report
- In the template on the start screen, paste your API Key from Step 1 like here and, optionally, choose the date range.
- Your data should be loading now. Depending on your data size this may take a minute or two.
Important: You will need to change the fields to their types (e.g. date, decimals, whole numbers, …) to use them in aggregations (sums, averages, …) or date filters. For users in Europe and other countries where a comma is used for decimals please change the locale of the data to English.
