Inside Vertica CRM
Unlocking Business Brokerage Insights: The Power of Vertica CRM Reporting
Which marketing brings sellers? Where do buyers stall? What will close this quarter? Here are the KPIs every business brokerage should track and how to calculate them, a library of the reports brokers use most, how any custom report gets built, a free KPI tracker, and how Vertica CRM brings your website, email, texts and pipelines into one source of truth.
Quick answer
Business brokers should track a small set of KPIs: new seller and buyer leads by source, inquiry-to-NDA and NDA-to-approval rates, listings taken and days on market, listing-to-close ratio, average time to close, pipeline value and commission forecast, activity by broker and lead response time. Beyond KPIs, a broker's CRM should produce any report the firm needs, for owners, brokers, marketing, listings, buyers and compliance. Vertica CRM brings data from your website, email, texts, lead scoring and pipelines into one place, so you can filter reports by any field, drill down, build dashboards, export to Excel or PDF, schedule reports by email and forecast commission by stage or close date, and the Vertica team builds custom reports around your methodology.
Struggling to keep track of leads and close deals?
In today's competitive business brokerage landscape, the data you need is scattered: inquiries on your website and marketing sites, conversations in email and texts, deal status in spreadsheets. Imagine a world where all your business brokerage data is centralized, organized and readily available at your fingertips. That's what reporting in Vertica CRM is built to do.
The struggle before Vertica CRM: a day in the life of John
John's story is an illustrative example of what many brokers go through.
John's inquiries came in from his website, several marketing sites and social media, and he handled each one by hand. Keeping track of where a lead came from, what had been said and what stage the inquiry had reached was slow and error-prone. His email campaigns went out as generic blasts, and his website analytics had nothing to do with which leads were most promising. Every month, he spent an afternoon pulling numbers from different tools into a spreadsheet, and by the time the report was ready, it was already out of date.
Vertica CRM: a single source of truth
Vertica CRM brings activity from inside the CRM, your website and, with permission, your clients' inboxes into one place. It tracks:
- Lead scoring, so the most promising buyers and sellers rise to the top.
- Email marketing campaigns, including opens, clicks and replies. (Email marketing for business brokers.)
- Buyer registrations and listing inquiries, with their source. (Lead parsing.)
- Website visitor behavior, such as which listings and pages each contact viewed.
- Client email and text conversations, logged on the contact record. (SMS for business brokers.)
- Every pipeline stage, from first inquiry to closing. (Deal pipeline for business brokers.)
No more stitching data together from separate tools: you see the whole journey, from first touchpoint to closed deal.
Beyond basic reporting: actionable insights
Combine lead scoring with website behavior and email history to find your highest-potential leads, tailor your outreach to each one, and personalize what they see next.
Business broker KPIs: what to track and how to calculate it
| KPI | How to calculate it | What a change tells you |
|---|---|---|
| New leads by source | Count of new seller and buyer leads from each source (website, portals, referrals, campaigns) | Which marketing to grow, and which to cut |
| Inquiry-to-NDA rate | NDAs signed ÷ buyer inquiries | How well your listings and follow-up turn interest into commitment |
| NDA-to-approval rate | Buyers approved ÷ NDAs signed | The quality of your buyers, and your approval criteria |
| Seller lead-to-listing rate | Engagements signed ÷ seller leads | How well your valuations and pitch win listings |
| Days on market | Days from listing active to accepted LOI | Pricing and marketing effectiveness |
| Listing-to-close ratio | Listings closed ÷ listings taken | How many of your listings actually sell |
| Average time to close | Days from engagement signed to closing | Where your process can move faster |
| Pipeline value | Sum of expected sale prices or commissions in open deals | The size of the business ahead of you |
| Commission forecast | Expected commission by stage or expected close date | Cash flow for the months ahead |
| Activity by broker | Calls, emails, texts, meetings and tasks completed per broker | Who is following up, and who needs help |
| Lead response time | Time from inquiry to first reply | Whether hot leads are going cold |
“Tracking the numbers inside a purpose-built brokerage CRM quickly revealed patterns the team had been guessing about for years. One report showed that leads from a particular marketplace converted at less than half the rate of private-referral leads, so the firm cut that advertising spend and doubled down on referral partners. Another surprise was that listings sitting longer than 90 days without a price adjustment almost never closed, which led the brokers to institute a mandatory 75-day pricing review. Response-time data also forced a change: buyers who received a text or call within 15 minutes were three times more likely to register and sign an NDA than those contacted the next day.” Joshua Factor, founder of Vertica CRM
The complete list of brokerage metrics, grouped by decision
Here are the most useful CRM reporting metrics for a business brokerage, grouped by what they actually help you decide.
1. Pipeline and deal flow
- Active listings by stage, from lead to listing, under LOI, due diligence and closed
- Average days in each stage
- Conversion rate between stages, such as listing to LOI and LOI to closed
- Win rate or close rate
- Pipeline value: total asking price or estimated commission in each stage
- Stalled deals: listings with no activity for a set number of days
2. Lead source and marketing
- Leads by source: marketplaces, your website, referrals, LinkedIn, outreach and more
- Cost per lead by source
- Lead-to-registered-buyer conversion by source
- Lead-to-closed-deal conversion by source
- Seller inquiry quality by source
3. Buyers
- New buyer inquiries
- Registered and NDA-signed buyers
- Active buyers: those who have viewed CIMs or toured
- Buyer engagement score or activity level
- Time from inquiry to registration to first CIM release
- Buyers who went quiet, and the reactivation rate
4. Sellers and listings
- New seller leads
- Listing appointment to signed engagement rate
- Average days from engagement to going live
- Price reductions and their effect on inquiry volume
- Listings with no serious inquiries after 30, 60 or 90 days
5. Activity and productivity
- Calls, emails and texts logged per broker
- Average response time to new inquiries
- CIMs released
- Buyer tours and management meetings arranged
- Follow-up completion rate
6. Financial performance
- Closed deals: count and total transaction value
- Commission earned, actual vs. projected
- Average deal size
- Revenue by broker
- Revenue by lead source
- Forecast commission for the next 30, 60 and 90 days
7. Trends over time
- Month-over-month growth in new listings, new buyers and closed deals
- Seasonal patterns
- Year-over-year comparison
- Broker activity trends
The five metrics brokerages act on most
- Lead source to closed deal conversion, which cuts bad advertising fast.
- Average days in each pipeline stage, which shows where deals die.
- Response time to new inquiries, which is directly tied to registration rates.
- Listings with no activity after 60 to 90 days, which forces pricing or marketing decisions.
- Projected vs. actual commission, which keeps forecasting honest.
Beyond the basics: Vertica CRM's reporting power
- Customization. Choose exactly which data points to include, such as lead scoring by industry alongside buyers' email interactions, and filter by any field.
- Visual storytelling. Charts, graphs and dashboards make trends easy to spot.
- Drill-down. Click into a category, such as an industry, to see each listing inquiry's stage, website visits and email history.
- Export and schedule. Export any report to Excel or PDF, and schedule reports to arrive by email automatically.
- Commission forecasting. Forecast expected commission by pipeline stage or expected close date, alongside other financial fields.
- Custom reports for your methodology. Track and log anything, and have reports built around the way your brokerage works.
Data-driven decisions
Reports on campaign performance, buyer registration sources and listing inquiry stages help you put your marketing budget where it works, prioritize the leads most likely to convert, and fix the parts of your sales process that slow deals down.
Reports that drive action
Lead scoring and buyer journey analysis
See lead scores alongside listing inquiries, website behavior and email interactions, broken down by sector, so you know which buyers to call first.
Email marketing performance
Track open rates, click-through rates, conversions and replies by audience segment, and see which campaigns actually produce registrations and meetings.
Buyer registration and conversion
See where registrations come from, how many become qualified leads, and what buyers looked at on your website before they registered.
Listing inquiry stage analysis
Follow each inquiry's stage, with its website and email history, to find the bottlenecks where buyers stall.
| Question | Report |
|---|---|
| Which marketing brings us sellers? | Seller leads and engagements by source |
| Where do buyers drop off? | Inquiry-to-NDA and NDA-to-approval by listing |
| Which listings need attention? | Days on market and inquiries per listing |
| What will close this quarter? | Commission forecast by expected close date |
| Is every lead getting a fast reply? | Lead response time by broker |
| Which brokers need support? | Activity and conversion by broker |
The business broker report library: 30 reports, and any report you need
KPIs tell you how the business is doing. Reports answer the specific questions behind them. Here are the reports brokerages use most, grouped by who uses them. Every one can be filtered by any field, shown as a dashboard tile, exported and scheduled by email.
| Who uses it | Report | The question it answers |
|---|---|---|
| Owner | Commission forecast by close date | What will we earn in the next 30, 60 and 90 days? |
| Owner | Revenue by lead source | Which sources actually produce commission? |
| Owner | Broker performance | Listings, deals, revenue and activity by broker |
| Owner | Projected vs. actual commission | How accurate are our forecasts? |
| Owner | Year-over-year comparison | Are we growing, and where? |
| Broker | My pipeline | Where does each of my listings and buyers stand? |
| Broker | Stalled deals | Which records have had no activity for a set number of days? |
| Broker | Follow-ups due | Who do I need to contact today? |
| Broker | New inquiries and response time | Did every new lead get a fast reply? |
| Broker | Activity log | Calls, emails, texts and meetings this week |
| Marketing | Campaign performance | Opens, clicks, replies and registrations by campaign |
| Marketing | Cost per NDA by source | What does each signed NDA cost us? |
| Marketing | Website visitor to registration | Which pages and listings turn visitors into buyers? |
| Marketing | Lead source to closed deal | Which marketing ends in a closing? |
| Marketing | Referral partner report | Which partners send leads, and which convert? |
| Listings and sellers | Days on market by listing | Which listings are aging? |
| Listings and sellers | Inquiries and NDAs per listing | Which listings attract interest but no commitment? |
| Listings and sellers | Price reduction impact | Did a reduction bring new inquiries? |
| Listings and sellers | No serious inquiries after 30, 60 or 90 days | Which listings need a pricing or marketing review? |
| Listings and sellers | Seller lead to engagement | How many valuations become listings? |
| Buyers | NDA and approval status | Which buyers are waiting on a next step? |
| Buyers | Data room activity | Which approved buyers are actually reviewing documents? |
| Buyers | Quiet buyers | Who has gone silent, and who has re-engaged? |
| Buyers | Buyer profile match | Which buyers fit a new listing's criteria? |
| Buyers | Inquiry to first CIM release | How long does it take a buyer to see the CIM? |
| Compliance and audit | NDA log | Who signed which NDA, and when? |
| Compliance and audit | CIM and document release log | Which buyers received which confidential documents? |
| Compliance and audit | User activity and login log | Who viewed or changed what, and from where? |
| Compliance and audit | Text and email opt-outs | Who has asked not to be contacted? |
| Compliance and audit | Data export log | Who exported data, and when? |
Don't see the report you need? The Vertica team builds custom reports around your brokerage's methodology, using any field in your CRM.
How a custom report gets built
- Tell us the question. For example, "Which referral partners sent buyers who signed an NDA within a week?"
- We map it to your data: the records, fields, stages and dates that answer it.
- We build the report, with the filters, groupings and charts you need.
- You choose how to see it: on screen, as a dashboard tile, as an Excel or PDF export, or as a scheduled email.
- Refine it as your questions change. Reports grow with your methodology.
Worked example: one month's report for a sample brokerage
Here's how the numbers turn into decisions. The brokerage and figures are illustrative.
| Source | Inquiries | NDAs | Inquiry-to-NDA | Approved |
|---|---|---|---|---|
| Marketplace A | 120 | 12 | 10% | 6 |
| Your website | 50 | 10 | 20% | 7 |
| Referral partners | 20 | 7 | 35% | 6 |
| Email campaigns | 10 | 1 | 10% | 1 |
| Total | 200 | 30 | 15% | 20 |
- Overall: 30 NDAs from 200 inquiries is a 15% inquiry-to-NDA rate, and 20 of 30 NDAs approved is 67%.
- Marketplace A brings the most inquiries but converts at half the rate of your website, so test cutting its spend and moving budget to website listings and SEO.
- Referral partners convert best, at 35%, so schedule more partner meetings. (Referral network guide.)
- Response time: if the report shows inquiries waiting more than a day, set an automatic text within 15 minutes. (Workflow automation.)
Free download: business broker KPI tracker
Put this article into practice with a free Excel KPI tracker. Enter your numbers in the yellow cells, and it calculates the rest:
- Monthly Inputs and KPIs: inquiry-to-NDA and NDA-to-approval rates, seller lead-to-listing rate, days on market, listing-to-close ratio, time to close, commission vs. projection and response time, month by month and year to date.
- Lead Sources: conversion and cost per inquiry, per NDA and per closed deal for every source.
- Pipeline Forecast: your open deals weighted by stage probability, with your forecast for the next 30, 60 and 90 days.
Download the business broker KPI tracker (Excel). Free, no form to fill in.
How to start reporting in Vertica CRM in five steps
- Make lead source a required field, so every inquiry is tagged from day one.
- Choose your five KPIs. Start with the five metrics brokerages act on most, above.
- Build your dashboard with those KPIs, filtered by broker and date range.
- Schedule the reports: weekly and monthly, emailed to the people who act on them.
- Review on a fixed day, and decide one action from each review.
Common reporting mistakes brokerages make
- Tracking vanity numbers, such as page views, instead of NDAs, listings and closings.
- Too many reports and no owner. Every report needs someone who acts on it.
- Missing lead sources, because inquiries are entered by hand without one.
- Reviewing without deciding. If a report doesn't change a decision, stop running it.
- No alerts for stalled deals, so problems show up only at month end.
- Gut feel over data, such as keeping a marketplace because it "feels busy".
A reporting routine for brokerage owners
| When | Review |
|---|---|
| Weekly | New leads by source, lead response time, stalled deals by time in stage, this month's commission forecast |
| Monthly | Inquiry-to-NDA and NDA-to-approval rates, listings taken, campaign performance, activity by broker |
| Quarterly | Listing-to-close ratio, days on market, average time to close, revenue by source, pipeline value |
Schedule each report to arrive by email, so the routine runs itself.
The benefits of integrated reporting
- A 360-degree view of your sales funnel, from first visit to closed deal.
- Data-driven decisions about your email and text campaigns and how you present listings.
- Unified tracking of website visits, emails, texts, calls and inquiries.
- Trends you can see early, before they show up in your bank account.
- Reports built around your business, not a generic template.
John's success story
With his data in one place, John, our illustrative broker, stopped building spreadsheets and started acting on what the numbers told him. Here's the kind of result brokers see:
- Higher lead conversion, because the best leads get called first.
- Better marketing ROI, because budget moves to the sources that produce deals.
- Shorter sales cycles, because stalled deals are spotted early.
- Stronger client relationships, because every conversation is in front of the whole team.
Two more illustrative examples (names and figures are made up) show what this can look like:
- "Sarah", a broker who began reporting on lead source and response time, could see a 30% increase in lead conversions and a 25% shorter sales cycle once she reallocated her marketing and set response-time alerts.
- "David", a brokerage owner, could use campaign reports to identify which marketing channels actually produce registrations, and move his budget accordingly.
What's changed since 2024
- More data in one place: text conversations, data room activity and AI CIM releases now sit alongside website, email and pipeline data.
- Funnel view with financial fields, including commission forecasts by stage or close date.
- Scheduled reports by email and exports to Excel or PDF.
- Unlimited pipelines to report on, from seller deal flow to listing marketing. (Deal pipeline for business brokers.)
Conclusion
Reporting in Vertica CRM gives you a 360-degree view of your brokerage and the confidence to make decisions based on data, not hunches. When every inquiry, email, text and stage is in one place, the numbers are always ready, and always current.
See your brokerage's numbers in one place
Book a free consultation, bring the questions you want answered, and see your KPIs, reports and commission forecast built around your methodology.
Schedule a Demo Questions? Call +1 212 381 4994 (USA) or +61 3 8518 4759 (Australia).Frequently asked questions
What KPIs should a business broker track?
New leads by source, inquiry-to-NDA and NDA-to-approval rates, seller lead-to-listing rate, days on market, listing-to-close ratio, average time to close, pipeline value, commission forecast, activity by broker and lead response time.
How do I calculate my inquiry-to-NDA rate?
Divide the number of NDAs signed by the number of buyer inquiries in the same period. For example, 30 NDAs from 200 inquiries is a 15% rate.
What is a listing-to-close ratio?
The share of the listings you take that actually close: listings closed divided by listings taken.
Can Vertica CRM forecast commissions?
Yes. The funnel view tracks commissions and other financial fields, and can forecast expected commission by pipeline stage or expected close date.
Can I export reports from Vertica CRM?
Yes. Reports can be exported to Excel or PDF, and scheduled to arrive by email automatically.
Can I build custom reports?
Yes. You can track and log anything, filter by any field, and have custom reports built around your methodology.
Does Vertica CRM track website visitor behavior?
Yes. Website activity, such as the listings and pages a contact viewed, is tracked alongside their emails, texts and pipeline stage.
Does Vertica CRM use lead scoring?
Yes. Lead scoring helps the most promising buyers and sellers rise to the top, and can be combined with website and email data in reports.
Which reports matter most for a business brokerage?
The five most brokerages act on: lead source to closed deal conversion, average days in each pipeline stage, response time to new inquiries, listings with no activity after 60 to 90 days, and projected vs. actual commission.
What reports can a business broker CRM produce?
In Vertica CRM, any report your brokerage needs: commission forecasts, revenue by source, broker performance, pipeline and stalled deals, follow-ups due, campaign performance, cost per NDA, days on market, data room activity, NDA and document release logs, user activity logs and more, each filterable by any field.
Can Vertica build a custom report for my brokerage?
Yes. Tell the Vertica team the question you want answered, and they build the report around your fields, stages and methodology, as an on-screen report, dashboard tile, export or scheduled email.
Which reports help with compliance and audits?
The NDA log, the CIM and document release log, user activity and login logs, text and email opt-outs, and the data export log.
Is there a free KPI template for business brokers?
Yes. This article includes a free Excel KPI tracker with monthly KPIs, lead-source conversion and cost, and a weighted 30, 60 and 90-day commission forecast, with the formulas built in.
How often should a brokerage review its reports?
Weekly for leads, response times, stalled deals and the commission forecast; monthly for conversion rates, listings taken and campaigns; quarterly for close ratios, time to close and revenue by source.
How do I start tracking KPIs in my brokerage?
Make lead source a required field, choose five KPIs, build a dashboard, schedule weekly and monthly reports by email, and review them on a fixed day, writing down one decision each time.
Why does lead response time matter for business brokers?
Fast replies catch buyers while their interest is high. In Vertica CRM founder Joshua Factor's experience, buyers contacted within 15 minutes were three times more likely to register and sign an NDA than those contacted the next day.
What's the difference between a pipeline and a report?
A pipeline shows where each record is right now. A report shows patterns across many records over time, such as conversion rates, time in stage and revenue by source.