Skip to main content
All CollectionsData SourcesAmazon
Brand Analytics Reports
Brand Analytics Reports

Seller and Vendor Brand Analytics Data Feed Automation

Openbridge Support avatar
Written by Openbridge Support
Updated over 2 years ago

There are three core Brand Analytics reports supported by Amazon for Sellers and Vendors;

  • GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT

  • GET_BRAND_ANALYTICS_SEARCH_TERMS_REPORT

  • GET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORT

Brand Analytics is only available to Sellers and Vendors registered in Amazon's Brand Registry. If you are unclear about what this means or the exact permissions Amazon requires, see our troubleshooting doc for more information.

Data Outputs

The outputs from the API are aligned by DAY, WEEK, MONTH, and QUARTER. As a result, there are 6 daily data outputs for each based on periods;

  • sp_ba_market_basket

  • sp_ba_repeat_purchase

  • sp_ba_search_terms_by_day

  • sp_ba_search_terms_by_month

  • sp_ba_search_terms_by_quarter

  • sp_ba_search_terms_by_week

Since the data is unified in each date output, you will need to use various columns to filter outputs. For example, in search terms, use department column to select the appropriate value. If you wanted to look at only Amazon.com, then you would use that in your query to filter the results.

Lookback Schedules

Due to the latency of changes at Amazon, as previously described, we use a LOOKBACK schedule for Brand Analytics of 1, 3, 7, and 30 days from the current date.

A lookback will also care for requests in cases where Amazon systems are unavailable. For example, Amazon says the "Daily Amazon Search Terms data processing is delayed. We are aware of the issue and actively working to resolve this delay. The dashboard will be refreshed with the latest data as soon as it is available." Openbridge will attempt to re-request a given date multiple times in these cases. For example, if search data is delayed on June 1, we will attempt to request the June 1 data on June 2, June 3rd, June 8th, and July 1.

As a result, any back updates Amazon may have made to older data would be updated. While we request older data, it may be possible that there is no new data to load for a given date.

See De-duplication and dealing with updates over a long time horizon for guidance on how to query this data.

Brand Analytics leverage the Amazon Reporting API for the report types listed above. For more details on the above report types, see Amazon's docs.

Understanding Search Terms: Data Category (Department) and Date Ranges

The data reflects the top clicked ASINs by search keyword and department for a marketplace. The data is available across different reporting periods: DAY, WEEK, MONTH, and QUARTER.

The search term data is expansive and is organized by 51 departments. Those departments have 4 date dimensions; daily, weekly, monthly, and quarterly. Here are Amazon search terms example departments available for download;

  1. Amazon.com

  2. APS

  3. AWS-APS

  4. Alexa Skills

  5. Amazon Custom

  6. AmazonBasics

  7. Arts, Crafts, and Sewing

  8. Automotive

  9. Baby

  10. Beauty

  11. Books

  12. Camera and Photo

  13. Collectibles

  14. Computers

  15. Courses

  16. Credit Cards

  17. Electronics

  18. Fresh

  19. Gift Cards

  20. Gourmet

  21. Grocery

  22. HPC

  23. Handmade

  24. Home Improvement

  25. Home and Garden

  26. Industrial and Scientific

  27. Kindle Store

  28. Launchpad

  29. Local Services

  30. MP3 Downloads

  31. Magazines and Newspapers

  32. Merchants

  33. Mobile Apps Store

  34. Movies and TV

  35. Music

  36. Musical Instruments

  37. Office Products

  38. Prime Pantry

  39. RPS

  40. Retail Help

  41. Softlines

  42. Software

  43. Sports and Outdoors

  44. Toys

  45. Uncategorized

  46. Vehicles

  47. Video Games

  48. Video On Demand

  49. Video Shorts

  50. Warehouse Deals

  51. Wireless

These departments may change over time as Amazon adjusts product offerings. The outputs from the API are dynamic, meaning whatever Amazon supplies, we will include them.

Did this answer your question?