Custom Project Management Solution for Agencies

project management template

David Krevitt

Lover of laziness, connoisseur of lean-back capitalism. Potentially the #1 user of Google Sheets in the world.

Project management for a digital agency is easily 100x more challenging than for a single business.

For a single business, standalone project management tools like Trello or Asana make a ton of sense.  You can build boards for each team or function, and use them for years.

But when you’re running a digital agency, the job to be done is always changing:

The list goes on.

If setup properly, Google Sheets can perfectly match this fluidity, and be the project management tool.

Let’s walk through how we built a custom Sheets project management system to manage a 7 figure digital agency.

This short video walks you through the solution we builtwatch it in action!

The problem

Trying to manage dozens of clients, hundreds of deliverables and client communications are a few problems every digital agency can relate to.

As Ryan Stewart (of WEBRIS) puts it:

Tools like Asana are great for task management, but they’re not built for the intricacies of a scaling agency. We needed a solution that could bend with our ever changing processes and systems.

Tired of client tasks falling through the cracks, Ryan turned to us to help build a custom project management system in the Google Suite.

The solution

Working with WEBRIS is always a pleasure, they meticulously document processes (this making our job easier).

They had an entire suite of templates built to run their agency – templates for project management, content creation, outreach campaigns, and client reporting.

We decided build it into a fully-connected platform.

It wasn’t easy or simple – we built Sheets just to trash them a week later, and went through dozens of iterations on the templates.

But at the end of the day, we landed on four simple rules for project management in Sheets.

 

1. One Sheet cannot do it all

It’s tempting to build one master project management Sheet, that has *all* your data packed into it.

That Sheet inevitably ends up like a junk drawer – a wasteland where tasks and projects go to be forever ignored.

Instead, we designed a suite of Sheets, that each perform one specific job.

For WEBRIS’s SEO project management suite, we split Sheets into their separate functions:

  1. Central tracker. The file that tracks day to day tasks, deliverables and open items. This Sheet is wired to “push” data to other Sheets trackers for hands free management.
  2. Content tracker. A file to manage content creation across clients at the agency, complete with content calendar.
  3. Outreach tracker. A file to manage the PR, link building and influencer outreach across the agency.
  4. Client tracker. Each client gets their own tracker to follow along with progress on tasks, deliverables, links and content. This file is auto generated and auto fed by the other 3 trackers.

Splitting up the Sheets files helped keep internal teams aligned and focuses. The content team didn’t have to waste time wading through tasks that didn’t concern them, they could focus explicitly on what the needed to do each day.

project management in google sheets example

A screenshot of the “Tasks” tab in the Central tracker

 

2. Ordain one Sheet as your Hub

Though you’ll need a village of Sheets, only one can be mayor.

This is critical for two reasons:

To keep data clean

You’ll need one master Sheet to hold on to all of your settings – important agency-level info like your list of clients. Using the importrange function, you can then push those options out to all of the other Sheets in your project management suite.

This let’s you do critical stuff like populating consistent dropdown menus everywhere – keeping your data nice and clean.

alt text

 

b. For ease of reporting

Looking at agency-wide stats requires pulling all your data together *somewhere*. Say you have 2 Sheets for separate workflows – content production and outreach, in the case of the WEBRIS project management process. To automate reporting, you can use that same importrange function to pull data back *into* your hub.

As one example, this ‘Pulse’ tab from the WEBRIS project management hub reports on link building campaign data from a separate workflow Sheet:

alt text

 

3. Always trigger the next step

Any project management process is, er, a process. Your team’s work is never done in isolation – there’s always a next step, and someone who needs to know about it.

Within Sheets, this often means populating a different tab on certain triggers – like when an article or deliverable is ready for review by an editor.

alt text

Google Apps script can be used to build out these triggers (called onEdit triggers) – and we used them heavily in the WEBRIS SEO project management suite.

 

4. Don’t be afraid to go beyond the spreadsheet

You might think that you can build the perfect, beautifully-automated project management suite for your agency.

There’s no such thing. Even WEBRIS, who worked for years to perfect their approach, still leans on work that happens outside of Sheets.

This might mean doing keyword research manually, by digging into reports from Ahrefs or SEMrush. This might mean using BigQuery instead of Sheets to store analytics data (as we do for the Agency Data Pipeline).

Not every process that *can* be automated, *must* be automated by Sheets.

The results

It’s tough to measure something tangible when it comes to increasing your company’s productivity.

However, 2 key things come to mind:

  1. WEBRIS’ revenue increased over 600% YoY from implementing Sheets based project management. On top of that, Ryan sold WEBRIS to another agency. He wrote publicly that his agency was acquired because of their processes + unique tool stack.
  2. Ryan decided to bundle this system up and sell it on his website as a standalone tool and training. He sent me the screenshot from Google Analytics. This simple Google Sheets system helped him generate an extra $75,390 in revenue.
google analytics sales data

Not bad for Google Sheets.

Interested in more?

  1. We published a free version of the templates as a Recipe – you can check it out here.
  2. You can purchase the full version of this tool here.

Or, we can collaborate to build you something custom. Set up a time to chat with me here.

Ready for BigQuery?

Get off the ground quickly, with quickstart Recipes for BigQuery.

GET COOKING