Create customised reports with the Report Editor

With the Report Editor, you can choose the data in your report and how it’s presented, sort and filter the data as you see fit, and pick from a variety of formats to download or email your reports. The Report Editor lets you customise reports with ease so you can focus on the data that matters most to you.

This article goes over the different tasks you’ll need to do in the Report Editor as you create and build your reports.

Before you start

To use the Report Editor effectively, familiarise yourself with the Report Editor parts.


How to create a report

  1. Sign in to your Google Ads account.
  2. In the top right-hand corner of your account, click the reporting icon , then select Reports.
  3. Click the plus button in the top left-hand corner of the page, then select Table, Line chart, Bar chart, Pie chart or Scatter chart.
  4. Drag tiles on to the canvas and drop them in one of the blue highlighted areas. The shelf automatically updates, and the canvas shows your data.
    • You can also create reports by typing your request in English into the search bar . For example, type 'sort campaigns and clicks by cost' and Report Editor will create a report for you. Report Editor can provide suggestions to help you get familiar with the tasks that you can do with this feature.

      Below are supported actions and examples of queries that you can use to create reports. You can enter combinations and variations of these to create reports.

      • Create a report: Specify the details that you want to include in the report. For example, you can type the following:

        • Clicks, impressions and cost

        • Show me campaigns and clicks

        • Clicks, impressions and cost sort by cost. Create a report with clicks, impressions and cost, then sort by cost.

        • Clicks, impression and cost in the last 14 days sort by cost. Create a report with clicks, impressions and cost, all sorted by cost, and filter the data down to last 14 days.

        • Show me campaigns with more than 100 clicks. Create a report with campaigns and clicks, and filter it down to campaigns that have received more than 100 clicks.

        • Show me campaigns with clicks more than 100. Create a report with campaigns and clicks and filter it down to campaigns that have received more than 100 clicks.

        • Show me campaigns with clicks more than 100 in the last 30 days. Create a report with campaigns and clicks and filter it down to campaigns that have received more than 100 clicks in the last 30 days.

      • Modify a report: You can also modify the report that you’re viewing. For example, if you have a report that breaks down your account’s clicks in the last 7 days by campaign, filtered for campaigns that received more than 100 clicks, you can ask the Report Editor to do the following:

        • Add impressions, ctr. Add impressions and click-through rate ('ctr') columns to the existing report.

        • Convert to line chart. Convert your table to a line chart. If your table has more columns than the chart can accommodate, you can choose the ones to keep.

        • Filter for clicks less than 100. Keep the rest of the report intact, but modify the filter on clicks to be a <100 filter. You can also type 'lower than 100' or 'less than 100', and it will result in the same actions.

        • Remove clicks. Remove the clicks column from your table.

        • Remove click. Remove the clicks column from your table. Some words will match even if you type a close variant of the column name, but you can verify the results of your actions before taking them.

    • Report Editor will also provide validation by showing you what it has understood based on your request, and also suggesting what actions it will perform. You can choose to proceed with those suggested actions, ignore the suggestions or edit your request. 

  5. If you have a manager account, you can view data for multiple accounts in the same report:
    1. Click the pencil icon Edit next to 'All accounts' above the canvas.
    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.
  6. 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.
  7. To view or edit the report at a later time, save the report. Learn how to open your saved reports.

How to sort table data

When you sort, nothing is removed or hidden from your table – your data is just reorganised. To sort a column, click on the column header:

  • The first time that you click on the header, the column will be sorted in ascending order.
  • The second time that you click on the header, the column will be sorted in descending order.


Sorting multiple columns helps you to organise your table to suit your needs. When sorting multiple columns, it’s important to remember that the order in which you sort the columns matters, so it can be helpful to think in terms of priorities. Try sorting the column with the least important information first, and the column with the most important information last. This way, the important data that you sort last will be the primary sorting column.

How to apply and remove filters

You can use report and table filters to hide data from your table that you don’t need to see. 

Apply a report filter

  1. Click the filter icon Filter in the top right-hand corner of the Report Editor, above the shelf.
  2. Click on the filter field that appears to see the filtering options.
  3. Choose a filtering option, and create your filter.
    • Some report filters offer the option of selecting items from a list.
    • Some report filters also offer the option for you to define the filter’s condition. For example, you could apply a report filter that only shows ads that received 1000 or more clicks.
  4. When you’ve finished creating your filter, click on Apply.
  5. Repeat steps 2, 3 and 4 to add additional filters as needed. You’ll see all filters that you’ve created in the filter field.

To remove a report filter, click it in the filter field, and click the close button (X) next to its name.

Apply a table filter

  1. Click the filter icon Filter in the column header. This opens the table filter window.
  2. Create your filter.
    • If you’re applying a table filter to a metric, you’ll be able to define a condition to filter based on that metric. For example, you could filter by 'Impressions' so your report only shows data for ads that got more than 1000 impressions.
    • If you’re applying a filter to a dimension, such as the type of device where your ads were shown, you’ll be able to choose from a list.
  3. Click Apply. This adds the filter to the column.

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

How to change the report presentation

The Report Editor allows you to view your data as a table, line chart, pie chart, bar chart or scatter chart. Having multiple options for viewing data means that you get to choose the most effective way to analyze and present your account’s statistics. To switch from one option to another, click the table/chart drop-down menu above the Report Editor shelf and select an option.


Different charts can accommodate different kinds of data. When switching between charts, you may be prompted to modify your dimensions and metrics in order to view your data in a particular chart. If you plan on converting your table to a chart, keep in mind that not all table filters can be transferred to charts.

How to save a report

While viewing your report as a table or a chart, you can save it by clicking either Save or Save as in the upper right corner of the page.

  • Use Save As to create a new saved report based on the current report.
  • Use Save to save your latest changes to a report that you’ve previously saved.

To find your saved reports, click the reporting icon , then click Reports. Simply click on any report to open it.

Saved reports that you haven’t accessed in over 18 months are automatically removed from your account. You can access a report by opening or downloading it, or by opening a dashboard that has the report.

How to download a report

After you’ve created a report, you can download it by clicking the download icon download icon in the top right-hand corner of the Reports page. You can download your report in a number of formats, including .csv and .xml.

How to schedule and share a report

In the Report Editor, you can schedule your reports to be emailed to you or other people who have access to your account at specific intervals.

  1. While viewing your report, click the email and schedule icon Clock.
  2. Complete the following settings:
    1. Select one or more account users to send the report to.
    2. Choose the frequency (examples: daily, weekly) that the reports are sent and in what format (examples: .csv, .xml).
  3. Click Save. If you haven’t saved the report already, you’ll be prompted to save the report.


Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue