Create custom reports in Report Editor

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.

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.

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.

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.

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.