Franchise ad fund reporting: how to show franchisees what the fund did for their location

The best franchise ad fund reports give every franchisee a one-page view of their own location: what they contributed, what the fund spent in their market, what that media delivered, and how many extra customers came through their door compared with similar locations, with an honest range. Most fund reports only cover the first of those. That is why the annual fund meeting so often turns into an argument.

This guide covers what to put in a fund report, how to measure per-location lift when much of the media is regional or national, how to handle franchisee logins and data, and how to talk about locations where the numbers are weak.

A quick note before we start: this is practical guidance on reporting and measurement. It isn’t legal advice, and nothing here describes what your franchise agreement or disclosure document requires. Take those questions to your franchise counsel.

Why most ad fund reports don’t satisfy franchisees

Think about it from the owner’s side. A percentage of gross sales leaves their account every month. Once a year they get a pie chart: so much on media, so much on creative, so much on agency fees. Maybe a list of campaigns with impressions in the millions. None of it mentions their store.

The spending breakdown matters, and in the US it is part of the disclosure picture. The FTC Franchise Rule asks franchisors to describe in Item 11 how the advertising fund was used in the most recent fiscal year, including the percentages spent on production, media placement and administrative expenses (Source: FTC Franchise Rule, 16 CFR 436.5, 2007). But a spending breakdown answers “where did the money go?” The question an owner actually asks is “what did it do for me?”

When that question goes unanswered, owners fill the gap with their own evidence: a slow month, a competitor’s billboard, a cousin who never sees the ads. Franchisor marketing teams then spend the meeting defending the fund instead of improving it.

The three layers of a useful franchise ad fund report

• Layer 1: spend. Total collected, total spent, and the split between working media, production and administration. Then the part most reports skip: how much was spent in each market, so every owner can see their area’s share against their contribution.
• Layer 2: delivery. What that spend bought in each trade area: impressions, reach, search visibility, map-listing views, calls. These are platform numbers and they say nothing about cause, but they show the media actually ran where the owner operates.
• Layer 3: outcomes. Extra customers at each location compared with what similar locations did over the same weeks, with a range. This is the only layer that answers the owner’s question, and it is the hardest to produce.

You can publish layers 1 and 2 next month. Layer 3 needs some design work, which is what most of this guide is about.

How to measure per-location lift from a franchise ad fund

Measuring what advertising did at a location means comparing it with what would have happened without that advertising. For a multi-location brand the cleanest comparison is other locations: markets where spend held steady over the same weeks show what the season, the weather and the menu did on their own. Markets where spend rose show all of that plus the ads.

Here is the catch for ad funds. If the fund buys the same national media at the same weight everywhere, every location gets the same treatment, and there is nothing to compare against. You can’t measure per-location lift from a flat national buy. Anyone who says otherwise is selling platform attribution.

The good news is that most funds aren’t flat. Local digital, regional radio, co-op spend and market-level paid social vary by market already, and you can make them vary on purpose.

Rotate heavier flights across market groups

Split your markets into four matched groups of similar size and history. Each quarter, one group gets a heavier local flight (say 40% more working media) while the other three continue at the normal level. Over a year every group gets one heavy quarter, nobody goes dark, and every quarter has three steady groups to compare against. The fund spends the same total; it just spends it unevenly in a planned way.

Over time this gives you a response read for each market: how many extra customers the extra spend produced. Combined with what the fund normally spends there, you can estimate what the fund’s local media did for each location. The comparison method that works well here is a synthetic control (in plain terms, a weighted blend of steady markets that tracked the target market closely before the change). Our guide to geo holdout tests covers the design details: picking groups, length, and how big an effect you can detect.

A worked example: per-location fund results for five units

An illustrative 60-unit quick-service system. Each unit contributes 2% of gross sales to the brand fund. Average unit volume is $1.2 million, so the fund collects about $1.44 million a year (60 × $1.2M × 2%). In this example it spends 72% on working media ($1,036,800), 13% on production ($187,200) and 15% on agency and administration ($216,000).

After a year of rotation, the franchisor has a per-location read of extra customers attributable to the fund’s local media. Average ticket is $28. Here are five units:

Three things jump out. First, most units got roughly $1.30 to $1.50 of extra sales per fund dollar. Second, extra sales are not profit. If an owner’s variable margin on a sale is around a third, $1.34 of sales is roughly 45 cents of contribution, and an owner will work that out in about four seconds. Say it before they do, and explain what a 12-month customer count can’t capture: repeat visits beyond the window, brand awareness, and the cost of being invisible while competitors advertise.

Third, Unit 31. It is the biggest contributor and has the weakest read. That pattern is common: high-volume units tend to sit in dense, expensive media markets where demand is already strong. The honest message is “we can’t tell yet”, not “the fund does nothing for you” and certainly not silence.

What to put in each franchisee’s report

One page per location, every quarter. Long reports don’t get read; they get forwarded to a lawyer.

1. What you put in. Contribution for the period and year to date.
2. What was spent near you. Fund spend in the owner’s market, and the market’s share of the fund against its share of contributions.
3. What it delivered. Two or three delivery numbers for the trade area. No more.
4. What it did. Extra customers with the 95% range, and the system median for context.
5. What changed. Openings, closures, remodels or promotions nearby that affect the read.
6. What happens next. The next quarter’s plan for the market, including whether it is in a heavier rotation.

Franchisee logins, data and access

Once you produce per-location results, owners will want to see them whenever they like, not when the quarterly PDF arrives. A portal or dashboard login helps, with some rules attached.

• Own locations only. An owner sees their units and system-level benchmarks (median, quartiles). Not other owners’ named results, unless your system has agreed to that openly.
• The same numbers the franchisor sees. If the marketing team has a different version, owners will find out, and trust goes with it.
• Monthly, not weekly. Weekly lift reads at a single location are mostly noise. Showing them invites owners to react to every wobble.
• A clear data path. Per-location outcomes need daily or weekly sales or transaction counts by unit. Systems on a common POS can share them directly. Where owners run different systems, a weekly CSV export works fine. Customer-level data isn’t needed.

How to talk about weak or inconclusive locations

Some locations will show little or no measurable lift. Publish them anyway. The fastest way to destroy a reporting program is for owners to discover that bad numbers were left out.

Be precise about what an inconclusive result means. A range that crosses zero says the measurement couldn’t separate the effect from normal week-to-week swings. It doesn’t prove the media did nothing. Then say what you’ll do about it: put the market in the next heavier rotation for a cleaner read, shift the local mix, or test a different channel there. Owners can live with “we don’t know yet, and here is the plan”. They can’t live with spin.

Common mistakes in franchise ad fund reporting

• Reporting platform conversions as results. Platform-reported conversions count people who clicked, many of whom were coming anyway. Owners who compare them with their own sales will spot the gap.
• Comparing this year with last year and calling it lift. Same-store sales growth includes pricing, menu changes, the economy and the competitor that closed. It isn’t the fund’s effect.
• Only publishing system averages. The system average hides the spread, and the spread is what owners care about.
• Dropping ranges to keep it simple. A single number with no range invites false precision and, later, accusations when it moves.
• Running the same national weight everywhere and expecting a per-location read. Without variation there is nothing to compare against. Plan rotations from the start of the fund year.
• Letting the report become a legal document. Keep the performance report separate from the disclosure and accounting materials your counsel manages. Different jobs, different owners.

Questions people ask about franchise ad fund reporting

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