locked
Report Filtering RRS feed

  • Question

  • I am trying to figure out how to use the filter settings.

    The examples use this:

    <ns1:Filter>
        <ns1:AdDistribution>Search</ns1:AdDistribution>
        <ns1:LanguageAndRegion>UnitedStates</ns1:LanguageAndRegion>
    </ns1:Filter>

    However I've noticed the spec says
    nillable="true", so I am assuming you can pass nil/null for the api to ignore this filter.

    The soap I have tried is this.

    <ns1:Filter>
        <ns1:AdDistribution xsi:nil="true"/>
        <ns1:LanguageAndRegion xsi:nil="true"/>
    </ns1:Filter>

    However it causes an error.

    I can get round the AdDistribution by setting it to:

    <ns1:AdDistribution>Search Content</ns1:AdDistribution>


    But how do you not limit by LanguageAndRegion?


    Hackzilla

    Friday, June 6, 2008 4:03 PM

Answers

  • Hi Hackzilla,

    Can you please try the same report again now? We've made some improvements that should eliminate this error.

     

    Wednesday, July 2, 2008 7:16 PM

All replies

  • From the documentation:

    http://msdn.microsoft.com/en-us/library/bb671591.aspx?s=26

    Remarks

    If this property is null, no language and country/region filtering is
    performed. Otherwise, this property contains a combination of one or
    more of the LanguageAndRegionReportFilter enumeration values.



    Hackzilla
    Monday, June 9, 2008 10:13 AM
  • Hi Hack

    Are you still having issues with this? If so, what is the error that you're seeing?

    This seems like an excellent question on which to get advice from other users in the forum. If there are no other responses, I'll research it with the support engineers. A little more information on the type of error may help.

    Thank you for using the forums,

     

    Chris

     

    Tuesday, June 10, 2008 4:56 AM
  • Hi Chris,

    Yeah this is still a problem.

    The complete output is:

    Code Snippet
    Last SOAP request:

    <soap-env:envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://adcenter.microsoft.com/api/advertiser/v5"><soap-env:body><ns1:getreportstatusrequest><ns1:reportrequestid>41808771</ns1:reportrequestid></ns1:getreportstatusrequest></soap-env:body></soap-env:envelope>
    ReportRequestId: 41808771
    Waiting another 5 minutes.
    Total wait time so far is 0 minutes.
    Last SOAP request:

    <soap-env:envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://adcenter.microsoft.com/api/advertiser/v5"><soap-env:body><ns1:getreportstatusrequest><ns1:reportrequestid>41808771</ns1:reportrequestid></ns1:getreportstatusrequest></soap-env:body></soap-env:envelope>

    ReportStatus: Pending
    Waiting another 5 minutes.
    Total wait time so far is 5 minutes.
    Last SOAP request:

    <soap-env:envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://adcenter.microsoft.com/api/advertiser/v5"><soap-env:body><ns1:getreportstatusrequest><ns1:reportrequestid>41808771</ns1:reportrequestid></ns1:getreportstatusrequest></soap-env:body></soap-env:envelope>

    ReportStatus: Pending
    Waiting another 5 minutes.
    Total wait time so far is 10 minutes.
    Last SOAP request:

    <soap-env:envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://adcenter.microsoft.com/api/advertiser/v5"><soap-env:body><ns1:getreportstatusrequest><ns1:reportrequestid>41808771</ns1:reportrequestid></ns1:getreportstatusrequest></soap-env:body></soap-env:envelope>
    ReportStatus: Pending
    Waiting another 5 minutes.
    Total wait time so far is 15 minutes.
    Last SOAP request:

    <soap-env:envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://adcenter.microsoft.com/api/advertiser/v5"><soap-env:body><ns1:getreportstatusrequest><ns1:reportrequestid>41808771</ns1:reportrequestid></ns1:getreportstatusrequest></soap-env:body></soap-env:envelope>

    ReportStatus: Pending
    Waiting another 5 minutes.
    Total wait time so far is 20 minutes.
    Last SOAP request:

    <soap-env:envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://adcenter.microsoft.com/api/advertiser/v5"><soap-env:body><ns1:getreportstatusrequest><ns1:reportrequestid>41808771</ns1:reportrequestid></ns1:getreportstatusrequest></soap-env:body></soap-env:envelope>

    ReportStatus: Pending
    Waiting another 5 minutes.
    Total wait time so far is 25 minutes.
    Last SOAP request:

    <soap-env:envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://adcenter.microsoft.com/api/advertiser/v5"><soap-env:body><ns1:getreportstatusrequest><ns1:reportrequestid>41808771</ns1:reportrequestid></ns1:getreportstatusrequest></soap-env:body></soap-env:envelope>
    ReportStatus: Error
    Error occurred in GetReportStatus (Error, stdClass Object
    (
        [ReportRequestStatus] =&gt; stdClass Object
            (
                [ReportDownloadUrl] =&gt;
                [Status] =&gt; Error
            )

    )
    )
    </soap-env:envelope>


     

     

     


    The strange thing about this, is that it seems to try to produce a report, by the fact that it waits so long.

    If the filters contain no-null data it all seems to work and I get to download the report.


    Hackzilla

    Tuesday, June 10, 2008 9:05 AM
  • I could get around LanguageAndRegionReportFilter by specifying all the countries, but I am after a solution that allows me to not worry about extra countries being added in.

    The same goes for
    AdDistribution.

    I am after a report that literally gives me all costs for a particular date range, with no filtering.


    Hackzilla
    Tuesday, June 10, 2008 9:09 AM
  • Thanks Hack,

    I'm looking into it and will post back soon as I can find more info.

    Thank you for using the forum.

    Chris

     

    Tuesday, June 10, 2008 5:42 PM
  • Hi Chris,

    Any news?


    Hackzilla
    Thursday, June 12, 2008 1:50 PM
  •  

    Hi Hack,

     

    Support engineering is researching this still. I expect to hear back by tomorrow.

    Sorry for the delay.

     

    Thursday, June 12, 2008 9:52 PM
  • Hi Hack

    It's taking a little more time to track down the answer on this, we'll post back as soon as we can.

     

    -Chris

    Monday, June 16, 2008 5:36 PM
  • Hi Hackzilla,

    In the scope of your QueueReport() request, are you specifying one or multiple accounts/campaigns/etc?

    Wednesday, June 18, 2008 5:51 PM
  •  Mirena Chausheva - MSFT wrote:

    Hi Hackzilla,

    In the scope of your QueueReport() request, are you specifying one or multiple accounts/campaigns/etc?



    At the moment, we are only specifying one account id, and no campaigns.
    Ideally we want to bring back multiple accounts.

    We are trying to achieve a daily dump of yesterdays activity for all of the accounts.


    Hackzilla
    Thursday, June 19, 2008 8:21 AM
  •  

    Hi Hackzilla,

     

    To be able to investigate further what might be going wrong, I will have to look at the specific details of your request. Do you mind posting a snippet of your SOAP request here? Please make sure you remove all login credentials and IDs from the xml before posting.

    Tuesday, June 24, 2008 5:11 PM
  •  Mirena Chausheva - MSFT wrote:

     

    Hi Hackzilla,

     

    To be able to investigate further what might be going wrong, I will have to look at the specific details of your request. Do you mind posting a snippet of your SOAP request here? Please make sure you remove all login credentials and IDs from the xml before posting.



    Code Snippet

    <?xml version="1.0" encoding="UTF-8"?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://adcenter.microsoft.com/api/advertiser/v5" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns2="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <SOAP-ENV:Header>
    <ns1:ApplicationToken><ns1:Value></ns1:Value></ns1:ApplicationToken>
    <ns1:DeveloperToken><ns1:Value>****</ns1:Value></ns1:DeveloperToken>
    <ns1:UserCredentials>
    <ns1:Password>****</ns1:Password>
    <ns1:Username>****</ns1:Username>
    </ns1:UserCredentials>
    </SOAP-ENV:Header>
    <SOAP-ENV:Body>
    <ns1:QueueReportRequest>
    <ns1:ReportRequest xsi:type="ns1:KeywordPerformanceReportRequest">
    <ns1:Format>Xml</ns1:Format>
    <ns1:Language>English</ns1:Language>
    <ns1:ReportName>My Report</ns1:ReportName>
    <ns1:ReturnOnlyCompleteData>false</ns1:ReturnOnlyCompleteData>
    <ns1:Aggregation>Daily</ns1:Aggregation>
    <ns1:Columns>
    <ns1:KeywordPerformanceReportColumn>AccountId</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>AccountName</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>CampaignName</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>CampaignId</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>AdGroupName</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>AdGroupId</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>Keyword</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>TimePeriod</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>Clicks</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>Impressions</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>Spend</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>AveragePosition</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>AverageCpc</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>ProductName</ns1:KeywordPerformanceReportColumn>
    <ns1:KeywordPerformanceReportColumn>Conversions</ns1:KeywordPerformanceReportColumn>
    </ns1:Columns>
    <ns1:Filter>
    <ns1:AdDistribution>Search Content</ns1:AdDistribution>
    <ns1:LanguageAndRegion xsi:nil="true"/>
    </ns1:Filter>
    <ns1:Scope>
    <ns1:AccountIds>
    <ns2:int>***</ns2:int>
    <ns2:int>***</ns2:int>
    </ns1:AccountIds>
    </ns1:Scope>
    <ns1:Time>
    <ns1:PredefinedTime>Yesterday</ns1:PredefinedTime>
    </ns1:Time>
    </ns1:ReportRequest>
    </ns1:QueueReportRequest>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>


    Hackzilla
    Wednesday, June 25, 2008 8:41 AM
  • Hi Hackzilla,

    Can you please try the same report again now? We've made some improvements that should eliminate this error.

     

    Wednesday, July 2, 2008 7:16 PM
  • Hi Mirena,

    I've just tried it, and its now working perfectly, thanks


    Hackzillla
    Thursday, July 3, 2008 10:03 AM