Keyword search volume as a function using Google AdWords API?

Support
#1

Hi,

I would like to pull Keyword search volume into an existing sheet with thousands of keywords in it,
Without having to copy paste the keywords into the tool

Instead being able to use a function to pull the data directly into the excel sheet i'm working with.

Would it be possible to show me how the function works?

Thank you!
Zalman

1 Like
#2

Perhaps like this:

Have all keywords in Column A.

Use the concatenate function in column B, for example:
// =concatenate("http://www.google.com/search?q=",A2)

in column C, use Xpath to extract the field for search volume:
// =XPathOnUrl(A2,"//*[@id='resultStats']/text()")

And use some VBA or left/right function to remove text from result.

#3

Hi,

Thank you for your response (it's a little above my pay grade :smile:
I was hoping for something simpler using Google Adwords API
To get search volume in Google (I think you thought I meant search results volume)

I tried this function but it's not working.

=AdwordsKeywordSearchVolumes(B2,2840,1000,FALSE,"Keyword,Competition,SearchVolume",TRUE)

http://imgur.com/a/sblrs

I've attached an image of the breakdown of the function.

Thanks
Zalman

#4

Same question as person above, as I did not find a solution before.

The solution you offer, @diskborste , is to get the amount of results on the serp page i think (?), but instead we try to get the search volume data pulled from adwords for a given keyword.

Having a formula next to the keyword you want to get the search volume from would eliminate the bug found by chilly bang, may 15th.