BSP API Arsenal: Every Tool Weaponized

8 active APIs, 303 experiments, $3.66M annualized. This is what powers the machine.

8
Active APIs
303
Experiments
$3.66M
Annualized Rev
11,831
Jobs Synced
334x
Daniel ROI

API Capability Registry

8 APIs Active
ST

ServiceTitan

active

Jobs, Customers, Pricebook, Estimates, Calls, Dispatch. The operational backbone.

400 Pricebook Items
11,831 Jobs Synced
8,284 Estimates
  • Jobs v2
  • Customers
  • Pricebook v2
  • Estimates
  • Calls/Telecom
  • Dispatch Assignments

Contract renewed through 2027

GA

Google Ads

active

Campaigns, Keywords, Conversions, Offline Upload. Smart Bidding re-learning.

$4,436 MTD Spend
4 Calls Uploaded
7 Active Campaigns
  • Campaign Management
  • Keyword Management
  • uploadCallConversions
  • Offline Import (MCC)
  • Budget Adjustments

Smart Bidding re-learning after conversion cleanup

QB

QuickBooks

active

P&L reports, OAuth refresh with token rotation. Financial SSoT.

$79,742 Net Income
Auto Token Rotation
  • P&L Report
  • Token Auto-Refresh

Critical: save new token every refresh cycle

$$

Ramp

active

Transaction data, merchant breakdowns. COGS visibility.

996 Rows Synced
$14,404 April Spend
  • Transactions
  • Merchants

932+ transactions in COGS analysis

GM

Gmail

active

Read, Send, Search via OAuth2. Google Support case managed.

OAuth2 Auth Method
Auto Calendar Sync
  • Read Messages
  • Send Messages
  • Search
  • Calendar Integration
DA

Vapi / Daniel AI

active

AI receptionist. 7 tools, call forwarding, after-hours booking.

7 Tools
38 Calls/Week
334x ROI
$75 /Month
  • Phone Forwarding
  • After-Hours Booking
  • Transfer to Live Agent
  • Knowledge Base Query

Phone: (913) 963-9817 via Telnyx

SL

Slack

active

Win alerts, Daniel notifications. Wins only -- no error noise.

Wins Alert Type
Daniel Notifications
  • Incoming Webhooks
  • Channel Messages

WINS ONLY policy enforced

AI

OpenAI / Claude

active

RAG synthesis, Zeus brain, content generation, repair agent.

2,808 RAG Chunks
54 Graph Nodes
10 Math Formulas
  • Zeus RAG Search
  • Zeus Ask v2 (Cited)
  • Context Harness
  • Repair Agent

Intelligence Stack: 7 APIs on port 8765

🌟

Perplexity Enterprise - New Weapons (Apr 2026)

5 Features

Computer for Enterprise

Build apps and dashboards in minutes. Connect to 100+ apps. Assign tasks directly in Slack.

USE FOR: Quick client-facing reports, competitive dashboards, Stephanie-ready financial summaries in seconds.

Final Pass

Upload docs, get inline error flagging. Checks numerical consistency. Verifies claims against live sources.

USE FOR: QA Sacred v2 before standups. Catch stale numbers automatically. Validate blog stats against real data.

Premium Sources

CB Insights, PitchBook, Statista. Enterprise-grade data normally behind $10K+ paywalls.

USE FOR: KC plumbing market sizing, competitor funding data, verified industry stats for Stephanie presentations.

Comet Enterprise

AI-powered browser for rapid research. Already have access. Audrey actively using it.

USE FOR: Meeting prep, competitor service page research, email draft generation, vendor evaluation.

App Connectors

Snowflake, Apollo, Gong, Airtable. Direct integrations for data flow.

USE FOR: Future CRM integration if BSP moves to Airtable. Apollo for lead enrichment. Gong for call analytics.
🤖

Vapi (Daniel AI) - Feature Watchlist

334x ROI

Current State: 7 Tools, $75/month

AI receptionist handling 38 calls/week. After-hours booking. Transfer to live agent. Knowledge base queries.

CapabilityStatusNotes
Phone Forwarding via 3CX LIVE (913) 963-9817 through Telnyx to 3CX
After-Hours Booking LIVE Captures name, phone, service type, urgency
Transfer to Live Agent LIVE Fixed Apr 2 -- state + select + email flow
Knowledge Base LIVE BSP services, pricing, service area
Call Transcripts LIVE Every call logged and searchable
Webinar Apr 28 WATCH Robert invited -- new features preview
Multi-Language (Spanish) NEXT Spanish speakers turned away per Service Direct analysis
SMS Booking Confirmation NEXT Send confirmation text after transfer/booking
10DLC Registration BLOCKED Needs BSP EIN from Stephanie for Telnyx SMS
📈

Google Ads API - What We Built

$4,436 MTD

Fully Weaponized Google Ads Pipeline

