Amazon Seller Central Business Reports

Overview

The Amazon Seller Central Business Reports dashboard was created to help you analyze your Amazon performance in Daasity in the same way as you would from within the Seller Central Business Reports.

Setup

Enterprise accounts

If you have an Enterprise account, please reach out to [e-mail] to help you set up the explore and dashboard. Or, if you have developer access in Looker, you can simply add the following line of code to your addons.lkml file:

include: "//base_daasity/**/integration/amazon/*"

Once enabled, just search for "Business Reports" using the search bar in Looker.

Growth accounts

If you have a Growth account, you just need to set up the Amazon Seller Central integration, ensure that the Sales and Traffic reports are enabled, and trigger a history load. Once you do this, you will see this dashboard in your dashboard list.

Data sources

All of the visualizations except for the Detail Pages Sales and Traffic - By ASIN table use the Amazon Business Reports - By Day explore.

The Detail Pages Sales and Traffic - By ASIN viz uses the Amazon Business Reports - By ASIN explore

Important things to know

Discrepancies due to data lag

We pull the data to populate this dashboard during your nightly workflow — typically at midnight in your Daasity account's timezone. This means if there are any updates to the data between when the data is extracted and when you view the report, there will be a discrepancy between the data in Daasity and the data in your Amazon Seller Central UI.

Discrepancies due to marketplace/currency settings

These Business Report explores differ from the Business Reports UI within the Seller Central interface in two ways:

• By default, we're displaying currency values converted into the master currency you have chosen in the Daasity app. In the Seller Central UI, the currency is displayed based on the marketplace you are reporting on.

• By default, the dashboard and explore show data for all of the marketplaces you have connected to Daasity. In the Seller Central UI, you can only view data for one marketplace at a time.

If the numbers look off, trying double-checking the marketplace and currency filters so that they match exactly what you're comparing in the Seller Central UI.

Discrepancies caused by the Sales & Traffic Business Reports by SKU lookback window

The "By ASIN" reporting will likely have a larger discrepancy than the "By Day" reporting because by deafult we only pull 1-day's worth of history with each nightly extraction. That means if there were returns that occurred outside that 1-day window, they won’t be reflected.

If you need to minimize this discrepancy, you can increase the lookback window in your Amazon Seller Central integration settings. However, this will increase the time it takes to extract this data every night.

Product dimensions

The Business Reports exports from Amazon don’t include product dimensions like product title. (They only includes parent asin, child asin, and sku.) To get dimensions like product name, the explore includes SKU Attributes data.

If you have mapped the SKU to a Shopify SKU, that means it will show Shopify SKU Attributes. Otherwise, it will show SKU information from your Amazon Orders reports.

NULL product dimensions

If you are seeing NULL product dimensions, check your SKU Mapping to make sure you're not mapping the same SKU twice.