Worklytics Datasets
Last updated
Last updated
© Worklytics Co.
Worklytics provides datasets describing work at various levels of aggregation. From less to more granular, the key Worklytics datasets you will be using are as follows:
In our Getting Started content, we use the following table names to refer to specific datasets, though the exact naming convention of tables may look different in your company's environment:
{Weekly_Group_Aggregates}
Weekly aggregated metrics pre-calculated at the group level. Typically used only in dashboards
idType, groupType, groupName, week, key
{Weekly_Individual_Aggregates}
Weekly metrics at the anonymized employee-level
employeeId, week, key
{Weekly_Individual_Groups}
No documentation exists, as this dataset will vary by customer
Weekly data at the anonymized employee-level with assigned groups and active employee status
employeeId, week
{Collaboration_Graph}
Weekly collaboration data based on the employee that initiated collaboration work and the person with whom they collaborated
employeeIdSource, employeeIdTarget, week
{Collaboration_Graph_Split}
Similar to {Collaboration_Graph}, but with an additional column for the type of collaboration (e.g., slack, meetings, etc.)
employeeIdSource, employeeIdTarget, week, sourceType
{Employee_Events}
A granular log of all employee events related to work across an organization (e.g., "Meeting Attendance"). This dataset can be used to generate new types of aggregate metrics describing work activity. For example, "How many external emails were sent by the sales team last month?" * Enterprise only
Use-case dependent
{Work_Items}
A granular log of all items related to work across an organization (e.g., "Meeting" or "Email"). This dataset can be used to generate new types of aggregate metrics describing work events. For example, "How many recurring meetings with more than 5 attendees do we have across the organization?" * Enterprise only
Use-case dependent
Note: Employee Events & Work Items datasets are only available in Datastream Enterprise tiers. Please contact sales@worklytics.co for more information