Google Groups Home
Help | Sign in
Un - supported report columns
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  4 messages - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
rajeesh  
View profile
 More options Jul 18, 11:01 am
From: rajeesh <rajee...@gmail.com>
Date: Fri, 18 Jul 2008 08:01:15 -0700 (PDT)
Local: Fri, Jul 18 2008 11:01 am
Subject: Un - supported report columns
Hi,

I want to pull an ad performance report with columns customer name,
customerid, impressions,clicks,cost.
but I am getting the following exception:

faultCode: {http://schemas.xmlsoap.org/soap/
envelope/}Server.userException
 faultSubcode:
 faultString: One or more report job parameters is invalid.
 faultActor:
 faultNode:
 faultDetail:
        {https://adwords.google.com/api/adwords/v12}fault:
       <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 Creative : [CustomerName, ExternalCustomerId]</
ns1:trigger>

These 2 columns need MCC account to access. But I am using MCC
account. The code sequence is as follows:
            String[] customOptions =
            {
                                "CustomerName"                ,
                                "ExternalCustomerId",
                                "Campaign"                    ,
                                "AdGroup"                     ,
                                "Keyword"                     ,
                                "DescriptionLine1"    ,
                                "DescriptionLine2"    ,
                                "DescriptionLine3"    ,
                                "VisibleUrl"          ,
                                "CreativeId"          ,
                                "CreativeType"                ,
                                "AdWordsType"         ,
                                "DestinationURL"      ,
                                "CampaignStatus"      ,
                                "Impressions"         ,
                                "Clicks"                      ,
                                "Cost"                                ,
                                "AveragePosition"
                             };
      myReportJob.setSelectedColumns(customOptions);

can you help me to solve this issue?


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
AdWords API Advisor Google employee  
View profile
 More options Jul 18, 4:49 pm
From: AdWords API Advisor <adwordsapiadvi...@google.com>
Date: Fri, 18 Jul 2008 13:49:46 -0700 (PDT)
Local: Fri, Jul 18 2008 4:49 pm
Subject: Re: Un - supported report columns
Hello Rajeesh,

 While you may be specifying a MCC account in your <email> header, can
you confirm that you're not passing anything for the <clientEmail> or
<clientCustomerId> headers? If you set those then you're no longer
going to be working in the context of your MCC account.

 If you're sure that you're not setting either of those headers, could
you please provide the value of the <requestId> header from your SOAP
response so I can look up your request in our logs?

Cheers,
-Jeff Posnick, AdWords API Team

On Jul 18, 11:01 am, rajeesh <rajee...@gmail.com> wrote:


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "Un - supported report columns (URL Performance Reports)" by mona.venning
mona.venning  
View profile
 More options Jul 25, 7:27 am
From: "mona.venning" <mona.venn...@googlemail.com>
Date: Fri, 25 Jul 2008 04:27:30 -0700 (PDT)
Local: Fri, Jul 25 2008 7:27 am
Subject: Re: Un - supported report columns (URL Performance Reports)
Hi Jeff and Rajeesh,

Just wondering how that issue was resolved because I seem to be facing
a similar issue running a top level URL performance report with
AdWords API v12 and receiving report validation errors where ‘One or
more report job parameters are invalid’: those being customerid.
Just to confirm: I am not passing anything for the <clientEmail> or
<clientCustomerId> headers.

Here’s the SOAP RequestId:
<requestId soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
soapenv:mustUnderstand="0" xmlns=https://adwords.google.com/api/
adwords/v12>
2cb31fa7124b1deb6950628064f1cd5f
</requestId>

The SOAP Request:

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/
envelope/" xmlns:ns1="https://adwords.google.com/api/adwords/v12"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<SOAP-ENV:Header>
<ns1:email>xxxxx</ns1:email>
<ns1:password>xxxx</ns1:password>
<ns1:useragent>Top level Activity Data Import</ns1:useragent>
<ns1:applicationToken>xxxxx</ns1:applicationToken>
<ns1:developerToken>xxxxxx</ns1:developerToken>
</SOAP-ENV:Header>

<SOAP-ENV:Body>
<ns1:validateReportJob>
<ns1:job xsi:type="ns1:DefinedReportJob">
<ns1:crossClient>false</ns1:crossClient>
<ns1:endDay>2008-07-24</ns1:endDay>
<ns1:name>URL Performance Report For: 2008-07-24</ns1:name>
<ns1:startDay>2008-07-24</ns1:startDay>
<ns1:aggregationTypes>Daily</ns1:aggregationTypes>
<ns1:selectedColumns>customerid</ns1:selectedColumns>
<ns1:selectedColumns>acctname</ns1:selectedColumns>
<ns1:selectedColumns>CampaignId</ns1:selectedColumns>
<ns1:selectedColumns>Campaign</ns1:selectedColumns>
<ns1:selectedColumns>AdGroupId</ns1:selectedColumns>
<ns1:selectedColumns>AdGroup</ns1:selectedColumns>
<ns1:selectedColumns>KeywordId</ns1:selectedColumns>
<ns1:selectedColumns>Keyword</ns1:selectedColumns>
<ns1:selectedColumns>KeywordTypeDisplay</ns1:selectedColumns>
<ns1:selectedColumns>KeywordDestUrlDisplay</ns1:selectedColumns>
<ns1:selectedColumns>AdWordsType</ns1:selectedColumns>
<ns1:selectedColumns>AveragePosition</ns1:selectedColumns>
<ns1:selectedColumns>Impressions</ns1:selectedColumns>
<ns1:selectedColumns>Clicks</ns1:selectedColumns>
<ns1:selectedColumns>Cost</ns1:selectedColumns>
<ns1:selectedColumns>Conversions</ns1:selectedColumns>
<ns1:selectedColumns>LeadCount</ns1:selectedColumns>
<ns1:selectedColumns>DestinationURL</ns1:selectedColumns>
<ns1:selectedColumns>KeywordStatus</ns1:selectedColumns>
<ns1:selectedColumns>AdGroupStatus</ns1:selectedColumns>
<ns1:selectedColumns>CampaignStatus</ns1:selectedColumns>
<ns1:selectedColumns>MaximumCPC</ns1:selectedColumns>
<ns1:selectedColumns>KeywordMinCPC</ns1:selectedColumns>
<ns1:selectedReportType>Url</ns1:selectedReportType>
</ns1:job></ns1:validateReportJob>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

The SOAP Response:

<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">104</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">2cb31fa7124b1deb6950628064f1cd5f</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>Unknown Column Type:customerid</ns1:trigger>
</ns1:fault>
</detail>
</soapenv:Fault>
</soapenv:Body>

</soapenv:Envelope>

Thanks in advance.

Kind Regards,
- Mona Venning


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
AdWords API Advisor Google employee  
View profile
 More options Jul 25, 11:50 am
From: AdWords API Advisor <adwordsapiadvi...@google.com>
Date: Fri, 25 Jul 2008 08:50:50 -0700 (PDT)
Local: Fri, Jul 25 2008 11:50 am
Subject: Re: Un - supported report columns (URL Performance Reports)
Hello Mona,

 I think you're running into something different than Rajeesh. Those
column names you're requesting are legitimately invalid. The list of
supported column names in your SOAP requests is at

  http://www.google.com/apis/adwords/developer/adwords_api_report_url.html

Specifically, instead of asking for the "customerid" and "acctname"
columns, you should specify the "ExternalCustomerId" and
"CustomerName" columns. (The report XML that is returned will have the
columns labeled as "customerid" and "acctname". Yes, having to keep
track of different names for the request and responses is definitely
less than ideal.)

 Please note that "ExternalCustomerId" and "CustomerName" are only
valid columns if you're running the report from an MCC account. And if
you are running the report from an MCC account, you should be setting
<crossClient> to true and specifying one or more value for the
<clientEmails> SOAP parameter (which is distinct from the
"clientEmail" SOAP header).

Cheers,
-Jeff Posnick, AdWords API Team

On Jul 25, 7:27 am, "mona.venning" <mona.venn...@googlemail.com>
wrote:


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google