Dataset: Activity Events
Entity: Activity Events
Field ID: _system_id
Type: Text
Description: The universal ID assigned to the record to uniquely identify it across all application records.
Source: Calculated
Transformation logic: Generated using the App Record ID and the Source App to create a truly unique ID.
From: |
|
Github (Timeline Items) | Calculated |
Gitlab (Discussions, State Events) | Calculated |
Bitbucket (Activity) | Calculated |
Azure DevOps (PR Threads) | Calculated |
Jira (Changelog, Worklog) | Calculated |
ClickUp (Issue timestamps) | Calculated |
Trello (Actions) | Calculated |
Reporting Use Cases
The ID (System) field is the unique identifier assigned by Keypup to every single activity event. Its most critical role in reporting is to serve as the foundation for accurate counting and to enable precise drilldowns from high-level trends to the individual actions that comprise them.
Enabling Accurate Drilldowns: This is an essential function for analysis. When you create a widget that aggregates activity, like a chart showing "25 issues closed last week," and you click on that data point, the
ID (System)is what allows the system to fetch and display the 25 specific CLOSED events that make up that total. It acts as the unique key for each record in the drilldown, guaranteeing that the detailed list of events you see is a perfect, 1-to-1 match of the aggregated metric you are investigating.