Two links from your Google Sheet. Paste them once and this device stays connected.
Everyone else opens the share link you copy at the end, so nobody has to do this twice.
In the sheet: File, Share, Publish to web. Pick the Leads tab, choose Comma separated values, then copy the link.
In the sheet: Extensions, Apps Script. Paste the script, Deploy as a web app, set access to Anyone, then copy the web app URL.
Anyone opening the board types this once. It is a doorstop, not a lock, so do not reuse a real password.
Send this to anyone who needs the board. It carries the settings, so they open it and it just works.
Tell them to add it to their home screen.
Connecting
Diagnostics Hide
Leads per day Last 14 days
What they are asking for
Which ads are producing
Where leads get to Tap to filter
Latest in See all
Ring now Nobody has called these yet, oldest first
Overdue You set a date and it has gone by
Due today
Coming up Next 14 days
0
Work won
0
Ad spend
0
Return on spend
0
Cost per lead
0
Cost per job won
0
Average job
Work won per month
Still to play for Nothing here is won yet
Month by month Type your ad spend in, the rest works itself out
Every job won
Ad performance Leads, wins, win rate and work won
When enquiries come in Darker means busier
Quiet Busy
Busiest areas By postcode
Budget spread
How soon they want it
How fast leads get called First move after it lands
Which forms are producing
Win rate by budget band Where the money actually is
Lead
Saved
/ search1 to 6 viewsR refreshD diagnosticsEsc close