4.88 (8 reviews)

### 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.

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
• 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

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

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)

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:

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:

• User-friendly and professional design
• Benchmark values included
• Informational notes included
• Works both on Mac and Windows
• Compatible with Excel 2010 and later versions
• Does not include any VBA code or macros

### PRODUCT VIDEO

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

1. Celeste

great!

2. Pete M

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

• Someka

Hello Pete,

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.

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!

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