Remote Marketing Project Delivery Tracker
This dataset provides granular tracking of remote marketing project delivery, capturing task completion rates, collaboration effectiveness, resource allocation, and workflow bottlenecks across distributed teams. It enables operational managers to analyze team performance, identify process inefficiencies, and optimize resource planning for marketing campaigns.
Sample rows
preview · 8 of 70 rows · all 21 columns| project_idstring | task_prioritystring | collaboration_scorefloat | bottleneck_flagboolean | rolestring | project_namestring | campaign_idstring | task_idstring | task_namestring | assigned_to_user_idstring | assigned_to_user_namestring | task_statusstring | task_created_datedate | task_due_datedate | task_completed_datedate | time_to_completion_daysfloat | commentsstring | team_idstring | team_namestring | resource_hours_allocatedfloat | resource_hours_usedfloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRJ-101 | high | 8.7 | false | designer | Spring Social Launch | CMP-2024A | TASK-1001 | Instagram Teaser Design | USR-01 | Carla Benton | completed | 2024-02-05 | 2024-02-10 | 2024-02-09 | 4 | Completed ahead of schedule. | TEAM-01 | Global Creatives | 24 | 20.5 |
| PRJ-102 | medium | 9.1 | false | copywriter | Influencer Outreach | CMP-2024A | TASK-1002 | Outreach Email Draft | USR-02 | Leonard Kim | completed | 2024-02-06 | 2024-02-13 | 2024-02-12 | 6 | Smooth collaboration with strategy team. | TEAM-02 | North America Content | 12 | 10.5 |
| PRJ-103 | critical | 7.5 | false | strategist | Spring Social Launch | CMP-2024A | TASK-1003 | Ad Copy Review | USR-03 | Priya Desai | in_progress | 2024-02-07 | 2024-02-14 | blank | blank | Awaiting stakeholder feedback. | TEAM-01 | Global Creatives | 18 | 8 |
| PRJ-104 | high | 8.2 | false | designer | Email Automation Revamp | CMP-2024B | TASK-1004 | Template Redesign | USR-04 | Megan Wu | completed | 2024-03-01 | 2024-03-05 | 2024-03-05 | 4 | Final assets delivered on time. | TEAM-03 | APAC Marketing | 20 | 19.5 |
| PRJ-105 | medium | 9.4 | false | copywriter | Podcast Launch | CMP-2024C | TASK-1005 | Landing Page Copy | USR-05 | Ethan Price | completed | 2024-03-11 | 2024-03-13 | 2024-03-13 | 2 | Excellent input from design team. | TEAM-04 | Europe Digital | 10 | 8 |
| PRJ-106 | high | 6.8 | false | strategist | Podcast Launch | CMP-2024C | TASK-1006 | Podcast Guest Sourcing | USR-06 | Sofia Almeida | in_progress | 2024-03-12 | 2024-03-17 | blank | blank | Initial outreach in progress. | TEAM-04 | Europe Digital | 15 | 7.5 |
| PRJ-107 | critical | 5.9 | true | strategist | Spring Social Launch | CMP-2024A | TASK-1007 | Facebook Ad Targeting | USR-07 | Daniel Novak | completed | 2024-02-08 | 2024-02-12 | 2024-02-13 | 5 | Delay due to ad policy changes. | TEAM-01 | Global Creatives | 22 | 24.2 |
| PRJ-108 | medium | 7.2 | false | strategist | Influencer Outreach | CMP-2024A | TASK-1008 | Influencer List Compilation | USR-08 | Olivia Chang | on_hold | 2024-02-07 | 2024-02-18 | blank | blank | Waiting for updated influencer database. | TEAM-02 | North America Content | 16 | 8.1 |
| PRJ-109 | high | 8.5 | false | strategist | Email Automation Revamp | CMP-2024B | TASK-1009 | Workflow Setup | USR-09 | Lucas Ford | completed | 2024-03-02 | 2024-03-07 | 2024-03-06 | 4 | All triggers tested successfully. | TEAM-03 | APAC Marketing | 22 | 21.7 |
| PRJ-110 | medium | 9.2 | false | designer | Podcast Launch | CMP-2024C | TASK-1010 | Audio Editing | USR-10 | Hugo Moretti | completed | 2024-03-13 | 2024-03-15 | 2024-03-15 | 2 | Audio mastered and uploaded. | TEAM-04 | Europe Digital | 16 | 14 |
| PRJ-111 | low | 8 | false | strategist | Spring Social Launch | CMP-2024A | TASK-1011 | Hashtag Strategy | USR-01 | Carla Benton | completed | 2024-02-08 | 2024-02-13 | 2024-02-11 | 3 | Final list shared with copy team. | TEAM-01 | Global Creatives | 8 | 7.5 |
| PRJ-112 | critical | 7.8 | false | copywriter | Influencer Outreach | CMP-2024A | TASK-1012 | Instagram DM Outreach | USR-02 | Leonard Kim | not_started | 2024-02-10 | 2024-02-17 | blank | blank | Task scheduled for next week. | TEAM-02 | North America Content | 12 | 0 |
| PRJ-113 | high | 8.1 | false | strategist | Email Automation Revamp | CMP-2024B | TASK-1013 | A/B Testing | USR-11 | Miho Takeda | in_progress | 2024-03-03 | 2024-03-09 | blank | blank | Initial test segments set up. | TEAM-03 | APAC Marketing | 18 | 9 |
| PRJ-114 | medium | 9 | false | designer | Podcast Launch | CMP-2024C | TASK-1014 | Soundtrack Selection | USR-10 | Hugo Moretti | completed | 2024-03-14 | 2024-03-16 | 2024-03-16 | 2 | Approved by content lead. | TEAM-04 | Europe Digital | 12 | 10 |
| PRJ-115 | critical | 5.2 | true | designer | Spring Social Launch | CMP-2024A | TASK-1015 | Creative Brief Assembly | USR-12 | Mateo Sanchez | blocked | 2024-02-10 | 2024-02-14 | blank | blank | Waiting for client feedback on concept. | TEAM-01 | Global Creatives | 20 | 6 |
| PRJ-116 | high | 8.6 | false | strategist | Influencer Outreach | CMP-2024A | TASK-1016 | Contract Drafting | USR-08 | Olivia Chang | completed | 2024-02-12 | 2024-02-15 | 2024-02-15 | 3 | Legal team signed off. | TEAM-02 | North America Content | 14 | 13.5 |
| PRJ-117 | medium | 7.7 | false | strategist | Email Automation Revamp | CMP-2024B | TASK-1017 | User Segment Mapping | USR-11 | Miho Takeda | completed | 2024-03-04 | 2024-03-12 | 2024-03-10 | 6 | Segments finalized and deployed. | TEAM-03 | APAC Marketing | 16 | 14.2 |
| PRJ-118 | high | 8.9 | false | strategist | Podcast Launch | CMP-2024C | TASK-1018 | Episode Promotion Plan | USR-06 | Sofia Almeida | completed | 2024-03-15 | 2024-03-18 | 2024-03-18 | 3 | Promotion calendar shared with team. | TEAM-04 | Europe Digital | 14 | 13 |
| PRJ-119 | medium | 7.5 | false | designer | Spring Social Launch | CMP-2024A | TASK-1019 | Visual Asset Approval | USR-12 | Mateo Sanchez | in_progress | 2024-02-11 | 2024-02-15 | blank | blank | Assets sent to client for review. | TEAM-01 | Global Creatives | 18 | 12 |
| PRJ-120 | critical | 6.2 | true | strategist | Influencer Outreach | CMP-2024A | TASK-1020 | Influencer Contract Negotiation | USR-08 | Olivia Chang | completed | 2024-02-15 | 2024-02-19 | 2024-02-20 | 5 | Negotiation delayed by influencer legal team. | TEAM-02 | North America Content | 20 | 23 |
What the 70 rows show
from the 70-row sampleCritical (task priority) stands out: 8 of its 12 rows have bottleneck_
- 14%bottleneck_
flag = true - 8.2median collaboration_
score - 5task statuses
- 5median time_
to_ completion_ days - 12median resource_
hours_ allocated - 8.1median resource_
hours_ used
Critical (task priority)'s mean collaboration_
Median 8.2, from 4.2 to 9.8.
- string 13
- float 4
- date 3
- boolean 1
Columns
21 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
project_id | string | Unique identifier for each marketing projectunique | PRJ-101 |
project_name | string | Descriptive name of the marketing project | Spring Social Launch |
campaign_id | string | Identifier for the marketing campaign this project belongs tooptional | CMP-2024A |
task_id | string | Unique identifier for each task within a projectunique | TASK-1001 |
task_name | string | Descriptive name of the task | Instagram Teaser Design |
assigned_to_user_id | string | Unique identifier for the team member assigned to the task | USR-01 |
assigned_to_user_name | string | Full name of the team member assigned to the task | Carla Benton |
role | string | Role of the team member on the project (e.g., copywriter, designer, strategist)optional | designer |
task_status | string | Current status of the tasknot_started · in_progress · completed · blocked · on_hold | completed |
task_priority | string | Priority level of the tasklow · medium · high · critical · optional | high |
comments | string | Additional notes or comments about the task, including reasons for delays or bottlenecksoptional | Legal team signed off. |
team_id | string | Identifier for the remote team responsible for the projectoptional | TEAM-01 |
team_name | string | Name of the remote marketing teamoptional | Global Creatives |
| Numbers 4 columns | |||
time_to_completion_days | float | Number of days taken to complete the task (from creation to completion)0 or more · optional | 4 |
collaboration_score | float | Quantitative score (0-10) reflecting collaboration effectiveness for the task0 to 10 · optional | 8.7 |
resource_hours_allocated | float | Number of resource hours allocated to the task0 or more · optional | 24 |
resource_hours_used | float | Actual number of resource hours used to complete the task0 or more · optional | 20.5 |
| Dates and times 3 columns | |||
task_created_date | date | Date the task was created | 2024-02-05 |
task_due_date | date | Scheduled due date for the taskoptional | 2024-02-10 |
task_completed_date | date | Date the task was marked as completedoptional | 2024-02-09 |
| True or false 1 column | |||
bottleneck_flag | boolean | Indicates if this task was identified as a workflow bottleneckoptional | false |
Use it for
A marketing dashboard
The bottleneck_
flag rate, collaboration_ score by task_ priority and a breakdown of role. Excel, Power BI or Tableau. Why do 10 of 70 rows have bottleneck_
flag = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Projects70PRJ-1018.7highPRJ-1075.9criticalPRJ-1155.2critical
A software demo
Believable projects with project_
name, campaign_ id and task_ id to fill a screen in front of a buyer.
blueprint · remote-marketing-project-delivery-tracker
Behind this dataset
Same schema. As many rows as you need.
These 70 rows came out of a blueprint — 21 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Each row represents a unique project task assigned to a team member.
- Task statuses must be updated in real time (e.g., Not Started, In Progress, Completed, Blocked).
- Collaboration scores (1-5) are self-reported after each project phase.
- Delivery deadlines are recorded and compared to actual completion dates.
- Project type and associated campaign must be specified for each entry.
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- remote-marketing-project-delivery-tracker