Troubleshooting Lookup Functions in Excel
It’s easy to get discouraged from using Excel when we run into errors. This post guides you as you troubleshoot your Lookup functions so you don’t refrain from using them!
Okay, so it’s not AdWords directly who’s picking the winner, but I put together a new statistic to rank each and every team in the NCAA Men’s Tournament by some of the metrics that matter in PPC: namely search volume and cost per click. It’s as if the RPI was replaced by a Google Pricing Index (a totally made up statistic created solely for the purposes of this exercise). Which team in the field of 68 would spend the most money in Google if you bid on all of the schools via Google AdWords?
Here’s a quick explanation on how the bracket was calculated:
Each school was run through the AdWords Keyword Tool in two different forms: first as (School Name) (School Mascot) and then again as (School Name) Basketball. As an example, our beloved Indiana Hoosiers were searched first as Indiana Hoosiers and then again as Indiana Basketball. I took the estimated monthly search volume for both queries, averaged it out, and then multiplied it by the average cost per click that Google estimated the phrases would return for them.
After an exhaustive (and exhilarating for a nerd like me) run through Excel, Google AdWords’ bracket has been filled out.
Without further ado, your 2013 Final Four Champion: The Oregon Ducks!
After a Cinderella trip through the exceedingly difficult Midwest region, Oregon topped Miami in the championship game to claim the title. Here are the stats of the winners of each region:
I’ve taken the liberty of entering this bracket into PPC Chat’s tournament on ESPN to see how Google does. If the only thing that comes out of this is a bunch of PPC professionals besting Google’s prediction of a 12 seed running all the way to a title, then it’s still a net win. (And yes, I recognize that Google is in no way actually affiliated with this bracket and it was assembled by some schlubby manager in the midwest, but I’m still going to feel a tiny bit good if my personally selected bracket does better).
If you’re curious, I’ve pasted the results of each region below. It favors bigger schools, as you would anticipate seeing that it was based on search volume. As someone who has long championed the underdog, it was cool to see a final four without any one seeds at all.
How’d Google do? You think Oregon can replicate this in real life?
Browse By Category
In December 2017, Google released a set of statistics about the Christmas shopping season. Use these insights in AdWords to make this your best December ever.
Google's First Page Bid Estimates can't be trusted. Adjust your bid strategy based on average position and not using this metric.
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
Organization is key to success in the PPC industry. Here is a guide to organizing your space, time, resources, and workload for efficient PPC management.
Proper Work-Life Balance Is Something Easily Forgotten. Here Is A Reminder That It's Okay To Have A Life Outside Of Work & Constantly Checking Performance.