Systems

What Should a Creative Agency Track? The KPIs and Data That Actually Matter

By Danielle Stephanie · Published · 10 min read

Fig. 1Weekly agency dashboard
New inquiries9This week
Top lead sourceReferrals4 of 9 inquiries
Calls booked53 proposals sent
Clients signed2This month
Active projects1210 on track, 2 at risk
Overdue tasks3Across 2 owners
Team capacity82%Designer fully booked
Client health1 at risk2 need attention
getyouropstogether.co
Weekly creative agency dashboard showing inquiries, lead sources, conversion, active projects, team capacity and client health
In this guide
  1. Why does data tracking matter so much in your agency?
  2. What KPIs should your small creative agency track?
  3. How do you track where your agency's leads come from?
  4. How do you track how many of your leads turn into clients?
  5. How do you know if your agency has capacity for more clients?
  6. How should you track project status in your agency?
  7. What is a client health score and should your agency use one?
  8. What should be on your weekly agency dashboard?
  9. Where should your agency's data live?
  10. Do you need both a CRM and a project management tool?
  11. Should you use Airtable for project management in your agency?
  12. How should you organize your client files and passwords?
  13. How do you clean up your agency's messy data?
  14. Where should you start?
  15. Frequently asked questions
  16. Get your agency's numbers out of your head

Most agency owners we work with are frustrated by the same things when it comes to their numbers: nobody can say how many inquiries came in this month without asking the owner, it's unclear whether the designer has room for another client, and late projects only get noticed once the client complains. The agency KPIs to track are a short list of operational numbers that tell you each week whether your business is healthy and where it needs attention. A KPI, short for key performance indicator, is a number you've chosen to watch because it tells you something important. For most small agencies, that means new inquiries and where they came from, how many turn into signed clients, how much capacity your team has compared with the work you've booked, the status of every active project, and how each client relationship is going. Each number should have one agreed home, like a CRM for leads and clients and a project management tool for the work.

Why does data tracking matter so much in your agency?

When the only person who knows these numbers is the owner, every decision waits for the owner. Data tracking puts that information somewhere everyone can see it.

That's why data tracking is one of six core systems we believe every agency needs. Our belief, from working with creative agencies, is that almost all agency work falls into six areas: lead inquiry, client onboarding, delivery, offboarding, team management and data tracking. A system simply means a written, repeatable way of doing something that doesn't rely on one person's memory. The first four follow the client journey, which is every step a client goes through with your agency from their first inquiry to the day the project officially ends. The last two work behind the scenes, and data tracking supports all the others, because each one produces information your team needs, as the guide to systems every creative agency needs explains.

What KPIs should your small creative agency track?

Most KPI lists are built for much bigger firms. For a small agency, we start with five operational areas instead: your leads and lead sources, your conversion from inquiry to signed client, your team's capacity, the status of your active projects, and the health of your client relationships.

Financial numbers like revenue and profit belong in your accounting software, and decisions about pricing or financial targets should be made with an accountant or financial advisor rather than from an operations dashboard.

How do you track where your agency's leads come from?

The first area is leads. A lead is anyone who submits an inquiry to work with you, and a lead source is how they found you. The simplest way to capture it is a required question on your inquiry form with set answer options rather than a free-text box, so the answers can be counted. Choose the options by looking at where your recent clients actually came from and the channels you're putting time into, and keep the list short enough that people pick the right one, with an "other" option to catch anything new. Where you can, use UTM links, which are tagged links that tell your analytics where a click came from. Store the source on the lead's record in your CRM, short for customer relationship management, the tool where you keep lead and client records. There's more in the lead inquiry system guide, and if you'd like to build an automated inquiry process that captures this information for you, our High Season Challenge is a five-day challenge where you build exactly that.

How do you track how many of your leads turn into clients?

