Worklytics Datasets

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:

Table	Description	Usual join keys/fields
{Weekly_Group_Aggregates} Data Schema, Definitions, Methodology	Weekly aggregated metrics pre-calculated at the group level. Typically used only in dashboards	idType, groupType, groupName, week, key
{Weekly_Individual_Aggregates} Data Schema, Definitions, Methodology	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} Data Schema	Weekly collaboration data based on the employee that initiated collaboration work and the person with whom they collaborated	employeeIdSource, employeeIdTarget, week
{Collaboration_Graph_Split} Data Schema	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} Data Schema	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} Data Schema	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 [e-mail] for more information