Why is asset.policy_summary.approval_status and asset.policy_summary.review_status fields empty from ad_group_ad_asset_view?

2023-03-13 Thread pg
Hi, I'm trying to get asset.policy_summary.approval_status and asset.policy_summary.review_status fields from ad_group_ad_asset_view, but whenever I do it I get None back for these 2 fields. Here's my query "SELECT ad_group_ad_asset_view.policy_summary, ad_group_ad.ad.id, ad_group.id, campaign

Keyword Performance Report - Drive template access

2019-02-13 Thread pg . pixart
Hi everyone, I have an issue with the Keyword Performance Report, since this script requires a copy of a Google Drive sheet but the template is unavailable. The sheet requires authorisation but this is taking more time than expected. Is there someone that had the same issue/knows how to overcome