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
-
15-20 images on a page / Alt Tag them or not with the keyword phrase?
I have a site that easily has 15-20 images per product page, giving the users ideas of what they can do with the product design. All of them have an alt tag with the keyword phrase in it. There is also an H1, H2, sometimes an H3, body copy with the keyword phrase 1-3 times, bold when it seems like a good time to emphasize it. Just in the images alone, we've exceeded the recommended 15 keyword phrases on a page. Moz On Page Grader says the following: Avoid Keyword Stuffing in Document We've seen evidence that excessive use of keywords can negatively impact rankings and thus suggest moderation. Recommendation: Remove instances of the targeted keyword(s) from the document text of this page to bring it below 15 What's the recommendation for the image alt tags? We'd like the images to show up in Google Images, so they should have the tag, right? What's the right way to handle this for SEO purposes? Someone's suggested naming 1/2 of the images one keyword phrase, and the other 1/2 an altogether different one, not searched nearly as often as the primary keyword phrase.
Moz Pro | | INCart0 -
How do you explain this in this Keyword Difficulty Report?
Hello here, I am trying to understand how my site virtualsheetmusic.com can better compete for the keyword "sheet music download" where we used to be 3rd until a few months ago, and now we are at the 5th spot. But here is my specific question: I can't find an explanation why two of our competitors are ranked before us at the 3rd and 4th spot. Please, look at the attached image (very wide) which shows the Keyword Difficulty Report for this keyword. You can also download a PDF of it here below: http://www.virtualsheetmusic.com/storage/keyword-sheet-music-download.pdf We are at the 5th spot, and the two competitors highlighted in pink are the ones I am talking about: I am trying to understand why they are ranking better than us, despite our metrics look much better than theirs. In fact, if I look at the metrics in the report, I can't find an explanation to justify their outrank against us, so there must be something else that the report is missing. Any thoughts about this issue are very welcome! Thank you in advance for any help. Sincerely,
Moz Pro | | fablau
Fabrizio [keyword-sheet music download.jpg](http://www.virtualsheetmusic.com/storage/keyword-sheet music download.jpg)0 -
What's up with Yahoo and Bing in my keyword rankings?
SEOmoz is good I've learned a lot from it. I'm on my 3rd month and now have 8 keywords in top 50 for one site and 1 keyword in top 50 for another. This is for Google US. For Bing and Yahoo! US however I am still not in the top 50 for anything. I have read elsewhere that meta-tag page words can be regarded by these engines as a spam signal. In my meta I have used competative keywords that are relevant to my content, some of which are in the body, but are not my actual targeted keywords as a red-herring to potential competitors. Also might be usefull for other smaller places that still use meta-tags. Could not appearing in BingHoo! have something to do with their alogrithms and the meta-tags? or is it an SEOmoz issue? I have another question also. The " / " after a domain name doesn't appear in my Firefox address bar (I think I did a 301 redirect), but when I copy and paste it into an entry box (e.g. for a link submission) it puts the " / " there at the end which I take off. Does this make any difference?
Moz Pro | | Zoolander0 -
Last Linkscape index update: 05/30/2012
When will the next Linkscape index update occur? I've been waiting to run our backlink profile numbers, but the Last Linkscape index update was 05/30/2012? Thanks!
Moz Pro | | larahill0 -
Where is the keyword difficulty tool data sourced from?
I also use Market Samurai, and I've noticed what seem to be big discrepancies with the keyword data presented by this (data comes from Majestic SEO) and the Keyword Difficulty Tool. To take just one example, I analyze the term "how to remove tea stains" In the Keyword Difficulty Tool, this returns the following: Root Domain Linking Root Domains: 2,233 Page Linking Root Domains: 4 When I use Market Samurai, however, the data returned is: RDD (Domains linking to this domain): 19,911 RDP (Domains linking to this page): 19 I thought that these two metrics were the same for both tools, but I've written them out in case someone sees a difference. As I say, Market Samurai data is sourced from Majestic SEO - a reputable SEO company - but I have no idea where the Keyword Difficulty Tool data is from, nor why these differences are so pronounced? Are they indeed the same metrics in both cases, or am I missing something? Any insight would be much appreciated.
Moz Pro | | ZakGottlieb710 -
Tracking Keyword Positions
Hello! I've been working with the various Google Docs Spreadsheets out there taking advantage of web scraping using xml and the seomoz api. I want to be able to track keyword rank by week, I've been playing around but can't seem to get it nailed on, I'm looking to put keyword in column 1, domain in col 2 and keyword rank on google uk in col 3. Anybody done/seen anything like this in a G spreadsheet? Cheers Jamie
Moz Pro | | ChapterEight0 -
Ranking are not updating for my keywords
i have almost three week now and some of my keywords still not showing any ranking under ranking tab instead they are showing the day next crawl is due. Any suggestions Thanks
Moz Pro | | TahirLiaqat0 -
How to get seomoz to re-crawl a site?
I had a lot of duplicate content issues and have fixed all the other warnings. I want to check the site again.
Moz Pro | | adamzski0