Mapping the Customer Journey: A 12-Object Schema for Full Lifecycle View
Priya Mehta
Austin, TX. RevOps Brief contributor
The 12-object schema is the answer to a question most RevOps leaders can't answer cleanly: "Show me the complete journey of a customer, from first anonymous visit to multi-product renewal, in a single system view."
Most CRM architectures can't do this because they were designed for Sales and then extended to handle everything else. The result is an Account record carrying data it was never designed to hold.
The Schema
1. Lead — The anonymous or partially-identified entry point. Converted to Contact on L2A match.
2. Account — The legal entity anchor. Parent-child hierarchy lives here. See Unified Account Record.
3. Contact — The individual. Owns communication history. May be associated with multiple Accounts.
4. Opportunity — The commercial event. Line Items attached for multi-product deals.
5. Campaign — The marketing touchpoint record. Powers multi-touch attribution.
6. Engagement — Custom object for meaningful interactions: demos, meetings, key calls. Captures quality, not just channel.
7. Workspace — The product instance. Source of product telemetry via Reverse ETL. See PLG schema design.
8. Subscription — The active contract. ARR, plan tier, billing cadence, seat count, start/end date.
9. Entitlement — Which features the Account can access. Enables feature-gated expansion triggers.
10. Feedback — NPS, CSAT, and support ticket patterns at the Account level. Feeds the customer health score.
11. Partner — Tracks referral or agency partner relationships for accurate channel attribution.
12. Renewal — A distinct Opportunity type for the recurring commercial event, with expansion, contraction, and risk indicators.
Why 12 Objects?
Each represents a distinct relationship type with its own lifecycle, owners, and operational logic. Collapsing them destroys your ability to query and automate them independently. With this schema, you can answer: "Which acquisition channel produces the highest-retention, highest-expansion customers?" Without it, that's a hypothesis. With it, it's data.