Multi-location marketing reporting: what to put on the dashboard

A multi-location marketing dashboard should show, for every location, how many extra customers your ads brought in, what each one cost, and what to do about it. Everything else is supporting detail. Most dashboards get this backwards: twenty platform metrics up top, and the location view buried on page four, if it exists at all.

It matters because dashboards don’t decide anything on their own. In a Gartner survey of 377 marketing-analytics users, analytics influenced just 53% of marketing decisions, and a third of respondents said decision makers cherry-pick data to support what they already think (Source: Gartner, 2022). A dashboard built around a decision, rather than around whatever data happened to be lying around, is how you win back some of the other 47%.

What to put on a multi-location marketing dashboard

Seven numbers per location, in this order:

1. Spend. Media spend for the location’s market, all channels, with agency fees if you want the true cost.
2. Customers. The count the location manages to: guests, members, new patients, booked jobs. From the POS, booking or practice-management system, never from the ad platforms.
3. Expected customers. What the location would have done without the ads, from a weighted twin of comparable locations where spend held steady.
4. Extra customers. Customers minus expected, with a 95% range. No range, no number.
5. Cost per extra customer. Spend ÷ extra customers. The one number your CFO will remember. Our guide to cost per incremental customer covers how to work it out properly.
6. Value per customer. Contribution margin per customer, or first-year value if you trust it. It turns the cost into a yes or no.
7. Status. “Proven”, “Not yet proven” or “Below plan”. In words, not just a colour.

Above the rows go four headline tiles for the region or brand: spend, extra customers, cost per extra customer against target, and how many locations are proven. Below them goes the most important part, which most dashboards leave out: the suggested budget moves.

What to leave off the main page

Impressions, reach, CTR, CPC, platform-reported conversions and ROAS all have a home: the media team’s working view. They’re how you tune creative, bids and audiences. They aren’t evidence that a location got more customers, and when they sit next to location results, people compare them as if they were. Platform conversions are the riskiest, because each platform counts the people it can link to its own ads, and the totals overlap. More on that in why click attribution misses in-store sales.

Also off: single-week location rankings, vanity totals (“4.2 million impressions!”), and any metric nobody has a decision attached to. If you can’t say what you’d do differently when a number moves, cut it.

One dashboard, three readers

Marketing reporting for a multi-location brand serves three groups, and they want different cuts of the same numbers.

Build one data model and three views, not three dashboards with three definitions of “customer”. Agencies running local media for several brands have the same problem multiplied; our guide to agency reporting for local ad results covers that case.

A worked example: one region’s scoreboard

This example is illustrative. A 24-club fitness brand runs a regional paid social program in one region’s six clubs, at $30,000 for March. Each club’s twin is a weighted blend of clubs in markets without the program, so spend ÷ extra members is a fair cost. The outcome is new memberships. A new member is worth about $160 in contribution over their first year, so anything under $160 per extra member pays back within the year.

Read it the way an operator would. The region is proven: 160 extra members, with a range well clear of zero. But at $188 each, it costs more than the $160 a member is worth. Three clubs (A, C and E) carry the result at $125 to $150 each. B got as much spend as A and shows almost nothing. F shows nothing at all.

Note that the region’s range (102 to 218) is narrower than you’d get by adding up the club ranges. Ranges don’t add; noise at one club partly cancels noise at another. That’s also why a region can be proven while half its clubs aren’t yet.

Turning the scoreboard into a budget move

The move is to shift $3,000 from B to A and $3,000 from F to E. Assume A and E’s next dollars cost more than their averages, say $160 per extra member: $6,000 ÷ $160 ≈ 37 more members. Cutting B by half loses about 6 (at its $500 rate), and F loses roughly nothing. Net: about +31 members a month for the same $30,000, which brings the region to around 191 extra members at about $157 each. Under target.

The dashboard should say that, not leave it to whoever happens to read it: “Move $3,000 from Club B to Club A and $3,000 from Club F to Club E. Expected effect: about +31 members a month. Re-read in six weeks.” For contrast, the platform report for the same month showed 640 leads at $47 each, spread fairly evenly across all six clubs. It would have told you to change nothing.

Design rules that keep a dashboard honest

• Show a range every time you show a lift. A number without one invites people to rank noise.
• Use four to eight weeks for location reads. A single week at a single location is mostly weather.
• Write statuses in words. “Not yet proven” reads differently from a red cell, and colour-blind readers will thank you.
• Put definitions on the page. What counts as a customer, which spend is included, which weeks. One line each.
• Fix the location-to-market mapping. Every location belongs to one market for spend purposes. Write it down and don’t change it mid-quarter.
• Separate the exceptions. New locations in their opening ramp, remodels and closures go in their own section. See how to measure a grand opening for why.
• Date-stamp everything. “Data through Sunday 4 October” heads off half of all dashboard arguments.

Where the numbers come from

You need three feeds, and you already have most of them:

• Customers by location, by day or week. From the POS (Toast, Square, NCR), the booking system (Mindbody, ABC Fitness), practice-management software (Dentrix, Open Dental) or field-service software (ServiceTitan).
• Spend by market and channel. From Meta Ads, Google Ads and whatever else you buy, plus invoices for radio, billboards, direct mail and CTV.
• A location calendar. Openings, closures, remodels, price changes and local promotions.

The mapping is where most projects stall. Ad platforms report by campaign and geography; the POS reports by store ID. Someone has to own the table that ties each store to a market and each campaign to a set of markets. Do that first, before anyone opens a dashboard tool.

How often to send multi-location marketing reports

Weekly for operators and the media team, monthly for leadership, quarterly for planning. Weekly reports should flag changes rather than restate everything: which locations changed status, which budget moves are waiting for approval. Monthly reports carry the roll-up, the ranges and the return against target. Quarterly is where you revisit targets and plan tests. If finance is the audience, our guide on how to prove marketing ROI to a CFO covers the format.

Budgets make the cadence matter more. Marketing budgets held flat at 7.7% of company revenue in 2025, and 59% of CMOs said they didn’t have enough to execute their strategy (Source: Gartner CMO Spend Survey, 2025). When the pot doesn’t grow, moving money is the main lever you have, and the dashboard has to show where to move it.

Common mistakes in multi-location marketing reporting

• Leading with platform metrics. The first screen sets the conversation. Make it customers at locations.
• Ranking locations on one week. Last week’s winner is usually this week’s loser. Use a longer window and show ranges.
• Hiding the range. It gets left off because it looks uncertain. It is uncertain. Showing it is what makes the rest believable.
• Mixing new and mature locations. An opening ramp makes any channel look brilliant. Report openings separately.
• Three definitions of a customer. Marketing counts leads, ops counts visits, finance counts revenue. Pick one outcome per business and write it down.
• No action line. A dashboard that doesn’t end in a decision is a report card.
• Too many tabs. If your scoreboard needs a training session, it’s too complicated.

Questions people ask about multi-location marketing reporting

Build the dashboard around the decision. If a number on it can’t change where the money goes next month, move it to a tab.

Written by The Countlift team at First Byte in The Woodlands, Texas. Questions or corrections? Email hello@countlift.com.