Community Management Interaction Logs
This dataset provides detailed logs of moderator interactions across social platforms, including user actions, content moderation, escalation events, and resolution statuses. It enables community managers to track moderation effectiveness, identify trends, and resolve issues efficiently, supporting healthy and engaged online communities.
Sample rows
preview · 8 of 200 rows · all 20 columns| interaction_idstring | interaction_typestring | escalated_to_adminboolean | content_typestring | timestampdatetime | moderator_idstring | moderator_usernamestring | user_idstring | user_usernamestring | community_idstring | community_namestring | action_takenstring | content_idstring | resolution_statusstring | user_reportedboolean | report_idstring | platformstring | interaction_reasonstring | content_textstring | resolution_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| int-000001 | message | false | blank | 2023-12-31T09:02:15Z | mod-101 | PlantMod1 | user-3201 | GreenLeaf82 | comm-980 | PlantLovers | none | blank | resolved | false | blank | blank | blank | User asked about watering schedule and received advice. | |
| int-000002 | warning | false | post | 2024-01-01T21:17:43Z | mod-102 | MarineMod | user-7882 | OceanicFan99 | comm-981 | MarineBiology | issued_warning | post-1192 | resolved | true | report-4001 | Discord | Repeated off-topic posting in research discussion threads. | Does anyone know about coral reproduction rates in Atlantic reefs? | Warning issued for off-topic post. User acknowledged. |
| int-000003 | ban | true | comment | 2024-02-29T13:45:08Z | mod-103 | TravelMod | user-5568 | BackpackerTom | comm-982 | WorldTravellers | banned_user | comment-7894 | in_review | true | report-4002 | User posted spam links repeatedly despite previous warnings. | Check out this amazing deal! Visit www.spamlink.com for free flights! | Ban escalated for admin review due to repeated spam. | |
| int-000004 | note | false | blank | 2024-03-01T15:30:44Z | mod-104 | StarMod | user-1002 | JediSam | comm-983 | StarWarsHub | none | blank | closed | false | blank | Discord | blank | blank | Note added regarding bot activity in trivia thread. |
| int-000005 | warning | false | comment | 2024-03-28T20:01:10Z | mod-105 | BotanicMod | user-2213 | SproutGirl | comm-980 | PlantLovers | issued_warning | comment-4821 | resolved | true | report-4003 | Inappropriate language used in comment section. | Your advice is stupid, plants don't grow like that. | Warning issued; user reminded of community guidelines. | |
| int-000006 | message | false | blank | 2024-04-01T11:23:39Z | mod-106 | ReefMod | user-4345 | BlueTide | comm-981 | MarineBiology | none | blank | resolved | false | blank | blank | blank | Moderator answered a user question about aquarium setups. | |
| int-000007 | mute | false | message | 2024-04-15T16:48:00Z | mod-107 | TravelMod2 | user-1098 | NomadMike | comm-982 | WorldTravellers | muted_user | message-9021 | pending | true | report-4004 | Discord | User was flooding chat with repeated messages. | Anyone here? Hello? Can someone answer me? Please? | User muted for 24 hours due to spamming. |
| int-000008 | message | false | blank | 2024-05-01T08:14:05Z | mod-101 | PlantMod1 | user-3421 | FernFanatic | comm-980 | PlantLovers | none | blank | resolved | false | blank | blank | blank | User asked about fertilizer brands, received suggestions. | |
| int-000009 | escalation | true | profile | 2024-05-17T22:05:22Z | mod-108 | StarMod2 | user-2104 | DroidHunter | comm-983 | StarWarsHub | escalated_issue | profile-1072 | pending | true | report-4005 | Harassment report escalated for admin review. | Profile flagged for repeated harassment in direct messages. | Issue escalated to admin due to severity. | |
| int-000010 | note | false | blank | 2024-05-31T19:20:40Z | mod-109 | BotanicMod2 | user-2214 | RootRambler | comm-980 | PlantLovers | none | blank | closed | false | blank | Discord | blank | blank | Moderator left a note about seasonal contest. |
| int-000011 | ban | true | message | 2024-06-01T07:54:38Z | mod-110 | ReefExpert | user-7214 | CoralKeeper | comm-981 | MarineBiology | banned_user | message-9002 | resolved | true | report-4006 | Discord | User posted hate speech in group chat. | I hate people who love marine life. You're all losers! | User banned, admin confirmed action. |
| int-000012 | warning | false | post | 2024-01-15T18:23:59Z | mod-111 | TravelQueen | user-8791 | GlobeWalker | comm-982 | WorldTravellers | issued_warning | post-1203 | resolved | false | blank | Posted misleading information about visa requirements. | You don't need a visa for Brazil if you're from any country. | Warning issued and post corrected. | |
| int-000013 | mute | false | comment | 2024-02-01T12:06:30Z | mod-112 | JediMaster | user-3011 | SithSlayer | comm-983 | StarWarsHub | muted_user | comment-4502 | pending | true | report-4007 | User ignored moderator and continued posting spoilers. | Luke dies in the movie! Can't believe it! | Muted user for 48 hours for posting spoilers. | |
| int-000014 | message | false | blank | 2024-03-15T09:22:14Z | mod-113 | ModSprout | user-6821 | MossyM | comm-980 | PlantLovers | none | blank | resolved | false | blank | blank | blank | Moderator explained photo contest rules to a user. | |
| int-000015 | escalation | true | post | 2024-04-20T23:54:06Z | mod-114 | OceanMod | user-2148 | SeaWeed47 | comm-981 | MarineBiology | escalated_issue | post-1244 | pending | true | report-4008 | Copyright infringement reported, escalated for admin review. | Copied images from scientific journal without permission. | Issue pending. Awaiting admin response. | |
| int-000016 | ban | true | post | 2024-05-10T06:11:11Z | mod-115 | TravelKing | user-4127 | JetSetter21 | comm-982 | WorldTravellers | banned_user | post-1251 | resolved | true | report-4009 | Discord | User posted inappropriate images. | Image post flagged for nudity and violation of rules. | User banned, images removed. |
| int-000017 | note | false | blank | 2024-06-01T18:51:27Z | mod-116 | StarMod3 | user-9802 | HanSoloFan | comm-983 | StarWarsHub | none | blank | closed | false | blank | blank | blank | Note about system maintenance scheduled for next week. | |
| int-000018 | warning | false | post | 2024-01-03T03:38:03Z | mod-117 | PlantMod2 | user-7622 | OrchidGuy | comm-980 | PlantLovers | issued_warning | post-1287 | resolved | false | blank | Discord | Excessive self-promotion in posts. | Visit my website for the best orchid care advice! | Warning issued, post edited. |
| int-000019 | mute | false | message | 2024-02-20T10:20:59Z | mod-118 | ReefMod2 | user-4717 | TideSurfer | comm-981 | MarineBiology | muted_user | message-9202 | pending | true | report-4010 | User posted repetitive memes in chat. | Check this meme! Check this meme! Check this meme! LOL | Muted user for 12 hours for chat flooding. | |
| int-000020 | message | false | blank | 2024-03-05T14:02:23Z | mod-119 | TravelMod3 | user-5124 | PassportPete | comm-982 | WorldTravellers | none | blank | resolved | false | blank | blank | blank | Moderator responded to user about travel insurance. |
What the 200 rows show
from the 200-row sampleBan (interaction type) stands out: 29 of its 29 rows have escalated_
- 24%escalated_
to_ admin = true - 3platforms
- 5resolution statuses
- 6action takens
- 8community names
- 16communities
- string 17
- datetime 1
- boolean 2
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 17 columns | |||
interaction_id | string | Unique identifier for each interaction log entryunique | int-000001 |
moderator_id | string | Unique identifier for the moderator involved in the interaction | mod-101 |
moderator_username | string | Username of the moderator | PlantMod1 |
user_id | string | Unique identifier for the user involved in the interaction | user-3201 |
user_username | string | Username of the user | GreenLeaf82 |
community_id | string | Unique identifier for the community or group where the interaction occurred | comm-980 |
community_name | string | Name of the community or group8 names | PlantLovers |
interaction_type | string | Type of interaction (e.g., warning, ban, message, escalation, mute)7 values | message |
interaction_reason | string | Moderator's stated reason for the interactionoptional | User posted hate speech. |
action_taken | string | Specific action taken by the moderator (e.g., deleted post, issued warning, banned user)7 values | none |
content_id | string | Unique identifier for the content involved (e.g., post, comment, message)optional | post-1192 |
content_type | string | Type of content involved (e.g., post, comment, message)post · comment · message · profile · other · optional | post |
content_text | string | Text of the content involved in the interaction, if applicableoptional | 🐟🐠🐡🐙🐬🐳🐋🐚🐚🐚🐚🐚 |
resolution_status | string | Status of the interaction (e.g., resolved, pending, in_review, closed)resolved · pending · in_review · closed · other | resolved |
resolution_notes | string | Notes on how the issue was resolved or any follow-up actionsoptional | Muted user for 24 hours. |
report_id | string | Unique identifier for the user report, if applicableoptional | report-4001 |
platform | string | Name of the social platform (e.g., Discord, Reddit, Facebook)3 platforms | |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the interaction occurred | 2023-12-31T09:02:15Z |
| True or false 2 columns | |||
escalated_to_admin | boolean | Indicates if the issue was escalated to an administrator | false |
user_reported | boolean | Indicates if the interaction was initiated due to a user report | false |
Use it for
A social media dashboard
The escalated_
to_ admin rate, escalated_ to_ admin by interaction_ type and a breakdown of content_ type. Excel, Power BI or Tableau. Why do 47 of 200 rows have escalated_
to_ admin = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Interactions200int-000001messageint-000003banint-000009escalati…
A software demo
Believable interactions with timestamp, moderator_
id and moderator_ username to fill a screen in front of a buyer.
blueprint · community-management-interaction-logs
Behind this dataset
Same schema. As many rows as you need.
These 200 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.
- Record user interaction type and timestamp
- Track moderation events
- Flag high-activity users
- Exclude private messages
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- community-management-interaction-logs