SEARCH_QUERY_PERFORMANCE_REPORT: ReportDefinitionError.INVALID_FIELD_NAME_FOR

Discussion:

SEARCH_QUERY_PERFORMANCE_REPORT: ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT

Akoudad Marvin

2014-10-28 17:43:28 UTC

Hello !

I just begin to use Adwords API and more specifically the reports.

But SEARCH_QUERY_PERFORMANCE_REPORT doesn't work, in fact i want to get
Query, Clicks, etc... but i've got this error:
ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT (I verified this fields
are in the report and for information, KEYWORDS_PERFORMANCE_REPORT works)

Log:

<reportDefinition>
<selector>
<fields>Query</fields>
<fields>Clicks</fields>
<fields>Impressions</fields>
<fields>Ctr</fields>
<fields>AverageCpc</fields>
<fields>Cost</fields>
<fields>AveragePosition</fields>
<fields>ConversionsManyPerClick</fields>
<predicates>
<field>Status</field>
<operator>NOT_IN</operator>
<values>REMOVED</values>
</predicates>
<dateRange>
<min>20141024</min>
<max>20141024</max>
</dateRange>
</selector>
<reportName>Search_query_performance_report_2014_10_24</reportName>
<reportType>SEARCH_QUERY_PERFORMANCE_REPORT</reportType>
<dateRangeType>CUSTOM_DATE</dateRangeType>
<downloadFormat>CSV</downloadFormat>
<includeZeroImpressions>false</includeZeroImpressions>
</reportDefinition>

Response Code: 400
Error Message: Report download failed. Underlying errors are
Type = 'ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT', Trigger =
'Status', FieldPath = ''.

Any idea for help ?

Thanks and good day.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-***@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+***@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+***@googlegroups.com.
Visit this group at http://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/930f0f53-c839-4408-b25b-e313efb1cdf6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Michael Cloonan (AdWords API Team)

2014-10-29 13:31:53 UTC

Permalink

Hello,

If you look at the error message you will see that the "Trigger" is the
field named "Status". If you look at the report definition for this report
<https://developers.google.com/adwords/api/docs/appendix/reports#search-query>,
you will see that there is no field named "Status". You are not selecting
this field, but you are trying to filter on it. You can only select or
filter on fields that exist within the report definition.

Regards,
Mike, AdWords API Team

Post by Akoudad Marvin
Hello !
I just begin to use Adwords API and more specifically the reports.
But SEARCH_QUERY_PERFORMANCE_REPORT doesn't work, in fact i want to get
ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT (I verified this fields
are in the report and for information, KEYWORDS_PERFORMANCE_REPORT works)
<reportDefinition>
<selector>
<fields>Query</fields>
<fields>Clicks</fields>
<fields>Impressions</fields>
<fields>Ctr</fields>
<fields>AverageCpc</fields>
<fields>Cost</fields>
<fields>AveragePosition</fields>
<fields>ConversionsManyPerClick</fields>
<predicates>
<field>Status</field>
<operator>NOT_IN</operator>
<values>REMOVED</values>
</predicates>
<dateRange>
<min>20141024</min>
<max>20141024</max>
</dateRange>
</selector>
<reportName>Search_query_performance_report_2014_10_24</reportName>
<reportType>SEARCH_QUERY_PERFORMANCE_REPORT</reportType>
<dateRangeType>CUSTOM_DATE</dateRangeType>
<downloadFormat>CSV</downloadFormat>
<includeZeroImpressions>false</includeZeroImpressions>
</reportDefinition>
Response Code: 400
Error Message: Report download failed. Underlying errors are
Type = 'ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT', Trigger =
'Status', FieldPath = ''.
Any idea for help ?
Thanks and good day.

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-***@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+***@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+***@googlegroups.com.
Visit this group at http://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/98a1e3f3-96d4-4f3e-a9ba-8fcc82c47840%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Akoudad Marvin

2014-10-29 13:42:03 UTC

Permalink

You're right and that work !

Thank's for your response.

On Wednesday, October 29, 2014 2:31:53 PM UTC+1, Michael Cloonan (AdWords

Post by Michael Cloonan (AdWords API Team)
Hello,
If you look at the error message you will see that the "Trigger" is the
field named "Status". If you look at the report definition for this report
<https://developers.google.com/adwords/api/docs/appendix/reports#search-query>,
you will see that there is no field named "Status". You are not selecting
this field, but you are trying to filter on it. You can only select or
filter on fields that exist within the report definition.
Regards,
Mike, AdWords API Team

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-***@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+***@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+***@googlegroups.com.
Visit this group at http://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/400887ae-9819-4804-8795-31669b6df058%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Akoudad Marvin

2014-10-29 10:35:34 UTC

Permalink

Resolve ! I remove filter STATUS (i forget because i used for another
Report).

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-***@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+***@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+***@googlegroups.com.
Visit this group at http://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ba990c0f-3ceb-4963-9e91-ce6e4a32a002%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.