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

# Data Dictionary

> Your complete reference for working with SourceMedium data — from metrics to schemas to SQL

Welcome to the Data Dictionary. Whether you're looking up a metric, writing SQL, or understanding table structure, this is your hub for all things data at SourceMedium.

***

## I want to...

<CardGroup cols={2}>
  <Card title="Look up a metric" icon="chart-line" href="/onboarding/data-docs/metrics">
    Find definitions for AOV, ROAS, LTV, CAC, and 180+ other metrics
  </Card>

  <Card title="Browse table schemas" icon="database" href="/data-activation/data-tables/sm_transformed_v2/index">
    Browse table schemas with column descriptions and data types
  </Card>

  <Card title="Write SQL queries" icon="code" href="/data-activation/template-resources/sql-query-library">
    Copy proven SQL templates for common analyses, returns, inventory, and attribution debugging
  </Card>

  <Card title="Access BigQuery" icon="key" href="/onboarding/analytics-tools/bigquery-essentials">
    Learn how to connect and run your first queries
  </Card>

  <Card title="Understand data structure" icon="sitemap" href="/data-transformations/philosophy">
    Learn about facts, dimensions, OBTs, and SourceMedium's modeling approach
  </Card>

  <Card title="Look up a term" icon="book-open" href="/help-center/glossary">
    Get definitions for channels, valid orders, and common SourceMedium concepts
  </Card>
</CardGroup>

***

## Quick Reference

For fast lookups, use [Metrics](/onboarding/data-docs/metrics), [Dimensions](/onboarding/data-docs/dimensions), or the [Glossary](/help-center/glossary).

***

## Table Documentation

<CardGroup cols={2}>
  <Card title="sm_transformed_v2" icon="table" href="/data-activation/data-tables/sm_transformed_v2/index">
    **Recommended for most use cases** — cleaned, enriched analytics tables (facts, dimensions, OBTs, reports)
  </Card>

  <Card title="sm_views" icon="table" href="/data-activation/data-tables/sm_views/index">
    Report views generated for common Managed Data Warehouse workflows
  </Card>

  <Card title="Metadata Tables" icon="database" href="/data-activation/data-tables/sm_metadata/dim_data_dictionary">
    Semantic layer catalog and automated data dictionary for programmatic lookups
  </Card>

  <Card title="Experimental Tables" icon="flask" href="/data-activation/data-tables/sm_experimental/index">
    Beta features including multi-touch attribution models and advanced attribution tables
  </Card>
</CardGroup>

<Tip>
  New to SourceMedium's data model? Start with [Modeling Philosophy](/data-transformations/philosophy) to understand how we structure data (facts, dimensions, OBTs, reports).
</Tip>

***

## Working with Data

<CardGroup cols={2}>
  <Card title="BigQuery Essentials" icon="circle-play" href="/onboarding/analytics-tools/bigquery-essentials">
    How to access your warehouse and run queries
  </Card>

  <Card title="SQL Query Library" icon="code" href="/data-activation/template-resources/sql-query-library">
    Copy-paste SQL for cohort analysis, retention, product performance, inventory, returns, and attribution health
  </Card>

  <Card title="Common Analyses" icon="lightbulb" href="/help-center/common-analyses/common-analysis-template">
    Proven patterns for top products, ROAS, retention, LTV, and profitability
  </Card>

  <Card title="Connect BI Tools" icon="plug" href="/onboarding/analytics-tools/connect-bigquery-to-looker-studio">
    Link BigQuery to Looker Studio, Tableau, or other visualization tools
  </Card>
</CardGroup>

***

## Schema Standards

<Card title="Naming Conventions" icon="tags" href="/data-transformations/naming-conventions/key-concepts">
  Learn the patterns behind table prefixes (fct\_, dim\_, obt\_, rpt\_), column naming, and metric calculations
</Card>

***

## Advanced Resources

<Accordion title="Platform Raw Data">
  Browse raw source schemas for integrated platforms (Shopify, Klaviyo, Meta Ads, Google Ads, etc.).

  **When to use:** Debugging integrations, understanding what SourceMedium transforms, or accessing platform-specific fields not yet in sm\_transformed\_v2.

  **For most analyses:** Use [sm\_transformed\_v2 tables](/data-activation/data-tables/sm_transformed_v2/index) instead — they're cleaned, enriched, and easier to work with.

  [View Platform Raw Data →](/help-center/raw-data-source-overviews/meta-ads-overview)
</Accordion>

<Accordion title="Custom Modeling in Your Warehouse">
  Need custom tables or logic beyond SourceMedium's out-of-the-box models? Learn how to extend the data warehouse with your own dbt models.

  [Managed Data Warehouse Modeling Guide →](/data-activation/managed-data-warehouse/modeling)
</Accordion>