Change service not working properly for Ad_Group_Ads

46 views
Skip to first unread message

F B

unread,
May 13, 2019, 6:39:27 AM5/13/19
to AdWords API and Google Ads API Forum

change_service
= f"""
SELECT
    change_status.resource_status,
    change_status.resource_name,
    change_status.last_change_date_time,
    change_status.resource_type,
    change_status.campaign,
    change_status.ad_group,
    change_status.ad_group_ad,
    change_status.ad_group_criterion,
    change_status.campaign_criterion


FROM
    change_status
WHERE
    change_status.resource_status = ADDED
    AND change_status.resource_type = AD_GROUP_AD
ORDER BY
    change_status.last_change_date_time DESC
LIMIT 10000
"""

Does not yield any results (although there have been multiple ads added)

F B

unread,
May 13, 2019, 6:44:22 AM5/13/19
to AdWords API and Google Ads API Forum
Actually it seems that the Problem is related to the ADDED.

It would appear that:
  • The change_status.resource_status relates to the object highest in the hierarchy (i.e. cmapaign?)
  • Adding Ads and Keywords is considered to be a Change and not an Add 

googleadsapi...@google.com

unread,
May 13, 2019, 5:09:54 PM5/13/19
to AdWords API and Google Ads API Forum
Hi Fabian, 

The results will be filtered based on the resource_status and the resource_type. The results returned will depend on the resource_type. For example, for AD_GROUP, campaign and ad_group fields will be set. Let me know if you have any questions.

Regards,
Bharani, Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

F B

unread,
May 13, 2019, 5:17:48 PM5/13/19
to AdWords API and Google Ads API Forum
Hi Bharani,

yes I understand that. But even in a test account where I explicitly created (i.e. added) a whole lot of ad_group_ads (respectively ad_group_criterion).

The query:

SELECT
    change_status
.resource_status,
    change_status
.resource_name,
    change_status
.resource_type,
    change_status
.ad_group_ad,

FROM
    change_status
WHERE
    change_status
.resource_status = ADDED
    AND change_status
.resource_type = AD_GROUP_AD

will not return any results. However, not that this query 

SELECT
    change_status
.resource_status,
    change_status
.resource_name,
    change_status
.resource_type,
    change_status
.ad_group_ad,
FROM
    change_status
WHERE
    change_status
.resource_status = CHANGED
    AND change_status
.resource_type = AD_GROUP_AD

will.

I find this quite odd, because to me added and changed are quite different things.

googleadsapi...@google.com

unread,
May 14, 2019, 5:17:29 PM5/14/19
to fbo...@gmail.com, AdWords API and Google Ads API Forum
Hi,

I've reproduced the behavior you described and filed an issue with the change status team to investigate. I'll reply back as soon as I have more information from them.

Thanks,
Josh, Google Ads API Team


=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@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 "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/9ad019e5-bad4-4f66-9c60-243c2cee09e3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

F B

unread,
May 21, 2019, 10:13:27 AM5/21/19
to AdWords API and Google Ads API Forum
Hi Josh,

cool. Any news here?

Cheers
Fabian

Google Ads API Forum Advisor Prod

unread,
May 21, 2019, 12:08:54 PM5/21/19
to fbo...@gmail.com, adwor...@googlegroups.com
Hi,

I don't have an update just yet, but I asked the team for one again just now. I'll be sure to let you know once I hear from them.

Thanks,
Josh, Google Ads API Team

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