Integration: Amazon Seller Central - Reports API - Seller Retail Analytics

This article will help you learn 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 in the Amazon Seller Central schema

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration:

Integration Overview

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.

Integration Availability

This integration is available for:

  • Pro V2

NOTE: You are considered V2 if...

  • Your account says Pro V2 in the Daasity App

Not sure? Reach out to Support@Daasity.com

API Endpoints

The Daasity Amazon Seller Central - Reports API - Seller Retail Analytics extractor is built based on this Amazon Seller Central API documentation. The following endpoints are used by Daasity to replicate data from Amazon Seller Central:

Entity Relationship Diagram (ERD)

The embedded diagram houses the ERD for the Daasity Amazon Seller Central - Reports API - Seller Retail Analytics integration illustrating the different tables and keys to join across tables. Hover over the embedded diagram to reveal controls to zoom and scroll.

Amazon Seller Central Schema

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.

Sales and Traffic Business Report

  • 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.
  • Endpoint: Seller Retail Analytics Reports
  • Update Method: UPSERT
  • Table Name: 
    AMAZON_SELLER_CENTRAL.GET_SALES_AND_TRAFFIC_REPORT

Limitations:

  • This feature can only be requested if Brand Analytics is turned on.
    • The Brand Analytics feature availability is determined by Amazon. Not sure? Reach out to Support@Daasity.com
  • Data updates every 24 hours
    • Requesting for historical data will take a long time.

    Sales and Traffic Parent 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.
    • Endpoint: Seller Retail Analytics Reports
    • Update Method: UPSERT
    • Table Name: 
      AMAZON_SELLER_CENTRAL.SALES_AND_TRAFFIC_PARENT_ASIN_REPORT

    Limitations:

    • This feature can only be requested if Brand Analytics is turned on.
      • The Brand Analytics feature availability is determined by Amazon. Not sure? Reach out to Support@Daasity.com
    • Data updates every 24 hours
    • Requesting for historical data will take a long time.

    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 SKU.
    • Endpoint: Seller Retail Analytics Reports
    • Update Method: UPSERT
    • Table Name: 
      AMAZON_SELLER_CENTRAL.SALES_AND_TRAFFIC_SKU_REPORT

    Limitations:

    • This feature can only be requested if Brand Analytics is turned on.
      • The Brand Analytics feature availability is determined by Amazon. Not sure? Reach out to Support@Daasity.com
    • Data updates every 24 hours
    • Requesting for historical data will take a long time.

     

    Sales and Traffic Child 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.
    • Endpoint: Seller Retail Analytics Reports
    • Update Method: UPSERT
    • Table Name: 
      AMAZON_SELLER_CENTRAL.SALES_AND_TRAFFIC_CHILD_ASIN_REPORT

    Limitations:

    • This feature can only be requested if Brand Analytics is turned on.
      • The Brand Analytics feature availability is determined by Amazon. Not sure? Reach out to Support@Daasity.com
    • Data updates every 24 hours
    • Requesting for historical data will take a long time.

    Related Resources