Weird pause when pulling results from AdsApp.report in loop

[Christopher Larkin]

Hi -

Thanks to a great suggestion on the forum, I've worked around a problem where I couldn't access some of the newer campaign types, like smart and discovery campaigns, using the AdsApp.report method. 

While the results are completely right, if I watch the data fed into a Google Sheets doc, at one point in the query, there is a pause, where no activity occurs, but I used Logger.log to determine the freeze happens when the AdsApp.report query is made. I tried the same query in awql.me and it returned the results instantly. 

Any thoughts on how this could happen? 

Thanks -

Christopher

[Christopher Larkin]

Here is extra information that might help clarify the delay - it shows the query above taking over 30 seconds:

10/16/2019 8:45:05 PM About to execute query: SELECT CampaignName, Clicks, Cost, Conversions, CostPerConversion, CampaignStatus FROM CAMPAIGN_PERFORMANCE_REPORT WHERE Cost > 0 and CampaignName CONTAINS 'Richmond' DURING THIS_MONTH 

10/16/2019 8:45:06 PM Query executed: SELECT CampaignName, Clicks, Cost, Conversions, CostPerConversion, CampaignStatus FROM CAMPAIGN_PERFORMANCE_REPORT WHERE Cost > 0 and CampaignName CONTAINS 'Richmond' DURING THIS_MONTH 

10/16/2019 8:45:06 PM Campaign Richmond Generic (Arc)

10/16/2019 8:45:06 PM Campaign enabled

10/16/2019 8:45:06 PM Campaign Richmond Competitive (Arc)

10/16/2019 8:45:06 PM Campaign enabled

10/16/2019 8:45:06 PM Campaign Richmond Master (Arc)

10/16/2019 8:45:06 PM Campaign enabled

10/16/2019 8:45:06 PM [21, 8]

10/16/2019 8:45:07 PM About to execute query: SELECT CampaignName, Clicks, Cost, Conversions, CostPerConversion, CampaignStatus FROM CAMPAIGN_PERFORMANCE_REPORT WHERE Cost > 0 and CampaignName CONTAINS 'San Diego' DURING THIS_MONTH 

10/16/2019 8:45:39 PM Query executed: SELECT CampaignName, Clicks, Cost, Conversions, CostPerConversion, CampaignStatus FROM CAMPAIGN_PERFORMANCE_REPORT WHERE Cost > 0 and CampaignName CONTAINS 'San Diego' DURING THIS_MONTH 

10/16/2019 8:45:39 PM Campaign San Diego Generic (Arc)

[Google Ads Scripts Forum Advisor]

Hi Christopher,

Thank you for reaching out.

I understand that you are encountering an issue that AdsApp.report doesn't work as expected.

So I can further investigate the issue that you are encountering in the Google Ads scripts, could you provide the following information via Reply privately to author?

• CID
• Script name
• Spreadsheet access

However, my apologies that I would not be able to comment about awql.me as this is a third-party tool and this is out of scope for our team.

Regards,
Hiroyuki
Google Ads Scripts Team

ref:_00D1U1174p._5001UKNbPz:ref