Superset

Sales Intelligence

PublishedPortfolio dashboardupdated

Sales Performance Snapshot

EstimatesApprovedApproval Rate %Estimate Value †LostOpenApproved Value †Approved Dollar Share %Open Pipeline †

Approval Rate by Sales Rep

0.030.060.090.0

Open Pipeline by Sales Rep

$0.0$100k$200k$300k

Monthly Approval Rate and Approved Dollar Share

Approval Rate %
FebMarAprMayJunJul

Representative Performance Detail

Sales RepEstimatesApprovedApproval Rate %Estimate Value †LostOpenApproved Value †Approved Dollar Share %Open Pipeline †

Lead Conversion for Leads at Least 30 Days Old

Leads created1,845
Reached estimate1,568
Reached approval1,013

Estimate Conversion by Size for Estimates at Least 30 Days Old

Estimate SizeEstimatesApprovedApproval Rate %Estimate Value †Approved Value †Approved Dollar Share %LostOpen
Under $1K55243478.6$51.2k$38.9k76.04672
$1K–$2.5K72351371.0$206k$143k70.082128
$2.5K–$5K72744160.7$428k$253k59.483203
$5K–$10K38620753.6$437k$228k52.246133
$10K+1244737.9$391k$163k41.61265

Lead Conversion by Established Source (25+ YTD Leads)

Lead SourceLeads 30+ Days OldReached EstimateLead-to-Estimate %Reached ApprovalLead-to-Approval %Approved Value †
Channel 0135128079.821561.3$93.0k
Channel 0221818584.911050.5$58.1k
Channel 0318013876.77038.9$30.4k
Channel 0414212084.56243.7$29.4k

Lost Lead Reasons

No response38
Duplicate19
Not serious14
Scheduled8
Too far out6

Time to Approval for Approved Estimates

Time to ApprovalApprovedApproved Value †Share of Approved %
Same day1.24k$598k60.6
1–3 days222$124k10.8
4–7 days152$75.8k7.4
8–14 days154$84.7k7.5
15–30 days148$69.0k7.2
31+ days91$48.3k4.4

Lead-to-Estimate Conversion by Lead Month

JanFebMarAprMayJunJul

Total Open Pipeline

$767k †

Open Estimate Count

864

Pipeline Aged 91+ Days

$303k †

Open Pipeline by Age Bucket

91+ days$306k
61–90 days$61k
31–60 days$156k
15–30 days$90k
0–14 days$156k

Open Pipeline Value by Sales Rep and Age

Sales RepOpen EstimatesOpen Pipeline †0–14 Day †15–30 Day †31–60 Day †61–90 Day †91+ Day †91+ Share %
Representative A225$182k$20k$30k$23k$9k$101k55.1
Representative B307$260k$76k$30k$61k$22k$71k27.3
Representative C277$282k$47k$20k$56k$31k$129k45.5
Representative D40$31k$6k$10k$14k$0$00.0
Representative E4$3k$0.5k$0$0$0$2k81.9
Representative F11$8k$6k$0.1k$2k$0$00.0

Open Estimate Follow-Up by Last Recorded Email Activity

Last Recorded Email ActivityOpen EstimatesOpen Pipeline †Needs Follow-UpFollow-Up Value †Follow-Up Share %
Clicked280$267k140$121k50.0
Opened181$145k81$74k44.8
Delivered20$18k8$7k40.0
Bounced5$3k3$2k60.0
No recorded email activity378$335k365$318k96.6

Leads Not Marked Completed or Lost by Current Status

Estimate scheduled264
Contacted37
Working draft23
New lead15

Town Sales Snapshot

EstimatesApprovedApproval Rate %LostOpenApproved Value †Open Pipeline †
3.22k2.05k63.5311864$1.02M$767k

Top Towns by Approved Value

Market 01$75k
Market 02$46k
Market 03$46k
Market 04$43k
Market 05$36k
Market 06$31k

Top Towns by Open Pipeline

Market 06$37k
Market 02$31k
Market 08$31k
Market 03$26k
Market 05$22k
Market 04$19k

Town Performance Detail

TownEstimatesApprovedApproval Rate %LostOpenApproved Value †Open Pipeline †
Market 0127722079.42037$75k$22k
Market 0213711382.5519$43k$12k
Market 031129080.41012$44k$15k
Market 041118778.4321$45k$9k
Market 051008282.0414$40k$11k
Market 06975657.71130$36k$16k

Revenue Realization Snapshot

InvoicesInvoice Value †Paid †Paid Share %Amount Due †
1.69k$889k$668k75.3$219k

Monthly Revenue Realization

Invoice Value †
FebMarAprMayJunJul

Amount Due by Sales Rep

$0.0$50k$100k$150k

Revenue Realization Detail

Sales RepInvoicesInvoice Value †Paid †Paid Share %Amount Due †
Representative A1.02k$512k$362k70.9$148k
Representative B373$192k$162k84.3$30k
Representative C188$119k$92k78.0$26k
Representative D15$5k$5k88.0$0.6k
Representative E18$17k$13k74.0$4k
Representative F69$45k$35k78.3$10k

View source

Rows summarize the reporting inputs grouped for this visual.