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
-
Just how accurate is anyone's appraisal on this forum?
When people are discussing what affects their search engine rankings on this particular forum, which has got to be one of the most read on the Internet just how much guesswork is really going on? It seems like God almighty Google works from its own criteria and the rest of us all scrap to guess! I myself in the last week of posted various topics on here and are conflicting reports by so-called experts not that I am being critical for the sake of it. If you to one website and said to all the people on this forum just exactly why is it ranking to a degree for this particular key phrase or not as the case may be would there be any truly accurate knowledgeable answers that will come through and explained the difference? If you have a top 10 of most important things that would influence your rankings that are not guesswork would that be possible to say based on knowledge and expertise? And if so spill the beans what are ? What are the movers and shakers in their particular keyword phrases doing ongoing that's getting them the great results we all want ? Or is the entire subject of how well you rank ultimately not totally understood and only the realms of guesswork based on observation. When I was young I trained as electrician which dealt in facts, it seems like this is not possible with the world of business and search engine rankings?
Moz Pro | | WhitbyHolidayCottages1 -
Newsletter Optimization Help - Anyone know someone?
Hi Moz'ers! I am looking for some help and possibly a referral. My organization has a massive newsletter, 180k subscribers but the performance of the newsletter has been decreasing over the past couple of years with a really poor CTR. I am looking for someone to help optimize and provide recommendation on how we can better the newsletter performance again. We are in the international education and travel business, primary audience is college students within the US/UK/AUS. If anyone has a recommendation of an agency or consultant specializing in newsletters optimization, that would be amaze-balls!
Moz Pro | | GoAbroadKP0 -
Keyword report
What's the purpose of the keyword difficulty report? I've typed in some of my keywords and discoverd their "highly competetive." As if I didn't already know this. 😉 The question is, what do I do about it?
Moz Pro | | sakeith0 -
MozScore. Why doesnt it let me Input all my keywords to get the Score? Why do i have to do it 5 at a time?
hey guys maybe someone can shed some light. why do i have to only input 5 words at a time in Keyword Analysis Tool rather then just inputing my Keyword list and getting the moz score for each one. ie: if i am initially just looking for the mozscore and nothing else? Any input?
Moz Pro | | BizDetox0 -
Proportion of branded keywords vs targeted keywords in anchor text distribution
Hello, I have a question about the proportion (in %) of branded keywords vs targeted keywords in the anchor text distribution of a website. Suppose if I have a website with 3 targeted keywords and 2 branded keywords in the anchor text distribution that looks like this: 1 main targeted keyword 20% 2 targeted keyword 15 % 3 targeted keyword 15 % 4 branded keyword 10 % 5 branded keyword 5 % 6 more keywords 35% The question is: What would be the best distribution in percentages to aim for the main and other keywords? Should the branded keyword % increase and (main) targeted decrease? Or something else? (I have "Opensite Explorer" and Cognitive SEO" as tools to measure.) Thank you for your answers!
Moz Pro | | ThomasH0 -
Using MOZ Keyword Rankings with Google Analytics in Excel to track paid keywords
Hi, I sorted my keywords in GA from highest incoming traffic to lowest, exported it and then imported these 280 or something keywords into SEO Moz. The problem is, it appears that SEO Moz Keyword Rankings tool pulls traffic data (in the traffic column) only for NON-PAID traffic ... So what I'm seeing is that keywords that brings A LOT of traffic to my site (because of AdWords) sometimes have 0 of traffic in SEO Moz, because I'm on page 3 of SERP and I literally got no non-paid traffic that week. The thing is: I want to improve my rankings for keywords that I'm already performing well, even if they are paid keywords, because they already bring me a lot of traffic to my website. The way this is working is not helping me out, because when I sort by the traffic column very important keywords end up in the last place for me. Questions: Whey does SEO Moz pull traffic data from non-paid keywords only ? Shouldn't be at least an option for this or I'm missing something here ? While they don't change it, any Excel Gurus could help me how to export SEO Moz ranking data, import it on Excel and MERGE a new "paid traffic" column that I export from Google Analytics ? How to assing each keyword line the paid traffic value I'm getting from GA ? Thanks ! Felipe
Moz Pro | | pqdbr0 -
Keyword Difficulty Tool on local results. Is this really working?
I've tried the Keyword Difficulty Tool on "consultant seo" in Romania (that is .ro) The tool says that it's Highly Competitive (59%), but I've got my website on #8 in 2 weeks. Question: Is this tool really working for local results? It seems way off... Actually I was kind of expecting for this keyword to be easy, what is confusing is the "59%" from the Keyword Difficulty results. Thanks for the answers!
Moz Pro | | wizant0 -
What is the best/your favorite management software?
Currently my company uses basecamp with a splash of google docs a little bit of Paymo, and Raventools for project management. (We use other tools like SEOmoz, but not so much for management as SEO tasks) The ideal features we are looking for are: Collaborative document editing and sharing(Google Docs) Task lists and project organization (basecamphq) Time Tracking on a per task basis (Paymo) (SEO tracking software is great too, but it doesn't have to be integrated with the project management directly. Currently using Raventools and SEOMoz along with some smaller tools.) The project management side can be completely separate from the SEO tool side, but it would be great if there was one simple interface that all of this could be done from. Any suggestions? Are there features I'm missing in my current software that could bring them up to this level?
Moz Pro | | MarloSchneider0