Build a Niche Site, Quick
I was listening to the Affiliate Juice podcast, featuring Girly Checks, and learned a bit about the checking business, so thought I’d make a small niche site on Border Collie checks. Here’s why I chose border collies:
- Girly Checks top seller is Yellow Labradors Personal Checks
- Girly Checks top selling category is dogs (cats is #2)
- My dog is a border collie
So first, I wanted to do some research. I found a list of the top dog breeds, and copied that data into Excel (Calc).
Next, I deleted all of the ranking data (since it’s already sorted), which left column A as a list of the dog breeds. These are the formal names, and I wanted common names. So I went through and put common names in column B. I filled column C with “checks.com” and in D, put =CONCATENATE(B1;C1)
Now, column D is filled with possible domain names (ex: yellowlabchecks.com). I then went to GoDaddy and pasted this list into their Express (or bulk) purchase box, and found which were still available.
Now that I have a domain (or more), it’s time to get the products. Login to ShareASale, click on Datafeeds, then search for Girly Checks. Download the zipped .csv, extract the zip file, then rename 24053.txt to 24053.csv and open in Calc (or Excel). As you import, the deliminator is the pipe character:
Before you do anything else, find & replace
YOURUSERID with your ShareASale user ID (found at the top of the ShareASale interface, once you’re logged in).
Now you have to find the products to put on your site. Here’s what I did:
- Insert a column between B and D
- Enter formula in C (new column) 1: =SEARCH(“border collie”;B1)
- Copy all the way down
- Sort by column C, descending
Now, you can see what products to put on your new site. In this example, there will only be a few to add, and you can do this manually. However, if you use this for another niche, you may have hundreds of products, and would want to use something like CSVPig.
The next parts are easy, but tedious. Set-up your domain with your hosting provider, install WordPress, add Thesis, then add a post for each product.
Keep SEO in mind! For example, on the Border Collie Agility Personal Checks page, I copied the image from Girly Checks, renamed it, and am hosting it myself (Border-Collie-Agility-Personal-Checks.gif)
Add some fluff (YouTube video, RSS feeds, other banners, etc) and you have a mini-niche site, done in a couple of hours.