Once you know where leads come from, the next question is how many become clients. Your conversion rate shows that, along with where people drop off. Give every lead a stage in your CRM and move them through it. Your stages should mirror how your own inquiry process works, since every agency's looks a little different. Some agencies send a proposal before a call, some book a discovery call (the first call where you learn about their needs) first, and some skip the call for smaller projects. A common set is inquiry, discovery call booked, proposal sent, signed and lost, but name your stages after the points where a lead actually moves forward or drops off in your business. Counting how many leads reach each stage shows you where the biggest gap is.

How do you know if your agency has capacity for more clients?

Capacity means how much work your team can realistically take on compared with how much is already booked. It's the number we see guessed most often, and it's the one most likely to lead to burnout, because a client your team can't absorb lands right back on the owner. A weekly view of hours available versus booked per person is enough. If you've never measured it, start with a two-week time-tracking audit, explained in what team management should look like in a small agency.

Fig. 2Where agency data lives
ACRMLeadsClient recordsLead sources
BProject toolProjectsTasks and ownersProject status
CShared driveClient filesDeliverables
DPassword managerLoginsAccount access
EDashboardPulls the numbers together
getyouropstogether.co
Diagram of where creative agency data lives: CRM, project management tool, shared drive, password manager and dashboard

How should you track project status in your agency?

Capacity covers the work coming up, and project status covers the work already underway. Mark every active project as on track, at risk or blocked, have each project's owner update that status in your project tool, and watch overdue tasks by owner alongside it. See the guide on how to map client delivery.

What is a client health score and should your agency use one?

Clients rarely leave without warning signs: slower replies, missed approvals, more requests outside the agreed scope (the work they signed up for), late payments or less positive feedback. A client health score means checking those signs regularly and giving each client a simple rating. Once a month, have the account owner mark each client as healthy, needs attention or at risk, with a short note on why. Feedback collected at the end of a project feeds into this too, as the client offboarding guide explains (offboarding is how you officially end a project on a good note).

What should be on your weekly agency dashboard?

With those five areas defined, you need one place to see them together. A dashboard is a single view of the numbers you check regularly. The most useful ones fit on one screen and include new inquiries and their lead sources, discovery calls booked, proposals sent and clients signed, active projects by status, overdue tasks by owner, team capacity per person, clients marked needs attention or at risk, feedback received, and invoices outstanding from your accounting software. Have it pull numbers automatically, using Airtable interfaces, ClickUp dashboards or a spreadsheet, because hand-built dashboards get abandoned.

Where should your agency's data live?

A dashboard is only as good as the information behind it, which is why we believe in a single source of truth: each type of information has one official home that everyone knows and trusts. A common frustration is finding the same client launch date in the CRM, the project tool, a Slack thread and a Google Doc, with no two matching. Decide one home per type of data, have whoever owns a decision update the official record, and treat information outside its home as unofficial until it's moved.

Data typeWhere it should liveExample toolsWhere it should not live
Leads, lead sources and conversion stagesCRMHoneyBook, DubsadoYour inbox, Instagram DMs only
Client recordsCRMHoneyBook, DubsadoScattered email threads
Projects, tasks, deadlines and statusProject management toolClickUp, Asana, NotionSlack, sticky notes, your head
Team capacity and timeProject tool or time trackerClickUp, Asana, a spreadsheetGuesswork
Client health ratingsCRMHoneyBook, DubsadoMemory
Files and deliverablesShared drive with a standard structureGoogle Drive, DropboxPersonal laptops, personal drives
Passwords and accessPassword managerAny reputable team password managerSlack, texts, spreadsheets
SOPs and policiesSOP libraryClickUp Docs, Notion, Google DriveOne giant manual nobody opens
Financial recordsAccounting software, with your bookkeeper or accountantYour accounting toolScreenshots and memory
Weekly numbersDashboardAirtable interfaces, ClickUp dashboards, a spreadsheetCalculated by hand each week

SOPs are standard operating procedures, the written steps for a task. We're tech-agnostic, so the tools listed are examples.

