Account Performance Report

[kvrvr]

Hi Team,

I'm working on "Account Performance Report". I'm getting the following
error,"ONE OR MORE REPORT JOB PARAMETERS IS INVALID". I have shared
sample code below. Please direct me where i'm going wrong.

reportJob.selectedReportType = "Account";
reportJob.aggregationTypes = new string[] {"HourlyRegardlessDate"};
............
...........
string[] customOptions = { "CustomerName" };
reportJob.selectedColumns = customOptions;



Thanks in Advance,
KVRVR

[Tino Hertlein]

Hi KVRVR,

besides the error-message you provided, there should also be a detailed trigger-message in the soap-response of your request.
Depending on the client-library you use, you should be able to extract that trigger-message (By activation of the logging-mechanism or extraction from the exception that is thrown).

The trigger-message should explain the underlying error in most cases.

Btw: your code looks correct to me...


Tino

--
Refined Labs GmbH
Landwehrstraße 17
80336 München
Tel +49 89 1392879-0
ti...@refinedlabs.com
http://www.refinedlabs.com

Sitz: München
AG München HRB 166589
Geschäftsführer:
Thomas Bindl, Stephan Seitz


-----Ursprüngliche Nachricht-----
Von: adwor...@googlegroups.com [mailto:adwor...@googlegroups.com] Im Auftrag von kvrvr
Gesendet: Dienstag, 20. Januar 2009 11:41
An: AdWords API Forum
Betreff: AdWords API Account Performance Report

[kvrvr]

Hi Tino,

Thanks for the immediate reply.
The error message goes like this when i try to get data for Account
Performance Report, "Unable to automatically step ito the server.
Connecting to the server machine 'adwords.google.com' failed. The
debugger cannot to the remote computer. This may be because the remote
computer does not exist or a firewall may be preventing communication
to the remote computer. Please see help for assistance". But i was
able to get the data for my Campaign Report. Little confusing here...

Regards,
KVRVR

On Jan 20, 4:26 pm, "Tino Hertlein" <t...@refinedlabs.com> wrote:
> Hi KVRVR,
>
> besides the error-message you provided, there should also be a detailed trigger-message in the soap-response of your request.
> Depending on the client-library you use, you should be able to extract that trigger-message (By activation of the logging-mechanism or extraction from the exception that is thrown).
>
> The trigger-message should explain the underlying error in most cases.
>
> Btw: your code looks correct to me...
>
> Tino
>
> --
> Refined Labs GmbH
> Landwehrstraße 17
> 80336 München
> Tel +49 89 1392879-0

> t...@refinedlabs.comhttp://www.refinedlabs.com

[Tino Hertlein]

Hi KVRVR,

sorry, I do not have any experience with that kind of error.
But I suppose Jeff from the API-team can help you.

Tino

--
Refined Labs GmbH
Landwehrstraße 17
80336 München
Tel +49 89 1392879-0

ti...@refinedlabs.com

http://www.refinedlabs.com

Sitz: München
AG München HRB 166589
Geschäftsführer:
Thomas Bindl, Stephan Seitz

-----Ursprüngliche Nachricht-----
Von: adwor...@googlegroups.com [mailto:adwor...@googlegroups.com] Im Auftrag von kvrvr

Gesendet: Mittwoch, 21. Januar 2009 05:12
An: AdWords API Forum
Betreff: AdWords API Re: Account Performance Report

[AdWords API Advisor]

Hello KVRVR,

You're definitely not going to be able to connect to the remote
Google AdWords API servers for debugging purposes, which is what your
IDE's debugger is attempting to do. But you should have all the
information on your end that we would need to determine what the error
is.

Instead of trying to use your IDE's debugger to connect to the server
code, what you'd need to do is examine the response message your
computer received that contained the error. Tino is correct in that
there should be a more detailed error message if you examine the full
SOAP response. You can do that locally on your end by breaking into
the debugger and checking out all of the properties of the *local*
SOAP fault (which should not require connecting your debugger to our
servers). Alternatively, and more straightforward, you could turn on
SOAP logging and show us the entire SOAP response message, including
the response errors. That should be enough for us to determine what
the root cause is.

Cheers,
-Jeff Posnick, AdWords API Team

On Jan 21, 3:35 am, "Tino Hertlein" <t...@refinedlabs.com> wrote:
> Hi KVRVR,
>

