querying removed *negative* keywords

[cha...@konversion.ca]

Hi.

We're using the 201710 api.

We maintain a database of campaign, adgroup and shared keyword criteria that we need to keep in sync with adwords.
For that, we need to be able to efficiently query removed keywords, both negative and positive, so as to avoid having to always query all keywords to update the database.

Campaign criteria(negative keywords) have a "campaignCriterionStatus" field, and biddable adgroup criteria also have a "userStatus" field. However, shared criteria and negative adgroup criteria don't seem to have an equivalent field to indicate if the criterion has been removed.
I assume this means that the removed criteria just won't appear in the result of a query?
This means that to update my database, I need to query all criteria, and check which criterion in our database are not in the query result?
This of course is not very efficient, as those queries can yield large amount of results.

Any advice on this?

Thanks.

[Peter Oliquino (AdWords API Team)]

Hi Charles,

You could try generating the Keywords Performance Report which should return all your biddable and negative keyword objects. You can add predicates such as the IsNegative IN [true, false] to retrieve both biddable and negative keywords and also the Status = REMOVED to satisfy your requirement.

Let me know if this helps.

Best regards,

Peter

AdWords API Team

[cha...@konversion.ca]

Yeah, we were already doing that.

Unfortunately, it seems that deleting a negative keyword makes it unavailable both in the keyword performance report and the services api.

I think a solution would be to use the customer sync service to know which keywords were removed.

[cha...@konversion.ca]

Using the customer sync api doesn't always address our need though, e.g. if there's too much change data, or if we missed changes beyond the last 90 days.

Also, the campaign criteria have a status attribute in the service api, but that attribute is not exposed through the campaign criteria(or campaign criteria performance) report.
As we want to store the status field along with the criteria in our database, we can't really rely on the reports for campaign criteria.

Le jeudi 17 mai 2018 02:24:36 UTC-4, Peter Oliquino (AdWords API Team) a écrit :

[MABEL MA]

i know, but a like you a mistake :((, i have konow i deal to fix this

Vào 14:29:05 UTC-7 Thứ Tư, ngày 16 tháng 5 năm 2018, cha...@konversion.ca đã viết:

[Peter Oliquino (AdWords API Team)]

Hi Charles,

Apart from the suggestion that I provided and your other solution of using the CustomerSyncService, there is no other way in which you could retrieve the REMOVED negative keywords information that you need.

[cha...@konversion.ca]

You confirm that negative keywords will not appear in subsequent reports or service query after being removed?

[Peter Oliquino (AdWords API Team)]

Hi Charles,

AdWords sometimes permanently deletes those objects which did not really generate any statistics. So for your removed objects, you may still be able to retrieve their information using the service or report which specializes in those entities and by applying the correct Status filter. In the event that no object is returned, then this would mean that they have already been permanently deleted.

Thanks and regards,

Peter

AdWords API Team