Tricks of the Trade: Len

It’s time for another installment on Excel 101! In this episode, we take an adventure into write ad copy, and use Excel to do the hard part for us.

old school copy rules

Will Smith is Yahoo, Kevin Kline is Google

Way back in the day (okay, it was like three years ago, but I like to make myself sound wise and experienced) there were different character requirements for different search network ads; what worked in Yahoo didn’t necessarily work in Google. Those wild west days are over though, and now everyone seems to have settled down on a standard ad copy setup:

25/35/35

That is to say you can have up to 25 characters in your title, and 35 in each description line under it. There are a bunch of other rules and requirements, but that’s a pretty basic rule to live by. And when you’re writing these haikus to industry you’ve got enough to worry about on your plate – is it on-brand? is it active? to capitalize or not to capitalize? – without having to count characters, which is where this nifty little trick comes into play!

Lemme throw it down for you:

  1. Choose three cells as your “writing” cells – generally I’ll pick three in a column since it mimics a common method of displaying the text, but you can do it however you want. Hell, put them scattered all over the screen if you want. For the purposes of explanation though, let’s say you’re using A1, A2, and A3.
  2. Choose three cells as your “counting” cells – again, I’ll generally put those next to the “writing” cells, but I won’t stifle your creativity here. Go ahead and put them wherever makes sense to you.
  3. In your “counting” cell, enter in the following formula: =len(A1) and copy it to the other “counting” cells.
  4. Write your ads, and watch as Excel tells you exactly how many characters you’ve used!

how to write ads in Excel

Oh, and you should probably check to make sure you’re obeying all the rules and regulations of the Supreme Deities (aka search networks).

Enhanced by Zemanta
Posted in Excel | Tagged ad copy, adwords, basics, excel, search networks, Yahoo | Leave a comment

Landing the Best Page

It happened again this morning. I clicked on a link in an email, and suddenly loud music was playing through my speakers. What? Huh? Argh!

Actually, to be more accurate, my reaction was something more like this:

What. Just. Happened.

But after closing the offending site, and pondering on why oh why oh why people think it’s a good idea to make a website that takes over your computer when you just wanted to see the schedule for the Brooklyn Flea Market, it got me thinking about web sites more. Specifically, what makes a good landing page?

Of course there are as many answers to that question as there are web sites on the interwebs. Even the definition of “good” can be different – one person might just want to increase the average time visitors spend reading his blog, while another business might want the highest possible number of shoes sold. But it all comes down to a couple of basic principles:

Make It Easy

Let’s all be honest with ourselves here: we’re lazy. Not you specifically – I’m sure you’re an energetic go-getter who wakes up at 5:30 every morning to take the dog on a five mile run before fixing yourself a full breakfast while reading the Times. I mean “people” as in, ya know, people. The kinds of people you probably want to spend more time on your site, or to buy your shoes. Those people are trawling the internet with the attention spans of your average pre-schooler, looking for a snippet of information every second, and wanting it presented directly in front of them with little or no guesswork. They don’t want to read about the history of your company or your vision for the future of environmental shoe manufacturing, no matter how fascinating it probably is. They want to see how many sandals you have, what colors they come in, and how much they cost. Zappos is a great example of this principal in action – search for “eco friendly shoes,” and their top result is a page full of just that. Eco-friendly shoes.

a good landing page

Who's a good landing page? You're a good landing page!!

Make It Easier

No seriously. These people are LAZY. You give them everything they want, right in front of them. They don’t even have to scroll down the screen! But when they add your magnificent animal-friendly, earth-sensitive slippers to their cart, let’s say you ask them to sign in first, and confirm via a code sent to their email. Oh sure, some people will go through that. Hell, I did just yesterday. But you know what a lot of people will do? That’s right. They’ll move on. Here’s the key: keep as few clicks between your people and what you want them to do. Want them to keep reading? Present them with a collection of related articles (*ahem* see the bottom of this post for just such a collection…). Want them to spend money? Make it easy for them to go from clicking on “add to basket” to entering their Visa and hitting “confirm”. Then ask them if they’ll pretty please give you their undying devotion and create a login, complete with email confirmation. To be fair, the average person probably still won’t do it, but at least you got their money first!

Easiness Is Anything But

Let’s say you’ve got a brilliant site. It’s perfectly streamlined, tailored to get your customers in-and-out in under ten seconds flat. That’s great. No really, I’m super happy for you. I hope you’re raking in the big bucks and can take early retirement in Cancun.

Now throw everything out and start over again.

Okay, not really. You can keep your hard-won site with its picture-perfect conversion rate, I’m just saying don’t become complacent. Sitting on your laurels means that in a year and a half you’ll be talking to someone like me, wondering out loud why sales are down 20% year over year. And while I promise that I’ll be sweet and supportive and make you tea, after you’re gone I’ll break out the whiskey. That’s because you haven’t done anything after you “perfected” your site. Times change. People change. What worked last year may not work this year. In order to really keep ahead of the curve you need to keep testing, all the time, even small things that seem inconsequential to you. I’ve worked with clients who just changed the background color of their site and saw conversions jump by 50%. No other changes. Just the background color. Did I mention they brought in 50% more conversions? There’s no way to predict that kind of result unless you’re testing. In a year or so they might want to revisit that same test too, trying out the exact same landing pages. Maybe by then new associations with colors will have sprouted up, and people will way prefer another color entirely. And if that happens they’ll be able to make that switch, and watch their conversions jump up again. And again, and again.

