Matt over on the WF forums had recently posted a SQL database that he had created comprised of first and last names, a great resource to have handy when auto-generating identities, accounts, comment authors, etc.. While it was a pretty large list, it still wasn’t as complete as the one i’ve been using over the years (also it was separated by gender and used one giant table instead of segmenting the first and last names into two). I figured that if I was going to complain about something free, I might as well provide something in return, so here’s your chance to download a free first and last name database in both SQL and CSV formats (pick your poison). There are a total of 5494 first-names and 88799 last-names allowing for a never-ending source of randomly generated full names.

Free Name Database Download – SQL:
.sql File | .zip File

Free Name Database Download – CSV:
First Names (5494) – .csv File & Last Names (88799) – .csv File
I also compressed them both for easy download – .zip of both files

enjoy.

80% of the time setting up any SEM campaign, especially if it’s selling products in an already crowded market (i.e. the majority of CPA offers in affiliate marketing), is spent on research. Some prefer to use free tools, some rely on paid services or applications that might offer additional marketing benefits and then there’s a whole separate group which will uses home-grown scripts that achieve a combination of tasks. First I’ll show you some of the freely available tools that you can use to research the competition, from finding out what other websites link to them (i.e. backlinks) to even what other websites the owner is hosting on the same IP address. This is part one of a series on SEO research tools: Researching The Competition (For free).

Free Competitive Research Tools:

WhoIsHostingThis.com – Find out what hosting company is being used for the website. For most this won’t matter much but for some of you, this information can be used in more grey-hat SERP strategies.

Quarkbase.com – A mash-up of some of the top research utilities that you’d check for any given site. From the # of links on social bookmarking sites, basic domain and webserver information, related sites, company information and even a comparison of several different ‘traffic ranking’ utilities. This is by far one of the most comprehensive and easy to use research utilities for any given website. A similar tool (that is open-source) is Xinu Returns.

SEOPro’ Link Checker – One of the best FREE services to check a website’s backlinks, including both the anchor text used as well as the homepage and link PR. Useful to see what links your competition are using to help build their SERP as well as which links have potential to improve (i.e. finding page links with high homepage PRs and working to improve the quality of the link).

What is hosted on that IP? – Great tool from SEOEgghead that will tell you what other domains are being hosted on the same ip or domain.

Redirect Check – Here’s another from SEOEgghead that will tell you all the paths taken to reach a specific domain, useful if they’re using multiple re-directs – this tool will identify every stop along the way.

Domain Tools – From the basic WHOIS information and META Tag information to previous owners and nameserver changes (though most of the more detailed information requires a paid subscription), this website has a bunch of tools that are useful in hunting down the owner of a website (or finding similar sites).

SocialMention.com – Search blogs, social networking sites (like twitter), comments, images, news and a variety of other sources for your keyword or website. You can even export the results in csv format. Great for finding out where people are talking about your competition or niche.

Quick Bulk PageRank and IP Lookup – This tool will let you look-up the pagerank and ip addresses of multiple URL’s, perfect for when you have a long list of sites and want to quickly see which would be the best to try and get a link from. It’s one of Esrun’s tools (a well-established figure in ‘blackhat seo’).

Multiple SERP Tool – An amazing script that gets the results on the first 3 keywords of a domain, then parses out the top 3 word combinations in the results pages and ultimately spits out a top-40 list of domains for that niche based on an intuitive ranking system. A must-use for niche research.

BuiltWith.com – Can’t figure out what platform a website is using to host their content? This site will let u know the basics from whether or not it’s using a popular CMS back-end like WordPress down to what software the server might be running.

Next up will be free keyword tools.

Tracking202, which is quiet possibly the single most important tool any affiliate marketer can have in their arsenal, just announced yesterday that they were starting to take applications for the new Tracking202 Pro Private Beta Program. While enrolled in this trial, all fees associated with the application will be waived with the exception of any API calls. Once the private beta is over the service will switch over to being a paid analytics program….the first that the company has ever offered.

Up until now all Prosper202 applications have been completely free of charge. These include:

• Tracking202 – A great link analytics program to help you map trends, ctr, and much more.
• Export202 – A utility to convert PPC campaigns from one advertising network to another (i.e Google->MSN).
• WorldProxy202 – A great service that offers free international proxies in Canada, USA, Australia and the UK. This was always great for checking how your ads would appear to the international search markets.
• Meetup202 – An event/user group planning system allowing you to create, manage, and track gatherings.

It should be interesting to see what new features this Pro version has, something to note though is that there will not be a self-hosted version this time. Tracking202 Pro will be only sold through their subscription service. I don’t know how well this will go over with the AM crowd as the biggest fear in using any subscription service is that someone will steal ideas, LP’s, strategies, etc.. All of which are visible through this tracking application.