How to Track Course Marketing Performance Using Google Sheets

Open a new Google Sheet and create these column headers in Row 1: Date, Channel, Page Views, Email Signups, Conversions, Revenue. Date is the week ending date. Channel is the traffic source — organic search, email, Instagram, Facebook, LinkedIn, podcast, referral, or paid ads. Each row represents one channel for one week. If you're active on three channels, you'll add three rows per week. That's 12 to 15 rows per month — manageable by hand.

Pick a day — Monday morning works well — and spend 10 to 15 minutes pulling the previous week's numbers. Traffic data comes from Google Analytics, filtered by source/medium. Email signup counts come from your email platform (Mailchimp, ConvertKit, Beehiiv, or whichever you use). Conversion and revenue data come from your course platform's dashboard. Consistency matters more than precision here — an approximate number entered every week is far more useful than exact numbers entered sporadically.

In column G, add a header called Signup Rate. The formula is straightforward: =D2/C2 (email signups divided by page views). In column H, add Purchase Rate: =E2/D2 (conversions divided by email signups). Format both columns as percentages. These two rates tell you different things. Signup rate measures how compelling your free offer is. Purchase rate measures how effectively your email sequence converts subscribers into buyers. If your signup rate is strong but your purchase rate is low, the problem is in your email nurture sequence, not your traffic generation.

For a summary view, add a new row at the bottom of each month's data with =SUM formulas to total each column. Calculating the overall conversion rate from the totals (not by averaging the weekly rates) gives you an accurate monthly picture.

After four weeks of data, select your Date and Revenue columns and insert a line chart (Insert > Chart in Google Sheets). Add a second series for Email Signups if you want to see whether growth in subscribers is translating to growth in revenue. A stacked bar chart works well for comparing revenue across channels — it shows at a glance whether one channel dominates or whether your revenue is diversified. Keep the chart on a separate tab called "Dashboard" so you can glance at it without scrolling through raw data.

At the end of each month, spend 20 minutes reviewing the dashboard. Ask three questions. First: which channel drove the most revenue? Not the most traffic — the most revenue. High-traffic channels with low conversion rates consume your time without growing your business. Second: which channel has the best purchase rate? A channel with modest traffic but a 5% purchase rate may deserve more of your effort than one with high traffic and a 0.5% rate. Third: what changed from last month? Trends matter more than snapshots.

The point of tracking is to make better decisions, not to accumulate a spreadsheet. If email consistently drives 60% of your revenue, spend more of your weekly marketing time on email content and list growth. If Instagram generates traffic but almost no conversions, either improve your Instagram-to-email funnel or reduce the time you spend there. If a channel you tried for two months shows no traction, stop and try something else. The dashboard turns these from gut feelings into evidence-based decisions.

Decide on your channel labels up front and use them exactly every week. "Instagram" and "IG" and "Social - Instagram" are three different values to a spreadsheet formula. Create a dropdown using Data Validation in Google Sheets (Data > Data validation > List of items) so you pick from a fixed list instead of typing freehand. This small step prevents hours of cleanup later when your SUMIFS formulas return zero because of a typo.

Revenue is the outcome you care about, but it's a lagging indicator. Email signups and page views move first. If your signups drop for two weeks in a row, that tells you something is off with your lead magnet or traffic sources — and it tells you before the revenue dip shows up. Watching the upstream metrics gives you time to course-correct before the numbers you care about are affected.

Weekly data is for entry. Monthly data is for decisions. A single week where email signups drop 40% could mean your email platform had a deliverability hiccup, or you published one fewer blog post, or it was a holiday week. Monthly aggregates smooth out that noise. When you review your dashboard, compare this month to last month — not this week to last week.

The biggest limitation of a spreadsheet dashboard is manual data entry. Every number requires you to look it up in another tool and type it in. For a solo creator tracking three channels weekly, that's 15 minutes of work — manageable. But if you scale to five channels, multiple courses, and daily tracking, the manual process breaks down. At that point, a tool like Databox or Google Looker Studio (free) can pull data automatically.

Google Sheets has no real-time data. Your dashboard is always as current as your last entry. If you need to see today's traffic or this morning's signup count, you still have to check your analytics tools directly. The spreadsheet is a weekly summary tool, not a live monitoring system.

Visualization in Google Sheets is functional but limited. Charts are basic. You can't build interactive dashboards with drill-downs or filters the way you can in dedicated BI tools. For a solo course creator making monthly strategy decisions, basic charts are sufficient. But if you find yourself wanting to slice data by campaign, by landing page, and by audience segment simultaneously, you've outgrown the spreadsheet.