Skip to content
andydataguy
Wiki Corpus

CRM Automation. Each automated handoff needs an owner who can complete the next task.

OPERATIONAL SYSTEMS · Reading guide~12 min read · 2,767 words

A completed sales call should leave the rep with a defined next action. Recording that the call happened gives you an activity count. Record the outcome, the follow-up owner and the condition for advancing the deal. Those details give the team something it can work from. CRM automation connects those events to the next piece of work.

I've worked with agencies that produced substantial results for their clients while barely having a functioning CRM themselves. They could deliver the service while their own funnels, sales processes and automations needed work.

That distinction changes where a rebuild starts. Adding a required field can make a dashboard look more complete while giving a rep another reason to keep the useful information somewhere else. A spreadsheet or a Slack thread may be doing a job the CRM hasn't made easy enough to do inside the record.

The design problem is finding that job and giving it a place in the workflow. A rep should be able to see what happened, what the current state means and which action they own. Management can then build reports from those records, with the limits of the data visible.

The work involves stage definitions, task rules and the connections to other systems. You can change each of those separately, but they have to agree about the work they're describing. An automation that assigns a task at the wrong stage just distributes the confusion.

Still from the hero animation. Five lifecycle stages sit on a lane running from the rep to the buyer, each stage pointing along the lane, with a single thin branch feeding a dashboard above.
Design stages around the rep's next action. Management can build reports from records of that work, with missing information and exceptions visible.

Design the CRM around the rep's work

Definitions have to fit the work

My CRM design starts with the reps who use the system daily. I define what a qualified lead, an opportunity and an account mean for this business, then map the stages and handoffs that deals actually follow. Those decisions need answers before they become software settings.

Those decisions constrain one another. A rep can't consistently mark an opportunity qualified if marketing and sales use different definitions. An agreed definition doesn't help much if the rep has to enter the same information in several places before creating the follow-up. The workflow has to make the agreed action practical.

Required fields need an operational use

A field review starts with what someone uses the information to decide. Some fields are necessary for qualification, delivery, compliance or reporting. Others may be leftovers from an old workflow. Removing a field needs the same care as adding one, because a field that looks unused to sales may feed a downstream obligation.

The questions are concrete enough to work through with a rep and the people who consume their records:

  • Which information changes the next action on this deal?
  • Who uses each required field, and for what decision?
  • Which information already exists elsewhere and could be brought into the record?
  • What happens when the rep can't supply an answer yet?

A management report remains a legitimate requirement. It needs records that represent the work accurately, including missing information and exceptions. Making every field mandatory can replace an unknown answer with a made-up answer that passes validation.

Two three-legged stools. The one in front stands level on legs of equal length and holds a lit amber lantern. Behind it, a grey stool with one short leg has tipped over, and its lantern lies dark on the floor.
A CRM stands on three legs: the people who work it, the definition of each stage, and the process deals actually follow. Shorten any one of them and the whole thing tips, whatever the software cost.

Qualification defines who belongs in the sales process. The CRM then records how those people and deals move through that process. Turning that movement into explicit states and transitions is the state-machine design problem.

Define the event that changes each stage

Lead, Marketing-Qualified Lead, Sales-Qualified Lead, Opportunity and Customer are familiar labels. Their usefulness depends on the definition behind each one. A qualified-lead count combines the judgments of the people entering those records.

A state describes where a record is now. A transition describes the change from one state to another. The entry condition says what evidence permits the change. A form submission, a completed discovery call or an acknowledged proposal can supply that evidence, provided the team has agreed what each event means.

Stage definitions need evidence and a next action

Consider an illustrative service business that uses an application before a discovery call. Its definitions could look like this. These are design choices for that example, not universal CRM definitions.

Stage Evidence required Next action
Lead A contact has entered through an identified source. Check whether the record is usable and who owns it.
Marketing-qualified lead, or MQL The application is complete and matches the business's agreed fit criteria. Route it for sales review.
Sales-qualified lead, or SQL A rep has held discovery and recorded the required qualification answers. Decide whether to propose work or disqualify the deal.
Opportunity The buyer has acknowledged a proposal for a defined piece of work. Record the buyer's next decision and the rep responsible for follow-up.
Customer The buyer has signed the agreement and completed any required initial payment. Hand the agreed scope and responsibilities to delivery.

