Dataset: Activity Events
Entity: Activity Events
Field ID: target_user_username
Type: Text
Description: The username of the person targeted by the event. Only applicable to REVIEWER_ASSIGNED, REVIEWER_UNASSIGNED, USER_ASSIGNED, USER_UNASSIGNED actions. NULL for any other event action. Note that usernames are app-specific.
Source: Applications support the following events
Github:
CREATED,CLOSED,REOPENED,MERGED,REVIEWER_ASSIGNED,REVIEWER_UNASSIGNED,USER_ASSIGNED,USER_UNASSIGNEDGitLab:
CREATED,CLOSED,REOPENED,MERGED,REVIEWER_ASSIGNED,REVIEWER_UNASSIGNED,USER_ASSIGNED,USER_UNASSIGNED,WORK_LOGGEDBitbucket:
CREATED,CLOSED,MERGED,REVIEWER_ASSIGNED,REVIEWER_UNASSIGNEDAzure DevOps:
CREATED,CLOSED,MERGED,REVIEWER_ASSIGNED,REVIEWER_UNASSIGNEDJira:
CREATED,CLOSED,REOPENED,USER_ASSIGNED,USER_UNASSIGNED,WORK_LOGGED,WORKFLOW_STATUS_UPDATEDClickUp:
CREATED,CLOSED. ClickUp does not expose an events API. Keypup generates these two events based on the issue timestamps (date_created&date_closed)Trello:
CREATED,CLOSED,REOPENED,USER_ASSIGNED,USER_UNASSIGNED,WORKFLOW_STATUS_UPDATED
Transformation logic: N/A
From: |
|
Github (Timeline Items) |
|
Gitlab (Discussions, State Events) | Extracted from system discussion content. |
Bitbucket (Activity) |
|
Azure DevOps (PR Threads) | Extracted from |
Jira (Changelog, Worklog) |
|
ClickUp (Issue timestamps) | N/A (no assignment events exposed) |
Trello (Actions) |
|
Reporting Use Cases
The Target User field from the Activity Events dataset identifies the person who was the object of a user-related action, such as being assigned to an issue or requested for a review. It is essential for analyzing workload distribution and tracking how responsibilities are delegated over time.
Filtering for User-Specific Activity: You can create detailed activity feeds focused on actions that involved a specific person.
"Work Assigned to Me": To see a log of all the times you were assigned to a task or requested for a review, you can create a report with a filter where
Target User is me.Team Assignment Feed: To monitor the workload being assigned to a specific team, you could filter where
Target User equals any of "user1,user2".
Reporting on Workload Distribution: Using this field as a dimension allows you to see who is receiving the most new assignments or review requests.
Assignments per Person: A bar chart with
Target Useras the dimension and a metric likeCOUNT_IF(action == "USER_ASSIGNED")will show you how many new tasks each person has been assigned over a given period.Review Requests per Person: Similarly, you can analyze the distribution of review requests with a metric like
COUNT_IF(action == "REVIEWER_ASSIGNED"). This is a powerful way to see if your review workload is balanced across the team.
Custom Formulas for Advanced Analysis: You can combine this field with the
Authorto analyze how your team delegates work.For example, you can create a report to see how often managers are assigning tasks to their team members by filtering where
Author = "manager.name"and then usingTarget Useras a dimension to see the breakdown of assignments.
