Foundational Entities
Customer (Account, Organization)
Customer (Account, Organization): A distinct billing entity with one or more subscriptions. The "who" of your business relationship.
In the data model
Customer is an entity in the GASP relationship graph.
Datasets
revenue_event(event)contract_event(event)lifecycle_event(event)trial(fact)customer(snapshot)onboarding(snapshot)onboarding_milestone(event)onboarding_session(event)
Fields on these datasets (49)
-
acquisition_datedate, customer -
activation_datedate, customer -
acvdecimal, contract_event -
attendeesinteger, onboarding_session -
change_natureenum, revenue_event -
composite_scoredecimal, customer -
contract_enddate, contract_event -
contract_event_typeenum, contract_event -
contract_startdate, contract_event, onboarding, onboarding_milestone -
criteria_metboolean, customer -
csm_idstring, customer -
currencystring, revenue_event, contract_event -
customer_idstring, revenue_event, contract_event, lifecycle_event, customer, onboarding, trial -
customer_statusenum, customer -
event_datedate, revenue_event, contract_event, lifecycle_event -
event_idstring, revenue_event, contract_event, lifecycle_event -
event_typeenum, revenue_event -
expansion_classificationenum, revenue_event -
hoursdecimal, onboarding -
last_active_datedate, customer -
lifecycle_attributionenum, revenue_event -
milestone_datedate, onboarding_milestone -
milestone_due_datedate, onboarding_milestone -
mrr_changedecimal, revenue_event -
new_mrrdecimal, revenue_event -
new_statestring, lifecycle_event -
onboarding_completion_datedate, onboarding, customer -
onboarding_idstring, onboarding, onboarding_milestone, onboarding_session -
onboarding_milestoneenum, onboarding_milestone -
onboarding_session_datedate, onboarding_session -
onboarding_start_datedate, onboarding -
prior_mrrdecimal, revenue_event -
prior_statestring, lifecycle_event -
qbr_completedboolean, customer -
qbr_dueboolean, customer -
resource_idstring, onboarding -
segmentstring, revenue_event, contract_event, customer -
snapshot_datedate, customer, onboarding -
state_categoryenum, lifecycle_event -
steps_completedinteger, onboarding -
steps_totalinteger, onboarding -
subscription_idstring, revenue_event, contract_event -
target_datedate, onboarding -
tcvdecimal, contract_event -
trial_end_datedate, trial -
trial_idstring, trial -
trial_start_datedate, trial -
trial_statusenum, trial -
upgrade_eligibleboolean, customer
Relationships
- Customer owns Subscription (1:N). A customer holds one or more subscriptions. Hierarchy Principle 1: customers own subscriptions, not the reverse.
- Customer engages via User (1:N). In B2B SaaS, one customer organization has many product users. Usage and engagement metrics are measured at the user level.
- Customer submits Ticket (1:N). Customers open support tickets. Support volume and resolution metrics are measured at the ticket level.
- Opportunity converts to Customer (1:1). A won opportunity creates a new customer (closed-won). This is the SQL→Customer transition.
- Employee manages Customer (1:N). CSMs and account managers are assigned to customer accounts. Employee efficiency and coverage ratios are measured through this relationship.
- Project serves Customer (N:1). Professional services projects are delivered to customers. Project margins and utilization are measured through this relationship.
- Customer belongs to Cohort (N:1). Each customer belongs to an acquisition cohort based on their start date. Cohort analysis isolates vintage effects in retention and expansion.
- Customer parent of Customer (1:N). Self-referential edge for account hierarchy. Global enterprises with subsidiaries roll up to a parent customer. Used for global account ARR and consolidated reporting.
- Customer represented by Contact (1:N). A customer account is represented by named individuals (champions, decision makers, executive sponsors). Enables buying-center coverage metrics and stakeholder mapping.
- Customer belongs to Segment (N:1). Each customer belongs to a segment classification (SMB, Mid-Market, Enterprise) based on size, ARR or fit. Segment is the foundational lens for cohort and benchmark comparisons.
Related Terms
Other definitions in Foundational Entities:
Subscription (Contract, Agreement)
A billable agreement between a customer and your product, with defined terms, pricing and status. The "what and when" of the relationship.
License (Entitlement, Access, Quota)
A specific capability, quantity or configuration granted by a subscription. The "how much" of the relationship.
Hierarchy Principles
1. **Customers own subscriptions, not the reverse.** A customer churns when *all* their subscriptions end.