Discrepancy between AWQL and Adwords UI data

[Jonas Bolin]

When I do a very simple query in AWQL, I get about 4500 rows returned, but when looking at the same report in the Adwords UI and export to Excel I get around 6000 rows and very different numbers

var query = "select Query, Cost from SEARCH_QUERY_PERFORMANCE_REPORT during LAST_MONTH";

Any idea what would cause this difference?

[Dhanya Sundararaju (AdWords API Team)]

Hi Jonas,

Would you be able to check if the date range you are running in the web interface is the same as in your AWQL? Could you reply privately to author with your client customer id, so that I will be able to dig deeper?

Regards,

Dhanya, AdWords API Team