LBR Plumbing · Business Dashboard

Demo · Dummy Data · June 2026
Starter view. Google Ads + Podium only. You see what you spend and what leads come in. No job or revenue data yet.
Google Ads ✓Podium ✓FieldEdge 🔒

Marketing Overview

Last refreshed today 6:04 AM · data through Jun 30
June 2026 ▾ 🔒 Filter by source
$5,240
Google Ads spend (June)
▲ 4.1% vs May
118
Total leads captured
▲ 9 leads vs May
$44.41
Blended cost per lead
▼ $2.10 vs May
14 min
Median first response (Podium)
▲ 3 min slower vs May

Ad spend vs leads · last 8 weeks

$0 $750 $1.5k W1W2W3W4 W5W6W7W8
Weekly ad spend Leads captured

Leads by source · June

SourceLeadsCPL
Google Ads67$78.21
Podium webchat31—
Podium reviews/SMS12—
Print (untracked)8*n/a

* Callers who mentioned the mailer. Print tracking with dedicated numbers is available in the top package.

Top Google Ads campaigns · June

CampaignSpendClicksLeadsCPL
Emergency Plumber · Search$1,98031229$68.28
Water Heater Repair · Search$1,41020418$78.33
Drain Cleaning · Search$1,12018814$80.00
Brand · LBR Plumbing$730966$121.67

Latest Podium leads

LeadChannelReceived
M. Herrera · "water heater leaking"WebchatJun 30, 4:12 PM
D. Okafor · "quote for repipe"SMSJun 30, 1:47 PM
S. Tran · "clogged main line"WebchatJun 30, 9:20 AM
R. Whitfield · "toilet install x2"WebchatJun 29, 6:03 PM
🔒 What happened to these leads? Did they book? What did the jobs pay? That's the Full Funnel package: FieldEdge integration connects every lead to a job and an invoice.

Full Funnel · Leads → Jobs → Revenue

Last refreshed today 6:04 AM · data through Jun 30
June 2026 ▾ All sources ▾ All job types ▾
118
Leads
▲ 8.3% vs May
71
Jobs booked
▲ 60.2% close rate
$58,940
Attributed revenue
▲ 11.6% vs May
6.9×
Return per ad dollar
▲ from 6.1× in May

The funnel · June

118 Leads
↓ 60% booked
71 Jobs
avg ticket $830
↓ 92% completed & invoiced
$58,940 Revenue
65 invoices

6 jobs still open, worth an estimated $5,400 if closed at average ticket.

Close rate by source

SourceLeadsBookedClose
Podium webchat312374%
Google Ads673857%
Podium SMS12758%
Print (untracked)8338%

Webchat leads close highest. Worth testing more spend that drives chat, not just calls.

Revenue & ROI by channel · June

ChannelSpendRevenueROI
Google Ads$5,240$36,1206.9×
Podium channels$399/mo$19,48048.8×
Print mailers$1,850$3,3401.8×

Print is barely paying for itself based on self-reported callers. Tracked numbers (top package) would confirm the real figure.

Recent lead → job → invoice matches

CustomerSourceJobInvoiceStatus
M. HerreraWebchatWater heater replace$2,180Paid
J. CastilloGoogle AdsMain line hydro jet$740Paid
D. OkaforSMSWhole-home repipe$9,600Scheduled
S. TranGoogle AdsDrain cleaning$385Paid
K. PalmerPrintFaucet install—No booking
🔒 Want trends, print tracking, exports, and alerts? The top package adds month-over-month trend analysis, tracked print numbers, technician breakdowns, PDF/CSV reports, and role-based logins.

Business Intelligence · Owner View

Last refreshed today 6:04 AM · data through Jun 30
OwnerOfficeTechs
Q2 2026 ▾
⚠ Alert: Cost per lead on "Drain Cleaning · Search" rose to $96.40 this week, 21% above your $80 threshold. Two competitors raised bids on the same keywords.
$168,220
Q2 attributed revenue
▲ 14.2% vs Q1
61.4%
Q2 close rate
▲ 3.1 pts vs Q1
$47.10
Blended CPL · Q2
▼ $4.30 vs Q1
$812
Average ticket · Q2
▲ $38 vs Q1

Revenue by channel · monthly trend

$0 $30k $60k JanFebMar AprMayJun
Google Ads Podium channels Print (tracked)

Print tracking · dedicated numbers

CampaignCallsJobsRevenue
Spring mailer · 78741229$6,140
Valpak insert · June113$1,890
Door hangers · Zilker41$385

Tracked numbers show print is doing better than self-reporting suggested: $8,415 vs. the $3,340 callers mentioned on their own.

Revenue by job type · Q2

Job typeJobsRevenueAvg ticketBest source
Water heaters38$61,400$1,616Google Ads
Repipes6$47,300$7,883Webchat
Drain / sewer74$33,900$458Google Ads
Fixtures & installs51$25,620$502Print

Jobs by technician · June

TechJobsRevenueCallback rate
R. Luna24$21,3002.1%
T. Briggs21$18,9403.4%
A. Mendez20$18,7006.8%

Visible to Owner and Office roles only. Techs see their own jobs, not each other's revenue.

Monthly owner report

One-page PDF: funnel, ROI by channel, trends, and alerts. Generated on the 1st, ready to forward to a partner or lender.