Case Study

MakeMeUnicorn
ร— ClickUp CRM

A full-service digital agency managing 90 active clients and a 40-member team โ€” every department, every client, every invoice, all inside one ClickUp workspace. I built the whole system from scratch.

90
Active Clients
40
Team Members
6
ClickUp Spaces
40+
Automations Built
Client
MakeMeUnicorn
Industry
Digital Agency
Platform
ClickUp
Scope
Full Operations
The Challenge

A 90-client agency running on
spreadsheets and group chats

MakeMeUnicorn had grown fast. The team was talented and the clients were real. But the operations hadn't kept up โ€” and cracks were starting to show.

๐Ÿ“
Scattered Tools
Trello, Google Sheets, Slack threads, email chains โ€” data lived everywhere and was visible nowhere.
๐Ÿ‘๏ธ
Zero Client Visibility
Nobody knew which client was at risk, behind on deliverables, or about to churn without manually digging in.
๐Ÿ”
Manual Onboarding
Every new client meant a week of copy-paste setup. No templates, no playbook โ€” just repeated effort from scratch.
๐Ÿ’ธ
Billing by Guesswork
Invoices tracked in a spreadsheet no one updated consistently. Payments slipped, retainers got forgotten.
The Solution

One workspace. Six systems.
Everything connected.

I architected a unified ClickUp workspace with six dedicated spaces โ€” each mapping to a core business function โ€” all wired together through custom automations and dashboards.

๐Ÿ—‚๏ธ
CRM Pipeline
Full lifecycle tracking for all 90 clients across 6 stages
๐Ÿ‘ฅ
Team Workspace
40 members across 6 departments with role-based task routing
โšก
Automation Engine
40+ automations replacing manual triggers, follow-ups and alerts
๐Ÿ“‹
SOP & Templates
Standardised playbooks and templated projects for every service line
๐Ÿ’ณ
Billing Tracker
Invoice status, recurring retainers and payment due dates per client
๐Ÿ“Š
Executive Dashboards
Live KPIs โ€” revenue, capacity, delivery health and churn risk
Module 01

CRM Pipeline โ€” every client, every stage, always visible

A six-stage kanban pipeline tracks every client from the first enquiry through to long-term retention. Each card carries the client's services, assigned owner, health score, and next required action โ€” so nothing falls through.

  • Intake form auto-creates a scoped ClickUp task with all client data
  • Onboarding triggers a 12-step checklist assigned to the right people
  • Active clients ping the owner when 7 days pass with no update
  • At-Risk flag escalates immediately to management with context
  • Health score calculated from delivery rate and response time
Client Pipeline โ€” Board View
New Lead8APApex LabsWebsite RedesignAwaiting replyBPBrightPathSEO + Paid AdsNewIntake12SBStellar BrandsRetainer PackageForm sent โœ“LALoop AgencySocial MediaReviewingOnboarding6NMNova MediaContent StrategyStep 4 of 12 โ–ธGPGridPointPPC ManagementStep 9 of 12 โ–ธActive58TGTechGrowthSEO ยท Ads ยท SocialScore 98HIHighImpactFull-serviceScore 99VCVeloce Co.CRO ยท ConversionScore 91At Risk4SWSpark & WaveSocial MediaScore 42 โš  FlaggedOBOldBridgeEmail CampaignsScore 38 โš  FlaggedChurned2FDFaded Inc.Paid AdsClosed
Team Workspace โ€” Spaces View
๐ŸคClient Success8 membersโ— Onboarding: Nova Mediaโ— Check-in: TechGrowth+14 tasks๐ŸŽจCreative11 membersโ— Design: Stellar Brandsโ— Video: HighImpact edit+22 tasks๐Ÿ“ˆSEO & Content9 membersโ— Content: NexGen โ€” Due Friโ— Audit: Veloce Commerce+18 tasks๐Ÿ’ฐPaid Ads7 membersโ— Google Ads: GridPointโ— Meta: Spark & Wave pause+12 tasks๐Ÿ’ณFinance & Billing3 membersโ— Invoice: OldBridge โ€” Dueโš  Overdueโš™๏ธOperations2 membersโ— SOP update: Onboarding v3+5 tasks
Module 02

Team Workspace โ€” 40 people, zero confusion

The team workspace is split into six department spaces. Every task gets routed to the right person based on service type โ€” no manager needed to manually assign work. Each space has its own views, priorities, and due-date rules.

  • Client Success โ€” owns onboarding, check-ins and health monitoring
  • Creative โ€” design, video, and brand deliverables
  • SEO & Content โ€” keyword strategy, blogs and audits
  • Paid Ads โ€” Google, Meta and LinkedIn campaigns
  • Finance โ€” invoicing, retainer tracking and payment chasing
  • Operations โ€” SOPs, tool management and system updates
Module 03

Automation Engine โ€” 40+ triggers that replace manual work

