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.
September 15, 2015At one point or another, scaling your organization is going to mean automating some part of your process. Because of the demands of data, automa...
August 19, 2015Hear from Chris Kerns, Author of Trendology, about the latest findings from the Spredfast Research team and their series, The Smart Social Repor...
July 07, 2015Social and Mobile Marketing Data Report: Register Below to Receive the Exclusive ReportMarketers: Sold on Social, Still Getting Their Feet W...
May 27, 2015Word-of-mouth marketing has always been a powerful driver of consumer behavior. Every experienced marketer knows that customers are mo...