locked
Different data between KeywordPerformance request through API and the data displayed in BingADS web interface RRS feed

  • Question

  • Currently we are trying to fetch our data using Bing ADS web service. We run a job daily in the evening to retrieve the data from the previous day. However the data does not correspond at all with the data displayed in the BingAds web interface. Per each row, the data seems to always be less than the one displayed in Bing interface. Also the total sum  (of clicks or impressions) of all rows is less compared with the count in BingAds web interface. I am sending the following request:

    <?xml version="1.0" encoding="UTF-8"?>
    <SOAP-ENV:Envelope xmlns:tns="https://bingads.microsoft.com/Reporting/v9" xmlns:ns0="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns2="https://bingads.microsoft.com/Reporting/v9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
       <SOAP-ENV:Header>
          <tns:CustomerAccountId>XXXX</tns:CustomerAccountId>
          <tns:CustomerId>XXXXX</tns:CustomerId>
          <tns:DeveloperToken>XXXXX</tns:DeveloperToken>
          <tns:Password>XXXXXX</tns:Password>
          <tns:UserName>gymondosem</tns:UserName>
       </SOAP-ENV:Header>
       <ns1:Body>
          <ns2:SubmitGenerateReportRequest>
             <ns2:ReportRequest xsi:type="ns2:KeywordPerformanceReportRequest">
                <ns2:Format>Csv</ns2:Format>
                <ns2:Language>English</ns2:Language>
                <ns2:ReportName>Keyword Performance</ns2:ReportName>
                <ns2:ReturnOnlyCompleteData>false</ns2:ReturnOnlyCompleteData>
                <ns2:Aggregation>Daily</ns2:Aggregation>
                <ns2:Columns>
                   <ns2:KeywordPerformanceReportColumn>KeywordId</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>Keyword</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>AccountId</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>TimePeriod</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>CampaignName</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>CampaignId</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>AdGroupId</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>AdGroupName</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>Impressions</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>Clicks</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>Ctr</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>Spend</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>AveragePosition</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>ExtendedCost</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>Revenue</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>TotalVisits</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>Conversions</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>BidMatchType</ns2:KeywordPerformanceReportColumn>
                   <ns2:KeywordPerformanceReportColumn>DeliveredMatchType</ns2:KeywordPerformanceReportColumn>
                </ns2:Columns>
                <ns2:Filter>
                   <ns2:DeviceType>Computer</ns2:DeviceType>
                </ns2:Filter>
                <ns2:MaxRows>1000</ns2:MaxRows>
                <ns2:Scope>
                   <ns2:AccountIds>
                      <ns0:long>XXXXX</ns0:long>
                   </ns2:AccountIds>
                </ns2:Scope>
                <ns2:Sort>
                   <ns2:KeywordPerformanceReportSort>
                      <ns2:SortColumn>Clicks</ns2:SortColumn>
                      <ns2:SortOrder>Ascending</ns2:SortOrder>
                   </ns2:KeywordPerformanceReportSort>
                </ns2:Sort>
                <ns2:Time>
                   <ns2:PredefinedTime>Yesterday</ns2:PredefinedTime>
                </ns2:Time>
             </ns2:ReportRequest>
          </ns2:SubmitGenerateReportRequest>
       </ns1:Body>
    </SOAP-ENV:Envelope>

    Example for our main keyword from API:

    Clicks 9, Impressions: 12

    Example for our main keyword from BingAds Interface:

    Clicks 13, Impressions: 20

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

    Total count Impressions API: 63

    Total count Impressions BingAds Interface: 461

    Appreciate your help


    • Edited by Gymondo Tuesday, March 17, 2015 4:45 PM
    Tuesday, March 17, 2015 4:44 PM

Answers

  • Hello.

    I noticed that you are using a filter in the API, which may cause the discrepancy. 

    <ns2:Filter>
        <ns2:DeviceType>Computer</ns2:DeviceType>
    </ns2:Filter>

    Please try again without the filter to see if the data matches.

    I hope this helps!

    Tuesday, March 17, 2015 11:18 PM

All replies

  • Hello.

    I noticed that you are using a filter in the API, which may cause the discrepancy. 

    <ns2:Filter>
        <ns2:DeviceType>Computer</ns2:DeviceType>
    </ns2:Filter>

    Please try again without the filter to see if the data matches.

    I hope this helps!

    Tuesday, March 17, 2015 11:18 PM
  • Thanks for the quick response, indeed that was the problem. I blindly copy pasted an example from somewhere which contained such filter.

    Thanks again!

    • Marked as answer by Gymondo Wednesday, March 18, 2015 9:36 AM
    • Unmarked as answer by Gymondo Wednesday, March 18, 2015 9:36 AM
    Wednesday, March 18, 2015 9:36 AM