This page is about how Daasity replicates data from Seller Retail Analytics section of the Amazon Selling Partner Reports API, limitations to the data we can extract and where the data is stored.
Last updated
Was this helpful?
The Daasity Amazon Seller Central integrations utilize the Selling Partner API (SP-API) which is a REST-based API that helps Amazon selling partners programmatically access their data on orders, shipments, payments, and more.
1-day data delay
If you are looking at your extracted data and see that there is no data from yesterday, this is expected. This is because there is a 1-day delay for Seller Retail Analytics data to be available for extraction. For example, data from 1/1/2023 would not be loaded until 1/3/2023.
This integration is available for:
Enterprise
Growth
The Daasity Amazon Seller Central - Reports API - Seller Retail Analytics extractor is built based on this . The following endpoints are used by Daasity to replicate data from Amazon Seller Central:
The Reports API will generate files in one of three formats (CSV, XML, and JSON). A report might vary slightly for each Seller Central account and thus Daasity will dynamically create the table based on the file extracted from Amazon. Thus each table will be a direct mapping from the file output to the table with no transformation.
This report provides key sales performance metrics such as ordered product sales, revenue, units ordered, and claim amount, as well as overall traffic to your Amazon pages.
Update Method: UPSERT
Table Name:
[AMAZON_SELLER_CENTRAL.GET_SALES_AND_TRAFFIC_REPORT]
This report provides key sales performance metrics such as ordered product sales, revenue, units ordered, as well as page traffic metrics such as page views and buy box percentage of the seller’s entire catalog of items aggregated by date and Parent ASIN.
Update Method: UPSERT
Table Name:
[AMAZON_SELLER_CENTRAL.SALES_AND_TRAFFIC_PARENT_ASIN_REPORT]
This report provides key sales performance metrics such as ordered product sales, revenue, units ordered, as well as page traffic metrics such as page views and buy box percentage of the seller’s entire catalog of items aggregated by date and SKU.
Update Method: UPSERT
Table Name:
[AMAZON_SELLER_CENTRAL.SALES_AND_TRAFFIC_SKU_REPORT]
This report provides key sales performance metrics such as ordered product sales, revenue, units ordered, as well as page traffic metrics such as page views and buy box percentage of the seller’s entire catalog of items aggregated by date and Child ASIN.
Update Method: UPSERT
Table Name:
[AMAZON_SELLER_CENTRAL.SALES_AND_TRAFFIC_CHILD_ASIN_REPORT]
illustrating the different tables and keys to join across tables.
Endpoint:
The Brand Analytics feature availability is determined by Amazon. Not sure? Reach out to
Before making a request for a historical report, reach out to
Endpoint:
The Brand Analytics feature availability is determined by Amazon. Not sure? Reach out to
Before making a request for a historical report, reach out to
Endpoint:
The Brand Analytics feature availability is determined by Amazon. Not sure? Reach out to
Before making a request for a historical report, reach out to
Endpoint:
The Brand Analytics feature availability is determined by Amazon. Not sure? Reach out to
Before making a request for a historical report, reach out to
