Settings and Data Source

Settings

Data source

Every number in this application is read from the Excel workbook at build time. Replace the file in the data folder and push to main; the site rebuilds and redeploys automatically.

Brightspeed_Cancellation_Data_Jan_Sep_2026.xlsx
Located in /data · last modified 10/5/2026, 1:43:12 PM · read 10/5/2026, 1:43:34 PM
LOADED
Months
9
January 2026 → September 2026
Latest month (default)
September 2026
States
6
Michigan, Missouri, Mississippi, North Carolina, New Jersey, Ohio
Channel data
Present
Channels tab is live
Sheets
Dashboard KPI30 rows
Monthly Overview9 rows
State Monthly54 rows
September State Drill6 rows
ODD Timing9 rows
Cancel Classification9 rows
Customer Miss Reasons324 rows
Watchtower Signals7 rows
Example Customer Journey7 rows
Executive Questions5 rows
Data Dictionary19 rows
Channel Monthlyoptional63 rows
NC Agency Monthlyoptional72 rows
NC Agency Septemberoptional8 rows
NC Rep Cohortsoptional10 rows
NC Sales Representativesoptional83 rows
NC Primary Driversoptional9 rows
October Forecastoptional20 rows
October Preventionoptional17 rows
Validation (0)
All required sheets and columns were found and the cross-sheet totals reconcile.
Data dictionary
Field / KPIDefinitionUnitSource sheetNote
Unique SaleQualifying acquisition order entering the Sales to Install funnel.CountMonthly Overview / State MonthlyBusiness outcome input.
InstallsOrders completed as installed service.CountMonthly Overview / State MonthlySuccessful Unit Sales / Installed Customers.
CancellationOrder terminates before installation / activation.CountMonthly Overview / State MonthlyLeading KPI for installed customers.
Cancel RateCancellations divided by Unique Sales.%Monthly Overview / State MonthlyJan to Aug internal baseline ~15.5%.
ChurnInstalled customer disconnects after activation.%Not in this workbookKept separate from cancellation.
ODDOriginal Due Date: the original installation commitment.DateODD Timing
Pre ODD / On ODD / Post ODDCancellation before, on or after the Original Due Date.Count / %ODD TimingLagging timing KPI.
Customer Miss / Company Miss / FauxRecorded responsibility classification.Count / %Cancel ClassificationEvidence adjusted NC view in NC Root Cause Classification.
Pending Customer ContactWatchtower state: customer contact unresolved.%Watchtower SignalsLagging customer process KPI and predictive input.
Install in Jeopardy / BSW Delay PredictedWatchtower operational and construction risk states.%Watchtower SignalsLagging delivery KPIs.
ChannelSales channel: D2D, Digital, Digital Partner, Inbound, Indirect, OBTM, Other.CategoryChannel Monthly
AgencySales partner (or in house team) selling through a channel.CategoryNC Agency Monthly / NC Agency SeptemberAlpha = NC D2D; Beta and Gamma = NC Digital Partner.
Partner dispositionCompletion based band: Strong (cancel ≤15%), Steady (≤20%), Below Target (≤30%), Weak (>30%).CategoryNC Agency MonthlyExisting Watchtower partner labels.
Sales representativeIndividual seller at an agency.IDNC Sales RepresentativesIllustrative IDs, not real people.
Representative bandCancel rate band: Low ≤15%, Watch ≤25%, High ≤40%, Critical >40%.CategoryNC Sales Representatives / NC Rep CohortsExisting Watchtower representative bands.
Primary driverOne primary cause per ORDER_ID so buckets reconcile without double counting.Count / %NC Primary Drivers955 / 1,313 / 567 / 148 = 2,983.
Cancellation propensityOrder level probability of cancellation from sales quality analysis.Score 0 to 100October PreventionPredictive overlay.
Leading KPIKPI that directly explains movement in a higher level outcome: Cancellations lead Installed Customers.KPI Driver Tree
Lagging KPIDeeper driver KPI explaining why the leading KPI moved (Post ODD, agency, rep, Pending Contact, No Access, BSW).KPI Driver Tree