ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT@PrimaryDisplayStatus

[khanh]

I'm receiving this error:
ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT@PrimaryDisplayStatus

when running a simple campaign report.
The report runs correctly on manually, and i get the XML file that i
want.

when I call the API with the report definition id, it gives me this
error.
This report has been working everyday until now.

What can that be?

[francula]

Hi,
i have the same issue, but with the following Message:
ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT@PrimaryDisplayStatus
Regards

[Schab]

same here with
ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT@SalesCount ... :-(

[khanh]

The field @PrimaryDisplayStatus is not even a field i'm selecting for
the report and again, the manually created XML file looks good.

[Schab]

hi khanh,

i can confirm the same issue with a invalid field "@SalesCount".
The error also just occurs by catching report by API.
Getting the report via user-interface works.

Regards,
Christian

[Dmitry]

It looks like I have the same issue: MCC report with Perl API failed:

error ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT@CriteriaParameters at .../MCCReportDownloader.pm line 106.

This report has been working everyday until now and continue to run ok manually. 

[Jon Brown]

Anyone get an answer here yet? Since the 8th, my campaign report has
been failing with:

INVALID_FIELD_NAME_FOR_REPORT@UserAndExperimentStatus

[Tony]

I also had problems with field names in the XML and It appeared that
the documentation was a little out of date. The simplest way to find
out for sure is to call a method of the v201003 or higher API on the
ReportDefinitionService object. It has a method called
getReportFields() which returns you an XML document with all the
available fields you can have. If you them use this as the master list
of fields then your problem is solved!

Documentation is here at
http://code.google.com/apis/adwords/docs/reference/latest/ReportDefinitionService.html#getReportFields

Regards
Tony

[Jon Brown]

Tony, thanks, but these are reports created via the AdWords web
interface. I have only selected the basic fields, but clearly behind
the scenes something is wrong.

When I pull the report definitions via the API, I see the bad field(s)
in the selector:

<fields>Date</fields><fields>UserAndExperimentStatus</
fields><fields>KeywordText</fields><fields>CampaignName</
fields><fields>AdGroupName</fields><fields>PrimaryDisplayStatus</
fields><fields>MaxCpc</fields><fields>Clicks</
fields><fields>Impressions</fields><fields>Ctr</
fields><fields>AverageCpc</fields><fields>Cost</
fields><fields>AveragePosition</fields><fields>DestinationUrl</
fields><fields>QualityScore</fields><fields>FirstPageCpc</
fields><fields>KeywordMatchType</fields><fields>AverageCpm</
fields><predicates><field>PrimaryDisplayStatus</
field><operator>NOT_IN</operator><values>CAMPAIGN_DELETED</values></
predicates><predicates><field>PrimaryDisplayStatus</
field><operator>NOT_IN</operator><values>ADGROUP_DELETED</values></
predicates><predicates><field>Status</field><operator>IN</
operator><values>ACTIVE</values><values>PAUSED</values></
predicates><predicates><field>IsNegative</field><operator>EQUALS</
operator><values>false</values></
predicates><predicates><field>CriteriaType</field><operator>IN</
operator><values>KEYWORD</values></
predicates><dateRange><min>20110803</min><max>20110809</max></
dateRange>

Maybe I could write some code to modify this report definition via the
API, but clearly Google changed something to break this since I've
been using this report for months.

[Tony]

Hi there your right in the sense that something has changed and what
used to work now doesn't and I know how annoying that can be. My point
was simply that for reports that are needed regularily you would be
better insulated from such problems by creating them completely via
the API at the point you need them. Its really easy to do and the
results are available in seconds, and you can also do it across
multiple threads for speed. If you are on a tight deadline and the
problem is NOT going to be fixed by Google any time soon then it might
be an option for you.

Good luck

Tony

[Jon Brown]

Understood. There was some combination of things that wouldn't allow
me to do it that way at the time. I think it had to do with old versus
new reports for MCC account cross-client reports.

[opalepatrick]

I have been having the same problem over on another thread, and
without wishing to suggest that this won't work for some, I do know
that I created reports yesterday directly from the API and still have
the same sort of problem: This seems to be the favourite

ReportDefinitionError.INV...@selector.selector

although this one copmes up as well

ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT@PrimaryDisplayStatus

Anyway, in a normal forum some moderator would merge the threads,
but.... :-)

[Kevin Winter]

Hi All,

  I just wanted to let everyone know we are aware of the problem.  This only seems to affect reports that were created in the UI and are being downloaded via the API.  We're still researching the best solution given that some of the fields in the reports are not allowed in API reports.  In the meantime, redefining the report via the API and using that moving forward permanently fixes the issue for an individual report (since it will not longer have the fields that only the UI can add).

We'll be sure to let you know when we have a fix.

