Impressions and click date wise

[Shivam Kumar]

Hi there, I want to know impression and click event for each date. Can you please help in writing GAQL query. 

Currently I am using the below query to get impressions and click but I want to how many clicks and impressions occurred on each day.

SELECT
campaign.name,
campaign.start_date,
metrics.impressions,
metrics.clicks,
campaign.id,
campaign.advertising_channel_type
FROM campaign WHERE campaign.id IN {campaign_ids}

Thank You

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

You can use the below query to get the impressions and clicks that occurred each day.

SELECT campaign.name, 
campaign.start_date, 
metrics.impressions, 
metrics.clicks, 
campaign.id

, 
segments.date, 
campaign.advertising_channel_type 
FROM campaign 
WHERE campaign.id IN (campaign_ids) 
AND segments.date BETWEEN 'YYYY-MM-DD' AND 'YYYY-MM-DD'

I would recommend you refer to this guide on Segmentation for more information.

I hope this helps.

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tJ0bk:ref" (ADR-00235402)

Thanks,
 

Google Ads API Team