Earnings from AdSense contextual ads can come from clicks or impressions, but the amount earned may be below 2 decimal points and may show as zero in the report. The Cost for a single impression may be such a small figure that it may take many decimal places before you see any significant figures. So Google AdSense has come up with something called CPM which stand for Cost per 1000 impressions and is calculated with the formula
CPM = (earnings X 1000)/no. of impressions
A rearrangement of the above figure will give the formula
earnings = (eCPM X no. of impressions)/1000.
where eCPM is the effective (average) Cost per 1000 Impressions. Sometimes, you see in the report no clicks for a particular channel, zero earnings but a positive figure for eCPM. That means you have earned something from those impressions. You can use the above formula to calculate how much you earn or, simpler, enter the no. of impressions and the eCPM into the respective cells of the spreadsheet below (the spreadsheet is interactive), and the earnings will be automatically calculated for you. Try it and see. You can also use the table to confirm the CPM earnings reported when you see a small figure for earnings but zero for clicks.
Adsense Excel Earning Calculator
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment