Playing With Profits

This got to be the coolest piece of software I ever seen.

Crayon Physics Deluxe from Petri Purho on Vimeo.

This the best gift ever.

I am so excited I am creating a contest to give away this tube or whatever that left. Rules are simple, the best comments wins. So what you waiting for?

I recently moved to my new place, its good to move out of my parent’s place after 35 years. The move took longer than expected about 2 months actually. All this well I have been able to do any actual work on my websites. Most of my website are simply sold as domains. I have been focusing intensely on PPC. I have managed to create profitable campaigns after studying lots of materials from various gurus. I have formatted my own sets of rules.
1. Create a system. Whether its niche research, finding keywords, locating products or setting up campaign. Create a system where you are able to go through the same process again for each new project. You might start with some else system but on the way refine it. Be prepare to throw away what your believes or what you have learn and accept new ideas.
2. Always go deep on keywords. One of the most valuable lesson I have learn is to go deep. People search for phrase when they are seeking solution, they are looking for specific solution so your keyword needs to cater these searches.
3. Measurement. I believe in measuring and keeping scores. Always have tracking codes install. Always check your campaign. Always keep records, create a excel if you have to, to monitor your profits.
4. Never turn off a campaign, searches fluctuates. Whats not popular might be in the future.
5. Out bid your opponent, what PPC was create for, is for business to out bid each other. Most rookie make the mistake of bidding too low. Don’t be afraid to bid for keywords that cost more than a dollar.

I been really busy learning new things, working and tweaking a lot of my wordpress site lately, theres a few good trick in mysql tricks that I find really useful. One such command is Replace. This is very useful when you need to make updates to a series of posts. For example your would like to change your links to nofollow.

update wp_posts set `post_content` = replace(post_content, ‘<a href=’, ‘<a rel=”nofollow” href=’)

How to sell incontent links
You can also sell in content links using this method.
Find the relevant anchor text.
Select post_name, post_title, guid, from wp_posts where post_content like ‘%make money from blogging%’;
This will give you the all the post that has this keyword
next add hyperlink by
update wp_posts set `post_content` = replace(post_content, ‘make money from blogging’, ‘<a rel=”nofollow” href=”http://www.wizcodeolution.com” >make money from blogging</a>’)

Another useful trick for SEO s to change the url from www.wizcodersolution.com/2008/09/post_title to www.wizcodersolution.com/post_title. I find that using wordpress dashboard do not change links for past post. You can use this command to up date the URLs
update  `wp_posts` set `guid` = concat( ‘http://www.qshape.com’, `post_name` )