ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT', Trigger = 'Cannot select a combination of

[Sage Lewis]

I'm working on setting up a campaign performance report with these fields:

'CampaignName','Impressions','Clicks', 'AverageCpc', 'AveragePosition', 'ConversionRate', 'Conversions', 'EstimatedTotalConversions', 'Cost', 'AdNetworkType1', 'Device', 'ClickType'

When I add 'ClickType' I get this error:

An error has occurred: Report download failed. Underlying errors are Type = 'ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT', Trigger = 'Cannot select a combination of EstimatedTotalConversions and AdvertiserExperimentId,ClickType,HourOfDay,ImpressionTypeId,Slot,SocialAnnotationType,TargetingType', FieldPath = 'EstimatedTotalConversions'.

It appears my 'EstimatedTotalConversions' is conflicting with 'ClickType'. 

Any thoughts would be greatly appreciated.

:)

[Josh Radcliff (AdWords API Team)]

Hi,

Certain metrics are not calculated at the ClickType level, so rather than show misleading or incorrect data for those metrics, AdWords rejects any report request that combines one of those metrics with the ClickType field. This is similar to how the UI behaves - see the Report is missing sum totals section of this Help Center article.

If you need one of those metrics and you need information by ClickType, then you'll have to run two separate reports: one that includes the metric but does not include ClickType, and another that only includes ClickType-compatible metrics and includes ClickType.

Cheers,

Josh, AdWords API Team

[Sage Lewis]

Thank you so much for your speedy answer here. 

In fear of even mentioning it, EstimatedTotalConversions and ClickType are required minimum functionality. I know you can't comment on that. But because that's the case is there any possibility that down the road EstimatedTotalConversions and ClickType could be included in the same report?

Thanks again.

Sage

[Josh Radcliff (AdWords API Team)]

Hi Sage,

I think it's highly unlikely that those two fields will be allowed in the same report because EstimatedTotalConversions cannot be broken down by ClickType. See the attached screenshot, where Est. total conv has a value (49) for the Ad Group, but has double-dash (--) for each breakdown by ClickType.

Cheers,

Josh, AdWords API Team