Search
Clear search
Close search
Google apps
Main menu

Create custom columns

Do you wish your columns only displayed a specific portion of your data? For example, instead of “CTR” (clickthrough rate), would you prefer to have “desktop CTR” and “mobile CTR”? Custom columns can be tailored to display specific views of your data and added to the statistics table in your Campaigns or Ad groups tab. They allow you to tailor the presentation of your data so you can benefit from the information that is most important to you.

Why use custom columns?

Here’s an example: Matthew’s business uses a metric called “Mobile share of clicks,” which is defined as mobile clicks divided by total clicks. There's no column for this in the Campaigns tab, so Matthew decides to create his own custom column:

  • First, he names the column “Mobile clicks” and adds a description, “This column calculates mobile clicks divided by total clicks.” The description will help other users on his account understand what the column displays.
  • He then selects the Clicks metric and adds the Device segment to it.
  • Finally, he adds ÷ and Clicks and saves the new column.
Custom column creation example

Now Matthew can view this metric in the Campaigns tab any time he needs to.

How to create a custom column

If you have a certain metric you'd like to see reported in a custom column, you can create it using the formula builder.

  1. Sign in to your AdWords account.
  2. Click the Campaigns or Ad groups tab.
  3. Click the Columns drop-down button, and then select Modify columns.
  4. Select the Custom Columns category on the left.
    • If you’ve never created a custom column, a dialog box is displayed. Go to the next step.
    • If you’ve already created a custom column, click +Column.
    Dialog box
  5. In the "Column name" field, enter the name of your new column. This name will be displayed in the column header. Column name
  6. In the “Column description” field, enter a description of your column. The text you enter here will be displayed whenever someone hovers over the ? icon next to the column name. Column description
  7. Select a metric, such as clicks or impressions. Select metric
  8. (Optional) You can also use a particular segment of the metric you've chosen. For example, to show mobile clicks, click the drop-down on Clicks, select Device, and click the () icon next to "Mobile devices with full browsers." Segment metrics
  9. Use the drop-down menus and math operators (+, -, x, and ÷) to build your formula. Build formula
  10. Choose the kind of formatting you'd like for the column contents: Number, Percent, or Currency. Choose format
  11. When you've completed your formula, click Save.
  12. Click Apply to add your column to your statistics table.

Just like standard AdWords columns, custom columns can be filtered, sorted, downloaded, and used to customize your performance summary graph above your statistics table. Learn how to customize your performance summary graph

Was this article helpful?
How can we improve it?
Special Reports

Get Google's guide to reporting and analysis in AdWords. Learn how to create meaningful insights that lead to performance improvements for your account. View the guide now.