Saturday, 11 February 2017

How to Make Phone Numbers Callable in Google Sheets

Learn how to insert phone numbers inside Google Spreadsheets and make the numbers clickable and callable on mobile phones.
If you click an email link on a webpage, it opens your default mail program. Similarly, you can make phone numbers on your website “callable” meaning when someone clicks the phone number, it will launch the dialer on their mobile phone and initiate dialing of the specified phone number. It is recommended that you make phone numbers clickable as more and more people would be accessing your site on their mobile devices.

How to Insert Clickable Phone Numbers in Web Pages


For instance, if you click this link on a mobile phone, it will open the phone dialer prefilled with the specified number. There’s no need to copy-paste numbers.

How to Type Phone Numbers in a Google Sheet

It is a bit tricky to type phone numbers inside Google Spreadsheets. Here’s why:
Phone numbers are mostly made of digits preceded by the plus (+) symbol. The problem is as soon as add the plus sign in the spreadsheet cell, it assumes that you entering a math formula and tries to calculate the value.

There are two simple workarounds to this problem. You can enclose the phone number inside double quotes (“) and precede it with an equal to (=) sign.
An even easier alternative is to use the single quote (‘) before the phone number. Google Sheets will then interpret the cell’s value as text and the phone number formatting will be preserved.

How to Make Phone Numbers Clickable in Google Sheets

Coming to the main problem, how do you make phone numbers inside a Google Sheet clickable. The obvious answer would be to use the =HYPERLINK() method with the tel protocol but, unfortunately, Google Sheets do not support it.
So a formula like =HYPERLINK(“tel:12345”, “Call Me”) would not work since sheets will only allow regular http and mailto hyperlinks. There’s a simple workaround though.

You can create a regular hyperlink in the cell pointing to a website which in turn redirects to the actual telephone link. To see this in action, add https://ctrlq.org/call/ before any phone number in the Google Sheet and it will turn into a clickable telephone link.

