Report API - get one row for one group, not multiple rows

[Chen k.]

Hello,

I want to get the data from report request as one row for one group, and i will explain by example:

I send to request that i want to get: Clicks and Impressions, split by Date (from 14-05-2019 - 15-05-2019)

the expected result is 2 rows, one row for one date:

'2019-05-14', 200, 500

'2019-05-15', 300, 550

but, the result contain many rows, like:

'2019-05-14', 70, 120

'2019-05-14', 100, 300

'2019-05-14', 30, 80

'2019-05-15', 200, 350

'2019-05-15', 100, 200

If i set the property: skipReportSummary = false, the total row contain total data for all dates.

Why the result comes as multiple rows,

and how can i get the result by rows for each dimension?

I hope I was clear,

Thanks!

[Google Ads API Forum Advisor Prod]

Hi,

Thanks for reaching out. To better assist you, can you provide the complete report definition you are using? A possible reason that I can think on top of my mind is probably because you have other segment fields besides the Date segment. 

Regards,
Dannison
Google Ads API Team

ref:_00D1U1174p._5001UAqNRW:ref

[Chen k.]

Hello Dannison,

Thanks for your reply.

Actually, I found the reason of this problem, in this link:

https://stackoverflow.com/questions/53650063/basic-awql-request-campaing-performance-split-by-date-only

It occurred because I ask the clicks and impressions from the KEYWORDS_PERFORMANCE_REPORT, so the results segmented by keyword.

I tried to get this metrics from ACCOUNT_PERFORMANCE_REPORT and the result came right!

But if I want to continue get the results from the KEYWORDS_PERFORMANCE_REPORT, what can I do? Do you have an idea?

Thank you for helping!

[Google Ads API Forum Advisor Prod]

Hi,

The StackOverFlow link you provided explained it correctly. Unfortunately, this is the expected behavior when downloading the Keywords Performance Report or any criteria reports. The reports you downloaded will always be segmented on the entity level of your report. Let me know if you have further clarifications.