Skip to main content

Featured Post

Changing Digit Grouping (Comma Style) in MS Excel - Million to Lakh

Well this is a very common problem for our sub-continent i.e. Bangladesh, India, Pakistan, Nepal, Maldives, Sri Lanka. Cause our digit grouping system doesn't match with the international system. To be more specific - they use million, billion etc. But we use - lakh (also lac), crore etc. 
Users of the mentioned regions often face problem with the comma separator position in MS Excel. Cause the default system is international. It doesn't suit our digit grouping system. 
International System - Separates every three digits 1,000.0010,000.00100,000.001,000,000.001,000,000,000.00
Subcontinental System - Separates every two digits after the 1st three digits
1,000.0010,000.00 1,00,000.001,00,00,000.001,00,00,00,000.00 
If you're familiar with the Indian Subcontinent system and if you're bound to use this system then it will be a big trouble if you don't know the solution. Well nothing to worry about as you are going through this article. Cause from the very next moment you'…

Trues and Falses in Optimizing AdSense

Couple of days ago Google AdSense offered its first online course for the Publishers. And I've been too. The course will be opened on 20th May, 2014. Register now for the course and take a Pre-Course Assessment to justify your AdSense knowledge! 

Course Outline

  • Introduction

  • Unit 1 - CPM and CPC: Winning Valuable Ads

  • Unit 2 - Clicks and CTR: Designing and Placing Your Ads

  • Unit 3 - Impressions: Showing More Ads

  • Wrapping Up

  • Final Assessment 

Just after getting the invitation for the course, I took the Pre-Course Assessment Test. There are 15 questions. You just need to choose one of the options - True, False and I don't know. 

