Marketing Remote Collaboration Workflow Tracker
This dataset tracks remote collaboration workflows for marketing campaigns, detailing team member roles, task progress, digital tool usage, and workflow efficiency. It enables SMBs and martech startups to identify bottlenecks, measure digital adoption, and optimize remote teamwork for improved campaign outcomes. The schema supports actionable analytics for digital transformation and operational excellence.
Sample rows
preview · 8 of 75 rows · all 20 columns| workflow_idstring | task_statusstring | efficiency_scorefloat | bottleneck_flagboolean | collaboration_toolstring | campaign_idstring | campaign_namestring | team_member_idstring | team_member_namestring | rolestring | task_idstring | task_namestring | task_start_datedate | task_due_datedate | task_completed_datedate | tool_usage_frequencyinteger | bottleneck_reasonstring | remote_collaborationboolean | adoption_scorefloat | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| WF-2024-001 | completed | 0.93 | false | Zoom | CMP-1001 | Spring Social Launch | TM-501 | Emily Carter | manager | T-9001 | Kick-off Meeting | 2024-03-01 | 2024-03-02 | 2024-03-02 | 3 | blank | true | 0.98 | Smooth coordination, everyone attended |
| WF-2024-002 | in_progress | 0.78 | false | Google Docs | CMP-1002 | Q1 Email Blast | TM-502 | Liam Nguyen | copywriter | T-9002 | Draft Email Copy | 2024-03-07 | 2024-03-09 | blank | 5 | blank | true | 0.92 | Awaiting manager review |
| WF-2024-003 | completed | 0.85 | true | Figma | CMP-1003 | Summer Paid Ads | TM-503 | Sophia Lee | designer | T-9003 | Banner Design | 2024-04-14 | 2024-04-20 | 2024-04-19 | 8 | Delays in feedback from copywriter | true | 0.89 | Design finalized after two revisions |
| WF-2024-004 | completed | 0.91 | false | SEMrush | CMP-1004 | Local SEO Push | TM-504 | Carlos Mendez | analyst | T-9004 | Keyword Research | 2024-02-13 | 2024-02-14 | 2024-02-14 | 2 | blank | false | 0.72 | Local keywords identified |
| WF-2024-005 | in_progress | 0.77 | false | Figma | CMP-1002 | Q1 Email Blast | TM-505 | Priya Singh | designer | T-9005 | Email Template | 2024-03-08 | 2024-03-12 | blank | 4 | blank | true | 0.93 | Working on mobile optimization |
| WF-2024-006 | completed | 0.88 | false | Asana | CMP-1001 | Spring Social Launch | TM-506 | Daniel Kim | developer | T-9006 | Landing Page Setup | 2024-03-03 | 2024-03-06 | 2024-03-05 | 7 | blank | false | 0.8 | Page launched successfully |
| WF-2024-007 | blocked | 0.64 | true | Trello | CMP-1005 | Brand Awareness Drive | TM-507 | Fatima Al-Sayed | manager | T-9007 | Strategy Planning | 2024-05-02 | 2024-05-05 | blank | 2 | Awaiting input from stakeholders | true | 0.75 | Waiting for final approval |
| WF-2024-008 | completed | 0.9 | false | Google Sheets | CMP-1003 | Summer Paid Ads | TM-508 | Jacob Fischer | analyst | T-9008 | Audience Segmentation | 2024-04-15 | 2024-04-17 | 2024-04-17 | 5 | blank | false | 0.65 | Segments sent to manager |
| WF-2024-009 | on_hold | 0.61 | true | Slack | CMP-1006 | Winter Promo | TM-509 | Anna Becker | copywriter | T-9009 | Social Copywriting | 2024-01-10 | 2024-01-12 | blank | 1 | Waiting on brand guidelines | true | 0.55 | Pending guidelines update |
| WF-2024-010 | completed | 0.87 | false | Jira | CMP-1004 | Local SEO Push | TM-510 | Oliver Grant | developer | T-9010 | Schema Markup | 2024-02-16 | 2024-02-18 | 2024-02-17 | 3 | blank | false | 0.79 | Markup tested and deployed |
| WF-2024-011 | completed | 0.95 | false | DocuSign | CMP-1007 | Influencer Partnership | TM-511 | Janelle Brooks | other | T-9011 | Contract Review | 2024-05-15 | 2024-05-18 | 2024-05-17 | 2 | blank | true | 0.96 | Contract signed by both parties |
| WF-2024-012 | completed | 0.84 | false | Canva | CMP-1001 | Spring Social Launch | TM-512 | Matthew Owens | designer | T-9012 | Social Post Graphics | 2024-03-04 | 2024-03-08 | 2024-03-07 | 6 | blank | true | 0.9 | Finalized after client approval |
| WF-2024-013 | in_progress | 0.76 | false | Excel | CMP-1005 | Brand Awareness Drive | TM-513 | Ava Johnson | manager | T-9013 | Budget Allocation | 2024-05-06 | 2024-05-08 | blank | 4 | blank | false | 0.82 | Budget review scheduled |
| WF-2024-014 | in_progress | 0.81 | false | GitHub | CMP-1002 | Q1 Email Blast | TM-514 | Lucas Wang | developer | T-9014 | Template Integration | 2024-03-09 | 2024-03-11 | blank | 5 | blank | true | 0.86 | Integration tests underway |
| WF-2024-015 | completed | 0.88 | false | Photoshop | CMP-1006 | Winter Promo | TM-515 | Sofia Rossi | designer | T-9015 | Promo Banner | 2024-01-11 | 2024-01-15 | 2024-01-14 | 7 | blank | false | 0.7 | Completed ahead of deadline |
| WF-2024-016 | in_progress | 0.74 | false | Google Docs | CMP-1003 | Summer Paid Ads | TM-516 | Ethan Wood | copywriter | T-9016 | Ad Copy Draft | 2024-04-18 | 2024-04-22 | blank | 3 | blank | true | 0.88 | Review meeting scheduled |
| WF-2024-017 | completed | 0.83 | false | SEMrush | CMP-1004 | Local SEO Push | TM-517 | Grace Turner | analyst | T-9017 | Competitor Analysis | 2024-02-15 | 2024-02-20 | 2024-02-19 | 4 | blank | true | 0.85 | Analysis shared with team |
| WF-2024-018 | completed | 0.94 | false | Illustrator | CMP-1005 | Brand Awareness Drive | TM-518 | Mohammed Ali | designer | T-9018 | Logo Draft | 2024-05-07 | 2024-05-10 | 2024-05-10 | 6 | blank | true | 0.93 | Client approved logo |
| WF-2024-019 | not_started | 0 | false | CMP-1007 | Influencer Partnership | TM-519 | Harry Evans | manager | T-9019 | Partnership Outreach | blank | 2024-05-19 | blank | 0 | blank | true | 0.7 | Scheduled for next week | |
| WF-2024-020 | completed | 0.92 | false | Tableau | CMP-1006 | Winter Promo | TM-520 | Maya Patel | analyst | T-9020 | Campaign Performance Review | 2024-01-16 | 2024-01-18 | 2024-01-18 | 3 | blank | false | 0.68 | Performance metrics met goals |
What the 75 rows show
from the 75-row sampleCompleted (task status) stands out: mean efficiency_
- 12%bottleneck_
flag = true - 0.86median efficiency_
score - 6roles
- 5median tool_
usage_ frequency - 0.85median adoption_
score
Median 0.86, from 0.0 to 0.99.
- string 12
- integer 1
- float 2
- date 3
- boolean 2
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
workflow_id | string | Unique identifier for each remote collaboration workflow trackedunique | WF-2024-001 |
campaign_id | string | Unique identifier for the marketing campaign associated with the workflow | CMP-1001 |
campaign_name | string | Name of the marketing campaign | Spring Social Launch |
team_member_id | string | Unique identifier for the team member involved in the workflow | TM-501 |
team_member_name | string | Full name of the team member | Emily Carter |
role | string | Role of the team member in the campaign (e.g., designer, copywriter, manager)6 values | manager |
task_id | string | Unique identifier for the specific task within the workflow | T-9001 |
task_name | string | Name or brief description of the task | Kick-off Meeting |
task_status | string | Current status of the tasknot_started · in_progress · completed · blocked · on_hold | completed |
collaboration_tool | string | Name of the digital collaboration tool used for the task (e.g., Slack, Asana, Trello) | Zoom |
bottleneck_reason | string | Description of the bottleneck reason, if applicableoptional | Delays in feedback from c… |
notes | string | Additional notes or comments related to the workflow or taskoptional | Awaiting manager review |
| Numbers 3 columns | |||
tool_usage_frequency | integer | Number of times the tool was used for this task0 or more · optional | 3 |
efficiency_score | float | Efficiency score for the workflow or task (e.g., time saved, productivity metric, scale 0-1)0 to 1 · optional | 0.93 |
adoption_score | float | Score indicating the level of digital tool adoption by the team member (scale 0-1)0 to 1 · optional | 0.98 |
| Dates and times 3 columns | |||
task_start_date | date | Date when the task was startedoptional | 2024-03-01 |
task_due_date | date | Date when the task is due to be completed | 2024-03-02 |
task_completed_date | date | Date when the task was completedoptional | 2024-03-02 |
| True or false 2 columns | |||
bottleneck_flag | boolean | Indicates if this task or workflow is a bottleneck in the processoptional | false |
remote_collaboration | boolean | Indicates if the task was performed remotely | true |
Use it for
A marketing dashboard
The bottleneck_
flag rate, efficiency_ score by task_ status and a breakdown of collaboration_ tool. Excel, Power BI or Tableau. Why do the 44 completed rows have a mean efficiency_
score of 0.90? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Workflows75WF-2024-0010.93completedWF-2024-0030.85completedWF-2024-0070.64blocked
A software demo
Believable workflows with campaign_
id, campaign_ name and team_ member_ id to fill a screen in front of a buyer.
blueprint · marketing-remote-collaboration-workflow-tracker
Behind this dataset
Same schema. As many rows as you need.
These 75 rows came out of a blueprint — 20 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 distinct campaign workflow event.
- Track time-to-completion and number of remote collaborators.
- Log tool/platform usage for each workflow instance.
- Flag bottlenecks based on predefined duration thresholds.
- Include feedback ratings from campaign leads.
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
- marketing-remote-collaboration-workflow-tracker