npm install @latimer-woods-tech/crm

import { CREATE_CRM_LEADS_TABLE } from '@latimer-woods-tech/crm';
await db.execute(CREATE_CRM_LEADS_TABLE);

CREATE TABLE IF NOT EXISTS crm_leads (
  id          UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  user_id     TEXT NOT NULL,
  app_id      TEXT NOT NULL,
  email       TEXT,
  status      TEXT DEFAULT 'lead',
  mrr         NUMERIC DEFAULT 0,
  source      TEXT,
  metadata    JSONB DEFAULT '{}',
  created_at  TIMESTAMPTZ DEFAULT now(),
  updated_at  TIMESTAMPTZ DEFAULT now(),
  UNIQUE (user_id, app_id)
);

function trackLead(db: Db, opts: {
  userId: string;
  appId: string;
  email?: string;
  status?: 'lead' | 'trial' | 'active' | 'churned';
  source?: string;
  metadata?: Record<string, unknown>;
}): Promise<CrmLead>;

function trackConversion(
  db: Db,
  opts: {
    userId: string;
    appId: string;
    status: 'trial' | 'active' | 'churned';
    mrr: number;
  },
  analytics?: AnalyticsClient,
): Promise<CrmLead>;

function getCustomerView(db: Db, userId: string): Promise<CustomerView>;

interface CustomerView {
  lead: CrmLead;
  subscriptions: Subscription[];
  recentEvents: FactoryEvent[];
  churnRisk: 'low' | 'medium' | 'high';
}

import { trackLead, trackConversion, getCustomerView } from '@latimer-woods-tech/crm';

// On sign-up
await trackLead(db, {
  userId: user.id,
  appId: 'focusbro',
  email: user.email,
  status: 'lead',
  source: 'google-ads',
});

// On subscription
await trackConversion(db, {
  userId: user.id,
  appId: 'focusbro',
  status: 'active',
  mrr: 29,
});

// Admin dashboard
const view = await getCustomerView(db, user.id);
console.log(view.churnRisk); // 'low' | 'medium' | 'high'