Validating Your Amazon Data in Daasity
Important things to know when analyzing your Amazon Seller Central data in Daasity
Use this guide to understand which explores and dashboards to use in Daasity based on the reports you already use within Amazon.
Amazon Fulfillment Reports
Almost all of the order-based Amazon reporting in Daasity uses data from the All Orders report:
Where to analyze this data
You can analyze data from the All Orders report in the following places.
Filter for Source Name = asc
to isolate Amazon data
If you have both Amazon and owned Ecommerce data in Daasity, you'll need to filter for the asc
source name to only show data from Amazon
Explores
Order Line Revenue
Transactional Sales
Daily Plan to Actual
Daily Company Metrics
Lifetime Value Time Series
Dashboards
LTV & RFM
Retention
Orders & Revenue
Daily Flash
Daily Flash vs Plan
Hourly Flash
Weekly Flash
Repurchase Rates
Product (Except for the Product Detail Page Performance, which uses the Sales and Traffic Business Report)
Raw data tables
AMAZON_SELLER_CENTRAL.GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL
How to validate this data
Known causes for discrepancies
The data you see in your Daasity reporting will vary slightly from the raw All Orders reports you download from the Amazon Seller Central UI for the following reasons:
Choose the Order Date report when comparing data with Daasity
When you download the All Orders report, you have the option of choosing to filter by Order Date or Last Updated Date:
If you are comparing data for a particular month between Daasity and the Amazon platform, it's best to choose the Order Date option.
Don't use the Last Updated Date option. If you're trying to compare data for orders placed in January 2024, for example, and you choose the Last Updated date option, that file could contain orders that were placed prior to January 2024. Additionally, if an order placed in January 2024 was updated in a later month, that order would not show up in that report download.
Compare gross sales in Daasity with the sum of item-price in the All Orders exports
Since the export contains and item-price column and a quantity column, you may (understandably) assume that you need to multiply item-price by quantity to get the full sales amount for the line item. In reality, item-price will reflect the sales amount for the entire line — it is not a unit price.
Amazon Business Reports
Daasity standard reports will use data from the Sales and Traffic report and the Detail Page Sales and Traffic report from Amazon.
Where to analyze this data
Amazon Sales and Traffic report
You can analyze data from the Sales and Traffic report in the following places:
Filter for Data Source = Amazon
to isolate Amazon data
If you have both Google Analytics and Amazon data connected to Daasity, you'll need to filter for the Amazon
data source to only show data from Amazon.
Explores
Traffic
Daily Plan to Actual*
Dashboards
Analytics & Attribution
Daily Flash*
Daily Flash vs Plan*
Weekly Flash*
* Only sessions from the Amazon Sales and Traffic report are used in these reports/explores. The sales and order data will be from the Amazon Orders by Last Updated Date fulfillment report.
Raw data tables
AMAZON_SELLER_CENTRAL.SALES_AND_TRAFFIC_REPORT
Amazon Detail Page Sales and Traffic report
You can analyze data from the Detail Page Sales and Traffic report in the following places:
Filter for Data Source = Amazon
to isolate Amazon data
If you have both Google Analytics and Amazon data connected to Daasity, you'll need to filter for the Amazon
data source to only show data from Amazon.
Explores
Product Page
Dashboards
Product (Only the Product Detail Page Performance tile)
Raw data tables
AMAZON_SELLER_CENTRAL.SALES_AND_TRAFFIC_SKU_REPORT
Known causes for discrepancies
Where this data is used in standard reports (listed in the previous section), it should match the UI exactly, except for any updates that have been made to orders since the data was extracted. For example, if we extract and transform the data at 1AM, there may be some changes between that time and when you analyze the data in the morning that will not be reflected in the Daasity reports.
However, when if you compare data from the Amazon Business Reports with other order-based reporting in Daasity (e.g.: Order Line Revenue, Transactional Sales, Daily Plan to Actual), there will be discrepancies for the following reasons:
Last updated