Campaign Performance Report aggregation issue

[Wes Thompson]

I'm not sure if there's a better place to report a possible bug in the reporting API so please redirect me if there is.  But it seems like there is a problem with the Campaign Performance Report not aggregating the ad group data correctly.  I am querying click-through rate for only one campaign ID which has four ad groups in it and I am not specifying an ad group ID.  However, the value being returned is not the average of all four.  The issue is the same in the native AdWords UI.  I have CTR selected on the chart and it is displaying one number (5.45%).  However, in the table below that chart there are four ad groups with the values 5.45%, 3.64%, 6.60%, and 0%.  This does not average out to 5.45%.  If I add AdGroupName to the SELECT of the API query then it returns all four values correctly.  The issue is the same for any campaign and time period and any metric; the aggregated average values do not come out correctly unless I separate my query by AdGroupName and average them myself.

I have attached a screen shot of the native UI that shows the issue.

I will give my access token and specific query information to someone from the AdWords team if necessary.

[Dannison Yao (AdWords API Team)]

Hi Wes,

It seems that your concerns are more on the statistical calculations of your report data. You may open your concern on the Advertisers Community Forum as the product owners are better equipped to provide you with the answers you need.

Regards,

Dannison

AdWords API Team