> sorry, I do not have any experience with that kind of error.
> But I suppose Jeff from the API-team can help you.
>
> Tino
>
> --
> Refined Labs GmbH
> Landwehrstraße 17
> 80336 München
> Tel +49 89 1392879-0

[kvrvr]

Hi Jeff,

Thanks for the details & clear explanation. I have shared the details
below, please share your thoughts on that. I replaced sensitive
information with "***************".



-----SoapRequest at 1/27/2009 6:05:07 PM-----
POST /api/adwords/v12/ReportService HTTP/1.0
Host: adwords.google.com
User-agent: Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client
Protocol 2.0.50727.1433)
Content-type: text/xml; charset=utf-8
Content-length: 1254
SOAPAction: "validateReportJob"
--------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Header>
<applicationToken xmlns="https://adwords.google.com/api/adwords/
v12">***************</applicationToken>
<clientEmail xmlns="https://adwords.google.com/api/adwords/
v12">***************</clientEmail>
<developerToken xmlns="https://adwords.google.com/api/adwords/
v12">***************</developerToken>
<email xmlns="https://adwords.google.com/api/adwords/
v12">***************</email>
<password xmlns="https://adwords.google.com/api/adwords/
v12">***************</password>
<useragent xmlns="https://adwords.google.com/api/adwords/
v12">AdWords API DotNet Client Library v2.0.0: </useragent>
</soap:Header>
<soap:Body>
<validateReportJob xmlns="https://adwords.google.com/api/adwords/
v12">
<job xsi:type="DefinedReportJob">
<endDay>2009-01-19</endDay>
<name>Custom Report</name>
<startDay>2009-01-19</startDay>
<aggregationTypes>HourlyRegardlessDate</aggregationTypes>
<selectedColumns>CustomerName</selectedColumns>
<selectedReportType>Account</selectedReportType>
</job>
</validateReportJob>
</soap:Body>
</soap:Envelope>
--------------------------------------------------------

-----SoapResponse at 1/27/2009 6:05:22 PM-----
Content-type: text/xml; charset=utf-8
Content-length: 1483
SOAPAction: "validateReportJob"
--------------------------------------------------------
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/
envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header>
<responseTime soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v12">8231</responseTime>
<operations soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v12">1</operations>
<units soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v12">1</units>
<requestId soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v12">***************</requestId>
</soapenv:Header>
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server.userException</faultcode>
<faultstring>One or more report job parameters is invalid.</
faultstring>
<detail>
<ns1:fault xmlns:ns1="https://adwords.google.com/api/adwords/
v12">
<ns1:code>30</ns1:code>
<ns1:message>One or more report job parameters is invalid.</
ns1:message>
<ns1:trigger> The following columns are not supported by the
Report Type Account : [CustomerName]</ns1:trigger>
</ns1:fault>
</detail>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>
--------------------------------------------------------


Thanks in Advance,
KVRVR

[kvrvr]

Hi Tino,

Thanks for the knowledge sharing.

Regards,
KVRVR

On Jan 21, 1:35 pm, "Tino Hertlein" <t...@refinedlabs.com> wrote:
> Hi KVRVR,
>

> sorry, I do not have any experience with that kind of error.
> But I suppose Jeff from the API-team can help you.
>
> Tino
>
> --
> Refined Labs GmbH
> Landwehrstraße 17
> 80336 München
> Tel +49 89 1392879-0

> > KVRVR- Hide quoted text -
>
> - Show quoted text -

[AdWords API Advisor]

Hello KVRVR,

Could you try the following? Leave out the clientEmail SOAP request
header entirely. Instead, set the crossClient attribute in the
DefinedReportJob object to "true", and optionally set the clientEmails
property of the DefinedReportJob object (which is NOT the same as the
clientEmail SOAP request header) to an array of one or more strings
containing client emails.

Does that work for you?

Cheers,
-Jeff Posnick, AdWords API Team

[kvrvr]

Hi Jeff,

Thanks for the directions. I tried with your suggestions but its the
same old story.

Regards,
KVRVR

On Jan 28, 1:00 am, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:

> > > - Show quoted text -- Hide quoted text -

[AdWords API Advisor]

Hello KVRVR,

As was the case before, could you please post a SOAP log illustrating
the issue? I'd like to confirm that the changes you made to your code
are actually reflected in the new SOAP request that is being
generated.

