Always Clean Maintenance
Pattison Food Group · Fall 2026 exterior program

PFG Program Dashboard

Data as of Sun 25 Oct 2026, 7:00 a.m. Source: PFG Visits sheet (crew pre-service, photos and post-service forms) 134 active stores · 4 Always Clean hubs Sample data on — 45 example visits added so the full program can be previewed. Example rows are marked.

Program highlights

The numbers Always Clean reports to PFG each round, from the Highlights tab of the dashboard sheet

Progress by hub

Fall 2026 visits against each hub's active stores, with spring audit coverage underneath

Visits completed this roundSpring 2026 audit coverage

Visits per week

Completed visits by week, Monday start · current week in green

Visit log

Click a visit for the full record

Store map

Every active store by Always Clean hub. Click a store for its record.

Visited this roundOn the Fall 2026 sheetSpring audit doneNothing yet

How the dashboard decides what PFG sees

Three questions, answered in the Rules tab of the dashboard sheet. No code changes.

What

Each piece of a visit record is a field: services, photos, certificate, walkthrough, site condition, time on site, crew name, store requests, documents, QA flags. Each field is either on or off for an audience.

When

  • Immediately — the moment the crew submits the post-service form.
  • After the certificate is received — once PFG's Digital Proof Certificate lands in the log.
  • After office review — once someone in the office ticks “Reviewed”.
  • In the Monday digest — held until the weekly summary goes out.
  • Never — internal only.

Who

Each PFG contact gets a private link tied to an audience. Head office sees the whole program; a regional manager sees their stores; a store manager sees only their store's visits. Always Clean sees everything, plus what is still being held and why.

Try it: switch “Viewing as” at the top, then change a rule in the panel. Set Before / after photos to “After office review” and tick “Reviewed” on a visit in the Always Clean view to release it.

How it goes live

Same pattern as the partnership portal: a Google Sheet, a small Apps Script, a page on our domain

1 · Crews

Pre-service, photo and post-service forms on the phone, as today. Nothing changes for the field.

2 · PFG Dashboard Data sheet

Visits sync from the crews' PFG Visits sheet every 15 minutes. Shawn and Dylan edit Program, Highlights, Rules and Contacts.

3 · Apps Script

Serves one feed per private link, applying the rules for that audience and scope. The certificate log and the office “Reviewed” tick are the release triggers.

4 · pfg.alwayscleanmaintenance.ca

This page, hosted on Netlify like the partnership site. Each PFG contact opens it with a private link; the page only ever receives the feed for their audience.

5 · Monday digest

Next: Apps Script emails PFG a one-page summary each Monday at 7 a.m. with a link back here.