Connectors

/

Harvest

/

Analyze Harvest team utilization
Report

See who is stretched and who has capacity in Harvest

For operations leads who want utilization and billable ratio per person, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Analyze Harvest team utilization
Analyze team utilization in Harvest for October and tell me who could take on more work.
Utilization for October ranges from 52 to 112 percent across the team. - Over 100 percent: Priya Shah at 112 percent, assigned to the Northwind Traders rollout and Fabrikam support - Under 60 percent: Tom Reyes at 52 percent, billable ratio 44 percent - Contractors: Sam Patel is reported separately Want the full table sorted by utilization?
Harvest
Sample figures. Your results come from your own account.
harvest-get-time-reports-team
harvest-get-project-user-assignments

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Harvest

Harvest
Run it on your own Harvest data.

Connect Harvest, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Capacity questions end up in a spreadsheet

Finding who is overloaded means exporting hours, working out capacity for the period and dividing by hand. Then each outlier needs another look to see which projects they are on.

Without PopdockAI

  • Export the team time report
  • Calculate capacity and utilization in a spreadsheet
  • Separate contractors by hand
  • Look up assignments for each outlier

With PopdockAI

  • Hours are compared with capacity for the period
  • Contractors are reported separately
  • Over and under-used people are flagged with assignments
  • Rates are never shown

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Report utilization per person from `{period-start}` (default: first of this month) to `{period-end}` (default: today).

**Step 1: Hours**

Call `harvest-get-time-reports-team` with `period-start` and `period-end`. Use `total-hours`, `billable-hours` and `weekly-capacity`.

**Step 2: Compute**

* Capacity for the period = `weekly-capacity` x weeks in the period.
* Utilization = `total-hours` / capacity.
* Billable ratio = `billable-hours` / `total-hours`.
Report contractors separately.

**Step 3: Explain the extremes**

For the two highest and two lowest, call `harvest-get-project-user-assignments` with `user-name` and `active` true to show what they are assigned to.

**Step 4: Report**

Table sorted by utilization with flags: over 100 percent (burnout risk), under 60 percent (capacity available), billable ratio under 50 percent. End with who could take on more work.

**Rules & Guidelines:**

* This is a read-only job. Never call any Action tool (any tool whose name ends in create, update, delete, restart, stop or create-from-tracked-time).
* Never show cost rates or hourly rates.

**Validation:**

* If `weekly-capacity` is empty for a person, report hours only for them.

Who it's for

One answer, three teams that use it

Operations managers

Spot burnout risk early

See who is logging more than their capacity for the period and what they are assigned to, so work can be moved in time.

Who in the team was over 100 percent utilization in Harvest last month?

Resource planners

Find room for new work

List people under 60 percent utilization with their current assignments, so new projects go to those with space.

Who has spare capacity in Harvest this month and what are they assigned to?

Department heads

Check the billable ratio

See who spends less than half their hours on billable work, with contractors reported on their own line.

Which people had a billable ratio below 50 percent this quarter in Harvest?

How it works

What PopdockAI does when you ask

You name the period. Your AI assistant reads the team hours and project assignments in Harvest, does the calculations and reports. Nothing is changed.

Ask

You give a period, or accept the first of this month to today.

Your AI tool

Calculate

It compares logged and billable hours with capacity for the period, with contractors kept apart.

harvest-get-time-reports-team
harvest-get-project-user-assignments

Explain

It looks up the assignments of the two highest and two lowest people.

No items found.

Report

You get a table with flags and a note on who could take more work.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Harvest and one secure connection to your AI tool. No code, no exports.

get-data

harvest-get-time-reports-team

Returns time reports by team from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
get-data

harvest-get-project-user-assignments

Returns project user assignments from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
Read only.Nothing in Harvest Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

Workload balance you can act on

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation