// Conversion Report — stage progression, time-in-stage, lead→sale velocity function ConversionReport({ contacts, deals, reps, showrooms, period }) { // Period filter to contacts/deals const today = new Date(); function inPeriod(dateStr) { if (period === 'all') return true; if (!dateStr) return false; const d = new Date(dateStr); if (isNaN(d)) return false; const monthsBack = period === '1mo' ? 1 : period === '3mo' ? 3 : period === '12mo' ? 12 : 60; const cutoff = new Date(today); cutoff.setMonth(cutoff.getMonth() - monthsBack); return d >= cutoff; } // Contacts without a firstContact date are always included (common for Supabase-synced records) const periodContacts = contacts.filter(c => { const d = c.firstContact || c.lastContact; if (!d) return true; return inPeriod(d); }); const periodDeals = deals.filter(d => inPeriod(d.created)); // Stage progression counts within the period const newLeads = periodContacts.filter(c => c.firstContact).length; const qualified = periodContacts.filter(c => ['qualified', 'in_pipeline', 'customer_active', 'past_customer', 'lost_quote'].includes(c.lifecycle)).length; const quoted = periodContacts.filter(c => (c.dealCount || 0) > 0 || ['in_pipeline','customer_active','past_customer','dormant_customer_active','dormant_past_customer'].includes(c.lifecycle)).length; const sold = periodContacts.filter(c => ['past_customer', 'customer_active', 'dormant_past_customer'].includes(c.lifecycle)).length; // Time-in-stage analysis from deals function daysBetween(a, b) { if (!a || !b) return null; return Math.floor((new Date(b) - new Date(a)) / 86400000); } const stageTimes = { qualifying: [], quoting: [], closing: [] }; for (const d of periodDeals) { // qualifying: contact firstContact → designApptDate if (d.designApptDate) { const contact = contacts.find(c => (c.dealIds || []).includes(d.id)); if (contact && contact.firstContact) { const t = daysBetween(contact.firstContact, d.designApptDate); if (t !== null && t >= 0 && t < 365) stageTimes.qualifying.push(t); } } // quoting: designApptDate → quotePresentationDate if (d.designApptDate && d.quotePresentationDate) { const t = daysBetween(d.designApptDate, d.quotePresentationDate); if (t !== null && t >= 0 && t < 365) stageTimes.quoting.push(t); } // closing: quotePresentationDate → forecastDepositMonth (won) if (d.stage === 'sold' && d.quotePresentationDate && (d.forecastDepositMonth || d.lastActivity)) { const t = daysBetween(d.quotePresentationDate, d.forecastDepositMonth || d.lastActivity); if (t !== null && t >= 0 && t < 365) stageTimes.closing.push(t); } } const stats = (arr) => { if (arr.length === 0) return { count: 0, avg: 0, median: 0, min: 0, max: 0 }; const sorted = [...arr].sort((a, b) => a - b); const sum = arr.reduce((a, b) => a + b, 0); return { count: arr.length, avg: Math.round(sum / arr.length), median: sorted[Math.floor(sorted.length / 2)], min: sorted[0], max: sorted[sorted.length - 1], }; }; const qStats = stats(stageTimes.qualifying); const quoteStats = stats(stageTimes.quoting); const closeStats = stats(stageTimes.closing); // By showroom — progression const byShowroom = showrooms.map(s => { const sc = periodContacts.filter(c => c.homeShowroom === s.id); return { ...s, newLeads: sc.length, qualified: sc.filter(c => ['qualified', 'in_pipeline', 'customer_active', 'past_customer', 'lost_quote'].includes(c.lifecycle)).length, quoted: sc.filter(c => c.dealCount > 0).length, sold: sc.filter(c => ['past_customer', 'customer_active', 'dormant_past_customer'].includes(c.lifecycle)).length, }; }); // By salesperson — progression + timing const bySalesperson = reps.map(r => { const rc = periodContacts.filter(c => c.owner === r.name); const rd = periodDeals.filter(d => d.rep === r.id); const rQualifying = [], rQuoting = [], rClosing = []; for (const d of rd) { if (d.designApptDate) { const contact = contacts.find(c => (c.dealIds || []).includes(d.id)); if (contact && contact.firstContact) { const t = daysBetween(contact.firstContact, d.designApptDate); if (t !== null && t >= 0 && t < 365) rQualifying.push(t); } } if (d.designApptDate && d.quotePresentationDate) { const t = daysBetween(d.designApptDate, d.quotePresentationDate); if (t !== null && t >= 0 && t < 365) rQuoting.push(t); } if (d.stage === 'sold' && d.quotePresentationDate && (d.forecastDepositMonth || d.lastActivity)) { const t = daysBetween(d.quotePresentationDate, d.forecastDepositMonth || d.lastActivity); if (t !== null && t >= 0 && t < 365) rClosing.push(t); } } const avg = (a) => a.length ? Math.round(a.reduce((x, y) => x + y, 0) / a.length) : 0; return { ...r, newLeads: rc.length, qualified: rc.filter(c => ['qualified', 'in_pipeline', 'customer_active', 'past_customer', 'lost_quote'].includes(c.lifecycle)).length, quoted: rc.filter(c => (c.dealCount || 0) > 0 || ['in_pipeline','customer_active','past_customer','dormant_customer_active','dormant_past_customer'].includes(c.lifecycle)).length, sold: rc.filter(c => ['past_customer', 'customer_active', 'dormant_past_customer'].includes(c.lifecycle)).length, avgQualifying: avg(rQualifying), avgQuoting: avg(rQuoting), avgClosing: avg(rClosing), avgTotal: avg(rQualifying) + avg(rQuoting) + avg(rClosing), }; }).sort((a, b) => b.sold - a.sold); const totalCycle = qStats.avg + quoteStats.avg + closeStats.avg; return (
Average time at each stage
Days between key milestones · {periodDeals.length} deals analysed in period
Total avg cycle: {totalCycle} days
{(qStats.count + quoteStats.count + closeStats.count) === 0 ? (
Stage timing will populate once your team records design appointment and quote presentation dates on deals.
) : (
Stage transition Deals Average Median Fastest Slowest
First Contact → Design Appt
Qualifying phase
 {qStats.count} {qStats.avg} days {qStats.median}d {qStats.min}d {qStats.max}d
Design Appt → Quote Presented
Quoting phase
 {quoteStats.count} {quoteStats.avg} days {quoteStats.median}d {quoteStats.min}d {quoteStats.max}d
Quote Presented → Sold
Closing phase
 {closeStats.count} {closeStats.avg} days {closeStats.median}d {closeStats.min}d {closeStats.max}d
)}
Progression by showroom
Funnel by location, in selected period
{byShowroom.map(s => ( ))}
Showroom New Qual. Quoted Sold Conv.
{s.name} {s.newLeads} {s.qualified} {s.quoted} {s.sold} {fmt.pct(s.sold / Math.max(s.newLeads, 1), 0)}
Progression & speed by designer
Funnel + average days per stage
{bySalesperson.map(r => ( ))}
Designer New Sold Conv. Qual. Quote Close Total
{r.name}
 {r.newLeads} {r.sold} {fmt.pct(r.sold / Math.max(r.newLeads, 1), 0)} {r.avgQualifying || '—'}{r.avgQualifying ? 'd' : ''} {r.avgQuoting || '—'}{r.avgQuoting ? 'd' : ''} {r.avgClosing || '—'}{r.avgClosing ? 'd' : ''} 60 ? 'var(--lost)' : r.avgTotal > 0 ? 'var(--accent)' : 'var(--ink-3)' }}>{r.avgTotal ? r.avgTotal + 'd' : '—'}
Qual. = First contact → design appt · Quote = Design appt → quote presented · Close = Quote → sold
); } window.ConversionReport = ConversionReport;