CAMPAIGN_PERFORMANCE_REPORT : Filtering by ClickType nulls out the total row in the CSV

[Stephen Yeargin]

I have a report definition that looks like:

<reportDefinition>
<selector>
<fields>CampaignId</fields>
<fields>CampaignName</fields>
<fields>Impressions</fields>
<fields>Clicks</fields>
<fields>Ctr</fields>
<fields>Cost</fields>
<fields>AverageCpc</fields>
<fields>AverageCpm</fields>
<fields>ConvertedClicks</fields>
<fields>ConversionsManyPerClick</fields>
<fields>ConversionRateManyPerClick</fields>
<fields>ClickConversionRate</fields>
<fields>ValuePerConvertedClick</fields>
<fields>ConversionValue</fields>
<fields>ConversionRateManyPerClick</fields>
<predicates><field>ClickType</field><operator>EQUALS</operator><values>URL_CLICKS</values></predicates>
<dateRange>
<min>20150507</min>
<max>20150605</max>
</dateRange>
</selector>
<reportName>Campaign Performance Report</reportName>
<reportType>CAMPAIGN_PERFORMANCE_REPORT</reportType>
<dateRangeType>CUSTOM_DATE</dateRangeType>
<downloadFormat>CSV</downloadFormat>
<includeZeroImpressions>false</includeZeroImpressions>
</reportDefinition>

And returns this CSV:

"Campaign Performance Report (May 7, 2015-Jun 5, 2015)"
Campaign ID,Campaign,Impressions,Clicks,CTR,Cost,Avg. CPC,Avg. CPM,Converted clicks,Conversions,Conv. rate,Click conversion rate,Value / converted click,Total c
onv. value
221722162,Manage Season Tickets,412,19,4.61%,20900000,1100000,50728155,5,10,52.63%,26.32%,1.0,5.0
Total, --, --, --, --, --, --, --, --, --, --, --, --, --

As you can see, it's returning data, but the total line is mysteriously empty. I use this CSV file (when not filtered by ClickType) without issue to generate a single "stat" metric in the UI by simply reading the last row of the CSV. However, applying the filter causes this row to turn up empty.

Is there a workaround for this?

[Umesh Dengale]

Hello,

When the clickType field is used in the report, report filed with metric behavior (e.g. Impressions, cost etc.) will have an impact. In case of impressions, the Ads can serve with multiple click types displayed, impressions may be double counted and the totals may not be accurate. Due to above reason when you use clickType, last line Total does not have any values. Here is previous forum discussion on using the clickType in the report.

Regards,

Umesh, AdWords API Team.