Data Integration

The Social CRM will expore how companies can capture and manage social media data. Including ways to integrate social media into; sales, marketing, research and strategy-making processes. Richard Sedley, Commercial Director at Foviance, will be presenting at this Social Media CRM Conference held in both London and New York

Areas of the day will cover

• The latest tools and techniques for implementing a successful SCRM strategy
• How companies are capturing and managing social media data
• Challenges of implementing social CRM
• Mapping your CRM system to the customer journey
• How social media can data be stored and managed between teams

The Social CRM will expore how companies can capture and manage social media data, including ways to  integrate social media into sales, marketing, research and strategy-making processes. Richard Sedley, Commercial Director at Foviance, will be presenting at this Social Media CRM Conference held in both London and New York

Areas of the day will cover

• The latest tools and techniques for implementing a successful SCRM strategy
• How companies are capturing and managing social media data
• Challenges of implementing social CRM
• Mapping your CRM system to the customer journey
• How social media can data be stored and managed between teams

This article, written by Neil Mason, was originally published on Clickz.com and is republished here with permission.

Despite the tough trading conditions a trend that I have observed here in the UK and I expect, is that organisations are continuing to build out their web analytics capabilities and grow their teams. A number of clients I work with are looking to bring on new people and the job market for web analysts remains reasonable healthy. In some cases this means that companies are looking to appoint their first person into a new role, but increasingly some organisations are looking to to expand the team to 2, 3 or more people. Read more…

This article, written by Neil Mason, was originally published on Clickz.com and is republished here with permission.

Maturity models seem to be all the rage these days. These models help organisations to identify where they are on the roadmap of whatever discipline or capability the model is about and where they need to be. They help to describe the journey to world-class status or best practice. I have been using a simple “maturity model“ for a few years to help organisations identify where they are in terms of their development of their digital marketing optimisation capabilities. I’ve found it a useful device to help people understand the journey they are on and a sense of the ultimate destination. Read more…

 This article, written by Neil Mason, was originally published on Clickz.com and is republished here with permission. 

Last week I was over in San Jose for the Emetrics Marketing Optimisation Summit for three days of input and output on all issues around digital analytics. As usual there was a wide variety of content to absorb and a breadth of issues to discuss. As I sit and write this at the airport on my way home (got to meet those ClickZ deadlines…) I get a chance to reflect on some of the key themes that came out of the conference. Read more…

This article, written by Neil Mason, was originally published on Clickz.com and is republished here with permission.

There is a generally accepted view that an organisation’s multi-channel customers are its best customers. The theory is that if a customer buys from an organisation over more than one channel, for example in the store, from a catalogue and over the web, then they are more likely to be of higher value than if they just purchase through one or two channels. I can see there is a natural inclination to believe that if a customer does business with an organisation over more than one channel that it is probable that the customer has a higher degree of loyalty and hence value. However, the mathematics of the analysis state that a multi-channel customer is also more likely to be of higher value anyway by the simple virtue of having bought more than once rather than necessarily because they bought across different channels. So understanding the value of multi-channel strategies requires a bit more careful consideration than simply looking at the average customer value.

There is another dimension I think as well to evaluating the impact of multi-channels strategies. In the example above the focus is on the result and the channel in which the transaction occurred. From a customer perspective that is fine but to fully understand how multi-channel strategies are working (or not) it’s also important to understand the dynamics between the channel that the customer was acquired in and the channel in which the transaction takes place. This is particularly important for understanding the role of the online channel in driving offline transactions and there are two important ingredients to achieving this. The first important thing is to have the tracking mechanisms in place to be able see multi-channel behaviour. I admit this can be easier said than done. The second important thing is to understand why multi-channel behaviours are happening the way that they are and then to evaluate whether some of these behaviours are desirable or not.

The type of industry an organisation is in and the type of channels it uses to do business will determine the appropriate methods it can use to track multi-channel behaviour. For example, the use of a specific telephone number on the website for the call centre or using source codes or reference numbers to identify customers. Some of these methods will be more accurate and reliable than others but the initial solution to understanding the multi-channel puzzle is to have at least some mechanisms in place to track behaviours.

