Notes

brand_performance_dataset

Denormalized weekly view joining sell-through to SKU, retail account, market share, and compliance data for brand-level reporting. · from sell_through_facts
Columns
ColumnLabelType
week_start_date Week temporal
state State dimension
category Category dimension
sku_name SKU dimension
brand Brand dimension
retail_account Retail Account dimension
channel Channel dimension
price_tier Price Tier dimension
promo_flag Promo Status dimension
door_status Door Status dimension
sku_status SKU Status dimension
coa_status COA/Testing Status dimension
license_status License Status dimension
Metrics
MetricLabelExpressionFormat
net_revenue Net Revenue SUM(net_revenue) currency
units_sold Units Sold SUM(units_sold) number
equivalized_units Equivalized Units (1g Flower Equiv.) SUM(equivalized_units) number
gross_margin_pct Gross Margin % SUM(gross_margin_amount) / SUM(net_revenue) number
avg_retail_price Avg Retail Price SUM(net_revenue) / SUM(units_sold) currency
list_price List Price AVG(list_price) currency
discount_depth_pct Discount Depth % AVG(discount_amount) / AVG(list_price) number
promo_lift_pct Promo Lift % AVG(promo_lift_pct) number
post_promo_baseline_units Post-Promo Baseline Units AVG(post_promo_baseline_units) number
market_share_pct Brand Market Share % AVG(market_share_pct) number
category_growth_pct Category Growth % AVG(category_growth_pct) number
velocity_units_per_door Units per Door per Week SUM(units_sold) / COUNT(DISTINCT retail_account_id) number
door_count Total Doors COUNT(DISTINCT retail_account_id) number
days_of_supply Days of Supply AVG(days_in_inventory) number
batch_count Batch Count COUNT(batch_id) number
pos_coverage_pct POS Coverage % AVG(pos_coverage_pct) number
reporting_lag_days Reporting Lag (Days) AVG(reporting_lag_days) number
missing_accounts_count Missing Accounts SUM(missing_accounts_count) number