Ad Metrics Report

[Ben Miller]

Can someone help with a request I'm trying to make?

I'm trying to get historical metric data for ads. Each request I make is coming in over 1 Gb.

I think I need to query a different resource but I'm not sure.

At the end of the day I need the following

allConversions,

averageCpm,

clicks,

conversions,

costMicros,

impressions,

averageCost,

averageCpc,

costPerConversion

Here is my query

SELECT segments.date,

metrics.clicks,

metrics.conversions,

metrics.impressions,

metrics.cost_micros,

metrics.all_conversions,

metrics.average_cpc,

metrics.average_cpe,

metrics.average_cpm,

metrics.average_cpv,

metrics.average_cost,

metrics.cost_per_conversion

FROM ad_group_ad

WHERE segments.date >= 'start_date' AND segments.date <= 'end_date'

ORDER BY segments.date ASC

Ideally I could add a GROUP BY segments.date and the request would come back grouped already.

Right now I loop through all the results and add to a huge array until everything is aggregated. I just need the results in a by day format for charting purposes.

Can someone please help?

Thanks,

Ben

Using: Google Ads API v6

[Google Ads API Forum Advisor Prod]

Hi Ben,

This issue appears to be caused by either the number of ads in your account and/or the duration of your date range. I'd recommend using a smaller date range and adding more filters in your report query. If you continue to face issues, please provide me the full report query and your CID.

Cheers,
Anthony

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q2DuTgU:ref

[Ben Miller]

Yeah I understand why it's happening. I'm trying to see if there's a better endpoint to call to get those stats.

[Google Ads API Forum Advisor Prod]

Hi Ben,

The ad_group_ad resource is the only way to get performance data on your ads through the API.

Regards,