The Query designer offers a few different custom query options, including: Person, Meeting, Group-to-group, Person-to-group, Peer comparison, and Network queries. Each query type can help you investigate and answer specific business questions. The different query types give you the flexibility to look at data from multiple perspectives and generate powerful insights. You can also combine output from two different queries to gain even more in-depth insights.
With these queries, you can:
- Select as many or as few metrics as you need, for any population or time range.
- Customize metrics with a broad range of interaction details.
- Get your data in a clean and easy-to-use format that can take your analysis to the next level.
Time limit for querying data
The historical data on which queries are run is time limited: You can run queries only on data that is no older than 27 months. This 27-month period is a rolling window. This means that, after you have 27 months of Microsoft 365 data data, as the data is refreshed each week, the 27-month extent of data that you can query advances by one week to include only the preceding 27 months.
The results of any queries that you've already run remain available to you, even after the data that was queried to produce those results passes the 27-month limit.
You can subscribe a tenant to using the the advanced insights app through the Capacity model where the tenant consumes capacity units based on their volume of query usage.
The appearance and behavior of the pages for creating and running queries and of the query results page will depend on whether your tenant is subscribed to the Workplace Analytics SKU or to the Viva Insights SKU.
For more details, see Capacity model.
You can run the following types of queries in Query designer.
Use a person query when you want to find broad trends in the organization by looking at aggregated metrics for a group of people.
Person query results show a de-identified list of the productivity metrics (such as time in meetings and email) of each measured employee. Each row of data represents one person and you can select to aggregate the results by day, week, or month.
With a person query you can compare across individual activities and attributes, such as:
- Time-use metrics
- Organizational attributes
See Person queries to learn more.
Use a meeting query when you want to understand the relationship between different meeting attributes.
With a meeting query you can compare across meeting attributes, such as:
- Size or duration
- Subject line keywords
- Double-booked or multitasking rates
- Meeting organizer attributes
See Meeting queries to learn more.
Use a group-to-group query when you want to understand how one team invested their collaboration time with other teams within and outside of the organization.
For this query type, you can define a team in a variety of ways, with any organizational attribute or email domain. This enables you to answer questions such as:
- How did Sales managers allocate their time between all external customer domains (companies)?
- How much time did Benefits analysts spend with individual contributors in each region?
- How did Corporate VPs allocate their time to managers by business unit?
Group-to-group queries also offer alternative perspectives on collaboration. Rather than allocating collaboration hours across other teams, you can analyze the number of interactions between the teams, or analyze only those collaboration activities initiated by the “time giver” team.
See Group-to-group queries to learn more.
Use a person-to-group query to help you understand how individuals invested their time with one or more collaborator teams within and outside of the organization.
As with a group-to-group query, you can define the person (or time investor) and that person's collaborator team or teams in a variety of ways, with any organizational attribute or email domain.
You can choose to analyze the number of interactions between a time investor and the defined collaboration team, or to analyze only those collaboration activities initiated by the specified time investor.
See Person-to-group queries to learn more.
Peer comparison query
The peer comparison query helps you identify people whose collaboration patterns differ as compared to their peers. The query includes the measured employees, their specified metrics, and their peer group's averages for those metrics.
You can compare individuals with others who share the same manager, with their direct reports, or even with a custom peer group as defined with organizational attributes.
See Peer comparison queries to learn more.
You can use Network queries in the advanced insights app to find out who the best-connected people are in your company, division, or group based on collaboration data. After you learn who your influencers are, you can act on the likelihood that these people can effectively connect within or across groups and become efficient drivers of change.
You can use meeting exclusions to exclude meetings that fall outside relevant norms for the data. You can select between the default meeting exclusion rules or create custom rules that match your company's meeting conventions.
See Meeting exclusions to learn more.
An analyst might start by looking at a person query to see trends of employees across the company related to meeting collaboration.
If the metrics show indications of poor meeting behavior, such as too many long meetings, the analyst could create a meeting query to investigate specific meetings in depth to uncover causes of the poor meeting behavior.
Additionally, the analyst could create a group query to identify the groups involved in those meetings and further investigate potential causes that could be addressed. Finally, to address the problem, the analyst could work with a program to set up an improvement plan. See Plan walkthrough to learn more.
You can create queries in the following ways:
- Edit and use a Query template.
- Create your own custom query.
- Open and edit a previously run query.
When you create a new query or edit an existing query, you can select the metrics to include and customize. You can also use filters to narrow the results and focus in on specific data.
The advanced insights app includes a number of predefined query templates to help you get started with the Query designer. For details, see Templates.
- Domain collaboration analyzes collaboration patterns with external domains.
- Standard meeting query analyzes meetings by using the available base meeting query metrics.
- Standard person query analyzes collaboration patterns by using the available base person query metrics.
- Hourly collaboration analyzes meeting, email, instant-message, and call activity by hour of the day.
The following videos were used to train analysts on how to run queries.
These videos were recorded before the new Query designer was available.
A week in the life
The A week in the life video demonstrates how to work with a Person query.
The Expensive meetings video demonstrates how to work with a Meeting query.
Submit and view feedback for