All insights
Operations & Delivery 9 min read

Agency CRM Setup: The Fields, Stages, and Reports That Actually Matter

The best CRM is the one that gets used. I have watched agencies sign up for the most expensive tools on the market and abandon them in 90 days. Here is the principle-first setup that makes any agency CRM actually work, with Attio as the worked example.

Watch the full video on YouTube. The article below is the operator playbook from this conversation.

The best CRM is the one that gets used. I have watched agencies sign up for the most expensive tools on the market and abandon them in 90 days. I have also watched £2M+ agencies built on a Google Sheet and a discipline. The tool matters less than the system around it.

I built and sold a £2.2M creative agency in Belfast and exited in 2022. We ran more than 70,000 projects through the CRM during that 13-year stretch. The discipline around the CRM, the fields, the stages, the reporting, is what made every other operating system possible.

This article is the principle-first setup that makes any agency CRM actually work, with Attio as the worked example. Pipedrive, HubSpot, Folk, Moxy, or even a Notion build will follow the same rules. The tool changes. The structure does not.

The principle: one system, single source of truth

Your CRM is not the sales tool. It is the customer journey tool. From the first enquiry, through qualification, the discovery call, the proposal, the verbal yes, the contract, the onboarding, the project, the renewal. One system manages that journey end to end. Every other tool feeds into it or pulls from it.

If your pipeline lives in one tool, your delivery in another, your invoicing in a third, and none of them talk, you do not have a CRM. You have three disconnected lists, and the founder’s head is the only place the picture is complete. That is the single biggest constraint on scale and on the discount a buyer eventually applies for control risk.

Pick one tool. Make it the source of truth. Everything else feeds it.

The fields that have to exist (regardless of tool)

The setup work is not “pick a tool”. It is “define the minimum data standard.” Once the fields are defined, you can configure any CRM around them.

On every company / client record

  • Standardised company name (no duplicates with three different spellings)
  • A unique client ID that other tools can reference
  • Primary service line
  • Account owner
  • Price model: retainer, project, or hybrid
  • Annual contract value or expected lifetime value
  • Start date and billing schedule

On every deal

  • Linked company ID
  • A stage that matches a written definition (more on this below)
  • Close date (committed, not “soon”)
  • Expected value
  • Deal owner
  • Source (inbound, referral, outbound, network)
  • Next action with a date attached

That last field is the one most CRMs make optional. Make it mandatory. If there is no next action with a date, the deal is not in the pipeline. It is a wish.

On every contact

  • Linked to a company record
  • Role and decision-making authority
  • Primary contact channel
  • Last touch date

On every project (once a deal closes)

  • Linked company ID
  • Service category
  • Budget in hours or pounds
  • Delivery owner
  • Start and end dates

This is the dataset that drives every report you will ever care about. If any of these fields are missing on any record, that report breaks.

Stage definitions: labels are not definitions

Most CRMs ship with stages like “Contacted”, “Qualified”, “Proposal Sent”, “Negotiation”. Those are labels. They mean nothing until you define what has to be true for a deal to sit at that stage.

A clean five-stage model that works for almost every agency setup:

  1. New lead. Interest shown, not qualified yet.
  2. Qualified. Pain confirmed, budget range identified, decision-maker spoken to. (If any of those three things has not happened, the deal is not in this stage no matter how good the conversation felt.)
  3. Discovery complete. Full discovery call done. Problem, context, timeline, and success criteria all documented.
  4. Proposal sent. Decision-maker has the proposal with a clear next step date.
  5. Verbal yes / procurement. Contract and onboarding.

When I installed stage definitions properly at my agency, two things happened. Total pipeline value dropped, because half the deals did not qualify against the new criteria. Close rate went up, because we were now working real opportunities instead of fiction. The full breakdown of how this feeds the broader sales system that runs without the founder is its own article, but the stage rigour starts in the CRM.

Reports you actually want

The reporting layer is where the CRM earns its place. Three reports drive 80% of the value.

Stage time. How long do deals sit at each stage? If deals stall at “proposal sent” for an average of 45 days, the bottleneck is follow-up cadence or proposal quality, not lead volume. Stage-time analysis is the diagnostic for where deals die.

Win rate by source. Are referral deals closing at 70% while outbound is at 8%? That is information that should change how you spend the next quarter. Most agencies cannot answer this because they do not track source consistently.

