Hello, I was able to take a look at the discrepancy you're noticing. The AdWords API have similar naming conventions as UI reports. However, the stats pulled through the API map to the corresponding Ads tab metrics in the UI. Please refer to this guide <https://developers.google.com/adwords/api/docs/guides/uireports> on how API reports are mapped in the UI.
Let me know if you have any other questions. Thanks, Bharani, AdWords API Team On Thursday, April 12, 2018 at 6:09:11 AM UTC-4, Khoa Nguyen wrote: > > Hi AdWords API support team, > > It seems the result of report query by API and AdWords UI is different: > - With the following report query: > SELECT Id, CampaignName, AdGroupName, Clicks, Impressions, Ctr, > AverageCpc, Cost, Conversions, ViewThroughConversions, CostPerConversion, > ConversionRate > FROM AD_PERFORMANCE_REPORT DURING LAST_WEEK > > In the AdWords UI (I used predefined "Basic / Ad" report), it shows 21240 > rows whereas the API returns 21972 rows. I found that there are some Ids in > the API result not found in the AdWords UI. > - With this report query (add Year segment): > > SELECT Id, CampaignName, AdGroupName, Year, Clicks, Impressions, Ctr, > AverageCpc, Cost, Conversions, ViewThroughConversions, CostPerConversion, > ConversionRate > FROM AD_PERFORMANCE_REPORT DURING LAST_WEEK > > In the AdWords UI, once I add "Year" to the row key, it shows 222 rows > whereas the API still returns 21972 rows and the "Year" column all contains > "2018" value > > Do you have any idea why it's like that? > > Thank you. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ea02771b-c75b-496b-9aa4-c18d87582170%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
