Toll Free: 1-877-695-7388

GTA: (647) 699-2838

Search Engine People
  • SEO
  • SEM
  • CRO
  • Display
  • Blog
  • Why Us
  • Contact
  • Join Our Team
  • Get A Quote

Toll Free: 1-877-695-7388

GTA: (647) 699-2838

Free Excel Template For Optimal PPC Keyword Organization

Chris Sisco | February 25th, 2011
Tweet54
Share31
Share
Pin
85 Shares

Keyword creation and organization are the foundations of a successful campaign. " Chuck Norris (just kidding)

There are great posts that discuss keyword research, but what comes next? How do we organize these keywords for our Adwords campaign? Can we expand on these keywords to include permutations?

Hi, I'm Troy McClure, and in the next 5 minutes, I'm going to teach you how to organize your keywords and expand on them by segmenting them into root keywords.

Root Keywords

So you are done your research and now you have a myriad of unorganized keywords either scribbled down on a piece of paper or on an unformatted excel sheet.

So what does this look like?

Let's use the example of sun protective swimwear! Here is your messy list of keywords

We see a reoccurring theme of hats (uv protective hat, spf caps, kids uva headpiece, etc) so lets start there. First we need to recognize from the keyword list that we are selling both kids and adults sun protective hats. This would justify creating 2 separate adgroups since we wouldnt want someone searching sun protective hats for men and landing on page showing sun protective hats for boys. So lets create an adgroup for Adult Sun Protective Hats and see what root keywords we can come up with!

We could go further and expand on other root keywords such as

+womens +spf (+hats, +caps, +headpieces, etc)
+mens +spf (+hats, +caps, +headpieces, etc)
+adults +sun (+hats, +caps, +headpieces, etc)

Organizing Keywords

Yeah Im going to have to ask youto organize these keywordsyeahthatd be great. " Bill Lumbergh

You can see that the keywords start to organize themselves once we start to expand on our root keywords. Everything is still unformatted with keywords clumped into a few cells so here is an Excel sheet that helps you organize your Adwords campaign:

Download SEM Excel Adwords Template for Small Businesses

 

You can use this template to keep track of keywords, keyword modifiers, adgroups, ads, and more! It will also help you organize root keywords on a per adgroup level.

Tweet54
Share31
Share
Pin
85 Shares
Posted in PPCTagged downloads, excel, keyword, PPC, tool

About the Author: Chris Sisco

SEO, SEM, BLT? The world of search engine marketing might be confusing to some, but to Chris Sisco it’s a second home (I heard he only speaks in keywords). He might be the best keytar player in SouthWestern Ontario, but he’s even better at getting your site noticed. Oh yeah, he's also an SEO/SEM specialist at Zero In, a internet marketing company located in Guelph, Ontario.

Internet Marketing Company

3 thoughts on “Free Excel Template For Optimal PPC Keyword Organization”

  1. Larry Kim says:
    February 28, 2011 at 11:05 am

    Hi Chris, Check out the keyword niche finder – it does a lot of the organizational work you’re talking about – http://www.wordstream.com/keyword-niche-finder
    Let me know what you think.

  2. Eden says:
    February 28, 2011 at 9:17 pm

    The spreadsheet is a nice idea but I can’t see it really being practical since it doesn’t appear to interact with Adwords. As a result, every time you make changes to your campaign – or to the spreadsheet – you have to manually update the other side.

    1. Chris Sisco says:
      March 2, 2011 at 7:29 am

      Hi Eden. Great point. This spreadsheet is for small businesses who are getting their feet wet with Adwords before they spend money or time on 3rd party tools.

Comments are closed.

Recent Posts

  • Maximizing Your E-Commerce Sales:
    A CRO Audit Guide
  • Movin’ On Up! Why Migrating to Google Analytics 4 (GA4) Should be a Priority
  • A Year in Review: The Digital Marketing Trends That Defined 2021
  • The Basics of Video Marketing
  • Just How Much Do Google Reviews Impact Your SEO Ranking?

Categories

  • Analytics & ROI Analysis
  • Company News
  • Content
  • Conversion Optimization
  • CRO
  • Display Advertising/RTB
  • Email Marketing
  • En Español
  • En Français
  • Inbound Marketing
  • Lead Nurture & Marketing Automation
  • Local Search
  • Marketing
  • Mobile
  • Partnership Marketing
  • PPC
  • PR
  • SEO
  • Social Media Marketing
  • Web Design

Additional Posts

Thou shalt not Duplicate Content: 3 Easy Tips Avoid It

February 24th, 2011 | by Shawn Graaff

Who Are You? The Power of Personal Stories In A Social World

February 24th, 2011 | by Bob Nunn

Restoring Your Google Places Listing After Being Removed For A Quality Guideline Violation

February 23rd, 2011 | by Mike Wilton

LET'S TALK

Need more information or want to get in touch?

Get in touch!
  • SEO
  • SEM
  • Display
  • Blog
  • Why Us
  • Join Our Team
  • Contact Us
  • Local SEO
  • Small Business SEO
  • Enterprise SEO
  • International SEO

LOCATION

1305 Pickering Parkway,
5th Floor Pickering, L1V 3P2

PHONE

Toll Free: 1-877-695-7388
Greater Toronto Area: (647) 699-2838

Social

© Search Engine People Inc. 2023 – Canada’s Top Digital Agency
© SEP 2023 – A Search Engine People Company | Privacy Policy

Search Engine People