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
The Opportunities Tab: AdWords vs Bing, A Friendly Match-Up
Dive into AdWords and Bing opportunities tabs and see how they compare. This includes accessibility, features, and performance insights.
How to Drive Calls that Actually Convert
Our experts are here to explain how gaining call tracking data can help you close the gap in your customer journey and tailor their experience so they actually convert.
New Facebook Analytics Updates from F8
Learn about journeys and automated insights, new tools announced at Facebook's F8 conference for the Facebook Analytics tool.
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
Spotify Advertising: The Why and How
This blog post gives you the rundown on Spotify, including why and how you might advertise on Spotify's new self-serve ad platform, Ad Studio.
5 Facebook Ad Settings to Audit In Your Account
5 Easy settings to audit in your Facebook Ads account to improve performance and understand website traffic.
Analyzing the AdWords Distance Report
The distance report provides a unique view of your geographic data. The report helps users understand how distance from a location impacts search ad performance.