So you’re staring down an account build. It’s monstrous. There’s several thousand products, over a hundred store locations nationally, distributers & competitors to build out and that’s before you come anywhere near the brand and category-level generics. Or display.
Oh, and the client wants it live in two weeks. Tops.
Sounds like a nightmare, but it’s totally doable. Put down espresso number 5 and step away from the ledge! With the right approach and some clever tricks it’s possible to build a massive volume of targeted inventory in a manageable amount of time.
Due to my pathological fear of lists, here are some things I consider to be essential skills for building accounts, in no particular order.
Did Da Vinci work in an open plan office? Probably not, I’m not an expert on professional standards in the high renaissance period.
It’s going to be almost impossible to create art if you’re distracted by the circus of office life. It seems you can’t shake a tree in North Sydney without a ping pong table and a couple of executives clutching paddles falling out of it.
Isolate yourself somehow or you’ll never produce anything of value. That’s why Da Vinci invented noise cancelling headphones. It’s true, look it up.
I’m a bit of an engineering geek, I love looking at the way things are put together and how they work. Take a bridge; even the grandest, most impressive feat of engineering is made up of lots of little parts: girders, cables, brackets, rivets, graffiti.
If you want to win in the search market, you need to engineer the highest quality score for your inventory sets. This means a relevancy chain from search query, through matched keyword, through the served ad, through to the landing page. Use the same variables to build your keyword templates as well as your ad templates. Connect the dots to win a good quality score!
You need to take that immense data set and make it manageable. Break it down into its constituents and construct a list of elements you can use to inform your build. Products are easy, the data set probably already does that for you. What about the rest? Don’t just throw your Brand + Geo keywords into the one campaign; segment by state and then segment ad groups by cities/towns/neighbourhoods. How are you going to manage your match types? (Hint: don’t throw them all in the one ad group. Please.)
Take your list, run keyword research on it & expand the list. Rinse and repeat.
Logical Naming Convention
Remember when you were a kid and your room was a total disaster? Remember that time your mum made you clean it up and it took forever, but you found all that cool stuff you thought you’d lost & forgotten about? Accounts aren’t like that, but they’re a bit like that and that’s good enough for my therapist.
The way you name your campaigns serves as a map of the account. This is critical in situations where your account is a big, hairy monster with elements coming on and going off at different times, campaigns targeting different geos, or involving multiple channels.
Keep it clean by implementing a standard naming convention which you can use across all of your campaigns & ad groups, across all of your channels. An example of an ad group naming convention would be something like this:
Geo | Channel | Network | Type | Initiative | Variable | Match Type
Here, the campaign naming template describes exactly what the campaign contains, who it’s targeting, what it’s supposed to do and what variable is being used to construct the keywords & ad copy templates. Let’s say you have a SEM campaign targeting users in New Zealand searching for backpacks, specifically hiking packs. That ad group naming convention would look like:
NZ | G | S/SP | NonBrand | Backpacks | Hiking Packs | Exact
Might be a mouthful, but it eliminates ambiguity and will make your life easier when the thing finally goes live.
Introducing: the nested IF statement. By using only a few excel functions you can construct hugely robust templates that will test your data and return targeted values you specify. Here’s a boring, technical example of a headline template:
=IF(LEN(“Headline Option “&A1)<26, “Headline Option “&A1,”Option 2”)
This formula will test the character count of “Headline Option ” and whatever is in cell A1. If the combined character count fits in the headline field it will go with that, if not, it will go with “Option 2”. Instead of defaulting to that, you can put another IF(LEN statement to test another line of copy.
Test progressively shorter lines of text to make sure you are using the most targeted line of copy for your variables as you can. Finally, end the formula with a default line of copy for when nothing will fit in a headline. Usually this is a brand message or a category-level statement.
You can do other things too, start your formula with IF(ISNUMBER(SEARCH(“Brand”,B1)) to test whether the variable in your Type column is for brand keywords. Then you can write the formula to split into two streams, one template for brand headlines and one for product-related keywords.
Play around with formulas and see what you can get them to do. You’re a search professional; that means you’re already straddling the line between genius and crazy. Use your ingenuity and start working smarter instead of harder.
Finally, never stop looking for a better way to do things.