Not getting all Keywords in KeywordPerfomanceReport.

[Gustavo Mora Gonzalez]

When I make a query from KEYWORDS_PERFORMANCE_REPORT the numbers of results that returns changes

SELECT Id, CampaignId, CampaignStatus, QualityScore, Date FROM KEYWORDS_PERFORMANCE_REPORT WHERE IsNegative = false DURING 20170228,20170228

This query only returns 88 keywrods

And If I remove the date field

SELECT Id, CampaignId, CampaignStatus, QualityScore, Date FROM KEYWORDS_PERFORMANCE_REPORT WHERE IsNegative = false DURING 20170228,20170228

returns 1324

Why this happen? Or which filters the apply applies in the first query

[Sreelakshmi Sasidharan (AdWords API Team)]

Hi, 

It looks like both the AWQLs are the same. Are you trying to say that removing the 'Date' field and by maintaining the "DURING" would generate results as given below?

1. "SELECT Id, CampaignId, CampaignStatus, QualityScore, Date FROM KEYWORDS_PERFORMANCE_REPORT WHERE IsNegative = false DURING 20170228,20170228" returns 88 keywords 

2. "SELECT Id, CampaignId, CampaignStatus, QualityScore FROM KEYWORDS_PERFORMANCE_REPORT WHERE IsNegative = false DURING 20170228,20170228" returns 1324 keywords 

Additionally, please note that the report stats are not available immediately. Since you are trying to extract data for 28-FEB-2017 it is likely that the stats were still being computed and that might be reason for this difference. Please check this document on data freshness for more clarity. Could you please retry once again or perhaps try for an earlier date and check if you see the same behavior?

Thanks,

Sreelakshmi, AdWords API Team

[Gustavo Mora Gonzalez]

Thanks for response, If I removed the date field I get more keywords I think that is something with segmentation

[Sreelakshmi Sasidharan (AdWords API Team)]

Hi, 

Could you please Reply privately to author and share with me your client customer Id along with the downloaded reports in both the cases?