Subscribe to the Feed!« PPC Powerpoint Presentation | Marketing Home Page | Personal Branding - an amazing interview with Joel Bauer »
Real Good Keyword Research Tools…
By Los Angeles Internet Marketing | October 12, 2007
Thanks for Dropping By! I'd love to learn more about you, so why don't you join my MyBlogLog Community and say "Hi"?
I’m frustrated - and I need your suggestion. I am doing keyword research on a huge industry for a site that we are putting up shortly. I’m a systematic person. When I was working for one of the best affiliate marketers creating keyword lists, I would systematically create an excel sheet that contained all of the variations of that keyword that people would search.
For example, one of the little tricks - (especially if you can get away with it as an affiliate), is putting in all of the different concatenations of your competitors domains. Many people often search for a domain directly in the search bar instead of the URL bar on top. These people convert really well as they are ready to buy already! So I would create one list of all of the domains. For example, in the dating arena the start of my spreadsheet would look like this:
This is murderously effective. I’ve used this little technique, and it’s really fun. This the first time I am creating the marketing for such a large enterprise, spanning all of the little niches in it from scratch. (I’ve built some large campaigns, however I had keywords that we had used for other campaigns to build from.)
I am a perfectionist at heart, and like everything to display nicely - even though alot of it may not significantly affect CTR. I’ve been looking for a tool that can take a whole bunch of themes, and mix relevant categories of keywords into many different keyword groups that has a drag and drop interface.
We have bid automation tools, keyword research tools, keyword mixing tools etc. But we don’t have a simple smart tool that allows you to categorize keywords, and mix thematically / semantically into different groups.
Now there is a phenomenal tool that I use - SpeedPPC for some of this. But there is no way to create a whole bunch of themed keyword categories. If someone knows of any such tool please tell me - and don’t forget to put in your affiliate link!
By the way Jay (Owner of Speed PPC), this is a suggestion for your next version of SpeedPPC. I’m sure that you’ve created this tool for yourself. I don’t what you do for keyword concatenations, but I can’t imagine you don’t do it yourself. Could you pleease include that in the next upgrade?
(BTW, Can someone tell me why speedppc.com isn’t the top result for Speed PPC in Google? Instead you have speedppcads, with all links redirecting to speedppc.com - and no affiliate links? Check out the whois data too… speedppc.com, and speedppcads.com. Rick - are you the SEO guy for Jay? Hehehe, just some bored research.)
Either way, I’d love to hear people suggestions, techniques or excel sheet formulas on this.
Share This
Topics: Company Marketing Techniques, ppc, Yahoo, Google, MSN Adcenter, Pay Per Click Advice, Search Engine Marketing |
October 12th, 2007 at 11:15 pm
Oops - a simple google search for rick calligris shows someone who is a great article marketer.
Maybe I’ll do a post why I even bother to do these types of whimsical research things on people…