A reusable pattern for creative agencies and consulting firms to manage clients, projects, billable hours, and deliverables from pitch to completion.
Agency Operations Hub
2. Universal Objects & Data Fields
Client
: The central record for a customer company.
Client Name
, Industry
, Primary Contact
.Project
: A specific engagement for a client (e.g., “Q4 Marketing Retainer”).
Project Name
, Client
(Object Connection), Project Type
(Select List: Retainer, Fixed-Price), Total Budget
(Currency), Hourly Rate
(Currency).Deliverable
: A specific task or piece of work within a Project
(e.g., “Homepage Mockup V2”).
Deliverable Name
, Assigned To
(User), Due Date
(Date), Status
.Timesheet Entry
: A record of billable time spent on a project.
Hours
(Number), Work Date
(Date), Activity Description
(Text).3. Object Connections
Project
is linked to one Client
.Deliverable
is linked to one Project
.Timesheet Entry
is linked to one Project
.4. Workflows & Statuses
Project Workflow:
PITCH
→ PROPOSAL
→ ACTIVE
→ COMPLETED
→ ON HOLD
Deliverable Workflow (Creative Cycle):
BACKLOG
→ IN PROGRESS
→ INTERNAL REVIEW
→ CLIENT REVIEW
→ APPROVED
5. Workviews
ACTIVE
status.Deliverables
grouped by their status, providing a clear view of the creative production pipeline.Deliverables
grouped by the Assigned To
user, to help with resource planning.