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
-
Comparing New vs. Old Keyword Difficulty Scores
We've had a few questions regarding the new Keyword Difficulty score used in Keyword Explorer, and how it compares to the old score in our stand-alone Keyword Difficulty tool. Specifically, people want to know why some scores are much lower using the new tool. There a general discussion of the math behind the tool in this post: Keyword Research in 2016: Going Beyond Guesswork One of the problems we had with the original Keyword Difficulty score is that, because it's based on our Page Authority (PA) score and PA tends toward the middle of the 0-100 range, Difficulty got a bit bunched up. A Difficulty score in the low-to-mid 20s (via the old tool) is actually very low. So, we set out to re-scale the new tool to broaden that score and use more of the 0-100 range. We hoped this would allow more granularity and better comparisons. While the logic is sound, we're concerned that we may have been too aggressive in this re-scaling, given recent feedback. So, we're going to be analyzing a large set of keywords (anonymously, of course) that people have run through the tool to see if too many Difficulty scores seem too low. If they do, we'll make some adjustments to the math. In the meantime, please be aware that low scores may appear lower in the new tool and very high scores may appear higher. We wanted to address some of the limitations in V1 and feedback over the years, and so the old and new scores really can't be compared directly in a meaningful way. We're sorry for any confusion that has caused, and we will re-evaluate if necessary.
Moz Pro | | Dr-Pete3 -
Can appropriate alt text be considered keyword stuffing?
Hi all, I just used the Moz page grader on this page: http://giavan.com/collections/earrings/pearl for the keyword "pearl earrings". It's grading it a "B" and the most important issue is "Avoid Keyword Stuffing in Document". The keyword appears once in the title, once in the H1 tag, twice in the body and 31 times in alt image text. We've recently been taking the time to add alt text to all product images by simply copying the product name. So if the product name is "Pearl & Crystal Beaded Drop Earrings", that text is copied and pasted as the product image's alt text. This seemed like the best way because it's highly descriptive and obviously, quick to implement. But if search engines see this as keyword stuffing, I guess we should rethink it. I don't know why Google would have a problem with this - it doesn't negatively affect the user experience and clearly those alt tag are serving a specific purpose. Still, the Moz grader doesn't seem to like it so if anyone knows the best way to handle this (or ignore it?) I'd really appreciate your help. Thanks!
Moz Pro | | RichAlbanese0 -
Does Anyone Know The Moz Analytics Release Date?
I know it's coming soon, but does anyone know the actual release date for Moz Analytics? Thanks!
Moz Pro | | eglassman0 -
I need to get a page in the top 3 Google results for my keyword "teaching jobs" but am struggling to do so! Can anyone help?
I'm trying to get this page http://www.eteach.com/teaching-jobs to rank as the top search result on Google with the keyword "teaching jobs" but it seems to be number 5 in the results! My competitors are totally kicking my arse on getting this page to be above my website. I've got the keywords in there, I have the right content and I have links, what more can I do to make it rank as number 1! Help please!! If anyone has an SEO check list of things I need to make sure I do on my pages for them to rank in the top 3 results then that would be really handy!
Moz Pro | | Eteach_Marketing0 -
Do you know if there is an problem with the rank Tracker on SEOmoz
My rank tracker is stating that I am not in the top 50 for my keyword which is auto insurance fremont ca. I check on bing and yahoo and i am listed as #2. Also on Google it states that my rank has gone down by 2 place but I acutally increase one from spot 12 to spot 11. Is anyone else having the same issue??
Moz Pro | | Greenpeak0 -
Is the Linkscape Index getting updated?
I know it only gets a big refresh once a month...The last being in the early part of January. But I released a map that went viral (front page of CNET, Wired, Scientific American) that has gotten me hundreds of links from different domains: https://www.google.com/search?q=perceptionbuilder.com+map I got these links in early to mid December and OSE is showing no data at all. Similarly, I have been doing some linkbuilding for clients and links that I got in October and November and those links aren't showing up either. Anyone else experiencing this? Many thanks, Matt
Moz Pro | | coppersix0 -
Pass Page LinkJuice? Or Pass Keyword LinkJuice?
I have a popular page that is not one of the three pages that I am hoping to raise awareness of (want to focus on). The dilemma I am trying to understand is that I really don't want to encourage all the flow from the popular to ONE of my hopeful pages (focus pages). Rather, I want to focus the keyword portions of that page to help the three hopeful pages. So I consider the rel=canonical tag.... err no. rel=canonical would pass ALL my popular page link juice to ONE of my three hopeful pages. What's the best way to pass the keyword link juice relevant to each of my three hopeful pages their, um, portion, of the popular page link juice. I'm white hat by preference. All four pages are good legitimate landing pages, and of course I dread sabotaging the popularity of what is working. Suggestions? Advice?
Moz Pro | | iansears0 -
How to handle crawl diagnostic errors for the same url. /products & /products/
I have copied on of the errors out of the crawl diagnostics report. Both /products and /products/ are returning an error, and both have pretty good domain authority so I feel like its hurting my site that these show up this way. Both urls create the same page, should I just setup a 301 on the /products with no slash or will that cause more harm... I am using the MODx cms system and that could have something to do with it. | Products | Datalight http://www.datalight.com/products 1 37 5 Products | Datalight http://www.datalight.com/products/ | 1 | 30 | 1 |
Moz Pro | | tjsherrill0