All Collections
Data Sources
Amazon Catalog Keyword Tracker
Amazon Catalog Keyword Tracker
Openbridge Support avatar
Written by Openbridge Support
Updated over a week ago

The Amazon Catalog Keyword Tracker is a comprehensive dataset providing detailed insights into how products are cataloged and ranked on Amazon with respect to specific keywords.

This data is crucial for understanding product visibility, search relevance, and competitive positioning on Amazon's platform.

Keyword Data

Each file in the dataset serves a unique purpose, focusing on different aspects of product listings and their attributes in relation to keywords. Here's an overview of each file and the types of analysis they enable:

1. Catalog Items by Keywords Vendor Details (sp_catalog_items_by_keywords_vendor_details)

  • Description: This file could contain information about the vendors or sellers associated with each product that appears for a given keyword. (Vendor Central Only)

  • Schema: Vendor ID, Vendor Name, Product ID, Keyword.

  • Analysis: Understanding the diversity of vendors for specific keywords, vendor dominance in certain keyword spaces, and potential opportunities for new vendors.

2. Catalog Items by Keywords Summaries (sp_catalog_items_by_keywords_summaries)

  • Description: Summarizes the products that appear for specific keywords, possibly including metrics like search frequency rank, average rating, review counts, and price ranges.

  • Schema: Keyword, Product ID, Search Frequency Rank, Average Rating, Review Count, Price Range.

  • Analysis: Identifying top products for keywords, evaluating competitiveness, and analyzing customer preferences based on ratings and reviews.

3. Catalog Items by Keywords Sales Ranks (sp_catalog_items_by_keywords_sales_ranks)

  • Description: Contains sales rank information of products for given keywords, which helps understand how well products are selling within certain categories.

  • Schema: Product ID, Keyword, Sales Rank, Category.

  • Analysis: Sales performance analysis, category trends, and identifying high-demand products.

4. Catalog Items by Keywords Relationships (sp_catalog_items_by_keywords_relationships)

  • Description**: Details on product relationships, such as bundle packages or complementary products associated with primary products for specific keywords.

  • Schema: Primary Product ID, Related Product ID, Keyword, Relationship Type.

  • Analysis: Exploring cross-selling and upselling opportunities, bundle strategy effectiveness.

5. Catalog Items by Keywords Product Types (sp_catalog_items_by_keywords_product_types)

  • Description: Information on the types of products (e.g., electronics, clothing) that appear for certain keywords.

  • Schema**: Product ID, Keyword, Product Type.

  • Analysis: Product assortment analysis, identifying gaps in product offerings, strategic product type placements.

6. Catalog Items by Keywords Images (sp_catalog_items_by_keywords_images)

  • Description: Contains URLs or references to images for products associated with specific keywords.

  • Schema: Product ID, Keyword, Image URL.

  • Analysis: Visual content analysis, image quality assessment, correlation between image characteristics and product performance.

7. Catalog Items by Keywords Identifiers (sp_catalog_items_by_keywords_identifiers)

  • Description: Likely provides unique identifiers for products, such as ASINs, UPCs, or ISBNs, associated with keywords.

  • Schema: Product ID, Keyword, Identifier Type, Identifier Value.

  • Analysis: Product tracking, catalog integrity checks, duplicate detection.

8. Catalog Items by Keywords Dimensions (sp_catalog_items_by_keywords_dimensions)

  • Description: Details on product dimensions, weight, and possibly packaging information for items under certain keywords.

  • Schema: Product ID, Keyword, Dimension Type, Measurement.

  • Analysis: Shipping cost analysis, product size distribution, and storage optimization.

Each of these files can be analyzed individually or in combination to gain insights into product visibility, competitive analysis, market trends, and strategic positioning on Amazon.

Understanding how products are associated with keywords allows businesses to optimize their listings, improve search relevance, and enhance their overall sales strategy on the platform.


Currently, each subscription can support 100 ASINs per Seller or Vendor account as we look to optimize for the Amazon limits. We hope to raise this higher as we observe the performance of Amazon's system.


Data is collected as daily snapshots, meaning Amazon provides the information as of that point in time when we request the data each hour. We can not request historical data as Amazon does not support requesting a snapshot of catalog data on a given date, like 9/13/23. However, over time, you will build your own historical snapshots, which accrue value the longer you collect the data.

Did this answer your question?