sm_transformed_v2, grouped by shape. Start with obt_orders for order questions, obt_order_lines for product questions, and obt_customers for customer questions.
Foundation vs Pro. Pro (dedicated warehouse) receives all 33 active tables. Foundation (shared warehouse) receives 16. The other 17 are Pro only: the seven dim_* order and customer tables, every subscription table, fct_orders_placed, and the two media mix tables. Each Pro-only page says so at the top. See Foundation and Pro.
Dimensions
dim_customer_addresses
Customer address dimension for enriching customers and orders with normalized geo attributes.
dim_customers
Customer dimension with stable keys and profile attributes for joining and segmentation.
dim_order_discounts
Order discount dimension with discount types, codes, and values.
dim_order_lines
Order line dimension for product-level attributes at line grain.
dim_order_shipping_lines
Order shipping line dimension for shipping method and cost details at line-level.
dim_order_taxes
Order tax dimension with tax names and amounts for reconciliation and reporting.
dim_orders
Order dimension with stable keys and descriptive attributes for joining and exploration.
dim_product_variants
Product variant dimension for enriching line items with stable keys and attributes.
dim_subscriptions
Subscription records with lifecycle, product, MRR, and reporting-currency fields.
dim_subscribers
Subscriber status, cohort, tenure, and lifetime revenue.
Facts
fct_order_attribution_signals
Row-level attribution signals table for tracing the inputs SourceMedium evaluated for each order’s attribution.
fct_orders_placed
Placed order fact table for order-count analytics and funnel tie-ins.
fct_refunds_processed
Refund transaction fact table for revenue adjustments and return analytics.
fct_returns
Loop Returns fact table enriched with Shopify order context.
fct_subscription_charges
ReCharge charges at charge grain.
OBT (One Big Table)
obt_affiliate_conversions
ShopMy and Superfiliate conversions at order grain.
obt_customer_support_tickets
Customer support ticket analytics for lifecycle, agent performance, and channel analysis.
obt_customers
Customer analytics table for acquisition, subscription status, and cohort analysis.
obt_funnel_event_history
Unified funnel event history across Elevar, RudderStack, Snowplow, and GA4 for pathing and attribution.
obt_inventory_positions
Current-state inventory visibility across Shopify and Amazon sources.
obt_order_lines
Product-level analytics table for order line revenue, costs, and profitability.
obt_orders
Order analytics table for revenue, profitability, refunds, and channel performance analysis.
obt_subscriptions
Subscription analytics enriched with product and subscriber attributes.
obt_subscription_charges
ReCharge charges with billing sequence.
obt_media_mix_performance
Full-detail media mix measurement at the vendor’s reported grain, including which sales venue the revenue landed on.
Reports
rpt_ad_performance_daily
Daily advertising performance across platforms for spend, efficiency, and ROAS.
rpt_cohort_ltv_by_first_valid_purchase_attribute_no_product_filters
Cohort LTV analysis by first valid purchase attributes (channel, campaign, source) with no product filters.
rpt_executive_summary_daily
Daily KPI aggregation for executive reporting and dashboards (revenue, ROAS, profit, targets).
rpt_funnel_events_performance_hourly
Hourly funnel event aggregation for near-real-time conversion monitoring.
rpt_outbound_message_performance_daily
Daily messaging performance across email/SMS/push for campaigns and flows.
rpt_subscription_signup_cohort_retention
Subscription retention and MRR by signup cohort and months since signup.
rpt_subscriptions_performance_daily
Daily subscription growth, churn, active subscriptions, and MRR reporting.
rpt_media_mix_channel_daily
Daily media mix results with modelled, last-click, and ad-platform ROAS side by side. Start here for media mix.
Planned
rpt_order_attributed_marketing_utms
Planned multi-touch UTM attribution table with conversion credit per UTM signal. It is not included in the 33 active tables above.
Retired
rpt_affiliate_performance_daily
Retired and no longer updated. Use
obt_affiliate_conversions for order-level affiliate analysis and daily rollups.Need something else in this index? Ping us and we’ll add it.