Create custom reports in Report Editor

The Report Editor allows you to analyze and present your performance data in more detail.

You can create custom tables and charts directly in Google Ads, without having to download your data in a separate sheet. These charts can be saved, shared with others, and added to personalized dashboards.

This article explains how to use the Report Editor to better visualize your performance.

Benefits

• Easy tables and charts: A simple drag-and-drop interface lets you quickly build multi-dimensional tables and charts, reducing the need to download your data.
• Visualize patterns and trends: Custom charts let you visualize the patterns and trends in your data.
• Advanced filtering and sorting: Filter, segment, and sort your report to see a specific set of campaigns or metrics.

Instructions

1. Create a report

Start by creating a custom report in your account.

You’ll then build your report by adding dimensions, such as campaigns, as well as metrics, like clicks and conversions.

CREATE IN MY ACCOUNT

1. Sign in to your Google Ads account.
2. Click Campaigns , and then Insights & reports.
3. Click Report editor.
4. Click   Custom and choose the type of chart you’d like to create: Table, Line, Column, Bar, Scatter, or Pie.
5. Drag and drop a dimension, such as Campaigns from the right-side panel into the “Row,” “X-Axis,” “Series,” or “Segment” section.
   • The name of this section will depend on the type of chart you’re creating.
6. Drag and drop metrics, such as Clicks or Conversions into the “Columns,” “Y-Axis,” or “Value”  section.
   • The name of this section will depend on the type of chart you’re creating.
7. Your chart or table will now show you values for each dimension based on the metrics you added, for example, the number of clicks and conversions for each campaign.
8. To save your report, click Save or Save as. “Save as” lets you create a copy of your report with a new name.

Change your chart

You can change your chart type or table by clicking the name of the chart type above the “Row” section.

Manager accounts

1. If you have a manager account, you can view data for multiple accounts in the same report:
   1. Click the pencil icon next to “All accounts.”
   2. Select from the drop-down whether you want to view accounts by account name or account label.
   3. Check the box next to the accounts you want to include in your report.
   4. Click Save. If you select more than one account, the canvas will show a preview of what the report will look like and some data will be grayed out. To view the data for all selected accounts, you’ll need to download the report.
2. Now that you’ve created your report, you can start refining your analysis:
   • To rearrange tiles, just drag and drop them inside the shelf.
   • To change the date range for your report, use the date range selector in the upper right corner of the page.
   • To remove a dimension or metric from your report, find the dimension or metric in the shelf and click the close button (X) next to its name.
3. To view or edit the report at a later time, save the report. Learn how to open your saved reports.

2. Edit your report

You can filter, format, and sort your data.

• Filter: See data that meets specific criteria in your table or chart.
• Format: Add conditional formatting to highlight cells with specific values.
• Sort: Reorganize the data in your table or chart.

Filter

You can filter and segment the data shown for the entire report or the data shown for specific columns.

Filter entire report

1. Click the filter icon above your table or chart.
2. Search and select the items you’d like to filter for:
   • For example, you might filter by “Ad type,” and select Text ads and Video ads.
   • You can NOT filter for a specific value, such as campaigns with less than 10 clicks. Those filters can be added to individual columns.
3. Click Apply. This adds the filter to your report.

To remove a table filter, click the filter icon in the column header, and then click Remove filter.

You can filter your report by data that isn’t in your rows or columns. For example, you could add a filter to only see ad clicks from a specific campaign, even if you haven’t added “Campaign” to your custom report.

Filter a data point

You can add filters to any of the data points you’ve added to your report.

1. Click the dropdown arrow next to an item in the “Row,” “X-Axis,” “Column,” “Y-Axis,” etc sections.
2. Select Filter.
   • For metrics, you can filter for a specific value. For example, you could filter by “Impressions” so your report only shows data for ads that received more than 1,000 impressions.
   • For dimensions, you’ll be able to choose from a list of options. For example, if you’re filtering by “Ad type,” you might select Text ads or Video ads.
3. Click Apply. This adds the filter to the column or row.

Format (table charts)

You can add conditional formatting to highlight certain cells in your table charts:

1. Click the dropdown arrow next to an item in the “Row” and “Column” sections.
2. Select Conditional formatting.
3. Set rules for how you want specific cells to be formatted. For example, you might highlight all cells in green that have over 1,000 clicks.

Conditional formatting is only available for metrics with numerical values such as clicks, conversions, and impressions.

Sort

Sorting re-organizes your report data for easy reading. There are two ways to sort your data:

1. For tables, you can sort a column by clicking the column header at the top of the table.
   • The arrow in the column header will show you whether the column is sorted from high to low (down arrow) or low to high (up arrow).
   • When you sort, nothing is removed or hidden from your table—your data is just reorganized.
2. For all other charts including tables, you can sort by clicking on the dropdown arrow for the data points you’ve added in the “Row,” “X-Axis,” “Column,” “Y-Axis,” etc sections.
   • Under “Sort by,” select High to low or Low to high.

You can sort multiple columns, but keep in mind that the last column you sort will change how the rest are sorted.

3. Download your report

After you’ve created a report, you can download it by clicking the download icon . You can download your report in several formats, including .csv and .xml.

4. Schedule and share your report

You can schedule your reports to be emailed to you or other people who have access to your account at specific times.

For example, you might want to share weekly updates on the number of conversions your campaigns have received.

1. Click the schedule icon .
2. Select one or more account users to send the report to.
3. Choose the frequency you’d like to share your report, such as daily or weekly.
4. Select the format that your report will be sent as, such as a .csv or .xml.

Click Save. If you haven’t saved the report already, you’ll be prompted to save the report.

 

Related links

• Use segments in your tables
• Create and manage reports