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?
Reply all
Reply to author
Forward
On Monday, April 29, 2024 at 3:24:39 AM UTC-7 Google Ads API Forum Advisor
wrote:
> 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,
>
> [image: Google Logo] Google Ads API Team
>
>
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"Google Ads API and AdWords 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/b05b26ea-541b-4259-b41a-7a611023a36cn%40googlegroups.com.
