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.
Facts
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.
OBT (One Big Table)
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 tracking sources (Elevar, Blotout, Snowplow/GA4, Heap) for pathing and attribution.
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.
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.
Need something else in this index? Ping us and we’ll add it.