Statistics aggregations

[Artem Savchenko]

Hello,

Is it possible to get aggregate statistic for some period? I have query:

SELECT
  customer.id,
  metrics.average_cpc,
  metrics.clicks,
  metrics.ctr,
  metrics.impressions,
  metrics.cost_micros,
  segments.date
FROM customer
WHERE segments.date BETWEEN '$dateStart' AND '$dateEnd'";

With this query I get statistics for each day, between $dateStart and $dateEnd. But I need to get the aggregation for the period. Is is possible?

With kind regards, 

Artem Savchenko.

[Google Ads API Forum Advisor]

Hi Artem,

Thanks for reaching out to the Google Ads API Forum.

In order to get metric statistics aggregation for the for a certain date period, have you tried to see the response when setting the value of summaryRowSetting to SUMMARY_ROW_ONLY value? If not, you may use the summaryRowSetting in your Search request and see if this helps you. 

Regards,

Yasar Google Ads API Team

 

 

ref:_00D1U1174p._5004Q2W69MM:ref

[Artem Savchenko]

Yeah, It worked!

Thank you!

Bets, 

Artem.