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.
How To Analyze Time-Of-Day Performance For Luxury Products
The importance of ad schedules varies across industries, services, and products. For e-commerce companies that sell luxury goods, ad schedules are more crucial.
One Week Left to Save 25% at Hero Conf London!
You still have time to join us for Hero Conf London, 24-26 October at etc.venues St Paul's at 25% off the conference price. But time is running out.
4 Common Questions Prospects Ask Me During The Sales Process
There’s always new, hot topics and questions we get asked by prospects to see what our company’s take is, and how we go about implementing from a services perspective. Read what our most common questions are.
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
Mobile Price Extensions Rolling Out In AdWords
It looks like "Christmas in July" has come to Google. Recently announced price extensions are designed to help mobile marketers qualify clicks and inform prospective consumers.
[New Whitepaper!] 4 Ways To Survive PPC Campaigns for the Healthcare Market...
This whitepaper will highlight four examples of how thinking at the corners can help boost your PPC performance in the healthcare industry.
Create Visually Appealing Reports With Google Data Studio
When we talk about what tasks tend to eat up a significant chunk of time, reporting is surely mentioned. You may want to explore another option - Google Data Studio.
Liveblogging 2016 DoubleClick Announcements
Today is the day we learn more about the latest DoubleClick updates. Follow along live as we share DoubleClick's announcements as well as our opinions.
The 2016 Top 25 Most Influential PPC Experts
After a month of voting, rigorous research and data analysis, we are excited to announce the wildly anticipated list of the Top 25 Most Influential PPC Experts for 2016.
[New Webinar with AdEspresso!] 4 Effective Strategies for Facebook Lead Gen...
In this new webinar, AdEspresso and Hanapin experts discuss four effective strategies to use Facebook Lead Gen Ads for your business.
PPC Hero Launches New Site!
We're excited to announce the launch of a brand new PPC Hero! We've redesigned the site to be more search friendly with a better navigation system and more opportunity to find the right resources quicker.
How To Get More Out Of Excel Solver
Excel Solver is a fantastic tool, but most examples only cover simple marketing use cases. We’ll cover the next steps of enhancing your models and how to automate the process.
Where You Should Focus Your Facebook Brand Awareness Efforts
Learn the basic metrics to focus on when you want to build awareness on Facebook.
Google To Release New Shopping And Travel Features
Several upcoming changes to Google Shopping and travel-related ads can be expected in the near future. Read to find out more.