Social Media Moderation Workflow Trace
This dataset provides detailed, end-to-end traceability of content moderation workflows on social media platforms, capturing operational handoffs, decisions, bottlenecks, and compliance flags. It enables operations managers to audit moderation processes, identify inefficiencies, and surface training opportunities for teams. The schema supports granular analysis of workflow stages, decision outcomes, and team performance.
Sample rows
preview · 8 of 68 rows · all 19 columns| trace_idstring | final_decisionstring | total_resolution_time_minutesfloat | compliance_flagboolean | team_idstring | content_idstring | content_typestring | content_created_datetimedatetime | reported_datetimedatetime | report_reasonstring | initial_moderator_idstring | initial_review_datetimedatetime | initial_review_decisionstring | handoff_countinteger | final_moderator_idstring | final_review_datetimedatetime | training_opportunity_flagboolean | bottleneck_stagestring | platform_namestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TRC-10001 | removed | 52 | false | TEAM-430 | CNT-20012 | post | 2024-04-12T09:23:15Z | 2024-04-12T12:17:40Z | hate speech | MOD-3004 | 2024-04-12T13:00:12Z | remove | 0 | MOD-3004 | 2024-04-12T13:15:44Z | false | none | SocialSphere |
| TRC-10002 | approved | 22 | false | TEAM-431 | CNT-20019 | comment | 2024-04-13T16:49:03Z | 2024-04-13T19:55:12Z | spam | MOD-3021 | 2024-04-13T20:15:22Z | approve | 0 | MOD-3021 | 2024-04-13T20:17:01Z | false | none | ChatterBox |
| TRC-10003 | removed | 106 | true | TEAM-430 | CNT-20015 | image | 2024-05-08T08:14:19Z | 2024-05-08T09:12:41Z | nudity | MOD-3047 | 2024-05-08T09:35:17Z | remove | 1 | MOD-3011 | 2024-05-08T10:01:03Z | false | initial_review | PicZone |
| TRC-10004 | escalated | 339 | false | TEAM-432 | CNT-20020 | video | 2024-05-01T21:05:55Z | 2024-05-02T02:17:02Z | harassment | MOD-3012 | 2024-05-02T03:10:11Z | escalate | 2 | MOD-3003 | 2024-05-02T06:44:09Z | true | escalation | VidStream |
| TRC-10005 | flagged_for_training | 124 | false | TEAM-430 | CNT-20017 | other | 2024-06-03T11:11:11Z | 2024-06-03T12:15:09Z | policy violation | MOD-3049 | 2024-06-03T12:40:20Z | request_info | 1 | MOD-3049 | 2024-06-03T13:15:33Z | true | final_decision | ConnectUp |
| TRC-10006 | removed | 62 | false | TEAM-431 | CNT-20013 | post | 2024-05-24T13:43:23Z | 2024-05-24T15:01:12Z | hate speech | MOD-3020 | 2024-05-24T15:10:10Z | remove | 0 | MOD-3020 | 2024-05-24T15:25:01Z | false | none | SocialSphere |
| TRC-10007 | flagged_for_training | 226 | false | TEAM-432 | CNT-20012 | post | 2024-04-12T09:23:15Z | 2024-04-13T10:05:02Z | harassment | MOD-3048 | 2024-04-13T10:37:41Z | escalate | 2 | MOD-3014 | 2024-04-13T13:21:19Z | true | escalation | SocialSphere |
| TRC-10008 | removed | 101 | false | TEAM-431 | CNT-20018 | comment | 2024-05-12T17:29:44Z | 2024-05-12T18:30:12Z | spam | MOD-3015 | 2024-05-12T19:00:09Z | remove | 0 | MOD-3015 | 2024-05-12T19:11:14Z | false | none | ChatterBox |
| TRC-10009 | removed | 82 | true | TEAM-430 | CNT-20021 | image | 2024-05-21T10:10:10Z | 2024-05-21T10:31:09Z | nudity | MOD-3027 | 2024-05-21T10:45:00Z | remove | 1 | MOD-3043 | 2024-05-21T11:31:42Z | false | initial_review | PicZone |
| TRC-10010 | escalated | 290 | false | TEAM-432 | CNT-20014 | video | 2024-06-01T08:05:22Z | 2024-06-01T10:00:00Z | violence | MOD-3012 | 2024-06-01T10:30:10Z | escalate | 3 | MOD-3044 | 2024-06-01T12:55:11Z | true | escalation | VidStream |
| TRC-10011 | flagged_for_training | 48 | false | TEAM-430 | CNT-20013 | post | 2024-05-24T13:43:23Z | 2024-05-25T09:13:50Z | policy violation | MOD-3018 | 2024-05-25T09:24:18Z | request_info | 1 | MOD-3018 | 2024-05-25T10:02:02Z | true | final_decision | SocialSphere |
| TRC-10012 | other | 111 | false | TEAM-433 | CNT-20022 | other | 2024-05-28T09:09:09Z | 2024-05-28T10:19:20Z | other | MOD-3041 | 2024-05-28T10:41:30Z | other | 0 | MOD-3041 | 2024-05-28T11:00:01Z | false | none | ConnectUp |
| TRC-10013 | approved | 42 | false | TEAM-431 | CNT-20018 | comment | 2024-05-12T17:29:44Z | 2024-05-13T08:03:21Z | spam | MOD-3007 | 2024-05-13T08:45:41Z | approve | 0 | MOD-3007 | 2024-05-13T08:46:10Z | false | none | ChatterBox |
| TRC-10014 | removed | 106 | true | TEAM-430 | CNT-20015 | image | 2024-05-08T08:14:19Z | 2024-05-09T09:12:41Z | nudity | MOD-3010 | 2024-05-09T09:35:17Z | remove | 2 | MOD-3022 | 2024-05-09T10:01:03Z | false | initial_review | PicZone |
| TRC-10015 | removed | 80 | false | TEAM-432 | CNT-20023 | video | 2024-05-20T21:05:55Z | 2024-05-21T02:17:02Z | harassment | MOD-3023 | 2024-05-21T03:10:11Z | remove | 1 | MOD-3023 | 2024-05-21T03:25:13Z | false | none | VidStream |
| TRC-10016 | removed | 62 | false | TEAM-431 | CNT-20024 | post | 2024-06-05T16:43:23Z | 2024-06-05T17:01:12Z | hate speech | MOD-3046 | 2024-06-05T17:10:10Z | remove | 0 | MOD-3046 | 2024-06-05T17:25:01Z | false | none | SocialSphere |
| TRC-10017 | approved | 22 | false | TEAM-431 | CNT-20025 | comment | 2024-06-07T16:49:03Z | 2024-06-07T19:55:12Z | spam | MOD-3042 | 2024-06-07T20:15:22Z | approve | 0 | MOD-3042 | 2024-06-07T20:17:01Z | false | none | ChatterBox |
| TRC-10018 | removed | 106 | true | TEAM-430 | CNT-20026 | image | 2024-06-08T08:14:19Z | 2024-06-08T09:12:41Z | nudity | MOD-3016 | 2024-06-08T09:35:17Z | remove | 1 | MOD-3016 | 2024-06-08T10:01:03Z | false | initial_review | PicZone |
| TRC-10019 | escalated | 339 | false | TEAM-432 | CNT-20027 | video | 2024-06-09T21:05:55Z | 2024-06-10T02:17:02Z | harassment | MOD-3039 | 2024-06-10T03:10:11Z | escalate | 2 | MOD-3045 | 2024-06-10T06:44:09Z | true | escalation | VidStream |
| TRC-10020 | flagged_for_training | 124 | false | TEAM-430 | CNT-20028 | other | 2024-06-11T11:11:11Z | 2024-06-11T12:15:09Z | policy violation | MOD-3040 | 2024-06-11T12:40:20Z | request_info | 1 | MOD-3040 | 2024-06-11T13:15:33Z | true | final_decision | ConnectUp |
What the 68 rows show
from the 68-row sampleEscalated (final decision) stands out: mean total_
- 25%compliance_
flag = true - 87.5median total_
resolution_ time_ minutes - 4bottleneck stages
- 5content types
- 5initial review decisions
- 7report reasons
Median 87.5, from 13.0 to 339.0.
- string 11
- integer 1
- float 1
- datetime 4
- boolean 2
Columns
19 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
trace_id | string | Unique identifier for the moderation workflow trace instance.unique | TRC-10001 |
content_id | string | Unique identifier for the social media content being moderated. | CNT-20012 |
content_type | string | Type of content (e.g., post, comment, image, video).post · comment · image · video · other | post |
report_reason | string | Reason the content was reported (e.g., hate speech, spam, harassment).7 reasons | hate speech |
initial_moderator_id | string | Identifier for the first moderator assigned to review the content. | MOD-3004 |
initial_review_decision | string | Decision made by the initial moderator (e.g., escalate, approve, remove, request info).approve · remove · escalate · request_info · other | remove |
final_moderator_id | string | Identifier for the moderator who made the final decision.optional | MOD-3004 |
final_decision | string | Final decision outcome for the content (e.g., approved, removed, escalated, flagged for training).5 values | removed |
bottleneck_stage | string | Stage in the workflow where a bottleneck was identified (e.g., initial_review, escalation, final_decision).initial_review · escalation · final_decision · none · optional | none |
team_id | string | Identifier for the moderation team handling the case.10 teams | TEAM-430 |
platform_name | string | Name of the social media platform where the content originated.8 names | SocialSphere |
| Numbers 2 columns | |||
handoff_count | integer | Number of times the moderation case was handed off between team members.0 or more | 0 |
total_resolution_time_minutes | float | Total time taken to resolve the moderation case, in minutes.0 or more | 52 |
| Dates and times 4 columns | |||
content_created_datetime | datetime | Timestamp when the content was originally created by the user. | 2024-04-12T09:23:15Z |
reported_datetime | datetime | Timestamp when the content was reported for moderation. | 2024-04-12T12:17:40Z |
initial_review_datetime | datetime | Timestamp when the initial moderator started reviewing the content. | 2024-04-12T13:00:12Z |
final_review_datetime | datetime | Timestamp when the final moderation decision was made.optional | 2024-04-12T13:15:44Z |
| True or false 2 columns | |||
compliance_flag | boolean | Indicates if any compliance issue was detected during moderation. | false |
training_opportunity_flag | boolean | Indicates if the case was flagged as a training opportunity for moderators. | false |
Use it for
A social media dashboard
The compliance_
flag rate, total_ resolution_ time_ minutes by final_ decision and a breakdown of team_ id. Excel, Power BI or Tableau. Why do the 10 escalated rows have a mean total_
resolution_ time_ minutes of 265.2? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Traces68TRC-1000152removedTRC-10003106removedTRC-1000982removed
A software demo
Believable traces with content_
id, content_ type and content_ created_ datetime to fill a screen in front of a buyer.
blueprint · social-media-moderation-workflow-trace
Behind this dataset
Same schema. As many rows as you need.
These 68 rows came out of a blueprint — 19 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.
- Every moderation action includes timestamps for reception, review start, decision, and closure.
- Each record is traceable to a unique content ID and moderator ID.
- Escalations are flagged and tracked with escalation reasons.
- All actions are classified by content type and flagged policy category.
- Compliance checkboxes indicate whether regulatory guidelines were followed at each step.
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
- social-media-moderation-workflow-trace