If you’re dealing with keywords, then Excel is your friend. Excel makes managing large lists of data very easy and it has a number of features that work especially well with keywords.
Here is a simple recipe to combine a few simple keywords together to create a list of long-tail terms.
Ingredients
Core terms
- apples
- oranges
- bananas
Geographic terms
- new york
- los angeles
- boston
- philadelphia
Recipe
In Excel, enter your core terms into column A.
Enter core terms
Now we need to multiply the amount of core terms (3) by the amount of geographic terms (4). So, in Excel we need to copy down the core to repeat them 12 times.
Select the cells A1 to A3 and click Edit -> Copy. Then select cells A4 to A12 and click Edit -> Paste.
Copy and paste core terms
Now sort the list by clicking Edit -> Select All and then Data -> Sort -> Sort By -> Column A -> Ascending.
Sort column A ascending
Now enter your geographic terms in column B and copy and paste them down.
Geographic terms enter, copy and paste
Now all we need to do is combine the 2 sets of data into to column C with the following formula: =A1&" "&B1
Combining formula
Now hit enter to see the results and the copy and past this cell (C1) into cells C2 to C12.
Copy and paste the formula
Now you have your long tail terms in column C. You can add these to your PPC campaign and improve and improve the chances of you add being seen.
This is obviously quite a simplistic example, but you can use this approach to build much richer, complex keyword lists.
Related posts:
- Prepare AdWords campaigns in Excel for upload into AdWords Editor
- AdWords checklist
- Sort Highrise email addresses by tag and check for duplicates in Excel
- PPC competitive research…
- Uploading campaigns from AdWords to Microsoft adCenter
Sponsored links:
{ 1 trackback }
{ 0 comments… add one now }