Its been a year since I started this journal.
Still haven't made it obviously.
I have spent about $3,000 on PPC and I am not going to even bother to estimate how many hours. I could have worked more hours for sure, there where a couple of months I did not work on anything.
One of the main mistakes I made was instead of trying multiple ideas, I just focused on a few and tried to optimize them. Closest I got to being steadily profitable was dating on POF.
Anyway, because of my tendency to spend a large amount of time on singular projects I am going to try SEO type stuff and see if it makes any difference. One thing is for sure I am not giving up.
I have already figured out what niche I am going into, and its super competitive, but that does not scare me a lot. The plan is to attack a slice of the niche and expand from there.
The last three days I have spent reading about SEO and analyzing the Google Panda update.
Site design has been completed on paper.
Right now I am working on my database that ties things together. 5 tables in total and about 50 fields to keep track of everything. Optimized tables and types.
Setup a webserver on my own PC for testing. (Thanks Dchuk for writing this:
Setting Up Ubuntu 10.04 For Local Web Development With LAMP)
PHP, mySQL and Apache2 installed successfully and tested
PHPMyAdmin installed successfully and tested
Local domain has been setup. index.html came up, woot...Hello Motherfucking World
Setting up my 5 tables in my DB. Its been a while, took much longer than expected trying to remember/research how to optimize everything. 4 tables have been completed, in the process of doing it I realized I need to add one more table to optimize my lookup speed
All important fields are indexed and I only have one primary key for my entire table.
Total Cost: $0
Total Hours: 4