100% Consistent Reporting Across Clients With Unified Custom Fields

The Situation

A digital content agency came to us with a fast-growing operation and a ClickUp workspace that was starting to slow them down. They worked across many clients at once, each one with their own monthly mix of social posts, story posts, photoshoots, videos, and engagement work. Two distinct sides of the business ran in parallel: content management for clients who needed ongoing social presence, and content creation for clients who needed photoshoots and video production.

Lists were inconsistent. Custom fields existed on some lists and not others. Time tracking happened, but pulling it together into a clear picture per client or per employee was nearly impossible. The team was doing the work, but the system around the work wasn't keeping up.

The brief evolved over time, but the core was clear from the start. Build a ClickUp operation that shows every client's content pipeline, every team member's time, and every hour spent, in a way the agency can actually use day to day.

Our Approach

We rebuilt the ClickUp workspace around how the agency actually operates, with two parallel workstreams reflecting the two sides of the business: content management and content creation. Every client got their own list in the right folder, every list got the same structured custom fields (Month, Client, Content Type, Timeline), and every recurring piece of work got a template so onboarding a new client took minutes instead of hours.

Two reusable templates were built: one for content management clients covering everything except photoshoots and video, and one for content creation clients covering only photoshoots and video. Duplicating a template, naming the list, and the agency was ready to start working with a new client the same day.

Dashboards became the operating layer of the workspace. We built per-client dashboards showing every piece of content moving through that client's account, broken down by month so the team could see what was planned, what was in progress, and what was done. We built per-employee dashboards showing every team member's hours across every client, so the agency lead could see at a glance who was working on what and how time was distributed. Time tracking widgets and weekly timesheets pulled it all into one place.

As the agency grew, we kept the operation evolving with it. New employees got their own dashboards. Departing employees were archived without losing their tracked time. At the start of each new year, the previous year's data was preserved in a dedicated archive space, with fresh lists for the new year ready to go, so the team always worked on current data while historical data stayed accessible for reference.

Throughout every round of work, we delivered video walkthroughs alongside written updates, so the team could see exactly what changed, why, and how to use the new setup. The system kept growing without anyone needing to be retrained from scratch.

Before

• Lists were inconsistent, with custom fields existing on some but not others

• Content management and content creation work mixed across the same lists without clear separation

• Onboarding a new client meant rebuilding a list structure from scratch every time

• Time tracking happened, but rolling it up to per-client or per-employee views was manual and slow

• Year-over-year transitions meant either losing data or carrying messy historical lists into the new year

• The team lead had limited visibility into how the team's hours were actually being spent

After

• Two parallel workstreams in ClickUp, content management and content creation, each with their own folder, lists, and structure

• Two reusable templates for instant client onboarding, one per workstream

• Standardized custom fields across every list (Month, Client, Content Type, Timeline) so reporting works consistently

• Per-client dashboards showing every piece of content moving through that client's account, broken down by month

• Per-employee dashboards showing every team member's hours across every client they touch

• Weekly timesheets giving the agency a clean rollup of who tracked what, when

• Dedicated archive space preserving historical data without cluttering the active workspace

• Year-by-year list duplication so each new year starts clean while the previous year stays accessible for reference

• Video walkthroughs delivered with every round of work, so the team always knew how to use the system

The Outcome

The agency now runs a ClickUp workspace that reflects how they actually operate: two workstreams, many clients, a growing team, every piece of content tracked, every hour visible. The team lead can pull up any client's dashboard and see the month at a glance, or pull up any team member's dashboard and see where their time went. New clients get onboarded in minutes with the templates. New employees get their own dashboards. Old data stays accessible without getting in the way of new work.

What used to be a workspace the team worked around is now a workspace that works for them. The setup is built to keep growing with the agency, year by year, client by client, so the savings in coordination time compound as the business scales.