As part of my first week here I’ve been doing some pretty intensive training, covering all aspects of Brandwatch. Including getting into the nitty gritty and complexities of creating query strings which I found really interesting (yes, I am a bit of a geek). But with so many operators so much is possible; the challenge is just working out what you want to track.
We found time between training session to catch up with James, who finally made it back from Chirp, the twitter developers conference in San Francisco. He was many days late due to the Eyjafjallajokull volcano (some people will use any excuse.) We may have let him off but we certainly didn’t give him much pity after his run ins with celebs, free stop overs in New York and Boston and the fact that he is now the proud owner of an iPad. Like I said, I am a bit of a geek and I seem to be fitting in very well here, as I joined in the general ooohing and aaahing over the Apple’s latest and greatest gadget. And it was good to discover that Brandwatch 4.0 works really well on an iPad (I’ve already suggested we get them for demos).
After getting on with some more serious work, Seb got asked if we could track just retweets about a topic on Twitter. We decided to try it on Vodafone, who plan to sell the iPad, and, after a little bit of head scratching and beard stroking, we realised it was actually very simple to do, by using the operators ‘site:’ and ‘raw:’. In a short time Seb created a query, which tracks RTs (retweets) on twitter which mention Vodafone, just to test this theory out.
When we looked at the data we found a few interesting things, firstly when we looked at the content of tweets we could see that the iPad really was the big story, with Orange and O2 also showing up as they are also going to be offering the iPad in the UK, see the below word cloud for the full data:
Word cloud of content of Retweets on twitter that mention Vodafone
But then we thought “wouldn’t it be good to be able to know who is being retweeted the most?” and with a little bit more time and some more head scratching and beard stroking, we worked out how to do this too. With a quick data download and some simple cutting up of the data in Excel we came up with a table that showed exactly that. The below table shows that data and the interesting thing was that although many of Vodafone’s own twitter accounts ranked highly it was in fact IntoMobile that got the most retweets, 19 in total.
Word cloud based on volume of retweets about Vodafone
If anyone is interested in how we did this or would like help to do something like this for your own brand or query then let us know. I look forward to posting up some more of these Brandwatch titbits over the coming months.
Analysing Vodafone Retweets
April 28th, 2010. Posted by Seth BallAs part of my first week here I’ve been doing some pretty intensive training, covering all aspects of Brandwatch. Including getting into the nitty gritty and complexities of creating query strings which I found really interesting (yes, I am a bit of a geek). But with so many operators so much is possible; the challenge is just working out what you want to track.
We found time between training session to catch up with James, who finally made it back from Chirp, the twitter developers conference in San Francisco. He was many days late due to the Eyjafjallajokull volcano (some people will use any excuse.) We may have let him off but we certainly didn’t give him much pity after his run ins with celebs, free stop overs in New York and Boston and the fact that he is now the proud owner of an iPad. Like I said, I am a bit of a geek and I seem to be fitting in very well here, as I joined in the general ooohing and aaahing over the Apple’s latest and greatest gadget. And it was good to discover that Brandwatch 4.0 works really well on an iPad (I’ve already suggested we get them for demos).
After getting on with some more serious work, Seb got asked if we could track just retweets about a topic on Twitter. We decided to try it on Vodafone, who plan to sell the iPad, and, after a little bit of head scratching and beard stroking, we realised it was actually very simple to do, by using the operators ‘site:’ and ‘raw:’. In a short time Seb created a query, which tracks RTs (retweets) on twitter which mention Vodafone, just to test this theory out.
When we looked at the data we found a few interesting things, firstly when we looked at the content of tweets we could see that the iPad really was the big story, with Orange and O2 also showing up as they are also going to be offering the iPad in the UK, see the below word cloud for the full data:
Word cloud of content of Retweets on twitter that mention Vodafone
But then we thought “wouldn’t it be good to be able to know who is being retweeted the most?” and with a little bit more time and some more head scratching and beard stroking, we worked out how to do this too. With a quick data download and some simple cutting up of the data in Excel we came up with a table that showed exactly that. The below table shows that data and the interesting thing was that although many of Vodafone’s own twitter accounts ranked highly it was in fact IntoMobile that got the most retweets, 19 in total.
Word cloud based on volume of retweets about Vodafone
If anyone is interested in how we did this or would like help to do something like this for your own brand or query then let us know. I look forward to posting up some more of these Brandwatch titbits over the coming months.