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 iconnext 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 .

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 iconabove 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 adsand 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 iconin the column header, and then click Remove filter.

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 adsor 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 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.

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 lowor Low to high.