Benchmark dataset
Use ShopifyQL to access the dataset to benchmark average order value and conversion rate metrics with similar shops defined based on product category, country, and order volume.
This page outlines the definition, type, and utility of each ShopifyQL column.
Notes about this dataset
Anchor link to section titled "Notes about this dataset"Benchmarks are created based on cohorts of shops similar to you. We define shop similarity based on a number of factors such as products that you have sold in the last 30 days, your primary market country, and order volume. Cohorts are refreshed at the start of each month.
This dataset contains only aggregate values.
This dataset is available for Plus merchants, excluding users in European countries.
Aggregates are predefined calculations of numeric values, to replicate metrics that are available throughout Shopify.
| Name | Type | Definition |
|---|---|---|
aov |
price | The average order value, which equates to gross sales (excluding adjustments) minus discounts (excluding adjustments), divided by the number of orders. |
aov_benchmark_p25 |
price | 25th percentile of average order value for shops similar to you. |
aov_benchmark_p50 |
price | 50th percentile of average order value for shops similar to you. |
aov_benchmark_p75 |
price | 75th percentile of average order value for shops similar to you. |
aov_rank |
percent | Rank of average order value in comparison to shops similar to you. |
conversion |
percent | Shop conversion rate. The conversion rate is the unique purchases made for all of the unique views in a given day. |
conversion_benchmark_p25 |
percent | 25th percentile of conversion rate for shops similar to you. |
conversion_benchmark_p50 |
percent | 50th percentile of conversion rate for shops similar to you. |
conversion_benchmark_p75 |
percent | 75th percentile of conversion rate for shops similar to you. |
conversion_rank |
percent | Rank of conversion rate in comparison to shops similar to you. |