The marketing dashboard

A marketing dashboard is one page of numbers that tells you, in a few minutes each month, whether your marketing is working and what to change. Learn which leading and lagging measures to include, how to build it in a spreadsheet and how to read it against the seasons.

Read the transcript

The marketing dashboard.

Most small business owners have more marketing data than they can use and less insight than they need.

Google Analytics, Search Console, two ad accounts, Instagram insights, a newsletter tool and a CRM all produce reports, and none of them answers the only question that matters: is my marketing filling the calendar profitably, and what should I change this month?

What a dashboard is for.

A dashboard is not a report of everything.

It is a short set of numbers chosen because each one leads to a decision.

The ten numbers.

Here is a starting set for an event business.

Most owners need eight to ten, never thirty.

Build it in a spreadsheet.

You do not need dashboard software.

A spreadsheet with three tabs works for most small businesses.

Make the CRM do the work.

A dashboard is only as good as the records behind it.

Most of the ten numbers come from the CRM, so set it up to produce them without extra effort.

Worked example: Lantern and Lane in November.

Close rate: 5 bookings divided by 18 inquiries is about 28 percent, which is in the “watch” band.

Average booking value: 29,500 dollars divided by 5 equals 5,900, dollars below the 6,500 dollars average in the studio's plan.

That is the lesson. The worksheet and the quiz are just below this video.

What you will be able to do

• Choose ten or fewer leading and lagging measures that drive decisions in your business
• Build a one-page monthly dashboard in a spreadsheet, fed by your CRM and ad accounts
• Run a 30-minute monthly review that compares results with targets and the same month last year

Most small business owners have more marketing data than they can use and less insight than they need. Google Analytics, Search Console, two ad accounts, Instagram insights, a newsletter tool and a CRM all produce reports, and none of them answers the only question that matters: is my marketing filling the calendar profitably, and what should I change this month? A dashboard answers that question on one page.

What a dashboard is for

A dashboard is not a report of everything. It is a short set of numbers chosen because each one leads to a decision. If a number on your dashboard went up or down by a third, and you would not do anything differently, take it off.

Good dashboards mix two kinds of measure.

• Lagging indicators tell you what already happened: bookings, revenue, cost per booking. They are the score, but by the time they move, the season may be over.
• Leading indicators move first and predict the score: inquiries, response time, consultations booked, pipeline value. They tell you early enough to act.

The ten numbers

Here is a starting set for an event business. Most owners need eight to ten, never thirty.

Website visits, followers and email open rates can live on a second tab for diagnosis. They belong on the main page only if you have a specific decision tied to them.

Build it in a spreadsheet

You do not need dashboard software. A spreadsheet with three tabs works for most small businesses.

1. Data tab: one row per month, one column per measure. Enter the numbers on the first working day of each month. It takes 20 minutes once your CRM fields are clean.
2. Dashboard tab: the current month, the target, the same month last year, and the rolling twelve-month total for each measure. Add a simple status column: on target, watch, or act.
3. Notes tab: one line per month on what happened. “Wedding show weekend.” “Google Ads paused for two weeks.” “Priya on holiday.” Six months later, these notes explain the bumps in the numbers.

Set thresholds before you look. For example, Lantern & Lane marks close rate as “watch” below 30 percent and “act” below 20 percent, and response time as “act” if the median goes above four business hours.

Make the CRM do the work

A dashboard is only as good as the records behind it. Most of the ten numbers come from the CRM, so set it up to produce them without extra effort.

• Required fields. Source, detail, event date, guest count, quoted value and outcome on every lead. A lead cannot move to the next stage until they are filled in.
• Dated stages. Record the date of inquiry, first response, consultation, quote and booking. Response time and the length of your sales cycle then calculate themselves.
• One saved report per measure. Build each report once, such as “bookings by source, last month”, and save it. The monthly update becomes a matter of opening six reports and copying the totals.
• Lost reasons. When a lead does not book, choose a reason from a short list: price, date unavailable, chose another vendor, no response, not a fit. After a season, the pattern tells you whether you have a marketing problem or a sales problem.

If you are still on a spreadsheet instead of a CRM, the same fields work as columns. The discipline matters more than the software.

Worked example: Lantern & Lane in November

The calculations:

