Automation

Sales CRM: How to Design a Pipeline That Actually Forecasts Revenue

A CRM is not software: it is your sales process, written down. Here is how to structure pipeline, fields, and routine to forecast revenue.

Photo of Kauára BertoluciKauára BertoluciPartner and Head of Strategy & Growth, KCLOCKPublished on 9 min readShare this articleWhatsApp
3D render of glass cards moving along glowing orange tracks, representing a sales pipeline

A CRM is not software: it is the sales process written down somewhere everyone can see. The tool just organizes what already exists. This guide shows how to design the pipeline, set criteria for moving between stages, and use the CRM to forecast revenue, not just fill in fields.

How to design the pipeline

Each stage needs to represent a change in the customer's state, not an internal task. "Proposal sent" is a task; "proposal under review by the decision maker" is a state. Pipelines with more than six stages usually hide a lack of criteria.

A lean pipeline: stages, entry criteria, and mandatory next step
StageEntry criteriaNext step
New leadconversion logged with sourcefirst contact within minutes
Contactedresponse receiveddiagnostic call scheduled
Qualifiedproblem, budget, and timeline clearproposal sent
Proposalscope and price presenteddecision meeting dated
Negotiationspecific objection opendeal won or loss declared
Won / lostdecision logged with reasononboarding or nurturing

The fields that actually matter

  • Conversion source (channel, campaign, and page).
  • Loss reason standardized in a closed list.
  • Estimated value and expected close date.
  • Main objection logged.
  • Owner and date of the last interaction.

With source and loss reason filled in, you close the loop between marketing and sales and can confidently calculate CAC and LTV by channel.

Integrations that avoid manual entry

  1. Site forms creating opportunities automatically, with UTM data preserved.
  2. WhatsApp conversations logged in the contact's history.
  3. Offline conversion events sent back to media platforms.
  4. Automatic nurturing for leads without timing, connected to marketing automation.

Revenue forecasting and routine

Weekly

Review the pipeline by value and date, focusing on opportunities that have been stuck longer than the average cycle.

Monthly

Read conversion between stages, the same logic behind sales funnel stages, to find out where the process stalls and which objections kill the most deals.

CRM operation checklist

  • Pipeline with up to six stages, each with an objective criterion.
  • Every opportunity with a dated next activity.
  • Conversion source filled in automatically.
  • Loss reason in a closed list.
  • Monthly cleanup of inactive deals.
  • Weekly report of conversion by stage and by rep.

Conclusion

A well-run CRM turns sales effort into predictability. The gain doesn't come from the tool: it comes from the criteria you write into it. Two criteria matter more than the rest: the time to respond to the lead and the follow-up cadence logged as a task.

Frequently asked questions about sales crm

How many stages should a sales pipeline have?

Generally, up to six. Each stage needs to represent a change in the customer's state, with an objective entry criterion, not an internal task for the team.

Which fields are mandatory in a CRM?

Conversion source, estimated value, expected close date, main objection, owner, and a loss reason standardized in a closed list.

How does a CRM help forecast revenue?

With value, date, and the historical conversion rate per stage, you can estimate how the period will close. The forecast is only reliable when every open opportunity has a dated next activity.

What is the difference between a CRM and marketing automation?

The CRM organizes opportunities and the human sales process. Marketing automation handles nurturing and communication sequences until the lead is ready for the conversation.

Why log the loss reason?

Because it reveals patterns in price, scope, timing, and communication. Without that closed list, the team repeats the same mistake every cycle without noticing.

Photo of Kauára Bertoluci, Partner and Head of Strategy & Growth, KCLOCK

About the author

Kauára Bertoluci

Partner and Head of Strategy & Growth, KCLOCK

Marketing, tracking, and CRO strategist. Leads positioning, funnels, paid media, and measurement across KCLOCK's projects.

  • #sales
  • #process
  • #automation

Want to apply this to your funnel with people who do it every day?

KCLOCK builds high-converting funnels, landing pages, websites, and e-commerce stores. We diagnose your current funnel and show you where the revenue you're leaving on the table is hiding.

Further reading

More from the same cluster to go deeper on sales crm.