Offline reporting

From Reports > Instant & offline > Offline Reporting, click on an existing report to update its setup, or click New offline reportto 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 reportand select either Inventory availabilityor Floodlight.

2. Name your reportto 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 activeto 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 startand expiredates. (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 Accountsor Advertiser Settings > Linked Accounts.
      2. Click Link New Account > BigQuery Exporter.
      3. Provide a name for the link.
      4. Fill in the BigQuery Project IDand BigQuery Dataset IDdetails 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 Deliveryto 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 mefilter.

      • 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 Savefor this report to be available for later use, and runnable at any time in the future.