Documentation Index
Fetch the complete documentation index at: https://docs.sourcemedium.com/docs/llms.txt
Use this file to discover all available pages before exploring further.
Dimensions are attributes used to slice and filter your data. This reference covers the most common dimensions across SourceMedium tables.
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 |
| 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;
