query = """
SELECT segments.date,
customer.descriptive_name,
campaign.advertising_channel_sub_type,
campaign.advertising_channel_type,
campaign.campaign_budget,
campaign.start_date,
campaign.end_date,
campaign.status,
ad_group.effective_target_cpa_micros,
ad_group.status,
ad_group.type,
ad_group_ad.ad.type,
ad_group_ad.ad.final_urls,
ad_group_ad.ad_strength,
metrics.interactions,
metrics.impressions,
metrics.clicks,
metrics.ctr,
metrics.cost_micros,
metrics.conversions
FROM ad_group_ad
WHERE segments.date = '2023-11-01'
"""
Thank you in advance for your help.
![]() |
Google Ads API Team |