From campaign management to offline conversion upload. Smart Bidding re-learning after conversion cleanup.

CapabilityStatusImpact
uploadCallConversions LIVE 4 calls uploaded. Feeds Smart Bidding real conversion signals.
Offline Conversion Import LIVE MCC-level target. ST Job Completed to Google Ads.
Campaign Pause/Enable LIVE Used to pause Emergency campaign. API-driven budget control.
Budget Adjustments LIVE Weather Engine triggers auto-budget changes based on NWS signals.
Keyword Management LIVE Negative keyword scripts deployed. Sewer keyword expansion.
Conversion Cleanup DONE 19 junk primary conversions removed. Book Appointment = default.
Enhanced Conversions (Leads) NEXT GTM tag ready. Needs publish. Will improve match rates.
Location Targeting Fix DONE 6/7 campaigns had zero location targets. $17K+ waste fixed.
CRITICAL LESSON: 19 junk PRIMARY conversions were feeding Smart Bidding garbage data. Book Appointment must be account-default. ST Job Completed was INACTIVE. Fixed and re-learning.
NEXT: Enhanced Conversions for Leads (GTM tag ready, needs publish). Will improve offline conversion match rates significantly.
🛠

ServiceTitan API - Current State

11,831 Jobs

Operational Data Pipeline

Full ETL from ServiceTitan into Titan PostgreSQL. Jobs, customers, estimates, calls, dispatch.

EndpointStatusRecordsNotes
Jobs v2 11,831 Main revenue pipeline. Use job.total (float) for revenue.
Customers Synced Customer records with contact info.
Pricebook v2 400 items 3 endpoints confirmed working. Categories, items, pricing.
Estimates 8,284 Full estimate history with line items.
Calls / Telecom 403 Call logs synced. Campaign attribution via campaignId.
Appointments Active Used for schedule backfill. Has scheduledOn field.
Dispatch Assignments Active Tech assignment via dispatch/v2/appointment-assignments.
Webhooks N/A Returns 404. Not supported. Must poll instead.
GCLID Custom Field Planned Create custom field for Google Click ID storage.
Pricebook Tier Builder Planned Kalen chose Xactimate structure over Wealthy Plumber.
KEY FINDING: Jobs API has NO scheduledOn field. Must use Appointments API for scheduling data. Also: No webhook support (404 on all attempts). All data sync must be polling-based.
KEY FINDING: campaignId is a FLAT INTEGER (not nested object). sold_by_id = who sold. technician_id = who was dispatched. Dashboard must use correct field.
NEXT: GCLID custom field creation for click-level attribution. Pricebook tier builder using Xactimate structure. Contract renewed through 2027.
💰

QuickBooks API - Financial SSoT

$79,742 Net

P&L is the North Star

QB P&L is the single source of truth for profitability. Q1 2026: $333K income, -$18K net.

CapabilityStatusDetails
P&L Report Pull LIVE -- $611K/3mo, $2.44M annualized. Q1: $333K income, -$18K net.
Token Auto-Refresh LIVE -- Critical: must save new token on every refresh cycle.
OAuth2 Rotation LIVE -- Token auto-rotates. Stale token = locked out.
Invoice-Level Pull NEXT -- Line-item detail for job-level profitability.
Bank Feed via Plaid BLOCKED -- Stephanie must approve Plaid bank connection.
REVENUE HIERARCHY: Big Sale $64K > QB $47K > ST $29K (BROKEN). Never report ST revenue alone. Check big_sale_tracker.json first. QB P&L is SSoT.

Weather Engine (NWS API)

WATCH Tier Active

Free, No API Key Required

National Weather Service API. Auto-detects severe weather in KC metro and adjusts Google Ads budgets.

SignalStatusRevenue Impact
Active Weather Alerts Monitors Overland Park / KC metro continuously
WATCH Tier 2 signals active. Freeze warnings trigger budget increase.
Revenue Projection $3,735 projected from current weather event
Auto-Budget Adjustment Google Ads budget scales with weather severity
Rain/Freeze Detection Sewer backup correlation with heavy rain events
🚀

What's Coming / What to Watch

5 Items

Google Ads Enhanced Conversions

GTM tag is ready and configured. Needs publish to go live. Will dramatically improve offline conversion match rates.

GTM tag ready -- needs publish

Plaid Bank Connection

Would connect QB directly to bank feeds for real-time cash flow. Removes manual reconciliation.

Blocked: Stephanie approval needed

3CX Deeper Integration

Office hours fix deployed. Next: call queue analytics, hold time tracking, missed call automation.

Foundation in place

Telnyx SMS (10DLC)

SMS booking confirmations after Daniel AI transfer. Requires 10DLC registration for A2P messaging.

Blocked: BSP EIN from Stephanie

Facebook / Meta API

Token needs refresh. All Meta campaigns currently paused anyway. Re-activate when landing pages ship.

Paused: landing pages blocked on Audrey