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: 2701584988, 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=2701584988,
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: "2701584988"
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?
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/8e0c3a86-8bbb-4ea7-96d8-95b43e4994a8n%40googlegroups.com.
