| name | agency-deliverables-tracker |
| description | Tracks every deliverable, deadline, and open item across marketing agency and freelancer relationships from email — what has been delivered, what is outstanding, what is overdue, and what feedback has been given. Use when a marketing team manages multiple external agencies or freelancers. Triggers on "agency deliverables", "what is the agency working on", "outstanding agency work", "freelancer deliverables", "agency status", "what do I owe the agency". |
| metadata | {"version":"1.0.0"} |
Agency Deliverables Tracker
Prerequisites
This skill needs the iGPT MCP at https://mcp.igpt.ai/.
If the MCP tools aren't available or return an auth error, tell the
user to install the iGPT plugin (/plugin marketplace add igptai/skills)
or add https://mcp.igpt.ai/ as a connector, then complete OAuth and say
"ready". Retry once after they confirm. Never invent tokens or OAuth URLs.
For deeper troubleshooting: https://raw.githubusercontent.com/igptai/skills/main/shared/mcp-guard.md
What This Skill Does
Scans all agency and freelancer email threads to extract every deliverable
that was requested or committed to — tracking what has been received, what
is outstanding, what is overdue, and what feedback loops are still open.
Workflow
-
Before calling any tool, collect these values from the user. Offer the
defaults and let the user override them; do not invent values they did
not give.
- [time_range] — what window of email to scan. The user may give this
in any form ("last 90 days", "the last 3 months", "May 2024",
"since the agency onboarded"). Default: the last 90 days. Keep
the user's natural phrasing for use in the ask input; convert to
ISO dates separately for the search call.
- [agency_scope] — either "all" (default) or the name of a specific
agency or freelancer to focus on.
- [agency_clause] — derived. When [agency_scope] is not "all", set
to " for [agency_scope]". When [agency_scope] is "all", set to
empty string.
-
Call search with:
- query: agency freelancer deliverable draft creative brief feedback
revision due submit deadline deliver
(if [agency_scope] is not "all", append the agency name to the query)
- date_from: ISO start date derived from [time_range]
- date_to: ISO end date derived from [time_range] (or today if open-ended)
-
Call ask with:
- input: Review all email threads from [time_range][agency_clause] involving marketing agencies, creative studios, and freelancers. For each agency or freelancer, extract every deliverable that was requested, scoped, or committed to. For each deliverable determine: what it is, when it was due, whether it has been delivered, whether feedback was given, and whether there are any outstanding revisions or open items in the feedback loop.
- output_format:
{
"strict": true,
"schema": {
"type": "object",
"description": "Agency deliverables tracker across all external marketing partners",
"additionalProperties": false,
"properties": {
"as_of": {
"type": "string",
"description": "ISO8601 date when this report was generated"
},
"agencies": {
"type": "array",
"description": "List of agencies and freelancers with their deliverable status",
"items": {
"type": "object",
"description": "Deliverable status for a single agency or freelancer",
"additionalProperties": false,
"properties": {
"agency_name": {
"type": "string",
"description": "Name of the agency or freelancer"
},
"agency_type": {
"type": "string",
"description": "Type of agency or external partner",
"enum": [
"creative_agency", "pr_agency", "digital_agency", "media_buyer",
"content_freelancer", "designer", "developer", "copywriter", "other"
]
},
"deliverables": {
"type": "array",
"description": "List of deliverables from this agency",
"items": {
"type": "object",
"description": "A single deliverable with status",
"additionalProperties": false,
"properties": {
"deliverable": {
"type": "string",
"description": "Description of what was requested or committed"
},
"due_date": {
"type": "string",
"description": "ISO8601 due date, empty string if not specified"
},
"status": {
"type": "string",
"description": "Current status of this deliverable",
"enum": [
"not_started", "in_progress", "submitted_awaiting_review",
"feedback_given", "in_revision", "approved", "overdue", "unknown"
]
},
"days_overdue": {
"type": "number",
"description": "Number of days past due date, 0 if not overdue"
},
"open_feedback_items": {
"type": "array",
"description": "Specific feedback points or revision requests still open",
"items": {
"type": "string",
"description": "A single open feedback item or revision request"
}
},
"blocker": {
"type": "string",
"description": "Anything blocking this deliverable from progressing, empty string if none"
}
},
"required": [
"deliverable", "due_date", "status", "days_overdue",
"open_feedback_items", "blocker"
]
}
},
"we_owe_them": {
"type": "array",
"description": "Items the marketing team owes this agency to unblock their work",
"items": {
"type": "string",
"description": "A single item owed to the agency"
}
}
},
"required": ["agency_name", "agency_type", "deliverables", "we_owe_them"]
}
},
"overdue_count": {
"type": "number",
"description": "Total number of overdue deliverables across all agencies"
},
"we_owe_count": {
"type": "number",
"description": "Total number of items the team owes to agencies that are blocking work"
},
"summary": {
"type": "string",
"description": "One or two sentence summary of overall agency deliverable status and most urgent items"
}
},
"required": ["as_of", "agencies", "overdue_count", "we_owe_count", "summary"]
}
}
-
Present overdue deliverables and items we owe agencies first. Lead with
overdue count and we_owe count.
-
Ask: "Would you like me to draft a status request or feedback email
for any agency?"
