/
/
See where overdue work is concentrated across Procore projects
For leaders who want open and overdue item counts ranked across their Procore projects by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Asking each project manager is slow and uneven
To see where overdue work sits you ask every project manager for a count. The replies come at different times in different shapes, so you cannot rank projects fairly.
Without PopdockAI
- Message each project manager for their overdue count
- Wait for replies in different formats
- Paste the numbers into one sheet
- Rank projects by hand and miss the quiet ones
With PopdockAI
- Open item counts are read for every project you can see
- Projects are ranked by overdue count on one basis
- Projects with work but no recent activity are flagged
- Counts follow your permissions, and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Summarize open items across projects matching `{project-name}` (default: all) and show where overdue work is concentrated.
**Step 1: Pull the counts**
* `procore-get-open-items-mine` with `project-name.contains` set to `{project-name}` when given: the connected user's own items.
* `procore-get-open-items-all` with the same filter: all items the user can see.
**Step 2: Rank**
* Rank projects by `overdue-count` and show `open-count`, `upcoming-count` and `last-activity`.
* Flag projects with open items but no `last-activity` in 30 days.
* Compare the user's own items against the total for each project.
**Step 3: Report**
A ranked table of the ten worst projects, then a line on projects with no recent activity.
**Rules & Guidelines:**
* This prompt is read-only. Do not call any write tool: Every `procore-create-*`, `procore-update-*`, `procore-delete-*`, `procore-sync-*`, `procore-add-*`, `procore-bulk-*` and `procore-send-*` tool, plus `procore-respond-*`, `procore-terminate-*`, `procore-restart-*`, `procore-refresh-*`, `procore-reset-*`, `procore-link-*` and `procore-retrieve-*`, are off limits.
* Report only values the tools returned. Do not estimate or fill gaps.
* If `{company}` is not blank, pass it as `company` on every call.
* Counts reflect only what the connected user can see. Say so in the report.
**Validation:**
* If no rows return, say so and stop.Who it's for
One answer, three teams that use it
Executives
See where to step in
Get the projects with the most overdue work ranked in one table, so the portfolio review starts with the right conversations.
Which of our projects have the most overdue open items right now?
Operations directors
Find projects gone quiet
Spot projects with open items but no activity in 30 days, before they become a surprise at the next review.
List projects with open items but no activity in the last 30 days.
Regional managers
Compare your own load to the total
See your own open items alongside everything visible to you for each project in your region.
Summarise open items for projects with Riverside in the name, and compare mine to the total.
How it works
What PopdockAI does when you ask
You say which projects to cover, or leave it open. Your AI assistant reads the counts and ranks them. It notes that figures reflect what your user can see.
Ask
You name a project, or leave it open to cover every project you can see.
Pull
It reads your own open item counts and the counts for all items visible to you.
Rank
It ranks projects by overdue count and flags open work with no activity in 30 days.
Report
You get the ten worst projects and a line on projects with no recent activity.
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-open-items-mine
procore-get-open-items-all
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
A ranked view of overdue work, without the chasing
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)
