会议查询Meeting queries

工作区分析会议查询可帮助您分析各个会议趋势。A Workplace Analytics meeting query helps you analyze individual meeting trends. 您可以使用会议查询获取在特定时间段内发生的所有会议及其属性的列表。You can use a meeting query to get a list of all meetings and their attributes that occurred during a specific period.

如何在会议查询和人员查询之间进行选择How to choose between a meeting query and a person query

可以使用会议或人员查询回答某些问题:Certain questions can be answered with either a meeting or person query:

会议或人员查询

但对于您想要回答的大多数问题,这些行为更清楚地剪切:But for most questions you want to answer, the lines are more clear cut:

会议查询和人员查询

当您想要了解不同会议属性之间的关系时,请使用会议查询。Use a meeting query when you want to understand the relationship between different meeting attributes.

当您想要了解个人的组织属性(如团队、级别或位置)的关系以及他们如何使用时间时,或者当您想知道某个人的时间使用的某个方面可能会影响其时间使用的另一个方面时,可以使用人员查询。Use a person query when you want to understand the relationship between a person’s organizational attributes – like their team, level, or location – and how they use their time, or when you want to know how one aspect of a person’s time use might influence another aspect of their time use.

创建会议查询Create a meeting query

设置会议查询非常简单。Setting up a meeting query is simple. 选择是希望按天、周还是月汇总每个会议的指标,以及您希望分析的时间段。Select whether you want the metrics for each meeting summarized by day, week, or month, and the time period you’d like to analyze.

使用 " 排除 " 窗格中的选项将会议或与会者从该查询的分析中排除。Use the options in the Exclusions pane to exclude meetings or attendees from this query's analysis. 若要执行此操作,请在 " 会议排除 " 字段中,选择一个自定义会议排除规则或使用默认会议排除规则。To do this, in the Meeting exclusions field, select a custom meeting-exclusion rule or use the default meeting exclusion rule. 此外,还 ((可选)) 中,选择 " 与会者排除 " 字段中的与会者排除:Also (optionally), select an attendee exclusion in the Attendee exclusions field:

排除项--会议和与会者

通过在没有排除项的情况下运行此查询,您将获得一个输出文件,可帮助您确定正确的条件,以便将其他日历项目中的工作相关活动分开。By running this query with no exclusions, you will get an output file that can help you determine the right criteria to separate work-related activities from other calendar items.

会议查询无排除

添加筛选器Add filters

您可以添加筛选器来限制输出文件中包含的会议列表。You can add a filter to limit the list of meetings included in the output file. 例如,会议筛选器根据与会议相关的大小、持续时间或其他属性来限制查询。For example, the Meeting filter limits the query based on the size, duration, or other attributes related to meetings.

您还可以根据会议的组织者、与会者和被邀请者属性来限制查询。You can also limit the query based on organizer, attendee, and invitee attributes for meetings.

会议查询筛选器

添加筛选器时,可以看到筛选器组中包含的人员数以及它所基于的已衡量员工的总数。When adding a filter, you can see the number of people included in the filter group and the total number of measured employees it's based on. 这可帮助您决定是否在运行查询之前设置了正确的筛选器 (或筛选器) 。This helps you decide if you've set up the correct filter (or filters) before running the query.

筛选器预览

添加指标Add metrics

您可以添加基本指标来自定义会议数据。You can add base metrics to customize your meeting data. 例如,选择 "与会者" 指标以包含参加会议的人员总数。For example, select the Attendees metric to include the total number of people that attended meetings. 您可以添加指标筛选器来进一步自定义数据。You can add a metric filter to further customize the data. 例如,以下指标筛选器将仅显示工程组中包括的与会者的会议。For example, the following metric filter will only show meetings that included attendees from the engineering group.

会议查询指标

若要获取有关添加指标筛选器的更多详细信息,请参阅 自定义指标To get more details on adding metric filters, see Customize a metric.

在创建会议查询的基本过程中,您将回答以下三个问题:In the basic process to create a Meeting query, you will answer three questions:

  1. 我要分析哪些会议属性?What meeting properties do I want to analyze? (筛选器部分) (Filters section)
  2. 我要分析的时间范围是什么?What time frame do I want to analyze? (日期范围) (Date range)
  3. 要了解有关该时间段中的哪些会议的数据?What data do I want to know about those meetings for that period? " (指标" 部分) (Metrics section)

