Search
Clear search
Close search
Google apps
Main menu

Explore your data with the Report Editor

The Report Editor is a tool that allows you to engage with your performance data through multi-dimensional tables and charts. With the ability to create these tables and charts directly within AdWords, the Report Editor eliminates the need to download your data in order to thoroughly explore it.

Benefits

  • A simple drag-and-drop interface lets you quickly build and manipulate multi-dimensional tables and charts, reducing the need to download your data for deeper analysis.
  • Multi-segment analysis lets you slice and dice your data with finer granularity in your tables and charts.
  • Custom charts let you quickly visualize the patterns and trends in your data.
  • Advanced filtering and sorting allow you to filter on segmented metrics (e.g., mobile clicks) and sort by multiple columns.

Guide me: Visualize your data

Click "Guide me" to be guided through creating charts and pivot tables in your account.


Guide me

Get to know the Report Editor

To use the Report Editor effectively, you should get to know its parts:

Tiles: These are dimensions and metrics that you drag on to the canvas to build your report. Metrics are quantitative measurements about your data, such as clicks, impressions, and conversions. Dimensions describe qualitative characteristics of your data, such as device, ad group, or location.

tiles

Sidebar: This area contains tiles and filters. Drag tiles onto the canvas to build reports. Use filters to refine the data in those reports. Click the tiles button (view list icon) to see dimensions and metrics. Click the filter button (filter icon) to see filtering options. To hide the sidebar completely, deselect both buttons.

sidebar

Canvas: The large gray area is the canvas. This is where you’ll drag tiles to create reports.

canvas

Shelf: This is the area above the canvas. The shelf shows you which tiles have been added to your report. It’s only displayed when you’ve dragged a tile onto the canvas.

shelf
Create a report
  1. Sign in to your AdWords account.
  2. Click the Reports tab at the top of your account.
  3. Click the +Report drop-down menu at upper left. Choose Table, Line chart, Bar chart, or Pie chart.
  4. Drag tiles onto the canvas and drop them in one of the blue highlighted areas. The shelf is automatically updated, and your data is displayed on the canvas.
  5. Now that your report has been created, 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 selector.
    • To remove a dimension or metric from your report, drag its tile off of the shelf.

You can also use the Report Editor to view and edit your saved reports. Learn how to open your saved reports

Sort table data

When you sort, nothing is removed or hidden from your table—it’s just reorganized. To sort a column, click the column header:

  • The first time you click the header, the column is sorted in ascending order.
  • The second time you click the header, the column is sorted in descending order.

Tip

Sorting multiple columns helps you organize 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 you sort last will be the primary sorting column.

Apply and remove filters

Applying a filter to your report hides data you don’t want to see. To see your hidden data again, just remove the filter.

There are two types of filters:

  • Report filters refine the dataset that is used to build your tables or charts. These filters are not affected by what tiles have been dragged on to the canvas, or what kind of table or chart you’re currently using to view your data. Use report filters when you want to explore a particular subset of your data. For example, you could use a report filter to view all your campaigns with the word “brand” in them, or focus on mobile traffic.
  • Table filters can be applied to specific columns in your table to filter out rows that don’t meet your specified criteria. If the column being filtered is removed from the table, the filter is removed as well. Use table filters when you want to focus your table on a particular set of rows. For example, you could use a table filter to hide all rows where impressions are less than 500. If you plan on converting your table to a chart, be aware that not all table filters can be transferred to your chart.

Example

Suppose you'd like to see all of the keywords in your campaigns that have lots of mobile clicks. First you create a table that shows keywords and clicks. Then you apply a report filter that narrows your dataset down to mobile devices. Now your table shows the mobile clicks for your keywords. However, you realize that there are a lot of keywords that have no mobile clicks, and they are cluttering your view. So you go to the column header and apply a table filter that only shows rows that have more than 0 clicks.

Apply a report filter

  1. Click the filter button (filter icon) in the sidebar of the Report Editor.
  2. Choose the dimension you’d like to filter. The view expands to display filtering options.
  3. Create your filter.
    • All report filters offer the option of selecting items from a list.
      selectable filter
    • Some report filters also offer the option for you to define the filter’s logic. For example, you could apply a report filter that only shows ad groups with 1000 or more mobile clicks.
      conditional filter
  4. When you’re finished creating your filter, click Apply. The filter is highlighted in yellow to show that it has been applied to your report.
  5. Repeat steps 2, 3, and 4 to add additional filters as needed.

To remove a report filter, click the close button (X) on the yellow highlighted dimension in the sidebar of the Report Editor.

Apply a table filter

  1. Click the triangle button (▼) in the column header. The table filter window is displayed.
  2. Create your filter.
    • If you’re applying a table filter to a metric, you’ll be able to define a logical condition to filter based on that metric.

      metric table filter

    • If you’re applying a filter to a dimension, you’ll be able to choose from a list.

      metric table filter

  3. Click Apply. The filter is added to the column and the logic is highlighted in yellow at the top of the column.

To remove a table filter, click the triangle button (▼) in the column header, then click Remove filter.

Use charts to visualize your data

The Report Editor allows you to view your data as a table, line chart, pie chart, or bar chart. Having multiple options for viewing data means you get to choose the most effective way to analyze and present your account’s statistics.

Format switching allows you to toggle between different reporting formats for the same data. To switch formats, select from one of the four options in the drop-down menu directly above the shelf.

format switching

Note

Different charts can accommodate different kinds of data. When switching between reporting formats, 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, be aware that not all table filters can be transferred to charts.

Save and download a report

Save a report

While viewing your report as a table, line chart, bar chart, or pie chart, you can save it by clicking either Save or Save as in the top right.

  • Use Save As to create a new saved report based on the current report.
  • Use Save to save your latest changes to your current report.

Your saved reports are easy to find. You’ll see them every time you click on the Reports tab. Simply click on any report to open it.

 

Download a report

Once you’ve created a report, you can download it by clicking the download button (download icon) in the toolbar. You can download your report in a number of formats, including .csv, .xml, and .pdf.

Schedule and share a report

Within the Report Editor, you can set up your report to run at specific intervals, and schedule them to be emailed to you or other people who have access to your account.

  1. While viewing your report as a table, line chart, bar chart, or pie chart, click the (calendar icon) icon above the shelf.
  2. If you haven’t saved the report already, you will be prompted to save the report before you can schedule it.
  3. In the drop-down form that appears, update the following settings:
    • Format: Choose to view your information in different formats (e.g., Excel or a .pdf file).
    • Send to: Email the report to yourself and/or others.
    • Frequency: Create an ongoing schedule to run the reports automatically.

    schedule report

  4. Click Apply.

Related links

Was this article helpful?
How can we improve it?
Sign in to AdWords

Get account-specific help and tips by signing in with your AdWords account email address, or learn how to get started with AdWords.