The SQL definition needs more than a completed-call checkbox. My qualification approach asks about budget, authority, need, timing and engagement. The business has to decide which answers permit a deal to advance and which answers require another conversation. A booked call supplies different evidence from a held call; neither proves that the buyer can approve the purchase.

A grey cloud-shaped dial with a drifting needle sits unlit on the left. To its right, three heavy switches on a rail are each held down by an object: an envelope, a telephone handset and a sealed folder. An amber lamp glows above each thrown switch.
A stage defined by a feeling drifts from rep to rep. A stage defined by a trigger flips when something happens, such as a form sent, a call held or a proposal acknowledged, so the dashboard counts events instead of opinions.

People, accounts and deals can have different states

A contact can belong to a customer account while discussing a new opportunity. Closing that opportunity as lost doesn't necessarily end the existing customer relationship. Keep the meaning of each record explicit before applying a lifecycle change across all of them.

The same discipline applies to stage count. Split a stage when the work requires a different decision, owner or action. Extra labels without a different operational meaning give people more places to disagree. A missed entry condition should leave the record visibly incomplete, with someone responsible for resolving it, rather than let a downstream rule assume qualification happened.

Stage history then becomes something you can inspect. Pick a transition and ask which event caused it, what evidence was recorded and what the new owner did next. That check connects the stage name to the work it claims to represent.

Give each automated handoff an owner

A rule earns its place by removing a defined piece of manual work. A rep might create a follow-up task after a call, look up missing company information after an application, or ask a manager to assign an incoming lead. Automating one of those actions starts with deciding exactly what should happen.

Check each rule against the same questions: what recorded event starts it, which action follows, who owns that action and what happens when the rule can't complete? A notification can help someone notice work, but the notification itself doesn't establish that anyone accepted responsibility.

A completed call can create a follow-up task

An illustrative discovery-call rule could start when the rep records that discovery is complete and saves the outcome. The rule creates the corresponding follow-up task on the deal and assigns it to the deal owner. A disqualified outcome follows its own defined path, so it doesn't produce a proposal task just because a call occurred.

The task needs enough context for its owner to act. It should point back to the deal and the recorded outcome. Sending the same unexplained alert to a channel full of people leaves the assignment decision for someone else.

A tall painted backdrop of a complicated machine, flat gears and pipes on a board held up by wooden braces, stands dark on the left. On the right, a small real crank turns one gear and lifts an amber crate onto a shelf under a warm lamp.
An automation that fires on no real event, leaves no owner and breaks silently is scenery. It makes the CRM look busy while the work still waits on a person.

Failure needs a place in the workflow

A missing deal owner should produce a visible exception for an assigned person to resolve. A repeated call event shouldn't create duplicate follow-ups. An enrichment failure should leave the field marked unknown instead of filling it with a plausible guess. These are design requirements to check in the chosen tools, not assurances that every CRM provides them automatically.

Response timers, rotating assignment and idle-deal reviews can all be useful once their purpose is clear. Choose response thresholds around the service the team has agreed to provide. Define inactivity using the actions that matter in that sales process. A deal waiting on an agreed buyer decision needs different treatment from an incoming lead nobody has opened.

Each rule also needs someone who can inspect a failure and change or stop the rule. My business-automation deliverables include alerting, logging and runbooks for that reason. The person responsible for the workflow needs to see whether a rule fired, what it changed and what remains unresolved. Counting enabled automations tells them none of those things.

Performance triggers created tasks for solar media buyers

I used this approach while consulting with a solar agency managing more than 50 client accounts. The customers were buying leads. The agency managed the advertising behind that service, and I helped put together the data infrastructure and a shared dashboard so the team could see performance across accounts.

