Platform comparison · Lead → Appointment → Conversion funnel reactive to date picker
Attribution: FB/IG lead counts use MS Forms source distribution (FB 85.4%, IG 0.7%) applied to period MS Forms. TikTok uses its own platform-tracked leads. WLG uses the CS Backend data (separate program).
Appt/IVF are pro-rated by lead share for FB/IG/TT (no per-channel appointment tracking in current NLG data). WLG shows its actual tracked appointments and conversions.
Ad spend distribution by platform · period
Efficiency comparison · Cost per Lead vs Cost per IVF
Cost per LeadCost per IVF
Lead → Appointment conversion rate % of leads that book
Appointment → IVF conversion rate % of appts that become IVF
synthetic sample data for this synthetic demo · 2025 full year + 2026 Jan–Jun · reactive to date picker
Facebook · anchor: May 2026 · MoM = vs previous month · YoY = vs same month prior year
Full monthly data 2025 + 2026 · synthetic sample data
Health indicators appt rate · IVF rate · quality signals
Lead status quality period
NLG Campaign Waterfall Which monthly campaigns are most effective · leads → conversion → revenue timing
Campaign cohort view — NLG campaigns typically start monthly (e.g. Mar Campaign, Aug Vita, Aug 50%). This tab tracks each campaign's leads, conversion timing, and revenue realization so you can see which campaigns are actually delivering ROI vs generating dead-lead volume.
Campaign Cohort Waterfall each row = one campaign · walk right to see when revenue landed
Revenue per lead by campaign effectiveness scoring
Cycle time by campaign average days from lead → convert
Synthetic sample records · illustrative revenue · sample providers
Revenue Waterfall Lead → conversion timing · when leads came in vs when revenue booked · reactive to date picker
Cohort waterfall view — WLG leads and IVF conversions happen in different months. This tab tracks that timing gap so you can see revenue booked per month vs. the source-month cohort that generated it.
Cohort Waterfall each row = one WLG source cohort · walk right to see when its revenue landed
Patient conversion timeline each bar = one patient · left edge = WLG date · right edge = conversion date · length = cycle time
Cycle time distribution days from WLG date to IVF conversion
Revenue booked vs source month where the cash landed vs where the lead started
Patient-by-patient revenue detail all converted WLG patients · sorted by conversion date
TLG · TikTok Lead Generation · 100% synthetic sample data · Jan–Jul 2026 · from the synthetic sample dataset · reactive to date picker
TLG Program overview · H1 2026 · TikTok Master Lead data
TLG conversion funnel Leads → Appts → IVF
Lead quality breakdown potential vs disqualified
Monthly performance leads · appts · IVF by month
Health indicators appt rate · IVF rate · disq rate
Top callers period · leaderboard
TLG program · Jan–Jul 2026 · detailed metrics
Status breakdown by call outcome
Caller leaderboard period · filtered
Monthly TLG breakdown Jan–Jul 2026
Lead Waterfall Lead flow · potential vs disqualified by month · conversion timing
Lead quality waterfall each month: total leads → potential → disqualified → appointments
Ideal patient persona AI-modelled from highest-converting segments
AI audience analysis generated insights + targeting recommendations
Real province data from Sample MS Forms Jan–Jun 2026 · vs Sample in 2025 H1
Top province
Phnom Penh
747 · 56.5% of all leads
Provinces reached
20+
Nationwide coverage
Outside Phnom Penh
574
43.5% (non-urban demand)
Cambodia lead distribution map
tile-map cartogram · hover for details · click to focus
Leads:
Low→High★ Capital◆ Tonle Sap▨ No data
Top 15 provinces Jan–Jun 2026
Phnom Penh vs rest 56.5% / 43.5%
Top 10 provinces
Province
Leads
%
Phnom Penh
747
56.5%
Kandal
102
7.7%
Prey Veng
56
4.2%
Takeo
50
3.8%
Kampong Speu
44
3.3%
Kampong Thom
40
3.0%
Siem Reap
40
3.0%
Kampong Cham
39
3.0%
Battambang
35
2.6%
B. Meanchey
29
2.2%
Phnom Penh concentration up — 56.5% (2026 H1) vs 54.5% (2025 H1). Rural demand slightly softening. Consider targeted Facebook regional campaigns for Kandal/Prey Veng/Takeo (combined 208 leads = 16% of total).
Ready for expansion strategy? Switch to the Nexus AI · Geographic tab for province opportunity scoring, whitespace analysis, and campaign recommendations.
Nexus AI · Geographic intelligence
Province opportunity scoring, market penetration analysis & expansion recommendations
AI POWERED
Province opportunity score AI-ranked by leads × market size × penetration gap
Market penetration vs potential bubble size = current leads · x = population · y = penetration rate
Regional cluster analysis grouped by geography · reveals where to concentrate campaigns
Whitespace opportunities provinces with high population but low Northstar penetration
AI geographic analysis strategic expansion insights + campaign recommendations
Generate report
H1 2026
Selected month only
Extended Analytics (optional)
19 sections selectedCover + TOC + Close added automatically
Data range
Selected month only
Extended analytics sections
7 / 7
Toggle each Extended section on/off · only applies to Full marketing report
Data comparison mode
N/A FALLBACK
When enabled, unavailable data renders as N/A instead of being hidden
What's inside the report up to 23 slides · fully editable · toggle Extended for 17-slide classic
Overview section
1Title slide · themed cover & stamp
2-3Contents · 2 pages (Core + Extended)
4Executive summary · KPIs, YoY, narrative
5Period comparison · MoM & YoY tables
6Marketing efficiency · CPL by platform
7Lead funnel · TOFU → BOFU cascade
Detail section
8Facebook · reach & CPL trend
9Instagram · TikTok · secondary paid
10Website · GA4 traffic & engagement
11SEO Performance · GSC clicks & ranking NEW
12NLG program · leads → appts → IVF
13WLG program · FN vs KH · NIP/EIP
14Audience & province · geo distribution
15SWOT · auto-generated strategy view
Extended NEW
16Financial & ROI · CAC, ROAS by platform
17Funnel operations · speed-to-lead, scoring
18Creative performance · top assets, attribution
19Retention & LTV · cohorts, LTV:CAC
20System & data health · pixels, alerts
21YoY comparison · headline growth story
22Recommendations · priority-ranked actions
23Closing · thank you & next review
How PowerPoint export works
Client-side generation. The report is built entirely in your browser — no server needed, no data leaves your machine. NexusIntel uses PptxGenJS, an open-source JavaScript library that constructs valid Microsoft Office .pptx files (which are ZIP archives of XML) directly in the browser using JSZip.
Three design templates — Corporate (navy + indigo, classic business), Northstar Brand (warm neutral with rose/amber, matches clinic identity), and Modern Dark (bold high-contrast for large-screen presentations). Each theme controls slide backgrounds, header bars, accent colors, KPI card fills, chart palettes, and typography sizing consistently across all slides.
Slide master. Every content slide inherits a shared master: header accent bar, slide title, section marker, page number, brand mark, and confidentiality footer. Charts use the theme's color palette; KPI cards use themed backgrounds with contrast-appropriate text.
Fully editable output. Every slide element — text, chart, table, shape — is a native PowerPoint object. Open in Microsoft PowerPoint, Google Slides, Keynote, or LibreOffice Impress and edit as normal.
Data Integrations
Loading…
Download the Excel template for any source → fill in your data → upload it back to import. Or connect the vendor API for automatic sync.
Nexus AI Forecasting
Learned from your H1 2026 data · Sample MS Forms records · 3 platform campaigns
Input your planned monthly ad budget across Facebook, Instagram, and TikTok. Nexus AI will forecast the resulting funnel outcomes — impressions, leads, appointments, IVF conversions, and revenue — using historical conversion rates and a diminishing-returns curve at scale.
Focus
Mode
Baseline scenario compare your target budget against this
Predicted funnel outcomes TOFU → BOFU flow with predicted volumes
Platform contribution predicted leads and revenue by channel
Sensitivity analysis "what if" budget scenarios
LeadsIVFRevenue $K
Shows forecast at 50%, 75%, current, 125%, 150%, and 200% of your input budget. Note diminishing returns above 150% baseline.
Nexus AI narrative generated analysis + strategic recommendations
Facebook competitor benchmark
Northstar vs 7 competitors · Jan–Jul 2026 · synthetic month-over-month sample data · page followers, growth & posting cadence
Synthetic IG sample data: Instagram figures reflect illustrative competitor follower counts and post frequency. Note IG follower counts are much smaller than FB — Sample Brand Four dominates IG (Sample flat) while Northstar leads on FB (Sample).
Chart type:
View:
Market position June 2026 · ranked by followers
Follower share of voice % of combined 5-clinic audience
Total page followers · trajectory Linear scale · Northstar dominance visible
Competitor race Northstar excluded · the 4 competitors on a comparable scale
New-follower momentum monthly acquisition trend
Publishing cadence posts per month · content volume
Competitor leaderboard June 2026 · ranked by followers
Follower gap vs Northstar how far behind competitors are · June 2026
Nexus AI competitive analysis generated from live benchmark data · reactive to date picker
How competitor data collection works automated pipeline · currently using slide data
1 · Data Extraction
Meta Graph API (own page) + Web scraping (competitors)
→
2 · Storage
PostgreSQL / BigQuery · historical rows
→
3 · Query Engine
SQL / REST API → this dashboard
Owned page (Northstar)
Meta Graph API. A Facebook Page Access Token programmatically fetches Northstar's own metrics — page_fans, page_impressions, post counts, daily follower growth — in real time via backend API calls.
Competitors
Meta restricts granular competitor analytics, so two automated options fill the gap: public web scrapers (Puppeteer, Selenium, or scraping APIs navigate competitor pages daily and output clean JSON) and third-party aggregators (Supermetrics, SocialPilot, Fanpage Karma feed comparison metrics via their APIs).
Database schema · social_benchmarks
date
page_name
followers
posts
growth
2026-06-01
Northstar
Sample
58
8,800
2026-06-01
Sim Phally
81,100
20
1,100
Sample period
Sample Brand Four
Sample metric
Sample metric
Sample metric
Run-rate query. Because rows are stored historically (not static slides), the backend computes catch-up time on the fly: months = (competitor_followers − your_followers) / (your_growth − competitor_growth)
Financial & ROI attribution
CAC · ROAS · budget pacing across FB · TikTok · IG · NLG vs WLG · linked to date picker
Attribution note:All ad spend attributed to NLG (WLG conversions come from CS-team outbound calls, not ads). Editable in Settings.
ROI headline · H1 2026 · reactive to date picker & comparison view
Per-program economics · CAC · NLG vs WLG
Funnel depth:
CAC by program × platform grouped bars · lower is better
FacebookTikTokInstagram
Per-platform CAC uses platform-share of spend (from real sp fields) × program-share of appointments. Values are directional — attribution matures as we tag leads with source in production.
ROAS trend monthly · per program
NLGWLGBreak-even (1×)
Funnel efficiency health CPL · CPA · CAC · reactive to period & allocation
How health is scored: Absolute-level thresholds tuned for fertility-clinic economics (avg NLG package $6,200). CAC uses LTV:CAC ratio — 10×+ is excellent, 3–10× healthy, <3× needs attention. CPL & CPA use per-lead / per-appointment cost bands.
What the numbers say CAC narrative · toggle to switch
Budget pacing cumulative daily spend vs ideal pace · click Settings to edit targets
What % of ad spend is attributed to each program? Adjusts CAC, ROAS and per-program economics everywhere in NexusIntel. Default: 100 / 0 — WLG is CS-team-driven, not ads.
%
%
Sum100%
Allocations must sum to exactly 100%
Monthly budget targets
Used by the budget pacing panel to compute Under / On / Over-pace status. Defaults match your Jan–Jun 2026 typical monthly spend.
$
$
$
Funnel operations
Lead scoring · speed-to-lead · operational funnel · linked to date picker
SLAmin
Per-lead data note: Your monthly totals (D26) are exact. Per-lead timestamps, response times, and score signals are synthesized from those totals with distributions tuned to fertility-clinic norms (log-normal response times, industry drop-off ratios). Aggregate counts always match D26 — verify by comparing Total leads here vs. Overview.
Operational headline · H1 2026
Lead score distribution Hot · Warm · Cold · reactive
HotWarmCold
Response-time distribution minutes to first-touch · SLA line marks target
LeadsMedian (p50)SLA target
Response time by platform median (p50) & 90th percentile (p90)
Median (p50)p90
SLA breaches leads exceeding SLA · newest first
Operational funnel Lead → Contacted → Qualified → Consult booked · click program to switch
Recent scored leads sample of latest 12 leads · newest first
Operational insight
Lead scoring rules
Weights sum to a score · 7+ Hot · 4–6 Warm · <4 Cold
Per-asset data note: Real platform spend from FB/TT/IG.26[m].sp is proportionally distributed across 24 synthesized creative assets. Attribution journeys are seeded from H1 conversion volumes so credited totals equal 107 NLG IVF conversions across all attribution models.
Creative overview · H1 2026
Top performers best CTR · lowest CPL · highest lead volume · sharpest fatigue
Creative performance click column headers to sort · fatigue bar shows 30-day CTR trend
Asset
Platform
Format
Spend
Impressions
CTR
Leads
CPL
Fatigue (30d CTR trend)
Multi-touch attribution how conversions are credited across the patient journey
Model:
Credit flow under the selected model · ribbon width = attribution credit received · toggle a different model to see the flow rearrange
Credited conversions per platform
What each model means
Creative insight
Retention & lifetime value
Patient journey · cohort retention · LTV:CAC unit economics · linked to date picker
Data provenance: Funnel counts use synthetic sample fields (a consults, q qualified, ivf conversions) and WLG_MONTHLY. Cohort retention curves are synthesized from realistic drop-off patterns (100% M0 → ~40% M5). CAC values read from programCAC() in Phase 0 so LTV:CAC ratios cannot disagree with P14.
Lifetime-value headline · H1 2026
Patient journey funnel Consult → Diagnostics → Active IVF → Completed · drop-off between stages
Cohort retention heatmap % of consult cohort still engaged N months later · 5-step Northstar ramp
Retention scale:<30%30-50%50-70%70-90%≥90%Diagonal white cells = not yet observable (cohort hasn't lived that long)
NLG unit economics estimated · $6,200 avg package
WLG unit economics synthetic sample revenue from WLG_MONTHLY
Payback period days to recover CAC per program
Stage conversion rates per-program conversion at each funnel step
Simulated alert delivery: This is a standalone HTML file. Rule evaluation and alert firing are real (against your D26/FB/TT/IG data), but Email · Telegram · WhatsApp delivery is simulated. In production, alerts would call configured channels via the P11 integrations. Pixel status reads from your P11 integration state — disconnecting an integration on P11 will show as Degraded here.
System headline · H1 2026
Data feed & pixel status tracking source health · linked to P11 integrations
Alert rules enabled rules run against the current period · click a rule to edit
0 rules configured
On
Rule name
Metric
Program
Condition
Channel
Actions
Recent alerts newest first · last 15 fires
Channel routing where alerts get delivered
System insight
New alert rule
Watch a metric · fire when the condition trips
Note: Channel delivery is simulated in this demo — alerts fire and log to the history panel, but no actual message is sent. In production, wire this to your P11 integrations.
Year-over-year comparison
H1 2025 vs H1 2026 · every headline metric side-by-side
2025 data coverage: Lead funnel counts (leads, appts, IVF) are complete for all months. Ad spend for 2025 is partial — TikTok spend covers all of 2025, Instagram from Jun 2025 onward, Facebook only Oct-Dec 2025. Where 2025 spend data is missing, delta cells show "— no baseline" instead of fabricating a comparison.
Headline comparison · the story in three numbers
Volume metrics lead funnel · from D25 and D26
Financial metrics ad spend · CAC · ROAS · revenue
Program breakdown NLG vs WLG · year over year
NLG program
WLG program
Monthly trend · 2025 vs 2026 toggle metric below
20252026
Year-over-year narrative
NexusIntel AI
Data narrative agent · powered by Claude
Metric
—
Click any KPI card to get an AI-generated insight.