RE: change_status doesn't return campaign_shared_set / shared_set changes

[Google Ads API Forum Advisor]

Hi,

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

Could you please provide us with the uncropped screenshot of the Google Ads account by highlighting the fields that you wish to retrieve via the Google Ads API?
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tPKcc:ref" (ADR-00232862)

Thanks,
 

Google Ads API Team

[Igor Gavryushkin]

Here's the query we used and the response that we are getting. Please let us know if you need the account number that we are using. It is our client account and we can provide it by request.

What we are trying to achieve is the accurate count of negative keywords added or changed in last 30 and 90 days across all account campaigns in display, search and shopping channels. This should include both changes to regular negative keywords and to the negative keyword sets shared across campaigns.

SELECT change_status.resource_name,
change_status.last_change_date_time,
change_status.resource_status,
change_status.resource_type,
change_status.ad_group,
change_status.ad_group_ad,
change_status.ad_group_bid_modifier,
change_status.ad_group_criterion,
change_status.ad_group_feed,
change_status.campaign,
change_status.campaign_criterion,
change_status.campaign_feed,
change_status.feed,
change_status.feed_item,
change_status.campaign_shared_set,
change_status.shared_set,
campaign.name,
campaign.id,
ad_group.name,
shared_set.resource_name,
ad_group.id
FROM change_status
WHERE change_status.last_change_date_time BETWEEN '2024-03-27' AND '2024-04-26'

AND campaign.advertising_channel_type IN ('DISPLAY', 'SEARCH', 'SHOPPING')
ORDER BY change_status.last_change_date_time ASC
LIMIT 10000

The culprit here is shared_set.resource_name (or any attribute from shared_set). Running it w/o explicit shared_set attributes seems to return blanks in the change_status.shared_set and change_status.campaign_shared_set for an account that has shared set changes.
Running it with shared_set.resource_name returns an error:

2024-04-26T15:26:34.576-07:00  WARN 85593 --- [ult-executor-11] c.g.ads.googleads.lib.request.summary    : FAILURE REQUEST SUMMARY. Method: google.ads.googleads.v16.services.GoogleAdsService/SearchStream, Endpoint: googleads.googleapis.com:443, CustomerID: XXXXXX, RequestID: dQGDrNxv7O76m4dz6eu6qw, ResponseCode: INVALID_ARGUMENT, Fault: Request contains an invalid argument..
2024-04-26T15:26:34.576-07:00  INFO 85593 --- [ult-executor-11] c.g.ads.googleads.lib.request.detail     : FAILURE REQUEST DETAIL.
Request
-------
MethodName: google.ads.googleads.v16.services.GoogleAdsService/SearchStream
Endpoint: googleads.googleapis.com:443
Headers: {developer-token=REDACTED, login-customer-id=XXXXXXX, x-goog-api-client=gl-java/17.0.6__Amazon.com-Inc.__Corretto-17.0.6.10.1 gccl/30.0.0 gapic/30.0.0 gax/2.43.0 grpc/1.61.1}
Body: customer_id: "XXXXXXXX"
query: "\n            SELECT change_status.resource_name,\n             change_status.last_change_date_time,\n             change_status.resource_status,\n             change_status.resource_type,\n             change_status.ad_group,\n             change_status.ad_group_ad,\n             change_status.ad_group_bid_modifier,\n             change_status.ad_group_criterion,\n             change_status.ad_group_feed,\n             change_status.campaign,\n             change_status.campaign_criterion,\n             change_status.campaign_feed,\n             change_status.feed,\n             change_status.feed_item,\n             change_status.campaign_shared_set,\n             change_status.shared_set,\n             campaign.name,\n             campaign.id,\n             ad_group.name,\n       shared_set.resource_name,\n             ad_group.id\n             FROM change_status\n             WHERE change_status.last_change_date_time BETWEEN \'2024-03-27\' AND \'2024-04-26\'\n             AND campaign.advertising_channel_type IN (\'DISPLAY\', \'SEARCH\', \'SHOPPING\')\n             ORDER BY change_status.last_change_date_time ASC\n             LIMIT 10000\n        "


Response
--------
Headers: Metadata(content-type=application/grpc,request-id=dQGDrNxv7O76m4dz6eu6qw,date=Fri, 26 Apr 2024 22:26:34 GMT)
Body: null
Failure message: errors {
  error_code {
    request_error: UNKNOWN
  }
  message: "The error code is not in this version."
}
request_id: "dQGDrNxv7O76m4dz6eu6qw"

Any suggestions how to track history of shared set changes in Google Ads API v16?

[Google Ads API Forum Advisor]

Hi,

As requested earlier, kindly provide us with the uncropped UI screenshot of the Google Ads account with visible customer ID by highlighting the fields that you wish to retrieve via the Google Ads API to assist you better.

[Igor Gavryushkin]

Sent screenshots in private post. Please take a look.