April 10, 2020
3 Ways to Use Google Trends to Shed Light on SEM Performance
With so many layers of bid adjustments in any well-managed PPC account – for device, geographic region, and ad schedule just to name a few – it’s not hard to imagine how the effective bid for a given query can deviate from your keyword level bid. This script analyzes keyword bids and bid adjustments in aggregate, and produces a spreadsheet with the actual CPC ranges for a given campaign or keyword to provide you with a more accurate picture of what you are actually bidding. All you have to do is paste it into a new AdWords script window, input your spreadsheet URL and run it! One caveat – scripts cannot access audience data so the output ranges will not take RLSA or demographic bidding into account.
It’s not uncommon for search marketers to A/B test ad copy or landing pages by evenly rotating ads within each ad group. But imagine the impact you can have on conversion rate by testing any aspect of your account with this script. How does it work? First, duplicate the campaign in question and alter what you plan to test (maybe it’s a setting like enhanced cost per click, or separating match types by ad group) to create your control and experiment. Next, apply labels and make a few adjustments to the script per the instructions, including selecting a confidence threshold. The script will pause and un-pause each campaign every hour so each campaign gets an even share of traffic, and then it will email you when your test has achieved significant results.
Several years ago, Google shook up the search world by removing your ability to choose if you want your exact keywords to match to “close variant” search terms. For some advertisers, this presented a real problem. And while most have likely bolstered their negative keyword lists and honed their strategies by now, there are still some instances where never-ending close variants are driving up costs. This script will pull a list of close variant search terms that matched to exact match keywords, and automatically add them as negatives at the campaign or ad group level.
Ever click through an ad in your account to find the landing page has been removed, or resolves in an error? Especially for larger accounts, this script can be a huge time saver and important health check. All you have to do is input which status codes are acceptable (maybe 301 and 302 redirects are fine, but 400 & 500 level errors are not), and if you want the script to pause the bad ads or simply notify you via email. Schedule it to run weekly, and you’ll never have a landing page error again.
What in the world is an n-gram? An n-gram is a phrase containing n(umber) words. This script mines your search query report to find your best and worst performing 2, 3 and 4 word phrases (however many you want, really). You can use this script to glean insight into your keyword universe. Are there hidden gems that you can expand? Or are certain search terms, like those with “promo code” for example, driving up costs?
So there you have it. With a few minutes of setup, you can save yourself tons of time, and produce some high-level analyses, by setting up a few simple AdWords Scripts.