CAMPAIGN_CRITERION & AD_GROUP_CRITERION in change_event table

50 views
Skip to first unread message

Miryam Miryam

unread,
Jun 27, 2021, 5:56:55 AM6/27/21
to AdWords API and Google Ads API Forum
I have been trying to use the change event service to fetch the changes for some of the entities, but when it comes to the CAMPAIGN_CRITERION & AD_GROUP_CRITERION, their types are always returned with 0 (UNSPECIFIED), even though when I try to fetch that exact criterion from their respective tables (campaign_criterion/ ad_group_criterion) the type is returned normally (USER_INTEREST, CUSTOM_AFFINITY, DEVICE, ... etc)

Query used to fetch the event changes:
$query = "
                SELECT  change_event.resource_name, change_event.change_date_time, change_event.change_resource_name, change_event.user_email, change_event.client_type, change_event.change_resource_type, 
                        change_event.old_resource, change_event.new_resource, change_event.resource_change_operation, change_event.changed_fields 
                FROM change_event 
                WHERE change_event.change_date_time BETWEEN " . "'$start'" ." AND " . "'$end'"
                . " ORDER BY change_event.change_date_time DESC 
                LIMIT 10000 ";

Google Ads API Forum Advisor

unread,
Jun 29, 2021, 3:48:34 AM6/29/21
to miryamm...@gmail.com, adwor...@googlegroups.com
Hi,

Thank you for reaching out to our API support team.

So our team can take a closer look, could you share your customer ID and the complete request and response logs, with the request-id?

If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link.

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Google Logo
Peter Laurence Napa Oliquino
Google Ads API Team
 


ref:_00D1U1174p._5004Q2JWeRe:ref

Miryam Miryam

unread,
Jul 12, 2021, 3:27:43 AM7/12/21
to AdWords API and Google Ads API Forum
I replied privately almost a week ago and didn't get any updates from your side

Google Ads API Forum Advisor

unread,
Jul 12, 2021, 10:31:48 PM7/12/21
to miryamm...@gmail.com, adwor...@googlegroups.com
Hi Miryam,

Thank you for following up. I work with Peter and let me provide support to your concern.

However, it appears that you are not receiving our responses for your concerns. With this, allow me to reiterate my reply on your email, specified below, that you've sent on a private email. The first statement that you've mentioned is the possible reason for returning 0 response for those entities. The types in question returned as 0 in the API response as there is no change occurred on those entities for the given date range.

"Are the types in question returned as 0 because those fields are not actually populated due to the fact that no change occurred on that exact field, or if this is the case those types should've been returned as NULL?

Request: https://googleads.googleapis.com/v7/googleAdsService/search
Response: please find attached the complete response object returned from the endpoint
customer_id: "4994461554"
query: """
          \n
                          SELECT  change_event.resource_name, change_event.change_date_time, change_event.change_resource_name, change_event.user_email, change_event.client_type, change_event.change_resource_type, \n
                                  change_event.old_resource, change_event.new_resource, change_event.resource_change_operation, change_event.changed_fields \n
                          FROM change_event \n
                          WHERE change_event.change_date_time BETWEEN '2021-06-05 14:54:49' AND '2021-07-04 00:00:00' ORDER BY change_event.change_date_time DESC \n
                          LIMIT 10000 
          """
"

Regards,
Google Logo
Ernie John Blanca Tacata
Google Ads API Team
 


ref:_00D1U1174p._5004Q2JWeRe:ref
Reply all
Reply to author
Forward
0 new messages