Every repetitive action in the agency โ€” onboarding checklists, deadline pings, billing reminders, status escalations โ€” is now a ClickUp automation. The team focuses on delivery, not administration.

  • New lead form โ†’ task created, owner assigned, 12-step checklist loaded
  • Client moves to Active โ†’ monthly check-in scheduled automatically
  • Task overdue 2+ days โ†’ owner notified + manager CC'd
  • Client silent 7 days โ†’ health score drops, At-Risk flag set
  • Invoice status = Sent โ†’ 7-day reminder auto-fired to finance
  • Project marked Complete โ†’ client satisfaction form dispatched
Automations โ€” Active (40+)
AUTOMATION 01 โ€” CLIENT INTAKEโšก TRIGGERForm submittedโš™ ACTIONCreate task + assign๐Ÿ“‹ TEMPLATELoad 12-step checklist๐Ÿ”” NOTIFYPing CS ownerAUTOMATION 02 โ€” AT-RISK ESCALATIONโšก TRIGGERScore drops below 50๐Ÿท STATUSSet โ†’ At Risk๐Ÿ‘ค ASSIGNEscalate to manager๐Ÿ”” ALERTSlack + emailAUTOMATION 03 โ€” BILLING REMINDERโšก TRIGGERInvoice โ†’ Sent (7d)โœ… CHECKStatus = unpaid?๐Ÿ“ง EMAILAuto reminder to client๐Ÿ”” TASKFinance follow-upAUTOMATION 04 โ€” PROJECT COMPLETIONโšก TRIGGERAll tasks โ†’ Done๐Ÿท STATUSProject โ†’ Complete๐Ÿ“‹ FORMSend satisfaction survey๐Ÿ“Š LOGUpdate dashboardโšก 40+ automations activeacross all 6 spacesโœ… 0 manual follow-upsadmin fully automatedโฑ ~40 hrs/week savedteam time reclaimed
Module 04

Billing Tracker โ€” every invoice, every retainer, always up to date

Every client's billing data lives inside their ClickUp record. Invoice status, retainer amounts, payment history, and due dates โ€” all visible from the same place the work is managed.

Finance Space โ€” Invoice Tracker
CLIENTINVOICE #SERVICEAMOUNTDUE DATESTATUSTYPETGTechGrowth Studiotechgrowth.ioINV-2026-0441SEO + Paid Ads$2,400Jun 15, 2026โœ“ PaidRetainerBLBloom Creativebloomcreative.coINV-2026-0438Web Design$1,800Jun 10, 2026โš  OverdueProjectNXNexGen Solutionsnexgen.ioINV-2026-0444SEO + PPC + Email$3,200Jun 20, 2026โ†— PendingRetainerVCVeloce Commercevelocecommerce.comINV-2026-0440CRO + Ads$1,650Jun 22, 2026โœ“ PaidRetainerHIHighImpact Digitalhighimpact.digitalINV-2026-0442Full-service Retainer$4,500Jun 25, 2026โ†— PendingRetainerShowing 5 of 90 clientsMonthly Retainer Total:$148,000Export CSV
Executive Dashboard โ€” Live KPIs
๐Ÿ’ฐMONTHLY REVENUE$148k90 active retainers86%๐Ÿ‘ฅCLIENT HEALTH84 / 90healthy ยท 4 at risk ยท 2 churned93%โœ…ON-TIME DELIVERY98%247 tasks done this week98%โšกTEAM CAPACITY72%28% headroom available72%Revenue Trend โ€” Last 6 MonthsJan$98kFeb$110kMar$118kApr$125kMay$138kJun$148k
Module 05

Executive Dashboard โ€” the whole agency on one screen

Leadership gets a live view of every metric that matters โ€” revenue, client health, team capacity, delivery rate, and churn risk โ€” without opening a single spreadsheet or asking anyone for an update.

  • Monthly revenue tracked in real-time against retainer targets
  • Client health scores surfaced automatically โ€” no manual reporting
  • Team capacity visible per department โ€” prevents burnout and overload
  • On-time delivery rate calculated from actual task completion data
  • Revenue trend chart updated automatically every week
  • At-risk clients escalated before the client notices a problem
The Results

What changed after the system went live

Within the first month, the impact was visible across the entire agency.

40h
per week saved
Manual admin time eliminated through automation. The team now focuses entirely on delivery.
0
missed deadlines
In the first 3 months post-launch. Deadline alerts and automated pings made it impossible to forget.
93%
client health rate
Up from untracked. At-risk flagging caught 4 clients before they churned โ€” saving the retainer revenue.
What the agency got
One source of truth for all 90 clients
Fully automated onboarding flow
Real-time billing and invoice tracking
Team capacity visible at all times
Client health scoring with escalation
Executive dashboard with live KPIs
Standardised SOPs across every service
Automated project completion reports
Zero dependency on manual admin
Get In Touch

Need a system like this?

I build ClickUp operating systems for agencies, studios and service businesses โ€” custom CRM pipelines, automations, dashboards and SOPs that actually work at scale.

Available now โ€” responds within 24 hours