First impression or creation date of a keyword

[Juan Carlos Blanco Delgado]

Hello, I have a project that I was trying to finish using Adwords scripts but as I just recently found out, there is a limit running scripts for 30 minutes. 

I need to check when was a keyword created on every campaign of an account that contains 404 campaigns working since 2008.

Could be possible to do it using the Adwords API?

My first idea, because there is not creation date of a keyword using Adwords Scripts, was to check when was the first impression of a keyword and then use that date as an approx creation date, the problem is that after the first impression and I go to the next date and there is an impression I need to check if the keyword has already been added, therefore every need keyword has to be added to a list, and the bigger the list the longer it takes to check if the keyword already exist.

Could be possible to do this faster or another method using the API???

Thank you!!!

[Google Ads API Forum Advisor Prod]

Hi Juan,

Thank you for posting your concern.

I would recommend to utilize the Keywords Performance Report and include a filter using the CampaignName field to get the campaigns that contains '404' in its name. You should then inlcude the Date field as well so you can check the earliest date as to when impressions were generated.

However, since you want to retrieve the data and impressions of keywords that is working since 2018, the output will be extremely large. If you encounter timeouts because of this reason, try a shorter date range or use predicates to break up the report request into multiple, smaller requests.

Let me know if this is what you're looking for.

Regards,
Ejay
Google Ads API Team

ref:_00D1U1174p._5001UEGxs3:ref

[Juan Carlos Blanco Delgado]

Hi Ejay, 

Yes it is helpful!

This is what I have so far.

I need to select the CampaignName, AdGroupName, FinalUrls and KeywordMatchType.

And I am assuming that FinalUrls are  the landing page?

SELECT CampaignName, AdGroupName, FinalUrls, KeywordMatchType

FROM KEYWORDS_PERFORMANCE_REPORT

WHERE CampaignName

LIKE "%404%" DURING 20081305,20190725

if the above is correct, how can I actually pass this to a spreadsheet, I dont know how to iterate the result

And I also need the name of the keyword which I dont know which attribute is

And how can I filter by date??? I thought that ordered by date was not allowed 

[Google Ads API Forum Advisor Prod]

Hi Juan,

Thanks for the reply. Please see my answer below for each of your question.

First, the FinalUrls field returns the list of landing pages of your ads.

Then, before we proceed to your question on how to download a report, I noticed that you've used 'LIKE' operator in the report definition. However, this operator is not supported in the AdWords Query Language (AWQL). With this, instead of using the 'LIKE' operator, you can use the 'CONTAINS' as its usage is the same.

For your convenience, you can use these sample codes (which is also available in other supported client libraries) to download the report. Provided in this link are all the supported download formats that you can use based on your preferences.

Moving forward to your question about retrieving the actual name of the keywords, you may include the Criteria field in the report.

As for your last question, you can only filter dates by using them in the DURING clause. I hope this has been helpful.

Regards,
Ejay
Google Ads API Team

ref:_00D1U1174p._5001UEGxs3:ref