BSP Intelligence
Before/After
The Stack
For You
Weather
Neighborhoods
Financials
Zeus RAG
Status
Weather Budget
Session Wins
Sewer Data
Deliverables
Tuesday Intelligence Brief
Tuesday, April 8, 2026 at 11:00 AM CT
Every decision backed by data. Every dollar traced to its source.
Scroll to explore the stack
The Paradigm Shift
What changed when we turned on the Intelligence Stack.
BEFORE
✗ Static reports updated manually✗ Revenue numbers from memory (often wrong)✗ No idea which marketing source works✗ Weather happens, we react✗ Neighborhood targeting = gut feel✗ Meeting prep = scramble morning-of
AFTER
✓ 6 live APIs feeding one brain✓ Every dollar traced to its campaign source✓ 11,766 completed jobs attributed to 24 sources✓ Weather predicts demand 48 hours ahead✓ 109 neighborhoods scored by pipe failure risk✓ Meeting brief auto-generates with AI summary
The Intelligence Stack
Six data sources, one intelligence layer, four outputs. All connected, all live.
Data Sources
📊
ServiceTitan API
11,766 jobs
💰
QuickBooks API
$331K income
💳
Ramp API
$15.6K tracked
⛅
Weather NWS API
Live KC Metro
🤖
Claude 3.5
AI analysis
⚡
Zeus RAG
2,808 chunks
↓
Intelligence Layer
🎯
Attribution Engine
Which marketing channel brought each customer and each dollar
🗺
Neighborhood Risk Scoring
109 zips scored by housing age + tree cover + job history = pipe failure probability
🌡
Demand Forecasting
Weather + seasonal + historical = what calls are coming and when
↓
Outputs
What This Means For You
Plain language. Real numbers. No jargon.
01
We Know Where The Money Is
66212 Overland Park: $493K from 188 jobs. 64114 KC: $155K from old housing stock. We target neighborhoods where pipes are oldest and revenue is highest.
02
We Know What's Coming
Friday: 83% rain probability. Our AI says 2-3x sewer backup calls. Camera crews staged. Ads already boosted. We are ready before the phone rings.
03
Every Dollar Has A Name
QB says $331K income, $149K expenses, 54.9% margin. Ramp tracks every supply run (Ferguson $2.5K, Winnelson $874). ST traces every job to the ad that brought it.
04
The AI Works For Us
Zeus RAG has 2,808 chunks of our institutional knowledge. Ask it anything about our business. Claude writes the meeting brief. Daniel AI answers calls with our playbook.
Live Weather Intelligence
Kansas City Metro conditions and demand signals.
Kansas City Metro Area
Live from National Weather Service API
HIGH PRIORITY
HEAVY_RAIN_FORECAST
Friday
Sewer backup surge incoming. Stage camera equipment. Rain events drive 2-3x sewer calls. Camera inspection = 35% close rate at $299.
OPPORTUNITY
SPRING_THAW
Active Now
Peak sewer season starting. March through June = peak per Kalen. Maximum sewer campaign budget.
Neighborhood Risk Map
Click any pin to see the full intelligence profile. Bigger circle = more revenue. Color = risk level.
Risk Levels
Circle size = total revenue
Top 10 Zips: Quick Stats
Total Revenue $2,162,964
Total Jobs 791
Avg Ticket $2,734
Avg Housing Age 69.5%
Avg Tree Cover 63.5%
How to read this map: Housing Age = % of pre-1970 homes (cast iron/orangeburg pipes). Trees = canopy density (root intrusion risk). Higher composite score = more pipe failures = more revenue. BSP HQ shown as the yellow star.
Zip
Area
Score
Risk
Housing Age
Trees
Revenue
Jobs
Avg Ticket
64114 Leawood / South KC 59.7 HIGH 85% 70% $155,596 52 $2,992 66205 Mission / Fairway 57.2 HIGH 68% 80% $171,647 75 $2,289 66207 Overland Park East 55.8 HIGH 60% 70% $246,904 87 $2,838 66212 Overland Park Central 55.6 HIGH 65% 55% $493,846 188 $2,627 66203 Shawnee / Merriam 55.3 HIGH 75% 55% $198,627 64 $3,104 66204 Mission / Overland Park 54.4 HIGH 72% 50% $165,297 89 $1,857 64131 South Kansas City 54.4 HIGH 80% 65% $64,215 27 $2,378 66206 Leawood North 54.2 HIGH 65% 75% $85,418 34 $2,512 66208 Prairie Village 53.2 HIGH 55% 65% $249,131 115 $2,166 66202 Shawnee 50.7 HIGH 70% 50% $132,283 60 $2,205
Financial Truth
QuickBooks P&L + Ramp expense tracking. 90-day window.
$331,416
QB Income (90 days)
QuickBooks P&L verified
$149,395
QB Expenses (90 days)
All categories included
$182,021
Net Income | 54.9% Margin
Revenue minus all expenses
Ramp Top Merchants This Week
$2,504
Ferguson Enterprises
$1,609
Savannah Winlectric
$875
Fort Collins Winnelson
Ask Zeus Anything About Our Business
2,808 knowledge chunks from playbooks, field notes, job data, and 21 sessions of institutional memory.
?
What is our sewer camera close rate and how do we improve it?
?
What is the average ticket for sewer replacement jobs?
?
Which zip codes have the highest revenue per job?
?
How does Daniel AI handle after-hours calls?
?
What are the most common reasons customers call back?
?
What marketing source brings the highest ticket customers?
?
What happens to call volume during freezes?
?
What upsell opportunities exist on drain cleaning jobs?
$
What should we charge for a sewer camera inspection and why?
$
What is the pricing strategy for water heater replacement?
$
How does our pricebook compare to competitors in KC?
$
What is the dispatch fee policy and when do we waive it?
Ask Zeus
Data Sources Status
All 6 APIs connected and feeding the Intelligence Stack.
ServiceTitan API
11,766 jobs synced
QuickBooks API
P&L live, token auto-refreshes
Ramp API
Expense tracking live
Weather NWS
KC Metro live
Claude 3.5
AI analysis active
Zeus RAG
2,808 knowledge chunks
Severe Weather Auto-Budget System (Proposed)
Automated Google Ads budget scaling triggered by NWS weather data
HOW IT WORKS
🌥
NWS API
Checks every 6 hours
➤
⚡
TRIGGER
Precip >60% or thunderstorms
➤
📈
BOOST 300%
Emergency campaign scales up
➤
☀
AUTO-REVERT
Next day when weather clears
NORMAL BUDGET: $381/day
Sewer Campaign
$196/day
LSA
$100/day
Emergency
$50/day
Sump Pump
$20/day
Brand
$15/day
SEVERE WEATHER BUDGET: $581/day
Sewer Campaign
$250/day (+$54)
Emergency
$200/day (+$150, 300%)
LSA
$100/day
Sump Pump
$20/day
Brand
$15/day (unchanged)
7-Day Forecast Trigger
TODAY
Thunderstorms 55%
Thursday: Thunderstorms 51%
Saturday: Sunny, clear
Extra Daily Spend
$200
On storm days only
Projected ROI
80x
$200 in, $16,033 out
7 extra leads per storm day
Session Accomplishments
April 3, 2026 Build Session
✓
Claude Sonnet 4 powering intelligence - swapped from Gemini for all Nexus AI systems
✓
Daniel AI: transport fixed - 1.5s delay, Ashton voice calibration, 3CX routing verified
✓
115 keywords pushed to Google Ads - sewer, drain, and emergency campaign coverage
✓
Blog: 20+ Kalen edits, active voice mandate - sewer camera inspection blog polished
✓
Email campaign: 4,731 contacts - 6 tiers segmented, Google Sheet ready for review
✓
Fake review detection: 6 engines - thesis-grade dictionaries for competitor review analysis
✓
8 playbooks enriched + tabbed - intelligence docs upgraded across the board
✓
Sewer budget $150 to $196 - highest-ROI campaign gets biggest allocation
Ashton Sewer Data
Historical sewer job analysis from ServiceTitan
Sewer Jobs Analyzed
149
Completed sewer service calls
Revenue Recovered
$262K
$262,037 from sewer services
Total Data Points
432
Records across all sewer categories
New Deliverables
Intelligence documents deployed this session