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

2.1K members online now
2.1K members online now
Get started with Google Ads - learn the basics to get set up for success
Guide Me

Need Help - How to do an automatic report

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello there,
I'm new in Goole Adwords and I am trying to do something that I don't know if it's possible.

I'm not looking for clicks or bids or campaigns.
What I really want is to do an automatic report about the number that a certain keyword is searched locally and globally!
(See the pictures for better comprehension)

More detailed:
I have a list of keywords and a list of countries.
What I want is for each keyword in all the countries, get the numer of searches that the specific keyword was searched worldwide and locally.

Keyword                    Country          Global searches         Local searches
Beaches in Brazil;      Brazil;            140500                      100500
Food in Thailand         Thailand          11567                         8600
Golf in USA                USA              245000                      150000

Can this be done in an automatic way, without doing it manually for every keyword/country (like one/two single script that thoes it all)?!
Is this possible in Google Adwords?
If it's possible, how it can be done?

Thank you very much in advance.

Re: Need Help - How to do an automatic report

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

As far as I'm aware, it's not possible to include this information in automated, scheduled reports. There may be third party tools that allow you to do this, but I'm not aware of any.


You can run the same report on a regular basis and use VLOOKUP to view changes/trends?

Re: Need Help - How to do an automatic report

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thank you for your answer Smiley Happy