Hi Google Scripts team,
Thanks again for the response. I want to clarify though: since there's already an if.....else statement here in the script (see below), it looks like it's not necessary for me to make this change. From my understanding, if I configure the spreadsheet to not include paused ads, it should already follow this logic. My main concern though is that even though I have configured the spreadsheet to skip checking paused campaigns, it's still checking ads within 'Ended' campaigns (campaigns with status: 'Ended', it looks like most of these 'Ended' campaigns were tests that were completed already). Unfortunately, the script still considers these campaigns as enabled campaigns (Please see the attached image below). Is there a way to exclude these ended campaigns?
Let me know also if you would like me to provide my Googe Ads Account ID privately. Thanks!
if (checkPaused) {
conditions.push(`ad_group_ad.status IN ('ENABLED', 'PAUSED')`);
conditions.push(`campaign.status IN ('ENABLED', 'PAUSED')`);
conditions.push(`ad_group.status IN ('ENABLED', 'PAUSED')`);
} else {
conditions.push(`ad_group_ad.status = 'ENABLED'`);
conditions.push(`campaign.status = 'ENABLED'`);
conditions.push(`ad_group.status = 'ENABLED'`);
}
Regards,
Aldric