Making Dashboards Match Reality

The Problem: "Invisible Work" An advertising agency with 100+ contractors was "using ClickUp," but the leadership dashboards were useless. Contractors were working in Slack or email instead of the tool. Tasks had no dates, time tracking was a "suggestion," and the founders couldn't see where the money was actually going.

The Mechanic’s Inspection: I did a deep dive into their ClickUp setup and found three major leaks:

The "Off-Tool" Leak: Work was happening in private chats, so the system was always out of date.

The "Guesswork" Leak: Tasks were missing owners and due dates, making workload tracking impossible.

The "Trust" Leak: Because the data was messy, managers stopped looking at ClickUp entirely and went back to manual status updates.

The Fix (What I actually did): I stripped the system down and rebuilt it with a "Standard Behavior Protocol" so the tool would finally work for the team, not against them:

Mandatory Fields: Set up required fields for every task (Owner, Start Date, Due Date, Priority) so nothing gets lost.

Intake Triage: Created a single path for all new work. If it's not in ClickUp, it doesn't exist.

Contractor Rules: Defined simple status changes (e.g., using "Blocked" instead of just leaving a task sitting) so everyone knows who is stuck.

Automated Cleanup: Built simple alerts that ping managers when a task is overdue or missing a time log.

One Clear Dashboard: Built a single view for leadership that shows exactly what is overdue, who is overloaded, and how many hours were logged vs. the estimate.

The Result: The agency moved from "memory-based" management to "system-based" facts. The founders can now justify every invoice because every hour is backed by a log in the system. No more "guessing" where the margins went.