Traffic, rankings and own manual note in one interface, please :)

[VinceWicks]

Hey guys, I really hope that such a tool exists out there. Here's the problem. My boss asked me to create a graph that shows the traffic, rankings and notes on our site updates in one place.

Here's what I did

I just made a screenshot of my Google analytics and rankings from RankTracker. Then I added it all in one Photoshop file and tried to combine them so that I can see if traffic drops coincided with keyword drops. Also, I added some manual notes about the updates on my site (like text updates on the homepage, etc).

So, is there a tool that allows to combine Google traffic data with ranking data. Plus it should allow to add my own comments ?

Here's the result of my crazy drawings so that you understand why I'm not happy about doing that in Photoshop

https://docs.google.com/file/d/0B_oX-XIT7OSCRC1jWUcxR3AwdkE/edit?usp=drive_web

[MikeTek]

Hi Vince,

If there is such a tool, I haven't seen it.

Chris's suggestion to export/import csv files into Excel and combine there would probably be where I'd start, but I'm not sure how easy it'd be to work with the annotations in Excel. There's a Greasemonkey (Firefox) script to export them, but I haven't used this myself so I can't confirm how smoothly it works.

Mash-ups of multiple metrics on a single chart like this I rarely find to be helpful, as they become visually confusing quickly - but if this is exactly what your boss is looking for, you're probably going to end up creating something in Excel and replacing the data each time (but saving the visualization settings). You could also hack together a macro to handle the repeating and tedious tasks.

Sorry I don't have a better/shorter/easier answer for you here. If you do find or build a solution that is robust and/or elegant, I hope you'll head over to YOUmoz and share it with the community.

Best of Luck,
Mike

[GPainter]

Couldn't you export a .csv from both then create a graph in excel ? All though its more manual I'd said you get a bit more control.

Moz does some nice reports that export too what about those reports?