GASP
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_date date, customer
  • activation_date date, customer
  • acv decimal, contract_event
  • attendees integer, onboarding_session
  • change_nature enum, revenue_event
  • composite_score decimal, customer
  • contract_end date, contract_event
  • contract_event_type enum, contract_event
  • contract_start date, contract_event, onboarding, onboarding_milestone
  • criteria_met boolean, customer
  • csm_id string, customer
  • currency string, revenue_event, contract_event
  • customer_id string, revenue_event, contract_event, lifecycle_event, customer, onboarding, trial
  • customer_status enum, customer
  • event_date date, revenue_event, contract_event, lifecycle_event
  • event_id string, revenue_event, contract_event, lifecycle_event
  • event_type enum, revenue_event
  • expansion_classification enum, revenue_event
  • hours decimal, onboarding
  • last_active_date date, customer
  • lifecycle_attribution enum, revenue_event
  • milestone_date date, onboarding_milestone
  • milestone_due_date date, onboarding_milestone
  • mrr_change decimal, revenue_event
  • new_mrr decimal, revenue_event
  • new_state string, lifecycle_event
  • onboarding_completion_date date, onboarding, customer
  • onboarding_id string, onboarding, onboarding_milestone, onboarding_session
  • onboarding_milestone enum, onboarding_milestone
  • onboarding_session_date date, onboarding_session
  • onboarding_start_date date, onboarding
  • prior_mrr decimal, revenue_event
  • prior_state string, lifecycle_event
  • qbr_completed boolean, customer
  • qbr_due boolean, customer
  • resource_id string, onboarding
  • segment string, revenue_event, contract_event, customer
  • snapshot_date date, customer, onboarding
  • state_category enum, lifecycle_event
  • steps_completed integer, onboarding
  • steps_total integer, onboarding
  • subscription_id string, revenue_event, contract_event
  • target_date date, onboarding
  • tcv decimal, contract_event
  • trial_end_date date, trial
  • trial_id string, trial
  • trial_start_date date, trial
  • trial_status enum, trial
  • upgrade_eligible boolean, 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.

Try searching for:

↑↓navigate↵select