INVALID_FIELD_NAME_FOR_REPORT unexpected error

[Oksana Sulyma]

Hi Google Ads support team!

We use Adwords API v201809 and we started to get unexpected error at March 19:

"Report download error: ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT - Cannot select a combination of ConversionTypeName and AbsoluteTopImpressionPercentage,ActiveViewCpm,ActiveViewCtr,ActiveViewImpressions,ActiveViewMeasurability,ActiveViewMeasurableCost,ActiveViewMeasurableImpressions,ActiveViewViewability,AllConversionRate,AverageCost,AverageCpc,AverageCpe,AverageCpm,AverageCpv,AverageFrequency,AveragePageviews,AveragePosition,AverageTimeOnSite,BounceRate,ClickAssistedConversionValue,ClickAssistedConversions,ClickAssistedConversionsOverLastClickConversions,Clicks,ContentBudgetLostImpressionShare,ContentImpressionShare,ContentRankLostImpressionShare,ConversionRate,Cost,CostPerAllConversion,CostPerConversion,CostPerCurrentModelAttributedConversion,Ctr,EngagementRate,Engagements,GmailForwards,GmailSaves,GmailSecondaryClicks,ImpressionAssistedConversionValue,ImpressionAssistedConversions,ImpressionAssistedConversionsOverLastClickConversions,ImpressionReach,Impressions,InteractionRate,InteractionTypes,Interactions,InvalidClickRate,InvalidClicks,NumOfflineImpressions,NumOfflineInteractions,OfflineInteractionRate,PercentNewVisitors,RelativeCtr,SearchAbsoluteTopImpressionShare,SearchBudgetLostAbsoluteTopImpressionShare,SearchBudgetLostImpressionShare,SearchBudgetLostTopImpressionShare,SearchClickShare,SearchExactMatchImpressionShare,SearchImpressionShare,SearchRankLostAbsoluteTopImpressionShare,SearchRankLostImpressionShare,SearchRankLostTopImpressionShare,SearchTopImpressionShare,TopImpressionPercentage,VideoQuartile100Rate,VideoQuartile25Rate,VideoQuartile50Rate,VideoQuartile75Rate,VideoViewRate,VideoViews"

There are two problems around this error. 

1. It is temporary - when I repeat the same request I get data successfully;

2. We don't request any fields from this incompatible fields list.

Is it some known API issue? I also see similar errors in our logs for 03/03, but then these errors we gone until 03/19.

I'll be happy to share more details in private message. 

Thanks in advance guys!

Oksana

[Oksana Sulyma]

Forgotten to write that this error occurs on the stage of getting the Campaign Performance Report.

[Johann Picot]

Hi Oksana, 
I've run into the same issues as you have on the very same dates. 

I dug around in Google Ads Developer Blog and I found this blog post from January 14, 2021 which announced some new selection restrictions regarding some conversion fields combinations (which was supposed to come into effect on February 15, 2021): 

https://ads-developers.googleblog.com/2021/01/changes-to-conversion-columns-in.html

Unfortunately, these changes have not been reflected in the official documentation for the Campaign Performance Report as the fields sub-sections display an outdated list of field incompatibility selection.... 

Hope this helps!

Johann

[Google Ads API Forum Advisor Prod]

Hi All,

Thank you for the raising your concern on this forum thread.

@Oksana, there is no such issue that has been reported to our team yet. With this, could you provide the following details via Reply privately to author option to investigate?

• Customer ID
• Complete report definition used when this error occurred
• The logs generated on your console where we can see the error and the timestamp on when this happened
• Successfully generated report after repeating the same report

@Johann, the incompatibility of specific fields discussed on that blog is also documented in Campaign Performance Report. You can see it when you inspect the field discussed on that blog in the said document and as an example, ConversionAdjustment is not compatible with AbsoluteTopImpressionPercentage, ActiveViewCpm, ActiveViewCtr and so on.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2DxgWq:ref

[Johann Picot]

Hey, 
Thanks for your reply on the docs issue. 

However, unless I'm missing something here, I do think some parts of the documentation are not up-to-date yet: 

Take the 'CostPerAllConversion' metric for instance in the CAMPAIGN_PERFORMANCE_REPORT docs:  

The docs only mention incompatibility with the combined selection of one of : ['ConversionAdjustment', 'ConversionAdjustmentLagBucket', 'ConversionLagBucket', 'HourOfDay']

