How do I get Day wise breakdown of Metrics like Clicks, Impressions, CTR etc related to campaigns?

[anirudh maddy]

What should be the order by query term to break down the results day wise?

Here is what I tried :

 

SELECT  campaign.name, customer.currency_code, metrics.impressions, metrics.clicks, metrics.ctr, metrics.average_cpc, metrics.average_position, metrics.all_conversions , metrics.cost_per_conversion   ,metrics.cost_per_all_conversions FROM campaign WHERE segments.date DURING LAST_30_DAYS  ORDER BY campaign.start_date ASC

With the above query, I'm getting data which is grouped on a campaign level. How can I break it down to each day?

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for reaching out. To be able to segment the results per day, you would need to add the segments.date field on your SELECT statement. Could you try this and confirm if you will get the results you are looking for?

Regards,
Dannison
Google Ads API Team

ref:_00D1U1174p._5001UAqiyF:ref