Hi everyone,

I am a SEO/Social Media Assistant at a company that helps artists market themselves to creatives.
I’ve seen quite a few posts on social media examiner on how to create a plan/strategy and other posts on what we should be tracking, but nothing on how to format a ROI report. For example, if I wanted to create a report that focuses on Twitter, and our goals for right now are to increase followers, and retweets/mentions of certain tweets, is there an easy way to outline this? We’re a small company so we just don’t have the resources to create our own graphics and charts. 
There is so much information for social media people to cover (from each network to each month’s strategies), any tips on how to best format a social media ROI report would be very helpful!
Christine

@danielmckean Thank you for the advice! I do have a few other metrics I plan on including, one being click-throughs. I guess beyond excel, I want to track the types of content that drives the most clicks, retweets, mentions, likes, etc. But you are right about using excel to create a chart that demonstrates this (love how we forget about the simple things!).