I need detect CHANGE STATUS in Google Ads API)) query = """ SELECT change_status.resource_name, change_status.last_change_date_time, change_status.resource_type, FROM change_status WHERE change_status.resource_status = 'REMOVED' ORDER BY change_status.last_change_date_time"""
response = ads_service.search(customer_id, query=query, page_size=ADS_PAGE_SIZE) I need get CHANGE STATUS with last_change_date_time. But response always empty! Ads API was not return any rows by status "REMOVED". How I can detect in Ads API, what Ad status changed to 'REMOVED'? For example: query = f""" SELECT {query_fields} FROM ad_group_ad WHERE ad_group_ad.status == 'REMOVED' ORDER BY ad_group_ad.ad.id""" I don't need this method^ becouse it return ALL removed Ads each time. I need receive only new (last) REMOVED ads FROM change_status. On Tuesday, 20 October 2020 at 08:23:09 UTC+3 adsapiforumadvisor wrote: > Hi, > > Thanks for posting your concern. > > I am afraid that it is not possible for the Google Ads API to detect the > changes in the status of ads in your database. You will need to reach out > to the support of the database that you are using to know if this is > possible on their product. > > However, if you want to retrieve the ads that have 'removed' status in > your Google Ads account, then you can use the ad_group_ad > <https://developers.google.com/google-ads/api/fields/v5/ad_group_ad> report > and filter the ad_group_ad.status > <https://developers.google.com/google-ads/api/fields/v5/ad_group_ad#ad_group_ad.status> > by > comparing this field it with 'REMOVED' value. > > Regards, > [image: Google Logo] > Ernie John Blanca Tacata > Google Ads API Team > > > ref:_00D1U1174p._5004Q26AUqZ:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/0bb6e261-c801-4608-b244-ccf6d1863ef0n%40googlegroups.com.