I scored 12 out of 15. This assessment will help you understand what you already know about AdSense and what you still have to learn. Have a look at the questions (modified) of Pre-Course Assessment - 

    1. Enabling both text and image ads increases the auction pressure for your website’s Ad and is very likely to increase your AdSense Earning. (True)
    2. Every page should have a 728x90 banner ad on it because this is the highest performing Ad Size. (False)
    3. Blocking Ad categories in AdSense account will not affect your revenue because the auction will just replace Ads from that category with ads from other categories. (False)
    4. You can put the same Ad unit into multiple custom channels. (True)
    5. AdSense Experiments can be used to test and compare the performance of different sizes or styles of your Ad units. (True)
    6. CPC and CTR are different acronyms for the same thing. Both of them measure how often users click on Ads. (False)
    7. The only way to be sure that you’ve put Ads in the right places on your site is to test frequently and understand the behavior of your users. (True)
    8. The best way to format text Ads is to blend/ mix with your content as much as possible. (False)
    9. If your page calls for an Ad to be served but no Ad is returned, this will be considered as an Ad request, a page view, and an impression. (False)
    10. In the AdSense auction, if Advertiser Sami bids $2.40 CPC, Advertiser Raj bids $2.10 CPC, and Advertiser Chris bids $2.15 CPC, Advertiser Sami wins and pays $2.40 for the impression. (False)
    11. With contextual targeting, the Google web crawler analyzes colors, images and videos to match ads to your content. (False)
    12. The number of AdSense Ads you can place on a desktop site is the same as you can place on a mobile site. (True)
    13. Page speed is important to Ad revenue because users are more likely to stay on your page and return again if the site loads faster. (True)
    14. If the AdSense crawler can't crawl a web page, the Ads displayed to that page may not be relevant to the page content. (True)
    15. A rejected Ad request occurs when site's content does not comply with AdSense policies. (False)

    Explanation of the False Ideas/ Concepts/ Notions

    Idea # 2

    728 x 90 Banner Ads perform well. But it doesn't mean that your page must have it. It  depends on your site's style and type. 

    Idea # 3

    Blocking non performing Ad categories may increase your revenue if done properly. But personally, I don't believe it - Learn more . . .

    Idea # 6

    CPC - Cost Per Click is the amount you earn each time when a user clicks on your Ad. CPC is determined by the Advertiser. 

    CTR - Click Through Rate is the number of clicks against pageviews. If you get 2 clicks against 10 pageviews, then your CTR is 20%.

    Idea # 8

    Blending Ad Units in such a way that users can't differentiate between Ads and Contents may be harmful for your AdSense account. Even you could be banned from AdSense program!

    Idea # 9

    If your page calls for an Ad to be served but no Ad is returned it will considered as rejected Ad request. 

    Idea # 10

    The Advertiser with the lowest CPC will win the bid. Advertiser Raj bids $2.10 CPC. So he will win the bid not Raj. 

    Idea # 11

    Contextual targeting analyzes your keywords, topics, text, language, link structure, page structure etc. It considers the central theme of your site rather than a single topic. To be honest, I don't know much about contextual targeting.  

    Idea # 15

    A rejected Ad request occurs when your page calls for an Ad to be served but no Ad is returned. But if your site doesn't comply with the AdSense policies, simply you will be banned from AdSense! 

    Stay with Marks PC Solution to get more interesting IT topics!


    1. Good information. It seems that before I will take Google's assessment test I really should read information or articles about "Adsense". I don't want to be banned when I enter "Adsense". :-)


    Post a Comment

    Popular Posts

    GTA San Andreas Cheat Code (PDF)

    After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them. 
    To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs. 

    I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side. 

    You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom. 

    EffectCheat CodeAdrenaline ModeMUNASEFAll Cars ExplodeALLCARSGOBOOMAll Cars Have NitroCOXEFGU or SPEEDFREAKAll Green LightsZEII…

    Office 2016 Activator (KMSPico 10.1.5)

    It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!!

    About the Activator Name: KMSPico 10.1.5File Size: 3 MB (Approx)File Type: Zipped Folder100% Neat & Clean - No virus!

    Activating Capacity . . .
    KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010Windows 10, 8.1 & 8Hopefully this version will work for both 32 bit & 64 bit versions of Windows.

    Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else.Install it as trial version without any key.Use the following activator . . .

    Download > Install > Enjoy . . . Get the file from here. The first link i…

    Office 2010 Activator (KMS) !!

    Day by day cracking has been a tough job. But yet very possible. Earlier a software may require only serial key to activate. But today there are many other options. Sometimes you might be asked to connect to the internet to activate or sometimes you're asked to make a phone call! 

    Microsoft Office 2010 has the same problem. It is not simply activated by the CD key. Sometimes CD key may not be asked during the installation process. If you're required to enter serial then try any of the following:




    After installing a trial version of Office 2010 you're allowed to use it for 30 days only. After that it will ruin your peace. It will give you continuous love messages each time you start office. Today I'm gonna share an activator by which you can activate Office 2010 and stop unwanted love messages by MS Of…

    Office 2013 Activator (KMSpico 10.1.5)

    KMSpico 9.1.3 is really an amazing tool for activating Office 2013. And as a bonus, you can also activate Windows 8 or 8.1 with this activator. Earlier I shared different activators for Office and Windows. And those activators are working fine. If you can't activate your Office or Windows by those activators, then you can try this one. 

    I've got Microsoft Office Professional Plus 2013 (final version) last week. And before that I was using Office 2010. After installing Office 2013, I was unable to use it before activating. And with this KMSpico 9.1.3 my Office gets activated within minutes. It's very easy to use! 

    Furthermore, this KMS is capable of activating -  Windows 8 and 8.1 (All Versions) Windows Vista and 7 (Business, Professional & Enterprise Edition)Office 2010 and 2013Windows Server 2008/2008R2Windows Server 2012/2012R2

    Activation Procedure: Download the KMSpico 10.1.5 from Here.Now double click on it. And follow the manual include inside.Press Next > Accept ter…

    Download GTA Vice City Cheat Codes (PDF)

    Couple of years ago, GTA Vice City was one of the most popular game. GTA games are always preferred by the gamers. Most of the GTA games like Vicy City, Liberty City, San Andreas have cheat codes. With these cheat codes, you can complete missions easily. When something is very difficult to perform normally, you can use cheats. 

    Here I'm gonna share 32 selected cheats with you. I've omitted the unnecessary cheats. And these cheats are also applicable for GTA Liberty City!

    Press any of the below cheats while playing the game. The right part of the table contains the cheats and the left part contains the results. 

    Cheat Code All Cars are FasterGet There FastArmorPrecious ProtectionBetter Driving SkillGrip is EverythingCaddyBetter Than WalkingCars Float on WaterSea WaysCars FlyAirshipCars FlyingCome Fly With MeClear Wanted LevelLeave Me AloneCommit SuicideI cant take it any moreDestroy All CarsBig BangFast CarGet There QuicklyFaster Game ClockLife is passing me byFaster Game Pla…

    IDM 7.2 Portable Free Download!!

    There is nothing new to tell about Internet Download Manager (IDM). Most of you are familiar with this amazing download accelerator. But still people look for the cracked version of IDM. Version changes over time. And people try to get the new activated version. Today I'm gonna share IDM 7.2 (Portable) with you! 

    Before I begin, I should declare that this is not a registered version of IDM actually. But the settings of this IDM are modified. You don't need to upgrade or register this version. After 30 days, you will not get the notifications to upgrade. And you will enjoy all the advantages just like a registered version. 
    But there is nothing to worry about. You can download this portable version of IDM without hesitation. It's just 4.7 MB. You don't need to install it. This version will never demand serial from you. And the download link is 100% free from ads, spams or malware.

    Downlaod IDM 7.2 Portable either from Link 1 or Link 2. Unzip the folder and move it to your …

    Rules for Bengali Typing in PDF (Bijoy Layout)

    Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing.

    Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing. 

    Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout. 

    Download the PDF file from the button below. Follow my instructions properly. And I can guarantee you will be able t…

    How to Disable Word Verification (Captcha) in Blogger Comment

    By default blogger blogs are designed to show word verification when visitors comment in a post. Though this is a very useful tool to avoid spam, but real users often get bored by this option. Besides blogger has an automatic spam checking tool. So you can remove the word verification option from the comment in order to let your visitors express their opinion easily. 
    While commenting on blogger blogs or other websites you may face a word challenge. And this is a very common thing. Specially when you open any online account. Sometimes words used in the verification option are too hard to guess. And users are very annoyed with this. 

    Look at the image above. When you comment on blogger blogs or someone comments on your blog he/she will face a challenge like this. Normally this option doesn't show any hard challenge. But sometimes they are also difficult to guess. Users have to try this again and again. If they are annoyed they will loose interest to express their opinion. 

    Since blogg…

    Disable Automatic Update in Windows 10

    As I mentioned earlier, Windows 10 has come with some boring changes. One of the stupid changes is related to Automatic Update. In Windows 10, you're set to automatically install new updates. And you've no choice to change this settings. Because the change settings option is disable. 

    Applies to: Windows 10

    Disable Automatic Update (Final Edition)

    When you Disable Automatic Update?

    If your net bandwidth is limitedIf you don't need windows updates at allIf the updates cause activators not work in your PC
    In earlier versions of Windows (Windows 7, 8 or 8.1), you can manually configure the update settings. There were four settings: Install updates automaticallyDownload updates but let me choose whether to install themCheck for updates but let me choose . . . Never check for updates
    In Windows 10, you don't have any option to choose any of these settings. It's simply disabled. You can't use the drop down menu. Look at the image below:

    But still you have a chance to configu…