skip to Main Content

AdSense Ad Revenue Calculator Excel Template

4.88 (8 reviews)

Spreadsheet to calculate Google AdSense earnings. Printable and simple Excel template for ad revenues. Ready for use. Industry benchmarks included.

Learn more about License Types


Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

TEMPLATE DESCRIPTION

You are running a website and planning to place some Google AdSense ads in order to make some money. Great, but you want to know how much AdSense revenue will you make with these ads, right? Then, our Ad Revenue Calculator Excel template will help you to calculate estimated Adsense earnings in seconds with industry benchmarks.

How much money can you make with Google AdSense?

Even though it is a simple calculation, it depends on many factors like your traffic, industry, visitor behavior, number of ads, and so on. You may know some of these metrics by looking at your analytics. But you may not have any idea about parameters like CTR (Click through Rate) or CPC (Cost Per Click). You will have to take some industry averages by looking at benchmarks for these figures.

Here are the metrics we consider while calculating estimated website ad revenue:

  • Daily Visitors
  • Avg. Page View per Visit
  • Ads per Page
  • CTR % (Click Through Rate)
  • CPC $ (Cost per Click)

We have prepared this Excel Template in order to make it easier to put in these variables and play with them. Let’s see an example and how can you calculate your estimated Adsense revenue.

Using Ad Revenue Calculator to see estimated earnings for 1000 daily visitors

The number of visitors is just one metric we use. You will also need to know the other metrics mentioned above in order to come up with more accurate estimations. Nevertheless, let’s make some assumptions for this example and find estimated earnings in 5 easy steps.

1 & 2) Calculate Ad Impressions

How to Use Adsense Revenue Calculator Excel Template - Someka SS1 tin

We assumed your average page view per visitor is 2.2 and you placed 2 ads per page on average. Simply making the calculations, brings us to 4,400 ad impressions per day.

3) Find Out Appropriate CTR and Calculate Number of Clicks

Then, your visitors see your ads 4,400 times and now let’s find out how many of them will click on these ads.

How to Use Adsense Revenue Calculator Excel Template - Someka SS2 tin

Let’s say you are in the e-commerce industry. There are some benchmarking studies that we can use for an average CTR value specific to our industry. In Adsense Calculator, you can just select your industry from the dropdown and it will show you the average CTR. (Source: https://www.wordstream.com/average-ctr)

4) Find out the appropriate CPC in Ad Revenue Calculator

Now we have inputted 0.45% as CTR. When we multiply 4,400 impressions by 0.45%, this tells us that you will receive around 20 clicks per day. So far cool, but how much does Google pay you per click? In the last step, we are going to use another benchmarking for this metric which is known as CPC (Cost Per Click)

How to Use Adsense Revenue Calculator Excel Template - Someka SS3 tin

According to a similar benchmarking study as before, this gives us $0.29 as CPC for our selected industry. (Source: https://www.wordstream.com/cost-per-click)

5) Calculate Adsense Estimated Earnings

Now we know the number of clicks and pay per click, we just multiply them:

Someka SS4 tin

With some rough assumptions, you will earn $5.80 per 1000 visitors every day. However, as mentioned, this is just an estimation and varies a lot depending on the geography, your niche, and so on. So please don’t take this for granted.

You also see your RPM value here (Revenue per thousand impressions). RPM is a commonly used number in advertising programs, and you may find it helpful for comparing revenue across different channels.

Ad Revenue Calculator Excel Template Features Summary:

  • Google Adsense revenue calculator for estimated earnings
  • User-friendly and professional design
  • Benchmark values included
  • Full Print Ready
  • Informational notes included
  • No installation needed, ready-to-use
  • Works both on Mac and Windows
  • Compatible with Excel 2010 and later versions
  • Does not include any VBA code or macros

** We provide this tool to make calculations easier. Someka is not associated with Google nor we do not guarantee any earnings calculated with this template. For more information about Google Adsense system and terminology, please refer to: https://support.google.com/adsense

Adsense Revenue Calculator is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

8 reviews for AdSense Ad Revenue Calculator Excel Template

  1. Celeste

    great!

  2. Pete M

    nice app thank you!
    how can I add new sheet?

    • Someka

      Hello Pete,

      To add new sheets:
      – Please unlock your workbook. Go to Review > Protect Workbook and enter your password.
      – Display your sheet tabs. Please click here to see how to display sheet tabs.

      Hope this helps!

      Should you have further questions, please let us know.

  3. Angelita R

    everytng is ok but one question removing logo is possible?

    • Someka

      Hello Angelita,

      You can remove the logo or replace it with your own logo for each sheet. For Free Versions, you are not allowed to remove the logo or alter any copyrighted material in the template.
      You can do it in the full version. Please check how to do that in this link.

      how-to-remove-someka-logo

      Hope this helps!

  4. Teresita

    see details part is very creative and nice!!!

  5. Fito U

    As with all your products, there is a product tutorial video for this. I like you someka.

  6. Chirag Wasnik

    Template is great and free you are awesome

  7. Luis Bo

    my ctr is 0.019 is that normal.. i am not getting a lot of views yet but still .. what can i do to bring that number up?? Thnanks!!!

  8. Andy Grushon

    Very helpful spreadsheet, but I’d like to know how much id generate from a website with around 100k+ unique visitors per month(I didn’t get there yet, but I surely will) using adsense.

    • Someka

      Hi Andy! Thanks for your feedback. We will consider your feature idea!

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED TEMPLATES