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
-
Remove geographic modifiers from keyword list
I just pulled a search term report for all of 2013 from my PPC account. What I got was 673,000 rows of terms that have garnered at least 1 impression in 2013. This is exactly what I was looking for. My issue is that the vast majority of terms are geo-modified to include the city, the city and state or the zip code. I am trying to remove the geographic information to get to a list of root words people are interested in based on their search query patterns. Does anyone know how to remove all city, state and zip codes quickly without having to do a find and replace for each geo-modifier in excel? for example, if i could get a list of all city and state combinations in the US and a list of all zip codes, and put that list on a separate tab and then have a macro find and remove from the original tab any instances of anything from the second tab, that would probably do the trick. Then I could remove duplicates and have my list of root words.
Moz Pro | | dsinger0 -
How To Ques. Getting ranked on page one for a keyword when you compete with bigger websites/companies/stores
Can David Beat Goliath. I work with small businesses with top products that are up against big brands and their online presence. If I am working with them to create content that meets the needs of all their stakeholders/customers/prospects to generate revenue I wonder if keyword targeting with content can really pay off to get them page one, #1 position ranking. So I ask you this question? How do you create a story for a small online store that can get ranked on page one for a keyword when you compete with bigger websites (or sites with higher domain authority)? I don't need all the basics, I'm just looking for a key insight or tip that you have found or heard is working for a David to beat a Goliath (and hold their position rank once they get highly ranked). We are up against sites - for viable keywords -who have higher domain authority and in some cases more content or link backs. Also, I've notice in situations when I do get to page one and I'm in position 7 MOZ analytics show low to no traffic coming from it? Yikes, what do I do to improve that? These are top keywords.
Moz Pro | | brandawakening0 -
Keyword Suggestion Tool
I want to know is their any good keyword suggestion tool other than Google keyword suggestion tool and keyword planner. I need to have a list of free ones only for now.
Moz Pro | | csfarnsworth0 -
Non-branded keywords sending search visits???
Hi, You announce a number of keywords sending search visits much larger than what you show in the interface. How do I get the list of the keywords you found?
Moz Pro | | ResourceLab0 -
Do SEOmoz private questions get answered?
I submitted a question on September 30 and never received a response. I then followed up on October 6 and had an exchange with the support staff, who first told me that the question would be answered and then a couple of days later told me that they had no record of the question. By chance, I had taken a screen shot showing confirmation that the question had been sent (just something I did to remind myself to follow up if I didn't get a response!), which I sent to them along with the question again. That was four days ago, and I've heard nothing since then - not even an automated email saying that the question was received. Is it common for it to take almost a month before a response is received, and to have to follow up multiple times just to get an answer?
Moz Pro | | csmm0 -
Exporting keywords from PRO?
I would like to export the keywords from all of my campaigns but I can't find anywhere to do that. I don't need data, just the keywords. I want to do an audit and refresh of what I am tracking and excel would be quickest. Thanks!
Moz Pro | | SEI0 -
Best Keyword Ranking Report Tool
What's the best keyword ranking report tool that anyone is using currently? I have used CuteRank (booo), Rank Tracker, SEOBook.com Rank Tracker, etc. Cost isn't an issue - I'm looking for a free or a paid tool. I need to be able to export resutls in PDF and Excel format. Thanks for the feedback!
Moz Pro | | ezclickmedia0
