Disapproved Price assets shows as Approved when data pulled via AdsApp.report

[Karl]

Hi,

I am trying to pull all disapproved assets on campaign level, and I'm running into a problem with price assets. I am using AdsApp.report and the query:

"SELECT campaign.name, campaign.status, asset.policy_summary.approval_status, campaign_asset.status, asset.policy_summary.review_status, asset.type, asset.price_asset.price_offerings FROM campaign_asset WHERE campaign.status = 'ENABLED'"

The account has 10 campaign with one disapproved price asset each, yet when pulling the report they all come out as "APPROVED":

 

Is this a bug or am I doing something wrong?

Thanks!

[Karl]

Anyone?

[Google Ads Scripts Forum Advisor]

Hi Karl,

 

This is Yasmin from the Google Ads Scripts Team.

 

Could you please provide the following information so we're able to further investigate this and assist you?:

• Google Ads account ID or CID
• Script name
• Shareable link of the spreadsheet the script is using (You may follow this guide under Share a file publicly)

 

Kindly send the requested items via `Reply privately to author` option. If the said option is not available on your end, you may send those through the email alias `googleadsscr...@google.com` instead.

 

Best regards,

 

Yasmin Gabrielle Google Ads Scripts Team

ref:_00D1U1174p._5004Q2h2WXO:ref