Say you have the phone number in cell A1. Add this simple formula in any other cell and it will create a telephone link just like on a regular webpage.
=HYPERLINK(“https://ctrlq.org/call/”&A1; “Call our support team”)
To get a better idea, open this Phone Number Google Sheet inside the Sheets app of your Android or iPhone and try clicking any of the phone links.

How to make money with Google Adsense. A Complete Guide from the Scratch.

What is Google Adsense ?
Google Adsense is the largest  advertisement program in this world ,which is run by Google.Inc . In which the owner of website, blog , youtube channel , web application & hubpages  get huge opportunity to make money by displaying advertisement on their content ,which is managed by Google . The revenue earned from advirtisment done on publishers content is shared between Google & the Adsense publisher (content owner) in the following ratio :
  1. For – Adsense for content – 68% of the revenue goes to publisher(content owner) & 32% of revenue goes to google. This is because , the content over which the ads is shown by google is owned by publishers. for example – websites, wordpress blogs , web applications.
  2. For – Adsense for hosted content – 60% of the revenue goes to publisher & 40 % to google , because the content is hosted on googles property like – youtube , hubpages , blogspot.
  3. For – Adsense for Search – 51% of the revenue goes to publisher & 49% of revenue goes to google.
How Google Adsense works ?
Web Advertisement  is the main source of revenue for google , which is managed by its product known as –  google adwords, In which advertisers from different part of the world sign up with google adwords and pay google to display the advertisement of their products & services across the whole web for any selectedkeyword.
Before the launch of adsense program . Google was only able to show its advertisement in the search results done by the public on tis own home page , or only on its own products. Hence the growth of revenue was limited , Hence Google came up with this program called Adsense in 2003 , through which google expanded its advertisement to others content as well , like others website , blog , web apps etc. Now google was able to collect more revenue from the advertisers , and in return some percentage of revenue is shared to the content publishers . so this is beneficial for both.
How it works – whene a advertiser wish to show his products & services ads on web , He  sign up with google adwords program , In which he mention his keywords . here google adwords display him the Cost (rate) for that keyword on per click basis ,which will be charged to advertiser . Now if any public is browsing some thing on any publisher website about the same topic , which is related to that keyword. Then Google algorithm recognize the scenario and display the ads of that advertiser there . If the public who is browsing the websit if he feels its need he may click on the advertisement. Then the per click charge is taken by the advertiser and this revenue is shared between google & publisher of website (content owner).
Starter Guide : Google Adsense for beginners . Step by step procedure on how to sign up & get approved with google adsense .
 If you are applying for your own website or blog –  Your website or blog must meet the all below mentioned requirements in order to get approved for adsense program.
  1. Your website of blog must have minimum 30 pages with quality post (mostly text) , which should be unique , should not be copied from any where , it should be completely created by your own.
  2. Should not contains topics like – porn & hacking . Also their should not be spelling mistakes .
  3. Try to keep your website on a single topic , on which you hav lot of knowledge & could write too much.
  4. Before applying your website should have a minimum of 500 viewers per day via search engine.
  5. Your website should not contains too much videos & images , because google hates websites which contains more photos & videos . google loves those websites which contains quality & unique text .
  6. Your website should be not in under construction mode , it should be completely finished at the time of applying for adsense.
  7. Your website should contains tabs like – about us , contact us & term of use or privacy policy.
                              If your website or blog meets the above all requirements , then create / sign up for agoogle adsense account . your account will be definitely approved .
How to Sign up for google adsense ?
Step 1 – If you have a existing google / gmail account you can use the same id for adsense or if you wish create a new google / gmail account.
Step 2 – open – http://www.google.com/adsense/start/   in your browser and click on – Get started now. And proceed with your google account sign in , Here key in your existing / newly created gmail / google account user name & password.
Step 3 – Enter your website name carefully in the space provided & select your language.
Step 4 – Now continue to next page , where you need to fill  – PAYEE NAME & address.
Note – payee name can not be changed in future , hence fill it very carefully , & fill the complete address  and submit your application for approval.
Step 5 – Within 48 hours you will get a confirmation email saying that whether your submittion was approved or not approved . if  not approved , they will mention the reason mentioning why it was not approved . once you correct those errors & issue , apply again for approval.
Step 6 -If you get approved , then they will ask you to create a advertisement unit , once you create a ad unit , they will generate a code for that advertisement & you need to paste it in your website. After pasting that code in your website web page , blank ads start showing on your website. They ask to paste the code in your website just to confirm that you are the owner of website or not.
Step 7 –Now within next 48 hour , you will get a confirmation from adsense team that your adsense account is fully approved  .
Step 8 – Now you can create various ads unit and paste in your website , you will see ads live on your website.
NOTE – you can use the same ads unit code to various websites you own , you need not to apply for each website separately . Because this is also against the term of adsense. Since a  adsense publisher should not have more than 1 adsense account.
What is Adsense for search ?
Suppose if you get approved by adsense for content ( for your website or blog ) then you are also eligible for adsense for search . In order to get ads on your website or blog by adsense for search , just you need to get the code from google custom search & paste in your website home page . which will create a search box in your website ,  which can only search the content within your website only . but whenever a visitor search in custom search box ( powered by google) , google will display some advertisement above the search results. If the visitor clicks on that type of ads , thene the publisher share is 51 % of revenue & google share is 49% of the amount received per click by advertiser.
What is hosted adsense for content ?
Simply  here “hosted” term means your content is being hosted on google’s  hosting space  or property. You had not paid any fee for hosting your content. This type of adsense applies to youtube adsense , blogspot adsense & hubpages adsense. In all these cases publisher publish their content on google’s hosting space . Hence in these all case revenue share for publisher is 60% & google is 40% , which is less than adsense for content.
NOTE – If you are approved for adsense for content ( website or blog ) , Then still you need to apply for youtube channel separately , also for blogger & hubpages you need to approval separately.
Do people live their earnings on adsense for fulltime ? What are the drawback of adsense ?
Yes , off course . various people makes millions by only adsense , even many big companies pay their employees by adsense earnings. But it is quite risky , if you are new to adsense  & if you completely depends upon adsense earnings. No doubt , you can earn lot of money from adsense because it is the highest paying cost per click program . But if your adsense account get disabled , then you will never be able to get adsense on your own name & for the same website.
What is the biggest benefit of google adsense program ?
Regular passive income source – Once you get approved for adsense you get regular monthly payments if your earnings exceeds 100 usd .
  1. No delay & no cheating in payment .
  2. If you make your full time business , you would have lot of time to spent for your friend & family.

How to make money with Google Adsense. A Complete Guide from the Scratch.

What is Google Adsense ?
Google Adsense is the largest  advertisement program in this world ,which is run by Google.Inc . In which the owner of website, blog , youtube channel , web application & hubpages  get huge opportunity to make money by displaying advertisement on their content ,which is managed by Google . The revenue earned from advirtisment done on publishers content is shared between Google & the Adsense publisher (content owner) in the following ratio :
  1. For – Adsense for content – 68% of the revenue goes to publisher(content owner) & 32% of revenue goes to google. This is because , the content over which the ads is shown by google is owned by publishers. for example – websites, wordpress blogs , web applications.
  2. For – Adsense for hosted content – 60% of the revenue goes to publisher & 40 % to google , because the content is hosted on googles property like – youtube , hubpages , blogspot.
  3. For – Adsense for Search – 51% of the revenue goes to publisher & 49% of revenue goes to google.
How Google Adsense works ?
Web Advertisement  is the main source of revenue for google , which is managed by its product known as –  google adwords, In which advertisers from different part of the world sign up with google adwords and pay google to display the advertisement of their products & services across the whole web for any selectedkeyword.
Before the launch of adsense program . Google was only able to show its advertisement in the search results done by the public on tis own home page , or only on its own products. Hence the growth of revenue was limited , Hence Google came up with this program called Adsense in 2003 , through which google expanded its advertisement to others content as well , like others website , blog , web apps etc. Now google was able to collect more revenue from the advertisers , and in return some percentage of revenue is shared to the content publishers . so this is beneficial for both.
How it works – whene a advertiser wish to show his products & services ads on web , He  sign up with google adwords program , In which he mention his keywords . here google adwords display him the Cost (rate) for that keyword on per click basis ,which will be charged to advertiser . Now if any public is browsing some thing on any publisher website about the same topic , which is related to that keyword. Then Google algorithm recognize the scenario and display the ads of that advertiser there . If the public who is browsing the websit if he feels its need he may click on the advertisement. Then the per click charge is taken by the advertiser and this revenue is shared between google & publisher of website (content owner).
Starter Guide : Google Adsense for beginners . Step by step procedure on how to sign up & get approved with google adsense .
 If you are applying for your own website or blog –  Your website or blog must meet the all below mentioned requirements in order to get approved for adsense program. [Read more…]

Earn Money With Images

Click Below Images to Complete Task


Image 1

Image 1

Earn Money With Website

Click Below Banner to Complete Task 
(Revenue Generator 1)


Click Below Banner to Complete Task 
(Revenue Generator 2)



Click Below Banner to Complete Task 
(Revenue Generator 3)



Click Below Banner to Complete Task 
(Revenue Generator 4)