Jul 2021 | Data Quality |
Microsoft Dynamics 365

For those of us who have been hanging around software systems for a while, the phrase Garbage In, Garbage Out (GIGO) is well acknowledged. We all know that our operational systems, such as Microsoft Dynamics 365, can only deliver on their promises – better marketing conversions, better customer service, maximised sales opportunities and better analysis – if the data is up to scratch.

But in study after study, organisations see negative impacts from poor data quality. A recent Forrester survey found that 68% of companies struggle to create a single view of customers in their CRM system. We have known about GIGO, for so very long, so what is going so very wrong?

CRM Data Strategy

In this post, we outline that, while GIGO is easy to say, it can be difficult to manage, and, in any case, is never the full picture. Here are 7 things that you should consider as part of your CRM data strategy.

  1. Know where you are starting from, then get accounts involved

    A regular data quality health check will tell you how big the problem is and what the right next steps are to go and fix it. A health check will reveal levels of duplicate records, how well your data is structured (you may have the right data, but not necessarily in the right fields) and where the gaps and inconsistencies are.

    Once you have an idea of the health of your data (run on a representative sample of records), you are in a position to size the problem in dollars and cents. For this part, your accounts department can certainly help. They will know how much a returned package costs, how much a courier will charge to correct an address or how much to re-book two skilled engineers out to a missed field service call. If the wrong goods or people were sent to the wrong customers at the wrong place, they should be able to quantify all of that. Just make sure that they think about all stages of the process.

    Before you even think about the cost to reputation, customer churn, or potential lost sales, you will have a great idea as to how urgently the problem needs fixing.

  2. Make sure you are not turning a blind eye to “Garbage In”

    When we think about how data gets into our Dynamics solution, there seems a clear need to provide real-time help: stop the bad happening at the point of committal. Whether your customers are providing data directly via eCommerce, you are receiving data from trusted selling partners, or your representatives are updating records, it is dangerous to assume they will always:

    • Know what they should be entering in each field.
    • Will never typo
    • Understand the various rules that constitute a valid email address
    • Will tell you the truth

    This last part is particularly important. We all love our customers but sometimes they don’t tell us the truth because they don’t want to be bothered (M.Mouse@blahblahblah.com). More seriously, they want to hide who they really are – maybe to get a second bite at an introductory offer, or other, more sinister reasons.

  3. Remember, you don’t know everything

    According to Harvard Business Review, 47% of newly created records will contain at least one critical error. Think about that email address above, is it real? Actually, there’s nothing wrong with the syntax, so it could be. Having the ability to automatically check if is receiving email on a valid domain may tip the balance though in whether you accept it onto your system. Despite all the due diligence on form design, Data Quality is still needed to confirm the email is live.

    Similarly, with addresses. Where is Richmond? Carlton? Brunswick? Did you know there’s also one in Brunswick East? And let’s take this address:

    Level 6 549 St Kilda Road, Melbourne, VIC 3000

    By sight, there is nothing wrong with it. But sending a courier, there is going to incur an unexpected cost – the postcode should be “3004”.

    And maybe you are not delivering goods or services to an address, but a building site. Latitude and longitude coordinates, or other geocode attributes would help.

    In general, accessible trusted reference data in real-time will take human errors out of the equation, ensuring that, at the time of capture, the data is as good as it can be.

    That covers, ‘at the time of capture’. But then what?

  4. Data gets old – Deal with it

    Time, it is said, is a great healer, but not when it comes to your customer data.

    If you believe the data in your Dynamics system is accurate here are some statistics, you might want to consider.

    • Around 1million Australians move house each year
    • 181,133 new homes were built in Australia last year
    • In 2019, 113,815 marriages were registered and 49,116 divorces granted in Australia.
    • Unfortunately, nearly 170K people died

    These ‘slowly changing dimensions’ are eating up the time of our sales reps, marketing budgets and the value of any analysis we attempt from our Dynamics data. According to a study by LeadJen, each year sales departments lose approximately 550 hours and $32,000 per sales rep from using bad data.

    There are a couple of approaches to handling this problem. The first involves the use of in-house data management software which has access to the necessary reference data you need (e.g. Aperture Data Studio). This gives you the flexibility to cleanse data monthly, weekly, or even daily if needs be. Alternatively, a regular cleanse using an outside agency may be suited to smaller data sets.

    This will also help eliminate the build-up of duplicate records over time. Duplicates are hard to eliminate as subtle differences in customer information result in the safety-first approach of entering a new record rather than overwriting an existing one. Again, access to reference sources can help resolve differences and keep your Dynamics implementation lean and meaningful.

    Learn more about Microsoft AppSource

  5. Go global in a quality way

    I’ve talked a lot about Australia here, but if you have customers in other countries then think about how reference sources can be accessed everywhere that you do business. Also, of course, appreciating that things like address and phone standardisation are country specific.

    Your Dynamics system was implemented to be a global solution to manage all your operations, no matter where in the world you set up operations. So why not ensure the system can handle all the various types of customer data that could be thrown into it, like the latitude & longitude of a property, for example, in the UK.

    Experian’s Microsoft Dynamics 365 applications support all the global enrichment datasets, please click here to find out more.

  6. Whatever you do, don’t hardwire it and build it for scale

    If you are a Dynamics user, you may have noticed that Microsoft keeps up a pretty fast pace when it comes to development. Address, phone, and email validation services need to be up-to-date with the latest Power Apps component framework (PCF) to meet Microsoft certification and keep apace of the frequent new versions of Dynamics 365. No-code integrations are far preferable in this instance as the upgrade implications become trivial.

    Also, you have to be aware that these systems are using API calls to web-based services used by thousands of other companies. At times such as Black Friday and Cyber Monday, these services can get pretty busy. You may not be processing thousands of transactions per day like a large retailer – but you are going to be using the same data – make sure the service can cope.

  7. Keep an eye on the end goal

    It has been said that data is the new oil. Let’s refine that statement (and the oil) and state that data is the new fuel.

    This may be the most obvious point, but if the reason you invested in Dynamics 365 is being compromised by the data, then you are obligated to fix it. You have a state-of-the-art engine with the potential to improve your marketing campaigns, give you new upsell opportunities, and better customer and field service operations. You have the functionality to deliver all of these and the added ability to truly understand your customers better, as well as the processes that deliver the best to the bottom line. You have a world-class engine – so it’s better to put world-class fuel in it.

    How Experian can help

    As a certified Microsoft Gold Partner, our global data quality solution integrates seamlessly into Microsoft Dynamics 365 to ensure only accurate addresses, email addresses and phone numbers for your customers and prospects are captured and stored in your Dynamics system.


Contact Us

By providing your personal information you agree that we may collect and process it in accordance with our Privacy Statement.