You can export, share, and copy Interactive reports in Google Ad Manager.
Review this article for details on each action, such as selecting file types when exporting, choosing recipients for sharing, and creating a customizable version of a report by copying.
In this article:
Overview
You can export, share, and copy Interactive reports.
Use Export to download a report in a selection of file types. Use Share to send a report to other users on your network. Use Copy to create a version of a shared report that you can customize. For details, review the sections that follow.
Export a report
Note the following details when exporting Interactive reports:
- Metrics: To use export, your report needs at least one metric.
- Table structure: Exported reports always use the flat table structure, even if you chose to display your data in the hierarchical structure within Ad Manager. Empty rows in your exported file indicate no data was available.
- Versions: When you export a report, the current version you are viewing is exported. The current version may be a draft or a published version, depending on the version you select.
To export a report:
- Sign in to Google Ad Manager.
- Click Reporting, then Interactive reports.
- Select an existing report, or create a new report.
- In the top-right corner of a report, click Export report, and then select a file type.
Currently supported export types include CSV, Google Sheets, and Microsoft Excel. The CSV and XLSX options can be downloaded. - Under "Additional data," make your selections:
- Include report properties (selected by default): Includes report details — such as report name, run time, and filters — that appear at the top of CSV files and in a separate tab for Google Sheets and Excel files.
- Include hidden or filtered data: Includes sections you've filtered or hidden, such as columns.
- Include fields added for formatting: Includes fields added to format the report. For example, ID fields and end dates are added for certain dimensions, and "Line item currency code" is added to format some line item attributes.
- Include totals row: Includes a row with the total for count metrics, or the average for percentage- and rate-driven metrics.
- Use API column names: Includes the API column name (such as COUNTRY_NAME) in the header row instead of the localized name (such as "Country"). Learn more about API column names in the API Developer docs.
Note: If you selected XLSX or CSV for the file type, under "Delivery," the "Download" export method is currently available and selected by default.
- Click Export.
Share a report
Requires permissionYou can share reports with anyone on your network who has the "Create and view reports" permission. |
You can share reports with other users in your Ad Manager network. To share a report, the report must have a name and be published. When you share a report, you can choose to give the recipient "Viewer" or "Editor" access. By default, recipients have "Viewer" access. Note the following details:
- Editor access: If a recipient with "Editor" access makes changes to a shared report, some changes don’t show for others until they’re published. For details, review About editing shared reports.
- Viewer access: If a recipient is given "Viewer" access, they can make a copy for their own customizable version, but they can’t edit the shared version.
To share a report
- Sign in to Google Ad Manager.
- Click Reporting, then Interactive reports.
- Create a report or open an existing report to share.
- Complete the following steps as needed:
- If the report has not yet been published, click Publish.
Only published reports can be shared. - If the report has not yet been named, enter a name for the report.
Only named reports can be shared.
- If the report has not yet been published, click Publish.
- In the top-right corner of the report, click
, and then:
- Under "Add users," search for a user you want to share the report with and check the box next to their name.
- To give the user edit access, next to "Viewer," click
and select Editor.
Note that if "Editor" can’t be selected for a user, they likely don’t have the required permission.
- (Optional) To grant view-only access to anyone in your network with the required permission, next to "Anyone in my network," check the box.
- 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
- Sign in to Google Ad Manager.
- Click Reporting, and then Interactive reports.
- Next to "Filter by," click Shared with me.
- Click the name of the report.
- (Optional) To create your own customizable version of the report, such as if you don't have Editor access, click Copy
.
You become the owner of the copied report and can edit it as needed.
About editing shared reports
If you’re granted Editor access in a shared report, review the following table to understand when your edits will show for others.
| Action in a shared report | Result in shared version | Changes require publishing to show in shared version? |
|---|---|---|
| You edit the name, schedule, or sharing settings. | Your edits immediately show for others sharing the report. | No |
You edit the following settings or features:
|
Your draft edits show only in your version. To share your edits with others, click Publish. | Yes |
You edit the following settings in the results:
|
Your changes show only in your view of the report. | N/A |
Copy a report
To save time with report setup, you can copy an existing report. "Copy of" is added to the name of the copied report, which you can rename. Once copied, the new report is ready to use. You can find your copied reports (along with all your reports) on the "Interactive reports" page.
- Sign in to Google Ad Manager.
- Click Reporting, and then Interactive reports.
- Click the name of the report you want to copy.
- In the top-right corner of the report, click Copy
.
- To rename the copied report, click the name field and enter a new name.
Note that your new report is saved as a draft until you rename it.