Benchmarks Table
tw_benchmarks_table
The Benchmarks table aggregates industry-wide data to provide a comparative analysis of performance across various metrics such as average order value, conversion rates, and advertising efficiency. Querying this table lets you compare your business's performance with industry standards, identify improvement opportunities, and strategize for competitive advantage.
Note
event_dateis a required field for queries on this table.Benchmarks are available on a 1-day delay, so you should not include today's date in queries on this table.
Industry benchmarks are based on aggregated ad channel data collected by Triple Whale. To preserve anonymity, benchmark data is only shown when there are at least 20 ad channel sources that match your filter criteria.
Dimensions
Dimensions are immutable properties that can be used for grouping data.
Title | ID | Type | Description |
|---|---|---|---|
Event Date |
| date | The date the ad was run. Based on the time zone of the shop at the moment of publishing. |
Event Day |
| date | The day on which the event occurred. Derived from |
Event Week |
| date | The Sunday of the week during which the event occurred. Derived from |
Event Month |
| date | The month during which the event occurred. Derived from |
Event Quarter |
| date | The first month of the quarter during which the event occurred. Derived from |
Event Year |
| date | The year during which the event occurred. Derived from |
AOV Segment |
| string | Segment based on the median Average Order Value (AOV). Example values: |
Channel |
| string | The platform through which the ad was delivered. Example values: |
GMV Segment |
| string | Segment based on the median Gross Merchandise Value (GMV). Example values: |
Industry |
| string | The industry category of the store as set by the seller in Triple Whale admin from a pre-defined list of industries. Example values: |
Derived
Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.
Title | ID | Type | Description |
|---|---|---|---|
Median Channel-Reported AOV |
| formula | The median Average Order Value (AOV) as reported by the marketing channel. Median Channel-Reported AOV = 50th Percentile of all |
Median Channel-Reported CPA |
| formula | The median Cost Per Acquisition (CPA) as reported by the marketing channel. Median Channel-Reported CPA = 50th Percentile of all |
Median Channel-Reported CPC |
| formula | The median Cost Per Click (CPC) as reported by the marketing channel. Median Channel-Reported CPC = 50th Percentile of all |
Median Channel-Reported CPM |
| formula | The median Cost Per Mille (CPM, cost per 1,000 impressions) as reported by the marketing channel. Median Channel-Reported CPM = 50th Percentile of all |
Median Channel-Reported CTR |
| formula | The median Click-Through Rate (CTR) as reported by the marketing channel. Median Channel-Reported CTR = 50th Percentile of all |
Median Channel-Reported CVR |
| formula | The median Conversion Rate (CVR) as reported by the marketing channel. Median Channel-Reported CVR = 50th Percentile of all |
Median Channel-Reported MER |
| formula | The median Marketing Efficiency Ratio (MER) as reported by the marketing channel. Median Channel-Reported MER = 50th Percentile of all |
Median Channel-Reported ROAS |
| formula | The median Return On Ad Spend (ROAS) as reported by the marketing channel. Median Channel-Reported ROAS = 50th Percentile of all |
Updated about 1 month ago