Social Media: Back to Spreadsheets

It’s a dirty word right now – spreadsheets.  IT departments want to remove our dependence on spreadsheets and convert us over to a secure, controlled, shared, and robust analytic environment.  I would love that!  But, I have a problem, social media.

I’m managing more properties and content that is outside the realm of my corporate environment but I still have to report back and show how it is doing.  The only way I can do this is by using several analytic tools across multiple properties.  I grab the stats I need and punch that into a spreadsheet.  Then, I go to my web analytics reports, grab those stats, and consolidate them with my social media data on my spreadsheet. After that, I consolidate my lead metrics with my internet metrics for a 360° view of my marketing efforts.

It is all very time consuming and open to data entry error.

Business Intelligence is great to track internal process, but it is doing nothing to help track activities outside the corporate environment.  So, I’m stuck with spreadsheets.  Can you help?

It’s a dirty word right now – spreadsheets.  IT departments want to remove our dependence on spreadsheets and convert us over to a secure, controlled, shared, and robust analytic environment.  I would love that!  But, I have a problem, social media.

I’m managing more properties and content that is outside the realm of my corporate environment but I still have to report back and show how it is doing.  The only way I can do this is by using several analytic tools across multiple properties.  I grab the stats I need and punch that into a spreadsheet.  Then, I go to my web analytics reports, grab those stats, and consolidate them with my social media data on my spreadsheet. After that, I consolidate my lead metrics with my internet metrics for a 360° view of my marketing efforts.

It is all very time consuming and open to data entry error.

Business Intelligence is great to track internal process, but it is doing nothing to help track activities outside the corporate environment.  So, I’m stuck with spreadsheets.  Can you help?