The team used Make.com automations to create tasks from performance triggers, including deviations from averages or anomalous results. Those tasks went to media buyers through a shared distribution process, rather than leaving each buyer permanently responsible for a fixed set of accounts.

My portfolio calls it round-robin. In the recorded account, I described the tasks as randomized and distributed among the buyers, with flexibility when someone was away. That supports the principle of shared task routing. It doesn't establish an exact rotation algorithm or a guarantee that everyone received an equal workload.

A sales team can apply the same design question to incoming leads: what event creates the work, which people are eligible to receive it and how does someone find work that remains unassigned? The answer still needs to fit their capacity and responsibilities. A rotating assignment rule doesn't make every rep interchangeable.

Two panels running the same CRM. On the graveyard side, a record crammed with form rows and required-field markers, sticky-note workarounds spilling off the screen, and a rep with his head in his hand. On the goldmine side, one screen carrying three connected cards in sequence, intake to work to result, and a rep sitting upright facing it.
Both panels run the same software. The variable is whether it was designed for the rep who sells or the manager who reports, and the system follows its design audience.

The solar example describes media-buying task distribution. It doesn't isolate how much time the routing rule saved or how it affected sales-CRM adoption. The broader work involved performance analysis and operating decisions as well. Assigning its business results to the routing rule alone would claim more than the record supports.

What transfers is the connection between a recorded signal and a task someone can act on. Keeping that connection accurate gets harder when the signal comes from a different system.

Decide which system owns each field

Billing records, product activity and support conversations can give a rep context that never appears in a sales note. Bringing that information into a CRM requires decisions about which records belong together and which system can change each value. Connecting the applications doesn't settle either question.

Map record identity before copying data

A billing customer ID, a product user ID and a CRM contact ID identify records inside their own systems. They don't automatically identify the same person or business across systems. A customer account can also contain several users and contacts.

Choose the entity you're joining, then keep an explicit mapping between its system-specific IDs. Email can help find a candidate match, but people change addresses, share inboxes and use more than one address. A company domain can contain many different people. Neither should silently authorize merging records that haven't been resolved.

An unresolved match needs a visible review path. Copying payment information onto the wrong contact can produce a convincing record about the wrong customer. The integration needs to preserve the source IDs so someone can investigate and correct that mapping without guessing which record supplied the data.

Give each shared field an authoritative source

Field ownership says which system's value the others should use. This illustrative map assigns an owner to each shared field. The business still needs to agree on what each field measures.

Field Authoritative source CRM use
Payment received The billing system that recorded the payment Show the payment alongside the customer record.
Last product activity The product's activity record Supply context for a conversation or review.
Deal stage The CRM's agreed sales workflow Drive the sales task and pipeline report.

The connection can carry different fields in different directions. Billing can send payment data to the CRM while the CRM sends a sales-owned field elsewhere. Each field still needs its own owner and update rule. Two applications independently overwriting the same field can replace a current value with a stale copy.

A violet column built like stacked vertebrae stands in the center. A coin chest, a lantern, a bundle of envelopes, a lifebuoy and a bound book each feed it through a channel with a one-way valve, amber liquid flowing inward. In a grey corner, two pipes pushing against each other spray where they meet.
Billing owns what the customer paid, the product owns when they last logged in, and the CRM owns the deal stage. Give each shared field an owner and update rule. Different fields can flow in different directions. Competing writes to the same field can replace a current value with a stale copy.

Resolve disagreements without erasing their meaning

A paid billing account and a lost deal can both be correct. The lost deal may concern new work for an existing customer. A customer who hasn't used a product recently may still have an active subscription. Those records describe different facts, so forcing them into a single active/inactive value loses information.

A conflict on the same field needs a different response. Keep the source values and route the disagreement to an owner who can resolve it. A failed sync should also remain visible, including when the CRM last received the information. A previously correct value can become misleading when someone assumes it's current.

I've worked with ClickUp, HubSpot, Salesforce and other tools. These design decisions recur across platforms, but permissions, integration behavior and available history differ. Check that the chosen connection can preserve identity, field ownership and failure information before relying on it for a handoff.

