The Client Company
Better Business Partnership is a free business sustainability program funded by Ku-ring-gai, North Sydney, and Willoughby City Councils in Sydney, Australia. This program promotes and supports small and medium-sized businesses to be more successful through sustainability. They do it by educating and providing free advice for local businesses of all types. In other words, BBP guides these businesses to be more efficient with their resources and make operational improvements to achieve environmental, social, and economic gains for long-term success.
BBP used an online assessment platform called “Brilliant Assessment” for data collection and evaluation of the businesses, totally separated from their CRM. Thus, double data entry to CRM was a serious issue for this client.
BBP has been supporting local businesses in Sydney’s north shore since 2009. In short, this company is helping thousands of local small and medium-sized businesses to save money on energy, water, and waste costs.
365 Digital Consulting helped them with the integration of their third-party assessment software and the company’s CRM, resulting in saving lots of time and avoiding double data entries. Additionally, with the new customised solution, they were able to capture extra details regarding their customers and the customers’ evaluation.
Helped 1000+ SMB on sustainability program
Microsoft Dynamics 365 CRM customisation
Power Automate (Flow)
What were the challenges?
The main challenges of the project were:
1. Firstly, BBP was using two systems. One was Microsoft Dynamics 365 CRM for managing day-to-day cooperation with their clients. Secondly, there was a third-party online assessment tool for providing sustainability assessments to their business members. The assessment software used by BBP was a tool that generated fully personalized feedback for developing engagement. However this software didn’t have any link to the BBP’s CRM, so the staff had to enter each assessment into the CRM manually. As a result, This could trigger some issues including:
- Time-consuming process
- High possibility of human error
- Low efficiency of the process
2. Meanwhile, another challenge regarding the CRM was that in the process of data transferring, some information were missing due to the lack of proper fields and features in CRM. Therefore, the staff has to manually capture some details.
Thus, BBP asked 365 Digital Consulting for implementing an integration solution and also Dynamics 365 CRM customisation for optimizing their business process.
What solutions did we provide?
First and foremost, the data retrieval of assessment information on a daily basis and storing it into dynamics CRM was the basic phase of this project.
One of the required features was extracting appropriate reports from the collected data which was totally impossible with the previous company’s system.
The first phase of the project consisted of integrating BBP’s CRM and the assessment software.
Our team designed a system by Power Automate, allowing the integration of the assessment software using its REST API and storing the data into the CRM. Once the data was entered in the assessment software and an assessment was completed, the integration solution transferred them into the CRM on daily basis.
Moreover, some customisations were applied to the Microsoft Dynamics 365 CRM Customer Engagement module. Therefore the equivalent sections to the assessment software were built on the CRM.
In addition, by developing some reports, the client had better insight and analysis on their data.
Furthermore, some new features were added to the CRM. These features include manipulating the evaluation results, recalculating the score of each category, re-accreditation process, importing data of previous years, and Mailchimp Integration using API.
What were the final results?
Following the implementation of the integration phase of the Dynamics CRM Customisation and Integration project, the staff could save lots of the data entry time and there was no need for double data entry in the CRM. Also, the accuracy of data has been improved and human errors have been prevented during the process.
Finally, after the second phase of the project, that is to say, CRM Customisation, relevant fields of data input enabled the client to have a flawless database of details for each business they credited. Moreover, various reporting dashboards helped BBP to make a better decision and uncover the value of their data.