*
* 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 appreciated.
Thank You!
Regards
Sadia Ar
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
',
'metrics.video_quartile_p50_rate',
'metrics.video_quartile_p75_rate',
'metrics.video_view_rate',
'metrics.video_views',
'metrics.view_through_conversions'
]
Thakns,
Best Regards,
Sadia Arooj
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https
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,