Owner: Robert | Priority: IMMEDIATE
Current monthly revenue by channel. Data from Monday standup, March 2026.
| Channel | 90-Day Revenue | % of Total | Avg Ticket | Status |
|---|---|---|---|---|
| Existing Customers | $293,075 | 41% | $3,085 | Highest Value |
| Google LSA | $175,809 | 25% | $1,418 | 16.6x ROAS |
| Service Direct | $112,047 | 16% | $1,418 | 4.3x ROAS |
| Google Organic | $78,903 | 11% | $1,160 | Free Traffic |
| Service Local Pro | $25,567 | 4% | $1,023 | 1.3x ROAS |
| Google Ads (PPC) | $0 | 0% | N/A | No Tracking |
| Inspector Nick | $0 | 0% | N/A | 1 completed, $0 rev in ST |
| Detail | Current | After Fix |
|---|---|---|
| Active Account | 7269555791 | Same |
| MCC | 8449092450 | Same |
| Weekly Spend | ~$1,250 [VERBAL, verify in Google Ads] | Same (tracked) |
| Conversion Tracking | NONE | Phone calls + forms + bookings |
| ROI Visibility | 0% | 100% |
| Campaign Status | All 41 PAUSED (do NOT reactivate) | Evelyn builds NEW campaigns by service type |
| Deactivated Accounts | AW-404985988, AW-242993149 (purged from all systems) | |
Current service booking rates and new categories to add:
| Service | Avg Ticket | Target Persona | Why This Persona | Status |
|---|---|---|---|---|
| Drain Cleaning | [Need ST data by service type] | Emergency Eric/Erica | Can't open it themselves, need same-day | Active |
| Sewer Repair | [Need ST data by service type] | Emergency Eric/Erica | Sewage backup, pipes burst, panic mode | Active |
| Emergency Heaters | [New category] | Emergency Eric/Erica | No hot water, need it NOW | Add Now |
| Water Heater (Upgrade) | [New category] | Renovation Rachel/Ryan | Planned upgrade, researching options | Add Now |
| Leak Detection | [New category] | Emergency Eric/Erica | Active leak, water damage risk | Add Now |
| Sump Pump Service | [New category] | Emergency Eric/Erica | Basement flooding, urgent | Add Now |
Scientifically derived from analysis of every BSP review across 6 platforms. These drive ALL marketing decisions.
Audrey's Vision: Field Media Intelligence System
Every job is a content opportunity. Techs capture Before/During/After. Audrey transforms raw captures into brand-quality content. Juxtaposition IS the brand: taking something ugly and making it gorgeous.
| System | Purpose | Status |
|---|---|---|
| Field Media Capture Guide | Before/During/After photo+video checklist for techs. Service-specific shot lists. | Live in Dashboard |
| Juxtaposition Gallery | Brand-defining before/after showcase. 6 service categories. | Live in Dashboard |
| Content Elevation Pipeline | Raw tech capture to brand-quality transformation tracker. | Live in Dashboard |
| Design Studio (7 Brief Types) | Auto-generates creative briefs from field intel. All 4 personas. | Live |
| Metricool Social Monitor | Pull analytics from FB, IG, TikTok, LinkedIn, X. | Needs API Key |
| Tech Facebook Mining | Surfaces interesting tech posts for Audrey to elevate. | Needs Metricool |
| Social Media Vault | Photo/video library by category with sub-categories. | Needs Content |
| # | Title | Target Persona | Status |
|---|---|---|---|
| 1 | That Sewer Smell Won't Go Away? Here's What's Rotting Under Your KC Home | Emergency Eric | Ready |
| 2 | What a Sewer Camera Actually Shows You (and Why Most KC Plumbers Won't Let You Watch) | Maintenance Mike | Ready |
| 3 | Your Water Heater Is Leaking Right Now? Do These 3 Things Before It Floods | Emergency Eric | Ready |
| 4 | Can't Find Your Sewer Cleanout in Overland Park? Here's Where It's Hiding | Renovation Rachel | Ready |
| 5 | Water Heater Replacement Cost in KC: The Real Numbers | Renovation Rachel | Ready |
| 6 | How to Choose a Plumber in the KC Metro Without Getting Burned | Renovation Rachel | Ready |
| 7 | Sewer Repair Kansas City: Cleanout, Root Intrusion + Long-Term Solution | Renovation Rachel | Ready |
March 3-9, 2026. Systems deployed, infrastructure hardened, intelligence activated.