Dec.01

Build a Niche Site, Quick

  1. Girly Checks top seller is Yellow Labradors Personal Checks
  2. Girly Checks top selling category is dogs (cats is #2)
  3. 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.

Paste into GoDaddy bulk purchase

Paste into GoDaddy bulk purchase

Results of which domains are still available

Results of which domains are 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).

Find YOURUSERID and replace with your User ID

Find YOURUSERID and replace with your User ID

Now you have to find the products to put on your site. Here’s what I did:

  1. Insert a column between B and D
  2. Enter formula in C (new column) 1: =SEARCH(“border collie”;B1)
  3. Copy all the way down
  4. Sort by column C, descending
Finding products in Calc

Finding products in Calc

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.

How To & Tips
Share this Story:
  • facebook
  • twitter
  • gplus

Comments(15)

  1. Trackback: How I built a site in less than 45 minutes

  2. Razvan
    2194 days ago

    I wish there were more affiliates like you that only write when they have something useful to say.

    Thanks a lot for the tutorial and for sharing such useful information.

  3. Bill at FamZoo
    2192 days ago

    Eric – that’s pretty cool. Nice step-by-step content. Be interested to hear how the site performs.

    Cheers,
    Bill

  4. Demon
    2191 days ago

    Oh Eric, thanks for sharing your niche and the wonderful site, and I really really love your dog Scout 😉

  5. Chris Gustafson
    2188 days ago

    Great Content Eric! I really appreciate it. I like how you laid out everything step-by-step, and as someone who does setup niche sites, I did learn a couple of things, that will save me a LOT of time.

    Thanks,

    Chris

  6. Bill Swartwout
    2186 days ago

    …and in about a week you get your first sale. Nicely done!

    And a big THANK YOU to Eric – for putting this tutorial together. Checks really do sell – yes they do. The best way to do just that is with the “niche” approach – as described by Eric. That is exactly how I got my first checks sales back in August of ’07. I began selling beach checks on a popular beach site we’ve had on line since 1999. It only took one page to get started.

    Thanks, again, Eric, for sharing your technique. Bravo.

  7. Danger Brown
    2177 days ago

    Thanks Eric! Very well done.

  8. Fiona
    2164 days ago

    I second Razvan’s comment: “Thanks a lot for the tutorial and for sharing such useful information.”

    Eric, would you mind if I shared a link to this post with our BlogPiG members? I’ve had a few people asking for more info about building niche sites or sites out of datafeeds (given we’re the home of CSVPiG) and it’s going to be weeks more before I get our own video tutorial out the door.

    Thanks,
    Fiona

  9. Rick
    2160 days ago

    Admittedly it looks so lame I wonder how it could possibly work. But best of luck. I like how you use spreadsheets though. And yes I might try it 🙂

    • Eric Nagel
      2159 days ago

      Yeah, the site looks a bit lame, but it’s generated sales already, so I’ll keep it 🙂

  10. Trackback: Using Spreadsheets to Choose Keywords | Free Excel 2010 Spreadsheet Tutorials

  11. Rick
    2159 days ago

    Well there you go, the proof is in the paycheques! I’ve only made one sale ever so I should definitely try your technique. 🙂

  12. Andy Rockwell
    2159 days ago

    Great method for building niche sites! Just tweeted this

  13. Trackback: The Wonder of WordPress « Eric C. Souza – Professional Narcissist

Leave a comment

Comment