Installation Compliance Analytics

Built from the AroFlo compliance form your install team fills on every job · JasonL Office Furniture

Live data. Every card below is queried straight from aroflo_compliance in BigQuery, filtered to forms submitted between the two dates above (defaults to the last calendar month). Pick an installer to narrow it further to just their jobs — a form counts for an installer whenever their name appears in "Who is in the team today", even if others are listed alongside them.
Date range to Installer

Defaults to the last calendar month. Filters every card below to forms submitted (fielddate) between these two dates, for the selected installer.

Jobs completed VOLUME
All installers
—
Unique compliance forms
Issue rate —
All installers
—
Suggested target: under 10% ·
Client sign-off rate —
All installers
—
Suggested target: 90%+ ·
Photos uploaded —
All installers
—
Suggested target: 95%+ ·
Site cleaned up —
All installers
—
Suggested target: 95%+ ·
QR code scanned by customer —
All installers
—
Target: 100% ·
Compliance Form Response

Every job counted in the card above, joined to aroflo_tasks

Task Name Status Project Manager Issue Client sign-off Photos uploaded Site cleaned up QR scanned Link
Loading…
Who's completing what

Every installer named on a compliance form in the selected date range, ranked by job count

Installer Issue rate Sign-off rate
Loading…
Issues by installer × issue type

Count of each issue type logged against each installer, filtered to jobs with an issue in the selected range · top issue types shown, columns sorted by total occurrences

Loading…
Issue types

Jobs can log more than one issue type

Loading…
Jobs by state

From the "state" column

Loading…
Jobs completed by month

Loading…

Loading…
Issue log

Every job with an issue in the selected range, newest first, with the installer's additional note

Date range to Installer Issue type

Date Order # Installer(s) Client Issue Type(s) Additional note
Loading…

This section has its own filters above — it does not use the date range or installer filter at the top of the page.