Cheers,
-Jeff Posnick, AdWords API Team

[kvrvr]

Hi Jeff,

I have shared the details below and replaced sensitive information
with "******". Please share your suggestions.



-----SoapRequest at 1/29/2009 1:22:18 PM-----

POST /api/adwords/v12/ReportService HTTP/1.0
Host: adwords.google.com
User-agent: Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client
Protocol 2.0.50727.1433)
Content-type: text/xml; charset=utf-8

Content-length: 1319

SOAPAction: "validateReportJob"
--------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Header>
<applicationToken xmlns="https://adwords.google.com/api/adwords/

v12">*****</applicationToken>
<clientEmail xmlns="https://adwords.google.com/api/adwords/
v12">*****</clientEmail>
<developerToken xmlns="https://adwords.google.com/api/adwords/
v12">*****</developerToken>
<email xmlns="https://adwords.google.com/api/adwords/v12">*****</

email>
<password xmlns="https://adwords.google.com/api/adwords/

v12">*****</password>

<useragent xmlns="https://adwords.google.com/api/adwords/
v12">AdWords API DotNet Client Library v2.0.0: </useragent>
</soap:Header>
<soap:Body>
<validateReportJob xmlns="https://adwords.google.com/api/adwords/
v12">
<job xsi:type="DefinedReportJob">

<clientEmails>*****</clientEmails>
<endDay>2009-01-26</endDay>
<name>Custom Report</name>
<startDay>2009-01-26</startDay>

<aggregationTypes>HourlyRegardlessDate</aggregationTypes>
<selectedColumns>CustomerName</selectedColumns>
<selectedReportType>Account</selectedReportType>
</job>
</validateReportJob>
</soap:Body>
</soap:Envelope>
--------------------------------------------------------

-----SoapResponse at 1/29/2009 1:22:28 PM-----

Content-type: text/xml; charset=utf-8
Content-length: 1483
SOAPAction: "validateReportJob"
--------------------------------------------------------
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/
envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header>
<responseTime soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/

adwords/v12">9117</responseTime>

<operations soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v12">1</operations>
<units soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/
adwords/v12">1</units>
<requestId soapenv:actor="http://schemas.xmlsoap.org/soap/actor/
next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/

adwords/v12">*****</requestId>

</soapenv:Header>
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server.userException</faultcode>
<faultstring>One or more report job parameters is invalid.</
faultstring>
<detail>
<ns1:fault xmlns:ns1="https://adwords.google.com/api/adwords/
v12">
<ns1:code>30</ns1:code>
<ns1:message>One or more report job parameters is invalid.</
ns1:message>
<ns1:trigger> The following columns are not supported by the
Report Type Account : [CustomerName]</ns1:trigger>
</ns1:fault>
</detail>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>
--------------------------------------------------------

Thanks,
KVRVR

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[AdWords API Advisor]

Hello KVRVR,

Based on that SOAP trace you haven't implemented the necessary
changes: "leave out the clientEmail SOAP request header entirely.

Instead, set the crossClient attribute in the DefinedReportJob object
to "true", and optionally set the clientEmails property of the
DefinedReportJob object (which is NOT the same as the clientEmail SOAP
request header) to an array of one or more strings containing client
emails."

If you're doing this in .NET, be sure that you set the
crossClientSpecified property to "true" in addition to setting
crossClient to "true", as that's needed in the .NET client library to
indicate that there is a value being passed in for crossClient. And
you really need to leave out the clientEmail SOAP request header,
which you're still not doing.

Cheers,
-Jeff Posnick, AdWords API Team

[kvrvr]

Hi Jeff,

I'm working on .NET environment. I specified "reportJob.crossClient =
true; reportJob.crossClientSpecified = true; ". I observed a new error
message is coming after this change .i.e. "You must supply an MCC
login to perform the current operation". Please let me know the
details.

Thanks,
KVRVR

[AdWords API Advisor]

Hello KVRVR,

That would strongly indicate that you're not following the
recommended steps. Specifically, I assume that you're still setting
the clientEmail SOAP header. Please make sure that you've taken all
the recommended steps and try again. If you're still seeing issues,
then as before I'd really need to see the entire SOAP request and
response, not just the text of the error message.

Cheers,
-Jeff Posnick, AdWords API Team