• Close rate: 5 bookings divided by 18 inquiries is about 28 percent, which is in the “watch” band.
• Average booking value: $29,500 divided by 5 equals $5,900, below the $6,500 average in the studio’s plan.
• Blended cost per booking: $1,150 divided by 5 equals $230.
• Pipeline: 9 open quotes worth $54,000 in total. At a 30 percent close rate, the expected value is $16,200.

What Priya and Marco decided: response time is far better than last year, so the new inquiry routine is working. Close rate and average booking value are both slightly down, and the notes show more small milestone parties from Meta ads. They kept the ads but added a minimum guest count question to the lead form, and Priya rewrote the party proposal to show the mid-tier package first.

The monthly 30-minute review

Put it in the calendar for the same morning each month. Work through five questions.

1. Which measures are in “act”, and what is the likely cause?
2. How does this month compare with the same month last year, not just last month?
3. Which source produced the most bookings, and which produced the most spend?
4. Is the pipeline big enough for the bookings we need in the next three months?
5. What one change will we make this month, and how will we know if it worked?

Write the answer to the last question in the notes tab. Next month, start by checking it.

Traps to avoid

• Month-on-month panic. Event businesses are seasonal. February will look better than August for wedding inquiries every year. Compare like with like.
• Precision theatre. A dashboard that takes a day to update will stop being updated. Round numbers, simple formulas, done.
• Counting what is easy. Followers and visits are easy to count. Bookings by source are the hard, valuable work.

In Canada and the GTA

Read the numbers against the Ontario year. Comparing a month with the same month last year matters more in the event industry than in most. In the GTA, wedding inquiries rise sharply from late December to March, after the holiday engagement season and around the wedding show calendar. Corporate holiday party inquiries build from late August and peak in September and October. Summer is busy with delivery and slower for new inquiries for many planners, while caterers, food trucks and rental companies may see their own peaks with festivals, graduations and backyard events. A good dashboard shows a full rolling year so these patterns are visible, and your targets should follow them month by month instead of being one annual number divided by twelve.

Communities whose celebrations follow lunar or lunisolar calendars shift those peaks each year, so a caterer or decorator serving Diwali, Lunar New Year or Eid celebrations should note the dates in the dashboard’s notes tab so year-on-year comparisons make sense.

Tax, privacy and benchmarks

Revenue before HST. Record booked revenue before the 13 percent HST. Including tax inflates average booking value and every ratio built on it.

The small supplier line. If you are not yet registered for GST/HST, add one row to the data tab: taxable revenue for each calendar quarter, and the total for the last four quarters. Under the CRA’s rules, you remain a small supplier only while your worldwide taxable supplies, including those of associates, are $30,000 or less in any single calendar quarter and over the last four consecutive calendar quarters. Exceed $30,000 in a single quarter and you stop being a small supplier immediately and must register within 29 days. A dashboard that shows the rolling total gives you warning before a busy season pushes you past the line. The details are in the CRA’s guide RC4022.

Privacy and sharing. A dashboard should show totals, not people. Aggregated monthly numbers are not personal information in the way your CRM records are, which makes the dashboard safe to share with a business partner, an accountant, a marketing contractor or a lender. Keep client names, phone numbers and event addresses in the CRM, where access is controlled. If you give a contractor access to the CRM itself, PIPEDA’s accountability principle means you remain responsible for that information, so limit their access to what the work needs and remove it when the work ends. The OPC’s summary of PIPEDA lists the ten fair information principles.

Local benchmarks. New owners often want to know what “good” looks like in the GTA. Published industry averages for small event businesses are scarce and rarely comparable, because close rates and booking values vary widely by vendor type, niche and price point. Your own history is the best benchmark you have. After one full year of clean dashboard data, you will know your normal for every month, and that is worth more than any average from a survey.

Seasonal businesses should also expect their own year to differ from a neighbour’s. A wedding photographer in Niagara wine country, a corporate caterer near the downtown core and a food truck working summer festivals across Peel will each have a different calendar, even in the same region. Build targets from your own past bookings, not from another vendor’s busy months.

Accessibility deadline for larger teams. If your business has grown to 20 or more employees in Ontario, add a compliance row as well: organizations of that size must file an accessibility compliance report every three years, and the current deadline is December 31, 2026.

This is general information, not legal or tax advice. Check the source, your accountant or a lawyer for your situation.

Worksheet

Download the worksheet and complete it for your own business, using Lantern & Lane as the model where it helps. Keep it with your marketing plan. It takes about 10 minutes.

Download the worksheet (PDF)