Build Custom Formulas Within Custom Columns
January 28, 2016
While paid search advertisers have utilized AdWords custom columns for over a year now, a recent announcement by Google will add an additional element of personalization. Custom columns will now support the inclusion of custom built formulas.
Custom columns, which grant marketers the ability to segment unique key metrics, have acquired an extra layer of potential application. This update opens the door for originally constructed formula based metrics to be displayed directly within the interface. Simple computations such as addition, subtraction, multiplication, etc. can be incorporated into a given segmentation in order to provide a metric important to an individual account.
Google included a handful of useful examples within their announcement:
“For example, to see the percentage of clicks you get from mobile devices, create a custom column that divides mobile clicks by total clicks. Or let’s say you’re a shoe retailer and enjoy a 40% profit margin for each pair of shoes you sell. To understand your total profit for each sale, ensure your conversion value column tracks revenue. Then, create a custom column that multiplies conversion value by 40% and call it “Estimated Profit.” -AdWords(Google+)
Custom columns utilizing a custom formula retain the ability to be further sorted, filtered, and exported. Similarly, automated rules can integrate these metrics into their functionality.
Construction of a custom formula is a fairly straight forward process. Simply select modify columns within the interface, navigate to custom columns, and click the red “+ Column” button. From there the metric is customizable to satisfy a wide array of needs. Support for setting up custom columns can be found here.
Browse By Category
Update Bids and Monitor Changes with AdWords Scripts
Explore different ways to use Google Sheets and AdWords Scripts to change bids and handle uploads. Get started with creating your own bidding system!
Google Speed Update – What It Means & The PPC Impact
The Google Indexing Speed Update implemented site speed as a SERP ranking factor for mobile web pages. Learn how the update could affect your PPC campaigns.
Dynamic Search Ads for Advanced Users
Explore a few advanced ways to use Dynamic Search Ads in your account!
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
What is 3rd Party Data and How Do You Use it?
Data is everywhere in online advertising. 3rd party data is an extremely useful way of getting your message in front of the right prospects. But what is 3rd party data and how do i use it.
Launch Your Multi-App Marketing Strategy
Understand what three things you need to know to start your Multi-App Marketing strategy.
Time for an Honest Discussion about RSA's
Join Hanapin’s Matt Umbro and Directive Consulting’s Garrett Mehrguth as they engage in an honest discussion about responsive search ads, walking through all the pros and cons and advice around using the new ad type in your campaigns.
Load More »