Is it possible (or what's the best way) to fetch metrics and thumbnails (image or video assets) for Performance Max campaigns?
For other types of ads I'm using this query:
SELECT
metrics.impressions,
metrics.clicks,
campaign.name,
ad_group_ad.ad.name,
ad_group_ad.ad.image_ad.image_url,
ad_group_ad.ad.responsive_display_ad.marketing_images,
ad_group_ad.ad.type,
ad_group_ad.ad.id,
ad_group_ad.ad.video_ad.video.asset,
ad_group_ad.ad.video_responsive_ad.videos,
ad_group_ad.ad.app_ad.images
FROM
ad_group_ad
WHERE
segments.date BETWEEN '2022-07-01'
AND '2022-07-31'
AND ad_group_ad.ad.type IN('IMAGE_AD', 'IN_FEED_VIDEO_AD', 'RESPONSIVE_DISPLAY_AD', 'VIDEO_TRUEVIEW_IN_STREAM_AD', 'VIDEO_BUMPER_AD', 'VIDEO_RESPONSIVE_AD', 'APP_AD', 'VIDEO_NON_SKIPPABLE_IN_STREAM_AD')
AND metrics.impressions > 0
ORDER BY
metrics.impressions DESC
and I get almost everything I need with a single query. I can extract assets for returned rows separately if needed.
Is there a similar way to do it with Performance Max campaigns or do I have to resort to fetching metrics separately and then make a separate query to
asset_group_asset and then map the rows myself?