Fig. 3Client folder structure
Clients
Client name
01 Admin
02 Brief and assets
03 Work in progress
04 Final deliverables
05 Reports
06 Archive
NoteCreate it from a template when a client is booked, so nobody has to ask where something lives.
getyouropstogether.co
Standard client folder structure for a creative agency shared drive

Do you need both a CRM and a project management tool?

Usually, yes. Your CRM holds relationships: who a lead or client is, how they found you, what stage they're at and their history with you. Your project management tool holds the work: what needs doing, who's doing it, by when, and what depends on what. When a client signs, mark them signed in your CRM and create a project from a template, by hand or with Zapier.

Should you use Airtable for project management in your agency?

Airtable is excellent as a database and a source for dashboards. Once an agency starts to scale, though, I don't recommend running project management there, because tasks, deadlines, dependencies and assignees get messier, and a dedicated tool like ClickUp or Asana handles them better. A clean setup keeps client records in your CRM, like HoneyBook or Dubsado, and reporting in a database or dashboard, while your project tool holds the tasks.

That's the split we used with Blessed Little Bungalow, Amber Guyton's interior design studio and home and lifestyle brand. We moved the team from Asana to ClickUp for project work and built an Airtable HQ with client journey dashboards and lead-source tracking for records and visibility. You can read this and other client stories in our client stories.

How should you organize your client files and passwords?

Files and logins are data too. Give every client the same folder structure and the same file naming convention, so anyone on the team can find anything without asking. What those folders are depends on your services and how your team works. To decide, think about what you collect from clients, what your team works on, what you hand over at the end and what you need to keep for your records, then make each of those a folder in the order work moves through your agency. A naming convention that includes the client name, deliverable, version and date is a common starting point. Client logins are some of the most sensitive information you hold, so store them in a team password manager, shared per person and per client. Remove access when a client or team member leaves.

How do you clean up your agency's messy data?

Where you begin depends on what's causing the most trouble right now, whether that's lost files, leads you can't trace or projects nobody can see. Most cleanups involve listing every tool, drive and channel where information currently lives, assigning one home per data type using the table above, moving active clients over before older ones, setting naming conventions and folder templates, and writing a short data policy that becomes part of team onboarding. If you'd like a head start, the free SOP Starter Kits in our Template Shop include policies and an SOP template, including kits for social media agencies and interior design studios. Archive rather than delete until you're sure, and build the dashboard last, once the data behind it is reliable. Clean data also makes it possible to step away, as explained in what to do before you go out of office.

Where should you start?

If you're not sure how much of your agency's information still lives with you, take the free Baggage Check, a self-assessment that shows where your agency still depends on you and what to hand off first.

Frequently asked questions

How often should I review my agency's numbers?

Check a short dashboard weekly, review client health monthly, and look at folders, tools and access every quarter.

Can I track my agency's data in a spreadsheet instead of a CRM?

Yes, while your agency is small, as long as the spreadsheet is the one official home for that information and everyone updates it. Set it up with the same stages and fields you'd use in a CRM so it's easy to move later. As leads and clients grow, a dedicated tool usually saves time because it connects your forms, proposals and records.

How do I get my team to keep our tools updated?

Make updating part of the task itself, for example changing a project's status in your project tool when a stage is finished. Keep your dashboard pulling numbers automatically so nobody has to rebuild it, and look at it together in your regular team meetings. Including your data rules in team onboarding means new people learn the habit from day one.

Get your agency's numbers out of your head

Start with the free Baggage Check, or grab a free SOP Starter Kit from the Template Shop to document where your data lives.

If you want your data tracking set up around how your agency already works, Ops Concierge is our done-for-you system build. For ongoing support that includes a monthly operations report, see the Residents' Lounge, our embedded operations partner retainer. And if you want support across all six core systems, RESORT Mode is our group program for creatives who want to scale to $30k+ months without the burnout. You get all the systems your agency needs, grow as a founder, and get real-time coaching as you scale.

Keep reading

Back to the blogRead the main guide: how to systemize your creative agency

Find out how much of your creative business is riding on you

Check Your Bags