I'm having trouble with long runtimes with my Keywords Performance Reports... I'm running 5 queries for each campaign in my account. And sometimes my first query (query3) is taking around one minute to complete.

This is strange because sometimes it takes less than a second. It seems to take longer on the same campaigns but I can't get as for why. The campaigns that take longer has similar amount of keywords to the campaigns that take less than a second... And also, the other queries (query7, query14, query28, query56) of the campaigns that took longer with query3, takes less then a second again like nothing is wrong. So I don't think amount of keywords is the reason for the runtime...

those are my queries:

var query3 = "SELECT Id, AdGroupId, SearchImpressionShare, AllConversionValue, Cost, Clicks, Impressions FROM KEYWORDS_PERFORMANCE_REPORT WHERE Status = ENABLED AND AdGroupStatus = ENABLED AND CampaignId = " + campaign.getId() + " DURING " + dateRange3days;
var result3 = AdWordsApp.report(query3); //////////////////////////////////////////////////////////////////////// !!!TOO MUCH TIME!!! ////////////////////////////////////////////////////////////////////////////////////////////

var query7 = "SELECT Id, AdGroupId, SearchImpressionShare, AllConversionValue, Cost, Clicks, Impressions FROM KEYWORDS_PERFORMANCE_REPORT WHERE Status = ENABLED AND AdGroupStatus = ENABLED AND CampaignId = " + campaign.getId() + " DURING " + dateRange7days;
var result7 = AdWordsApp.report(query7);

var query14 = "SELECT Id, AdGroupId, SearchImpressionShare, AllConversionValue, Cost, Clicks, Impressions FROM KEYWORDS_PERFORMANCE_REPORT WHERE Status = ENABLED AND AdGroupStatus = ENABLED AND CampaignId = " + campaign.getId() + " DURING " + dateRange14days;
var result14 = AdWordsApp.report(query14);

var query28 = "SELECT Id, AdGroupId, SearchImpressionShare, AllConversionValue, Cost, Clicks, Impressions FROM KEYWORDS_PERFORMANCE_REPORT WHERE Status = ENABLED AND AdGroupStatus = ENABLED AND CampaignId = " + campaign.getId() + " DURING " + dateRange28days;
var result28 = AdWordsApp.report(query28);

var query56 = "SELECT Id, AdGroupId, SearchImpressionShare, AllConversionValue, Cost, Clicks, Impressions FROM KEYWORDS_PERFORMANCE_REPORT WHERE Status = ENABLED AND AdGroupStatus = ENABLED AND CampaignId = " + campaign.getId() + " DURING " + dateRange56days;
var result56 = AdWordsApp.report(query56);

Does anyone else came across a problem like this?

Also, I've tries to give those queries a list of campaign IDs to retrieve data from (So I could run the 5 queries once for all campaigns instead of once for each campaign). But I couldn't make it work with a list. Does anyone know how to make Keywords Performance Reports to work with campaignIds List?

Thanks in advance, Itay.