These AdWords Scripts Will Help Manage Shopping Ads
March 22, 2016
Last week I had the pleasure of returning to Portland, Oregon, site of the last US-based Hero Conf. Some of the locals had heard my talk on Shopping Ads and invited me back to cover the same topic at SEMpdx. They told me this would not be an audience of PPC newbies and since I’d already covered the basics of Shopping Ads, I decided to combine this topic with my perennial favorite: automating AdWords with AdWords Scripts.
I’ll share some of the scripts I wrote for that conference in the hopes that some of you will find these useful and help save you some time.
Find Duplicate Product Targets
Just like we don’t like adding duplicate keywords to accounts, we think it’s a bad idea to accidentally target the same product through multiple product groups. The problem is simple: whenever you accidentally have a duplicate target in AdWords, whether it’s a keyword or a product, this leads to unexpected outcomes.
Say you look at the latest conversion data and realize you’ve been bidding too much for a product so you decrease the bid for its product group. If that same product is also targeted from another product group where the bid is now higher than the one you just lowered, it might start to serve ads. Instead of lowering the CPC, you’ve just shifted traffic from one place to another. Not an ideal situation.
So here’s a script that will help you find situations where the same product is targeted by multiple product groups. It does this by looking for products that have received impressions from multiple product groups over the same date range.
Avoid Traffic From ‘Everything Else’
Just like duplicate targets reduce our control over AdWords, so does traffic emanating from the product group of ‘everthing else’. To draw a parallel with keywords, it’s like buying the broadest keywords you can imagine and hoping for the best. Newbies continue to make this mistake but not PPC heroes like us, right? Well, it turns out that even the best of us probably fall victim to traffic spikes from ‘everything else’ and here’s why.
It’s useful to have a bid for the product group ‘everything else’ so that it can serve as a catch-all bucket for any products we didn’t include in a better-defined product group. The query data we get from this can help us optimize our campaigns.
But what if a retailer who sells t-shirts created product groups by brand and then later starts to sell a new brand of shirt. That new brand doesn’t fit the existing groups so it will automatically fall in the ‘everything else’ bucket. Unless we’re constantly checking that the feed is in sync with the AdWords product group structure (like we do with Optmyzr’s Shopping Campaign Refresher tool – that’s my company) or talking regularly with our clients to make sure they’re not changing the feed structure or changing their product mix, ‘everything else’ will at some point see traffic spikes.
I wrote a script that tells you the percentage of traffic coming from undefined product groupings like ‘everything else’. Run this script regularly and when the ratio gets too high, re-evaluate your product groupings to see if any new products need their own product groups.
Manage Shopping Bids To A CPA Target
We should probably all manage ecommerce campaigns to ROAS targets (conversion value / cost) but a lot of clients still haven’t figured out how to pass the data about the value of the sale back to AdWords. It’s not technically challenging but inertia at companies of a certain size still makes this a difficult proposition. So I wrote a little script that uses CPA targets instead.
The point of this script is really just to show how easy scripts can be. In 14 lines of code, I wrote a script that sets the CPC of a product group based on its historical conversion rate and a target CPA. If I didn’t care to make the code easy to read, I could have done it in 10 lines.
So grab this code and tweak it to work with ROAS, to send you alerts or do something else that makes it fit your needs. You’ll probably also want to build in some additional conditions for what to do when there are few or no conversions.
Download Shopping Reports
When it comes to bidding for Shopping ads, you may find that your own business data can tell you something about the likely conversion rates. In an example I received from the team at whoopapp.com, they said that conversion rates are different for a shoe retailer who has all sizes in stock versus one that has a more limited number of sizes ready to ship. That makes perfect business sense and if you have an insight like that, you could add this sort of data in one of the five custom labels.
Then you can run the reports and calculate exactly how much difference there is in performance for the various labels. Here’s a simple script that downloads the shopping report and saves it to your Google Drive.
All these scripts are simple but they do things that we would otherwise have to do manually. By scheduling these to run periodically, we can offload repetitive work to the machines. You might think these are a decent starting point but wish they could do just a little more. And that’s the beauty of scripts. Copy my code, tweak it, and make it do exactly what you need.
Leveraging Analytics For Remarketing: Picking The Ripest Fruit
Remarketing prevalence is well founded based on competitive returns in both volume and efficiency. With that said, this "low hanging fruit" world isn't always easy to pick.
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.
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
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.
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.