Sentiment on @Starbucks Red Cup Christmas issues using PlusOneSocial.com and @MSExcel

image

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

image

I used www.PlusOneSocial.com to harvest the tweets and Microsoft Excel to create the sentiment.

Enjoy, Patrick

Creating your own sentiment insights with @PlusOneSocial and @MSExcel on $YELP

yelp

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. 

image

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.

image

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.

image

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.

yelp2

Give it a shot!, Patrick

PS.  All created with Plus One and Microsoft Excel

What’s the social sentiment on Godaddy and Etsy IPO? Not Good… @plusonesocial #viz

Capture

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!!!!

Capture

Etsy ($ETSY) wasn’t any better.  It was actually worse…  Makes you wonder about companies going IPO and never making a profit…

Enjoy, Patrick

PS.  If you want to do this, visit PlusOneSocial.com and use the Excel Analyst Pack.