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 -
Results of keyword rankings way off??
I just did my first crawl, and a bunch of the keywords show my rank as being like 76 or 102 and I'm number 1 for the search when I search manually. **I of course have personal results turned off and I'm not logged into gmail when I search.
Moz Pro | | immortalgamer0 -
Does anyone know why some keyword rankings go from nowhere in the top 50 to ranking 1st to then nowhere in the top 50 in the space of 3 weeks?
SEOMOZ told me to ask the question here because they say their ranking programme now works correctly and the problems I was having before with keywords changing so dramatically, even though nothing had been changed with regards to optmisation, is now to do with google rather than their ranking tool do google really change their algorithms on a weekly basis so that rankings can go up by more than 50 to ranking 1st to then going down by more than 50? Any hints or tips from anyone on I can keep the rankings more consistent (maybe dropping or increasing by one or two places week by week rather than changing by over 50 positions?)
Moz Pro | | KateNZ0 -
How do I add a logo to a campaign/report I had before I updated my account?
I have tried to go in and add a logo to a report on one of my campaigns, but I can't see where to do that anywhere. Thanks.
Moz Pro | | Rocket.Fuel0 -
Significance of SEOmoz`s keyword difficulty
Hello everybody, currently, I am working on a project that will be available in multiple languages. My problem concerns the difference of the German and English language in relation to the SEOmoz`s Keyword difficulty (KWD). I just finished my German keyword research and got a satisfying collection of keywords I can use according to the KWD, page/ domain authority, Backlinks and Onpage-check. Now, as I am doing my research for the English market I find it hard to find any appropriate keywords with a satisfying KWD. I imagined the ranking on the English market to be much harder but now I doubt to ever rank for any useful, effective keyword on my list, because most of them are over 70 (some important over 80). According to the research it seems to have something to do with the authority strength of the pages, trust, etc, because they do not have more backlinks. Since they are query independent it is very hard for me to get a feeling for those metrics (I am new at SEO). So here are my questions: Due to your experiences, is it even possible to derank such pages or should I simply save the effort? How significant is the SEOmoz`s KWD? Would you always do Onpage optimization (text, internal linking) in case you earn more trust, authority, etc in the future, just to have your site optimized on the best keyword possible, even though you know that you cannot rank for that keyword (Cue: User-experience)? Or would you switch to less significant words (e.g. flashcards -> index cards) where you have a chance to rank but which is not that effective with traffic? Or focus on longtail, if possible? Many thanks
Moz Pro | | cramlr0 -
Does anyone know of a crawler similar to SEOmoz's RogerBot?
As you probably know SEOmoz had some hosting and server issues recently, and this came at a terrible time for me... We are in the middle of battling some duplicate content and crawl errors and need to get a fresh crawl of some sites to test things out before we are hit with the big one? Before I get a million thumbs downs- I love and will continue to use SEOmoz, just need something to get me through this week ( or until Roger is back! )!
Moz Pro | | AaronSchinke1 -
Campaign Manager Keyword Rankings all messed up???
My campaign in SEO Moz Campaign Manager has just ran it's weekly crawl, and all my keyword rankings are messed up. 18 keywords have apparently dropped by massive amounts, but when I do a physical search, they haven't moved. Also Keyword Tracker agrees with the physical search, so why is the Campaign Manager showing the wrong rankings all of a sudden??
Moz Pro | | gdavies090319770 -
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