> ## 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.

# Dimension Definitions

> Definitions and examples for common SourceMedium dimensions used in reporting and filtering

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

<Tip>
  For full column documentation, see [Data Tables Reference](/data-activation/data-tables/sm_transformed_v2/index).
</Tip>

## 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

```sql theme={null}
SELECT COUNT(*) AS valid_orders
FROM `your_project.sm_transformed_v2.obt_orders`
WHERE is_order_sm_valid = TRUE;
```

### Filter by channel

```sql theme={null}
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

```sql theme={null}
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

```sql theme={null}
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;
```

## Related Resources

* [Glossary](/help-center/glossary) — Term definitions
* [Metric Definitions](/onboarding/data-docs/metrics) — Calculated metrics
* [Data Tables Reference](/data-activation/data-tables/sm_transformed_v2/index) — Full table documentation