- Kevin Winter

AdWords API Team

[opalepatrick]

Actually that is not strictly true Kevin. I re-created a report via
the API yesterday and it did exactly the same thing?

[Kevin Winter]

Hi,

  Could you provide the sanitized SOAP XML request that created the report?

Also, if you use a GET to retrieve the reportDefinition, does it have the same fields as when you created it?

- Kevin Winter

[opalepatrick]

Hi, straightforward keyword_performance_report with 13 fields as
required. Checked it just with GetReportDefinitions and it hasnt
changed.

I knew I would get asked for SOAP XML, never done it, so how doers one
turn on SOAP logging (for the record)?

Thanks

[Kevin Winter]

Hi,

  Which client library are you using?  They each have their own method of turning it on: http://code.google.com/apis/adwords/docs/clientlibraries.html

- Kevin Winter

[opalepatrick]

v201008 Kevin

[opalepatrick]

Sorry - PHP :-)

[Kevin Winter]

Hi,

  The README has instructions on how to do it: http://code.google.com/p/google-api-adwords-php/source/browse/trunk/README?r=196#130

- Kevin

[khanh]

We need to grab the report from the UI and download as the report has
a column (Phone Cost) that I can get from creating the report via the
API.

We are using .net client library: Google.Api.Ads.AdWords.v201101;

[opalepatrick]

Well this morning twice I got
'ReportDefinitionError.INV...@selector.selector',
then the third time, it worked (this is a re-created report via the
API), still working.

However, I also cannot get a report because $user->LogAll(); gives me
a fatal error, $user->LogDefaults(); does not. I have checked and
double-checked the includes and paths to Logger.php but get this error
no matter what on more than one report. I appreciate this may be an
unrelated matter, but as I am getting totally sporadic behaviour, and
I cant get a SOAP XML...?

On Aug 11, 8:07 pm, Kevin Winter <Kevin.Win...@google.com> wrote:
> Hi,

>   The README has instructions on how to do it:http://code.google.com/p/google-api-adwords-php/source/browse/trunk/R...
>
> - Kevin

[Kevin Winter]

Hi,

  To save time, how about you just send me the php code that is defining the report definition?  I should be able to reconstruct how the report should look like from that and attempt to reproduce.

[Kevin Winter]

We have an update for this issue:

https://groups.google.com/forum/#!topic/adwords-api/sHvSoAQTy54

[khanh]

This does NOT solve my problem.
The UI report has a column called Phone Cost.
I can not retrieve Phone Cost (it's not a field available) from the
API and must generate the column/report via the UI.

Why should retrieving the report which is XML break?

If i manually save the XML file from the UI and import it manually it
still works.
The idea was to have the API automatically download the UI report.

[Dmitry]

In my report via UI I defined 2 segments: day and keyword/placement. How I can do it via API ?

[Kevin Winter]

Hi,

  Unfortunately, this is not a supported field via the API at this time.  Since the field does not have any analog in the API, we felt it does not make sense to return it in API reports.  This is consistent with the existing report definition behavior which does not allow these fields to be defined in new API reports.

[Dmitry]

Hi,

If I understood correct Ad Performance Report doesn't contain "keyword" field anymore but contains "keywordid" field.
If immediately after Ad Performance Report I run Keyword Performance Report I may find there the corresponding keyword itself.

But what about segment definition (by the way: segment means aggregation ?).

Regards,
  Dmitry

[Kevin Winter]

Hi Dmitry,

  When you choose a field such as Date, the statistics are aggregated for that date.  For example, lets say you choose the fields Clicks and Date for the date range of the previous seven days.  You might see the following data returned:

Date,Clicks

20110809,45

20110810,22

20110811,55

20110812,33

20110813,40

20110814,44

20110815,34

This effectively aggregates the stats on the day they occurred.  This is how segementations are done via the API.

[khanh]

So is there no resolution to this?
How are we to get the Phone Costs?

[Kevin Winter]

Hi,

  Phone information is not currently supported by the API, therefore the reports will not allow you to download them at this time.

- Kevin Winter

[Kevin Winter]

Hi Dmitry,

  It sounds like you should run some type of Placements report and a Keyword report: http://code.google.com/apis/adwords/docs/appendix/reports.html

- Kevin Winter

[Matt]

ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT@PrimaryDisplayStatus???

Anyone have an examples on how to do the below in C#?

https://groups.google.com/forum/#!topic/adwords-api/sHvSoAQTy54

Code worked great until google felt compelled to change it

On Aug 12, 4:32 pm, khanh <i...@exactamedia.com> wrote:

[Kevin Winter]

Hi,

  You might want to take a look at the available fields in our documentation and choose fields that are valid for the API: http://code.google.com/apis/adwords/docs/appendix/reports.html