SaaS usage & churn
==================

A business analytics product sold to Indian companies on monthly plans: accounts, subscriptions with upgrades and cancellations, feature usage events and support tickets. Accounts that stop using the product and open tickets are the ones that churn.

Category: Analytics
Licence: CC0-1.0
Synthetic data generated by DataStride. Places are real; companies are fictional.
Build: 940aea8e3b2c8169

saas_plans (4 rows)
  plan_id                INTEGER        [key] Plan identifier.
  plan_name              VARCHAR(20)    Plan name.
  monthly_price          DECIMAL(10,2)  Price per month, INR, before GST.
  seat_limit             INTEGER        Seats included.

saas_accounts (700 rows)
  account_id             INTEGER        [key] Customer account.
  company_name           VARCHAR(80)    Customer company (fictional).
  industry               VARCHAR(30)    Industry.
  city                   VARCHAR(40)    Head office city.
  employees              INTEGER        Company headcount.
  signed_up_on           DATE           Trial start.
  acquisition_channel    VARCHAR(20)    How they found the product.

saas_subscriptions (900 rows)
  subscription_id        INTEGER        [key] Subscription identifier.
  account_id             INTEGER        -> saas_accounts.account_id Account subscribing.
  plan_id                INTEGER        -> saas_plans.plan_id Plan on this subscription.
  started_on             DATE           Subscription start.
  seats                  INTEGER        Seats paid for.
  billing_cycle          VARCHAR(10)    Billing cycle.
  ended_on               DATE           Cancellation date; null while active.
  cancel_reason          VARCHAR(40)    Reason given at cancellation.

saas_usage_events (5000 rows)
  event_id               INTEGER        [key] Event identifier.
  subscription_id        INTEGER        -> saas_subscriptions.subscription_id Subscription the user belongs to.
  event_date             DATE           When the feature was used; always within the subscription.
  feature                VARCHAR(20)    Feature used.
  duration_sec           INTEGER        Session length on the feature.

saas_tickets (1200 rows)
  ticket_id              INTEGER        [key] Ticket identifier.
  account_id             INTEGER        -> saas_accounts.account_id Account raising it.
  opened_on              DATE           Opened.
  priority               VARCHAR(10)    Priority.
  topic                  VARCHAR(30)    Subject area.
  resolution_hours       DECIMAL(8,1)   Hours to resolve.
  csat                   INTEGER        Satisfaction score 1–5 after resolution.
