Funnel Milestones
Funnel milestones record when a project first reached each key step of its sales, design and production pipelines. Reports use them to answer questions stages can't: how many leads met with sales, where lost leads stopped, how long it takes from sold to job start.
Stages and Milestones
| Stage | Milestone | |
|---|---|---|
| Answers | Where is the project now? | Did it ever get here, and when? |
| Per project | One current stage per pipeline | One date per milestone |
| Moves backwards | Yes | Never: a milestone is stamped once |
| Set by | Someone changing the stage | Rules on real events, or an admin correction |
Stages still drive your boards and day-to-day work. Entering a stage can be one of the rules that stamps a milestone.
Accessing This Setting
- Go to Settings > Projects > Stages > Funnel Milestones
- Pick the Sales, Design or Production tab
System Milestones
Every company has these milestones. They can't be archived or moved, and every report reads them the same way. You can rename them and choose whether they're filled in from a later milestone (see Editing a Milestone).
| Pipeline | Milestone | Default rule |
|---|---|---|
| Sales | Handed to Sales | The 1st Appt activity is booked |
| Sales | Met with Sales | The 1st Appt activity is completed |
| Sales | Proposal | A project proposal is sent |
| Sales | Sold | The project enters a Won stage |
| Design | Design Agreement | A design services agreement or a deposit agreement is signed |
| Design | Design Complete | The Design Complete Date is set |
| Production | Job Started | The Actual Start Date is set |
| Production | Substantial Completion | The Substantial Completion Date is set |
| Production | Job Complete | The Actual Finish Date is set |
A cancelled activity never counts.
The Sales pipeline starts at Created, the day the project was created. It isn't a milestone you can edit or correct, but the project's Milestones card and the Milestone Funnel report show it as the first step.
How Milestones Are Stamped
- A milestone is stamped the first time any of its rules matches. Once stamped, it never moves: cancelling the appointment, reopening the project or changing the rule leaves it as it is.
- The date is the date the event happened: the appointment's date, the day the contract was sent or signed, or the date in the date field. A backdated date field gives a backdated milestone.
- Reaching a milestone also fills in the earlier milestones of the same pipeline that are still empty and have Fill in when a later milestone is reached ticked, with the same date. It never fills in another pipeline's milestones.
- A filled-in date counts as reached everywhere (reports, the report builder, workflow conditions). The project's Milestones card shows it as Filled in from the later milestone, and the Milestone Funnel report leaves it out of its day counts, since the project didn't really reach that step on that day.
- Rule changes apply from the moment you make them. Past projects keep the milestones they were stamped with, so last quarter's numbers don't shift. To restate history, use Recalculate History.
Rules
Every rule is a workflow that ends in the Stamp Milestone action. Each milestone card lists its rules. A rule shows:
- A label for what it watches: Activity, Stage, Contract, Role, Date, Manual or Custom
- What it watches, for example "When 1st Appt is completed" or "When the project enters a Won stage". A custom rule shows its name.
- New activity only on a custom rule (see below)
- On / Off to turn the rule on or off. A rule that has never been published shows Draft instead.
- Open in Workflow Builder to edit it
- A delete button
Every company starts with a default rule for each system milestone. You can edit, turn off or delete them like any other rule. If a system milestone is left with no active rule, its card warns you and offers Restore Default Rule.
Standard and Custom Rules
A standard rule has one trigger followed by Stamp Milestone, and nothing else:
- An activity of a category, and optionally one subcategory, is booked or completed
- The project enters a stage
- A role (a project user field) is assigned
- A contract is sent or signed
- A project date field is set or changed (the operator Changed to any value (was empty) or Changed (any change)). The milestone's date is the field's value; clearing the date stamps nothing.
Standard rules count in the Last 90 Days preview and in Recalculate History, which replay them against your projects' past. A Manual rule (a manual trigger followed by Stamp Milestone) is the exception: there's no past event to replay, so Recalculate History only fills its milestone's empty dates.
Any other trigger, or a rule with conditions, delays, enrollment criteria or other steps, is a custom rule. It's labelled New activity only: it works from the day it's turned on, but the preview and Recalculate History can't replay it.
Your change history records the stage's name at the time, not the stage itself. When the preview or Recalculate History replays a stage rule, it matches past moves by the stage's current name. If you renamed a stage, moves made under its old name don't match. Live stamping isn't affected.
Milestone rules appear only on this page, not on the Workflows page. General workflows can't stamp milestones; they can react to one with the Milestone Reached trigger.
Adding a Rule
- Click Add Rule on the milestone's card
- Choose what the rule watches: An activity, The project or A contract
- Click Open Workflow Builder
- Set up the trigger, then publish the workflow
Deleting a Rule
Click the delete button on the rule, then Delete. The rule is removed from the milestone and stops stamping. Dates it already stamped stay on your projects, and its run history is kept.
To stop a rule for now, turn it Off instead.
Milestone Rules in the Workflow Builder
A rule opens in the workflow builder in milestone-rule mode:
- The bar at the top reads Milestone rule · <milestone>, with a Back to Funnel Milestones link.
- The Stamp Milestone step is locked in. It always stamps this rule's milestone, and it can't be removed or pointed at another milestone.
- The trigger can't be Milestone Reached, and the rule never re-enrolls a project.
- For an activity trigger, pick the Activity Category, then a Subcategory or leave it on Any subcategory.
- Saving, publishing or going back returns you to the Funnel Milestones tab you came from, with the milestone's card in view.
General workflows work the other way round: they can't stamp a milestone, but they can start from one. Use the Milestone Reached trigger to act when a project first reaches a milestone, or a Milestone: <name> condition (Is known or Is unknown) to check whether it has.
Editing a Milestone
Click Edit on a milestone's card to change:
- Name. System milestones can be renamed too. The dialog shows the built-in name under the field ("System milestone: Proposal"); click Restore name to go back to it. The new name shows everywhere the milestone appears: this page, the project's Milestones card, the report and the report builder.
- Description, shown on the card
- Fill in when a later milestone is reached. When a project reaches a later milestone of the same pipeline first, this one gets the same date. It's on by default for system milestones and off for new custom milestones. A milestone with it off can be skipped.
Turning Fill in when a later milestone is reached off or on applies to stamps from then on. To restate past projects, use Recalculate History.
Custom Milestones
Click New Milestone to add a milestone to the current pipeline, such as Selections Complete, Plans Approved or Permit Issued. Then add a rule so it gets stamped.
- Use the arrows to move it between other milestones. System milestones keep their order.
- Archive stops it being stamped or shown; its history is kept. Archived milestones are listed at the bottom of the tab, where you can restore them.
Last 90 Days
The card on the right replays your active standard rules against the projects created in the last 90 days, and shows how many of them reach each milestone and the % of Created. Use it to check a rule change before you run Recalculate History. Custom rules aren't included.
Recalculate History
Recalculate History re-stamps every project's milestones by replaying your current standard rules against past activities, stage history, role assignments, contracts and date fields.
- Milestones that also have a custom rule only get their empty dates filled.
- Dates it fills in from a later milestone are marked as filled in.
- Admin corrections are kept, including a date an admin cleared.
- No workflows run, and every change is recorded in the project's change history.
- Stage rules match past moves by the stage's current name (see Stage rules and renamed stages).
It runs in the background after you confirm.
Correcting a Project's Milestone
Users with this page's permission can set or clear a milestone date from the project's Milestones card. See Project Milestones.
Reporting
- The Milestone Funnel report shows how many projects reached each milestone and the days between them.
- In the Report Builder, every milestone is a project date field named
Milestone: <name>, and Furthest Milestone (Sales / Design / Production) shows the latest milestone a project has reached.