separating keywords into lists

[SeanW]

I was just setting up a campaign and trying out a way to break out keywords from a master list, and I thought I'd share the commands I used to do so.

I used the Microsoft AdCenter Keyword Intelligence Excel plugin to generate a list of keywords. I eyeballed them to come out with a list of broad categories that I'd be using.

So now I have two files: masterlist.csv with the keywords, and categories.csv with the keywords designating categories. If I were doing something like car parts, category.csv might have something like

muffler
engine
mods
racing
...

To generate individual keyword lists, I ran the following Bourne shell command:

for i in `cat categories.csv `; do grep $i masterlist.csv > cat_$i.csv; done

to pick up all the keywords I missed,

grep -v -f categories.csv masterlist.csv  > cat_other.csv

I can then look through cat_other.csv to see if there are some categories I should add, or I can just use it as is.

Sean

 

[roundrobin20]

Anyone know what a similar command/plugin in excel that would do this?

Thanks.