Rebuild beside the system that carries live work

A CRM rebuild changes the records and habits the business uses to keep work moving. The sequence should protect that work while exposing mistakes in the new design. A calendar can organize the project. The cutover decision needs evidence that the workflow can carry live deals.

Observe work before redesigning it

Sit with reps while they use the existing system. Watch without coaching first. Record the spreadsheets, messages and remembered steps they use to complete a deal, along with the fields they skip or fill just to get past validation. Then ask what each workaround makes possible.

Observation shows the action; the follow-up conversation helps explain it. A parallel spreadsheet might contain information the CRM can't represent, or it might be someone's preferred view of data that's already present. Those are different design problems. Treating both as resistance to change can remove a useful tool without replacing its function.

Map the current states and handoffs with the reps and the teams who receive their work. Agree on the entry conditions, owners and exceptions. Decide which automations survive and which fields flow from another system. The redesign should let those people explain what changes in their own work before configuration begins.

Give the parallel run an explicit scope

Configure the new workflow beside the existing one, then use a bounded cohort of new deals to exercise it while the existing book stays where it is. Keep the authoritative record for each deal clear. A parallel run where both systems can send the same buyer a follow-up creates a second problem while testing the first.

Check the full path on those deals. The rep should be able to identify the current state and next action. The task should reach its owner, the integration should update the intended record and the report should count the event using the agreed definition. Include missing information and failed actions in that inspection.

Two bridges cross the same dark river. The old stone bridge still carries a steady line of carts. Beside it, a new timber bridge lit by amber lanterns carries only a few trial carts, and one freshly patched plank glows where a gap was found.
Configure the new CRM beside the old one and send a small cohort of live deals across it first. The gaps show up while the old bridge still carries the business, and the cutover waits until they are fixed.

Gaps found here are reasons to adjust the design before widening the cohort. Decide in advance what happens to those live deals if the new workflow has to stop. Preserve enough record history and ownership information to resume work without losing a buyer's commitment or sending a duplicate message.

Migrate and teach the actual workflow

Move the remaining data after the critical paths work, with backups, a checked mapping and a recovery plan. Retiring the old workflow needs an explicit decision about its records, integrations and automations. Leaving an old rule active can undo the new design even after the team stops opening the old screen.

Enablement should use the tasks people perform: process an incoming lead, record discovery, resolve an exception and hand an accepted scope to delivery. Keep instructions and ownership accessible after the session. Documentation is part of the operational handoff.

Track whether people use the workflow, but inspect whether the records and handoffs are correct too. Logging in doesn't establish that a rep recorded the outcome or that delivery received the agreed scope. A rebuild has to make those actions usable enough to repeat.

Start with a handoff you can trace

You can begin this work without replacing the CRM. Pick a handoff whose failure the team can describe, then follow an actual record through it. The point is to find where the event, the definition and the next action stop agreeing.

A bounded starting sequence keeps the change inspectable:

  1. Watch a rep complete the work. Record the extra tools, missing information and manual decisions involved. Ask which of those steps the rep depends on before removing any of them.
  2. Write the stage transition on one page. Name the prior state, the event, the evidence required, the next owner and the action that follows. Let the people on both sides of the handoff challenge it.
  3. Inspect the rule attached to that transition. Keep it if it produces useful work. Change or retire it if it has no useful recipient or duplicates another action, after checking downstream dependencies and recording how to restore it.

Adding another automation may be the right decision. So may removing a rule that sends an alert nobody uses. The decision follows the observed work and the agreed responsibility. More rules don't repair an undefined handoff.

Record what happened on the next real deal that uses the change. Check that the task reached the intended person and that they could complete it from the information provided. Keep unresolved cases visible so the next adjustment addresses a specific failure.

The rep who completed the call should be able to open the deal, see its recorded outcome and find the follow-up they own. The person receiving the handoff should be able to do the same. That gives the activity count an operational meaning you can explain when someone opens the report.

Visuals 7

Keep reading