My Customers, Sales & Service Trends
Reporting dashboard
Live-style snapshots mirror the workbook tabs New Reports — My Customers, Sales and Service Trends. Each tile surfaces the same KPIs as the opening rows of the full report; open any tile for the detailed grid.
Overview
Sales
Sales YTD
New units YTD
1,842
Front $3.82M
Used units YTD
2,062
Front $4.10M
Total front gross
$7.92M
PRU $2,028
Open full report →
Sales by Zipcode
Top ZIP share
80202 · 12%
Urban core
Fastest growing
80525
+18% units
ZIPS tracked
156
≥1 delivery
Open full report →
Sales by Model
Top model (units)
Grand Cherokee
412 YTD
Highest PRU
Wagoneer L
$3,420
Turn leader
Compass
34 days
Open full report →
Service
Service YTD
Customer pay ROs
18,640
72% of mix
Warranty ROs
4,120
16%
Internal ROs
3,080
12%
Open full report →
Service by Zipcode
Highest RO density
80111
ROs / 1k HH
CP labor lead
80525
$184k/mo
Emerging market
80907
Prospecting focus
Open full report →
Service by Model
Highest RO volume
Ram 1500
6,420 ROs
Recall pipeline
Pacifica
1,840 open
MPI attach
Grand Cherokee
61%
Open full report →
Effective Labor Rate
Door rate
$142.00
Posted
Effective ELR
$117.35
CP blend
Leakage vs door
17.4%
Target 15%
Open full report →
Master Service Report
Tech productivity
118%
Bill / clock
First visit yield
$412
Per RO
Comeback rate
2.1%
30-day
Open full report →
People
Salespeople
Team retail units
156
MTD group
Top PRU
A. Morales
$3,040
Show ratio leader
J. Chen
71%
Open full report →
Sales Managers
Avg front / deal
$2,862
Team rollup
Close from demo
38%
+2.1 pts
One-price adherence
94%
Policy audit
Open full report →
F&I Managers
VSC penetration
44%
Group avg
PPM per deal
$1,902
MTD
Reserve / contract
$812
Weighted
Open full report →
Group
Group Salespeople
Group units MTD
518
24 stores
#1 volume
R. Patel
Fort Collins CDJR
Top gross / unit
M. Ibrahim
Luxury row
Open full report →
Group Sales Managers
Group front / unit
$2,904
Weighted
Best showroom traffic
Denver Metro
index 112
Lowest aged inventory
Fort Collins
47 days
Open full report →
Group ELR
Group ELR
$116.88
CP weighted
Best ELR
Englewood
$119.40
Opportunity
Springs
-$3.10 vs avg
Open full report →
Lifecycle
Campaigns
Service Campaign
Open campaigns
14
Active bulletins
Completion rate
76%
Eligible base
Campaign labor
$428k
YTD
Open full report →
Sales Campaign
Active journeys
22
Omnichannel
Appt show rate
68%
Campaign traffic
Sold / campaign lead
14.2%
90-day
Open full report →
Service Prospecting
Hot prospects
420
Score 80+
Contact rate
61%
7-day
Booked ROs
184
From prospect
Open full report →