{"id":211,"date":"2009-07-30T09:27:48","date_gmt":"2009-07-30T14:27:48","guid":{"rendered":"http:\/\/24.183.55.167:8101\/wordpress\/?p=211"},"modified":"2012-08-14T20:54:04","modified_gmt":"2012-08-15T01:54:04","slug":"an-interesting-experiment-traffic-at-icesquarecom","status":"publish","type":"post","link":"https:\/\/icesquare.com\/wordpress\/an-interesting-experiment-traffic-at-icesquarecom\/","title":{"rendered":"An Interesting Experiment &#8211; Traffic at IceSquare.com"},"content":{"rendered":"<p>Here is the traffic summary of this blog in July. The numbers give a pretty interesting picture:<\/p>\n<p>Total number of visits:<br \/>\n<strong>Apache &#8211; 2048<\/strong><br \/>\nThis number means there are 2048 pages have been shown to the visitors.<\/p>\n<p><strong>Google Analytics &#8211; 1464 (72% of 2048)<\/strong><br \/>\nThis number means out of 2048 actual visits, Google Analytics can only detect 72% of them, which means some visitors has use tools to block the detection from Google Analytics.<\/p>\n<p><strong>Google Adsense Impression &#8211; 1526 (74.5% of 2048)<\/strong><br \/>\nThis number means out of 2048 actual page loads, only 1526 ads have been displayed. Note that multiple ads can be detected in one single page. <\/p>\n<p><strong>Number of pages load with Ad &#8211; 508 (25% of 2048)<\/strong><br \/>\nThis number means that out of 2048 pages, only 25% of them will contain the ads. In the other words, 75% of the ads were blocked.<\/p>\n<p><strong>Google Adsense Click &#8211; 24 (1.57% of 1526)<\/strong><br \/>\nThis number after showing 1526 ads, 24 of them were clicked by the visitors.<\/p>\n<p>Conclusions:<br \/>\n&#8211; The ads that are shown here are not interesting at all. I will blame this to Google because they always display content-irrelevant ads.<br \/>\n(By the way, Google is showing an ad related to blood pressure now. Can you see it?)<\/p>\n<p>&#8211; There is a huge market for crashing the ad-blocking tools. \ud83d\ude42<\/p>\n<p>&#8211;Derrick<\/p>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here is the traffic summary of this blog in July. The numbers give a pretty interesting picture: Total number of visits: Apache &#8211; 2048 This number means there are 2048 <a class=\"more-link\" href=\"https:\/\/icesquare.com\/wordpress\/an-interesting-experiment-traffic-at-icesquarecom\/\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[37],"tags":[35,36,39,34,38],"class_list":["post-211","post","type-post","status-publish","format-standard","hentry","category-game-of-numbers","tag-ad","tag-adsense","tag-analysis","tag-google","tag-icesquare"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p1sqzr-3p","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":5012,"url":"https:\/\/icesquare.com\/wordpress\/google-one-vpn-how-to-by-pass-vpn-in-windows\/","url_meta":{"origin":211,"position":0},"title":"Google One VPN: How to by pass VPN in Windows","author":"Derrick","date":"February 14, 2024","format":false,"excerpt":"Recently I started using the Google One VPN service. I love it because of its simplicity. However, I quickly ran into problem because some services require my real IP addresses. Since the Google One VPN is designed for average Joe, it doesn't have any advanced features. It is either all\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/icesquare.com\/wordpress\/category\/technology\/"},"img":{"alt_text":"","src":"\/wordpress\/wp-content\/uploads\/2024\/02\/Putty-01.fw_.png","width":350,"height":200},"classes":[]},{"id":222,"url":"https:\/\/icesquare.com\/wordpress\/example-code-to-convert-a-number-to-excel-column-letter\/","url_meta":{"origin":211,"position":1},"title":"Example PHP code to convert a number to an Excel column letter","author":"Derrick","date":"August 6, 2009","format":false,"excerpt":"I was looking for a good way to convert a number to the Excel column letter, for example: 1 -> A 26 -> Z 27 -> AA 28 -> AB 800 -> ADT etc. After searching on Google, I could not find any algorithm I want. (The closest one can\u2026","rel":"","context":"In &quot;Programming Problems&quot;","block_context":{"text":"Programming Problems","link":"https:\/\/icesquare.com\/wordpress\/category\/programming-problems\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1199,"url":"https:\/\/icesquare.com\/wordpress\/how-to-remove-a-remarkable-book-from-wiley-finance-an-excellent-book-paul-wilmott-want-to-break-into-the-lucrative-world-of-trading-and-quantitative-finance-you-need\/","url_meta":{"origin":211,"position":2},"title":"How to remove &#8220;A Remarkable Book from Wiley-Finance \u201cAn excellent book!\u201d \u2014 Paul Wilmott Want to break into the lucrative world of trading and quantitative finance? You need this book!&#8221;","author":"Derrick","date":"January 12, 2011","format":false,"excerpt":"Recently, I found that Wordpress adds the following things (or random crappy ads) into my posts, such as: A Remarkable Book from Wiley-Finance \u201cAn excellent book!\u201d \u2014 Paul Wilmott Want to break into the lucrative world of trading and quantitative finance? You need this book! The Unreal Universe A Book\u2026","rel":"","context":"In &quot;Computer Problems&quot;","block_context":{"text":"Computer Problems","link":"https:\/\/icesquare.com\/wordpress\/category\/technology\/computer-problems-computer-help-pc-support\/"},"img":{"alt_text":"","src":"\/wordpress\/wp-content\/uploads\/2011\/01\/AdSenseNow_Crap_Message_Thumbnail-150x150.png","width":350,"height":200},"classes":[]},{"id":237,"url":"https:\/\/icesquare.com\/wordpress\/does-most-popular-imply-the-best\/","url_meta":{"origin":211,"position":3},"title":"Does the most popular imply the best?","author":"Derrick","date":"August 19, 2009","format":false,"excerpt":"Today, I had a discussion with my co-worker on the best languages for web applications. While I argued that Perl, and Ruby performs better than PHP, my co-worker had an opposite opinion. He believed that PHP is the best language overall because it is widely used. It brings me to\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/icesquare.com\/wordpress\/category\/technology\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":851,"url":"https:\/\/icesquare.com\/wordpress\/comments-on-running-webservers-at-home-part-1\/","url_meta":{"origin":211,"position":4},"title":"Comments on running webservers at home &#8211; Part 1","author":"Derrick","date":"September 9, 2010","format":false,"excerpt":"I like to experiment all kind of computer technologies especially server applications. I am not one of those who is satisfied with just making a website and putting it in somewhere. I like the full control of the server because I like to try different combination of applications for performance\u2026","rel":"","context":"In &quot;Computer Problems&quot;","block_context":{"text":"Computer Problems","link":"https:\/\/icesquare.com\/wordpress\/category\/technology\/computer-problems-computer-help-pc-support\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4083,"url":"https:\/\/icesquare.com\/wordpress\/rhel-7-mariadb-mysql-error-1018-hy000-cant-read-dir-of-errno-24\/","url_meta":{"origin":211,"position":5},"title":"RHEL 7 \/ MariaDB \/ MySQL: ERROR 1018 (HY000): Can&#8217;t read dir of &#8216;.&#8217; (errno: 24)","author":"Derrick","date":"March 5, 2016","format":false,"excerpt":"Recently, I decided to upgrade a database server from RHEL 6 (CentOS 6) to RHEL 7 (CentOS 7), which involves switching from MySQL 5.5 to MariaDB 5.5. Our server hosts about 100 databases, when I was testing them individually, I didn't see any problem. However, when I ran the back\u2026","rel":"","context":"In &quot;Computer Problems&quot;","block_context":{"text":"Computer Problems","link":"https:\/\/icesquare.com\/wordpress\/category\/technology\/computer-problems-computer-help-pc-support\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/icesquare.com\/wordpress\/wp-json\/wp\/v2\/posts\/211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/icesquare.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/icesquare.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/icesquare.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/icesquare.com\/wordpress\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":12,"href":"https:\/\/icesquare.com\/wordpress\/wp-json\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":2939,"href":"https:\/\/icesquare.com\/wordpress\/wp-json\/wp\/v2\/posts\/211\/revisions\/2939"}],"wp:attachment":[{"href":"https:\/\/icesquare.com\/wordpress\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/icesquare.com\/wordpress\/wp-json\/wp\/v2\/categories?post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/icesquare.com\/wordpress\/wp-json\/wp\/v2\/tags?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}