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 your reports
• Delete a report

Create a report

When you create a report (adding at least one metric), the results 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 save as drafts. You can give them a name later, which takes them out of draft status. Learn how to view all your 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 time period 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.
   • Time zone: To change the time zone of your report, under "Time zone," click  and select a time zone. Currently, network and Ad Exchange time zones are available. Network time zone is selected by default.
6. Add dimensions (indicated by ) and metrics (indicated by ). 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. As we continue to add dimensions and metrics, feel free to provide feedback for those most important to you that aren’t yet available. 
7. To filter results, such as by "Country," click Add filter, then make your selections and click Apply.

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.

For longer reports, you can now view all rows by scrolling up or down.

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 select a table format, click the flat  or hierarchical  icon:
   • Flat: This spreadsheet view displays columns for each of your selected dimensions and metrics, with rows for all results. 
   • Hierarchical: This format changes how the table data is grouped for readability and to better display trends. This pivot table view displays your selected report dimensions in a single column, with data aggregated for each dimension value in a hierarchical tree format. For example, each ad unit name might have countries listed below, and then devices below countries. Your selected metrics each get their own column. Note that exported reports always use the flat table structure, even if you chose to display your data in the hierarchical structure within Ad Manager.
3. 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.
4. To show a dimension’s values as columns, under "Columns," click the menu  and select a dimension. Note that to select a column dimension, "Split" must be set to "Totals only." If a selected dimension has more than 100 values, overflow data won’t be displayed. Keep this in mind with dimensions which may have thousands of possible values, exceeding the 100 column limit.   
5. To filter by flags, under "Filter by flag," click the menu  and select a flag.
   To use this option, you need to have a flag set up.     
6. 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. In addition:
   • Note that in the hierarchical table format, the single column for dimensions can’t be hidden.
   • 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.
7. To jump to the top or bottom rows, in the lower-right corner, click Click to top or Click to bottom. Scroll up or down to view all rows of the report. 

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 your reports

All your Interactive reports show on the table on the "Interactive reports" page. To quickly find certain reports, you can use search or filters.  

1. Sign in to Google Ad Manager.
2. Click Reporting, and then Interactive reports.
   
3. To search for a report, in the search box at the right, enter the name of the report (or some keywords from it) and click Enter. The table updates with relevant results. Note that only named reports are included in the search results; unnamed draft reports don’t show. 
4. To filter for a report, click a filter:
   • All reports: Shows all reports you can access on your network. 
   • My reports: Shows reports you created, including any draft reports. 
   • My saved reports: Shows reports you created, but not draft reports.
   • Shared with me: Shows reports others shared with you. Your access is view-only. For an editable version of the report, you can make a copy.
5. Under "Name," find the report.
   For more details or to make changes, click the report name.

Overview of the Interactive reports table

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. Shared reports show next to the report name. Hover over the icon for details. 
• 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 .
• Owner: Shows whether you or someone else created the report. Report owners have edit access, while others have view-only access. If recipients of a shared report need to make changes, they can make a copy of the report. 
• 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 re-run a report, in a report, click  Re-run. 

Delete an Interactive report

You can quickly delete one or more Interactive reports. Note that deletion is final and can’t be undone.

1. Sign in to Google Ad Manager.
2. Click Reporting, then Interactive reports. 
3. Next to the name of a report you want to delete, check the box and then click Delete. 

Related article

• Schedule interactive reports and set delivery options

• Export, share, or copy an Interactive report

• Use flags in your interactive report