Create an Interactive report (Beta)

This feature is in Beta
Features in Beta phase might not be available in your network. Watch the release notes for when this feature becomes generally available.

With Interactive reports, you can create a report and view the results on the same page in Ad Manager. 

To help with your analysis, you can change the report layout, sorting and organizing the results for a custom view.

After your report is generated, you can change your selections, such as adding other metrics or dimensions. The results update automatically. 

Jump to a section below:

• Create a report
• About report results
• Change the report layout
• About time comparisons in the report
• View previous and draft reports
• Copy a report
• Export a report

Create a report

When you create a report, adding at least one dimension or metric, the results will usually show within a few seconds. If there are no results, try other selections, such as a different date range. 

1. Sign in to Google Ad Manager.
2. Click Reporting, and then Interactive reports.
3. Click New report.
4. Enter a name for your report.
   
   Tip: Unnamed reports are saved as drafts. You can continue creating them later. Learn how to view your previous and draft reports.
5. Select the basic parameters for your report:
   • Date: Next to the date, click  and select a date or date range for your report.
   • Compare: To compare your selected date to another time period, under "Compare," click  and select a time period. By default, "None" (no comparison) is selected. Learn more about time comparisons.
   • Split: By default, "Split" shows "Totals only." To split columns by a time period, under "Split," click  and select an option. Note that up to 100 columns can show. 
   • Currency: To change the report currency, under "Report currency," click  and select a currency.
6. Add dimensions and metrics. Choose from the following options:
   • Click Select dimensions and metrics, enter a search term or scroll through the list, and check the box for each dimension or metric you want to include. 
   • Click View all, check the box for each dimension or metric you want to include, and then click Apply. Note that for a focused view, in the top-right corner, you can click Dimensions or Metrics.
     Note: Some dimensions and metrics aren’t yet available in Interactive reports. While we will continue to add dimensions and metrics, feel free to provide feedback for those most important to you that aren’t yet available. 
7. To add a filter, click Add filter and make your selections.

Note: If the message "Report is invalid" shows after making your selections, it means some of the selected dimensions and metrics aren’t compatible. To remove the incompatible items, click the link in the message, or click on the dimension or metric name. 

About report results

With Interactive reports, your results show on the same page as your report setup. Results show automatically as you add metrics and dimensions to your report. 

Note that the "Totals" row shows results for all unfiltered data that is returned, and includes totals for the entire table, not just what’s displayed.

To navigate reports with multiple pages, in the lower-right corner, click the arrows. 

Change the report layout

After your report is generated, you can change the layout as follows:

1. To reorder columns, next to "Select dimensions and metrics," drag a dimension or metric to the desired column order. Dimensions always show before metrics. 
2. To display top results by rank, next to "Display," click  and select an option, such as "Top 5." When you display top results, dimension and metric menus become available. Make a selection to further sort ranked results by a dimension or metric.
3. To show a dimension as a column, under "Columns," click the menu  and select a dimension. Note that to select a column dimension, "Split" must be set to "Totals only."   
4. To filter by flags, under "Filter by flag," click the menu  and select a flag.  
5. To organize columns, next to a column heading, click  and filter, sort, or hide the column. For example, if you added the "Total impressions" metric, you can sort the results from highest to lowest. 
   • To unhide a column you previously hid, next to a column heading, click the "Show column" arrow.
   •  To adjust column width, drag a column separator left or right.
6. To view more rows, next to "Show rows," click  and make a selection.

About time comparisons in the report

You can set up reports to show data for a single day or various date ranges. And you can compare your date selection to other time periods. By default, no time comparison is applied.

Apply a time comparison

Under "Compare," you can choose from the following options:

• Previous period: Compare your selected time period to the one before it of the same duration. For example, if your selected time period is "Last 7 days," the previous period compares the 7 days before that. 
• Same period last year: Compare your selected time period to the same time period last year. 
• Custom period: Compare your selected time period to a time period you specify.

When you compare time periods, the report includes a "Change" column that shows the difference between the periods. You can filter the column for "Total change values" or "Percent change values."

Add a time period split

Along with time comparisons, you can apply a time period split. For example, if you select "Day" under "Split," the results will show for each time comparison as follows: 

• Previous period: Each day in the report is compared to its previous day.
• Same period last year: Each day in the report is compared with the same day in the previous year.
• Custom period: Each day in the report is compared to the custom period.

The same rules apply to Week, Month, and Quarter column breakdowns.

View previous and draft reports

You can view your previous, draft, copied, and scheduled reports on the "Interactive reports" page:

1. Sign in to Google Ad Manager.
2. Click Reporting, and then Interactive reports.
   
3. Under "Name," find the report.
   For more details or to make changes, click the report name.

Overview of your interactive reports

The table on the "Interactive reports" page includes the following information: 

• Name: The name of the report. Copied reports show "Copy of" before the name. Reports not yet named show "Unnamed report." Copied and unnamed reports remain as drafts until you rename them.
• Date range: Shows the date range selected for the report, such as "Last 7 days" or a custom range.
• Settings: Shows the report’s dimensions, metrics, and date range. For details, hover over .
• Report type: Shows the type of report, such as "Historical."
• Schedule: Shows the frequency of a scheduled report.
• Last run: Shows the date and time the report last ran, as well as the date range the report covers. After 40 days, the "Last run" status of completed reports changes to "Expired."
  Tip: You can re-run a report at any time for the latest results. To rerun a report, next to “Last run,” click . 

Copy a report

To save time with report setup, you can copy an existing report. The copy adds "Copy of" to the title. Once copied, the new report is ready to use. You can find your copied reports (along with your other previously created reports) on the "Interactive reports" page. 

To copy a report: 

1. In the top-right corner of a report, click . 
2. Update the title of the new report and make other changes as needed.
   Note that your new report is saved as a draft until you rename it.  

3. Export a report

To use Export, your report needs at least one metric. 

1. Sign in to Google Ad Manager.
2. Click Reporting, then Interactive reports.
3. In a report, click Export.
   Currently supported export types: CSV, Google Sheets, and Microsoft Excel.
4. Under "Data to include," make your selections:
   • Export all rows: Includes all rows in your report. Check this box to include data that otherwise might not display due to table level filters or hidden columns.
   • Include fields added for formatting: Includes ID fields and end dates related to certain dimensions such as line items and ad units. 
   • Include totals row: Includes a row with the total for count metrics, or the average for percentage and rate driven metrics. 
5. Under "Delivery" select a delivery method:
   • To download the report, click Download. 
     Currently supported delivery methods: Download
6. Click Export.

Related article

• Use flags in your interactive report