Offline reporting

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

Offline reporting offers a few specific report types, including Inventory availability and Floodlight.

To create and run a report

1. Click New offline report and select either Inventory availability or Floodlight.

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

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.

      • Note: For Instant and Offline reporting, when a report is shared with another user, only the report files are shared, and not the report itself. The user won't have access to run the report, but the shared report files will be available in the “Files” column.

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.