Spreadsheets
Location website audit sheet for franchise networks
A spreadsheet for corporate to check every location's website by hand, one row per location, and see which ones need attention first.
Download location-website-audit.xlsxFranchise websites drift one location at a time. A phone number changes, a booking link breaks, a holiday banner stays up into spring. Nobody notices until a customer does. This sheet is for checking every location on a schedule, by hand, the way a customer would.
Open each location's site on a phone and work across the row. Does the phone number match? Are today's hours shown? Does the booking link work? Does the form send, and does someone reply? Mark each check Yes, No or Fix, add the date and your name, and write what needs fixing in the notes. The bottom row counts the locations needing a fix for each check, so you can see where to start.
If your network runs on Brandyland, its health dashboard already lists stale hours, holidays not set and inquiries left waiting for every location, worst first. The rest of this sheet is still worth a pass each quarter.
What is in the file
One row per location, with columns for the location, website address, phone matches our list, today's hours shown, holiday hours set, schedule page works, booking link works, inquiry form works, photos current, no old notices (such as COVID rules or past events), tap to call works on a phone, last checked, checked by and notes. Each check is Yes, No or Fix from a drop-down. The bottom row counts the locations needing a fix for each check. Room for 250 locations, with one example row to delete.
Download location-website-audit.xlsxAn Excel file. It opens in Excel, Google Sheets and Numbers. No sign-up, no email.
Questions
Questions people ask
How often should we audit location websites?
The full sheet every quarter, and the hours and notices before each major holiday. Check a new location in its first month, too.
Why check by hand when there are tools for this?
Tools can find broken links and slow pages. They cannot tell you whether the phone gets answered, whether the hours are true, or whether a photo shows a room that was remodeled last year. A person on a phone can.
What counts as an old notice?
Anything that has passed or no longer applies: COVID rules, last season's camp, a weather closure, a special that ended. If it would confuse a first-time visitor today, it comes down.
Who should do the audit?
Someone at corporate who did not build the sites, working from a phone. Share each location's row with its owner and agree on a date for the fixes.
Want this done for every location, automatically?
Brandyland runs the website, the replies and the reminders for every location of a franchise. Leave your email and a person replies within a day.