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
-
Rank high for the term "Software development manager"
I would like to rank high for term like software development manager. How do I get started? I am new at this. I am going to start watching seo moz video tutorials to get some ideas. In the mean time if there are any step by step techniques that would be helpful. Thanks
Industry News | | zsyed0 -
Please critique my seo packages page on my website
Hello, I think there is a lot of room for improvement to my SEO packages (analysis) page on my website. Visit it by clicking here. I've always done SEO for our own business, so I'm new to this. Any help is appreciated. btw: I'm going to redo the chart on the page. I don't think profit and sales would ever compare like that. Thanks.
Industry News | | BobGW1 -
Manual action penalty by Google
Hello, We have a big well-known brand - www.titanbet.com. This brand is well established and the site has been live for almost 4 years now ranking very well on some very strong KWs. we received a message from Google on Aug 29<sup>th</sup> saying “Google has detected a pattern of artificial or unnatural links pointing to your site” and that “Google has applied a manual spam action to titanbet.com/” The past 2 weeks since the penalty was received we saw some of our major KWs drop in rankings. BUT all brand related KWs were still ranked 1<sup>st</sup> Over the last weekend the penalty has worsen and we no longer rank on any of the brands KWs (we find the site in 5<sup>th</sup> page at best). Moreover, when searching for a sentence from the any of the page on the site in Google, we see other sites ahead of us in the SERPs. Based on the message we originally received from Google we have started cleaning some of the bad links to the site. We found a lot of links from bad sites, some of them are not indexed and probably penalized as well, some are from affiliate websites and some are from some automatic indexation websites based in China and Russia
Industry News | | Tit
we have started reaching out to some of these sites to try and have them remove our links. We are also worried about the duplication of our site. We have found many other sites (mostly affiliate websites) have copied and in some cases completely duplicated our content. Google for some reason has chosen to penalize us for this. Although we do not have control over these other sites. We have run copyscape to try and figure out which pages are the most problematic and we will try to re-write the content on these pages. But what if the other sites copy us again? Any suggestions on the above would be appreciated as we try to understand why Google has penalized us. thank you Titan Bet Team0 -
Will Google ever begin penalising bad English/grammar in regards to rankings and SEO?
Considering Google seem to be on a great crusade with all their algorithm updates to raise the overall "quality" of content on the Internet, i'm a bit concerned with their seeming lack of action towards penalising sites that contain terrible English. I'm sure you've all noticed this when you attempt to do some proper research via Google and come across an article that "looks" to be what you're after, then you click through and realise it's obviously been either put together in a rush by someone not paying attention or putting much effort in, or been outsourced for cheap labour to another country whose workers aren't (close to being) native speakers. It's getting really old trying to make sense of articles that have completely incorrect grammar, entirely missing words, verb tenses that don't make any sense, randomly over-extravagant adjectives thrown in just as padding, etc. etc. No offense to all those from non-native speaking countries who are attempting to make a few bucks online, but this for me is becoming by far more of an issue in terms of "quality" of information online as opposed to some of the other search issues that are being given higher priority, and it just seems strange that Google have been so blasé about it up to this point - especially given so many of these articles and pages are nothing more than outsourced filler for cheap traffic. I understand it's probably hard to code in something so advanced, but it would go a long way towards making the web a better place in my opinion. Anyone else feeling the same way? Thoughts?
Industry News | | ExperienceOz1 -
Steady Traffic Decline over a 1 year period
Hello everyone, Need some help or suggestions. We have been experiencing a steady decline in our traffic for the last year or so. Beginning in October of 2011, we were averaging about 14,000 unique visitors per month (465/day). We are now averaging about 8,000 unique visitors per month (254/day). The thing that is really weird is that we do not have any type of a penalty from the big G. We have just seen a constant decrease in hits over the last 12 month period. Anywhere between 50-1,000 hits per month in decrease (continuously). This has just been frustrating, and no matter what we do, we cannot turn it around. Our whole website has been re-done in the last 3-4 months to see if we can stop this from continuing. We re-did a lot of the content, got rid of some pages that had keyword stuffing, we're now working on removing bad backlinks pointing to us. I am including an image with this post that will show you our gradual decline in traffic. I understand that the Google updates and refreshers have been coming out quite frequently (Panda, Penguin). But I also understand that most sites that have been affected by these algorithm changes, updates and refreshes have actually received penalties, sudden drops in traffic etc... We are still working on fixing the whole site before we submit a re-inclusion document to the big G. Does anybody in the SEOMOZ community have any suggestions or ideas as to what can be done to better our chances of getting back to normal traffic again? Everything that we did prior to the 2 latest Google updates has been according to what was legal and what worked in the past. Now, we have fixed the majority of those issues with our site, yet the decrease of traffic continues. Any help or suggestions would be greatly appreciated. I can provide you with our website URL if somebody would like to take a close look. Thanks ahead, Gaura lCx44.jpg
Industry News | | Gaura0 -
Convert Oganic ranking into Local Search Results
Hi, Right now, my website appears in top 5 results in organic SERPs, but I noticed that my business has gradually started going down, as my local results have been replaced by organic search results. Initially I used to rank in local results, but now, I appear in organic results so the no. of calls/day have decreased significantly. Now, I again want to appear in local search results instead of organic results. Please advice what should I do to remove my listing from organic search results and improve position in local search results PFA the screenshots for both the results for your better understanding. I look forward to hearing from you. Regards, qHKAt.png 0cPOp.png
Industry News | | Visiblics0 -
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 -
Keyword Ranking Tool
Hi guys, Can anyone help with a software (online or offline / paid or free) that can help us get the keywords and the rankings our websites are ranking for? *** NOTE: We already use some software to get our rankings for a list of keywords we submit. We are interested in a software that can pull our keywords and rankings WITHOUT having to submit a keyword list. We want to know where and what for do we rank (especially long tails).
Industry News | | tolik1
Also, we know we can use a turn around (by exporting the keywords we get traffic from from Analytics and using Market Samurai to get the rankings, but we prefer an independent software that does all this automatically for all the links on our entire domain. I remember I accidentally got into such software a couple of months ago, but lost the track of it :). Please let me know if you know about such software. I hope I am not chasing after shadows 🙂0