Keyword Performance Report v201101 discrepency with v13

[Ernnie Sangalang]

Performed a Keyword Performance Report on both v201101 & v13 and got a huge discrepancy on data retrieved.

(ex: Total clicks v13 & webui = 5568 but v201101 = 878)

v201101 report id = 291259172
v13 report id = 1345770212

Can provide more info regarding this.

Here's a the soap xml request/response for v201101

[Aug 18 2011 22:00:23.000000 - INFO] POST /api/adwords/cm/v201101/ReportDefinitionService HTTP/1.1
Host: adwords.google.com
Connection: Keep-Alive
User-Agent: PHP-SOAP/5.2.13, gzip
Accept-Encoding: gzip, deflate
Content-Encoding: gzip
Content-Type: text/xml; charset=utf-8
SOAPAction: ""
Content-Length: 949
 
<?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/cm/v201101" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <SOAP-ENV:Header>
    <ns1:RequestHeader xsi:type="ns1:RequestHeader">
      <ns1:authToken>*****</ns1:authToken>
      <ns1:clientEmail>******</ns1:clientEmail>
      <ns1:developerToken>*****</ns1:developerToken>
      <ns1:userAgent>AwApi-PHP-2.5.1-*****</ns1:userAgent>
    </ns1:RequestHeader>
  </SOAP-ENV:Header>
  <SOAP-ENV:Body>
    <ns1:mutate>
      <ns1:operations>
        <ns1:operator>ADD</ns1:operator>
        <ns1:operand>
          <ns1:selector>
            <ns1:fields>Date</ns1:fields>
            <ns1:fields>CampaignName</ns1:fields>
            <ns1:fields>AdGroupName</ns1:fields>
            <ns1:fields>KeywordText</ns1:fields>
            <ns1:fields>KeywordMatchType</ns1:fields>
            <ns1:fields>Status</ns1:fields>
            <ns1:fields>QualityScore</ns1:fields>
            <ns1:fields>MaxCpc</ns1:fields>
            <ns1:fields>CriteriaDestinationUrl</ns1:fields>
            <ns1:fields>Impressions</ns1:fields>
            <ns1:fields>Clicks</ns1:fields>
            <ns1:fields>Ctr</ns1:fields>
            <ns1:fields>AverageCpc</ns1:fields>
            <ns1:fields>Cost</ns1:fields>
            <ns1:fields>AveragePosition</ns1:fields>
            <ns1:fields>FirstPageCpc</ns1:fields>
            <ns1:dateRange>
              <ns1:min>20110816</ns1:min>
              <ns1:max>20110816</ns1:max>
            </ns1:dateRange>
          </ns1:selector>
          <ns1:reportName>Keywords Performance Report generated by ***** (AdWords API v201101) Account: **** DateRange: 2011-08-16-2011-08-16</ns1:reportName>
          <ns1:reportType>KEYWORDS_PERFORMANCE_REPORT</ns1:reportType>
          <ns1:dateRangeType>CUSTOM_DATE</ns1:dateRangeType>
          <ns1:downloadFormat>CSV</ns1:downloadFormat>
        </ns1:operand>
      </ns1:operations>
    </ns1:mutate>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>


HTTP/1.1 200 OK
Content-Type: text/xml; charset=UTF-8
Content-Encoding: gzip
Date: Thu, 18 Aug 2011 14:00:31 GMT
Expires: Thu, 18 Aug 2011 14:00:31 GMT
Cache-Control: private, max-age=0
X-Content-Type-Options: nosniff
X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block
Content-Length: 663
Server: GSE

<?xml version="1.0"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Header>
    <ResponseHeader xmlns="https://adwords.google.com/api/adwords/cm/v201101">
      <requestId>0004aac809080bd00a4219f41d26d809</requestId>
      <operations>1</operations>
      <responseTime>268</responseTime>
      <units>400</units>
    </ResponseHeader>
  </soap:Header>
  <soap:Body>
    <mutateResponse xmlns="https://adwords.google.com/api/adwords/cm/v201101">
      <rval>
        <id>291259172</id>
        <selector>
          <fields>Date</fields>
          <fields>CampaignName</fields>
          <fields>AdGroupName</fields>
          <fields>KeywordText</fields>
          <fields>KeywordMatchType</fields>
          <fields>Status</fields>
          <fields>QualityScore</fields>
          <fields>MaxCpc</fields>
          <fields>CriteriaDestinationUrl</fields>
          <fields>Impressions</fields>
          <fields>Clicks</fields>
          <fields>Ctr</fields>
          <fields>AverageCpc</fields>
          <fields>Cost</fields>
          <fields>AveragePosition</fields>
          <fields>FirstPageCpc</fields>
          <dateRange>
            <min>20110816</min>
            <max>20110816</max>
          </dateRange>
        </selector>
        <reportName>Keywords Performance Report generated by NarraLite (AdWords API v201101) Account: **** DateRange: 2011-08-16-2011-08-16</reportName>
        <reportType>KEYWORDS_PERFORMANCE_REPORT</reportType>
        <hasAttachment>false</hasAttachment>
        <dateRangeType>CUSTOM_DATE</dateRangeType>
        <downloadFormat>CSV</downloadFormat>
        <creationTime>20110818 070028 America/Los_Angeles</creationTime>
      </rval>
    </mutateResponse>
  </soap:Body>
</soap:Envelope>

Thanks,
--Ernnie

[Ernnie Sangalang]

[Ernnie Sangalang]

Any updates on this? Can someone from adwords help us on this?

Thanks,
--Ernnie

[Eric Koleda]

Hi Ernnie,

The core of the discrepancy is that the v13 keyword report returned placement data as well, while the v201101 report only returns keywords.  The UI "Total" rows are misleading, as they are also displaying placement data totals on the keywords page.  If you are only interested in the total activity in an ad group then use the ADGROUP report instead of the KEYWORDS report.

Best,

- Eric Koleda, AdWords API Team

[Ernnie Sangalang]

Hi Eric,

Is there a way to generate a report w/ all the criteria types in one report in v201101 similar to v13 keyword report? Keyword/Placement/Vertical Performance in one Report?

Thanks,
--Ernnie

[Eric Koleda]

Hi Ernnie,

Unfortunately it isn't possible using v201101 reporting to get all criteria types in one report.  This is a feature that many developers have requested and we are investigating solutions.

Best,

- Eric

[bgraves]

Any ETA when a solution will be available? Currently, merging 3
different reports into 1 for all our accounts is an extremely painful
process.

[Eric Koleda]

Hi,

Unfortunately I don't have any updates on this.

Best,

- Eric