A Guide to building up your Keyword List in AdWords Editor

Once you have sorted out the structure of your account, campaigns and ad groups, and you also have a good idea of the keywords which you want to include in your campaign, what is the best method of actually implementing this into a campaign? People have different methods, dependent on how they use AdWords, but below, I will highlight the way I would add a keyword list using AdWords Editor.

AdWords Editor

AdWords Editor is the most useful tool for an AdWords professional, and doesn’t necessarily need to be limited to a professional. The application is easy to use, small and – most importantly – free. It allows a user to create, modify and analyse their account locally on their computer. But it is the way that it is easily integrated with Microsoft Excel which makes it the most useful.

The first step is to create your keyword list in Excel, using one column per word. So, if you wanted to add the term “Pay Per Click Company” to the list, the term would span across four columns. This makes adding modifiers and the repetition of words much easier, as you can drag the rows down.

Once you’ve created your full list, use the Excel formula =concatenate()remembering to put spaces in between words (use “ “ for this). This will join all your words together to create a single term. Now that you have your concatenated list, you can append the match type as desired using copy and paste to aid any keywords with which you wish to make multiple match types.

Now you are ready to copy and paste into the AdWords Editor. Select the Ad Group you wish to add the keywords to, select Add Multiple Keywords and paste the Search Terms and the match type into the space provided and press OK.

Philip Pollock
PPC Account Manager