Skip to content

CRM with a Standard Sales Process, Customer 360 and Quotes

Industrial polymers producer

In short

How can a B2B manufacturer move customer data from spreadsheets into one CRM?

Customer data at the client lived in personal notes and spreadsheets, prospects were validated by hand, and every salesperson worked slightly differently. Management could not make decisions from data that did not exist in one place. We built a CRM with one sales process, a Customer 360 view and a semi-automated quotation process.

At a glance

  • One customer view replaces notes and spreadsheets
  • One standard sales process for the whole team
  • Semi-automated quotation process

The client

The client is a business-to-business producer in the polymers and chemicals sector, selling to industrial customers through a direct sales team. The CRM covered the sales process from prospect to quote and gave management one view for reporting.

What it was costing them

  • Time: salespeople searched notes and spreadsheets for customer history and rebuilt quotes by hand.
  • Errors: prospect validation and onboarding were manual, so data was incomplete or inconsistent.
  • Key-person risk: customer knowledge sat in personal notes, so it left with the person.
  • Missed sales: without competitor and project data, cross-selling and co-selling opportunities went unseen.
  • Weak decisions: management could not report from consistent data.

What we built

We built a CRM that standardised how sales data is entered and added a Customer 360 view, reminders and a semi-automated quotation process.

  • One view of each customer: a Customer 360 view brings contacts, history, meetings and projects together.
  • The same process for everyone: standard forms and stages guide each salesperson through the same sales process.
  • Competitor knowledge in one place: competition analysis is captured against the customer, not in a private file.
  • Meetings and new projects recorded: reporting on meetings and new projects is part of the CRM, not a separate spreadsheet.
  • Fewer missed follow-ups: automated reminders and suggestions prompt the next step.
  • Faster quotes: the quotation process is semi-automated, with flexible and managed price handling.
  • Prospect onboarding made simple: validation and onboarding of new prospects follow the same standard path.
  • Data for management: reporting capabilities were increased, so decisions use CRM data.

Results

  • Customer data, competitor notes, meetings and new projects are captured in one standard CRM structure.
  • Quotations became easier and less time-consuming, with flexible price management.
  • Reminders and suggestions give the sales team a proactive way to follow up, which supported more co-sale and cross-sale opportunities.
  • Management gained reporting on standard data for strategic decisions.

The risk most teams miss

The month-three risk is adoption. If entering data is harder than keeping a private note, salespeople go back to spreadsheets and the CRM goes stale. Price lists and quote rules also go out of date. We kept data entry standard and short, and used reminders and suggestions to give people a reason to open the CRM. We also name a price list owner and publish a data quality view.

What we would add today

Improvements we would add on top of what is live.

  • Add Copilot in Dynamics 365 Sales or a Copilot Studio agent to summarise customer history before a meeting.
  • Use AI Builder prompts to draft a quote cover note and a prospect summary from CRM data.
  • Apply Dataverse row-level security by region and product line, so people see only their own accounts.
  • Move releases to Power Platform pipelines with environment variables for price lists and connection references.
  • Open a Power Pages page where customers view and accept quotes.

Technology

Microsoft Dynamics 365 and Power Platform: CRM on Dataverse, Power Automate for reminders and quotations, Power BI for reporting.

Tell us where your customer data lives today, and we will tell you what it takes to put it into one standard sales process.

Products and capabilities

  • Dynamics 365
  • Dataverse
  • Power Automate
  • Power BI
  • Customer 360
  • sales process
  • quotation process

Have a Microsoft project in mind?

Tell us what you need built, fixed or supported. A senior consultant replies within one business day.