Social Analytics using @Google as your business intelligence dashboard #gartnerbi @plusonesocial


Sounds crazy right?  Using Google Apps as your digital marketing dashboard for social analytics.  Well, it is totally possible!   How did I do it?  I started with Plus One to harvest the social data I want to analyze.   Plus One allows me to harvest data based on keywords and it stores that data into a Microsoft Access database.


Then I pulled that data into Google Spreadsheets and created several pivot tables of that data.   I put all the data in one tab and then built several pivots of that data for the types of charts I wanted to create.


Then using that summarized data in your pivot tables, you can build out your individual dashboard components like I did below.  Then I just copied those to the main dashboard page resulting in my social insights.


Pretty slick huh?  You can get started doing this yourself with a FREE version of Plus One and using Google Spreadsheets which is FREE too!  Can’t beat that!

Enjoy, Patrick

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s