Recommended tables
- Orders:
obt_orders - Customers:
obt_customers
Key concepts
- Subscription orders can be flagged in
obt_orders(e.g.,is_subscription_order,is_order_recurring_subscription). - If you’re validating against your subscription platform, start by aligning the definition of “active”, “new”, and “cancelled”.
Suggested workflow
- Filter to valid orders:
is_order_sm_valid = TRUE. - Segment subscription vs non-subscription customers.
- Analyze:
- Subscription order frequency
- Time between subscription orders
- Churn proxy (no subscription orders in X days)
- If you have a direct integration, reconcile key counts to the source platform.