Dimension Definitions

Dimensions are attributes used to slice and filter your data. This reference covers the most common dimensions across SourceMedium tables.

For full column documentation, see Data Tables Reference.

Channel & Attribution Dimensions

Dimension	Definition	Example Values
`sm_channel`	Primary channel classification for orders and marketing	`online_dtc`, `amazon`, `retail`, `wholesale`
`sm_sub_channel`	Granular breakdown within a channel (config-sheet or platform-derived; falls back to channel)	`Fulfilled by Amazon`, `Fulfilled by Merchant`, `Online DTC`
`sm_utm_source`	UTM source (when available)	`facebook`, `google`, `klaviyo`, `direct`
`sm_utm_medium`	UTM medium (when available)	`cpc`, `email`, `organic`, `referral`
`sm_utm_campaign`	UTM campaign (when available)	`spring_sale_2026`, `retargeting_lookalike`
`sm_utm_source_medium`	Convenience combined source/medium	`facebook / cpc`

Customer Dimensions

Dimension	Definition	Example Values
`customer_tags_array`	Customer tags as an array (preferred for exact matching)	`VIP`, `wholesale`, `influencer`
`customer_tags_csv`	Customer tags as a comma-separated string	`VIP, wholesale`

Order Dimensions

Dimension	Definition	Example Values
`is_order_sm_valid`	Whether order should be included in reporting	`TRUE`, `FALSE`
`order_payment_status`	Payment/financial status	`paid`, `refunded`, `partially_refunded`
`order_discount_codes_csv`	Discount codes applied to the order	`SUMMER20, INFLUENCER10`
`order_product_tags_array`	Tags across products in the order (array)	`subscription`, `gift`
`sm_valid_order_index`	Sequential index of valid orders per customer	`1`, `2`, `3`

Product Dimensions

Dimension	Definition	Example Values
`product_type`	Shopify product type	`T-Shirt`, `Supplement`, `Accessory`
`product_vendor`	Product vendor/brand	`Nike`, `In-house`, `Partner Brand`
`product_tags_array`	Shopify product tags (array)	`bestseller`, `new-arrival`, `sale`
`product_collection_titles_csv`	Product collection membership	`Summer 2026`, `Basics`, `Limited Edition`

Time Dimensions

Dimension	Definition	Notes
`order_created_at`	Order timestamp (UTC)	Use for filtering by date range
`order_created_at_local_datetime`	Order timestamp (brand timezone)	Use for time-of-day analysis
`date`	Date for aggregated report tables	In `rpt_*` tables

Geographic Dimensions

Dimension	Definition	Example Values
`order_shipping_country_code`	Shipping destination country code	`US`, `CA`, `GB`
`order_shipping_state`	Shipping destination state/province	`CA`, `NY`, `ON`
`order_shipping_city`	Shipping destination city	`Los Angeles`, `New York`

Marketing Dimensions (Ad Performance)

Dimension	Definition	Example Values
`source_system`	Advertising platform source	`meta_ads`, `google_ads`, `tiktok`
`ad_campaign_name`	Campaign name from ad platform	`Prospecting - Lookalike`
`ad_group_name`	Ad group/ad set name	`Interest - Fitness`
`ad_name`	Individual ad name	`Video - Testimonial v2`

Common Filtering Patterns

Filter to valid orders

SELECT COUNT(*) AS valid_orders
FROM `your_project.sm_transformed_v2.obt_orders`
WHERE is_order_sm_valid = TRUE;

Filter by channel

SELECT COUNT(*) AS valid_orders
FROM `your_project.sm_transformed_v2.obt_orders`
WHERE is_order_sm_valid = TRUE
  AND sm_channel = 'online_dtc';

Filter by date range

SELECT COUNT(*) AS valid_orders
FROM `your_project.sm_transformed_v2.obt_orders`
WHERE is_order_sm_valid = TRUE
  AND order_created_at >= '2026-01-01'
  AND order_created_at < '2026-02-01';

Filter by customer type

SELECT COUNT(*) AS first_valid_orders
FROM `your_project.sm_transformed_v2.obt_orders`
WHERE is_order_sm_valid = TRUE
  AND sm_valid_order_index = 1;

Glossary — Term definitions
Metric Definitions — Calculated metrics
Data Tables Reference — Full table documentation

Getting Started

Quick Reference

Table Documentation

Schema Standards

Platform Raw Data

Channel & Attribution Dimensions

Customer Dimensions

Order Dimensions

Product Dimensions

Time Dimensions

Geographic Dimensions

Marketing Dimensions (Ad Performance)

Common Filtering Patterns

Filter to valid orders

Filter by channel

Filter by date range

Filter by customer type

​Channel & Attribution Dimensions

​Customer Dimensions

​Order Dimensions

​Product Dimensions

​Time Dimensions

​Geographic Dimensions

​Marketing Dimensions (Ad Performance)

​Common Filtering Patterns

​Filter to valid orders

​Filter by channel

​Filter by date range

​Filter by customer type

​Related Resources

Channel & Attribution Dimensions

Customer Dimensions

Order Dimensions

Product Dimensions

Time Dimensions

Geographic Dimensions

Marketing Dimensions (Ad Performance)

Common Filtering Patterns

Filter to valid orders

Filter by channel

Filter by date range

Filter by customer type

Related Resources