change_status doesn't return shared sets changes

43 views
Skip to first unread message

Igor Gavryushkin

unread,
Apr 26, 2024, 7:58:17 PM4/26/24
to Google Ads API and AdWords API Forum
Hi, our attempts to use change_status for tracking changes made to shared sets of keywords return no data. More over, adding to the query attributed resource fields from shared_set object, which according to the Query Builder are available throws an error in Java API. 
Here's the query:
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

unread,
Apr 29, 2024, 7:05:41 AM4/29/24
to igav...@gmail.com, adwor...@googlegroups.com
Hi,

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

I notice that you've already raised this concern in another thread titled 'Change_status doesn't return campaign_shared_set / shared_set changes'. We've already provided a response there regarding this issue. To streamline communication and avoid redundancy, please refer back to that thread for any updates or further discussions on this topic. ​ ​ 
 
This message is in relation to case "ref:!00D1U01174p.!5004Q02tPKd6:ref" (ADR-00232866)

Thanks,
 
Google Logo Google Ads API Team


Reply all
Reply to author
Forward
0 new messages