Skip to main content
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

DimensionDefinitionExample Values
sm_channelPrimary channel classification for orders and marketingonline_dtc, amazon, retail, wholesale
sm_sub_channelGranular breakdown within a channel (config-sheet or platform-derived; falls back to channel)Fulfilled by Amazon, Fulfilled by Merchant, Online DTC
sm_utm_sourceUTM source (when available)facebook, google, klaviyo, direct
sm_utm_mediumUTM medium (when available)cpc, email, organic, referral
sm_utm_campaignUTM campaign (when available)spring_sale_2026, retargeting_lookalike
sm_utm_source_mediumConvenience combined source/mediumfacebook / cpc

​
Customer Dimensions

DimensionDefinitionExample Values
customer_tags_arrayCustomer tags as an array (preferred for exact matching)VIP, wholesale, influencer
customer_tags_csvCustomer tags as a comma-separated stringVIP, wholesale

​
Order Dimensions

DimensionDefinitionExample Values
is_order_sm_validWhether order should be included in reportingTRUE, FALSE
order_payment_statusPayment/financial statuspaid, refunded, partially_refunded
order_discount_codes_csvDiscount codes applied to the orderSUMMER20, INFLUENCER10
order_product_tags_arrayTags across products in the order (array)subscription, gift
sm_valid_order_indexSequential index of valid orders per customer1, 2, 3

​
Product Dimensions

DimensionDefinitionExample Values
product_typeShopify product typeT-Shirt, Supplement, Accessory
product_vendorProduct vendor/brandNike, In-house, Partner Brand
product_tags_arrayShopify product tags (array)bestseller, new-arrival, sale
product_collection_titles_csvProduct collection membershipSummer 2026, Basics, Limited Edition

​
Time Dimensions

DimensionDefinitionNotes
order_created_atOrder timestamp (UTC)Use for filtering by date range
order_created_at_local_datetimeOrder timestamp (brand timezone)Use for time-of-day analysis
dateDate for aggregated report tablesIn rpt_* tables

​
Geographic Dimensions

DimensionDefinitionExample Values
order_shipping_country_codeShipping destination country codeUS, CA, GB
order_shipping_stateShipping destination state/provinceCA, NY, ON
order_shipping_cityShipping destination cityLos Angeles, New York

​
Marketing Dimensions (Ad Performance)

DimensionDefinitionExample Values
source_systemAdvertising platform sourcemeta_ads, google_ads, tiktok
ad_campaign_nameCampaign name from ad platformProspecting - Lookalike
ad_group_nameAd group/ad set nameInterest - Fitness
ad_nameIndividual ad nameVideo - 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;