The next issue is then to understand the behaviours that are being tracked. It’s likely that first challenge will be to integrate the data from the different channels. Data may need to come from web analytics systems, call centre systems, customer databases and so on. Data will need to be cleaned, integrated and then analysed. This may require some different data analysis tools. The type of analysis you need to do will depend on the type of problem you are trying to solve. Let me give you an example based upon work we have done in the travel industry.

A company sells holidays to an older target market. The main channel historically has been telephone sales through a call centre though the web channel now makes up a significant proportion of their business. The website also allows visitors to download a brochure and it also gives the number for the call centre. Although web site traffic is growing steadily, the conversion rate was not increasing. Increased sales were a function of increased traffic.

The company wanted to increase the conversion rate to get more bookings transacted online as opposed to through the more costly call centre.

The website already had its own special number for the call centre so the number of calls that originated online could be tracked. The next stage was to understand how many of these calls turned into bookings. In this instance the call centre system didn’t allow bookings to be tracked against specific inbound numbers, so for a period of time call centre operatives receiving “web calls” were asked to track how many of them resulted in a sale. In this way a conversion rate could be calculated.

The other aspect was to understand what happened when people ordered a brochure from the website. The approach here was to match the names and addresses of people who had ordered the brochure online and to cross-reference them against bookings received in subsequent months and to look at what channel they had booked through. Although perhaps not perfect it seemed to be good enough. From this analysis we could determine how many of those people who had ordered a brochure online had subsequently booked and which channel they had used to make the booking (via the call centre or via the website).

This analysis allowed us to do two things. First of all we were able to estimate the total value being delivered to the organisation. This was not just the value of the online bookings but also the value of the bookings that came through to the call centre on the special website number and even those who had ordered a brochure from the website and had subsequently booked via the normal call centre number. In this case a significant proportion of the internet channel’s total value to the organisation came from its delivery of business into the offline channels and highlighted that the way that the organisation had been historically measuring the value had been underestimating the true Return on Investment.

The second thing that the analysis allowed us to do was to explore the dynamics of the interaction between the online and offline channels and to understand why some of these behaviours were happening. I’ll go into that in more detail next time. Till then…

This article, written by Neil Mason, was originally published on Clickz.com and is republished here with permission.

A few weeks ago I took stock of the web analytics market, particularly looking at some of the key trends in Europe. This week to get a sense check from the position of someone in the US, I turn to a fellow WAA Board Director and friend Avinash Kaushik. Avinash is also an Author and one of the leading thinkers about web analytics and where it’s heading, having actually “been there and done it” previously at Intuit software.

This is what Avinash had to say.

Avinash, you had a busy year in 2007. What were some of the highlights for you?

It has indeed been a hectic year, becoming an Independent Consultant and Analytics Evangelist role at Google and publishing Web Analytics: An Hour A Day in June. Along they way speaking at conferences and running around the country became normal! Oh then there is the blog, Occam’s Razor, my baby (!), that took more time than I could ever have imagined.

I think the biggest professional highlight has to be the book. In five months sales have vastly exceeded my expectations. Since all of my proceeds go to charity (The Smile Train, Doctors Without Borders) it has meant a nice amount raised for them.

The book is a great primer and reference document for all things “web analytics”. But in this fast moving industry, isn’t it a risk writing a book? Are there some parts of the book that you think you might have to rewrite soon?

The core of the book I think will stand the test of time (and by that I mean five years at most! ). But there are many sections I would update. The book has been out only five months but I would add new things to the SEO section. Ditto for blogging metrics, I have slightly changed two of the six in the book and added a brand new one. I touch on Social Media but when I write the next version of the book I think things will be more settled and I can add more interesting things.

New tools will come with time, as will new sources of data and my book, or and those of others, will accommodate for that. But the biggest goal of Web Analytics: An Hour A Day is to teach you a new way of thinking, that I think will be relevant for quite some time to come.

All that said Willem from Wiley was over the other day asking me to start work on the next version!!

What do you consider to be some of the key industry developments to have been in 2007?

I get the distinct feeling that we will look back at 2007 and remember it as a turning point, a good one, for the industry.

Why is that?

Every site in the world seems to have Google Analytics – a leading indicator that even the most common person with tangential interest in data now has access to a great web analytics application. More interest translates into more mind share.

