5 Excel Time Savers For PPC Ad Writing
September 13, 2012
For the next edition of our Excel for PPC series, I’d like to show you some cool tricks I use for Excel when writing ads.
1. Use Ad Groups as Ad Titles
For this to work, you need to structure your ad group to describe perfectly what you’re selling or advertising. Like, if I’m selling coffee mugs, and I decide to make an ad group for every color. So, my ad group will be “Purple Coffee Mugs”.
For the Headline, I can either just do the formula =B2, which is my ad group, or I can use the formula I’m talking about in tip # 2 to add some text in. Because Purple Coffee Mug is sort of long, I’ll just leave it at that for this example.
2. Use the ad group title and the formula to insert text for one of your description lines to make your ad targeted for good quality scores and high click-through rates!
For desc. line 1, I’m going to use a call to action of “Buy Now!” and an adjective of “Pretty”. Yeah, I know these aren’t the best ads. But, they’re examples!
The formula reads like this: =”Pretty “&B2&”. Buy Now!” So, you do the equal sign, quotes around whatever you want to be in front of the ad group title, like an adjective. Don’t forget the space! Then you need to put the & symbol, click the cell of the ad group, the & symbol again, and then quotes around your last bit of text. I put a period after “Pretty Purple Coffee Mugs”, so I put the period and the space in the second quotes. It looks like this with that exact formula I use above:
3. Pick two benefits, features, or call to actions to test against each other in desc. 2 and fill them in for each ad group.
For Desc. line 2, I like to have two ads testing in each ad group. So, I can set up a test against two different benefits. In this case I’ll test 30% orders $50+ against “Free Upgrade to 2nd Day Ship Today.”.
So, now we’ve got this:
4. Use ctrl+f and replace for the rest of your ad groups and ads!
So, what I do next is fill out the rest of the ad group and keyword information. I’ll have an ad group for yellow, orange, and polka dot.
A quick way to do this is to copy and paste what you just did for purple and do a clt+f for purple and replace with the new color.
So, I just keep plugging away at this until I’ve built everything out.
5. Start with templating adjectives, products, services, etc. if you need a more complex system.
If you have a diverse product that isn’t as easy as changing the colors around, just do some prep work for that by templating. So, if you have 10 products with 25 different adjectives each, go “product 1 adjective 1, product 1 adjective 2, etc” for the ad groups, and you can ctrl+f and replace with what they should read. Just prep a list before hand that corresponds a number to each product/service and adjective. Obviously character limits will likely cause you to have to go in and do some custom changes, but over all this should save you a load of time!!
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.