Hello, We were able to take a look at the discrepancy you mentioned. Please find my response below:
1. I was able to download a report for Apr 2,2018 - Apr 8, 2018. I see that the number of rows in API is 21978, and segmenting the exact same fields in the UI are 22032. The stats for all the segmented fields match in both the report types. However, I see that the number of rows in UI is greater than the ones in API. This is because of the AdWords Express Campaigns which are included in the UI Reports. These Campaigns can only appear in the Campaign Performance Report. Please refer to this blog post <https://ads-developers.googleblog.com/2017/11/changes-to-adwords-express-campaigns-in.html> for more information. If you're still experiencing the discrepancy, please share the complete reports along with the date range, so I can take a look. 2. Please note the reports generated by AdWords API use the same naming convention as UI Reports. The number of rows and data collection techniques might be different for both UI and API. The stats pulled through API reports, however, should match the stats in the UI. The reports pulled through the API can be compared to the downloaded report from that view. Let me know if you have any other questions Regards, 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/1290380b-237b-4583-9680-32821ddb798a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
