Different metric value between SEARCH_QUERY_PERFORMANCE_REPORT and AD_PERFORMANCE_REPORT

[Dũ Đoàn]

- I send request to get report for reportType = SEARCH_QUERY_PERFORMANCE_REPORT and reportType = AD_PERFORMANCE_REPORT.

- After summary data, I see the summary value of metrics are different between 2 above reportType. For example:

+ With reportType = SEARCH_QUERY_PERFORMANCE_REPORT

   . Sum(impressions) = 105

   . Sum(clicks) = 29

   . Sum(cost) = 14644000000

+ With reportType = AD_PERFORMANCE_REPORT

   . Sum(impressions) = 150

   . Sum(clicks) = 27

   . Sum(cost) = 1493000000

=> So, why the total of metric between 2 above reportType are different.

- My request of 2 above reportType, please help me to check it, thank you very much!

+ With reportType = SEARCH_QUERY_PERFORMANCE_REPORT

Request made: Service: reportdownload Method: POST clientCustomerId: xxx URL: https://adwords.google.com//api/adwords/reportdownload/v201809 

HTTP request:

accept-encoding: [gzip]

authorization: REDACTED

user-agent: [Adwords Axis (AwApi-Java, Common-Java/4.1.0, Java/1.8.0_241, maven, ReportDownloader)]

developertoken: REDACTED

clientcustomerid: xxx

skipreportheader: true

skipreportsummary: true

includezeroimpressions: false

Content:

__rdxml: <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<reportDefinition xmlns:ns2="https://adwords.google.com/api/adwords/cm/v201809">

<ns2:selector>

<ns2:fields>Date</ns2:fields>

<ns2:fields>CampaignId</ns2:fields>

<ns2:fields>CampaignName</ns2:fields>

<ns2:fields>AdGroupId</ns2:fields>

<ns2:fields>AdGroupName</ns2:fields>

<ns2:fields>Device</ns2:fields>

<ns2:fields>AdNetworkType1</ns2:fields>

<ns2:fields>Query</ns2:fields>

<ns2:fields>KeywordTextMatchingQuery</ns2:fields>

<ns2:fields>QueryMatchTypeWithVariant</ns2:fields>

<ns2:fields>Impressions</ns2:fields>

<ns2:fields>Clicks</ns2:fields>

<ns2:fields>Cost</ns2:fields>

<ns2:fields>ViewThroughConversions</ns2:fields>

<ns2:fields>Conversions</ns2:fields>

<ns2:fields>ConversionValue</ns2:fields>

<ns2:fields>AllConversions</ns2:fields>

<ns2:fields>CrossDeviceConversions</ns2:fields>

<ns2:fields>AbsoluteTopImpressionPercentage</ns2:fields>

<ns2:fields>TopImpressionPercentage</ns2:fields>

<ns2:dateRange>

<ns2:min>20200601</ns2:min>

<ns2:max>20200601</ns2:max>

</ns2:dateRange>

</ns2:selector>

<ns2:reportName>dsp_report_adwords_search_query_145196642_600721841142200</ns2:reportName>

<ns2:reportType>SEARCH_QUERY_PERFORMANCE_REPORT</ns2:reportType>

<ns2:dateRangeType>CUSTOM_DATE</ns2:dateRangeType>

<ns2:downloadFormat>GZIPPED_CSV</ns2:downloadFormat>

</reportDefinition>

+ With reportType = AD_PERFORMANCE_REPORT

Request made: Service: reportdownload Method: POST clientCustomerId: xxx URL: https://adwords.google.com//api/adwords/reportdownload/v201809 

HTTP request:

accept-encoding: [gzip]

authorization: REDACTED

user-agent: [Adwords Axis (AwApi-Java, Common-Java/4.1.0, Java/1.8.0_241, maven, ReportDownloader)]

developertoken: REDACTED

clientcustomerid: xxx

skipreportheader: true

skipreportsummary: true

includezeroimpressions: false

Content:

__rdxml: <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<reportDefinition xmlns:ns2="https://adwords.google.com/api/adwords/cm/v201809">

<ns2:selector>

<ns2:fields>Date</ns2:fields>

<ns2:fields>CampaignId</ns2:fields>

<ns2:fields>CampaignName</ns2:fields>

<ns2:fields>AdGroupId</ns2:fields>

<ns2:fields>AdGroupName</ns2:fields>

<ns2:fields>AdNetworkType1</ns2:fields>

<ns2:fields>Id</ns2:fields>

<ns2:fields>Headline</ns2:fields>

<ns2:fields>AdType</ns2:fields>

<ns2:fields>Description</ns2:fields>

<ns2:fields>HeadlinePart1</ns2:fields>

<ns2:fields>HeadlinePart2</ns2:fields>

<ns2:fields>Description1</ns2:fields>

<ns2:fields>Description2</ns2:fields>

<ns2:fields>DevicePreference</ns2:fields>

<ns2:fields>ImageAdUrl</ns2:fields>

<ns2:fields>Device</ns2:fields>

<ns2:fields>DisplayUrl</ns2:fields>

<ns2:fields>CreativeDestinationUrl</ns2:fields>

<ns2:fields>Labels</ns2:fields>

<ns2:fields>Impressions</ns2:fields>

<ns2:fields>Clicks</ns2:fields>

<ns2:fields>ViewThroughConversions</ns2:fields>

<ns2:fields>Conversions</ns2:fields>

<ns2:fields>ConversionValue</ns2:fields>

<ns2:fields>Cost</ns2:fields>

<ns2:fields>CreativeFinalAppUrls</ns2:fields>

<ns2:fields>CreativeFinalMobileUrls</ns2:fields>

<ns2:fields>CreativeFinalUrls</ns2:fields>

<ns2:fields>AllConversions</ns2:fields>

<ns2:fields>CrossDeviceConversions</ns2:fields>

<ns2:fields>BusinessName</ns2:fields>

<ns2:fields>ShortHeadline</ns2:fields>

<ns2:fields>LongHeadline</ns2:fields>

<ns2:fields>AbsoluteTopImpressionPercentage</ns2:fields>

<ns2:fields>TopImpressionPercentage</ns2:fields>

<ns2:dateRange>

<ns2:min>20200601</ns2:min>

<ns2:max>20200601</ns2:max>

</ns2:dateRange>

</ns2:selector>

<ns2:reportName>dsp_report_adwords_listing_ad_report_145196643_600811224237200</ns2:reportName>

<ns2:reportType>AD_PERFORMANCE_REPORT</ns2:reportType>

<ns2:dateRangeType>CUSTOM_DATE</ns2:dateRangeType>

<ns2:downloadFormat>GZIPPED_CSV</ns2:downloadFormat></reportDefinition>

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for reaching out. The Search Query Performance Report gets metrics from the search term level while the Ad Performance Report gets metrics at the ad level so it is expected that there would be some discrepancies. You can see here for how to map the Search Query report to the UI and here for how to map the Ad report to the UI. If there are any discrepancies between the values in the UI and what is returned from the API, please share your client customer ID via Reply privately to author so I can further investigate the issue.

Regards,
Mitchell
Google Ads API Team

ref:_00D1U1174p._5004Q2176Yx:ref

[Dũ Đoàn]

Thank you for the information. 

Vào 23:41, T.4, 17 Th6, 2020 Google Ads API Forum Advisor Prod <adsapifor...@gmail.com> đã viết: