The short answer
Give each franchisee one row: Search Console clicks to their location page, GA4 conversions from visits that started there, and the change since the period before. Label who paid for each number. Report a national ad account once for the whole system, because it cannot be split by location, and keep local spend in its own section.
- The disclosure document covers where fund money goes; your report shows what it produced.
- Judge a small territory on rates and per-household figures, never on raw clicks alone.
- Save every quarter's table; rolling windows cannot rebuild old quarters.
A quarterly fund report outline, location by location
Franchisees skip the marketing deck. They scroll to their own town, read one number and decide whether the fund works for them. So give each location one row, with the same columns in the same order every quarter.
This outline assumes one domain with a page per location, such as /locations/hollybank: a common setup, and the hardest to report fairly.
- The window. "The 90 days to September 30" beats "Q3", because the agent reads rolling windows, not calendar quarters.
- A system line. Fund work no territory owns: the brand ad account, the homepage, the store locator.
- The location row. Search Console clicks to the page, GA4 conversions from visits that began on it, and the change on the prior 90 days.
- A size column. Households per territory, from your own territory file.
- Local spend, fenced off. A franchisee's own ad accounts, where linked, under "paid locally".
- One action per location. What the fund will change on that page next quarter, written by a person.
- A definitions box. Identical wording every quarter, so nobody can say the goalposts moved.
Ask your agentFor every Lumen Lawn Care location page, give me Search Console clicks and GA4 conversions over the last 90 days.
Tools it calls list_websites get_search_console_pages get_ga4_landing_pages
Copy these terms into the definitions box once and never reword them.
- Search Console click
- Google counts "any click that sends the user to a page outside of Google Search, Discover, or News."
- Landing page
- In GA4, "the page path associated with the first page view in a session." A visit that reaches Hollybank through the store locator belongs to the homepage.
- Conversions
- DuckDive's word for GA4 key events: events that measure "an action that's particularly important to the success of your business," such as a quote request.
- Prior 90 days
- The last 6 months minus the last 90 days. It runs a few days longer than 90, so label it approximate.
- Territory households
- Your count from each territory map. DuckDive does not hold it; you paste it in.
What the disclosure document says about the fund
Not legal advice
Your franchise counsel owns the disclosure document. This section only reports what the FTC's guide says Item 11 covers. Quote your own document on the report; never paraphrase it.
Item 11 of the franchise disclosure document covers the franchisor's assistance, including advertising. The FTC's Franchise Rule Compliance Guide (May 2008) says that disclosure includes whether the franchisor must advertise, the media used, and the geographic scope, "local, regional, or national." For any fund a franchisee must pay into, franchisors disclose:
- who contributes, and whether franchisor-owned outlets contribute on the same basis as franchisees;
- who administers the fund, and whether it is audited;
- whether its financial statements are available for review;
- whether franchisees receive "a periodic accounting of fund expenditures";
- the share, if any, "used principally to solicit new franchise sales";
- how the fund was spent in the last fiscal year, as percentages for production, media placement, administrative expenses and other uses.
The rule text itself, 16 CFR 436.5, also asks whether the franchisor must spend any amount on advertising in the franchisee's area or territory.
Notice what that list measures: money in and money out. None of it says what the spending produced in Hollybank or Pennick. A paper from the International Franchise Association's 2024 legal symposium, Marketing Funds and Local Marketing, found that most agreements its authors reviewed give franchisees some right to "a more detailed understanding" of fund spending than the "generic disclosures contained in Item 11." A results report by location moves from spending to outcomes.
Put three lines from your own document on the cover, word for word: the fund's geographic scope, whether the franchisor must spend in each territory, and the franchise sales share. They answer the commonest complaint before it is sent.
Separating fund-paid results from local spend
A franchisee running their own Local Services Ads credits every lead to that budget; the fund wants the same leads. Settle it in writing before the first report. Adjust the middle column to your agreement.
| Number | Usually paid by | Where it belongs |
|---|---|---|
| Search clicks to a location page | The fund, if it pays for the site and SEO | Location row |
| GA4 conversions on a location page | Mixed, organic and ads both land there | Location row, marked "all channels" |
| The brand's Google Ads account | The fund | System line only |
| A franchisee's own LSA account | The franchisee | Paid locally section, where linked |
| A franchisee's own Google Ads account | The franchisee | Paid locally section, where linked |
| Homepage and store locator visits | The fund | System line |
| Franchise opportunity pages | The disclosed franchise sales share | Leave out of location results |
The mixed row needs explaining. get_ga4_landing_pages returns sessions, conversions and conversion rate per landing page, with no channel split; get_ga4_channels splits channels for the whole site only. So local ad visits to a location page share its row with organic ones. The fix: send local ads to their own path, such as /locations/pennick/offer. GA4's landing page is the path, so a query string tag alone will not give that traffic its own row.
One account, one number
get_google_ads_summary returns spend, clicks, impressions, conversions and cost per conversion for a website's linked account, with no campaign or location breakdown. One national account cannot be split by territory in DuckDive; report it once. More on Google Ads results in your agent.
Ask your agentFor each Lumen location with its own Local Services Ads account linked, list leads, charged leads and spend for the last 90 days under a "paid locally" heading.
Tools it calls list_websites get_lsa_summary
Worked example: a quarter for twenty-two franchisees
Lumen Lawn Care is a fictional brand: twenty-two franchised territories on one domain. The fund pays for the site, its SEO and a brand Google Ads account; franchisees pay for local ads. On October 1 the director asks for the quarter.
Build this quarter's fund table: every Lumen location page, its Search Console clicks for the last 90 days, the change on the 90 before, and GA4 conversions. Flag anything that needs a note.
list_websitesfinds Lumen Lawn Care, one website because it is one domainget_search_console_pageslast 90 days, 100 rows, keeping paths under /locations/get_search_console_pageslast 6 months, to find the earlier period by subtractionget_ga4_landing_pageslast 90 days, conversions per location pathget_google_ads_summarythe brand account, last 90 days, for the system line
The 22 location pages drew 14,513 Search Console clicks in the 90 days to September 30, up 10.5% on the period before (13,130). Those figures count Rookwood's new path only; with its old path added, the total is 14,654 and the rise 11.6%. Twenty-one grew, and Rookwood is flat once both paths are counted. GA4 counted 971 conversions from visits that started on them. Below, Conv. is GA4 conversions and Change is clicks against the prior 90 days.
| Location | Clicks | Change | Conv. |
|---|---|---|---|
| Pennick | 1,310 | +11% | 92 |
| Garnet Ridge | 1,166 | +14% | 88 |
| Bracken Row | 1,021 | +13% | 77 |
| Kestrel Point | 954 | +10% | 41 |
| Elmstead | 873 | +12% | 64 |
| Merriton | 812 | +12% | 58 |
| Pell Harbor | 781 | +13% | 53 |
| Abbotsleigh | 742 | +16% | 51 |
| Halloway | 688 | +13% | 47 |
| Northcote | 633 | +13% | 44 |
| Rookwood | 623 | -18% | 39 |
| Selsdon Rise | 612 | +13% | 40 |
| Cotterfield | 560 | +9% | 38 |
| Corriemoor | 529 | +10% | 35 |
| Tamsin Grove | 519 | +14% | 33 |
| Dunmere | 497 | +16% | 31 |
| Lanyard | 463 | +13% | 29 |
| Wickhurst | 437 | +14% | 27 |
| Farrowgate | 402 | +15% | 22 |
| Quenby | 348 | +5% | 23 |
| Ivy Mill | 331 | +12% | 20 |
| Hollybank | 212 | +4% | 19 |
| Total (new Rookwood path) | 14,513 | +10.5% | 971 |
Rookwood's 18% fall is mostly an artifact. Its old path, /locations/rookwood-lawn, still drew 141 clicks after the August URL change. Combined, 764 against 760: flat.
Kestrel Point converts poorly. 41 conversions on 954 clicks, against 64 at Elmstead on fewer. Test its quote form.
Hollybank and Quenby gained least, 9 and 18 clicks. Both are small; judge them per household.
System line: the brand Google Ads account spent $41,300 for 1,268 conversions ($32.57 each), system-wide. It stays off the location rows.
Notice the Rookwood catch. A URL change splits one page across two rows, and a naive table hands a franchisee their worst quarter when nothing happened. Ask this follow-up every quarter and read the whole list.
Ask your agentWhich location pages gained the fewest Search Console clicks in the last 90 days compared with the 90 before?
Tools it calls list_websites get_search_console_pages
Two limits shape this method. Each page call returns at most 100 rows ranked by clicks, so a quiet location page on a site with a busy blog can drop off. And the agent reads fixed windows from 7 days to 12 months, never custom dates.
Ask your agentWhich of the 22 Lumen paths under /locations/ are missing from the top 100 Search Console pages or GA4 landing pages for the last 90 days? Mark them "not in list", not zero.
Tools it calls get_search_console_pages get_ga4_landing_pages
Build your own location table before the next fund meeting
Link the brand site's GA4 property and Search Console site, then ask for every location page's clicks and conversions in one go.
Free for 2 sites · No credit card
Answering the franchisee who says the fund ignores them
The email tends to land the week contributions come out: "I pay the same rate as Pennick and get nothing." Treat it as a data request. The IFA paper lists claims that a franchisor "failed to provide adequate advertising" among recurring fund disputes; a fast, specific reply keeps a complaint from becoming one. Five parts, in order:
- Restate the deal. Quote the document's line on the fund's geographic scope.
- Give their numbers. Same window and definitions as every location.
- Compare fairly. Rates and per-household figures, not raw clicks against the biggest market.
- Commit to one change the fund will make to their page next quarter.
- Promise the follow-up: the same numbers in 90 days.
Draft a reply to the Hollybank franchisee who says the fund ignores their territory, using their last 90 days of data.
list_websitesfinds the Lumen Lawn Care websiteget_search_console_pageslast 90 days and last 6 months, for Hollybank's clicks and changeget_ga4_landing_pageslast 90 days, sessions, conversions and rate per location pageget_search_console_keywordslast 90 days, top queries naming Hollybank or its villages
Draft for your review:
Hi Marisol, fair question. Here is what the brand fund produced for Hollybank in the 90 days to September 30, measured the same way as all 22 locations.
Your page drew 212 clicks from Google search, 9 more than the 90 days before. 268 visits started there and 19 became quote requests. That 7.1% rate is the best of any Lumen page, so people who find you act.
The weak spot is reach. Thistlecombe and Oxlade sit inside your territory but do not appear among the site's top searches. Next quarter the fund will add both villages to your page, and I will send these numbers again in January so you can judge the change.
The agent drafts; a person sends, after matching each figure to the quarter's table and clearing the commitment with the web team. See checking your AI agent's marketing numbers for spot checks. If the real complaint is a quiet phone, use the method for finding which locations lost calls.
Worked example: two territories with very different search demand
Hollybank and Pennick pay the same rate. Pennick is a commuter suburb; Hollybank is a market town ringed by farms. Raw clicks will always favour Pennick, so the director brings territory sizes.
Put the Hollybank and Pennick location pages side by side for the last 90 days. Hollybank's territory has 9,400 households and Pennick's has 41,000, so adjust for size. Is Hollybank behind on demand, on visibility, or on the page itself?
list_websitesfinds the Lumen Lawn Care websiteget_search_console_pageslast 90 days, clicks to both location pagesget_ga4_landing_pageslast 90 days, sessions, conversions and rate on both pagesget_search_console_keywordslast 90 days, top queries, filtered for each town's name
Hollybank's page converts better than Pennick's. Its gap is reach: about 29% fewer clicks per 1,000 households.
| Measure, last 90 days | Hollybank | Pennick |
|---|---|---|
| Territory households (your file) | 9,400 | 41,000 |
| Search Console clicks to page | 212 | 1,310 |
| Clicks per 1,000 households | 22.6 | 32.0 |
| Sessions starting on page | 268 | 1,540 |
| Conversions from those sessions | 19 | 92 |
| Conversion rate | 7.1% | 6.0% |
| Clicks on top queries naming the town | 64 | 402 |
Part of the gap is demand the fund cannot create: fewer households, fewer searches naming Hollybank. Part is visibility. Among the site's top queries, three name suburbs next to Pennick; none name Hollybank's villages. Search Console data here is site-wide, so this shows which places the brand is found for, not which page answered each search. Adding the villages to Hollybank's page is content work, and the fund already pays for it.
Per-household figures turn a fairness argument into a shared target: close the gap per household while holding the conversion rate. Paste every territory's household count and the agent ranks all 22 pages the same way.
One caution: the keyword tool returns the site's top 100 queries by clicks, so small-town searches can fall below the cut. Read "no village queries" as "none big enough to list".
Keeping the report consistent quarter to quarter
A fund report earns trust by being boring: same pages, same windows, same wording, bad quarters included. Most disputes start with something that quietly changed between editions.
Before each quarter's report goes out
- Same run day. The first business day after quarter end, so the 90-day window tracks the quarter closely.
- Fully imported data. Run
get_sync_statusthe morning of the pull; a half-imported GA4 property makes every territory look as if it fell off a cliff in the same week. - Frozen page list. New locations join at the bottom, marked new, with no change figure yet.
- Logged site changes. URL moves, redesigns and new quote forms get a footnote on their rows.
- Saved tables. Rolling windows cannot rebuild a past calendar quarter for a page; your saved copies are the history.
- Versioned household file. Note redrawn territories, or per-household figures jump for no reason.
- Named owners. Each action line belongs to a person on the marketing team.
Ask your agentBefore I pull Lumen's quarter, confirm the brand site's Search Console and GA4 data are up to date and that nothing is importing or failing.
Tools it calls list_websites get_sync_status
If each franchisee has a separate website instead, each becomes its own DuckDive website with its own GA4, Search Console and ad accounts, and comparisons get cleaner. The weekly routine for people who run dozens of websites suits that setup.
Franchisee pushback, answered
- "Pennick wins because it is bigger." Agreed, so the report shows clicks per 1,000 households beside raw clicks.
- "My leads come from my own ads." Some do. That spend has its own section and the fund does not claim it.
- "Clicks are not customers." True, so conversions sit beside them, defined as quote requests, not booked jobs.
- "You only show good quarters." The Rookwood footnote proves the awkward rows go out too.
- "What about the radio money?" Google data cannot see it, and the cover says so.
Connecting the brand site and location accounts
DuckDive imports the brand site's Google data, stores it, and lets the AI agent you already use read it. For a fund report, one question returns every location's row, and the same numbers are there when a franchisee writes in. The multi-location overview covers the rest.
-
Use the Google account your web agency or IT team granted
Marketing directors rarely own the brand GA4 property themselves. Before signing up, check that the address you use for the fund deck already has access to that property and to the Search Console site; if not, ask whoever built the site to add it.
-
Add the brand domain, not each territory
Hollybank, Pennick and the other twenty are paths on that domain, so the location rows come from page-level data.
-
Link GA4 and Search Console, plus ads where the brand runs them
Link the GA4 property and Search Console site, and the Google Ads and Local Services Ads accounts if the brand runs them. Importing that history usually takes a few minutes.
-
Hook the marketing team's Claude or ChatGPT up to the fund data
In Claude or ChatGPT, open the connectors or apps menu (the label differs between apps and versions), add
https://api.duckdive.ai/mcpas a custom connector, and approve it with Google. There is no API key for anyone to store. On ChatGPT this needs a Business or Enterprise workspace; Claude accepts it on every plan (Claude setup guide). If you would rather the assistant handled the steps, give it this line:
Hand this line to your agentSet up DuckDive for my website. Follow https://analytics.duckdive.ai/
agents.md -
Pull the first table as quarter zero
Once GA4 and Search Console show as ready, run the location prompt from the top of this guide. File that output as the starting point every later fund report is measured from.
What this report cannot show a franchisee
A report that overclaims loses the room the first time a franchisee spots it.
- No fund ledger. Spending percentages come from your books, not DuckDive.
- No split of a national ad account. Google Ads arrives as an account total.
- No offline media or revenue. Radio, print and booked jobs never reach Google data.
- No Business Profile data. It is not a DuckDive source.
- No custom dates or alerts. Windows run from 7 days to 12 months.
- No franchisee logins or branded PDFs.
Some systems can skip this setup. A brand with a handful of territories can filter the Search Console Performance report by page, add GA4's landing page report, and paste both into the fund deck in an afternoon. A fund spent mostly on radio, TV or direct mail will show little in Google data whatever tool reads it. The agent route pays off when the location list runs into the dozens and franchisees ask between reports, not just at quarter end. The franchise systems page covers the wider picture.
Questions marketing directors ask before connecting
Does the disclosure document require a results report for each location?
The FTC's compliance guide lists Item 11 fund disclosures on contributions, administration, audits, financial statements, periodic accounting of spending and the franchise sales share. A per-location results report is not on that list. Your agreement may promise more; ask your counsel. This is not legal advice.
We run one website with a page for every location. Can DuckDive split it?
Yes, by page. Your agent reads Search Console clicks per page and GA4 sessions, conversions and conversion rate per landing page, up to 100 rows per call. You add the brand domain once; each /locations/ path becomes a row in the table.
Our brand runs one national Google Ads account. Can each franchisee see their share?
Not through DuckDive. It reads the whole account's spend, clicks, impressions, conversions and cost per conversion, with no campaign or location breakdown. Report it once as a system line.
Franchisees run their own Local Services Ads accounts. Can those go in the report?
Where a franchisee's account is linked to a DuckDive website, the agent reads its leads, charged leads and spend. Keep those in a paid-locally section, apart from fund results. Ask DuckDive how to attach several location accounts to one brand domain before planning columns.
Can I pull the same quarter from last year for one location page?
Not as a calendar quarter. The agent reads rolling windows from 7 days to 12 months. Save each quarter's table and compare next year's run against it.
Does the agent see franchisee or customer personal data?
The tools behind this report return counts per page or per ad account, such as clicks, sessions, conversions and spend; contracts, royalty figures and customer records are not among them. Nothing can be erased through the connector, and DuckDive is not sent the conversation itself. Once figures reach Claude or ChatGPT, that company's terms decide how they are kept, not DuckDive's.
Is it free to try?
One website is free with no card. Because the whole location network sits under the brand domain, the free site is enough to run last quarter's table on real data before anyone signs off a budget.
Sources
- Franchise Rule Compliance Guide, Federal Trade Commission (May 2008; Item 11 advertising sections on pages 65 and 66 of the PDF), checked November 16, 2026.
- 16 CFR § 436.5, Disclosure items, Legal Information Institute, Cornell Law School, checked November 16, 2026.
- Marketing Funds and Local Marketing: Dos and Don'ts to Promote System Harmony while Promoting the Brand, International Franchise Association 56th Annual Legal Symposium (May 2024), checked November 16, 2026.
- What are impressions, position, and clicks?, Search Console Help Center (support.google.com), checked November 16, 2026.
- Analytics dimensions and metrics, Google Analytics Help Center (support.google.com), checked November 16, 2026.
- Conversions vs. key events in Google Analytics, Google Analytics Help Center (support.google.com), checked November 16, 2026.
Last reviewed . Numbers in EXAMPLE DATA blocks are fictional.
