Maybe try this request for data you are looking for
SELECT
campaign.id,
campaign.name,
campaign.status,
campaign.advertising_channel_type,
campaign.start_date,
campaign.end_date,
campaign.targeting_setting.target_restrictions,
metrics.impressions,
metrics.clicks,
metrics.average_cpm,
metrics.cost_micros,
ad_group.id,
ad_group.name,
ad_group_criterion.keyword.text,
ad_group_ad.ad.id,
ad_group_ad.ad.final_urls,
ad_group_ad.ad.image_ad.media_file,
ad_group_ad.ad.video_ad.media_file,
segments.date
FROM campaign
WHERE segments.date DURING LAST_30_DAYS
Blobr - AI agents to optimise Google Ads Spending