Ad Performance Report

This script is for a single account. For operating on multiple
accounts in a manager account, use the
Ads Manager
version of the script.

Ad Performance Report is an example of advanced reporting functionality
provided by Google Ads scripts. Advertisers like to analyze how their ads are
performing in their campaigns. Sometimes, comparing how a given headline or
final URL performs against others will provide insight in creating new
ads. Ad Performance Report generates a Google Spreadsheet with a number of
interesting distribution charts.

A new Ad Performance report gets created whenever the script executes. You
can access all of these reports in
Google Drive. Optionally, the script can also
email the report to one or more recipients.

Scheduling

The script uses last week's statistics to generate the report. Schedule it
Weekly, on Mondays.

How it works

The script starts off creating a copy of a
template spreadsheet,
with all graphs pre-configured. The script then populates the data values in
the Report sheet, and graphs in the other sheets get
constructed automatically.

Setup

Create a new script with the source code below.

Don't forget to update RECIPIENT_EMAIL in order to specify
your email preference.