可用数据Available data

通过会议查询,您可以使用适用于贵公司的 Office 365 中的日历元数据获取会议详细信息,包括:与会者会议时间、与会者、被邀请者、会议期间发送的电子邮件等。With a meeting query, you can use the calendar metadata available from Office 365 for your company to get meeting details, including: Attendee meeting hours, attendees, invitees, emails sent during meetings, and so on.

选择要包含的组织数据Select what organizational data to include

当您在工作区分析中运行会议查询时,输出 ( .csv) 文件可能会大于所需的大小,而不是您所需的组织数据列。When you run a meeting query in Workplace Analytics, the output (.csv) file can be larger than necessary, with more organizational data columns than you need. 您可以使用 "组织数据" 部分选择要在输出文件中包含的数据列:You can use the Organizational data section to select which data columns to include in the output file, which:

  • 使用较小的文件中的列改进数据分析。Improves data analysis with fewer columns in a smaller file.
  • 通过排除从文件中选择的列,进一步保护私有数据。Further protects private data by excluding select columns from the file.
  • 使您能够选择 " 全部清除 " 以清除所选列,并使用 " 全选 " 来包含所有列。Enables you to select Clear all to clear the selected columns and use Select all to include all columns.

"组织数据" 部分

长时间定期会议的示例查询Example query for long recurring meetings

继续执行 人员查询中的示例,调查包含操作的长会议,并确定其他重要的会议因素(如长时间会议定期会议),您可以创建具有以下条件的会议查询:Continuing the example from Person queries, to investigate long meetings that include Operations and identify other significant meeting factors, such as if long meetings are recurring, you can create a meeting query with the following criteria:

  • 时间范围:显示每周聚合的数据Time frame: Show the data aggregated weekly
  • 会议属性:筛选器Meeting properties: Filters
    • 会议中至少有一个人从操作成为与会者Meetings include at least one person from Operations as attendee
    • 长会议为两个小时或更多Long meetings are two hours or more
    • 会议定期发生Meetings are recurring
  • 哪些数据:指标What data: Metrics
    • AttendeesAttendees
    • 与会者会议时间Attendee meeting hours

为长期定期会议创建自定义会议查询To create a custom meeting query for long recurring meetings

  1. 在 "工作区分析" 中,选择 "分析 > 查询 > 会议"。In Workplace Analytics, select Analyze > Queries > Meeting.
  2. 选择此处并将 " 输入查询名称 " 更改为 长时间定期 Ops 会议Select and change Enter query name here to Long recurring Ops meetings.
  3. 对于 " 分组依据",选择 " 星期"。For Group by, select week.
  4. 输入所需的 日期范围Enter the Date range you want.
  5. 对于 会议排除项,请选择此查询的排除规则。For Meeting exclusions, select an exclusion rule for this query.
  6. 若要添加自定义筛选器以仅包括至少有一个与会者的会议,请在 " 筛选器" 下,选择 " 添加筛选器",选择 " 与会者",然后选择 " 函数 > 等于 > 操作"。To add a custom filter to include only meetings with at least one attendee from Operations, under Filters, select Add filter, select Attendee, and then select Function > equals > Operations.
  7. 若要添加自定义筛选器以仅包含两个小时或更长时间的会议,请选择 + (加号) 添加另一个筛选器,然后选择 "会议 > 持续时间 (以小时为单位,) > 大于或等于 > 2"。To add a custom filter to include only meetings that are two hours or longer, select the + (plus sign) to add another filter, then select Meeting > Duration (in hours) > greater than or equal to > 2.
  8. 若要添加自定义筛选器以仅包含定期会议,请选择 + (加号) 添加其他筛选器,然后选择 "会议 > IsRecurring > 等于 > True"。To add a custom filter to include only meetings that are recurring, select the + (plus sign) to add another filter, then select Meeting > IsRecurring > equals > True.
  9. 若要为与会者数量添加指标,请在 "指标" 中,选择 " 添加指标"。To add a metric for the number of attendees, in Metrics, select Add metric.
  10. 选择 " 与会者",然后选择 "名称" 并将指标的名称更改为 " 与会者总数"。Select Attendees, and then select and change the metric's name to Total attendees.
  11. 若要为与会者的总会议时间数添加一个指标,请选择 "添加指标 > 会议时间",然后选择 "指标" 的名称并将其更改为 "与会者会议总小时数"。To add a metric for the total meeting hours of attendees, select Add metric > Attendee meeting hours, and then select and change the metric's name to Total attendee meeting hours.
  12. 在 " 组织数据 " 部分中,您可以选择要在输出 ( .csv) 文件中包含的数据列。In the Organizational data section, you can select what data columns to include in the output (.csv) file. 选择 " 全部清除 " 以清除所有选定列,然后选择要从列表中包含的列。Select Clear all to clear all selected columns, and then select which columns you want to include from the list. 使用 " 全选 " 可包含默认的所有列。Use Select all to include all columns, which is the default.
  13. 选择右上角的 " 运行 " 以运行查询。Select Run at the top right to run the query.
  14. 在 "查询 > 结果" 页上,查询状态显示为 "已提交"。On the Queries > Results page, the query status shows as Submitted. 在查询状态更改为 " 成功" 后,您可以查看、共享、下载 (.csv 文件格式) 、删除或 复制 OData 链接 以在可视化工具中使用,例如 Power BI 或 Excel。After the query status changes to Succeeded, you can view it, share it, download it (in .csv file format), delete it, or Copy an OData link to use in a visualization tool, such as Power BI or Excel.

