Hello Google Ads API Team,
I have been trying for days to fetch policy violation details
(`approval_status`, `policy_topic_entries`, and `evidences`) for all
campaign types using GAQL, but every query I try is failing with errors.
My goal is simple: I want to get the exact policy reasons for any asset,
ad, or keyword that is "Not Approved" or "Approved (Limited)".
Here are the queries I have tried and the errors I am getting:
1. For Performance Max (`asset_group_asset`):
```
SELECT
campaign.id,
asset_group_asset.policy_summary.approval_status,
asset_group_asset.policy_summary.policy_topic_entries
FROM asset_group_asset
WHERE asset_group_asset.policy_summary.approval_status != 'APPROVED'
```
Error: `PROHIBITED_FIELD_IN_SELECT_CLAUSE` for
`asset_group_asset.policy_summary`.
2. For Standard Ads (`ad_group_ad`):
```
SELECT
campaign.id,
ad_group_ad.policy_summary.approval_status,
ad_group_ad.policy_summary.policy_topic_entries
FROM ad_group_ad
WHERE ad_group_ad.policy_summary.approval_status != 'APPROVED'
```
Error: `PROHIBITED_FIELD_IN_SELECT_CLAUSE` for `ad_group_ad.policy_summary`.
3. For Keywords (`keyword_view`):
```
SELECT
campaign.id,
ad_group_criterion.policy_summary.approval_status,
ad_group_criterion.policy_summary.policy_topic_entries
FROM keyword_view
WHERE ad_group_criterion.policy_summary.approval_status != 'APPROVED'
```Error: `UNRECOGNIZED_FIELD` for
`ad_group_criterion.policy_summary.approval_status`.
---
I have tried every combination I can think of. It seems impossible to
select `policy_summary` or its sub-fields from these resources.
Could you please provide the single, correct GAQL query for each of these
three resources (`asset_group_asset`, `ad_group_ad`, and `keyword_view`)
that will successfully return the policy violation details?
Thank you.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"(Deprecated) 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 visit
https://groups.google.com/d/msgid/adwords-api/7a97d24c-155e-4a2e-a515-592159938e17n%40googlegroups.com.
