I saw a post that Starbucks stopped making a Christmas cup because they didn’t want to offend anyone. So the cup is just RED now. Boring… Anyway, people take to social to either voice they are happy, mad or don’t really care. Here are the analytics.
- 9,796 Tweets harvested and analyzed
- 9,228 unique tweeters, that is a high number with very little retweets
- 18% are happy with the new RED cup
- 21% don’t like just the RED cup
- 61% are neutral, just give me $6.50 peppermint mocha
I used www.PlusOneSocial.com to harvest the tweets and Microsoft Excel to create the sentiment.
Want to create some quick sentiment insights using Microsoft Excel? Download Plus One social harvesting tool. Enter your keywords and harvest your data. Below I’m using a standard for tweeting about stocks.
Once you have your data in Plus One, you can then use our Excel 2013 workbook to refresh your data and create sentiment insights in just minutes! Connect the Bridge database and then go into Excel and Refresh the data.
The workbook has some base charts to get started, but the data is Power Pivot enabled so you can drag and drop your own views.
One of my favorite views is sentiment over time. It maps all the records down to the second and allows you to see a heartbeat of your keywords. Great insights.
Give it a shot!, Patrick
PS. All created with Plus One and Microsoft Excel
That is GoDaddy above at the end of day in regards to their IPO. I’m using Plus One Social to pull on the $GDDY keyword on Twitter as that is what the stock analyst use to comment on stocks. I’m using Microsoft Excel with Power Pivot and a special sentiment function I created. It works great!!!!
Etsy ($ETSY) wasn’t any better. It was actually worse… Makes you wonder about companies going IPO and never making a profit…
PS. If you want to do this, visit PlusOneSocial.com and use the Excel Analyst Pack.