Intelligent Word Mapping and the Wonder Wheel for Organic Search and Social Media Monitoring

So many things going on for me that it’s sometimes hard to focus – often I look “outside” to see what is going on in Social Media that’s interesting ( my Web Journals); other times, like this one, I feel the need to touch the data personally in a different way – that’s the substance of this blog – touching the data and look at it differently (hopefully, than anyone else does).

If you read this post all the way through I promise you’ll get methods you can use to improve the information your gathering from Social Media Monitoring and Organic Search (but you don’t have to stop there, Site Search would work just as well under this model, etc).

Note: I haven’t worked close enough with Text Analytics platforms like Lexalytics and Clarabridge - it’s possible they might supply aspects of this functionality – just to be sure – check them out in case they do offer it (though I doubt they offer it in the way I’m presenting it here).

I started with my own Organic Search Traffic from Google this month (you can download the entire spreadsheet here).  My Search traffic now comprises 40% of all the traffic to and seems to be going up more and more – almost all of it is “long tail” – and how does one make sense of it?

Along with the Search Query I sorted by City as the secondary dimension and the report became a lot more usable to me all of a sudden.  It’s as if, by sorting by city, I could not see a pattern in the information that wasn’t as clear before – and it became the takeoff for this long, and I hope, rewarding post for you to read.

Here’s a chart I created around two subjects I found in my search logs – Restaurants and Social Media.  I could have picked far more – could have spent days on this – but that’s not the point – the point is to evolve a way of working with data – if you want to spend days working your data – or mine, be my guest.

As I looked at my own search logs for this month – I saw patterns (the artist in me) – it’s as if the data was speaking to me – people were asking about weather there was a net promoter score for restaurants, or if I was doing any more comparisons between social monitoring platforms, or even if I had a quick and easy Social Media Scorecard to share.

I saw patterns, such as Social Media + “how to”  and Social Media + ROI, etc.  Sure, there were only a few people asking those questions (in some cases, they spent hours on my blog looking for the answers, just look at the excel spreadsheet in full and you’ll see the most engaged reader was looking for (based ib time spent in a single session).

As I pulled this data it looked strangely familiar – no I’m not speaking about Radian6 Word Maps (they are limited by a single word and are not capable of what I did in my first slide – grouping by concept – at least, not with considerable amount of tagging – something most people don’t want to deal with).   Rather, I’m speaking of Google’s own Wonder Wheel.

Speaking for myself only, the Wonder Wheel is a “Wonderful Experiment” or Tool created by Google Engineers to create some sort of order out of searches that people are making on Google – it’s also there to help give you ideas when you want to come up with keywords for ads you might want to run in AdWords.     But the Wonder Wheel doesn’t work with your own data - unless Google, or someone else, were to adapt it and use it to process Search Query Referral Traffic, Site Search Queries (when site search is being used on a site) and SOCIAL MEDIA MONITORING platforms like Radian6, Sysomos, BrandWatch, etc, at el.

The Wonder Wheel makes sense, in other words if you want to operate on other peoples data - but not much help if you want to understand your own – if your monitoring your own logs, if your running your own query in Radian6, if your pulling your own data – if your a brand and you want to know what people said about you when they visited your properties – nothing like the Wonder Wheel exists at the very moment, that I know off, offhand, for your own data.

That’s the data you care about the most – your own – not Google’s.

I suppose Google could have used the Wonder Wheel with Google Analytics and Google WebMasterTools – after all – it’s all their platforms – we absolutely know Google haven’t used the Wonder Wheel technology at all for Google Analytics – but did they use it for WebMasterTools?   No, they didn’t – but there is useful information – just not the semantic breakdown I’m talking about today.

Undoubtedly , the Wonder Wheel would be very useful in Google Analytics but it’s also fair to point out that such analysis is left out of every web analytics tools I’ve ever used – none of them have that information nor were they built for it.    So while I could see the benefit of Google adding Wonder Wheel to Google Analytics, I’m not sure they ever would – and as far as Web Master Tools – they certainly could add it – if they wanted to – and it would make a lot of sense if they did.

Using a “Wonder Wheel” for Social Media Monitoring

What if he had something like the Wonder Wheel for Social Media Monitoring? – How much better do you think the intelligence would be?    Again, you might think Lexalytics or Clarabridge, if you upload your monitoring data to those platforms – but I don’t think they’re going exactly the same place I’m going with this).

