![]() And if you are combining multiple data sources / tables in Excel this AbleBits merge tool is handy. You could do similar to the above with Microsoft Excel's table filters. Here is a semi-automated way (where you still have a bit of human editorial in the process to manually filter to find themes & create groups) There are a couple different ways to use the Google AdWords editor to group keywords. Another nice feature is that they show you keywords they feel you are missing out on by putting them in bold, so this tool is great both for looking up competing sites & for looking up your own site to see what you missed. They allow you to browse keywords to drill down in areas of interest. That is to be expected though, because it is searching through a database of records related to sites, rather than just applying a filter or returning results. The big benefit with SpyFu is that you can view data on a competing site & use their performance as a bit of a filter for you, but the downside is that at times it can be a bit slower than the above tools. In addition to listing keywords by root word, they also give you the option of viewing the top 100, 500, or 1000 keywords for a site. Spyfu's Keyword Groupie allows you to look up a competing site's keywords & see them organized by root word. ![]() ![]() Wordstream's keyword grouper allows you to see niche keyword groups at a fairly granular level, with them emailing the results to you. This tool works well in spreadsheets, but it takes some level of programming sophistication to get working. RKG Duck is a Perl clipboard extension which was the inspiration for our above tool. This can not only be used for organizing keywords for paid search, but also to help organize them for your SEO efforts down to a per-page level. It also allows you to use stop words to filter the list. The output is TSV, so you can copy it and paste it into a spreadsheet for further analysis. We created an ad group organizer tool which aims to create a footprint for keywords by putting muti-word keywords in alphabetical order & stemming the keywords. Here are a dozen different tips and tools to help you organize your keywords. Let's say you have a big list of keywords which is not well organized & you want a quick and dirty way to organize it. Given Google's new approach to search (where dead weight can harm your good pages) organization is more important than ever. Clustering like keywords together and using that to help set up your site's information architecture is a lower risk and higher return strategy. Before Google's Panda update an effective SEO strategy was to "make a page for everything." If you are Wikipedia that strategy may still work, but for most websites that approach is a high risk & low return approach.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |