The marketing metrics that matter for a course business fit on one spreadsheet page: email subscribers, conversion rate, revenue per student, and refund rate. Everything else is vanity. Most course creators don't have the budget for Mixpanel or the patience for GA4's learning curve — but a well-structured Google Sheets spreadsheet can give you 80% of what you need. It won't track individual visitor behavior, but it'll show you which channels actually bring buyers.
What you’ll walk away with:
- A weekly marketing tracker showing impressions, signups, sales, and revenue by channel
- Conversion rate formulas that reveal which channels actually drive purchases
- A channel summary tab that aggregates data for strategic decisions
- A 15-minute weekly ritual that replaces gut-feel marketing with real numbers
Why Google Sheets for marketing tracking
Google Sheets solves this not because it's a sophisticated analytics tool — it isn't — but because it's free, familiar, and forces you to look at real numbers every week. The act of manually entering "Instagram: 2 signups, 0 sales" and "Email: 8 signups, 3 sales" makes the difference between those channels visceral in a way that no automated dashboard achieves. You can't ignore a column of zeros.
If you're already using Google Analytics for your website, this spreadsheet complements it by pulling in data from platforms GA4 can't see: your email provider's open and click rates, your social media engagement numbers, and your payment processor's actual revenue data. The spreadsheet becomes the one place where everything meets.
Step-by-step: Building your marketing dashboard
Create the workbook structure
Open Google Sheets and create a new workbook. Name it something you'll actually open — "Course Marketing Dashboard" works. Create two tabs: "Weekly Tracker" for your ongoing data and "Channel Summary" for a high-level view. The Weekly Tracker is where you'll do your input; the Channel Summary will use formulas to calculate what's working.
Set up your Weekly Tracker columns
In the Weekly Tracker tab, create these columns: Week (date), Channel, Impressions/Reach, Clicks/Visits, Email Signups, Sales, Revenue, and Notes. Each row represents one channel for one week. So if you're active on three channels, you'll add three rows per week. This sounds tedious, but it takes about ten minutes once you have the habit — and those ten minutes will be the most valuable marketing time you spend all week.
For the Channel column, be specific. Don't just write "social media" — break it into "Instagram," "LinkedIn," "YouTube," or wherever you actually post. The point is to see which specific channel converts, not which broad category. If you run paid ads, track those separately from organic posts on the same platform.
Add conversion rate formulas
In a column after Revenue, add a formula for signup conversion rate: =IF(D2>0, E2/D2, 0) where D is Clicks and E is Signups. Add another for sales conversion rate: =IF(E2>0, F2/E2, 0) where E is Signups and F is Sales. Format these as percentages. These two numbers tell the real story: how well each channel turns attention into interest (signup rate) and interest into revenue (sales rate). A channel with low traffic but a high sales conversion rate is often more valuable than one with high traffic and low conversion.
Build a Channel Summary tab
The Channel Summary tab aggregates your weekly data into a per-channel view. Use SUMIFS to total up impressions, signups, sales, and revenue for each channel across all weeks. Then calculate an overall conversion rate and a cost-per-sale if you're spending money on any channel. This tab is what you'll look at when deciding where to double down and what to drop. Sort it by revenue or by sales conversion rate — whichever number matters more to you right now.
Pull data from your actual platforms
Here's where to find the numbers for each row. Your email provider (Kit, Mailchimp, whatever you use) shows open rates, click rates, and subscriber counts. Your social media platforms show impressions, engagement, and link clicks in their native analytics. Your payment processor — typically Stripe or PayPal — shows actual revenue. And your course platform shows enrollments. The tricky part is connecting "this person came from Instagram" to "this person bought my course." UTM parameters on your links help if you're using GA4 alongside this spreadsheet. If not, use unique landing pages or coupon codes per channel as a rough proxy.
This reconciliation is imperfect. Your data lives in four or five different places, and no single tool combines it automatically unless you pay for a dedicated integration. The spreadsheet is the manual version of that integration.
Set a weekly review ritual
Block 15 minutes on the same day each week — I'd suggest Friday afternoon or Monday morning — to pull your numbers and enter them in the spreadsheet. Don't skip weeks. The value of this system compounds over time: after a month you can see trends, after a quarter you can see seasonal patterns, after a launch you can compare this launch to the last one. The spreadsheet doesn't do anything if it's empty.
Tips for course creators
Track effort alongside results
Add a "Hours Spent" column next to each channel's weekly data. This lets you calculate not just which channel brings the most sales, but which channel brings the most sales per hour of your time. You might discover that your YouTube channel brings twice the revenue of Instagram but takes four times as long to maintain. That math changes your strategy.
Use conditional formatting to spot trends
Apply a color scale to your conversion rate columns — green for high, red for low. This visual shortcut lets you scan weeks of data at a glance and immediately see when a channel's performance shifted. Google Sheets has built-in conditional formatting under Format > Conditional formatting. Set it once and it updates automatically as you add rows.
Keep a 'What I Tried' notes column
The Notes column is underrated. When you try something different — a new subject line format, a different posting time, a webinar instead of a static sales page — write it down. Three months later, when your conversion rate spikes, you'll want to know what you did differently that week. Memory is unreliable; the spreadsheet isn't.
Limitations
No individual visitor tracking
Google Sheets can't track individual visitor behavior. It won't tell you that a specific person visited your sales page three times before buying, or that mobile visitors bounce faster than desktop visitors. For that level of detail, you need Google Analytics on your sales page. The spreadsheet tracks channel-level performance; GA4 tracks visitor-level behavior. They answer different questions.
Manual entry is both strength and weakness
Manual data entry forces you to engage with the numbers, but it's also easy to skip. If you find yourself falling behind after a few weeks, the system breaks. Some creators solve this by automating the data pull using Google Sheets' built-in IMPORTDATA function or Zapier integrations, but those add complexity. Start manual, automate later if the habit sticks.
No multi-touch attribution
A spreadsheet can't attribute multi-touch journeys. If someone discovers you on a podcast, follows you on Instagram, and then buys through your email, the spreadsheet only captures whichever channel you assign the sale to. This is a real limitation — most buyers interact with you across multiple channels before purchasing. Accept that the attribution is approximate and focus on the directional trends rather than precise per-channel ROI.
Frequently asked questions
How often should I update my marketing spreadsheet?
Weekly is the right cadence for most course creators. Updating daily leads to overreacting to noise — a single social media post going viral or a quiet Tuesday can distort your picture. Weekly updates smooth out those fluctuations and let you spot real trends. Set a recurring 15-minute block on Friday or Monday to pull your numbers. Monthly is too infrequent because you'll miss the signal that a channel stopped converting until it's too late to course-correct.
Can Google Sheets replace a dedicated analytics tool like GA4?
Not exactly, but it can be a solid complement or even a temporary substitute. GA4 automatically tracks visitor behavior on your website — page views, session duration, traffic sources — without you lifting a finger after setup. Google Sheets requires you to manually enter or import data, but it lets you combine metrics from multiple platforms (email provider, social media, payment processor) in one view. Many course creators use both: GA4 for website behavior and a Google Sheets dashboard for the cross-platform picture.
What if I only have one or two marketing channels?
Then your spreadsheet will be simple, and that's perfectly fine. If you only use email and Instagram, you need two rows per week. The structure still helps because it forces you to track actual numbers rather than relying on gut feeling. Most course creators who track even two channels discover that one of them converts meaningfully better than the other — and that insight alone justifies the ten minutes per week.
Related guides
- How to Track Course Revenue Using Google Sheets — pair your marketing data with a revenue spreadsheet for the full financial picture
- How to Track Course Sales Page Traffic Using Google Analytics — add visitor-level tracking to complement your channel-level spreadsheet
- How to Build an AI-Powered Course Creation Workflow — automate repetitive tasks so you have more time for actual marketing
- How to Schedule Course Marketing Posts Using Buffer — streamline the social media work your spreadsheet is tracking
From tracking to decisions
The point of a marketing dashboard isn't to accumulate data — it's to make better decisions with less guessing. After four weeks of tracking, you'll know which channel actually brings buyers. After eight weeks, you'll see whether a new strategy is working or not. The numbers won't lie to you the way your intuition sometimes does.
Once you know where your students are coming from, Ruzuku gives you a place to teach them — with zero transaction fees and no technical headaches. You handle the marketing. Your spreadsheet tells you what's working. Ruzuku handles the rest.