A custom report lets you choose the data, breakdowns and numbers you want to see, then run it once or on a schedule and send the results where you need them. You build custom reports on the Custom Reports tab of the Reports page. You need access to custom reports to do this.
Create a custom report
- In the left-hand navigation, select Report.
- Make sure you are on the Custom Reports tab, then click Create Report at the top right.
- Enter a Report Name. This is how you'll recognise the report in your list and in delivered files and emails.
- Choose a Date Range. Pick a preset, or choose Custom to set exact start and end dates.
- Choose how often the report runs from the Schedule Report dropdown. If you choose Daily, Weekly or Monthly, also set the start and end dates for the schedule.
- (Optional) Tick Add Grand Total Row to add a summary line at the bottom of the report.
- (Optional) Tick one or more delivery destinations and set each one up. See Delivery destinations below.
- (Optional) In the Filters section, click Add and choose the data to include, such as advertisers or campaigns. Leave filters empty to include everything.
- In the Dimensions section, click Add and choose how the data is broken down into rows, such as by date, campaign or platform.
- In the Metrics section, click Add and choose the numbers you want to measure, such as impressions, clicks or spend.
- Click Save and Run. The report is saved and runs straight away, and then appears in your report list.
Note: Report Name, Date Range and at least one dimension are required. Everything else is optional.
Note: If your access is limited to particular advertisers, add an Advertiser filter that only includes advertisers you can access. A report without an advertiser filter, or one that includes an advertiser you can't access, won't appear in your report list, even if you created it.
Schedule options
| Option | What it does |
|---|---|
| Never | Runs once, when you click Save and Run. |
| Daily | Runs every day between the schedule's start and end dates. |
| Weekly | Runs once a week between the schedule's start and end dates. |
| Monthly | Runs once a month between the schedule's start and end dates. |
By default, a schedule runs for three months from today. Once the end date passes, the report stops repeating.
For scheduled reports, pick a rolling date range such as Last 7 Days. It moves forward with each run, so every run is current. A Custom date range stays fixed, so every run repeats the same dates.
Delivery destinations
Each destination is a tick-box on the report form. Ticking one shows its setup options. You can choose more than one destination. If you don't choose any, you can still download each run from the report list.
| Destination | How to set it up |
|---|---|
| Tick Email Report and enter the recipients' email addresses, separated by commas. Each recipient gets an email with a download link. | |
| Google Sheets | Click Configure Google Spreadsheet, connect your Google account and choose the spreadsheet and tab. |
| Amazon S3 | Click Configure S3 Secrets, enter your storage credentials and choose the bucket. |
| SFTP | Click Configure Sftp credentials and enter your server details. |
| Google BigQuery | Click Configure Google BigQuery, connect your Google account and choose the project, dataset and table. BigQuery is only available on some accounts. |
Note: Destinations only receive results when a run succeeds and returns data. Destination changes take effect when you click Save and Run.
If you can't see the Custom Reports tab
If the Reports page only shows the Dashboards tab, custom reports aren't part of your access. Contact your account admin if you need them.