difference in data of Keywords_Performance_Report downloaded from API and Google-ReportsUI

[Harish R]

Hi Team,

I am downloading the Keywords_Reports using Google-API (by calling KEYWORDS_PERFORMANCE_REPORT) and also downloaded using ReportUI dashboard(downloaded from home dashboard for particular account). As per the name convictions used for the navigation on Google-ReportUI and to call using Google-API, both table data should match,

But,

There is a lot of difference between the two tables.

Please give the solution and confirmation on this ASAP.... 

Thanks

[googleadsapi...@google.com]

Hi Harish,

The data between the Google Ads UI and API should match. Can you please reply privately to author your report query and the results from both the UI and API?

Thanks,

Anthony

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@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 and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@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/7db9b2f8-7f15-4112-8351-03973f056465%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Harish R]

Hi Team,

Thanks for the quick replay,

I have shared screenshots of two accounts,

for both accounts I used below AWQL to download Keywords_Report using API

" SELECT  Criteria, CampaignName, AdGroupName, Status, Clicks, Impressions, Cost FROM KEYWORD_PERFORMANCE_REPORT WHERE Status IN [ENABLED, PAUSED] DURING LAST_MONTH "

here is my basic observation,

for Account1 --> There is a lot of difference in clicks, impression and cost when compare to ReportUI data and API data

for Account2 --> No difference found (clicks, impressions and cost are same) when compare to ReportUI data and API data

Screenshots 

Account1_ReportUI.png  --> ReportUI screenshot

Account1_AWQL_API.png --> Downloaded Excel Screenshot (rows filtered to show only Total)

Account2_ReportUI.png  --> ReportUI screenshot

Account2_AWQL_API.png --> Downloaded Excel Screenshot (rows filtered to show only Total)

Also Please tell,

What is the difference between KEYWORDS_PERFORMANCE_REPORT and CRITERIA_PERFORMANCE_REPORT ..?

Thanks

[googleadsapi...@google.com]

Hi Harish,

I will need to take a look at your account. Can you please reply privately to author the CID of the first account?

Thanks,

Anthony

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@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 and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@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/bd66fe6c-6e22-429a-84f7-9f0845c75d8a%40googlegroups.com.