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.
November 24, 2015An exclusive, live webinar on November 24th at 12pm ET/9am PT Description coming soon.
November 17, 2015An exclusive, live webinar from Social Media Today on Tuesday, November 17th at 12pm ET/9am PT. Description coming soon.
August 26, 2015Summer may be winding down, but there's no stopping the growth of social for today's top businesses. The newest Smart Social Report is out,...
August 20, 2015While 81% of small to medium-sized businesses use social media to establish loyal fans, most struggle to dedicate the time needed to make it...