Our Blog

where we write about the things we love

17

Feb

Bringing the data to life – four important lessons

We have a client who has been using Microsoft Dynamics CRM for just over a year. They added marketing add-on ClickDimensions to the mix some months later and now have a real set of rich data with which to work. The customer records are updated nightly through a process from a data warehouse and CRM is the mechanism for marketing and outbound communications.

Many companies talk about mining their data and have lofty ideas about what they want to do, and these are often tabulated and postulated about before a new system is implemented, but the reality of the data and the perceived marketing ideals do not really converge.

As I have found with this client, learning about the data as the system evolves is how great marketing ideas come about and the requirements become more identifiable. I have watched this data come alive and have seen how, with filtering and intuitive understanding, more and more effective marketing comes about.

The key lesson here is that during the analysis phase it should be generally understood that data mining and analysis are going to be important and the data model incorporated into CRM must be correctly designed; however presumptions about what you perceive will be the results should be avoided. It is not a light switch and it is unlikely that on day one there will be a large data revelation.

Our client is still learning; they understand that. They know that they don’t know everything there is to know about their data. ClickDimensions adds a whole new perspective to the data analytics; and with web capturing, which we recently added, even more interesting data stories are beginning to unfold. There is no long list of things that are wanted; it is now much more spontaneous, and with each iteration and Advanced Find query saved, more and more understanding is added to the overall model. It’s an iterative building and learning process.

In effect they are bringing the data to life little by little, and when I am asked to assist and I see what is starting to happen, I can see the beginnings of the data taking on a life of its own. Their marketing model is all about customer retention and regular interaction which lends itself to this type of analytical systems approach.

Four important lessons:

1. Good data is probably the first and most important element.

The core transactional data coming from the business systems via the data warehouse feed in this instance keeps the integrity of the data on a very sound footing. The understanding of the relationships between certain elements of the data within the customer record becomes pivotal to the analytics.

2. Constantly review your data and campaigns.

The customer found that the subsequent marketing data related to outbound campaigns and the resultant activities and further incoming data based on these campaigns all correlated, making for a full picture about how a specific customer was affected by an individual marketing campaign. When aggregated, segmented and analysed it showed trends that they did not perceive would be possible when starting out.

3. Make use of visual data.

They have also been using CRM dashboards to visualise the data. This, too, has been an evolving process and certainly was not defined up front. Dynamic exports of views and pivot tables to Excel can also be very effective.

4. Have the right people doing this work.

I also believe that the people doing this type of work need to be marketers, not pure data analysts. They need an affinity for the business, an understanding of their industry and the intuition to bring this all together. Once they have a good system we can teach them how to get the most from their data within the system, and from that point forward it is a growing and learning experience.

And the key to success is?

Start small, be pedantic about the quality of your data, record results and try and understand what they mean. Build on each step and I am sure in time you too will also start seeing your data coming alive.

This post first appeared on Ivor’s personal blog here.

Posted by: Ivor Whibley, CRM Consultant | 17 February 2014

Tags: Data, Data Accuracy, Data management, design


Blog archive

Stay up to date with all insights from the Intergen blog