Traffic, rankings and own manual note in one interface, please :)
-
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
-
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 -
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?
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Difference between Organic and Natural Traffic?
This is a pretty basic question, but I'm wondering if there is any meaningful difference between the terms Organic and Natural traffic? My assumption is that Organic traffic refers to traffic that comes in through search engines, whereas Natural traffic would also include people directly entering a URL, coming in through social referrals, and through links on other sites in addition to organic search. Is this correct, or are there other definitions for what these terms mean?
Industry News | | ShawnHerrick0 -
About Ranking
I have a question regarding keywords and ranking I am running a campaign using "Conference venues Park Lane" as one of the keyword. I am already in first place google with that keywords but not the the right landing page. How can I fix that. Google is sending to the wedding landing page and not the conference one. Any idea?
Industry News | | lnietob0 -
Help ranking for a keyword
So I found a keyword that is labeled as "Low Competive" on Google Adwords. About a week and a half ago I optimized the page using the SEOMOZ On-Page optimization tool. It says that I am 100% with everything. My website is new but it has been around for about a year. I haven't gotten into linking and the more in depth SEO. After doing some searches though I noticed a lot of other new website that are atleast ranking in the top 50 for certain keywords, so I figured I could get my page to rank atleast in the top 1000 for this "Low Competitive" keyword. Could someone take a look and see if maybe I over optimized it or did something that would make this keyword not rank even in the top 1000 on google? Any advise is appreciated. I am obviously very new to SEO, but I am someone that likes to do and learn everything for myself. Thanks in advance! The keyword is: Nitro Monster Truck The web page is: http://www.rcnitroshop.com/nitro-monster-truck
Industry News | | bilsonx0 -
SEO Conferences - Which One(s) do you Attend ?
I have been in SEO since over 10 years now. And have been attending Pubcon since 2004 in Las Vegas. I think I have only missed 1. This year, I have been thinking of which conferences to attend and here are the options. I am looking for 1st hand experiences from people who have attended multiple conferences to kinda do a comparison. Here are the upcoming conferences by date. I am only listing the US Conferences. SES New York March 19-23* BlueGlass Los Angeles April 23-24* SMX Advanced Seattle Jun. 5-6* MozCon July 25 - July 27* SES San Francisco August 13-17* SMX New York | Oct. 2-4, 2012* Pubcon Las Vegas October 16 - 19* SES Chicago November 12-16* SMX Social Media Marketing Las Vegas | Dec. 5-6 Please let me know what conferences you have attended in the past and which ones of these people here are planning to attend ?
Industry News | | NakulGoyal1 -
Why has my places ranking dropped off google?
I've recently worked for a company who up untill 3 weeks ago have shown up in the google places ranked at number 1 for the following key phrases. First Aid Training in Cornwall
Industry News | | it-ok
First Aid Courses in Cornwall
Health and Safety Training in Cornwall as well as several more... However over the past 3 weeks they have gradually dropped out of the places listing all together, and I'm struggling to understand why this might be. Yesterday I released a new website for them which has had a lot more SEO input in to the site, is this likely to have an affect on the places ranking? the website is www.insafehandstraining.com Any answers would be very appreciated.0 -
Reconsideration Request denied for 3rd time!!! - Could Use Some Fresh Eyes Please?
I have read the FAQs and checked for similar issues: YES
Industry News | | LVH
My site's URL (web address) is:http://www.recoveryconnection.org/
Description (including timeline of any changes made):n mid-June, we were penalized. We received a message in WMT that our site was penalized for Doorway Pages, thin content, and pages trying to rank for just 1 KW. 1. We removed all doorway-style pages (according to guidelines) and consolidated content to target no less than 3 KWs per page, and not over-optimized.
2. Submitted first reconsideration request.
3. Denied 8 days later via MSG in WMT that stated simply that the site still did not meet Google's Guidelines.
4. Printed fresh copies of Google's guidelines, and rewrote almost every page of the site. We took down the blog in case of old thin content or possible doorway pages. We reduced the overall size of the site from over 400 pages down to around 80.
5. Submitted 2nd reconsideration request.
6. Denied 10 days later via MSG in WMT that stated simply that the site STILL did NOT meet Google's Guidelines.
7. Restructured site and it's content.
8. Denied 3rd time. http://www.google.com/support/forum/p/Webmasters/thread?tid=43c09330ab7b25b5&hl=en Note: We have checked our link profile over and over, and we have NO Paid links. We have moved our entire site to a new platform, with clean code, new URL structure, etc. Does anyone have any feedback? Thanks.0 -
Which one is THE BEST seo book
For you guys which one is the best SEO BOOK?? Maybe this one? http://www.amazon.com/Ranking-Number-One-Essential-Results/dp/1452849900/ref=sr_1_4?ie=UTF8&qid=1309247497&sr=8-4 Thanks in advance!
Industry News | | augustos1 -
I'm looking for solid internet usage / traffic data.
Hi there, In a week or two I'll give my first internet marketing presentation to a local business club. Ill walk them through the basics of what is happening online, and how both B2B and B2C business can use their online assets as marketing tools. I want some basic statistical data to back up my story, like: Current web usage distribution (social/search/media etc) Growth of Mobile vs Desktop Search Engines distribution (google bing yahoo msn) Online retail numbers To top it all off, I would also like to be able to show both worldwide and The Netherlands data. What is my best bet for some serious datamining ;)? Thanks in advance for helping me out!
Industry News | | rickdronkers0