Ad Performance Report

Name: Ad Performance Report
Author: Google Ads Scripts Team

Generates a Google Spreadsheet with ad performance stats segmented by headline and final URL, including distribution charts. Covers all ad types and optionally emails the report link weekly.

Shopping

PMax

Display

YouTube

reporting

ads

performance

headlines

by Google Ads Scripts Team·developers.google.com/google-ads/scripts/docs/solutions/ad-performance

Overview

Ad Performance Report copies a template spreadsheet, queries the last 7 days of ad performance data across all ad types (text, expanded text, responsive search, display, video, shopping, and more), aggregates metrics by headline and final URL, and writes the results into two sheets with distribution charts. The report link is emailed to the configured recipients.

Setup

1Make a copy of the official template spreadsheet linked in the Google Ads Scripts documentation.
2Paste the spreadsheet URL into CONFIG.spreadsheet_url.
3Set CONFIG.recipient_emails to the email addresses that should receive the report link.
4Schedule weekly (Monday morning recommended) to capture the prior week's data.
5Run once in preview to confirm the new spreadsheet is created and data populates.

Ready to Use This Script?

Configuration Variables

Variable	Default	Description
`CONFIG.recipient_emails`	['YOUR_EMAIL_HERE']	Array of email addresses to notify when the report is ready.
`CONFIG.spreadsheet_url`	'YOUR_SPREADSHEET_URL'	URL of the template spreadsheet to copy for each report.

Expected Output

Generated new reporting spreadsheet https://docs.google.com/spreadsheets/d/...
Ad performance report available at https://docs.google.com/spreadsheets/d/...
(Email sent to recipients with the spreadsheet link)

Notes

Each run creates a new copy of the spreadsheet, timestamped with the current date. Old report spreadsheets are not deleted automatically — clean them up periodically from Google Drive.