Running a weekly client update in ten minutes

A client status update template for agencies, and a ten-minute routine to fill it in from the board and Reports instead of from memory every Friday.

Gareth Thurlow 8 min read

The Northwind Rebrand jobs as a table grouped by priority: Critical, Important, Normal and Low groups with their counts, columns for title, labels, priority, assignee, due date and tasks, and an Export CSV button. The saved view “My critical jobs” is on screen. “Brand guidelines v3”, three days overdue, is raised from Important to Critical and moves into the Critical group.

The weekly client update is the email everybody means to send on Friday and nobody enjoys writing. It takes an hour because it is written from memory: scrolling through threads, asking the team what moved, and guessing at what is late.

It should take ten minutes. If the board is up to date, the update is already there; you only have to read it out. This article gives you a client status update template with five short sections, and a routine for filling it in from the table view and Reports.

Why status updates take so long#

Most status updates are slow for one of three reasons.

  • The facts are in different places. What was finished is in one tool, what was decided is in email, and what is late is in someone's head.
  • The update is written from scratch. A blank email invites a narrative, and narratives take time.
  • It tries to cover everything. A client wants to know what changed, what they need to do and whether the date still holds. They don't need every task.

The fix for all three is the same: a fixed template, filled in from the same screens every week, in the same order.

A client status update template#

Five sections, each a few lines. Copy it as it is.

  1. Done this week. The jobs that were finished, by name. No more than five; link to the rest.
  2. In progress. What the team is working on now, and when the client will see it next.
  3. Waiting on you. Anything that needs the client: a review, an answer, a file. Each with the date you need it by.
  4. Late or at risk. Anything past its due date, or close to it, and what you are doing about it. Say it plainly.
  5. Next week. What is due, and any date the client should hold.

Section 3 is the one that earns the email. If a client reads only one part, make it that one, and put it near the top if it has anything in it.

Minutes one to four: the table, grouped by column#

Open the project in the table view and set Group to Column. Each column is a stage of the work, so the groups map almost directly onto the template:

  • The last column, or the jobs marked complete this week, is Done this week.
  • The working columns are In progress.
  • The column where work waits for the client is Waiting on you.

The Completed filter has three settings: Show, Hide and Only. Set it to Only and sort by Updated to see what was finished most recently. Then set it back to Hide to read what is still open.

Add the Due and Assignee columns from Columns if they aren't showing, and click the Due heading to sort by date. Now every open job is in stage order, with its date beside it.

The Northwind Rebrand jobs as a table grouped by priority: Critical, Important, Normal and Low groups with their counts, columns for title, labels, priority, assignee, due date and tasks, and an Export CSV button. The saved view “My critical jobs” is on screen. “Brand guidelines v3”, three days overdue, is raised from Important to Critical and moves into the Critical group.

If you prefer to write the update in a spreadsheet or paste a table into it, Export CSV downloads the rows as shown, with your grouping and filters applied.

Minutes four to seven: what is late, and what is about to be#

The table's due date filter has Overdue, Due today and Due this week. Run through Overdue first: every job it shows goes into Late or at risk, with a line on why. Then Due this week gives you Next week, or the rest of this one.

For a wider picture, open Reports and choose the project. The overview shows Jobs completed, Overdue jobs and Active jobs for the dates you pick, and every tile is clickable: click one and you get the list of jobs behind the number. Set the range to Last 7 days and Jobs completed becomes your Done this week list, already counted.

Below the tiles, the at-risk panel lists open jobs that are overdue or due in the next seven days. If it says "Nothing is at risk", you can write that sentence with confidence.

Quick search results for “brand” across projects, and the Reports dashboard: Overview, Flow, People and Projects tabs, tiles for 128 jobs completed (up 32% on the previous period), a 3.2-day median lead time, 4 overdue jobs and 46 active jobs, and a weekly throughput chart.

Lead time and throughput explains the rest of Reports, if you want to add a line about how quickly work is moving.

Minutes seven to ten: write it, don't decorate it#

You now have every fact the template needs. Write each section in short lines, using job titles exactly as they appear on the board, so the client can find them.

A few habits keep it quick:

  • Name the job, then the change: "Brand guidelines v3: darker navy added, ready for your review."
  • Give every request a date: "Please review by Wednesday."
  • Link to the job, not to a file. If the client is a guest on the project, the link opens the job with its files and comments.
  • Leave out internal steps. Tasks are for the team; the client cares about the job.

If the client is a guest on the project, much of Waiting on you is already in front of them: files waiting for approval show on the job, and they can approve from there. The email points them to it. Sharing work with clients covers what a guest sees.

Let Reports send the numbers for you#

If part of your update is always the same numbers, schedule them. Save the report for the client's project, then choose Schedule… and pick weekly, a day, an hour and a timezone. Under Send to you choose who gets it, and that can include the client: a report about one project can go to anyone in that project, guests included.

The email carries the overview: jobs and tasks created and completed against the previous period, active and overdue jobs right now, overdue work by person, and a list of jobs at risk. Each copy counts only the projects its reader is in, so a client never sees numbers from another client's work. Every copy has a link to stop receiving it.

Only administrators, or the team member who saved the report, can schedule it.

A scheduled report doesn't replace the update. It carries the numbers, so your email can carry the judgement: what the numbers mean, and what you need from the client.

A worked example: Harbour Studio's Friday update#

Take a small agency, say Harbour Studio, which is rebranding its client Northwind. This is a made-up example. Its board runs Brief, In progress, Client review and Done, and Tom Becker at Northwind is a single-project guest.

On Friday morning Sam Okafor, the strategist, opens the Northwind project in the table, grouped by column. Done has two jobs from this week: "Social launch kit" and the copy for the email header. In progress has "Homepage hero", where Priya Shah's hero-direction-b.png is waiting for Tom's approval. Client review has "Brand guidelines v3", which went past its due date while Tom was reviewing it.

The Overdue filter confirms it: one job, the guidelines. Sam opens it, sees in the thread that Tom asked for a darker navy and Leo Ortiz has added "Deep Harbour (#0B2545)", and writes:

  • Done this week: Social launch kit; email header copy.
  • In progress: Homepage hero, second direction ready for you to approve.
  • Waiting on you: Brand guidelines v3, with the darker navy added. Please review by Tuesday. Homepage hero approval by Wednesday.
  • Late or at risk: Brand guidelines v3 is past its date while it waits for review. Nothing else is late.
  • Next week: final artwork for the social kit, due Thursday.

It takes Sam about ten minutes. Maya Chen, the studio lead, has also scheduled a weekly report for the Northwind project to Tom, on Monday at 09:00, so the numbers arrive at the start of his week and Sam's email doesn't need to repeat them.

The ten-minute routine, as a checklist#

  • Table view, Group set to Column, Due and Assignee showing.
  • Completed on Only for what was done; on Hide for what is open.
  • Overdue, then Due this week.
  • Reports, Last 7 days, click Jobs completed to check the list.
  • Fill in the five sections, with a date on every request.
  • Schedule the numbers once, and stop retyping them.

The Reports guide covers saved and scheduled reports in more detail, and the table view page shows the grouping and export.

A weekly update is quick when it reads from the board instead of from memory. Keep the board honest, use the same template every week, and the Friday email becomes ten minutes of reading and a few lines of judgement.

Written by

Gareth Thurlow

Founder, Skybase

Gareth founded Skybase to give agencies and client teams one place for client work, from the brief to the sign-off.