// data.jsx — sample data + persistence layer // Mirrors the CA Bonus Tracker Sheet shape. Persisted to localStorage so writes // survive refresh. const STORAGE_KEY = 'cabt_state_v1'; // ── Seed data ─────────────────────────────────────────────────────────────── const SEED_CAS = [ { id: 'CA-01', name: 'Sam Reyes', email: 'sam@groundstandard.com', role: 'CA', payStructure: 'Salary + Bonus', annualEquivalent: 78000, lastReviewed: '2026-01-15', nextReview: '2026-07-15', active: true }, { id: 'CA-02', name: 'Jordan Park', email: 'jordan@groundstandard.com', role: 'CA', payStructure: 'Salary + Bonus', annualEquivalent: 72000, lastReviewed: '2025-11-02', nextReview: '2026-05-02', active: true }, { id: 'CA-03', name: 'Morgan Vance', email: 'morgan@groundstandard.com', role: 'CA', payStructure: 'Salary + Bonus', annualEquivalent: 68000, lastReviewed: '2026-02-20', nextReview: '2026-08-20', active: true }, { id: 'CA-04', name: 'Drew Mahoney', email: 'drew@groundstandard.com', role: 'CA', payStructure: 'Salary + Bonus', annualEquivalent: 70000, lastReviewed: '2026-03-01', nextReview: '2026-09-01', active: true }, ]; const SEED_SALES = [ { id: 'AE-01', name: 'Alex Calloway', role: 'AE', startDate: '2025-02-10', upfrontRate: 0.10, midRate: 0.05, endRate: 0.05, notes: '' }, { id: 'AE-02', name: 'Riley Chen', role: 'AE', startDate: '2025-06-22', upfrontRate: 0.10, midRate: 0.05, endRate: 0.05, notes: '' }, { id: 'SDR-01', name: 'Casey Brooks', role: 'SDR', startDate: '2025-09-01', upfrontRate: 0, midRate: 0, endRate: 0, notes: 'Flat $100/booking' }, { id: 'SDR-02', name: 'Avery Singh', role: 'SDR', startDate: '2026-01-12', upfrontRate: 0, midRate: 0, endRate: 0, notes: 'Flat $100/booking' }, ]; // 18 BJJ/MMA gym clients across the 4 CAs const SEED_CLIENTS = [ // Sam's book { id: 'C-001', name: 'Ronin BJJ Austin', assignedCA: 'CA-01', signDate: '2024-06-12', cancelDate: '', monthlyRetainer: 2500, hasMembershipAddon: true, termMonths: 12, ae: 'AE-01', sdrBookedBy: 'SDR-01', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '2024-07-01', stripeId: 'cus_R1' }, { id: 'C-002', name: 'Atlas Combat Club', assignedCA: 'CA-01', signDate: '2024-09-04', cancelDate: '', monthlyRetainer: 1800, hasMembershipAddon: false, termMonths: 12, ae: 'AE-01', sdrBookedBy: 'SDR-01', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '', stripeId: 'cus_R2' }, { id: 'C-003', name: 'Westside Muay Thai', assignedCA: 'CA-01', signDate: '2025-01-22', cancelDate: '', monthlyRetainer: 2200, hasMembershipAddon: true, termMonths: 12, ae: 'AE-02', sdrBookedBy: 'SDR-02', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '2025-02-01', stripeId: 'cus_R3' }, { id: 'C-004', name: 'Iron Lotus Jiu-Jitsu', assignedCA: 'CA-01', signDate: '2025-03-11', cancelDate: '', monthlyRetainer: 1500, hasMembershipAddon: false, termMonths: 12, ae: 'AE-01', sdrBookedBy: '', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '', stripeId: '' }, { id: 'C-005', name: 'Pacific MMA Lab', assignedCA: 'CA-01', signDate: '2025-08-19', cancelDate: '', monthlyRetainer: 2800, hasMembershipAddon: true, termMonths: 12, ae: 'AE-02', sdrBookedBy: 'SDR-01', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '2025-09-01', stripeId: 'cus_R5' }, { id: 'C-006', name: 'Cobra Kai Denver', assignedCA: 'CA-01', signDate: '2025-11-05', cancelDate: '', monthlyRetainer: 1900, hasMembershipAddon: false, termMonths: 12, ae: 'AE-01', sdrBookedBy: 'SDR-02', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '', stripeId: '' }, { id: 'C-007', name: 'Black Belt Academy KC', assignedCA: 'CA-01', signDate: '2025-12-14', cancelDate: '', monthlyRetainer: 2100, hasMembershipAddon: false, termMonths: 12, ae: 'AE-01', sdrBookedBy: '', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '', stripeId: '' }, // Jordan's book { id: 'C-008', name: 'Granite Grappling', assignedCA: 'CA-02', signDate: '2024-08-01', cancelDate: '', monthlyRetainer: 2400, hasMembershipAddon: true, termMonths: 12, ae: 'AE-02', sdrBookedBy: 'SDR-01', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '2024-09-01', stripeId: 'cus_R8' }, { id: 'C-009', name: 'Sevens MMA Phoenix', assignedCA: 'CA-02', signDate: '2025-04-30', cancelDate: '', monthlyRetainer: 1700, hasMembershipAddon: false, termMonths: 12, ae: 'AE-01', sdrBookedBy: 'SDR-02', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '', stripeId: '' }, { id: 'C-010', name: 'Forge Fight Academy', assignedCA: 'CA-02', signDate: '2025-07-08', cancelDate: '', monthlyRetainer: 2300, hasMembershipAddon: true, termMonths: 12, ae: 'AE-02', sdrBookedBy: 'SDR-01', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '2025-08-01', stripeId: 'cus_R10' }, { id: 'C-011', name: 'Wolfpack BJJ Boise', assignedCA: 'CA-02', signDate: '2026-01-15', cancelDate: '', monthlyRetainer: 1600, hasMembershipAddon: false, termMonths: 12, ae: 'AE-01', sdrBookedBy: 'SDR-02', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '', stripeId: '' }, // Morgan's book { id: 'C-012', name: 'Northbound Submission', assignedCA: 'CA-03', signDate: '2024-11-20', cancelDate: '', monthlyRetainer: 2000, hasMembershipAddon: false, termMonths: 12, ae: 'AE-01', sdrBookedBy: 'SDR-01', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '', stripeId: 'cus_R12' }, { id: 'C-013', name: 'Apex Striking Coalition', assignedCA: 'CA-03', signDate: '2025-05-09', cancelDate: '', monthlyRetainer: 2600, hasMembershipAddon: true, termMonths: 12, ae: 'AE-02', sdrBookedBy: '', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '2025-06-01', stripeId: '' }, { id: 'C-014', name: 'Concrete Jungle BJJ', assignedCA: 'CA-03', signDate: '2025-09-12', cancelDate: '', monthlyRetainer: 1800, hasMembershipAddon: false, termMonths: 12, ae: 'AE-01', sdrBookedBy: 'SDR-02', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '', stripeId: '' }, { id: 'C-015', name: 'High Desert Muay Thai', assignedCA: 'CA-03', signDate: '2026-02-01', cancelDate: '', monthlyRetainer: 1500, hasMembershipAddon: false, termMonths: 12, ae: 'AE-02', sdrBookedBy: 'SDR-01', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '', stripeId: '' }, // Drew's book { id: 'C-016', name: 'Lighthouse Combat', assignedCA: 'CA-04', signDate: '2024-12-03', cancelDate: '', monthlyRetainer: 2700, hasMembershipAddon: true, termMonths: 12, ae: 'AE-01', sdrBookedBy: 'SDR-01', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '2025-01-01', stripeId: 'cus_R16' }, { id: 'C-017', name: 'Bayside Brazilian JJ', assignedCA: 'CA-04', signDate: '2025-06-18', cancelDate: '', monthlyRetainer: 2100, hasMembershipAddon: false, termMonths: 12, ae: 'AE-02', sdrBookedBy: 'SDR-02', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '', stripeId: '' }, { id: 'C-018', name: 'Stonefist Boxing & MMA', assignedCA: 'CA-04', signDate: '2025-10-25', cancelDate: '', monthlyRetainer: 1900, hasMembershipAddon: true, termMonths: 12, ae: 'AE-01', sdrBookedBy: 'SDR-01', upfrontPct: 0.10, midPct: 0.05, endPct: 0.05, membershipStartDate: '2025-11-01', stripeId: 'cus_R18' }, ]; // Generate Monthly Metrics — last 4 months for each client (with some gaps so completeness < 100%) function genMonthlyMetrics() { const months = ['2026-01-01', '2026-02-01', '2026-03-01', '2026-04-01']; const rows = []; let id = 1; SEED_CLIENTS.forEach((c, ci) => { months.forEach((m, mi) => { // Skip current month for some clients to create "needs data" prompts if (m === '2026-04-01' && (ci % 4 === 0 || ci === 6 || ci === 11)) return; // Skip a random month for one client to lower completeness if (ci === 14 && mi === 1) return; const baseMRR = c.monthlyRetainer + Math.round(Math.random() * 200 - 100); const leads = 35 + Math.floor(Math.random() * 40); const adSpend = Math.round((c.monthlyRetainer * (0.6 + Math.random() * 0.4)) / 50) * 50; const leadCost = Math.round(adSpend / Math.max(1, leads)); const grossRev = Math.round(c.monthlyRetainer * (3.5 + Math.random() * 2.5)); const apptsBooked = Math.floor(leads * (0.32 + Math.random() * 0.25)); const leadsShowed = Math.floor(apptsBooked * (0.55 + Math.random() * 0.25)); const leadsSigned = Math.floor(leadsShowed * (0.55 + Math.random() * 0.30)); const totalStudentsStart = 80 + Math.floor(Math.random() * 60); const studentsCancelled = Math.floor(totalStudentsStart * (0.02 + Math.random() * 0.05)); rows.push({ id: `MM-${String(id++).padStart(4, '0')}`, clientId: c.id, month: m, clientMRR: baseMRR, leadCost, adSpend, clientGrossRevenue: grossRev, leadsGenerated: leads, apptsBooked, leadsShowed, leadsSigned, totalStudentsStart, studentsCancelled, notes: '', }); }); }); return rows; } const SEED_GROWTH_EVENTS = [ { id: 'GE-001', date: '2026-04-08', clientId: 'C-001', eventType: 'Review', notes: 'Google review, 5⭐', saleTotal: 0, costToUs: 0, loggedBy: 'CA-01' }, { id: 'GE-002', date: '2026-04-12', clientId: 'C-003', eventType: 'Testimonial', notes: 'Video testimonial from owner Maya', saleTotal: 0, costToUs: 0, loggedBy: 'CA-01' }, { id: 'GE-003', date: '2026-04-15', clientId: 'C-005', eventType: 'Gear Sale', notes: 'Gi bundle sold via affiliate link', saleTotal: 480, costToUs: 220, loggedBy: 'CA-01' }, { id: 'GE-004', date: '2026-04-02', clientId: 'C-008', eventType: 'Membership Add-on', notes: 'Upgraded to membership tier', saleTotal: 0, costToUs: 0, loggedBy: 'CA-02' }, { id: 'GE-005', date: '2026-03-28', clientId: 'C-013', eventType: 'Referral 1+', notes: 'Referred Cobra Kai Denver', saleTotal: 0, costToUs: 0, loggedBy: 'CA-03' }, { id: 'GE-006', date: '2026-04-18', clientId: 'C-002', eventType: 'Case Study', notes: 'Q1 case study published', saleTotal: 0, costToUs: 0, loggedBy: 'CA-01' }, ]; const SEED_SURVEYS = [ { id: 'SR-001', date: '2026-03-15', clientId: 'C-001', overall: 5, responsiveness: 5, followThrough: 5, communication: 4, anonymous: false, comment: 'Best decision we made this year.', submittedBy: 'CA-01' }, { id: 'SR-002', date: '2026-02-20', clientId: 'C-002', overall: 4, responsiveness: 4, followThrough: 5, communication: 4, anonymous: false, comment: 'Solid month-over-month.', submittedBy: 'CA-01' }, { id: 'SR-003', date: '2026-03-02', clientId: 'C-005', overall: 5, responsiveness: 5, followThrough: 5, communication: 5, anonymous: false, comment: '', submittedBy: 'CA-01' }, { id: 'SR-004', date: '2026-01-30', clientId: 'C-008', overall: 4, responsiveness: 5, followThrough: 4, communication: 5, anonymous: false, comment: '', submittedBy: 'CA-02' }, { id: 'SR-005', date: '2026-03-10', clientId: 'C-013', overall: 3, responsiveness: 4, followThrough: 3, communication: 3, anonymous: true, comment: 'Want more proactive comms.', submittedBy: 'CA-03' }, ]; const SEED_ADJUSTMENTS = [ { id: 'CA-001', date: '2026-04-15', repId: 'AE-01', role: 'AE', type: 'Bonus', amount: 500, reason: 'Closed 3 contracts in March, exceeded quota', linkedClient: 'C-007', period: 'Q1 2026', status: 'Pending' }, { id: 'CA-002', date: '2026-04-10', repId: 'SDR-01', role: 'SDR', type: 'Correction', amount: 100, reason: 'Missed booking credit for Pacific MMA Lab', linkedClient: 'C-005', period: 'Q1 2026', status: 'Pending' }, { id: 'CA-003', date: '2026-03-22', repId: 'AE-02', role: 'AE', type: 'Draw', amount: 1000, reason: 'Pre-payout draw against Q2 milestones', linkedClient: '', period: 'Q2 2026', status: 'Paid' }, ]; const SEED_PENDING_CLIENTS = [ { id: 'PC-001', stripeCustomerId: 'cus_QxR9z2K7AbCdEf', name: 'Phoenix Combat Academy', monthlyRetainer: 2200, signDate: '2026-04-22', status: 'pending', source: 'stripe', detectedAt: '2026-04-22' }, { id: 'PC-002', stripeCustomerId: 'cus_QxS4m8N1HiJkLm', name: 'Test — Bobby Personal', monthlyRetainer: 1, signDate: '2026-04-23', status: 'pending', source: 'stripe', detectedAt: '2026-04-23' }, ]; const DEFAULT_CONFIG = { gracePeriodDays: 90, adSpendFloor: 1000, adSpendPctOfGross: 0.10, adSpendOverDeliveryCap: 2.0, bookingFloor: 0.30, showFloor: 0.50, closeFloor: 0.70, attritionGreenFloor: 0.03, attritionCriticalCeiling: 0.05, satisfactionLookbackMonths: 6, noResponsePenalty: 0.7, membershipRevenueRate: 0.05, sdrFlatFeePerBooking: 100, quarterStart: '2026-04-01', quarterEnd: '2026-06-30', }; // ── Reporting fixtures (v2) ───────────────────────────────────────────────── // The Leads and Ads sections read tables that no sync fills yet, so against the // live database they are honestly empty. Demo mode is where the shape can be // shown — to Bobby, to Kurt, to Mike — without a single invented row landing in // the client's Supabase. // // Deterministic on purpose: a seeded generator, not Math.random, so the demo // looks the same on every reload and a screenshot keeps matching the screen. let _rptSeed = 20260914; const rnd = () => { _rptSeed = (_rptSeed * 1103515245 + 12345) & 0x7fffffff; return _rptSeed / 0x7fffffff; }; const pick = (arr) => arr[Math.floor(rnd() * arr.length)]; const between = (lo, hi) => lo + rnd() * (hi - lo); const daysAgoIso = (n) => { const d = new Date(); d.setDate(d.getDate() - n); return d.toISOString().slice(0, 10); }; // Four books' worth of advertising — enough for the platform tabs, the campaign // and ad set levels, and the at-a-glance comparison to have something to say. const RPT_DEMO_CLIENTS = ['C-001', 'C-003', 'C-005', 'C-008']; function genAdData() { const accounts = []; const campaigns = []; const adSets = []; const metrics = []; RPT_DEMO_CLIENTS.forEach((clientId, i) => { ['meta', 'google'].forEach(platform => { const accId = `acct-${platform}-${i}`; accounts.push({ id: accId, clientId, platform, accountId: `${platform}-${100000 + i}`, name: `${clientId} ${platform === 'meta' ? 'Meta' : 'Google'} Ads`, currency: 'USD', active: true, }); const names = platform === 'meta' ? ['Free Trial Class', 'Kids BJJ Interest', 'Adult Fundamentals'] : ['Search — Brand', 'Search — BJJ Near Me']; names.forEach((name, ci) => { const campId = `${accId}-camp-${ci}`; campaigns.push({ id: campId, adAccountId: accId, platformId: `${23800 + ci}${i}`, name, status: ci === 2 ? 'PAUSED' : 'ACTIVE', objective: platform === 'meta' ? 'LEAD_GENERATION' : 'SEARCH', }); // One campaign in three performs badly on purpose, so the "needs work" // reading is visible rather than theoretical. const poor = ci === 1; for (let day = 0; day < 60; day++) { const spend = Math.round(between(18, 65) * 100) / 100; const impressions = Math.round(between(900, 5200)); const clicks = Math.round(impressions * between(poor ? 0.004 : 0.012, poor ? 0.009 : 0.031)); const leads = Math.max(0, Math.round(clicks * between(poor ? 0.018 : 0.028, poor ? 0.038 : 0.062))); metrics.push({ id: `${campId}-m${day}`, day: daysAgoIso(day), level: 'campaign', refId: campId, clientId, spend, impressions, clicks, leads, }); } if (platform === 'meta') { ['Lookalike 1%', 'Interest — Martial Arts'].forEach((sName, si) => { const setId = `${campId}-set-${si}`; adSets.push({ id: setId, adCampaignId: campId, platformId: `${6100 + si}${ci}${i}`, name: sName, status: 'ACTIVE' }); for (let day = 0; day < 60; day++) { const spend = Math.round(between(8, 34) * 100) / 100; const impressions = Math.round(between(400, 2600)); const clicks = Math.round(impressions * between(0.008, 0.028)); const leads = Math.max(0, Math.round(clicks * between(0.02, 0.055))); metrics.push({ id: `${setId}-m${day}`, day: daysAgoIso(day), level: 'adset', refId: setId, clientId, spend, impressions, clicks, leads, }); } }); } }); }); }); return { accounts, campaigns, adSets, metrics }; } // The split Bobby asked for. Weighted so paid social leads the volume and the // phone trails it, which is what a gym's book actually looks like. const RPT_LEAD_SOURCES = ['facebook', 'facebook', 'facebook', 'google', 'google', 'website', 'website', 'phone', 'referral', 'walk_in']; const RPT_FIRST = ['Marco', 'Dani', 'Priya', 'Luis', 'Tess', 'Owen', 'Grace', 'Ivan', 'Nora', 'Sam', 'Ruth', 'Kai']; const RPT_LAST = ['Alvarez', 'Boyd', 'Castillo', 'Dunne', 'Eriksen', 'Fahey', 'Gomez', 'Hart', 'Ibarra', 'Jain']; function genLeads() { const out = []; for (let i = 0; i < 260; i++) { const clientId = pick(RPT_DEMO_CLIENTS); const source = pick(RPT_LEAD_SOURCES); const age = Math.floor(between(0, 60)); const created = new Date(); created.setDate(created.getDate() - age); created.setHours(Math.floor(between(8, 20)), Math.floor(between(0, 59)), 0, 0); // A lead generated "today" between 8am and 8pm lands in the future if it is // currently 3am. Pull anything ahead of now back behind it. if (created > new Date()) created.setTime(Date.now() - Math.floor(between(1, 120)) * 60000); const stamp = (offsetDays) => { const d = new Date(created); d.setDate(d.getDate() + offsetDays); return d > new Date() ? null : d.toISOString(); }; // Funnel, thinning at each step the way a real one does. const booked = rnd() < 0.55; const showed = booked && rnd() < 0.68; const signed = showed && rnd() < 0.42; const lost = !signed && rnd() < 0.25; out.push({ id: `lead-${i}`, clientId, client: { id: clientId, name: (SEED_CLIENTS.find(c => c.id === clientId) || {}).name || clientId }, source, sourceDetail: source === 'facebook' ? 'Instant Form' : source === 'google' ? 'Search — BJJ Near Me' : null, platform: source === 'facebook' ? 'meta' : source === 'google' ? 'google' : null, firstName: pick(RPT_FIRST), lastName: pick(RPT_LAST), email: null, phone: null, createdAt: created.toISOString(), bookedAt: booked ? stamp(1) : null, showedAt: showed ? stamp(3) : null, signedAt: signed ? stamp(5) : null, lostAt: lost ? stamp(7) : null, lostReason: lost ? pick(['No answer', 'Price', 'Too far', 'Signed elsewhere']) : null, value: signed ? Math.round(between(129, 249)) : null, origin: source === 'walk_in' || source === 'phone' ? 'manual' : 'ghl', confirmedAt: rnd() < 0.15 ? created.toISOString() : null, }); } return out.sort((a, b) => b.createdAt.localeCompare(a.createdAt)); } // Sync bookkeeping, including one failure — the case the screens exist to make // visible: a number missing because the job died, not because there was nothing. function genSyncRuns() { const ago = (hours) => new Date(Date.now() - hours * 3600 * 1000).toISOString(); return [ { id: 'run-1', source: 'ghl', status: 'ok', startedAt: ago(6), finishedAt: ago(6), rowsWritten: 41 }, { id: 'run-2', source: 'meta', status: 'ok', startedAt: ago(7), finishedAt: ago(7), rowsWritten: 288 }, { id: 'run-3', source: 'google_ads', status: 'failed', startedAt: ago(7), finishedAt: ago(7), rowsWritten: 0, error: 'token expired' }, ]; } function buildSeed() { const adDemo = genAdData(); return { cas: SEED_CAS, sales: SEED_SALES, clients: SEED_CLIENTS, monthlyMetrics: genMonthlyMetrics(), growthEvents: SEED_GROWTH_EVENTS, surveys: SEED_SURVEYS, adjustments: SEED_ADJUSTMENTS, config: DEFAULT_CONFIG, pendingClients: SEED_PENDING_CLIENTS, pendingSync: [], // offline queue // v2 reporting — demo mode only. Live mode reads the real tables. leads: genLeads(), adAccounts: adDemo.accounts, adCampaigns: adDemo.campaigns, adSets: adDemo.adSets, adMetricsDaily: adDemo.metrics, syncRuns: genSyncRuns(), }; } // ── Persistence ───────────────────────────────────────────────────────────── function loadState() { try { const raw = localStorage.getItem(STORAGE_KEY); if (!raw) return buildSeed(); const parsed = JSON.parse(raw); // shallow merge with seed to gain new fields if schema evolves return { ...buildSeed(), ...parsed }; } catch (e) { return buildSeed(); } } function saveState(state) { try { localStorage.setItem(STORAGE_KEY, JSON.stringify(state)); } catch (e) { /* ignore quota */ } } function resetState() { localStorage.removeItem(STORAGE_KEY); } Object.assign(window, { CABT_loadState: loadState, CABT_saveState: saveState, CABT_resetState: resetState, CABT_buildSeed: buildSeed, CABT_genLeads: genLeads, CABT_genAdData: genAdData, });