Agency & Client Ops
Deliverable Review-Round Tracker
Every deliverable's review rounds tracked so nothing spins in circles.
Saves about ~1 hr per week
What it does
- Creates a review record per deliverable
- Tracks round number and status
- Reminds when a round has been idle too long
- Flags deliverables stuck in 3+ rounds
How it works
- Deliverable added
- Review rounds counted
- Idle reminders fire
- Stuck deliverables flagged
What's included
- Review DB
- Round tracking
- Idle + stuck flags
Set it up yourself
Follow these 4 steps in order. You will need accounts for: Notion.
Step 1: Set up the review DB
- Create a Notion database 'Deliverables': Project, Deliverable, Round, Status, Last Updated, Owner.
- Add statuses: In Review, Changes, Approved, Idle.
- Connect the internal integration.
- Test creating a record.
- Keep the Round as a number, not text.
Watch out: A numeric Round column is what makes '3+ rounds' detectable — a text column ('round three') can't be compared.
Step 2: Create records on handoff
- Trigger: when a deliverable is handed to the client (or a sheet/form marks it).
- Create the record with Round = 1, Status = In Review.
- Attach the deliverable link.
- Test the creation.
- Keep creation friction-free.
Watch out: The creation trigger is the discipline point — if records only exist when remembered, the tracker tracks nothing.
Step 3: Add the idle reminder
- Weekly scan: any In Review or Changes record with Last Updated > 7 days.
- Post a poke to Slack/email: deliverable, round, days idle.
- Daily scan for > 14 days (escalate).
- Test with stale records.
- Adjust thresholds to your rhythm.
Watch out: The idle reminder is what stops reviews rotting — a deliverable that sits un-reviewed for 3 weeks is a client relationship leak.
Step 4: Flag the stuck
- Flag any deliverable at Round ≥ 3 with a note.
- Monthly report: rounds-per-deliverable average, stuck list.
- For stuck ones, propose a 'converge' meeting.
- Review the report with your team.
- Tune where reviews get stuck.
Watch out: Three rounds is usually a sign the feedback isn't converging — the flag should trigger a conversation about the brief, not another pointless round.
Frequently asked questions
What does the Deliverable Review-Round Tracker automation do?
Every deliverable's review rounds tracked so nothing spins in circles. Creates a review record per deliverable
How much time does Deliverable Review-Round Tracker save?
It is estimated to save ~1 hr per week. Actual savings depend on your volume.
Which tools does Deliverable Review-Round Tracker use?
It works with Notion.
What does Deliverable Review-Round Tracker include?
Review DB, Round tracking, Idle + stuck flags.
Can I set up Deliverable Review-Round Tracker myself?
Yes. The do-it-yourself guide on this page walks through 4 steps, from getting access to testing the finished automation.