Lending Operations Dashboard: Pipedrive Insights with Pipeline, Revenue & Team Analytics

Problem:

The lending team had no centralized view of pipeline health, rep performance, or deal progression, managers relied on spreadsheets and manual CRM filtering to assess conversion rates, revenue trends, and activity completion across six sales reps.

Solution:

Built a custom Pipedrive Insights dashboard with 11 live report widgets covering the full lending operation: Leads Created by Users (bar chart, 5 reps tracked with Web Forms vs. Deal vs. Manual sources), Leads Conversion by Sources (Web Forms at 4.37%, Deal at 6.89%, Manually Created at 25%), Deal Conversion funnel (33% win rate across 8 stages from Stalled to Won, 612 deals tracked), Deals Won Over Time (monthly bar chart by rep, peaks at $317K and $311K), Average Deal Value ($10,286 with +$1,107/12.06% trend), Deal Duration (17 days 21 hours average), Activities Completed (321 done this month), Deals Lost by Reasons (pie chart — 65% "Did not close," 7% "Borrower rejected terms"), Deal Progress (monthly stacked bar by stage for Hard Money Loans pipeline), New People Report (164 new contacts), New Organisation Report, and Revenue Forecast ($317K→$2.2M monthly weighted forecast).

Result:

Management now monitors pipeline conversion, rep activity, and revenue trajectory from a single live dashboard, with real metrics showing 33% win rate across 612 deals and a $10,286 average deal value."