Database and Tracking Ideas

I'm curious to know the different ways everyone keeps track of multiple keyword possibilities and campaigns for several different websites.

For example: You have 50 websites. Each website has 30 keyword possibilities depending on geographic location targeted, services, products, etc.

Lets say the first two campaigns you target two cities using BMR and with 3 different keywords ending up with 6 keywords for anchor text. And campaign two you want to go for the next 6 keyword phrases.

I've been using excel but wondering if there is an easier way.

How do you store this information so you can refer to it for each campaign you run?

Thanks!

If i understand your question correctly, you can use a software like rank tracker or any of the tools that have a rank tracker built in

implayer said:

If i understand your question correctly, you can use a software like rank tracker or any of the tools that have a rank tracker built in

Click to expand...

Thanks for the reply implayer.

I might not have worded that question the right way but it is helpful information.

I'm looking for more of an automated way to cross check all of my keywords I want to optimize for with which keywords I have already used in campaigns where I might only use 3 or 4 keywords in anchor text.

Im using excel right now where I have the keywords, cities, and each campaign for each website and I don't know how much more of this I can
do manually.

Hopefully that makes sense to everyone

Take a look at seo powersuite - it can find all your back links for you and puts them in a spreadsheet and allow you to see anchor text, the page its linking too anda lot of other factors. Then you can just search for the keyword and see how many times it appears.

And how much more effort you need to put in for that keyword

hope that helps

implayer said:

Take a look at seo powersuite - it can find all your back links for you and puts them in a spreadsheet and allow you to see anchor text, the page its linking too anda lot of other factors. Then you can just search for the keyword and see how many times it appears.

And how much more effort you need to put in for that keyword

hope that helps

Click to expand...

That does help thanks implayer! If these are for my own websites can I get away with managing over 100 sites with the pro edition rather than enterprise?