会议查询结果Meeting query results

每个数据行都代表一个会议。Each row of data represents a single meeting. 您可以选择要在查询结果的列中包含以下哪些信息:You can select which of the following information to include in the columns of the query results:

  • IsCanceledIsCanceled. 会议是否已取消Whether the meeting was canceled, or not
  • DurationHoursDurationHours. 会议的长度(以小时为单位)The length of the meeting, in hours
  • IsRecurringIsRecurring. 会议是否为定期系列的一部分,或者不是Whether the meeting is part of a recurring series, or not
  • 主题Subject. 会议邀请的主题行Subject line of the meeting invitation
  • TotalAcceptTotalAccept. 接受会议的被邀请者人数The number of invitees who accepted the meeting
  • TotalNoResponseTotalNoResponse. 未响应的被邀请者数量The number of invitees who did not respond
  • TotalDeclineTotalDecline. 拒绝会议的被邀请者的数量The number of invitees who declined the meeting
  • TotalNoEmailsDuringMeetingTotalNoEmailsDuringMeeting. 会议期间与会者发送的电子邮件数The number of emails sent by attendees during the meeting
  • TotalNoDoubleBookedTotalNoDoubleBooked. 已预订的受邀人数The number of invitees who were doubled booked
  • MeetingResourcesMeetingResources. 会议室的主 SMTP 地址的别名部分。The alias portion of the meeting room's primary SMTP address. (多个会议室,请使用以分号分隔的列表。 ) (For multiple rooms, use a list delimited by semi-colons.)
  • TotalNoAttendees 参加会议的人员数TotalNoAttendees The number of people who attended the meeting
  • 会议 IDMeeting ID. 会议的唯一 ID 号A unique ID number of the meeting
  • 开始日期和时间Start Date and Time. 会议启动时When the meeting started
  • 会议资源 Id 计数Meeting Resource Ids Count. 为每个会议保留的会议室数The number of meeting rooms reserved for each meeting
  • 指标Metrics. 您在查询中包括的任何其他指标Any other metrics that you included in the query

会议查询结果示例Example meeting query results

会议 IDMeeting ID "开始日期"Start Date 持续时间(小时)Duration Hours 定期发生Is Recurring 已取消Is Canceled 会议过程中发送的电子邮件总数Total # of emails sent during meeting 主题Subject 指标-与会者数Metrics - Number of Attendees
M1M1 04/21/2020 5:00PM04/21/2020 5:00PM 1 1 No No 10 10 产品演示Product demo 10 10
M2M2 04/22/2020 3:00PM04/22/2020 3:00PM 2 2 Yes No 4141 营销会议Marketing meeting 15 15