The Reports page, under Insights & setup in the Franchise Sales sidebar, answers the questions a development director asks every week. This article explains what each number counts, so you can trust it and explain it. It is part of the +CRM/Franchise Sales add-on. For setup and goals, see Franchise Sales setup, settings, goals and reports.
Each report has an Export CSV button. If your permissions limit you to your own prospects, the rep, source and forecast figures only cover those prospects.
The four headline tiles
- Pipeline forecast: the budget of every non-archived, unconverted prospect, including lost-stage and Dead ones, multiplied by their deal odds, added up. A prospect with no odds adds nothing to this number. The line under it shows the unweighted total, which is those budgets added together. Converted prospects are left out of both.
- Overall conversion: prospects awarded as a share of every non-archived prospect. The line under it shows "N of M prospects awarded".
- Active reps: the number of rows in the rep leaderboard: people who own at least one prospect, plus an Unassigned row if some prospects have no rep.
- Awarded YTD: franchisees converted this calendar year.
Conversion funnel
One bar per pipeline stage, using your own stage names, showing how many prospects are in each stage right now. It is a snapshot of today, not a track of how prospects moved through. It doesn't show a percentage between stages, because a ratio of two current headcounts isn't a true conversion rate.
Stage velocity
The average number of days prospects currently in each stage have been there, with "n=" showing how many prospects the average comes from. A stage with no prospects shows 0 days. Use it to spot a stage where deals pile up. It measures time spent so far for prospects who are still in the stage, not the time of prospects who already moved on.
Lead source attribution
A table with one row per source: Leads (with its share of all leads), Awarded, Conv. (awarded as a percentage of that source's leads) and Pipeline (the total of their stated budgets). Each source shows by the same name you pick on a prospect, such as Website, Phone, Social Media, Cold Outreach or PR. 0% in Conv. means nothing from that source has been awarded yet. Pipeline adds up stated budgets, not the franchise fees you charge.
Rep leaderboard
One row per rep, sorted by awarded franchises, then by pipeline value: Assigned, Hot, Awarded (with the percentage of that rep's prospects) and Pipeline. Prospects with no rep show as Unassigned.
Broker performance
For the brokers on your roster: Leads, Conv. (conversions and the rate), Pipeline and Commission. Only prospects linked to a broker on the roster count. A prospect that only has a broker name typed in is not attributed. Pipeline is the stated budgets of that broker's unconverted prospects, including lost-stage and Dead ones. Once a prospect is converted, its budget leaves Pipeline and the deal counts under Conv. instead. The Commission column shows the broker's commission rate, and shows a dash where no rate is on file or you can't see rates. For brokers, see Managing franchise brokers and their commissions.
Things to know
- The rep, source, velocity and forecast figures count every active prospect, however large your pipeline is. The headline Overall conversion and Awarded YTD come from full counts.
- Archived prospects are not included, except in Broker performance, which counts every prospect linked to the broker. Restore them in the Archived view to include them.
- Budgets are what the prospect told you. Treat pipeline figures as a guide, not a forecast of revenue.
- CSV files hold the same numbers shown on the page.
Frequently asked questions
Q: Why is my pipeline forecast lower than the total of all budgets?
A: The forecast multiplies each budget by its deal odds. A 40 percent deal counts for 40 percent of its budget, and a prospect with no odds counts for nothing. The unweighted total is shown beneath.
Q: Why doesn't the conversion funnel show percentages between stages?
A: The bars are today's headcount in each stage. Dividing one headcount by another isn't a real conversion rate, and could even go over 100 percent.
Q: What does Overall conversion measure?
A: How many prospects were awarded out of every prospect that isn't archived.
Q: Why is a broker missing from Broker performance?
A: Only non-archived roster brokers appear. Archived or unlisted brokers don't. Link prospects on their record to give a broker numbers.
Q: Does the leaderboard use revenue?
A: No. It counts awarded franchises, hot leads and the stated budgets of the rep's prospects.