/
/
See a Procore project's earned hours and efficiency at a glance
For project managers who want labor performance rolled up from cost code rows, by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Project labor performance means adding up dozens of rows
A field production report lists earned and actual hours by cost code, so a project view means summing every row. Efficiency and the weakest cost codes only appear after you do the arithmetic.
Without PopdockAI
- Export the field production rows
- Total budgeted, actual and earned hours
- Divide earned by actual for efficiency
- Hunt for the weakest cost codes by eye
With PopdockAI
- Rows are read for the project and the budgeted hours floor
- Totals and overall efficiency are worked out
- The three weakest and the three with most hours left are named
- Zero values are excluded from ratios, never divided by
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Summarize the labor performance of the project numbered {project-number}, using only cost codes with at least {min-budgeted-hours} budgeted hours (default 0).
**Step 1: Pull the rows**
Call procore-get-field-production-report with project-number set to {project-number}. If {min-budgeted-hours} is given, pass it as udgeted-hours.min.
**Step 2: Roll up**
* Total udgeted-hours, ctual-hours, earned-hours, emaining-hours and projected-hours-at-completion across rows.
* Overall efficiency is earned hours divided by actual hours; above 1 is ahead of plan.
* Identify the three cost codes with the lowest efficiency and the three with the highest remaining hours.
**Step 3: Report**
A short totals block, then the two top-three lists, then a one-paragraph verdict: ahead, on plan or behind, with the reason.
**Rules & Guidelines:**
* This is a read-only job. procore-get-field-production-report is the only tool; never attempt to change any Procore record.
* Quote figures exactly as returned; do not invent hours or quantities that are not in the rows.
**Validation:**
* If the read returns no rows, say so, list the filters used, and suggest loosening them.
* If a field is blank or zero (for example budgeted hours of 0), note it and exclude it from ratios instead of dividing by it.Who it's for
One answer, three teams that use it
Project managers
Know if labor is ahead or behind
Get one verdict on labor performance with the reason, before you report to the owner.
Is project 2024-205 ahead or behind on labor, and what is the reason?
Cost engineers
Find the weakest cost codes
See the three cost codes with the lowest efficiency and the three with most hours remaining.
Show the weakest cost codes by efficiency on project 2024-087, ignoring codes under 50 budgeted hours.
Operations directors
Compare a project at a glance
Get totals and overall efficiency for a project without opening the field production report.
Give me total earned and actual hours and efficiency for project 2023-412.
How it works
What PopdockAI does when you ask
You give the project number and your AI assistant rolls up the rows. Figures are quoted exactly as returned and nothing in Procore is changed.
Ask
You give the project number and optionally a minimum number of budgeted hours.
Pull
It reads the project's field production rows.
Roll up
It totals the hours, works out efficiency and finds the weakest cost codes and those with most hours left.
Report
It gives the totals, two top three lists and a verdict.
What PopdockAI provides
The tools behind the answer
Ready made tools for Procore and one secure connection to your AI tool. No code, no exports.
procore-get-field-production-report
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.
The outcome
Earned versus actual hours explained in one verdict
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.

.webp)
