Anyone know how/where to get keyword yield ratio?
-
I'm trying to incorporate keyword yield ratio (the ratio of keywords to pages yielding search traffic) in my seo report.
I want to be able to compare on a monthly basis the percentage ratio of keywords to a landing page yielding search traffic.
So for example, in July we might have 5 keywords that earned a click to landing page A.
But in September, the number of keywords grew to 8 keywords that earned a click to landing A.
I would like to be able to report monthly on the % ratio growth of number of keywords to landing pages that yield search traffic. Aim is to grow # of keywords per page...
Is there a way I can get this data through seomoz tools or google analytics?
Thanks,
Gemma
-
Yeah... I'm trying to find a way to do it without me having to dump into excel... but thanks!
-
I looked up "amalgamation" - I can't even pronounce it right. So... I am in over my head here. But I am still trying!
I think you can import the data into Excel. Then using some formulas get the numbers you are looking for. A field that counts the number of keywords. You could also use a conditional formula. This is hard to explain but I think you could do it.
-
Sorry but that's all I got... not even sure what "amalgamation" means. Sounds painful!
-
Hi Stephan,
Thanks. But that particular report doesn't give you amalgamation of the % ratio growth of all non-paid keywords per landing page though..
-
I think I got it. Do you have a Google Analytics account?
If so... if you click on the ecommerce section, you should find a section called "keywords" where you can select "non-paid keywords" to get a list of all the keywords that sent traffic to your site. You can also get this list by going through the "traffic sources" section.
Once you have your list of referring keywords, you should see a drop down that says "none" in the column next to the keyword column. If you activate the drop down you can add another parameter...select "landing page" which will bring up the landing page associated with each keyword.
So you'll have visits per keyword per landing page... I think this gives you enough info for your report! Let me know if you need more info or if I am off base.
-
I want to be able to compare on a monthly basis the percentage ratio of keywords to a landing page yielding search traffic.
So for example, in July we might have 5 keywords that earned a click to landing page A.
But in September, the number of keywords grew to 8 keywords that earned a click to landing A.
I would like to be able to report monthly on the % ratio of number of keywords to landing pages that yield search traffic. Aim is to grow # of keywords per page...
Hope that's a bit clearer?
Thanks.
-
Hi.
Can you be more specific? Maybe give an example.
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
-
Page Ranking by URL / Keyword
Needing to know how to find out the page rank of a URL that is NOT within the top 50 or top 100. Need to know that specific page's rank, not what our overall site's ranking for the keyword is. Can't seem to find any tool that goes beyond the top 100. Any ideas?
Moz Pro | | leankit0 -
Aren't domain.com/page and domain.com/page/ the same thing?
Hi All, A recent Moz scan has turned up quite a few duplicate content notifications, all of which have the same issue. For instance: domain.com/page and domain.com/page/ are listed as duplicates, but I was under the impression that these pages would, in fact, be the same page. Is this even something to bother fixing or a fluke scan? If I should fix it does anyone know of an .htaccess modification that might be used? Thanks!
Moz Pro | | G2W0 -
Are Moz Ratings that reliable/correlated against SERPS?
So 3 weeks in Penguin 2.0 and after an initial drop in rankings (4-5 places on top keywords from rank 1), I have seen a small climb in rankings by a couple places but have seen a huge jump in my DA, PA and Domain trust/rank... That FAR surpasses any other magicians website. However I am ranking below some really really poorly rated sites. I am getting a PA of 51 which is really high for the industry (maybe the highest). If this is the case, why am I not number one for every keyword in my demographic?
Moz Pro | | TomLondon
I know this is asked a lot but how reliable are Moz stats, I know no one can really know how Google rank sites on SERPS but if Moz is the best shouldn't it be kinda close? Any thoughts on how accurate Moz rank is and also if it can be used as some indication of the SEO power behind a website.0 -
Multiple Sites/Internal Pages Campaign
Can MOZ do reports/ranks/campaigns separately for each of our sites, then do separate keyword campaigns for specific internal content pages of each of the websites? For a law firm with both a defense and family law sites. We have multiple pages within each site, we will need to do separate and individual campaigns for assault, burglary, traffic tickets, ect. in our defense site. And we'll need other specific campaigns for other specific content in out family law site. Will Moz be able to accommodate our needs with their $99/mo plan or is that service only available for higher packages? (or is it even possible in ANY of their packages???) Thanks.
Moz Pro | | Wallin_Klarich0 -
Are labels useful in managing keywords in SEOMoz Campaigns?
I am using SEOMoz for only one domain. Should I track keywords under only one campaign, or should I utilize the different campaigns for different types of keywords under the same domain? Is it easier to keep all keywords for a domain in one campaign? Is it helpful to assign labels to keywords within the campaign? What types of labels should I create?
Moz Pro | | djlittman1 -
Rogerbot getting cheeky?
Hi SeoMoz, From time to time my server crashes during Rogerbot's crawling escapades, even though I have a robots.txt file with a crawl-delay 10, now just increased to 20. I looked at the Apache log and noticed Roger hitting me from from 4 different addresses 216.244.72.3, 72.11, 72.12 and 216.176.191.201, and most times whilst on each separate address, it was 10 seconds apart, ALL 4 addresses would hit 4 different pages simultaneously (example 2). At other times, it wasn't respecting robots.txt at all (see example 1 below). I wouldn't call this situation 'respecting the crawl-delay' entry in robots.txt as other question answered here by you have stated. 4 simultaneous page requests within 1 sec from Rogerbot is not what should be happening IMHO. example 1
Moz Pro | | BM7
216.244.72.12 - - [05/Sep/2012:15:54:27 +1000] "GET /store/product-info.php?mypage1.html" 200 77813
216.244.72.12 - - [05/Sep/2012:15:54:27 +1000] "GET /store/product-info.php?mypage2.html HTTP/1.1" 200 74058
216.244.72.12 - - [05/Sep/2012:15:54:28 +1000] "GET /store/product-info.php?mypage3.html HTTP/1.1" 200 69772
216.244.72.12 - - [05/Sep/2012:15:54:37 +1000] "GET /store/product-info.php?mypage4.html HTTP/1.1" 200 82441 example 2
216.244.72.12 - - [05/Sep/2012:15:46:15 +1000] "GET /store/mypage1.html HTTP/1.1" 200 70209
216.244.72.11 - - [05/Sep/2012:15:46:15 +1000] "GET /store/mypage2.html HTTP/1.1" 200 82384
216.244.72.12 - - [05/Sep/2012:15:46:15 +1000] "GET /store/mypage3.html HTTP/1.1" 200 83683
216.244.72.3 - - [05/Sep/2012:15:46:15 +1000] "GET /store/mypage4.html HTTP/1.1" 200 82431
216.244.72.3 - - [05/Sep/2012:15:46:16 +1000] "GET /store/mypage5.html HTTP/1.1" 200 82855
216.176.191.201 - - [05/Sep/2012:15:46:26 +1000] "GET /store/mypage6.html HTTP/1.1" 200 75659 Please advise.1 -
Can SEOMOZ Pro suggest me the best keyword to work for?
Hi, how SEOMOZ PRO can suggest me the best keyword to rank easily in the first position of Google's SERP? Is there a tool to find good keyword and got some ideas? Regards
Moz Pro | | jadlib0 -
Getting relevant keywords from URL with Google KW Tool.
Hi, When I first start researching a site, I like to see what Google "thinks" it is relevant to. I use the Google KW Tool and enter the website URL only. I sort the results by relevance. I can then show the prospective client what Google thinks his site is optimized for and use that info to show him what opportunities exist to rank for terms more relevant to his business. I show him keyword, volume and I also get current SERP rank for his site. For larger sites, I do this for the top pages based Domain Authority. I want to automate this process using excel and APIs but Google refused my API token request. I told them I wanted to use the "Google AdWords API Extension for Excel" from http://seogadget.co.uk/google-adwords-plugin-excel. The Google API token team replied: Please note, after reviewing your application in detail, we are sorry to let you know that we won't be able to approve your token. We understand that you are planning to use the AdWords API mainly for Targeting Idea Service (TIS) and Traffic Estimation Service (TES) such as 'keyword research'. Please note that as per the Required Minimum Functionality (RMF) outlined in the API Terms & Conditions, using the AdWords API exclusively for TIS and TES type of services is not allowed. Q1: What does the KW Tool relevancy data mean, anyway? Q2: is there another way to get it or is there another way to do this? Q3: Is there a better approach I should take with the Google API team? Q4: Are there other APIs and Excel plugins that can do this, including the SEOMoz APIs? Thanks,
Moz Pro | | phersh
Phil0