Blog Revenue Tracking in 2026: How to Build a Dashboard That Shows True Profit Per Post (Template Included)

You've been blogging for months — maybe years. You see a healthy total revenue number each month from Mediavine, Amazon Associates, and your digital products. But ask yourself: Which individual blog post makes you the most profit? Which posts actually lose money when you factor in writing time, editing, and promotion? If you can't answer those questions, you're leaving money on the table — and worse, you might be investing in content that's draining your resources.

In 2026, with rising content costs and intense competition for every keyword, profit per post is the only metric that matters. Total revenue is vanity; profit per post is sanity. This guide will teach you to build a simple, no‑code dashboard (Google Sheets or Notion) that tracks:

• Revenue from each monetisation channel: display ads, affiliate marketing, digital products, sponsorships.
• Direct costs: content production (writers, editors), tools, hosting, promotion.
• Indirect costs: a fair allocation of your time and overhead.
• Profit per post, per traffic source, and per monetisation channel.

By the end, you'll know exactly which 20% of your content produces 80% of your profit — and you can double down on what works.

Why Most Bloggers Don't Know Their True Profit Per Post

Here's a hard truth: most bloggers track top‑line revenue and call it a day. They see $5,000 from Mediavine, $2,000 from affiliate links, and $1,000 from an ebook — total $8,000. That looks great. But what if writing that ebook cost you $3,000 in freelance editing and design? What if your top five affiliate posts required $400 each in paid promotion? What if you're spending 40 hours a month on content that generates $200 in profit — while a single pillar post from two years ago makes $1,500 with zero maintenance?

Without profit‑per‑post tracking, you cannot make rational decisions about:

• Which topics to write more about (the ones with highest profit per hour).
• Which posts to update (high‑potential posts that have declined).
• Which traffic sources to invest in (some sources bring low‑value visitors).
• Which monetisation methods to prioritise (affiliate might beat display ads on certain posts).

In 2026, with AI content flooding the SERPs and Google's Helpful Content System rewarding genuine value, efficiency is everything. A blog that tracks profit per post will out‑earn a blog with twice the traffic but no cost visibility. Let's fix that.

Data Sources You Need: Revenue, Traffic, Costs

Before building your dashboard, gather data from these sources. You'll update it monthly (takes 30–60 minutes once set up).

Revenue Sources

• Display Ads: Mediavine, Raptive, Ezoic, or AdSense dashboards. Export monthly earnings by site (or by page if available). Mediavine provides page‑level RPM data — use that.
• Affiliate Networks: Amazon Associates, ShareASale, Impact, CJ Affiliate, individual brand programmes. Most let you export transaction reports with product, date, and commission.
• Digital Products: Gumroad, Lemon Squeezy, Payhip, Teachable — each has sales export. Include fees and refunds.
• Sponsorships: Manual tracking via invoice spreadsheet.

Traffic Data

• Google Analytics 4 (GA4): Page views, sessions, bounce rate, conversions per page. Crucial for attributing revenue to individual posts. If you haven't set up GA4 properly, see our Blog Analytics Setup in 2026: GA4 Configuration for Monetised Blogs.
• Google Search Console: Impressions, clicks, CTR — helps diagnose underperforming posts. Google Search Console for Bloggers in 2026 covers how to use it for profit analysis.

Cost Data

• Content production: Payments to writers, editors, proofreaders. Track per post or average cost per word.
• Tools & software: SEO tools (Ahrefs, Semrush), email marketing, hosting, CDN, stock photos, project management.
• Promotion costs: Pinterest ads, Facebook ads, Outbrain, Taboola — if you paid to promote specific posts.
• Overhead (optional but recommended): Allocate a percentage of your time (e.g., $50/hour) to understand true profit after your labour.

Building Your Dashboard: Google Sheets vs Notion

You don't need expensive BI tools. A spreadsheet is enough for most bloggers up to $50K/month. Here are two options:

For the rest of this guide, we'll focus on Google Sheets because it's universally accessible and allows the most detailed profit analysis. But the same logic applies to Notion.

Google Sheets Structure (5 Tabs)

