Lately I’ve been building some PPC campaigns with Google AdWords. I’ve got almost 80,000 keywords ready to be imported into my AdWords account. Up to this day I haven’t got to launch a “serious” PPC campaign so I never realized how much work it could be.
As you already know, it’s important to build relevant keyword groups. Putting irrelevant keywords into the same adgroup will result into a low Quality Score, therefore increasing your PPC costs.
At first I only used Google AdWords web-based interface. I tried to group keywords with Microsoft Access and Excel which was a total pain. I finally decided to have a look into Google’s AdWords editor. To my surprise, it offers the possibility to group your keywords automatically! Hurray!
Google AdWords Editor is an offline management software for your Google AdWords account. This means that it downloads your whole account locally and when you’re done making changes, it uploads data back to your account.
Grouping your keywords with this software is a piece of cake. Here’s how I did it:
- Import all your keywords into a single (or multiple) adgroup. An adgroup can hold up to 2000 keywords so you may need to have more than one. I named my adgroup “Default AdGroup”.
- From the left column, select your newly created adgroup (Default AdGroup in my case) and click on Tools => Keyword Grouper from the main menu.
- From the Keyword Grouper window, hit the Generate common terms button and then click on Next.
- The keyword grouper will then give you the possibility of importing text ads in each new adgroup to be created. At this point, this is up to you. Personnally I don’t import any ads since they probably won’t be relevant enough, thus resulting in a low Quality Score.
- Click on Finish when you’re done. The keyword grouper will build new adgroups automatically.
- Delete the initial adgroup you’ve created (Default AdGroup).
And voilà! You’ve got some brand new adgroups with relevant keywords grouped together.
At this point, I’ve got no text ads for these adgroups so I pause them all. All that’s left to do is to go through each adgroups, write relevant ads and set the default bid. When you’re done, activate the adgroups and post the changes to your AdWords account.
Top Commentators