Back to Hugo Maciel FragaAll case studies
Case study
Monthly Sales and KPI Reporting
Each month I pulled CRM and accounting data into one report and presented it to the General Manager and department teams. It showed where sales came from, what converted, and where the business fell short of its targets, so management could spot patterns and decide where to focus.
- qualified-opportunity conversion, from lead qualification, client discovery, pricing analysis, and proposal improvements combined
- mid-60s to high 70s
The business
Quick Countertop & Cabinets is a countertop and cabinet business with about $2 million in annual revenue. Leads and deals were tracked in Pipedrive CRM, and revenue and project costs in QuickBooks.
The problem
Management needed a regular, shared view of how the business was doing: which products and customer segments were selling, which lead sources were worth the effort, and where the team was behind its targets.
The web lead pipeline also carried spam and unqualified traffic.
Data used
- Pipedrive CRM: lead source, qualification, customer segment, and deal outcomes.
- QuickBooks: revenue by product category, read against monthly targets.
What the report covered
- Revenue by product category and by customer segment.
- Lead sources, and how leads from each source converted.
- Conversion rate and performance against targets.
How it was used
I presented the report each month to the General Manager and to department teams, so everyone reviewed revenue, conversion, lead sources, and targets from the same figures. The point was to find patterns and performance gaps early and give management something concrete to decide from.
Lead qualification
I worked with marketing on lead qualification and the quoting workflow, including filtering spam and unqualified traffic out of the web lead pipeline, so the sales team spent its time on real opportunities.
Outcome
Qualified-opportunity conversion, meaning won deals divided by qualified opportunities, rose from the mid-60s in late 2024 to the high 70s in early 2026.
That reflected several changes made over the same period: lead qualification with marketing, better client discovery, pricing analysis, and proposal improvements. No single change accounts for it on its own.
The reports themselves contain company data, so I cannot share them or screenshots of them.
Tools
- Pipedrive CRM, the source for lead source, qualification, segment, and conversion reporting.
- QuickBooks, for revenue by product category.
- PowerPoint, for presenting the report.