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.
May 21, 2015A social campaign is only as good as its results, and turning your data into actionable insights is the first step to a successful campaign. Whe...
May 12, 2015Ever since Time magazine named “you” on YouTube 2006’s person of the year, companies have been working on ways to seamlessly use the people’s pl...
April 24, 2015Pinterest is a critical channel for any e-commerce brand. With over 70 million registered users, it deserves to be a big part of any social...
April 10, 2015With its 271 million monthly active users who produce 500 million tweets per day, it’s getting harder and harder to ignore Twitter as an im...