Function Point Automated Staff Utilization Reports
Every Monday, WebRun opens Function Point, pulls each staff member's billable and total logged hours from the previous week, calculates a utilization rate, writes it to a running Google Sheets tracker, and posts your resourcing lead a Slack summary of who is over or under target.
How do I track staff utilization across the agency without building a spreadsheet every week?
WebRun pulls each staff member's billable and logged hours from Function Point every Monday, calculates a utilization rate, and appends it to a running Google Sheets tracker. It posts your resourcing lead a Slack summary flagging anyone under target for two weeks running or consistently over target, so both idle capacity and burnout risk get caught early.
- Utilization rates land in Slack every Monday without manual spreadsheet work
- Underutilized staff get flagged before it becomes a resourcing crisis
- Overworked staff get flagged before it becomes a burnout problem
Built for creative agencies · advertising agencies · resourcing managers · agency operations leads
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
hosted.functionpoint.comin a real browser with your saved login - no setup, no API keys. -
1
Function Point - pull billable and logged hours per person
functionpoint.com
WebRun opens Function Point to pull billable and logged hours per person. - Open Function Point and pull each staff member's logged hours for last week
- Split hours into billable and non billable for each person
- Calculate utilization as billable hours divided by total available hours
Done when Every staff member has a calculated utilization rate for last week.
-
2
Google Sheets - log the weekly utilization rate
google.com
WebRun opens Google Sheets to log the weekly utilization rate. - Append this week's utilization rate for each person to the running tracker
- Keep a rolling four week average alongside the latest week
Done when The utilization tracker is updated with this week's numbers.
-
3
Slack - report who is over or under target
slack.com
WebRun opens Slack to report who is over or under target. - Post the resourcing lead a summary of who is over, at, or under target utilization
- Flag anyone under target for two weeks running as a resourcing risk
- Flag anyone consistently over target as a burnout risk
Done when The resourcing lead has this week's utilization summary in Slack.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it use utilization to make staffing decisions on its own?
No. WebRun only calculates and reports the rate. Any staffing, workload, or performance decision stays with your resourcing lead and managers.
How is utilization calculated?
Billable hours logged in Function Point divided by total available hours for the week, giving a straightforward percentage per person.
Does it flag people who are overworked, not just underutilized?
Yes. Anyone consistently over target utilization is flagged too, so the report catches burnout risk, not only idle capacity.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.