The industry has consolidated quite a bit. Omniture has built on top of its already impressive growth by acquiring Visual Science (/WebSideStory / HBX), in addition to Instadia (Analytics + Surveys), TouchClarity (Behaviour Targeting) and Offermatica (Multivariate Testing). This year all roads seemed to lead to Salt Lake City!

WebTrends is going through some temporary management turmoil, but with its excellent set of solutions I expect them to come back strong.

There were more web analytics consultancies launched, more than on you can count. Ditto for web analytics conferences. Actually a real interesting trend was how many non-analytics conferences had “web analytics day” or “web analytics pre-intensives” – a real sign of growing demands.

It was also a year of Web Analytics 2.0. An expansion of the core definition of what web analytics is, stretching is beyond just clickstream to include qualitative research, testing, competitive intelligence, multiple dimensions of outcomes etc.

So what are some of the key drivers?

Many, if not all, of the trends above were driven by a singular phenomenon: The web is becoming serious business.

It seems odd to say this in 2008 but in many companies web, and web analytics, have been a silo that someone else is taking care of. Websites are becoming the most important customer touch point and the most important revenue generator even for businesses that are not first of mind.

The consolidation in the industry, the increase in interest (tools or conferences) and expansion of the definition is a reaction to the demands now being placed driven by a desire to move beyond printing reports (to perhaps printing money!).

How would you assess where the web analytics industry is at the moment from the point of view of software vendors?

Full of opportunity.

Money and fame awaits all. Well at least those who are willing to work hard.

The vendors have done well thus far, mostly, but they are still scratching the surface of what is possible. Many big websites still don’t use web analytics. There are many growth opportunities in the Software market (aside from the current favourite child: hosted). We are not even scratching the surface of integration with data from other parts of the company and other tools should we decide that web analytics is not a silo but a part of “Business Analytics”? So there is a lot to do and appropriate financial rewards for companies that help accelerate the move beyond clickstream.

What about the people side, i.e. the end users and consultants?

There is a read dearth of skilled practitioners in our industry. And that has stunted the amount of progress that can be made (because the 10/90 rule still applies – spend $10 on software/services and $90 on people who can actually analyze data and produce insights). If you are a skilled person, you can name your own salary (but make sure you are on the web analytics 2.0 continuum and not 1.0), and if you are someone who wants a great Analytics career then now you know where to find it.

Consultants will thrive in any field where the rule is 10/90, because they can bring their expertise to bear on the $90 part of the equation. Additionally because of increase in the demand you are noticing many more consultancies (mom and pop and grandpa included), and an interest from the “big boys” for mature web analytics consultancies (example: our good friends Zaaz acquired by WPP). To make optimal amounts of money Consultancies, like other companies, are finding that they can’t be a one trick “let me parse your log files” pony. They are being forced to evolve into areas such as multivariate testing, competitive intelligence, usability etc.

What are some of the key trends that you see at moment? Where’s the market going?

The problem with Web Analytics 1.0 is that it is an exercise in data torture and reporting with long lags in taking action (if any). Data torture needs to get automated and expanded, decision making needs to get automated; people need to be left for smart hard things (vs. what happens today!). Smart companies will start to exploit more things like Multivariate Testing, Onsite Behaviour Targeting etc because in each case you are leaving humans to understand customers and create content and you are letting intelligent solutions create the right customer experience based on data. Won’t happen overnight, but are on this train for good.

I also believe that 2008 will see a more serious attempt to get Web Analytics to become a part of “Business Analytics”. We are still a silo in most companies (data and people!). We will see more collaboration and innovation in helping web data become a core part of the company data to truly give end to end visibility (and maybe the holy grail of multi channel analytics / impact). Won’t happen all in 2008, but we might get serious.

I am optimistic that we don’t have untouchable islands of data like we do today. Search Engine Optimization, RSS, Social Media, etc. They are all becoming mainstream yet the current generation of tools mostly stink at tracking them. You can track them, but if you are willing to row your leaky boat all by yourself to that island. I think this will change.

Oh and we are not done with consolidation in the industry.

It’s going to be fun!

I reckon so, thanks Avinash

This post originally appeared in Applied Insights’ events section. Foviance acquired Applied Insights in November 2008, with Neil Mason joining us as Director of Analytical Consulting. As part of this acquisition, we’ve incorporated Applied Insights’ events list into our own.

At this inaugural event in Sweden Neil presented on data integration.