Mar 15 Posted 3 years ago
Taking your comment about MS Access/Excel on setup further and it might be obvious. Use macro's and/or queries to manipulate data sets and into actional reports that you can provide clients directly. Downloads of csv's and then databases that churn high qualities of data against KPI can be really really revealing. In many cases unless were looking at data at a granual level we will "miss" it in dashboard reports. For example a 60 point increase and a 50 point decrease only equate to a 10 point moment at the top line, but can be very very very important to see somewhere. Thanks for the write-up Barry! @dock29
Mar 11 Posted 3 years ago
Thanks for the input Evelyn.
I'm going to answer from an enterprise perspective: I believe the biggest criteria for my own dashboard projects are my 'secret sauce' business indicators. Most existing social dashboards focus on increasing followers, a bit of engagement, or a sales/e-commerce conversion.
These are all nice for different reasons... but the biggest ROI for most businesses hides in some high level partnership such as enterprise sales or within a cost efficiency to something they are doing. These larger business drivers are usually closely held strategies and most mid-management personnel don't have a real idea around where the next million or billion dollar strategic goal is.
If you look at 99% of the current social media dashboard market, you can quickly see that they are designed to address fairly simple marketing/PR scenarios and have almost no value add to convincing exeutive leadership to focus on the initiatives that really matter.
If you haven't integrated your social media dashbaords with elements you mentioned (market trends, demographics, economic conditions, etc), then you are probably looking at an entirely faulty set of measurements.
Mar 10 Posted 3 years ago
Barry, your post made me miss Excel pivot table.
It is a matter of micro vs. macro, and I still think the data social media monitoring tools capture is somewhat micro.
It is important to know how customer talk about your brand, but social media doesn't have a way to predict what is going to happen based on millions of things, i.e market trneds, economy...etc. I want to know if you were to create your own dashboard, what criteria will you be looking at to make your social data more practical.
Great post by the way, enjoy reading it.
Mar 10 Posted 3 years ago
Thanks for sharing your thoughts and tools. I think we all like to hear what the other person is using. Wish there was an all in one mega version for social media. Always too many windows open. Good article.
February 09, 2016An exclusive, live webinar from Social Media Today on Tuesday, February 9th at 12pm ET/9am PT. Social media has given brands the great gift of...
January 19, 2016An exclusive, live webinar from Social Media Today January 19th, 2016 at 12pm EST / 9am PST There is a fine line between an omni-channel market...
November 24, 2015An exclusive report brought to you by Social Media Today and Hinge These days, cutting edge companies know that if they aren't leveraging t...
November 23, 2015The 2016 Social Media Marketing planning guide includes a must-have checklist as well as a first-of-its-kind research study aiming to provid...