Basic AWQL request - CAMPAING_PERFORMANCE split by "date" only

Question

I face strange behavior on my Adwords API response, which brakes a logic of our reports.

Here is my AWQL: SELECT Date,Ctr FROM CAMPAIGN_PERFORMANCE_REPORT DURING 20181206, 20181206

Response: Report Day,CTR 2018-12-06,0.00% 2018-12-06,3.23%

Why do I get 2 rows of results, it should be only one (same date). I asked only for one date. Same thing with a different range of dates.

It feels to me like Adwords splits the results by CampaignIds. It is possible to get "total" result, split by date?

Answer 1

CAMPAIGN_PERFOMANCE_REPORT is segmented by campaign. If you want Ctr by date across an account you need to use ACCOUNT_PERFORMANCE_REPORT instead