Most small business owners spend money on marketing without really knowing which parts are working. They run Google ads, post on social media, send emails, and ask customers how they heard about them — but without a system to track and compare results across channels, the decision of where to spend next month's marketing budget is mostly guesswork.
Excel fixes this. A simple marketing analytics tracker lets you compare cost per lead, conversion rate, and cost per customer across every channel you use, so your marketing budget goes to what actually works rather than what feels like it should work. Here is how to build one.
Before building anything, get clear on what you actually need to measure. For most small businesses the marketing metrics that drive real decisions are cost per lead, lead to customer conversion rate, and cost per acquired customer. Everything else is secondary. If you know those three numbers by channel, you know where your marketing money is well spent and where it is not.
Your spend tracker logs every marketing expense by channel and month. This is the input side of your marketing analytics — what you spent and where. Without this, calculating cost per lead or cost per customer is impossible.
| Column | What to Enter |
|---|---|
| Date | When the spend occurred |
| Channel | Google Ads, Facebook Ads, Email, SEO, Events, Print, Referral, etc. |
| Campaign | Specific campaign or initiative if applicable |
| Description | Brief note on what this spend was for |
| Amount | Dollars spent |
| Month | =TEXT(Date,"mmm yyyy") for easy grouping |
Monthly spend by channel automatically:
Tracking where every lead comes from is the most important data habit you can build as a small business marketer. Without it you cannot calculate cost per lead or know which channels are generating the most qualified prospects.
| Column | What to Enter |
|---|---|
| Date | When the lead came in |
| Name | Lead's name |
| Email or Phone | Contact information |
| Source Channel | How they found you, be specific |
| Campaign | Which specific campaign or post if applicable |
| Lead Quality | Hot, Warm, or Cold, your initial assessment |
| Converted to Customer | Yes or No, update when they close |
| Revenue Generated | How much they spent, fill in when known |
With leads and spend tracked by channel, your key metrics calculate automatically:
This is where your marketing analytics delivers its highest value. A side-by-side comparison of every channel showing spend, leads, conversion rate, customers, and cost per customer tells you definitively which channels are worth investing more in and which are underperforming.
Here is what this comparison looks like across a few channels:
This table tells a clear story. Referrals generate the highest quality leads at zero cost. Email has a strong conversion rate and very low cost per customer. Google Ads is working but expensive. Facebook Ads is generating leads that rarely convert, making the cost per customer very high relative to the other channels.
The marketing decision those numbers suggest is obvious: invest more in referral programs and email, optimize or reduce Facebook Ads spend, and keep monitoring Google Ads performance. Without the data these conclusions require months of gut feel. With it they take five minutes to see.
Your marketing dashboard pulls your key metrics together in one view that you review at the start of each month. It answers the questions that drive your marketing decisions: how much did we spend, how many leads did we generate, what did it cost per lead, and are we getting better or worse over time.
| Metric | Formula |
|---|---|
| Total Marketing Spend | =SUMPRODUCT for current month across all channels |
| Total Leads Generated | =COUNTIFS on lead date for current month |
| Overall Cost Per Lead | =Total Spend / Total Leads |
| Leads by Channel | =COUNTIF for each channel |
| Overall Conversion Rate | =Customers Won / Leads Generated |
| New Customers This Month | =COUNTIFS on conversion date for current month |
| Cost Per Customer | =Total Spend / New Customers |
| Revenue from New Customers | =SUMIFS on revenue column for current month customers |
| Marketing ROI | =(Revenue from New Customers - Marketing Spend) / Marketing Spend |
If you have never tracked marketing analytics before, start with just two things. Track every lead source when a new lead comes in, and track your total marketing spend by channel each month. Those two habits alone will give you more insight than most small businesses have after years of marketing.
Once those are running consistently, add the conversion tracking and dashboard. Within three to six months you will have enough data to make genuinely data-driven marketing decisions, which for most small businesses means reallocating budget away from channels that feel productive toward ones that demonstrably are.
If you would like a custom marketing analytics workbook built for your specific channels and business model, that is exactly what we do at HelpMyData.
Tell us about your marketing channels and we'll build a complete Excel tracking system covering spend, leads, conversion rates, and cost per customer. Starting at just $75.
📧 Get Started Today