Pipeline coverage. Required coverage equals revenue target divided by close rate. If you want £50K next month at a 25% close rate, you need £200K of qualified pipeline today (and you needed it 45 to 60 days ago if your average sales cycle is two months). It is maths almost no owner I work with has run before we sit down together.

These three reports turn the CRM from an admin tax into the steering wheel of the commercial engine. They are also the data points buyers ask for during due diligence.

Email and calls inside the CRM (Attio example)

Once the fields, stages, and reports are right, the next thing that earns its place is email and call integration. This is where Attio (and HubSpot, Pipedrive, Folk to varying degrees) become powerful.

Connect your Google Workspace or Microsoft 365 inbox to the CRM. Every email to or from a contact attaches to the deal automatically. You stop searching three apps to find the last message thread.

Set up canned responses for the high-volume moments. Inquiry comes in? Auto-reply with a link to the pre-qualification questionnaire. They fill it in? Confirmation plus the discovery call booking link. The first hour of every new lead’s experience is templated, and your team’s time is freed for the conversations that need judgement.

For calls, capture and transcript matter more than you might think. If you can record discovery calls (with consent) and store them against the deal, you have the most valuable training asset in the business. Listening to a junior salesperson’s calls is how you train them to run discovery without you in the room. It is also how you spot when a deal really moved versus when someone wrote “qualified” because the conversation felt good.

Attio’s Call Intelligence does this directly. HubSpot has it. Pipedrive integrates with Gong, Fathom, or Otter. Even without a dedicated tool, Google Meet and Microsoft Teams transcribe natively now. The principle: the conversation is the evidence. Without it, the CRM is people’s memories, edited.

Automations and sequences (where the compounding work happens)

The fields, the stages, the integration: that gets you from “spreadsheet” to “CRM”. Automation gets you from “CRM” to “system that works without the founder.”

Three high-impact automations to wire up first.

Inquiry → pre-qualification questionnaire. Lead form submitted. Confirmation email out. Questionnaire link delivered. If filled in within 48 hours, route to a discovery call booking link. If not, follow-up reminder. Three small automations replace 30 minutes of human work per inquiry.

Stage change → follow-up tasks. When a deal moves to “proposal sent”, auto-create the follow-up tasks for day 2, day 7, day 14, and day 30. Salesperson never has to remember the cadence. The diary fills itself.

Deal closed-won → onboarding kickoff. Once a deal closes, the CRM creates the project record, assigns the delivery owner, kicks off the welcome email sequence, and triggers the invoice schedule. The handoff between sales and delivery becomes structural, not a Slack message.

Attio handles email sequences and workflow automations natively. Some agencies (mine included) push automations out to n8n or Zapier for the more complex multi-tool orchestrations. Either approach works. The principle is the same: every repeated task that follows a clear rule is automation work waiting to happen.

The pattern that compounds

Once the fields are clean, the stages are real, the reports are wired, and the automations are doing the heavy lifting, the CRM stops being a tool you fight with. It becomes the operating fabric.

That is when the weekly KPI cadence starts to work, because the inputs are reliable. That is when the retainer renewals become predictable, because you can see the renewal date 90 days out. That is when transferability goes from aspiration to something measurable, because someone other than the founder can answer the question “how is the pipeline?”

What to do this week

Two actions.

One: define the minimum fields. One page. Companies, deals, contacts, projects. What fields must exist for reporting to work? Print it. This is the data standard that any tool, including the one you have now, gets configured to enforce.

Two: write your five stage definitions. Not labels, definitions. What must be true for a deal to sit at stage 2? At stage 3? At stage 4? Write them. Share them with the team. Audit your current pipeline against them. Be prepared for the pipeline to shrink. That is the point.

If you want to see how your CRM maturity and pipeline visibility affect what your agency could be worth, the free Agency Valuation Calculator walks through that scoring in about 10 minutes. Pipeline predictability and the absence of founder dependency in sales are heavily weighted factors.

For structured support installing the fields, the stages, the automations, and the team training that turns the CRM into the operating fabric, the Strategic Growth Programme covers exactly this work. Book a discovery call if you want to discuss where your current CRM falls down.


Hear this in practice on Exit Ready:

One practical insight, every Tuesday.

Join the founders building something worth running, and one day worth selling.

Score your agency in five minutes.

Eight pillars. A personalised diagnosis of where your agency is strong, where it's leaking, and the one move that lifts your weakest area most.