SEO Meta Keyword Worksheet to Calc Stats

**Patchworks** · 11-05-2008, 11:13 PM

I had another thread but it evolved so much I decided to start a new thread. I've uploaded a spreadsheet to see if anyone can help with that I'm trying to accomplish.

Basically this is used for SEO (Search Engine Optimization), In other words, getting you website listed higher in the list so you can get more traffic.

What I do is download traffic stats from Google (CSV) for keywords and create a worksheet and sort based on the most traffic to least. I put a number for the order I want the keywords to be listed and have it build a string that I use to put on webpages. There are certain criteria that you don't want to go over and I would like this spreadsheet to tell me if I go over or under those criteria.

I've put notes in the spreadsheet but if you have questions, please let me know. I willing to help anyone with some SEO advice in exchange for some Excel help. I'm sure this worksheet would come in handy to may of you out there so maybe we can come up with something to benefit the community.

We are looking for the following calculations:

Total Unique Words
Total Count for each Unique Words

Thanks,

g