We recently completed a
- Marketing- Their marketing department was using an Excel spreadsheet that listed all the districts and contacts within those districts and theycreated detailed notes in the Excel file during every call they made. The problem with this was that no other department could see these notes. The marketing department also ran into a few instances where there had been previous contact made, but they didn’t have insight into what those conversations touched on. They had to start at “phase one” every time they reached out to new prospects and/or existing districts.
- Contracts- The contracting department had to keep close track of what contracts they had sent out to what districts as well as what date the contract went out and what date it came back in. By tracking this in a spreadsheet, follow up was tedious and often confusing. It really limited them from a growth standpoint.
- Billing and Invoicing- They did invoicing in another system, but it didn’t provide a lot of functionality that they needed; so they added another Excel spreadsheet to the mix of information that included what district had been invoiced, and whether that payment had gone through or not. This information was never real-time, therefore skewing the financial information they had insight to.
- Events- Once our client gets approved in each state they are required to go through mandatory meetings to continue serving that particular district. These meetings were another thing they had to track closely so as to meet each district’s requirements. This required yet another spreadsheet tracked separately from all the rest.
As you can imagine, this many spreadsheets within a company can cause major confusion. Each spreadsheet was segmented in different ways and made it nearly impossible to compare data in order to capture a true picture of their operation. For example, billing would call district contacts about invoices and also have an overall conversation about how things are going. Then marketing would call the very next day to see how things are going, not realizing they had already spoken to billing the day before. This miscommunication put their customer satisfaction at risk and wasted time within every department.
In addition to keeping track of contact information, district name, address, superintendent, upcoming school information, students in district, as well as how many they can serve inside that district, they also had to keep track of all-up information for each school year. They needed the information in a standardized view so they could easily see where each district stood in terms of services they could offer.
By simply putting all their information into one system, our client is reaping benefits left and right:
- Event Tracking: In their weekly meetings, they can now quickly report on how many events were attended and for which districts. They can also view how many more events are required for a particular school year. Dashboard views help here so they don’t need to conduct manual counts or cross-check multiple documents.
- Streamlined and Effective Marketing: The marketing department is now on the same page as everyone else in the company AND everyone else can see the notes they make while communicating with prospects and existing districts. They can easily keep track of how many phone calls they made on a weekly basis and can also share this information easily in weekly meetings.
- Collaboration Made Possible: Now that everything is recorded in Microsoft Dynamics CRM, they have insight into all departments. Contracting department can see into invoices. Marketing can see into contracts. It has made collaboration possible and growth, limitless.
This is an extreme case of the over utilization of Excel spreadsheets by multiple users within an organization to run the daily operations of their business. Excel wasn’t designed for this, but Microsoft Dynamics CRM was designed to help organizations collaborate and perform at optimum levels. If you feel your company manages one too many spreadsheets, causing confusion instead of helping, contact us at The TM Group to learn how Microsoft Dynamics CRM can help.
Also, we’ll be spotlighting some key add-on solutions for Microsoft Dynamics CRM at our upcoming Microsoft Dynamics Conference called