Home  ›  Guides  ›  Training GTM teams to get more from their CRM  ›  Ten CRM habits that keep pipeline data accurate

Ten CRM habits that keep pipeline data accurate

A pipeline report adds up the deals in your CRM. When those deals carry old close dates or out-of-date amounts, the report looks precise and points the wrong way.

Many pipeline errors come from small updates that nobody made. A deal stays in the proposal stage after the buyer stops replying. A close date passes without anyone changing it.

Agree what each field means first

Habits only help when everyone records the same thing in the same way. Before you introduce them, agree a short definition for each field the pipeline report uses.

FieldExample definition
Deal stageThe last step the buyer has completed, shown by buyer evidence that meets the stage's exit criteria
AmountThe value in the latest approved proposal or order, excluding tax, stated as one agreed measure
Close dateThe date the buyer expects to sign, based on what they told you
Next stepThe next agreed action with the buyer, with a date
Lost reasonOne value from a fixed list, chosen when the deal closes as lost

Choose one measure for amount, such as annual recurring revenue or total contract value. A report that mixes measures cannot be added up.

Write these definitions where people can find them, such as the help text on each field.

Set stage criteria from buyer evidence

Give each stage an entry and an exit criterion. Base each one on something the buyer did or said, so two reps put the same deal in the same stage.

Example stageEnter whenExit when
DiscoveryThe buyer agrees to a meeting about a defined needThe buyer confirms the problem, a rough timeline and who else is involved
DemoThe buyer accepts a demo with people who will use or approve the productThe buyer asks for pricing or a proposal
Proposal sentThe rep sends a proposal the buyer asked forThe buyer gives feedback, asks for changes or starts approval
NegotiationThe buyer starts approval or contract reviewThe buyer signs or declines

A rep's own activity, such as sending a proposal nobody requested, leaves the stage where it is.

Learn the ten habits

The last column shows how a manager or administrator can check each habit.

#HabitWhy it mattersHow to check
1Record a dated next step after every buyer conversationA deal with no next step has often stalled without anyone noticingMeetings logged this week on deals with no next step dated after the meeting
2Move the stage only when the buyer meets its exit criteriaStage drives forecast weighting, so early moves inflate the forecastA sample of deals that changed stage this week, checked for the buyer evidence each stage requires
3Change the close date when the buyer's timeline changesPast close dates make the current month look fuller than it isOpen deals with a close date before today, plus a sample of notes that mention a new timeline
4Keep the amount in line with the latest approved proposal or orderOld amounts carry early estimates into the forecastThe CRM amount compared with the latest approved proposal or order value
5Log calls and meetings on the same daySame-day notes are more accurate, and others can see the deal's historyActivities created a day or more after the activity date, where your CRM records both dates
6Add each member of the buying group to the dealA deal that rests on one person is exposed if that person leavesLate-stage deals whose contacts differ from the buying group named in notes or the proposal
7Close deals that meet the closure criteria, with a reasonDead deals in the pipeline hide the real coverage gapLost deals with no reason, and stalled deals with no dated follow-up
8Search before you create a company, contact or dealDuplicates split activity and double-count pipelineRecords created this week that your duplicate report matches to an existing record
9Use controlled values for categories you need to compareUse a fixed list for categories such as lost reason or source; keep notes for context that does not fit a listLost reasons or sources recorded as "Other" or left blank
10Review your own open deals before the weekly pipeline meetingA short personal review catches gaps before the meetingCounts for checks 1, 3 and 4 taken the day before the meeting and again that morning

Checks 2, 3 and 6 need a short sample review, because a report cannot read the buyer evidence in notes. Five to ten deals a week is an example sample size.

In habit 7, a stalled deal has, for example, no logged buyer activity for 30 days. Set your own threshold to match your sales cycle, and use it in every report.

A buyer who goes quiet has not necessarily decided against you. Agree the follow-up steps first, such as two further contacts over two weeks. Close the deal as lost when those steps get no reply.

A single contact can be correct for a small purchase with one decision-maker. Check the contacts on the deal against the buying group the buyer described.

Give each habit a place in the week

Link each habit to a regular moment in the rep's day or week.

WhenHabits
Straight after each buyer conversation1, 5 and 6: next step, activity log, new contacts
When the buyer meets a stage's exit criteria2: stage
When a proposal or order is approved4: amount
Whenever the buyer mentions timing3: close date
Before creating any new record8: search first
Friday afternoon or before the pipeline meeting7, 9 and 10: follow up or close quiet deals, tidy fields, review your list

Follow one deal through the habits

Example (illustrative): a mid-sized software deal over three weeks

An account executive meets a prospective customer's operations manager. Straight after the call, the rep logs the meeting and adds the operations manager as a contact. The rep then records a next step: a demo for the finance lead in ten days.

At the demo, the finance lead joins and asks for pricing. The rep adds the finance lead to the deal and sends a proposal two days later. The rep then moves the stage to "Proposal sent" and sets the amount to the approved proposal value.

A week later, the operations manager says the budget will not be approved until next quarter. The rep moves the close date into next quarter and notes the reason. The rep also sets a dated next step to check in after the budget meeting.

In the pipeline meeting, the manager sees the deal in next quarter with a clear next step. Without these updates, the deal would have sat in the current month and overstated the forecast.

Check the habits without a scoreboard

Build one data quality report that runs the checks from the table. Review it as a team each week, with totals for the whole pipeline, and fix gaps together.

  1. Create a saved report or dashboard with one view for each check that a report can run.
  2. Record the starting count for each check before you introduce the habits.
  3. When a check stays high across many reps, look at the process or the field itself.

Agree a target with the team. For example, a team might aim for most open deals to pass checks 1 and 3 within a month.

When a rep keeps missing the same habit, ask what makes it hard. The field may be in the wrong place, or the update may take too many clicks.

Introduce the habits a few at a time

Add two or three habits a week, starting with the next step and the close date. To train each role on these tasks, see role-based CRM training.

Avoid these common mistakes

Common questions

How do I fix pipeline data that is already wrong?

Run the checks and ask each rep to update their own deals within an agreed period, such as a week. Then introduce the habits so the data stays current.

How many stages should a sales pipeline have?

Use as many stages as you can define with distinct buyer evidence for entry and exit. If two stages rely on the same evidence, merge them.

Should sales managers update CRM deals for their reps?

Only in agreed cases, such as when a rep is on leave. Otherwise, ask the rep to make the update and confirm it in your one-on-one.

More on training GTM teams to get more from their CRM

All guides in this area

Train for the job: role-based CRM training

Train each role on the CRM tasks it does each week. Includes a task list by role, a 45-minute session and a competence check.

Read the guide: Train for the job: role-based CRM training

How managers coach from CRM data in weekly one-on-ones

Use CRM data to start coaching conversations in weekly one-on-ones. A suggested 30-minute agenda, the reports to open and questions to ask.

Read the guide: How managers coach from CRM data in weekly one-on-ones

Browse guides by area

All guides