How to get the number of clicks, views, and digested amount

[RYO O]

Hello.

Right now, I'm running an API to get the monthly or daily number of clicks, number of displays, and digested amount by month or by day.

In order to get the data for each day of the year, we need to run the API 365 times.

How can I get the data for 365 days in a single API run?

Thanks,

[Google Ads API Forum Advisor]

Hello,

Thank you for reaching out to us.

On your query, you can actually set the date range to capture the 365 days. See sample query below using the campaign view. You can also check available reports here.

SELECT metrics.cost_micros, segments.date FROM campaign WHERE segments.date >= '2020-01-01' AND segments.date <= '2021-12-31'

Also, can you confirm the following fields below so we can also provide the actual report field equivalent?

• get the monthly or daily number of clicks -> you can use the metrics.clicks field
• number of displays
• digested amount

Regards,

Mark Kevin Albios Google Ads API Team

 

ref:_00D1U1174p._5004Q2OWLXn:ref

[廖真]

Hi

I try this GAQL, but got nothing. Has this feature been modified?

request: SELECT metrics.cost_micros, segments.date FROM campaign WHERE segments.date >= '2020-01-01' AND segments.date <= '2021-12-31'

response: {"fieldMask": "metrics.costMicros,segments.date"}

[Google Ads API Forum Advisor]

Hello,

Thanks for getting back to us.

So our team can further check on this, can you share to us the following details below?

• Customer ID
• login-customer-id
• Complete API logs (request and response with request-id)

Please send the requested details via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Regards,