Publisher Ad Revenue Planner

Stop guessing what your website will earn

The Publisher Ad Revenue Planner is a ready-made spreadsheet that forecasts your ad income, tracks your RPM, compares ad networks, and helps you price sponsorships. Works in Excel and Google Sheets.

  • Forecast 12 months of ad revenue in minutes
  • Spot RPM changes before they cost you money
  • See what switching ad networks could add
  • Set a goal and know exactly how long it will take
Publisher Ad Revenue Planner

The problem: Ad income feels like a black box

You publish great content. Traffic grows. And then your earnings go up one month, drop the next, and nobody can tell you why.

So you end up asking the same questions again and again:

  • How much will my site actually earn next year?
  • Is my RPM good, or am I leaving money on the table?
  • Would a different ad network pay more?
  • Did that new ad layout help or hurt?
  • How much traffic do I need to reach my income goal?

You could build a spreadsheet to answer all of this. But that means hours of formulas, and one wrong cell quietly gives you wrong numbers.

The solution: One planner. Every number you need.

The Publisher Ad Revenue Planner turns the guesswork into a clear plan. It was built by the team behind the AdRevHub Ad Revenue Calculator, and it takes the same simple logic (impressions x CPM) much further.

Enter your numbers in the yellow cells. Everything else calculates automatically. No macros, no add-ins, no learning curve.

What’s inside: 7 tools in one workbook

1. 12-Month Forecast Project your monthly and yearly ad revenue using your traffic, pageviews, ad units and CPM. Adjust for your niche, your audience’s countries and seasonal swings (including the Q4 jump). Includes a chart.

2. RPM and Revenue Tracker Log your real monthly numbers and watch page RPM, eCPM and month-over-month change update automatically. You will see trends at a glance instead of digging through dashboards.

3. Ad Network Comparison Enter your pageviews and the RPM each network could pay. See monthly and yearly revenue side by side, plus the extra income switching could bring. Includes a reference guide to popular networks.

4. Ad Placement Test Log Record every layout test with control and variant RPM. The sheet calculates the lift, estimates the monthly impact and tells you whether to keep the change, revert it or keep testing.

5. Ads + Affiliate Model See how affiliate links add to your ad income. Includes a sensitivity grid that shows affiliate revenue at different click-through and conversion rates.

6. Sponsorship Rate Card Turn your audience numbers into prices for banners, sponsored posts, newsletter mentions and bundles. Comes with an outreach email template and a media kit checklist.

7. Income Goal Planner Set a monthly revenue target. See how much traffic you need, how many months it will take at your growth rate, and chart the path to get there.

Bonus: A Start Here tab with instructions, a colour key and a guide to every tab.

How it works: Up and running in 10 minutes

Step 1. Download. You get the file instantly after purchase.

Step 2. Enter your numbers. Fill in the yellow cells with your traffic, CPM and revenue figures. Example values are included so you can see how everything works.

Step 3. Make better decisions. Read your forecast, compare your options and plan your next move with real numbers.

Publisher Ad Revenue Planner

Who it’s for: Made for publishers who want to earn more from their traffic

This planner is a great fit if you are:

  • A blogger or niche site owner earning from display ads
  • A publisher preparing to apply to a premium ad network
  • Someone running affiliate links alongside ads
  • A site owner who wants to sell direct sponsorships
  • Anyone who wants clear projections before making business decisions

It is probably not for you if you need automatic data syncing with Google Analytics or your ad network. This is a spreadsheet you fill in yourself, which keeps it simple, private and fully under your control.

Why a spreadsheet? Simple, private and yours to keep

  • No subscription. Pay once, use it for as long as you like.
  • Your data stays with you. Nothing is uploaded to anyone’s server.
  • Fully editable. Change any assumption, add your own rows or adapt it for each of your sites.
  • Works where you already work. Excel, Google Sheets and LibreOffice.

Get the complete planner

Price: $19 (launch price, regular price $29)

What you get:

  • The full 8-tab workbook (Excel and Google Sheets compatible)
  • Step-by-step instructions inside the file
  • Free updates to this version
  • Instant download

Get the Planner for $19

Publisher Ad Revenue Planner

FAQ

Does it work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets, or use File > Import. Formulas and dropdowns carry over.

Do I need Excel skills?
No. You only type into the yellow cells. Every other cell calculates by itself.

Are the numbers guaranteed?
No. The planner gives estimates based on the numbers you enter. Your real earnings depend on traffic quality, your ad setup, your audience and the market.

Where do the CPM and RPM values come from?
The example CPMs, niche multipliers, country multipliers, seasonality and network RPMs are illustrative starting points. Replace them with your own figures from your ad dashboard for the most accurate results.

Can I use it for more than one website?
Yes, for websites you own or manage. Make a copy of the file for each site. Please do not resell or share the file.

Does it connect to Google Analytics or my ad network?
No. You enter numbers manually, which keeps your data private and the workbook simple.

Which ad networks does it support?
It works with any network, because you enter your own RPM. The comparison tab includes a reference guide to AdSense, Ezoic, Journey by Mediavine, Mediavine, Raptive and Media.net, and a row for any network you want to test.

Will I get updates?

You will receive free updates to this version by email.

What if I need help?
Email at contact@adrevhub.com and we will get back to you within 5-7 working days.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top