Executive CRM

interface ExecutiveMetrics {
  mrr: number;
  arr: number;
  pipelineValue: number;
  winRate: number;
  avgDealSize: number;
  forecastAccuracy: number;
  churnRate: number;
  nrr: number;
}

async function computeExecutiveMetrics() {
  const [mrr, pipeline, deals] = await Promise.all([
    db.invoices.aggregate({ where: { status: "active" }, _sum: { amount: true } }),
    db.opportunities.aggregate({ _sum: { value: true } }),
    db.deals.findMany({ where: { closedAt: { gte: new Date(Date.now() - 90 * 86400000) } } }),
  ]);

  const winRate = deals.filter(d => d.won).length / deals.length;
  const avgDealSize = deals.reduce((s, d) => s + d.value, 0) / deals.length;

  return {
    mrr: mrr._sum.amount ?? 0,
    pipelineValue: pipeline._sum.value ?? 0,
    winRate,
    avgDealSize,
    forecastAccuracy: winRate * 0.85,
  };
}