Analytics

Avg Days Silent
40d
Across 19 active customers
Avg Risk Score
50.8
0 = healthy, 100 = critical
Total Book Value
$11,208.96
Invoiced + Pipeline combined
Customer Risk Map
Days Silent vs Total Value

Bubble size = estimate amount. Color = risk gradient (green → red). Top-right = high-value dormant customers.

Activity × Risk Heatmap
Where Inactivity Is Building
ActivityGreenYellowRed
Very Active———
Active———
Moderate———
Low
7
$4,661.40
7
$2,884.40
15
$3,663.16

Cell count = customers. Darker = more concentration. Watch for red clusters in high-activity rows — those are accounts that were active and are now stalling.

Aging Pipeline
Uninvoiced Estimates by Dormancy

Shows estimate dollars that haven't turned into invoices, grouped by how long the customer has been silent. Taller bars on the right = money at risk.

Risk Distribution
Customer Risk Levels
Red: 15
Yellow: 7
Green: 7

Red Accounts by Value Tier

Value TierTotalRedYellowGreen
#Est. $Inv. $#Est. $Inv. $#Est. $Inv. $
D - Low2915$1,437.07$2,226.097$582.50$2,301.907—$4,661.40

Shows whether risk is concentrated in your most valuable tiers. Red A-tier customers = highest priority.

Dormancy Buckets

BucketCustomersTotal ValueBy Value TierBy Conversion Status
0–7d10$0.00
D: 10
Inactive: 10
8–14d0$0.00
15–30d11$6,892.14
D: 11
Converting: 4Invoice Only: 7
31–60d5$3,696.42
D: 5
Invoice Only: 5
61d+3$620.40
D: 3
Invoice Only: 3

Customers bucketed by days of silence, broken down by tier and conversion status. Makes the aging problem visible at a glance.

Score Breakdown by Customer

CustomerRiskValueOpportunityPriorityInact. RatioDays SilentExp. Gap
Paulsen Medical Supplies100203458.714.5×29d2d
Red Rock Diner100201054.014.5×29d2d
Sonnenschein Family Store100201054.09.0×27d3d
Travis Waldron100201054.06.7×30d5d
Sushi by Katsuyuki81201045.64.1×29d7d
Geeta Kalapatapu58201035.12.5×28d11d
Kookies by Kathy58201034.92.5×76d30d
Bill's Windsurf Shop57201034.52.5×75d30d
Dukes Basketball Camp57201034.52.5×75d30d
Gevelber Photography5020029.5——30d
Kate Whelan5020029.5——30d
Pye's Cakes5020029.5——30d
Rago Travel Agency5020029.5——30d
Shara Barnett5020029.5——30d
Video Games by Dan5020029.5——30d
Wedding Planning by Whitney5020029.5——30d
Diego Rodriguez5020029.5——30d
Dylan Sollfrank5020029.5——30d
Freeman Sporting Goods5020029.5——30d
55 Twin Lane39201026.71.9×36d20d
John Melton36201025.21.7×52d30d
Jeff's Jalopies34201024.11.6×49d30d
Barnett Design27201021.31.4×41d30d
Amy's Bird Sanctuary27201021.01.3×30d23d
Cool Cars26201020.71.3×39d30d
Weiskopf Consulting19201017.71.0×29d30d
Rondonuwu Fruit and Vegi19201017.40.9×28d30d
Mark Cho18201017.10.9×27d30d
0969 Ocean View Road18201017.10.9×27d30d