Besides, many of the monitoring platforms already use Lexalytics on their backend for sentiment analysis scoring and aren’t providing anything like what I’m focusing on today - so why would Lexalytics provide it on their own?  Wouldn’t these platforms have done it already if it was so easy for them?

I just happen to have handy a downloaded log of Havana Central’s interactions from Radian6 on hand for the first half of this month to use as a test(see  Aug 1-15th all).  As mentioned before, I’m working with the this restaurant chain and have done a case study on them – as well as set up monitors and alerts on some of their competitors -the very same thing I suggested Roger Smith Hotel try, recently……

though the action we take from alerts is open to debate - while we should monitor competitors – I know we have to be very careful how we actually engage with them – Brian Solis has that pegged down better than I do and perhaps I ought to read his book so I understand the full implications of monitoring being set up and how you’d use it to engage with your customers – or just listen, if that’s all want to do.

The first thing I’d do is sort by content alphabetically – to try to simulate the Wonder Wheel type of map that Radian6 can’t today provide (see below- but who knows,  in the future – maybe they’ll read this post and add it as a feature next year sometime, along with additional interesting technologies I know they’re working on merging).

You can certainly click on the words you care about like “Havana”- but there’s no real semantic grouping – nothing that does what I put out as my first slide in this post.  Wonder Wheel could eat up Radian6’s logs, digest them and give you something that actually helps you answer what people are looking for or saying.

Could have gone a bit deeper but there wasn’t that much really to summarize here – and honestly – the messaging is more uni-directional than bi-directional – which is what you need it to be for effective Social Media Outreach.

If the Wonder Wheel type technology had a crack at these logs you could click on them and it would keep bringing up more information – except the information would be coming from your data – not what Google wants you to create ads for, or what others on Google searched for – but instead, what you need to understand about the people who are coming to you asking questions –  questions we all should be answering.

And with that – my next post will attempt to answer  a few questions my readers have asked me – based on this post and my own data from Google Analytics.

Enhanced by Zemanta

3 thoughts on “Intelligent Word Mapping and the Wonder Wheel for Organic Search and Social Media Monitoring”

  1. Morning Marshall,

    Your wonderwheel sounds a bit like our “key conversations” tool, where we take your key search terms and then link it to words and sentences that it’s being used in conjunction with.
    I’m just wondering if you’ve seen it? We have it ion both our MAP and Heartbeat products. It may be something you want to check out.


    Sheldon, community manager for Sysomos

  2. Hey there!

    I did just submit your idea as a feature request. Thanks for the feedback, Marshall!

    Also – I’m curious… are the conversations happening around Havana Central what you expect to see, or is there a discrepancy between what conversaions you expected to see and what conversations are actually happening?

    Community Manager | Radian6

  3. Hi Marshall,

    thanks for mentioning us. While we don’t have the graphic “wonder wheel” you’re referring to here, we do allow users to look for linguistic connections between words and can do groupings based on those linguistic connections. You could create a category in your category model based on particular concepts you’re looking for, say mentions of social media, then see what words are linguistically connected to that concept. Additionally, you can look at the sentiment that is associated with those posts based on an 11 point scale.

    I should also clarify that when I say linguistic connections, unlike some systems that parse sentences into concepts and look for linguistic connections based on proximity (literally physical closeness of one word to another to determine the connection) we do full natural language processing (NLP) syntax parsing of the sentence to determine the linguistic connection more accurately.

    Additionally, while you might want to create your own category model to “bucket” the data (organize it) for you, you could also use some of the clustering algorithms to simply go through the data and see what groupings occur based on linguistic connections. And, you can take that even further and use machine learning to further “train” your model over time. Perhaps overkill for what you’re doing, but we do have a self-service offering you can try out for free for a limited time at


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>