said 11 months, 3 weeks ago:
@christinetandrews What you are describing is more in line with simple metrics and not necessarily ROI. If you are limited to creating charts and graphics, Excel can automatically produce the charts for you if you plug in the appropriate values.
You’ll need to have a base measurement to cross compare your numbers as you go forward. Then once you have those numbers, you can see how well you are doing in periodic time cycles for however you define, e.g., weekly, etc.
Your metrics are very basic. You may want to include click-throughs using a bit.ly strategy as one additional metric if you are trying to drive traffic to a destination.
My advice from the situation you explained, don’t over complicate the reporting. Track and compare the numbers to measure influence whether its simply in a matrix format or supplemented with graphs and charts. In either case, Excel can easily do this.
…and you can always add additional value to the reporting with brief explanations and analysis of the events transpiring.