Build Custom Formulas Within Custom Columns

By William Larcom | @Will_Larcom | Account Manager at Hanapin Marketing

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+)

Screen Shot 2016-01-27 at 4.14.40 PM

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.

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.

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.