Hey friend! Have fun exploring Q&A, but in order to ask your own
questions, comment, or give thumbs up, you need to be logged in to your
Moz Pro account.
You can also earn access by receiving 500
MozPoints
from participating in YouMoz and the Moz Blog!

What is the easiest way to produce a graphical report of keyword performance over the past few months

My client wants to review performance to date and wants a report of key search terms and how much they have improved or declined over the past few months. I know the weekly and monthly reports do this but only since the last report, whereas I need to go back to day 1 and compare performance from then till now.

If I do an export of keyword ranking history, I get a massive Excel file with all the data I need, but turning this into a comparative graph seems like a huge task. Is there an easy way to do this either within seomoz or in another program?

1 Response

Thanks for writing in with a great question. Unfortunately, we don't have a way to translate the data in the historical ranking report in our system, but you may consider importing the spreadsheet into Google docs, which has a pretty basic and easy graphing functionality built into it.

Hey friend! Have fun exploring Q&A, but in order to ask your own
questions, comment, or give thumbs up, you need to be logged in to your
Moz Pro account.
You can also earn access by receiving 500
MozPoints
from participating in YouMoz and the Moz Blog!
Learn more.