Yet, the Adwords Blog post I mentioned in my earlier reply above states that 'CostPerAllConversion' is now incompatible with the combined selection of several other fields like 'ConversionTypeName' for example. This has now become a reality in practice since March 19th, 2021 according to my own logs, getting the INVALID_FIELD_NAME_FOR_REPORT error upon trying to select these two fields together.

However the docs I mentioned above for that specific report and field have not been updated to reflect those latest changes as far as I can see... 

If I did miss something here, I'd be glad to know! 

Thanks,

Johann

[Oksana Sulyma]

@Johann, thanks so much for the information which you've provided! This makes a lot of sense.

For the reports which fail I request the next combination of fields:

'CampaignId',
'Date',
'ConversionTypeName',
'ConversionCategoryName',
'ConversionAttributionEventType',
'ConversionLagBucket',
'ConversionAdjustmentLagBucket',
'ExternalConversionSource',
'AdNetworkType1',
'ConversionAdjustment',
'LabelIds',
'Labels',
'Amount',
'Conversions',
'ConversionValue',
'AllConversions',
'AllConversionValue',
'CrossDeviceConversions',
'ConversionRate',

And if looks like problematic metric is 'ConversionRate'.

So now I'm +1 to Johan's question on proper documentation version.

[Google Ads API Forum Advisor Prod]

Hello,

Thanks for pointing this out. I've passed this information to the team so that our documentation will be up to date.

Cheers,
Anthony

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q2DxgWq:ref

[joel]

I also reported this issue on March 4th (https://groups.google.com/g/adwords-api/c/LZfwrb3duaE/m/awDPr2STAwAJ) but I didn't follow-up because it self-resolved. This issue is sporadic and occurs infrequently, I can't recreate it consistently. I also don't believe it's NOT a documentation issue because the requested fields should be allowed together and always have been.

Joel

[joel]

Sorry, meant to simply say it's not a documentation issue.

[Oksana Sulyma]

Hi Joel,

If this could help, in my case (I've provided requested fields in comment above) I got the next error: 

ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORTCannot select a combination of ConversionTypeName and AbsoluteTopImpressionPercentage,ActiveViewCpm,ActiveViewCtr,ActiveViewImpressions,ActiveViewMeasurability,ActiveViewMeasurableCost,ActiveViewMeasurableImpressions,ActiveViewViewability,AllConversionRate,AverageCost,AverageCpc,AverageCpe,AverageCpm,AverageCpv,AverageFrequency,AveragePageviews,AveragePosition,AverageTimeOnSite,BounceRate,ClickAssistedConversionValue,ClickAssistedConversions,ClickAssistedConversionsOverLastClickConversions,Clicks,ContentBudgetLostImpressionShare,ContentImpressionShare,ContentRankLostImpressionShare,ConversionRate,Cost,CostPerAllConversion,CostPerConversion,CostPerCurrentModelAttributedConversion,Ctr,EngagementRate,Engagements,GmailForwards,GmailSaves,GmailSecondaryClicks,ImpressionAssistedConversionValue,ImpressionAssistedConversions,ImpressionAssistedConversionsOverLastClickConversions,ImpressionReach,Impressions,InteractionRate,InteractionTypes,Interactions,InvalidClickRate,InvalidClicks,NumOfflineImpressions,NumOfflineInteractions,OfflineInteractionRate,PercentNewVisitors,RelativeCtr,SearchAbsoluteTopImpressionShare,SearchBudgetLostAbsoluteTopImpressionShare,SearchBudgetLostImpressionShare,SearchBudgetLostTopImpressionShare,SearchClickShare,SearchExactMatchImpressionShare,SearchImpressionShare,SearchRankLostAbsoluteTopImpressionShare,SearchRankLostImpressionShare,SearchRankLostTopImpressionShare,SearchTopImpressionShare,TopImpressionPercentage,VideoQuartile100Rate,VideoQuartile25Rate,VideoQuartile50Rate,VideoQuartile75Rate,VideoViewRate,VideoViewsConversionTypeName
For me the ConversionRate is 'new' in this list and this is not in Campaign Performance Report documentation.

And for our case the issue is also irregular, looks like this restriction from https://ads-developers.googleblog.com/2021/01/changes-to-conversion-columns-in.html was rolled out to the part of servers or something :)

[Google Ads API Forum Advisor Prod]

Hi Joel and Oksana,

Thank you for providing further information.

If you can provide the following details via Reply privately to author option, it will be very helpful in our investigation to address it:

• Customer ID
• Complete report definition used when this error occurred
• The logs generated on your console where we can see the error and the timestamp on when this happened
• Successfully generated report after repeating the same report

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2DxgWq:ref