Ad Performance Report Script Error

[Nayan Prakash]

Hi Team,

I'm using the default template for 'Ad Performance Report' in Google Ads and want to generate a report for last 60 days. In the default template, it shows for last 7 days but when I change it to 60 days, the script don't run.

Can someone help me here to clarify if this script will only work for last 7 days?

Thanks in advance!

[Google Ads Scripts Forum]

Hi,

Thank you for reaching out to the Google Ads Scripts support team.

I would like to inform you that there is no option such as LAST_60_DAYS to retrieve the last 60 days Ad Performance report. It is only possible to retrieve “TODAY, YESTERDAY, LAST_7_DAYS, THIS_WEEK_SUN_TODAY, LAST_WEEK, LAST_14_DAYS, LAST_30_DAYS, LAST_BUSINESS_WEEK, LAST_WEEK_SUN_SAT, THIS_MONTH, LAST_MONTH, ALL_TIME” data or else you can a particular date range by using “BETWEEN ‘YYYYMMDD’ AND ‘YYYYMMDD’”.

I hope this helps! If you still face any issue even after following the above steps, do reach out to us with the below details.

• Google Ads account ID/CID
• Name of the affected script
• Screenshot of the error (if any)
• Shareable spreadsheet link that you are using in the script. You may refer to this article to share a file publicly

You can share the requested details via Reply privately to the author option or a direct private reply to this email.

Thanks,
Google Ads Scripts team