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
-
Why, my client website sudden gone down its ranking?
Hi Moz, As I am shocked to see sudden drop in my client website himachalpackagetour.com sudden dropped its ranking, here I am sharing single keyword "himachal tour packages" rank = 10th into rank = 250th in Google.co.in ? How it could have happened , I didn't even touch anything with the website. Let me tell How, Why it happened and suggest me to get it back same ranking. Thanks in Advance. Best,
Industry News | | Futura
Teginder0 -
Direct is taking over my SEO traffic in Mobile iOS and Android Devices
WIth all the buzz of mobile has anyone taken a look to dig into the SEO traffic by device (desktop vs mobile). Well I did and surprising my desktop trend was not even close to mobile traffic. Surprising to know that due to the security updates in iSO and Android organic traffic (traffic with out tracking codes) is getting bucket into Direct. (Yes we all know Direct traffic is dirty dirty label traffic that analytics platforms can identify.)http://www.rimmkaufman.com/blog/estimating-google-organic-search-visits-hidden-by-ios-6/17122012/http://www.definemg.com/recover-your-android-4-and-ios-search-traffic/ Feels like SEO is receiving no love... didn't we have enough with Google encryption, we didn't get the keyword but at least got the referral! Have you notice in your traffic and what are you doing about it?
Industry News | | LNEseo0 -
I need some help with google please
Hello i am trying to remove google partial penalization to my website since july 2012 I have removed link, used disallow tools, wrote letters Last comunicacion was a letter send on 12/2012 that they responded 3/2013 web in cuestion is www.propdental.com I have not answered yet because i am looking for a good profesional help they responded saying that i still have unnuturall links wich is pretty probably but i dont nkow wich ones remove. Site authority has dropped from 43 to 32 with all links removed traffic dropped from 48000 to 15.000 Please profesional contacts needed
Industry News | | maestrosonrisas0 -
What causes the reduction in traffic?
On FEB 2012 I got the now-famous notice from Google about the unnatural links. I contacted the SEO company who worked for my website and removed the inbound links. I submitted the reconsideration request and Google said that there are still unnatural links. I dig more on my links and continue to remove the links I think Google does not like. I again submitted the reconsideration request and they responded “we still see links to your site that violate our quality guidelines.”. When I compared the non-paid traffic month by month, starting on March, I see these fluctuations: March compared with Feb -16% April compared with March -18% May compared with April +13% Jun compared with May -10% July compared with June +10% August compared with July -10% September compared with August -12% October compared with September-29% Also, If I look into the index stats on my WMT, I see that on October I have 50% less pages indexed compared with July. It has been dropping between 10% and 15% each week, as follows: | Date | Total indexed | Change 7/1/2012 | 1101 | -0.09% 7/8/2012 | 1020 | -0.07% 7/15/2012 | 1020 | 0% 7/22/2012 | 975 | -0.04% 7/29/2012 | 781 | -0.2% 8/5/2012 | 714 | -0.09% 8/12/2012 | 703 | -0.02% 8/19/2012 | 690 | -0.02% 8/26/2012 | 690 | 0% 9/2/2012 | 588 | -0.15% 9/9/2012 | 582 | -0.01% 9/16/2012 | 580 | 0% 9/23/2012 | 580 | 0% 9/30/2012 | 580 | 0% 10/7/2012 | 622 | 0.07% 10/14/2012 | 618 | -0.01% 10/21/2012 | 618 | 0% 10/28/2012 | 562 | -0.09% | The rankings for the 3 top keywords went (starting on April) From 5 to 15 From 8 to 27 From 5 to 39 At this point, I am not sure what causes the reduction in traffic.
Industry News | | cardif0 -
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 -
Huge Hit and Bouncing Rankings Since Panda 3.3 Update?
Has anyone else seen rankings bouncing all over the place since the end of Feb? A client's site is for the term hcg which I know is controversial but we were in 3rd or 4th for the past couple of months until this update. Now for the term "hcg" the rankings are bouncing from the twenties to over 100 multiple times a day. I check them throughout the day with non personalized search, rank checker, etc to just try and keep updated. I have never seen rankings bounce around so much after an update and am wondering if this update is somehow effecting these more controversial search terms. Since The end of Feb our traffic has almost dropped in half due to the drop in just the "hcg" term ranking We have been cleaning up the site, updating lower quality content, blogging frequently and trying to build better links for the past couple months of working on the site.The problem is there have been a few other previous SEO companies that worked on the site and I don't know how much black hat tactics were used. Any insight or suggestions on this would be appreciated, we are all scrambling to try and recover from this.
Industry News | | Netmark0