Ecommerce Dataset (Shopper Intelligence)
This Batch API dataset helps companies monitor consumer demand, analyze shopper behavior, and optimize search strategies to win in the Ecommerce world.
Historical Data Availability
Access 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
- Categories: Sales performance metrics at the category level including views, revenue, and conversion rates
- Brands: Brand-level performance across categories with 1P/3P seller breakdowns
- Products: Top-performing products with detailed metrics including ratings and reviews
- Top Brands in Category: Competitive brand analysis within specific categories
- Top Products in Category: Product performance rankings and metrics
- Product Keyword Analysis: Search traffic and click analysis for product keywords
- Top Keywords in Category: Category-level keyword performance and brand share
- Top Products in Brands: Brand-specific product performance analysis
- Top Keywords in Brands: Brand-level keyword performance and click share
API Key Requirements
Batch API and REST API use different authentication keys. Ensure you're using your Batch API key for these requests.
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
Include your Batch API key in the request headers:
curl --location 'https://api.similarweb.com/batch/v4/request-report' \
--header 'api-key: {{API_KEY}}' \
--header 'Content-Type: application/json' \
--request POST \
--data body
2. Request Structure
All Ecommerce Dataset requests follow this structure:
🦉
Batch API Request - Step-by-Step Walkthrough
Open Recipe
Available Tables (vtables)
Amazon Categories (amazon_category_sales)
amazon_category_sales)Primary use case: Provides comprehensive sales metrics for Amazon categories including revenue, units sold, and conversion rates.
Table URL: https://api.similarweb.com/v3/batch/amazon_category_sales/request-report
Primary Keys: domain, category_id
Available Metrics:
| Metric Name | Description | Supported Granularity |
|---|---|---|
amazon_category_sales_product_views | Number of unique product views for the selected domain and category | Monthly, Weekly |
amazon_category_sales_revenue | Amount of revenue generated by the selected domain and category | Monthly, Weekly |
amazon_category_sales_units_sold | Number of units sold in the selected domain and category | Monthly, Weekly |
amazon_category_sales_cvr | Conversion rate calculated by dividing unique purchases by product views | Monthly, Weekly |
amazon_category_sales_revenue_1P | Revenue generated by first-party sales | Monthly, Weekly |
amazon_category_sales_units_sold_1P | Units sold by first-party sales | Monthly, Weekly |
amazon_category_sales_revenue_3P | Revenue generated by third-party sales | Monthly, Weekly |
amazon_category_sales_units_sold_3P | Units sold by 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 here
Example Request
curl --location 'https://api.similarweb.com/v3/batch/amazon_category_sales/request-report' \
--header 'api-key: {{API_KEY}}' \
--header 'Content-Type: application/json' \
--data '{
"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)
amazon_brand_sales)Primary use case: Tracks brand performance metrics across categories with detailed seller type breakdowns.
Table URL: https://api.similarweb.com/v3/batch/amazon_brand_sales/request-report
Primary Keys: domain, brand, category_id
Available Metrics:
| Metric Name | Description | Supported Granularity |
|---|---|---|
amazon_brand_sales_product_views | Number of unique product views for the selected domain and brand | Monthly, Weekly |
amazon_brand_sales_revenue | Amount of revenue generated by the selected domain and brand | Monthly, Weekly |
amazon_brand_sales_units_sold | Number of units sold in the selected domain and brand | Monthly, Weekly |
amazon_brand_sales_cvr | Conversion rate calculated by dividing unique purchases by product views | Monthly, Weekly |
amazon_brand_sales_revenue_1P | Revenue generated by first-party sales | Monthly, Weekly |
amazon_brand_sales_units_sold_1P | Units sold by first-party sales | Monthly, Weekly |
amazon_brand_sales_revenue_3P | Revenue generated by third-party sales | Monthly, Weekly |
amazon_brand_sales_units_sold_3P | Units sold by third-party sales | Monthly, Weekly |
amazon_brand_sales_category | Name of the selected category | Monthly, Weekly |
Available Brands
Check the full list of available Amazon brands here
Example Request
curl --location 'https://api.similarweb.com/v3/batch/amazon_brand_sales/request-report' \
--header 'api-key: {{API_KEY}}' \
--header 'Content-Type: application/json' \
--data '{
"delivery_information": {
"response_format": "json"
},
"report_query": {
"tables": [
{
"vtable": "amazon_brand_sales",
"granularity": "monthly",
"latest": true,
"filters": {
"domains": ["amazon.com"],
"brands": ["Nike"],
"category_ids": [-1]
},
"metrics": [
"amazon_brand_sales_units_sold",
"amazon_brand_sales_revenue",
"amazon_brand_sales_units_sold_1P",
"amazon_brand_sales_units_sold_3P",
"amazon_brand_sales_revenue_1P",
"amazon_brand_sales_revenue_3P",
"amazon_brand_sales_category",
"amazon_brand_sales_cvr",
"amazon_brand_sales_product_views"
]
}
]
}
}'
Top Brands in Category (amazon_top_brand_sales_by_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/v3/batch/amazon_top_brand_sales_by_category/request-report
Primary Keys: domain, category_id, brand
Available Metrics:
| Metric Name | Description | Supported Granularity |
|---|---|---|
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 (up to 80 brands) | Monthly, Weekly |
amazon_top_brand_sales_by_category_units_sold | Units sold for top brands (up to 80 brands) | Monthly, Weekly |
amazon_top_brand_sales_by_category_cvr | Conversion rate for top brands | Monthly, Weekly |
Example Request
curl --location 'https://api.similarweb.com/v3/batch/amazon_top_brand_sales_by_category/request-report' \
--header 'api-key: {{API_KEY}}' \
--header 'Content-Type: application/json' \
--data '{
"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)
amazon_top_product_sales_by_category)Primary use case: Provides detailed metrics for top-performing products within categories, including reviews and ratings.
Table URL: https://api.similarweb.com/v3/batch/amazon_top_product_sales_by_category/request-report
Primary Keys: domain, category_id, asin
Available Metrics:
| Metric Name | Description | Supported Granularity |
|---|---|---|
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 | Leaf category ID | Monthly, Weekly |
amazon_top_product_sales_by_category_leaf_category_name | Leaf category name | Monthly, Weekly |
amazon_top_product_sales_by_category_leaf_category_depth | Leaf category depth | Monthly, Weekly |
Example Request
curl --location 'https://api.similarweb.com/v3/batch/amazon_top_product_sales_by_category/request-report' \
--header 'api-key: {{API_KEY}}' \
--header 'Content-Type: application/json' \
--data '{
"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_category_name",
"amazon_top_product_sales_by_category_category_depth",
"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",
"amazon_top_product_sales_by_category_parent_asin",
"amazon_top_product_sales_by_category_leaf_category_id",
"amazon_top_product_sales_by_category_leaf_category_name",
"amazon_top_product_sales_by_category_leaf_category_depth"
]
}
]
}
}'
Top Products in Brands (amazon_top_product_sales_by_brand_and_category)
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/v3/batch/amazon_top_product_sales_by_brand_and_category/request-report
Primary Keys: domain, brands
Available Metrics:
| Metric Name | Description | Supported Granularity |
|---|---|---|
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 | Leaf category ID | Monthly, Weekly |
amazon_top_product_sales_by_brand_and_category_leaf_category_name | Leaf category name | Monthly, Weekly |
amazon_top_product_sales_by_brand_and_category_leaf_category_depth | Leaf category depth | Monthly, Weekly |
Example Request
curl --location 'https://api.similarweb.com/v3/batch/amazon_top_product_sales_by_brand_and_category/request-report' \
--header 'api-key: {{API_KEY}}' \
--header 'Content-Type: application/json' \
--data '{
"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",
"amazon_top_product_sales_by_brand_and_category_parent_asin",
"amazon_top_product_sales_by_brand_and_category_leaf_category_id",
"amazon_top_product_sales_by_brand_and_category_leaf_category_name",
"amazon_top_product_sales_by_brand_and_category_leaf_category_depth"
]
}
]
}
}'
Product Keyword Analysis (amazon_product_on_site_search_traffic_by_keyword)
amazon_product_on_site_search_traffic_by_keyword)Primary use case: Provides detailed keyword performance metrics for products including organic and paid search traffic.
Table URL: https://api.similarweb.com/v3/batch/amazon_product_on_site_search_traffic_by_keyword/request-report
Primary Keys: domain, keyword, asin
Available Metrics:
| Metric Name | Description | Supported Granularity |
|---|---|---|
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 keyword | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_keyword_paid_clicks | Total sponsored clicks for 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 if 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 | Leaf category ID | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_leaf_category_name | Leaf category name | Monthly, Weekly |
amazon_product_on_site_search_traffic_by_keyword_leaf_category_depth | Leaf category depth | Monthly, Weekly |
Example Request
curl --location 'https://api.similarweb.com/v3/batch/amazon_product_on_site_search_traffic_by_keyword/request-report' \
--header 'api-key: {{API_KEY}}' \
--header 'Content-Type: application/json' \
--data '{
"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_avg_ranking",
"amazon_product_on_site_search_traffic_by_keyword_organic_top10_appearances",
"amazon_product_on_site_search_traffic_by_keyword_organic_p1_appearances",
"amazon_product_on_site_search_traffic_by_keyword_organic_p2_appearances",
"amazon_product_on_site_search_traffic_by_keyword_brand",
"amazon_product_on_site_search_traffic_by_keyword_leaf_category_id",
"amazon_product_on_site_search_traffic_by_keyword_avg_organic_ranking",
"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_product_asin_paid_clicks",
"amazon_product_on_site_search_traffic_by_keyword_asin_organic_clicks",
"amazon_product_on_site_search_traffic_by_keyword_keyword_paid_clicks",
"amazon_product_on_site_search_traffic_by_keyword_keyword_organic_clicks",
"amazon_product_on_site_search_traffic_by_keyword_paid_clicks",
"amazon_product_on_site_search_traffic_by_keyword_organic_clicks",
"amazon_product_on_site_search_traffic_by_keyword_search_volume",
"amazon_product_on_site_search_traffic_by_keyword_parent_asin",
"amazon_product_on_site_search_traffic_by_keyword_leaf_category_id",
"amazon_product_on_site_search_traffic_by_keyword_leaf_category_name",
"amazon_product_on_site_search_traffic_by_keyword_leaf_category_depth"
]
}
]
}
}'
Top Keywords in Category (amazon_category_on_site_search_traffic)
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/v3/batch/amazon_category_on_site_search_traffic/request-report
Primary Keys: domain, category, keyword
Available Metrics:
| Metric Name | Description | Supported Granularity |
|---|---|---|
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 |
Example Request
curl --location 'https://api.similarweb.com/v3/batch/amazon_category_on_site_search_traffic/request-report' \
--header 'api-key: {{API_KEY}}' \
--header 'Content-Type: application/json' \
--data '{
"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)
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/v3/batch/amazon_brand_on_site_search_traffic/request-report
Primary Keys: domain, category_id, brands
Available Metrics:
| Metric Name | Description | Supported Granularity |
|---|---|---|
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 |
Example Request
curl --location 'https://api.similarweb.com/v3/batch/amazon_brand_on_site_search_traffic/request-report' \
--header 'api-key: {{API_KEY}}' \
--header 'Content-Type: application/json' \
--data '{
"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_clicks",
"amazon_on_site_search_traffic_organic_clicks_share",
"amazon_on_site_search_traffic_paid_clicks_share",
"amazon_on_site_search_traffic_total_clicks",
"amazon_on_site_search_traffic_brand_share"
]
}
]
}
}'
Data Retention
The download link will remain valid for 30 days. We recommend saving these for a certain time period just in case you will need our assistance to troubleshoot any issue that may occur.
Updated 11 days ago