Create custom reports in Report Editor

The Report Editor allows you to analyse 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. Then, save these charts to share with others, or add them to personalised dashboards.

This article explains how to use the Report Editor to better visualise 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.
• Visualise patterns and trends: Custom charts let you visualise 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. In the top right-hand corner of your account, click the reports icon , then select Reports.
3. Click   Custom and choose the type of chart that you’d like to create: Table, Line, Column, Bar, Scatter or Pie.
4. Drag and drop a dimension, such as Campaigns from the right-hand side panel into the 'Row', 'X-Axis', 'Series' or 'Segment' section.
   • The name of this section will depend on the type of chart that you’re creating.
5. 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 that you’re creating.
6. Your chart or table will now show you values for each dimension based on the metrics that you added, for example, the number of clicks and conversions for each campaign.
7. 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 menu whether you want to view accounts by account name or account label.
   3. Select the box next to the accounts that 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 greyed 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-hand 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: Reorganise 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 that 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 that you’ve added to your report.

1. Click the drop-down 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 drop-down 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-organises 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 reorganised.
2. For all other charts including tables, you can sort by clicking on the drop-down arrow for the data points that 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 bear in mind that the last column that 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 that 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 with which 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

• About the Report Editor
• Create and manage reports