What Report Granularities Does Amazon Provide, and How Does It Affect Your Data Analysis?

Amazon's SP API provides daily to yearly report options for business insights. Note the 72-hour delay and potential deviations affecting metrics like Year-to-Date figures.

Amazon's Selling Partner API is a powerful tool that empowers sellers to access critical data and insights about their business operations. One of the key features of this API is the ability to generate detailed reports with varying granularities, allowing sellers to track their performance over different time frames. In this article, we'll explore the different report granularities available through the Amazon Selling Partner API and understand how they can be used to gain valuable insights into your business.

Report Granularities in Amazon Retail Analytics (ARA):

  1. Daily Granularity:

    • Example: "Ordered Revenue on a Specific Day"
    • This report provides a detailed breakdown of your sales, including revenue, orders, and other metrics for a specific day. It's ideal for tracking daily performance and identifying trends or anomalies on a day-to-day basis.
  2. Weekly Granularity:

    • Example: "Ordered Revenue of a Certain Week"
    • The weekly granularity report aggregates data for a specific week, allowing sellers to assess their business's performance over a broader time frame. It's particularly useful for identifying weekly trends and making informed decisions accordingly.
  3. Monthly Granularity:

    • Example: "Ordered Revenue of a Certain Month"
    • Monthly reports offer an overview of your sales and performance metrics for a particular month. This level of granularity is suitable for tracking monthly growth, setting goals, and analyzing seasonality.
  4. Quarterly Granularity:

    • Example: "Ordered Revenue of a Certain Quarter"
    • Quarterly reports provide insights into how your business performed during a specific quarter. This longer time frame is essential for assessing your business's performance over a three-month period and making strategic decisions accordingly.
  5. Yearly Granularity:

    • Example: "Ordered Revenue of a Specific Year"
    • Yearly reports offer a high-level overview of your business's performance for an entire year. They are invaluable for tracking annual growth, evaluating long-term strategies, and understanding the overall health of your business.

Please be aware that all reports accessible through the Selling Partner API are subject to a minimum delay of 72 hours. This means that the data you access may not be entirely current and should be considered with this delay in mind.

Understanding Deviations:

It's important to note that each of these reports stands alone. Due to data processing and latencies during updates, deviations between the reports are to be expected. For instance, if you aggregate all 30 daily sales reports for September 2023, the result may differ from the monthly report for the same period. These discrepancies can occur due to various reasons, including order cancellations, returns, and data processing delays.

Owing to variations in the report granularities mentioned above, it's important to recognize that these distinctions also have a ripple effect on downstream metrics that are derived from these reports, such as Year-to-Date (YTD) figures.

Report Granularities in Amazon Sponsored Ads and DSP:

In stark contrast to the complexity of ARA reports, SpAds and DSP APIs offer data exclusively on a daily basis, streamlining data aggregation. This flexibility allows you to choose your reporting period without worrying about granularity constraints.

Understanding Deviations:

While the Hub and Amazon Ads Console may not always be perfectly synchronized, this should not be cause for concern. According to Amazon's Documentation deviations of up to 5% are anticipated, allowing for reasonable variations.

 

If you're still feeling unsure about something, feel free to reach out to us. We're here and happy to assist! 

Take a look at the article 📖 to find out how you can get in touch with us and what you should have prepared to help us resolve your issue quickly.