I was not good in getting income from selling products through affiliation. So I did not bother to focus much on it after blogging for 5 years. Signed up B&H Photo Video Pro Audio and Amazon Affiliate long time ago. But only got $20.63 from B&H Photo Video Pro Audio Affiliate and nothing from Amazon Affiliate. Most of my incomes are from advertisements like Google AdSense, Vibrant Media. And really envy with other sites that having high revenue from affiliation.

Earnings & Orders Summary from Amazon Affiliate

Well, I know that the earning is not much (and I yet to receive the payment). But it is a good start for me. At least, I learned how to make money from selling products through affiliation. Banner ads without specific product do not help much. However, a product review article with link to the affiliate website really helps. Readers have more interest of purchasing that product after reading the review. So Conversion rate is much higher.

I started to use back WP Super Cache on JayceOoi.com when W3 Total Cache was giving me issue on my VPS. And W3 Total Cache was not able to sustain PrettyGirl2u.com traffic on shared web hosting yesterday. Received warning email from HostGator about high CPU usage…

Hello,

This message is to advise you of a temporary block placed on your account. This account was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system’s CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case.

Requests to this scripts under this account may become degraded by limiting the ability for scripts to run for a limited amount of time, or if the issue persists, we may be forced to restrict how fast processes can be spawned until the issue has been resolved.

We recommend taking steps to reduce the overall CPU usage for the account, which may be as simple as generating a flat HTML page for popular content, or enabling caching that is available through many popular scripts, or disabling high CPU usage features such as searches or Ajax refreshes. Although we may not be able to help in all cases, we would be more than happy to assist if you are unable to determine any cause, or if you need help interpreting any of the information.

PrettyGirl2u.com should not have any high CPU usage because it does not have comment system which will increase DB usage. And I don’t see any traffic spike on Google Analytics. Anyway, I disabled W3 Total Cache and installed WP Super Cache back. I did some studies on WP Super Cache. Haha… I should have enabled Preload Mode on WP Super Cache since day 1 I use it. I preloaded all the post and refresh preloaded WP-Super-Cache files every 720 minutes (half 1 day). This means that the server will only access to database to query information once half a day or any new comment entered. And it really does reduce CPU usage on shared web hosting.

Did you enable Preload Mode on WP Super Cache?

I am getting ‘Akismet has detected a problem. A server or network problem prevented Akismet from checking xxx comments. They have been temporarily held for moderation and will be automatically re-checked in xx mins.’ issue lately… This issue happens once in a while. And the longest last for 1 day. I had to delete all the spam comments manually by clicking ‘Check for Spam’. It is okay now as the time of writing this article. Hmm… Any idea what went wrong?

Anyway, I discovered another stuff ~ wp_commentmeta is the biggest size table in my WordPress database. What does wp_commentmeta store? After checking here and there. It has _wp_trash_meta_status data in meta_key. And lot of akismet_result, akismet_history, akismet_as_submitted, akismet_user_result and akismet_user entries too. wp_comments is only 8.5MB while wp_commentmeta is using more than 40MB database storage space. And it has more rows than wp_comments. Do these entries have any value at all?

After did some testings, I found out that wp_trash_meta data will be generated when you spam or trash a comment. And will be deleted after you delete the comment permanently. So the wp_commentmeta is clean. However, it will get bigger and bigger if you are using Akismet WordPress Plugin. Akismet will create 3 entries in wp_commentmeta on each comment. 5 entries if you spam the comment yourself manually.

I prefer a small and clean WordPress database. So it is time to clean it up. I used these entries to check and delete those unwanted entries.

Clean up wp_commentmeta entries that have no relation to wp_comments

select count(*) from wp_commentmeta where comment_ID not in
(select comment_ID from wp_comments)

delete from wp_commentmeta where comment_ID not in
(select comment_ID from wp_comments)

Clean up all Akismet wp_commentmeta entries

select count(*) from wp_commentmeta where meta_key like ‘%akismet%’

delete from wp_commentmeta where meta_key like ‘%akismet%’

Only performs these scripts in phpMyAdmin if you know what you are doing…

I have a new smartphone ~ Samsung Galaxy S II. It is a great phone but bad compare to HTC HD2 in SEO term. Why? The official Samsung Galaxy S II keywords does not always return the search result that I want. Samsung Galaxy S (SGS1) results were returned some time. Therefore, I used Google Trends to check its search volume.

Samsung Galaxy S II search volume

Based on Google Trends, Samsung Galaxy S2 is the most frequent search keywords compare to official Samsung Galaxy S II keywords. So you know which keywords should I use now?

Pay per lead affiliate programs offer you excellent opportunities to make money via affiliate marketing. However, to enter into pay per lead affiliate business, you should have proper understanding of this program as well as the pros and cons of this program.

Tips to become a successful affiliate marketer
Through affiliate programs, you the affiliate is paid for a specific action. The pay per lead affiliate marketing programs offer you good chance to earn money. The popularity of these programs is based on the fact that you need not to sale products and services. Generally, these programs are aimed at to promote the services offered by the products. These programs are indeed useful for the sellers as they help restore information about the visitors. Generally, the conversion rate of these programs is quite high. However, these programs are not absolutely free from risks. If these programs are not pursued in proper way they may even lead to loss of money. So it is highly recommended that you should follow certain strategies so as to maximize the gains. Here are some tips for you so that you can become successful as a pay per lead affiliate marketer.

Respond quickly
One of the keys to achieve success as an affiliate marketer is to immediately send the traffic to the programs. This is indeed helpful to accelerate the conversion rate and thereby minimizes the chance of losing out prospective customers. You can put in place the pay per click system so as to generate traffic to the pay per lead affiliate program.

Learn social marketing
To become a successful affiliate marketer, master the art of social marketing. This helps you immensely get the leads. You can utilize the social media sites such as Facebook and MySpace to place your ads and various related information. This in turn positions you in front of countless visitors.

Set up different websites for different types of traffic
Setting up different types of websites for different categories of traffic is a good ploy to attract more visitors. This helps bring in targeted category traffic. You have to keep separate options in the website for various types of visitors. And thereby you can get the list of targeted visitors. This helps targeting the potential customers.

Avoid some basic mistakes
You have to take adequate safeguard regarding the software that you are using. The programs should not be such that install bugs such as Ad-wire or Spyware on the personal computers of the visitors. If this happens, this badly tarnishes the reputation of your pay per day affiliate program. Another important aspect on which you should be very much careful is the privacy of the visitors. You should no way use the personal details of the visitors for some gainful purposes.

These are the few tips that you can follow so as to become a successful as a pay per lead affiliate marketer.

Guest Post: Jenney Roberts is a writer for various finance related Communities including Debt Consolidation Care. She is a financial writer by profession and has specialization in dealing with financial problems and its solutions. She is well equipped to write articles on debt consolidation, savings, planning, frugality, debt settlement etc.