Skip to main content
These pages document the definitions that matter across SourceMedium:
  • The fields that appear across many tables (and therefore many dashboards + recipes)
  • The business rules behind how we normalize, map, and dedupe data
  • The “gotchas” that most often cause analysis to drift
If you’re here for SQL examples, the fastest starting point is the SQL Query Library.

Valid Orders

How to filter orders correctly using is_order_sm_valid.

Revenue Fields

Net vs gross vs total revenue (and how refunds/discounts flow through).

Refund Logic

Refund components, sign conventions, and common refund-rate patterns.

Subscription Flags

Subscription classification fields and “first vs recurring” flags.

Channel Mapping

How sm_channel and sm_sub_channel are assigned (and how overrides work).

UTM Normalization

How UTM fields are normalized and how to query them safely.

Event + Journey Deduping

How we avoid double-counting when multiple event streams exist.