Hopefully by now you’re seeing the beauty in this system. Treating your customers like idiots is never a great idea, but treating them like fickle, easily-distracted teenagers might not hurt.

Just don’t take it too far.

bad landing page

do NOT put this on your landing page

Posted in Strategy | Tagged Conversion rate, Landing page, strategy, testing | Leave a comment

Tricks of the Trade: Duplicates in Excel

If I could marry Excel, I would. No seriously, I bet it would give me a beautiful engagement ring and we’d have a beautiful ceremony on the Brooklyn Bridge. My mother would cry.

photo credit: Justin Paine

But I digress. The point is that I’ve picked up a trick or two over time using Excel that I use on a disturbingly regular basis for someone who went to a liberal arts college and got a BA in English. And quite possibly the most commonly-used one I have is taking out duplicates within a list – very useful when you’ve got a list of 15,000 keywords and want to make sure you’re not bidding on the same thing twice!

Here’s how it works:

  1. Alphabetize your list in column A
  2. In B1 enter in the following: =IF(A1=A2,”DUP”,1)
  3. Drag that formula down to the bottom of your list in column A
  4. Copy-paste column B as value (this just gets rid of the formula so Excel doesn’t show you weird results later – not necessary, just looks nicer)
  5. Filter column B to show only results that say DUP
  6. Erase all those rows
  7. You’re done!

Hooray! No need to thank me, really, just knowing I’ve done a service for mankind is enough.

Posted in Excel | Tagged basics, excel, keywords, tools | Leave a comment

Quick Keyword Creations

Ah, keywords. The bread and butter of SEM, and the bane of most people who work in SEM. Time-consuming if you do it right, potentially disastrous if done wrong, always a topic for contention and disagreement. Why, I’ve even seen fist fights break out over the best way to manage keywords!

a metaphor for ignoring keywords

a metaphoric carpet

Okay, no, I haven’t really. But I do think people take their attitudes about keywords to extremes. Either they’re these complicated strategic elements of highly sophisticated campaigns or they’re brushed under the metaphoric carpet of sexier jargon (testing, dayparting, we-can-give-you-a-CPA-of-just-$5, etc).

Here’s the thing: without keywords you’ve got nothing. They’re the skeleton you build your… uh… Frankenstein creature of an AdWords campaign on. Okay, bad example. My point is that you need to make sure that you’ve got good ones. Actually read the site you’re writing keywords for. Actually read they keyword lists you’re making. Actually read the ads you’re assigning to the keywords, and ask yourself if they actually make sense (that goes double if you’re using keyword insertion!). Yes, it’s an awful lot of reading. I know. But I think you can do it. You’re up for the challenge!

And so, at the risk of revealing all my secrets and completely destroying my value as a freelancer, here’s my keyword process:

  • Check out the website. Make a list of the most important keywords as you see them. Don’t worry about catching every single keyword, just try to get all the major topics/products/messages.
  • Use a keyword tool or two.
    an example of bad keywords

    while delicious, this has nothing to do with furniture

    Enter in the list you made above for a “top tier” list of keywords, then enter in the URL (if it allows you to) for a “messier” list you’ll have to pay more attention to. I used to be completely against the use of any keyword tools, because I saw so many bad examples – I once had a client who sold furniture, and whose previous agency had them bidding on keywords like “I’m gonna hire a wino to redecorate my living room.” Seriously. But they can be extremely useful, and major time savers, just so long as you follow my next step…

  • Read the keyword list you’ve generated!! Pay extra attention to any list that’s been generated just off the URL and not your specially hand-made list, since a computer will think all sorts of nutty things are related to your site if you don’t give it any direction (see wino example above). Pull out any keywords that make no sense. Pull out any keywords that refer to Paris Hilton rather than the Hilton hotel in Paris. You get my drift on this one. Even if you just go through the high-volume top 200 keywords, it’s worth your time, I promise.
  • De-dup. I know it’s obvious, but take the two minutes to make sure you’re not going to add the same keyword twice in two different places. Not only is it messy and potentially a headache later, but it also means you’ll be bidding against yourself, potentially paying higher CPCs. And nobody wants that.
  • Use the tools the God of Google gave you. Look at the search terms you’re matching against on a regular basis. Add the relevant ones in as actual keywords (you’ll pay lower CPCs if you’re matching on Phrase or Exact match), and make sure to Negative match on anything that’s irrelevant. Check out the search-based keyword tool on a regular basis for new ideas. As time goes on people might start searching using different terms for your products, and you want to make sure you’re maintaining relevancy. These tools will let you do that without even having to think much. Double-win!
  • Revisit your site. I’m not saying this has to be a regular thing, but at least once or twice a year head over to your site and pretend like you have no keywords. Put together that top-keyword list again. If you’ve got time maybe even run it through some keyword tools. Then de-dup it against your current list. I promise you’ll come up with something new and brilliant that slipped through the cracks last time. I don’t care if your site hasn’t changed in eight years (seriously? eight years? you couldn’t even be bothered to do a little quick SEO work??), you’ll think of new keywords each time you come through. The human brain is funny like that.

I know, it seems like more work than just sticking everything through a tool, then setting it to run on manual. It’s also more work to change bids on keywords instead of just sticking a budget cap on the campaigns. It’s work that will make you more money though, and win you the praise and admiration of your peers.

Get it? AD-miration?

Bad puns are usually the sign that I should stop talking. Did I mention the Frankenstein creature of AdWords…?

building your google adwords account

Posted in Basics | Tagged adwords, basics, google, keywords, ppc, sem, tools | Leave a comment