There aren’t many guarantees in life, and even fewer in marketing. But in the world of search engine marketing (SEM), using paid search (PPC) to rank on a search engine results page (SERP) for a given term comes pretty close. That’s why PPC is such good business for Google, which still generates 96% of its revenue through advertising -- because marketers know when they invest in PPC properly, they can get pretty close to guaranteed placement in the SERPs and help you generate leads.
The problem is, many marketers suffer from poor PPC campaign management, which ends up costing them way more money than they need to spend and delivering underwhelming lead generation results. So, how do you do PPC "properly" so you actually get leads at a reasonable cost? It comes down to intelligent campaign structure. And how do you master intelligent campaign structure? You use a template.
That's why we created a free PPC campaign management template that will help you -- or if you're an agency, the clients you're running campaigns for -- set up a full-funnel campaign structure that follows PPC best practices. Once you do that, you'll be better positioned to maximize the return on your PPC investment. We're going to show you how to use that PPC template in this blog post -- so download the template now so you can follow along with the explanation!
Bonus: If you're running PPC campaigns for someone who doesn’t understand the importance of good campaign structure, this template will also act as a deliverable that will enlighten your boss or clients.
Alright, got your template handy? Cool ... let's get started!
Tips for Using This Template
Before we get started, let's go over a few tips that'll make using this template even easier:
- You will want to clear out the example data I have in the template such as keywords, campaign and AdGroup names, ads, and destination URLs. Unless, of course, you're running a fruit stand named after me.
- Be careful not to erase columns E, G, and I. They contain formulas that will help you in subsequent steps.
- Any red markers you see in the top corners of the cells contain helpful tips and FAQs -- if you ever forget what a cell is used for, those are good reminders.
Step 1: Understand PPC Campaign Structure
Before we actually do anything with this template, it's important we're all on the same page about PPC campaign structure. Far too many marketers ("too many" being defined as any number greater than 0) will just set up an account, create an ad, direct the ad to their home page, pick some keywords and hit go. This is not the way to do things.
With AdWords, you have the opportunity to create multiple campaigns. Each campaign may contain several AdGroups, and each AdGroup may contain a few ads and multiple, similar keywords. It's wise to create multiple campaigns because you can set daily budget caps, day-parting, and select geo-targeted regions at the campaign level. If you're bidding on generic keywords and branded keywords, you'll want to put these in separate campaigns because the economics around these two types of keywords will likely be very different. As you can see, your template reflects these best practices, providing space for several different campaigns, AdGroups, and ad variations within those AdGroups.
Step 2: Identify Your Landing Pages
The "Destination URL" is the place on your website where you want the PPC traffic to end up. Because there is a marginal cost associated with each PPC visitor you attract, I recommend you choose a landing page URL as your destination URL. Do not drive them to your home page or a blog article in the hopes that they will stumble upon a lead generation form somewhere; that’s the job of organic search. Drive them to what we here at HubSpot define as a landing page, a web page with a form on it -- and don't forget to put in a tracking token so you know where these leads are coming from.
I know the big boys don’t always follow this rule, but the big boys also have millions of dollars in budget that needs to have evaporated at the end of the month. Make it easy on yourself and let your landing pages define your AdGroups and campaigns as you see in this template.
You will notice that, within an AdGroup, the Destination URL is the same regardless of the keyword or ad. If you really want to drive a keyword to a different landing page, then create another AdGroup -- or in the extreme, another campaign -- for that keyword.
You should also keep your sales funnel in mind when you identify these landing pages, and think about which part of the sales funnel each landing page and offer speaks to. For example, an educational PDF about an industry concept would be appropriate for a top-of-the-funnel offer, while a coupon or a demo would be at the bottom of the funnel. You will want to manage each part of the funnel separately, and therefore create separate campaigns. If you scroll down in your template, you'll see that there's dedicated space allotted for campaigns in all of these funnel stages.
Step 3: Build Your Keyword Strategy
Next, you will select the keywords that are relevant to the landing page and offer. Make sure to keep them as relevant as possible to increase the chance that each visitor you pay for completes the form on the landing page. Yes, it would be nice to rank for certain keywords, but if the landing page doesn’t answer the keyword queried, think twice. Or better yet, create another offer and landing page that speaks more directly to the keyword.
You can use free tools like the Google AdWords Keyword Tool or, if you're a HubSpot customer, our Keywords tool , to understand the actual search volumes and costs around each keyword you select. If you're running short on inspiration, these tools can help you think of other keywords to include in your campaign -- but always consider the costs of those suggested keywords and keep your economic interests in mind.
If this is your first time, it would be wise to read up on how to design a killer keyword strategy . And, in the case of AdWords, you could become a quick expert by becoming knowledgeable on the keyword quality score .
Step 4: Create Your Ads
This is the fun part! Both Google and Bing allow you to create more than one ad for each AdGroup (hence the "group" terminology) and the service will rotate them until it notices that one appears to drive a higher clickthrough rate (CTR). This is how A/B (and C and D) testing works . While it's optional, you should take advantage of the ability to create more than one ad.
Writing an ad is a bit like writing a haiku. There are character limits for each part, and it can be a little aggravating figuring out how to best complete the ad. You are allotted 25 characters for the title, 35 characters for the display URL -- the URL that's displayed in the ad, not to be confused with the destination URL -- and 35 characters for each line of copy. But if you're using this template , don’t worry about keeping track! The cell to the right of each ad component will count characters and turn red when you have gone over the limit. Handy, right?
In my observation, the title has the greatest influence on an ad’s CTR. It's wise to include a keyword in the headline to draw a user’s attention to your ad. An even better practice would be to use dynamic keyword insertion . I find the copy to be less important, but you certainly can't just put gibberish in there. Search engines have editorial policies for what you can and cannot put in an ad, and they change it frequently, so it's your job to stay up to date on them. A good rule of thumb, however, is to simply try to provide a congruous experience for searchers -- from seeing your ad in the SERPs to completing the form on your landing page.
Finally, there's the tricky matter of the display URL. You're only allowed 35 characters here, but it's unlikely that your destination URL, the actual URL for your landing page, will be that short. So the search engines allow you to create a display URL, which may not even be an actual URL on your website. It is critical, however, that the domain in your display URL be the same as the domain in your destination URL.
Step 5: Share the Completed Template With a Decision Maker
Whether you're doing PPC for your business or a client, your completed template will ensure you're aligning the decision-maker’s expectations with the realities of a productive PPC campaign . If you're the decision maker, this template will help you really think about what you're doing with the money you're spending on PPC.
The end result is that you'll have created the sort of congruous user experience that search engines like to see. That can benefit you in terms of your positioning in the SERPs and, ultimately, your costs. It will also grant you the agility you need to swiftly reallocate and modify budget as you respond to changes in the marketplace, and the drive to maximize the return on your PPC spend.
How do you manage your PPC campaigns so you maintain intelligent campaign structure?
Image credit: barron
Joseph Botelho 9:13 AM on November 29, 2012
Great information to become very effective with any PPC campaign step by step making sure you fully understand how to win against the big boys. Great advise, will share this all the best..
Garaen 10:16 AM on November 29, 2012
This is very cool. Thank you for doing the work. It saves me the time of having to write formulas. I love the word count feature for characters. Furthermore, keeping track of the ads is much clearer than in Adwords and should help with explaining to clients what has been done. Clear as water!
Eric Marshall 10:59 AM on November 29, 2012
This is extremely useful Matthew - thanks! We do use "intelligent campaign structure" for our client's PPC accounts, but this template will help make setup and management much more efficient.
Yen Pham 11:13 AM on November 29, 2012
Thank you for great information. The template looks very cool. I would love to try it. However, I had trouble opening the zipped file. Is there any other way to get the template?
Thank you.
Mary 2:32 PM on November 29, 2012
Awesome. Can't wait to see the results.
Jeannette 2:51 PM on November 29, 2012
Thank you, thank you, thank you HubSpot!
Tim 3:44 PM on November 29, 2012
I'm having trouble with the zipped file too. There's no actual excel document when I open it. Any other way I can get the excel template?
Pamela Vaughan 3:59 PM on November 29, 2012
Hey Folks. We just tested the download on a couple different computers (Mac and PC) and browsers, and it worked fine. Are you using an older version of Excel? Hope we can help!
Stephanie 5:32 PM on November 29, 2012
What if your ads are strictly mobile and clicking on your ad calls you directly. How can you manage to get a good quality score without a landing page?
Dan 8:02 PM on November 29, 2012
Thanks for sharing! I downloaded it but am not able to open it up. I can't find the Excel doc after unzipping the file. Any other way to get it? Thanks.
Mike 8:07 PM on November 29, 2012
Wow, Matt's Fruit stand is exactly what I was trying to market! :-p.
Anyway, thanks for the info. PPC already makes far more sense than it ever did.
P.K Bibi 9:48 AM on November 30, 2012
If you are in the PPC trenches every day, you appreciate how useful a tool like this can be.
Most of the campaign I review, the number 1 problem I see is poor campaign structure, leading to some serious financial waste & management difficulty.
Pamela Vaughan 10:47 AM on November 30, 2012
Hi folks! For those of you having trouble opening the template, we believe what's happening is the file type isn't compatible with some older versions of Excel. We've just re-saved it as a file that should be more compatible with those older versions.
Please try downloading the file again through your confirmation email/the thank-you page, and let us know if you're still having trouble.
Thanks!
Stephen Dowdy 2:43 PM on November 30, 2012
Did the link on the download page get disabled? I could not find the usual links that you see on your sites.
I was hoping to go through the exercise with the template. Anyway thanks for the information.
Denis - Outsourced Marketing 1:01 PM on December 03, 2012
Quite an elaborative and well-specified article. Very useful!
Thanks.!
Randy Guzman 9:06 PM on December 03, 2012
Thanks for sharing the information.It's really useful.
Leo 1:48 PM on December 06, 2012
I had no idea that PPC advertising is related in anyway to the placement in the SERPs. Thank you for the article. I guess I have to reconsider my views on PPC.