licks*
* FROM ad_group_ad_asset_view*
* WHERE segments.date*
* BETWEEN '2022-12-01' AND '2023-01-31'*
* AND metrics.cost_micros > 0*
* AND ad_group_ad.ad.type = 'DISCOVERY_MULTI_ASSET_AD'*
please help that would much appreci
Hi,
I'm Trying to get assets that are approved but getting in UNSPECIFIED
category.
Please help me in this regard. Thank You
*Current Query *
SELECT
asset.id ,
asset.name ,
asset.policy_summary.approval_status
FROM asset
WHERE
asset.type IN ('IMAGE', 'YOUTUBE_VIDEO')
AND asset.policy_summary
,
'metrics.interaction_rate',
'metrics.interactions',
'metrics.percent_new_visitors',
'metrics.top_impression_percentage',
'metrics.value_per_all_conversions',
'metrics.value_per_all_conversions_by_conversion_date',
'm
Hi
I'm trying to get insights of assets. I'm able to get insights of assets
but facing problem regarding assets of responsive search ad. is there any
way to get that. I'm attaching query so for please help me out what I'm
doing wrong.
SELECT
ad_group_ad.ad.id,
asset.id,