Anyone know how/where to get keyword yield ratio?

[RBA]

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

[RBA]

Yeah... I'm trying to find a way to do it without me having to dump into excel... but thanks!

[STPseo]

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.

[STPseo]

Sorry but that's all I got... not even sure what "amalgamation" means. Sounds painful!

[RBA]

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..

[STPseo]

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.

[RBA]

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.

[STPseo]

Hi.

Can you be more specific? Maybe give an example.