G Ad Scripts- Ad Performance- How to get all-time?

[CJ]

Hi, 

I'm using the template Ad performance (Last 7 days).

How do I get results for All Time and last 90 days?

Thank you.

CJ

[Nils Rooijmans]

you can change the date range in the GAQL query at line 210.

ie, change

        `segments.date DURING LAST_7_DAYS`);

into

        `segments.date BETWEEN 20250101 and 20250207`);

this gives you the results for this year up until 7 Feb.

Hope this helps,

Nils Rooijmans
https://nilsrooijmans.com
See my Google Ads Scripts FAQ to avoid the same mistakes I made: https://nilsrooijmans.com/google-ads-scripts-faq/

[Google Ads Scripts Forum Advisor]

Hi,

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

@Nils, thank you for the insights on this issue.

I would recommend you to follow the provided solution by Nils if you are GAQL query in your script and get back to us in case of any further issue with the below details:

• Google Ads account ID/CID
• Name of the script

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

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vH0lz:ref" (ADR-00287561)

Thanks,
 

Google Ads Scripts Team

Feedback
How was our support today?