1. Raw_Revenue: Columns: Date, Post URL/Slug, Channel (Display Ads, Affiliate, Digital Product, Sponsorship), Amount, Notes.
2. Raw_Costs: Columns: Date, Post URL/Slug, Cost Type (Writing, Editing, Tools, Promotion), Amount, Notes.
3. Traffic: Columns: Post URL/Slug, Month, Page Views (GA4), Sessions, Bounce Rate, Goal Completions.
4. Profit_Per_Post: Summary table with formulas (we'll build this).
5. Dashboard: Charts and pivot tables for visual insights.

You can download a template from the link at the end of this article (we'll provide a copy‑able Google Sheets link).

Profit Per Post Formula & Step‑by‑Step Example

The core formula is simple:

Profit Per Post = (Total Revenue Attributed to Post) – (Total Costs Attributed to Post)

Where:

• Revenue attribution: For display ads, use page RPM × page views / 1000. For affiliate, sum commissions from that post's links. For digital products, attribute sales to the post where the customer clicked (use UTM parameters or last‑click attribution in GA4).
• Cost attribution: Direct costs like writer payment, editing, images. Indirect costs (tools, hosting) can be allocated proportionally by page views or by number of posts.

Step‑by‑Step Example: A Real Post

Let's say you have a post: "Best Credit Cards for Travel Rewards 2026" (URL: /credit-cards-travel-2026). In January 2026:

• Page views (GA4): 12,000
• Display ad revenue (Mediavine RPM $25): ($25 × 12,000) / 1,000 = $300
• Affiliate revenue (credit card sign‑ups): 8 approved applications at $75 each = $600
• Digital product revenue (related ebook "Travel Hacking"): 3 sales at $27 = $81 (attributed via last click from this post's internal link)
• Total revenue: $981
• Direct costs: Writer ($150 for 2,500 words), editor ($40), stock photos ($15) = $205
• Allocated overhead (hosting, SEO tools, email marketing): Total monthly overhead $300 across 30 posts = $10 per post
• Total costs: $215
• Profit: $981 – $215 = $766

That's a highly profitable post. Compare it to another post with 5,000 views, $50 display ad revenue, $30 affiliate, $0 digital product, writer cost $100 → profit negative $20. Now you know which post to deprioritise.

Profit Per Traffic Source: Organic, Social, Email, Referral

Not all traffic is equal. Visitors from Google Search often have higher commercial intent than those from Pinterest or Facebook. To optimise your content strategy, calculate profit per traffic source.

In GA4, create a custom report showing page views, engaged sessions, and conversions by Session default channel group. Then, using your revenue attribution model, calculate:

• Profit from Organic Search: Sum of revenue from posts where the user's first interaction was organic, minus costs.
• Profit from Social: Similar for Facebook, Pinterest, Instagram, etc.
• Profit from Email: If you send newsletters promoting posts, track UTM parameters.

Most bloggers discover that organic search traffic produces 3–5× higher profit per visitor than social traffic. That insight alone will shift your content promotion efforts.

Profit Per Monetisation Channel: Ads vs Affiliate vs Products

Your dashboard should also show profit per channel. Some posts may be display‑ad goldmines but terrible for affiliate. Others might have low traffic but high affiliate conversion.

Create a pivot table that sums revenue and costs by Channel (Display Ads, Affiliate, Digital Products, Sponsorships) and then by Post. This reveals which monetisation method you should emphasise on each piece of content.

For a deep dive into which model suits your niche, read Display Ads vs Affiliate Marketing vs Digital Products for Blogs in 2026: RPM Comparison by Niche.

Automating Data Imports (Manual vs Zapier vs API)

Manual entry is fine for most bloggers — it forces you to look at the numbers monthly. But if you have 100+ posts, you can automate:

• GA4 data: Use Google Sheets add‑on "Google Analytics" (now deprecated, but you can use Looker Studio or Supermetrics). A free option is to manually export CSV from GA4 once a month.
• Affiliate revenue: Some networks (ShareASale, Impact) offer CSV exports. No universal automation without middleware like Zapier.
• Mediavine/Ezoic: Both provide CSV exports by page.

For most, a 30‑minute manual update each month is sufficient. The key is consistency — do it on the 1st of every month.

Real Dashboard Walkthrough with Numbers

Let's walk through a simplified Google Sheets dashboard for a blog with 50 posts.

Tab 1: Raw_Revenue

Enter each revenue event row by row. Example:

Tab 2: Raw_Costs

Tab 3: Profit_Per_Post (using SUMIF formulas)

In cell A1, list all post slugs. Then:

• Total Revenue =SUMIF(Raw_Revenue!B:B, A2, Raw_Revenue!D:D)
• Total Costs =SUMIF(Raw_Costs!B:B, A2, Raw_Costs!D:D) + (Allocated Overhead per post)
• Profit = B2 - C2
• Profit per 1,000 views = Profit / (Page Views from GA4) * 1000

Sort by Profit descending. The top 10 posts are your money makers. Create more content like them. The bottom 10 are either to be updated, consolidated, or removed.

Monthly Review Process & Actionable Insights

Set a recurring calendar event: first Friday of every month, 1 hour. Do this:

1. Update Raw_Revenue: Export from Mediavine, affiliate networks, Gumroad for the previous month.
2. Update Raw_Costs: Add any new writer payments or tool subscriptions.
3. Update Traffic: Pull GA4 page views for each post (last 30 days).
4. Refresh Profit_Per_Post formulas.
5. Look for anomalies: Which posts saw profit drop? Which traffic source improved?
6. Take action: Schedule updates for declining high‑profit posts. Cut costs on negative‑profit posts (e.g., stop promoting them). Double down on topics that show high profit per hour.

Over time, you'll build a content machine that only produces profitable content.

Advanced: Cohort Tracking & Content Lifetime Value (LTV)

Once you master basic profit per post, consider content lifetime value — the total profit a post generates over its entire life (e.g., 24 months). Some posts earn slowly but consistently for years. Others spike then die.

To track LTV, add a column for publication date. Then, in a separate sheet, calculate cumulative profit by month since publication. You'll see which posts have the best long‑term ROI. That informs your update strategy: posts with high LTV but recent decline are prime candidates for refresh.

If you're stuck at a revenue plateau, read Blog Income Plateau in 2026: Structural Fixes That Actually Work — often it's because you're not tracking profit and doubling down on the wrong content.

Frequently Asked Questions About Blog Revenue Tracking