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”? You can tailor custom columns to display specific views of your data, so you can quickly see the information that is most important to you.
This article shows you how to create custom columns and how to add these columns to your statistics tables.

Why use custom columns?

Custom columns offer a convenient solution if you’re interested in seeing only part of the data for a metric. Custom columns also allow you to make your own metric based on existing metrics in AdWords. 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 page, 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.
  • Then, he selects the Clicks metric and adds the Device > Mobile phones segment to it so it only shows clicks from mobile devices.
  • He adds ÷ and adds the Clicks metric again, which represents the total number of clicks.
  • Finally, he saves the new column.

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

Instructions

Follow the steps below to create a custom column.

Choose the AdWords experience you're using. Learn more

  1. Sign in to your AdWords account.
  2. In the left page menu, click Campaigns or Ad groups.
  3. In the upper right corner of the table, click the columns icon Columns, then select Modify columns.
  4. Click the Custom columns section, then click New column.
  5. Provide the following information for your column:
    • Enter a name that will be used as the column header.
    • Enter a description of the column that you’ll see when you hover over the column header.
    • Click + Metric, then select a metric such as clicks or impressions. For some metrics, you can narrow down the metric data by segment. For example, to show only clicks from mobile devices, select Clicks as your metric. Then, in the “Segment” section that appears on the right, click Device and select Mobile phones.
    • Use the math operators to create your column conditions, and choose the formatting of the column contents: Number, Percent, or Currency. For example, to calculate the percentage of mobile clicks in a campaign, select Clicks with the segment “Mobile phones” as your first metric. Then, click the ÷ operator, and select Clicks as your second metric. Finally, choose Percent as the column format. 
  6. When you’ve finished entering column information, click Save. You’ll be taken back to the “Modify columns” page. 
  7. Select your new custom column, then click Apply to view it in the statistics table.

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

Was this article helpful?
How can we improve it?
New Previous
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.