CRM reporting and forecasting is one of the key features company require when adopting a CRM
Case study
Industry: Digital
Business model: Business To Business
Company dimensions: 20 mil
Company type: International
The AS IS Situation
Our client asked us to support their team in a project to develop better CRM Reporting and Forecasting in their Pipedrive CRM. The company has 20 salespeople in two teams who follow 7 markets in 3 continents and they are growing.
The Project
The project went well beyond just setting up the reporting tool, that would be too easy.
We went through the data architecture of their DBs, defining what was working and what wasn’t and clarifying the dataset rules in order to optimise R&F outputs.
Among the client’s expectations they didn’t list the need to learn how to use the CRM, that was something not considered as a problem.
In fact, the setting of a more efficient data architecture requires changing the CRM use, mainly the data input should be carefully redesigned to enable leverage on a more effective dataset.

Adopted Solution
The outcome of the project has been wider and deeper. It came out that many deals were forgotten along the process, there were contacts that had never been touched. There were also missing data in Deals as well as in organisations and people DBs.
Essentially the use of many Pipedrive features was suboptimal, especially about Activities Management. The CRM reporting showed a lack of consistency in tracking activities done and managing the dialogues with counterparts along the sales process.
One outcome was to review the Sales Process, setting it with more direct and efficient stages and actions to do. Besides Pipedrive standard CRM reporting, we also set up a BI tool combining it with some Pipedrive dashboards and DB queries.
The two together offer a much better experience in data rendering, charts and queries for a detailed analysis.
Feedback about our CRM Reporting and Forecasting
“You went well beyond expectations, we were thinking to just set up a reporting dashboard, not remake our data management system, but thanks to your approach we discovered a lot of black holes and now we are more aware of what is going on”