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
• Export a report
• Share a report
• Copy 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.

You can now view all rows of longer reports 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 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 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 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. (Optional) Click a filter to view:
   • 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.
4. 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. 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.
• 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 . 

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.

Share a report

You can share reports with anyone on your network that has the reporting permission. Shared reports are view-only for recipients, but they can make a copy for a customizable version.

To share a report

1. Sign in to Google Ad Manager.
2. Click Reporting, and then Interactive reports.
3. Create a report or open an existing report to share. 
4. Click Share, and then choose an option:
   • Selected users: Shares the report only with the users you enter or select in the "Add users" menu.
   • Anyone in my network: Shares the report with anyone in your network who has reporting access. 
5. Click Save.
   Note: If your report doesn’t have a name, you’ll be asked to enter one.

To view a report shared with you

1. Sign in to Google Ad Manager.
2. Click Reporting, and then Interactive reports. 
3. Next to "Filter by," click Shared with me. 
4. Click the name of the report. 
5. (Optional) For a version of the report you can customize, click Copy.
   You become the owner of the copied report, and can edit as needed. 

 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. Sign in to Google Ad Manager.
2. Click Reporting, and then Interactive reports. 
3. Click the name of the report you want to copy. 
4. In the top-right corner of the report, click . 
5. 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.  

Related article

• Use flags in your interactive report