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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s