Ecommerce Dataset (Shopper Intent)
This Batch API dataset helps companies monitor consumer demand, analyze shopper behavior, and optimize search strategies for the ecommerce world.
Historical Data Availability: Up to 36 months of historical data, depending on your subscription plan and the data table (some are limited to 24 months).
What you can track
- Sales performance — Track Amazon sales with views, units sold, and revenue, broken down by 1P/3P. Dive into product-level pricing, ratings, and reviews.
- On-site search — Amazon search data including volume, rankings, and clicks, with paid/organic and branded/generic breakdowns.
- Categories — Sales performance metrics at the category level including views, revenue, and conversion rates.
- Brands — Brand-level performance across categories with 1P/3P breakdowns.
- Products — Top-performing products with detailed metrics including ratings and reviews.
- Top brands in category / Top products in category — Competitive analysis within specific categories.
- Product keyword analysis / Top keywords in category / Top products and keywords in brands — Search and click analysis at multiple levels.
🔍 How to find category and brand names?
Browse the full list of supported Amazon categories and brands we currently offer in this detailed guide: Available Amazon Categories and Brands.
Getting started
1. Authentication
curl --location 'https://api.similarweb.com/batch/v5/request-report' \
--header 'api-key: {{API_KEY}}' \
--header 'Content-Type: application/json' \
--request POST \
--data body
Available tables (vtables)
Amazon Categories (amazon_category_sales)
Table URL: https://api.similarweb.com/v3/batch/amazon_category_sales/request-report
Primary keys: domain, category_id
amazon_category_sales_product_views | Unique product views for the selected domain and category. | Monthly, Weekly |
amazon_category_sales_revenue | Revenue generated by the selected domain and category. | Monthly, Weekly |
amazon_category_sales_units_sold | Units sold in the selected domain and category. | Monthly, Weekly |
amazon_category_sales_cvr | Conversion rate (purchases / product views). | Monthly, Weekly |
amazon_category_sales_revenue_1P / amazon_category_sales_revenue_3P | Revenue from first-party and third-party sales. | Monthly, Weekly |
amazon_category_sales_units_sold_1P / amazon_category_sales_units_sold_3P | Units sold by first-party and third-party sales. | Monthly, Weekly |
amazon_sales_category | Name of the selected category. | Monthly, Weekly |
Available Categories
Check the full list of available Amazon categories on the Available Amazon Categories and Brands page.
{
"delivery_information": {"response_format": "csv"},
"report_query": {
"tables": [{
"vtable": "amazon_category_sales",
"granularity": "monthly",
"latest": true,
"filters": {"domains": ["amazon.com"], "category_ids": [-1]},
"metrics": [
"amazon_category_sales_product_views",
"amazon_category_sales_units_sold",
"amazon_category_sales_revenue",
"amazon_category_sales_units_sold_1P","amazon_category_sales_units_sold_3P",
"amazon_category_sales_revenue_1P","amazon_category_sales_revenue_3P",
"amazon_sales_category","amazon_category_sales_cvr"
]
}]
}
}
Amazon Brands (amazon_brand_sales)
Table URL: https://api.similarweb.com/v5/batch/amazon_brand_sales/request-report
Primary keys: domain, brand, category_id
Tracks brand performance metrics across categories with detailed seller-type breakdowns. Available metrics mirror the categories table but use amazon_brand_sales_* prefixes (product_views, revenue, units_sold, cvr, revenue_1P, revenue_3P, units_sold_1P, units_sold_3P, category). Granularity: Monthly, Weekly.
Available Brands
Check the full list of available Amazon brands on the Available Amazon Categories and Brands page.
Top Brands in Category (amazon_top_brand_sales_by_category)
Primary use case: Returns up to 80 top-performing brands within a category with their key metrics.
Table URL: https://api.similarweb.com/v5/batch/amazon_top_brand_sales_by_category/request-report
Primary keys: domain, category_id, brand
amazon_top_brand_sales_by_category_product_views | Unique product views for top brands (up to 80 brands). | Monthly, Weekly |
amazon_top_brand_sales_by_category_revenue | Revenue generated by top brands. | Monthly, Weekly |
amazon_top_brand_sales_by_category_units_sold | Units sold for top brands. | Monthly, Weekly |
amazon_top_brand_sales_by_category_cvr | Conversion rate for top brands. | Monthly, Weekly |
{
"delivery_information": {"response_format": "json"},
"report_query": {
"tables": [{
"vtable": "amazon_top_brand_sales_by_category",
"granularity": "monthly",
"latest": true,
"filters": {"domains": ["amazon.com"], "brands": ["Nike"], "category_ids": [-1]},
"metrics": [
"amazon_top_brand_sales_by_category_revenue",
"amazon_top_brand_sales_by_category_product_views",
"amazon_top_brand_sales_by_category_cvr",
"amazon_top_brand_sales_by_category_units_sold"
]
}]
}
}
Top Products in Category (amazon_top_product_sales_by_category)
Primary use case: Detailed metrics for top-performing products within categories, including reviews and ratings.
Table URL: https://api.similarweb.com/v5/batch/amazon_top_product_sales_by_category/request-report
Primary keys: domain, category_id, asin
amazon_top_product_sales_by_category_product_views | Unique views for top products. | Monthly, Weekly |
amazon_top_product_sales_by_category_revenue | Revenue generated by top products. | Monthly, Weekly |
amazon_top_product_sales_by_category_units_sold | Units sold for top products. | Monthly, Weekly |
amazon_top_product_sales_by_category_average_unit_price | Average unit price of top products. | Monthly, Weekly |
amazon_top_product_sales_by_category_reviews | Number of reviews for top products. | Monthly, Weekly |
amazon_top_product_sales_by_category_rating | Rating of top products. | Monthly, Weekly |
amazon_top_product_sales_by_category_asin_name | ASIN names of top products. | Monthly, Weekly |
amazon_top_product_sales_by_category_brand | Brands associated with top products. | Monthly, Weekly |
amazon_top_product_sales_by_category_category_name | Category names associated with products. | Monthly, Weekly |
amazon_top_product_sales_by_category_category_depth | Taxonomy depth of categories. | Monthly, Weekly |
amazon_top_product_sales_by_category_parent_asin | Parent ASIN ID. | Monthly, Weekly |
amazon_top_product_sales_by_category_leaf_category_id / _name / _depth | Leaf-category attributes. | Monthly, Weekly |
{
"delivery_information": {"response_format": "csv"},
"report_query": {
"tables": [{
"vtable": "amazon_top_product_sales_by_category",
"granularity": "monthly",
"latest": true,
"filters": {"domains": ["amazon.com"], "category_ids": [-1]},
"metrics": [
"amazon_top_product_sales_by_category_units_sold",
"amazon_top_product_sales_by_category_revenue",
"amazon_top_product_sales_by_category_product_views",
"amazon_top_product_sales_by_category_average_unit_price",
"amazon_top_product_sales_by_category_brand",
"amazon_top_product_sales_by_category_asin_name",
"amazon_top_product_sales_by_category_rating",
"amazon_top_product_sales_by_category_reviews"
]
}]
}
}
Top Products in Brands (amazon_top_product_sales_by_brand_and_category)
Primary use case: Analyzes top products for specific brands across categories.
Table URL: https://api.similarweb.com/v5/batch/amazon_top_product_sales_by_brand_and_category/request-report
Primary keys: domain, brands
amazon_top_product_sales_by_brand_and_category_product_views | Unique views for top products by brand. | Monthly, Weekly |
amazon_top_product_sales_by_brand_and_category_revenue | Revenue generated by brand's top products. | Monthly, Weekly |
amazon_top_product_sales_by_brand_and_category_units_sold | Units sold for brand's top products. | Monthly, Weekly |
amazon_top_product_sales_by_brand_and_category_average_unit_price | Average unit price of brand's products. | Monthly, Weekly |
amazon_top_product_sales_by_brand_and_category_reviews | Number of reviews for brand's products. | Monthly, Weekly |
amazon_top_product_sales_by_brand_and_category_rating | Rating of brand's products. | Monthly, Weekly |
amazon_top_product_sales_by_brand_and_category_asin_name | ASIN names of products. | Monthly, Weekly |
amazon_top_product_sales_by_brand_and_category_category_name | Category names. | Monthly, Weekly |
amazon_top_product_sales_by_brand_and_category_parent_asin | Parent ASIN ID. | Monthly, Weekly |
amazon_top_product_sales_by_brand_and_category_leaf_category_id / _name / _depth | Leaf-category attributes. | Monthly, Weekly |
{
"delivery_information": {"response_format": "csv"},
"report_query": {
"tables": [{
"vtable": "amazon_top_product_sales_by_brand_and_category",
"granularity": "monthly",
"latest": true,
"filters": {"domains": ["amazon.com"], "brands": ["Nike"], "category_ids": [-1]},
"metrics": [
"amazon_top_product_sales_by_brand_and_category_category_name",
"amazon_top_product_sales_by_brand_and_category_asin_name",
"amazon_top_product_sales_by_brand_and_category_units_sold",
"amazon_top_product_sales_by_brand_and_category_rating",
"amazon_top_product_sales_by_brand_and_category_reviews",
"amazon_top_product_sales_by_brand_and_category_average_unit_price",
"amazon_top_product_sales_by_brand_and_category_product_views",
"amazon_top_product_sales_by_brand_and_category_revenue"
]
}]
}
}
Product Keyword Analysis (amazon_product_on_site_search_traffic_by_keyword)
Primary use case: Detailed keyword performance metrics for products including organic and paid search traffic.
Table URL: https://api.similarweb.com/v5/batch/amazon_product_on_site_search_traffic_by_keyword/request-report
Primary keys: domain, keyword, asin
amazon_product_on_site_search_traffic_by_keyword_brand | Brand associated with the product's ASIN. | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_search_volume | Total searches for the keyword. | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_organic_clicks | Organic search clicks on the product. | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_paid_clicks | Sponsored search clicks on the product. | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_keyword_organic_clicks | Total organic clicks for the keyword. | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_keyword_paid_clicks | Total sponsored clicks for the keyword. | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_asin_organic_clicks | Aggregate organic clicks for main ASIN. | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_product_asin_paid_clicks | Aggregate sponsored clicks for main ASIN. | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_branded | Indicates whether the keyword is brand-specific. | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_avg_organic_ranking | Average organic ranking position. | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_total_clicks | Combined organic and sponsored clicks. | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_parent_asin | Parent ASIN ID. | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_leaf_category_id / _name / _depth | Leaf-category attributes. | Monthly, Weekly |
{
"delivery_information": {"response_format": "csv"},
"report_query": {
"tables": [{
"vtable": "amazon_product_on_site_search_traffic_by_keyword",
"granularity": "monthly",
"latest": true,
"filters": {"domains": ["amazon.com"], "keywords": ["shoes"]},
"metrics": [
"amazon_product_on_site_search_traffic_by_keyword_brand",
"amazon_product_on_site_search_traffic_by_keyword_search_volume",
"amazon_product_on_site_search_traffic_by_keyword_organic_clicks",
"amazon_product_on_site_search_traffic_by_keyword_paid_clicks",
"amazon_product_on_site_search_traffic_by_keyword_total_clicks",
"amazon_product_on_site_search_traffic_by_keyword_branded",
"amazon_product_on_site_search_traffic_by_keyword_avg_organic_ranking"
]
}]
}
}
Top Keywords in Category (amazon_category_on_site_search_traffic)
Primary use case: Analyzes keyword performance within categories including click share and top brands.
Table URL: https://api.similarweb.com/v5/batch/amazon_category_on_site_search_traffic/request-report
Primary keys: domain, category, keyword
amazon_category_on_site_search_traffic_total_clicks | Unique clicks on products (30-min session deduplication). | Monthly, Weekly |
amazon_category_on_site_search_traffic_organic_clicks_share | Percentage of organic clicks. | Monthly, Weekly |
amazon_category_on_site_search_traffic_paid_clicks_share | Percentage of paid clicks. | Monthly, Weekly |
amazon_category_on_site_search_traffic_top_brand | Brand receiving most clicks. | Monthly, Weekly |
amazon_category_on_site_search_traffic_top_brand_share | Top brand's click share percentage. | Monthly, Weekly |
{
"delivery_information": {"response_format": "csv"},
"report_query": {
"tables": [{
"vtable": "amazon_category_on_site_search_traffic",
"granularity": "monthly",
"latest": true,
"filters": {"domains": ["amazon.com"], "category_ids": [-1]},
"metrics": [
"amazon_category_on_site_search_traffic_total_clicks",
"amazon_category_on_site_search_traffic_top_brand_share",
"amazon_category_on_site_search_traffic_top_brand",
"amazon_category_on_site_search_traffic_paid_clicks_share",
"amazon_category_on_site_search_traffic_organic_clicks_share"
]
}]
}
}
Top Keywords in Brands (amazon_brand_on_site_search_traffic)
Primary use case: Tracks keyword performance for specific brands including click metrics and share analysis.
Table URL: https://api.similarweb.com/v5/batch/amazon_brand_on_site_search_traffic/request-report
Primary keys: domain, category_id, brands
amazon_on_site_search_traffic_total_clicks | Unique clicks on products (30-min session deduplication). | Monthly, Weekly |
amazon_on_site_search_traffic_brand_clicks | Unique clicks on brand's products. | Monthly, Weekly |
amazon_on_site_search_traffic_brand_share | Percentage of clicks on brand's products. | Monthly, Weekly |
amazon_on_site_search_traffic_brand_organic_clicks_share | Percentage of organic clicks on brand's products. | Monthly, Weekly |
amazon_on_site_search_traffic_brand_paid_clicks_share | Percentage of paid clicks on brand's products. | Monthly, Weekly |
{
"delivery_information": {"response_format": "csv"},
"report_query": {
"tables": [{
"vtable": "amazon_brand_on_site_search_traffic",
"granularity": "monthly",
"latest": true,
"filters": {"domains": ["amazon.com"], "brands": ["Nike"], "category_ids": [-1]},
"metrics": [
"amazon_on_site_search_traffic_total_clicks",
"amazon_on_site_search_traffic_brand_share",
"amazon_on_site_search_traffic_brand_organic_clicks_share",
"amazon_on_site_search_traffic_brand_paid_clicks_share"
]
}]
}
}
Data retention: The download link remains valid for 30 days. We recommend saving it for some time in case you need our help troubleshooting.
On this page
- Ecommerce Dataset (Shopper Intent)