Offline reporting

From Reports > Offline Reporting, click on an existing report to update its setup, or click New offline report to create a new one.

To create and run a report

1. Click New offline report to create a new standard report.

   1. Click the arrow for a different report type (other than standard).

2. Name your report to identify it in a list of other saved reports.

Report properties

1. Choose the date range to report on.

Report setup

Report template	Choose from a list of templates to populate your report with specific metrics and dimensions.
​Filters	Limit the data in your report. For example, add the Advertiser filter, and your report will only contain data about the chosen advertiser.
Dimensions	Descriptors that aren't numerical totals like clicks or impressions. For example, choose Ad type to report on how a given type of ad is performing. Learn more about all reporting dimensions.
Metrics	Units of measurement like clicks, conversions or impressions. They are often expressed as numerical totals or percentages.  Learn more about all reporting metrics.

Schedule a recurring report

1. Check active to schedule this report to run on an ongoing basis.
2. Choose how frequently the report will be run. (For example, daily, or weekly.)
3. Pick the schedule's start and expire dates . (Scheduled reports won't run once the end date has passed.)

Report delivery

1. Choose a filename and format for the report.

   Enable BigQuery format 

   If the Display & Video 360 and BigQuery accounts are managed by separate teams, this process may be performed by multiple admins.

   1. Link the Display & Video 360 account to the BigQuery project and dataset
      1. Navigate to Partner Settings > Linked Accounts or Advertiser Settings > Linked Accounts.
      2. Click Link New Account > BigQuery Exporter.
      3. Provide a name for the link.
      4. Fill in the BigQuery Project ID and BigQuery Dataset ID details and then click Link.
      5. Take note of Display & Video 360 service account. 
   2. Grant the Display & Video 360 service account access to the BigQuery project and dataset
      1. Sign into BigQuery.
      2. Give the Google-generated service account the following access:
         • A member of the Google Cloud project with the BigQuery Job User role.
         • A member of the BigQuery dataset with the BigQuery Data Editor role.
      3. Provide the Display & Video 360 admin the BigQuery project ID and dataset ID details.

   Once the Display & Video 360 account is linked to the BigQuery project and dataset, the dataset will be available to select under BigQuery export in offline reporting. 

   Limitations

   • Scheduled reports containing data of more than 14 days are disabled when BigQuery is selected as file format to minimize reprocessing of data. 
   • For BigQuery exports, there may be duplicate files for the same date. If that happens, you can use the newer file based on the timestamp in the file name.  

2. (Optional) Click the link under Delivery to share the report with other users. You can email a copy of the report as an attachment or share a link for users to download the file. Note that you can't duplicate reports you don't own.

   1. Only reports shared as a link are visible under the Reports shared with me filter.

3. Click Save And Run to generate your reporting file.

4. Click Save for this report to be available for later use, and runnable at any time in the future. 

Limitations

Scheduled reports

• Scheduled reports that haven't been downloaded for more than 60 days or have failed to run for more than 30 days will be deactivated. These reports can be reactivated at any time.
• Scheduled reports will no longer run if you lose reporting permissions or access to data for the advertiser or partner.
• The report owner must be active for scheduled reports to run. You can duplicate the report with a new user to start generating reports again. Note that you can't duplicate reports you don't own.
• CSV files in scheduled reports are zipped when over 200kB. Attachments in scheduled report emails are limited to 25MB. 
• Some metrics and dimensions may be unavailable depending on your user role.