4+ Hours Saved Weekly: Notion Workspace for a 12-Person Agency
A 12-person marketing agency with 15 active client engagements and 40+ monthly content pieces had no centralized system. Campaign tasks lived in Slack threads. Client data sat in personal spreadsheets. The founder had zero visibility into team capacity or project status. I designed and built a 7-database Notion workspace with relational architecture, real-time capacity dashboards, and executive reporting. Replaced a 90-minute weekly status meeting entirely.
The Problem
No Single Source of Truth
Client information, project status, and task ownership lived in different tools and different people's heads. Account managers tracked their own clients in personal spreadsheets. The founder relied on Monday standups to understand what was happening across 15 engagements. By Tuesday, the information was already outdated.
Team Capacity Was Invisible
No way to see who was overloaded and who had bandwidth. Work allocation happened by gut feeling and whoever responded first in Slack. Some team members carried 60+ hours of active tasks while others had capacity to spare. The founder only discovered imbalances when deadlines slipped.
Content Pipeline Running Blind
40+ content pieces per month across multiple clients and platforms. No calendar, no status tracking, no way to see what was scheduled vs. what was still in draft. Missed publish dates were becoming a client retention problem.
The Solution
Relational Database Architecture
Built 7 interconnected databases forming a complete agency operating system. Tasks roll up to Projects. Projects roll up to Clients. Content pieces link to both Projects and Tasks. Every record traces back to a client relationship. Rollup calculations show active task counts, estimated hours, and project health at every level.
Client CRM and Pipeline Management
Created a centralized client database replacing 12 individual spreadsheets. Fields include status (Active, Onboarding, Churned), monthly retainer value, assigned account manager, industry, and linked projects. Pipeline views show client health at a glance with stalled projects, delayed onboardings, and revenue concentration risk.
Task Management and Content Calendar
Task database with Kanban, table, and filtered views. Team members see their personal board. Project leads see everything tied to their accounts. The founder sees the full picture. A dedicated Content Calendar with calendar and board views tracks every piece through Draft, Review, Approved, Scheduled, and Published.
Team Capacity Dashboard
Each team member's record shows active tasks, estimated hours this week, and a formula-driven capacity status: Available, At Capacity, or Overloaded. Red/yellow/green indicators replace the guessing game. The founder allocates work based on data, not gut feeling.
Executive Reporting Dashboard
A master dashboard pulling filtered views from every database. Client health, tasks due this week, content going live, team capacity summary. All visible on a single page. Replaced 4 separate tools and a weekly 90-minute status meeting.
The Impact
Operational Transformation
- 12 individual spreadsheets, multiple Slack channels, and email threads replaced by one connected workspace
- Full visibility across 12 team members, 15 client engagements, and 40+ monthly content pieces
- Team capacity visible in real time with data-backed work allocation
- Client onboarding time reduced through standardized checklist tracking
Strategic Business Value
- Founder recovered 4+ hours per week previously spent gathering status updates
- Weekly 90-minute status meeting eliminated entirely
- Architecture supports doubling client count without adding administrative overhead
- Every task has an owner, a deadline, and a visible status
Have a similar problem?
Tell me what is going on and I will tell you what I would do about it. No obligation.
Get in touch