Fetching ads and keywords that were changed yesterday

[Andjel Boskovic]

Hi,

I'm trying to fetch and import ads and keywords that changed yesterday into our internal system.

One of our accounts has:
 > 160,000 active ad groups
> 940.000 active ads
> 900.000 active keywords

As far as I'm informed there is the AdGroupChangeData in CustomerSyncService.

This service returns ad groups that were changed, for example, yesterday.

In order to get the ads and keywords, I'd need to check if the returned AdGroupChangeData had its keywords/ads changed.

In a scenario where only 2.000 ads and 1.500 keywords were changed, it is still needed to receive and loop through all changed ad groups that may have had only ad group level bids/ extensions changed, that number is always very high. This takes a lot of resources for inefficient work.

Fetching ads or keywords directly from the ad or keyword services does not allow filtering by changes, as far as I'm aware.

Is there a way to fetch only changed ads and keywords that had been changed yesterday?

Thank you in advance,
Andjel

[Google Ads API Forum Advisor Prod]

Hi Andjel,

There is a Change Event service in Google Ads API but not in AdWords API. For keywords, I recommend checking the 'Ad group criterion' resource type. Please take a look at the service:

1. https://developers.google.com/google-ads/api/docs/change-event?hl=en
2. https://developers.google.com/google-ads/api/reference/rpc/v6/ChangeEvent?hl=en

Thanks,

Lakshmi Prathipati Google Ads API Team

ref:_00D1U1174p._5004Q2CTTZx:ref

[Gigel Chiazna]

Here it is how you can limit by date using change_event.

SELECT change_event.resource_name, change_event.change_date_time, change_event.change_resource_name, change_event.user_email, change_event.client_type, change_event.change_resource_type, change_event.old_resource, change_event.new_resource, change_event.resource_change_operation, change_event.changed_fields FROM change_event WHERE change_event.change_date_time <= 20220818 AND change_event.change_date_time >= 20220803 ORDER BY change_event.change_date_time DESC LIMIT 2000

Gigel Chiazna

[Google Ads API Forum Advisor]

Hi Andjel,

Thank you for reaching out to the Google Ads API support team.

The AdWords API is no longer supported. Use the Google Ads API instead. You may refer the migration guide. You can use change_event report. The changes made through UI, API and new versions of Editor by external users (including external users, and internal users that can be shown externally) in the past 30 days will be shown. The change shows the old values of the changed fields before the change and the new values right after the change. ChangeEvent could have up to 3 minutes delay to reflect a new change. Let me know if you have any questions.

Thanks,

Nirmita Google Ads API Team

ref:_00D1U1174p._5004Q2CTTZx:ref