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.

📘
Notes
event_date is 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.
Industry benchmarks are based on aggregated ad channel data collected by Triple Whale. To preserve anonymity, benchmark data is only shown when at least 20 ad channel sources match your filter criteria.

👍
Example Query
The following example retrieves the median channel-reported ROAS for the food_and_beverages industry on the most recent day for which benchmark data is available.
SELECT
  quantile(0.50)(channel_reported_roas) AS channel_reported_roas
FROM tw_benchmarks_table
WHERE event_date = DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
  AND industry = 'food_and_beverage'

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	SQL Expression	Description
Event Date	`event_date`	date	`event_date`	The date the ad was run. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day	`event_date.day`	date	`event_date`	The day on which the event occurred. Derived from `event_date`.
Event Week	`event_date.week`	date	`event_date`	The Sunday of the week during which the event occurred. Derived from `event_date`.
Event Month	`event_date.month`	date	`event_date`	The month during which the event occurred. Derived from `event_date`.
Event Quarter	`event_date.quarter`	date	`event_date`	The first month of the quarter during which the event occurred. Derived from `event_date`.
Event Year	`event_date.year`	date	`event_date`	The year during which the event occurred. Derived from `event_date`.
AOV Segment	`aov_segment`	string	`aov_segment`	Segment based on the median Average Order Value (AOV). Possible values: `<$100`, `$100+`
Channel	`channel`	string	`channel`	The platform through which the ad was delivered. Example values: `facebook-ads`, `google-ads`, `tiktok-ads`
GMV Segment	`gmv_segment`	string	`gmv_segment`	Segment based on the median Gross Merchandise Value (GMV). Possible values: `$10M+`, `$1M-$10M`, `<$1M`
Industry	`industry`	string	`industry`	The industry category of the store as set in Triple Whale admin. Example values: `food_and_beverage`, `health_and_beauty`, `consumer_electronics`, `business_supplies_and_equipment`, `home_and_garden`, `baby`

Derived

Derived fields are metrics that are pre-calculated using formulas.

Title	ID	Type	SQL Expression	Description
Median Channel-Reported AOV	`channel_reported_aov`	formula	`quantile(0.50)(channel_reported_aov) AS channel_reported_aov_median`	The median Average Order Value (AOV) as reported by the marketing channel (50th percentile).
Median Channel-Reported CPA	`channel_reported_cpa`	formula	`quantile(0.50)(channel_reported_cpa) AS channel_reported_cpa_median`	The median Cost Per Acquisition (CPA) as reported by the channel.
Median Channel-Reported CPC	`channel_reported_cpc`	formula	`quantile(0.50)(channel_reported_cpc) AS channel_reported_cpc_median`	The median Cost Per Click (CPC) as reported by the channel.
Median Channel-Reported CPM	`channel_reported_cpm`	formula	`quantile(0.50)(channel_reported_cpm) AS channel_reported_cpm_median`	The median CPM (cost per 1,000 impressions) as reported by the channel.
Median Channel-Reported CTR	`channel_reported_ctr`	formula	`quantile(0.50)(channel_reported_ctr) AS channel_reported_ctr_median`	The median Click-Through Rate (CTR) as reported by the channel.
Median Channel-Reported CVR	`channel_reported_cvr`	formula	`quantile(0.50)(channel_reported_cvr) AS channel_reported_cvr_median`	The median Conversion Rate (CVR) as reported by the channel.
Median Channel-Reported MER	`channel_reported_mer`	formula	`quantile(0.50)(channel_reported_mer) AS channel_reported_mer_median`	The median Marketing Efficiency Ratio (MER) as reported by the channel.
Median Channel-Reported ROAS	`channel_reported_roas`	formula	`quantile(0.50)(channel_reported_roas) AS channel_reported_roas_median`	The median Return On Ad Spend (ROAS) as reported by the channel.

Updated 18 days ago