AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

1.7K members online now
1.7K members online now
Dive into advanced features like Remarketing, Flexible Bid Strategies, AdWords Editor, and AdWords Scripts
Guide Me

Google Scripts - First Timer

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭



I am new to Google Scripts. Is it possible to do the following:


1. Find Keyword Term with Organic Average Position above position 8

2 Then find Keywords with Organic Queries over 20 per year 


I have this data from the Paid and Organic Report.


If this is true can the Script create an ad for this with standard content in lines 2 and 3.

Rather like Dynamic?

2 Expert replyverified_user

Re: Google Scripts - First Timer

Top Contributor
# 2
Top Contributor

Our script guru is @Jon_Gritton

Moshe, AdWords Top Contributor , Twitter | Linkedin | Community Profile | Ad-Globe
Did you find any helpful responses or answers to your query? If yes, please mark it as the ‘Best Answer’

Re: Google Scripts - First Timer

Top Contributor
# 3
Top Contributor

Hi @Suzanne K (thanks @MosheTLV)


This is certainly possible with Scripts, you'd need to make use of the PAID_ORGANIC_QUERY_REPORT, see here:


If you're a newbie to scripting it could be quite tricky as accessing these API reports is one of the more complex aspects of AdWords scripting, but it's certainly possible.  There's a guide to using reports here:


You'd need to iterate through all the Keywords in your chosen Campaigns, look for organic terms with traffic against those Keywords (KeywordMatchingText or KeywordId) then, if data exists, test the data against position (OrganicAveragePosition) and number of queries (OrganicQueries).


Let us know how you get on.



AdWords Top Contributor Google+ Profile | Partner Profile | AdWords Audits