Milestone Funnel Report
The Milestone Funnel shows how far projects get through a pipeline: how many reached each funnel milestone, how many converted from one step to the next, and how many days the steps took.
Accessing the Report
Reports > Sales > Milestone Funnel
Filters
| Filter | What it does |
|---|---|
| Pipeline (Sales / Design / Production) | The pipeline whose milestones are shown |
| Count projects by: Created in range / Sold in range | Cohort: the projects created (Sales, Design) or sold (Production) in the date range, and how far they've got since. Design starts from Created because most design work happens before the whole project is sold. |
| Count projects by: Reached in range | Period: the milestones reached in the date range, whatever the project's age |
| From / to | The date range |
| Design only / Production only | The switch beside Pipeline, for Design and Production; on by default. Counts only the projects that went through that pipeline: those with a design (or production) stage now, or that had one at some point in the project's history. A job that never had design is left out of every Design number instead of counting as a project that stopped short. Turn it off to count every project. The card title says when it's on, for example "1,240 projects created with a design stage". |
| Break down by | Adds a table by source, campaign, salesperson, designer (design team leader) or project manager |
Reading the Report
- Each milestone shows the number of projects that ever reached it, including dates filled in by a later milestone. A milestone that isn't filled in can be skipped, so a later step can count more projects than the one before it.
- In a cohort, the percentage is the share of the cohort that reached the milestone, for example "3.9% of created" (or "of sold" for Production). It is never measured from the step before: because a milestone can be skipped, a later step can count more projects than an earlier one. In a period there is no percentage, since each milestone counts a different set of projects.
- Median days are measured between each project's own milestone dates. For each project, a step's days run from the latest earlier milestone that project reached on its own:
- A filled-in date is never measured, from or to. A project that jumped straight to Sold isn't counted as taking 0 days from Proposal to Sold; its Sold is measured from the last milestone it really reached.
- A project that skipped a milestone is measured from the one before it, so it still counts toward the next step.
- A project that reached none of the earlier milestones is measured from the cohort's start (Created, or Sold for Production). In a period there is no start, so it isn't measured for that step.
- In a period, a step counts and measures the projects that reached that milestone in the date range. The earlier milestone its days run from can be before the range: a project sold this month is measured from its Proposal last year. The same goes for the span from the first milestone to the last.
- When every project in a step was measured from the same milestone, the caption names it ("median 5 days after Proposal"). When they were measured from different ones, it names the milestone just before the step ("median 5 days after Proposal") and adds an info icon: hover or focus it to read that projects that skipped that milestone, or had it filled in, are measured from the milestone before it.
- Days can be negative when a project's milestone dates are out of order, for example a later milestone dated before an earlier one.
- The breakdown table lists the groups with the most projects first, then A-Z. None (projects with no source, campaign, salesperson, designer or project manager set) and Unknown (set to a record that no longer exists) always come last.
- The breakdown table's Median days from the milestone before columns, the total row, the Slowest step tile and the CSV all measure days the same way. In a cohort, the first of those columns names where it starts, for example Created → Design Agreement or Sold → Job Started.
- Slowest step names the milestone that took longest to reach, with its median days and what they were measured from ("median from Proposal", with the same info icon when its projects were measured from different milestones).
- No new milestone in 60 days counts projects that have started the pipeline, haven't reached its last milestone, and have reached nothing new for 60 days.
- How milestones are counted lists each milestone of the pipeline with its active rules, one per line under Any of: when there are several, and Also filled in when a later milestone is reached for the ones set to be filled in. A milestone with no active rule shows No active rule. Milestones show the names your company gave them. Users who can manage milestones get a Change in Settings › Funnel Milestones link.
See the projects behind a number
Click any number to list the projects behind it. A 0 or a "–" has nothing behind it and isn't a link. Every list holds exactly as many projects as the number you clicked, and has its own Export CSV.
- Counts — the funnel's steps (including its Created or Sold start), the breakdown table's Projects and Projects reaching columns, and the total row. Each project shows its client, its breakdown value (source, salesperson and so on) when the report is broken down, and the date it reached the milestone. A date filled in by a later milestone is marked Filled in.
- Median days — the breakdown table's Median days from the milestone before columns, the total row's, and the Created → Sold (start to last milestone) and Slowest step tiles. The list is the projects that were measured for that step: each with the milestone it was measured from and its date, the milestone it reached and its date, and the days between. The longest come first, so outliers are easy to spot. Projects whose date was filled in aren't listed, because they weren't measured.
- No new milestone in 60 days — the stalled projects, each with the furthest milestone it reached and when.
The title names what you clicked, for example Referral · Proposal · 69 projects or Referral · Met with Sales → Proposal · 25 days median. A list shows up to 500 projects; for more, it says how many there are and you can narrow the date range.
Exporting
Export CSV downloads the totals and every breakdown row, in the table's order: projects, the count at each milestone, and the median days from the milestone before for each step.