It is important to adjust your social media after you review your metrics to achieve better results for your business. I will be discussing this will my Halifax social media class on Wednesday. After looking over 7 months of data, I now know where I should be going and what I should be targeting. Have you checked your social media metrics?
Social media metrics using Microsoft Excel PivotTable
After analyzing over 7 months of data in Microsoft Excel, I now have a clearer view of the social media road ahead. I look forward to sharing these insights with my social media class in Halifax Wednesday. Several key things stood out including when to post and what to post. My results were very different from Dan Zarella’s findings. I guess us Maritimers are hard to put into a Zarella mold.
So of the things that I looked at were key times for retweets, mentions, favorites, clicks and overall reach on Twitter. After reviewing the findings, I made the adjustments in my schedules and in my mindset. This exercise was really helpful. I had been previously looking at finding ways to better resonate better with my community. Now I suspect that the measures that I have put in place will increase my resonance rate over time with my community. I trust it will help create more opportunities as well.
What can we learn from my experience? I found my resonance rate decreasing over time. So I decided to look at the social media metrics to see what was going on. Then I adjusted my schedules and strategies. You should look at your metrics and see what you are getting back from your investment of time. After all, it would be a bad thing if you invested all that time and you did not see any improvements.
One thing I would recommend is that you use Microsoft Excel to keep track of how your social media is going. Once the data is in place, you can use a PivotTable to really analyze what is going on. You just might be surprised to see the true results. Go into the process with an open mind and do not exclude any data. Once that data is in Microsoft Excel, you can play with it as you like. The hard part will be getting it into the workbook.
So review your social media metrics from time to time and see how you are doing. Don’t just guess. Analyze your data…. and adjust for better success.
