Frequently Asked Questions for Workplace Analytics
The most commonly asked questions and answers about Workplace Analytics are grouped into the following sections:
Q1. Is Workplace Analytics considered a tool for human-resource planning?
A1. No. Workplace Analytics is a collaboration analysis tool that can be used to analyze behavior and network patterns.
Q2. How do MyAnalytics and Workplace Analytics differ?
A2. MyAnalytics presents personal and private insights to Microsoft 365 users in Outlook through digest emails, inline suggestions and the Insights Outlook add-in. It can also be accessed through a web dashboard.
Workplace Analytics is a tool that is used by organizations for running top-down analysis and it computes only aggregated and de-identified metrics.
Privacy and compliance
Q1. How much data does Workplace Analytics collect?
A1. Workplace Analytics initially collects and processes 13 months' worth of data. Through weekly refreshes, Workplace Analytics continues to increase this history until 27 months’ worth of data is collected. Customers can file a request, for security reasons, to provide Workplace Analytics with less than this default amount; in that case, the minimum amount that can be collected is one month.
Q2. Does Workplace Analytics support a separate data environment that adheres to compliance and regulatory requirements such as those required by the government?
A2. Workplace Analytics is not available in data cloud environments that Microsoft maintains for government agencies.
Q1. Can I upload an organizational data file that has non-English words or letters?
A1. Yes. The organizational data file can have non-English words or letters. Note the following:
- File names and individual rows can have non-English words or letters.
- Each column header must be mapped to an attribute with an English name.
Q2. Can I construct a query with filters and/or meeting subject lines that contain non-English words or letters?
A2. Yes. You can use filters in queries that include the following:
- Attributes or values from your organizational data that include non-English words or characters.
- Meeting subject lines (which can include non-English words or characters) as specific filter criteria.
For more information, see Customize a base metric in a query.
Workplace Analytics setup
Setup and configuration
Q1. What are the basic steps to enable Workplace Analytics?
A1. The main tasks required to enable Workplace Analytics for your organization are:
- Assign licenses
- Assign roles
- Configure settings
- Upload organizational data
For complete information about setup, see Set up Workplace Analytics.
Q2. Does it present a problem if my licensed population works in different time zones or has varying working hours?
A2. No. Workplace Analytics can determine each employee's time-zone value and their working hours, regardless of their location. To make this determination, Workplace Analytics carries out the steps that are described in Default time zone.
Q3. Can I configure the user data that particular analysts can access and use?
A3. You can assign analysts the analyst (limited access) role, which limits them to view Explore the stats data. See Assign Workplace Analytics roles and User roles in Workplace Analytics for more details.
Q4. Why are Start time and End time so important when configuring Workplace Analytics?
A4. The Start time and End time values determine the working hours for which data will be analyzed. They also determine the time period that is considered after hours. See Working days and hours.
Q5. Is there a maximum number of Workplace Analytics analyst roles that can be assigned?
A5. No. No limit is imposed by Workplace Analytics.
Q6. In the Workplace Analytics Data sources section, on the "Office 365 data" page, you can see the number of "Measured employees." Is this the number of licensed users or the number of both licensed and un-licensed?
A6. Licensed. Specifically, this number refers to licensed employees who are also present in the collaboration (Office 365) data. For more information, see Origin of data counts.
Q7. What happens with users who were not assigned a Workplace Analytics license? Are they ignored?
A7. No, they are not ignored but they are not measured and their data is not processed. However, as internal collaborators of measured employees, their collaboration data is used for analysis when measured employees collaborate with them through meetings, email, unscheduled calls, or instant messages. For details, see Origin of data counts.
Q1. What are common causes of a failure to upload an organizational data file into Workplace Analytics, or the invalidity of such a file?
A1. An upload can fail if the data has invalid values, if it is missing required data, or if the validity threshold for unrequired data is set too high; this is the case for custom fields in uploads after the organization's first upload. For more information, see the following:
- Validation fails in Upload organizational data (subsequent uploads)
- Validation fails in Upload organizational data (first upload)
Q2. For my first organizational data upload, should I choose "append" or "replace"?
A2. For your first upload, you will not have either of these choices. For more details about your first upload, see Upload organizational data (first upload). For more information about when to append or replace, see Upload organizational data (subsequent uploads).
Q3. For the required fields, what percentage does Workplace Analytics require for the validity threshold?
A3. Workplace Analytics requires that the PersonId and EffectiveDate fields meet 100% of the validity threshold, because each of row of data must have a PersonId for each person in your organization. The other required fields (such as ManagerID) must exceed 95% of the validity threshold. (Note that the calculations of validity threshold consider only two kinds of data values: valid values and blank values. This means that, for a validity threshold that's set to 95%, the column will pass validation if fewer than 5% of the values in the column are blank and the rest are valid. However, if even one cell contains malformed data, the entire file upload will fail.) For more information, see Field column details.
Q4. What happens if an employee (who is represented by a PersonID) has more than one manager (who would be represented by ManagerIDs)?
A4. Organizational data allows for the identification of only one single, primary manager. This manager is represented by the ManagerID for that PersonID on a given EffectiveDate. However, note that the Workplace Analytics admin can use the EffectiveDate field in the organizational data to indicate that an employee’s primary manager has changed from one month to the next.
Q5. Who obtains the organizational data that must be uploaded to Workplace Analytics?
Q6. Who can access organizational data after it has been uploaded to Workplace Analytics?
A6. For privacy reasons, no one can download the raw data that was uploaded. Workplace Analytics admins can view metadata about the organizational data on the Data sources page, but they cannot see how the attribute values map to individual people.
Use Workplace Analytics
Q1. What is the difference between privacy settings and meeting-exclusion rules?
A1. Admins make privacy settings to change the way Workplace Analytics extracts data, such as preventing data from ever being included in any Workplace Analytics calculation. Note that privacy settings changes apply to future data extractions and are not retroactive to past data. For more information, see Privacy settings and Workplace Analytics privacy and data access.
Analysts use meeting-exclusion rules in Workplace Analytics queries to help ensure that query results accurately represent relevant meeting norms within the organization. Changes to these rules apply retroactively in the data. For more information, see Meeting exclusion rules in Workplace Analytics.
Q2. Can other analysts use the meeting exclusion rule sets that I create?
A2. Yes. Anyone in your organization can use the meeting exclusion rules that anyone else in the organization has created. For more information about meeting exclusion rules, see Application of meeting-exclusion rules.
Data validation, verification, and use
Q1. Why is my measured population less than the number of employees with assigned licenses?
A1. This can happen if you selected only a subset of your population for data analysis, or if your admin excluded a subset of the population from the organizational data that's uploaded into Workplace Analytics. For more details, see Assign licenses and Who to include in the data in Prepare organizational data, and see Origin of data counts.
Q2. Why do the totals seem too high for internal and external collaborators?
A2. The collaborator totals include the number of internal (or external) people with whom the measured employees have collaborated at least one time during the selected period. The totals that are included in the Summary header on the External collaboration page do not change because of filters that have been applied in Page settings. For details, see External collaboration.
Q3. Why doesn't the email or meeting trend line extend back for the entire historical 13-month period (or for the custom time period that I set)?
A3. Business policies can affect the historical data that is processed by Workplace Analytics. As you view historical data, if you see a steady decline or point-in-time drop in email and/or meeting activity, it might be due to email having been archived. Another cause can be recurring meetings that are deleted before the data is extracted. However, this only impacts initial baseline data, because future deletions do not affect weekly data that was previously collected. On the Sources page, you can select a time period where the email and/or meeting activity is stable. For more information, see Office 365 data summary.
Q4. How does Workplace Analytics process data for meetings and emails sent to distribution lists?
A4. Workplace Analytics processes email and meetings data for a distribution list as a single entity or person. It does not expand the distribution list and assign meeting and email hours to its members. For more accurate data, upload the organizational data attributes for these lists by adding attributes of the distribution-list members or whatever best describes the list population. See Upload organizational data for detailed steps.
Q5. What collaboration information is processed from Microsoft Teams?
A5. Teams provides information about collaboration activities, namely direct messages (chats) and calls. It does not provide information about Teams channels.
Q6. When a person sends a message or meeting invite for a group’s shared mailbox or on behalf of another person, who gets credit for sending it?
A6. It depends on the type of mailbox and which permissions are set for the Exchange Online mailbox. For details, see Mailbox permissions.
A shared mailbox (Microsoft 365 group mailbox) typically has a number of group members that share access and permissions for the group mailbox. An example of a shared mailbox is
LeadershipTeam@Contoso.com. For details, see Which permissions you should use in shared mailboxes.
- Send As permission - When a group member with Send As permission for a shared mailbox sends a message or meeting invitation from the group mailbox, Exchange gives credit to the shared mailbox instead of any single person in the group. Workplace Analytics does not use this action in its calculations.
- Send on Behalf permission – This permission is not available for shared mailboxes in Exchange Admin Center. However, if it is set with PowerShell (GrantSendonBehalf parameter), the person who sends the message gets credit for it in Workplace Analytics calculations.
An individual mailbox (or a linked mailbox) with a primary mailbox owner can link or give delegate access and one of the following permissions to another person to send messages or meeting invites for the primary mailbox owner. For example, an assistant with delegate access can send a message or meeting invite from their manager's mailbox. A delegate can have one of the following permissions. For details, see Give mailbox permissions to another user.
- Send As permission – The primary owner of the mailbox gets credit for sending the message or invite in Workplace Analytics calculations.
- Send on Behalf permission - The person who sends the message on behalf of the mailbox owner gets the credit in Workplace Analytics calculations.
- Both Send As and Send on Behalf permissions – If the delegate person has both permissions set, the Send As permissions are used and that person does not get credit for sending the message or invite in Exchange and therefore Workplace Analytics credits the owner of the mailbox in calculations.
Explore the stats
Q1. Why do I have fewer "filtered employees" than "measured employees" with no filters applied?
A1. Employee data can change based on the Page settings that are selected for Explore the stats or Solutions data. These settings are not necessarily considered filters but can still cause totals to vary. For details, see Page settings.
Q2. How does Workplace Analytics estimate the cost of low-quality meetings? Can I customize this estimate?
A2. Admins can include optional hourly-rate data in the organizational data upload, which they can then use to calculate the total cost of low-quality meetings for the Meetings overview. If this organizational data is provided, cost is calculated as the person's default hourly rate for the organization multiplied by the number of low-quality meeting hours. If no hourly rate is assigned to a meeting participant, a default hourly rate of $75 is used. On the Settings page, admins can change the value in the Hourly Rate field from its default value to another hourly rate.
Q3. Why are a group's total meeting hours (included as part of working hours and after-hours work) larger than the group's total meeting hours for the week?
A3. This can occur because of the way Workplace Analytics calculates meeting hours. The meeting-hours total includes adjusted hours for attended meetings, while total working hours and after-hours work include the number of meeting hours (not adjusted) for scheduled meetings.
This discrepancy can occur when meetings overlap. Workplace Analytics doesn't know which meetings were attended, so the meeting hours total will include adjusted hours, which are an estimate of time actually spent in meetings. For example, let's say a group of five employees is double booked for two meetings from 4:30 to 5:30 PM, and the group's workday ends at 5:00 PM. For this scenario, Workplace Analytics adjusts the meeting hours to one hour, since the group cannot attend two meetings at the same time. However, Workplace Analytics doesn't adjust for the two scheduled meetings, which results in it adding five hours to total working hours and five hours to after-hours work. The group can avoid this discrepancy by declining any scheduled meetings that they do not attend.
Q4. What is the total workday length assumed for calculating focus hours?
A4. If measured employees or internal collaborators have their time zones defined as part of your organizational data, Workplace Analytics uses their individual time-zone settings for working hours, focus hours, and other time-related metrics. However, if the organizational data does not define a time zone for an employee, Workplace Analytics uses the default time-zone setting that your admin sets in Workplace Analytics for that employee. For more details, see Time zone setting and Focus hours and fragmented hours.
Q1. For a group-to-group query, what's the difference between the results for "Collaborators Within Group" and for "Same group as Time Investor?"
A1. If the result of a query defines the same set of people as members of both the time investors and collaborators groups, and these individuals also match any defined filters, then the collaborators are grouped together under the Collaborators Within Group results. The Same group as Time Investor results apply when a time-investor group allocates time only to themselves if no other groups are participating in the meeting or email. See Group-to-group query output and Overview of time allocation for more details.
Q2. How do I analyze collaboration hours at my company for a specific time frame, such as 8 PM to 8 AM?
A2. You can use the Collaboration hours metric to filter for a specific time frame, regardless of when it occurs. Note that query results that use the Collaboration hours to filter for a time period that includes after-hours time, such as 8 PM to 8 AM, will include all people who collaborated during this time regardless of if they have this time period set as their working or non-working hours on their calendar.
Q3. Why don't totals for meeting hours and email hours match up with totals for working hours and after hours in person query output?
A3. Because totals for working hours and after hours calculate the "time booked on your calendar" instead of "time in meetings." Calculations for total meeting hours (time in meetings) adjusts the duration time to account for double-booked meetings, where a person has two meetings scheduled at the same time or times that overlap on the calendar. A heuristic logic orders which meetings a person likely attended and assigns time accordingly. For more details, see Person query output.
Q4. When I download and view a query, why is the data unreadable or not shown correctly in Excel?
A4. You probably opened the .csv file as is. For Excel to show the data correctly, you need to import the .csv file into Excel. If you are using Excel 2016, follow the steps in Download and import query results. For other versions of Excel, open Help in Excel and then search for the instructions on how to import a .csv file.
Q5. Why don’t a person’s low-quality meeting hours equal the sum of their redundant, conflicting, and multitasking meeting hours in my query?
You might expect the total number of redundant, conflicting, and multitasking meeting hours to equal the total number of low-quality meeting hours. However, sometimes they won’t equal because of how conflicting meeting hours are calculated. For more details, see Low-quality meeting hours, Conflicting meeting hours, and Calculation variables.