How StageClock works
What it measures, how precise it is, and what it cannot see.
Getting started
- Connect Notion and, in Notion’s page picker, share the databases you want to track. Share the original database, not a linked view.
- Track a database. StageClock proposes its status property and reads the status groups (To-do, In progress, Complete).
- Start tracking. StageClock records the current status of every row, then every change from now on.
- Open the reports. They fill in as rows move; the cycle time trend needs about 10 completed rows.
1. Property to track
| Not started | To-do |
| In progress | In progress |
| Review | In progress |
| Waiting on client | In progress |
| Done | Complete |
Definitions
- Time in status: how long a row stayed in a status. Repeated stays are added up per row. Average, median and 85th percentile.
- Cycle time: total time in In progress statuses until the row first reaches a Complete status.
- Lead time: from the row’s creation in Notion until it first reaches a Complete status.
- Aging: how long an open row has been in its current status.
- Every figure says how many rows it is based on. Fewer than five rows: marked low confidence.
- Durations are calendar time, or working time when the database has a working calendar (working days, hours, holidays; set in setup). Reports can switch between the two.
The reports
Custom metrics
- Between two statuses: from the first entry into one status (or from row creation) to the first later entry into another. Example: time to first response.
- Sum of statuses: total time in chosen statuses before the row first reaches Complete. Example: time waiting on the client.
- Up to ten per database, each optionally written back to Notion as a number property in days.
Targets and forecast
- Targets: “cycle time within 5 days” (or lead time, or a custom metric). The report shows the share of rows that met it, week by week, against an optional goal.
- Forecast: from your own completed rows. “85% of rows finish within 9 days”, and for each open row the date by which it is 50% and 85% likely to be done, based on rows that took at least as long so far. Arithmetic, not AI.
Time per assignee
Choose a people property as the assignee: StageClock records who a row is assigned to, like statuses. By default it shows team figures only (time to first assignment, handoffs, unassigned time). Per-person figures can be switched on; they measure individuals, so in some countries employee representatives must be consulted first.
Sharing, exports and embeds
- Invite colleagues to a database as viewer (reports) or editor (setup too). They sign in with their own Notion account.
- CSV: transitions, intervals (time per status) or rows.
- Embed: a private link to one report. In Notion, type
/embedand paste it. Anyone with the link can see that report; revoke it any time.
Precision
- Exact: recorded from Notion’s change notification, to about a minute.
- Approximate: found by the hourly check (for example after a missed notification), placed at the row’s last edit.
- Estimated: the status was already set when tracking started. Notion keeps no status history StageClock can read, so its start is the row’s last edit. Reports can exclude these.
| Not started | 1.2 d | exact |
| In progress | 2.5 d | exact |
| Review | 3.1 d | approximate |
| In progress | 0.8 d | exact |
Limits
- History starts when you connect. Earlier changes cannot be recovered.
- Notion groups notifications that arrive within about a minute. A status held for only a few seconds may not be recorded.
- Notion notifications say that a status changed, not to what. StageClock reads the row right after; if it changed again in between, only the newer status is recorded.
- Rows in databases that are not shared with StageClock are invisible to it. Removing the share stops recording.
Write-back
Optional. StageClock adds Status since, Days in current status (a Notion formula on Status since, so it never needs rewriting), Cycle time (days), Lead time (days) and up to five Time in [status] (days). A Notion filter such as “Days in current status > 5” then shows the same rows as StageClock’s aging report.
Each write is an edit: Last edited by shows StageClock. Writes are silent, but database automations that react to edits can run. Only changed values are written, one request per row, at the pace Notion allows.
Alerts
Set a limit per status. Once a day, at the hour you choose, StageClock emails the rows that went over a limit since the last digest. A row is reported once per stay in a status. Optionally StageClock comments on the Notion page and mentions the assignee.