YammerGroupsActivityDetail
Returns detailed analytics on activity across Yammer groups, including post volume, member participation, and engagement rates, grouped by Yammer group.
Select
The add-in uses the Microsoft Exchange API to process WHERE clause conditions built with the following columns and operators:
- Period supports the '=' operator.
- Date supports the '=' operator.
The rest of the filter is executed client-side in the add-in.
At a minimum, a Date or Period column is required to get the report data. By default, the driver makes a request of the period as D7 if no filter is specified.
For example, the following query is processed server-side:
SELECT * FROM YammerGroupsActivityDetail WHERE Period = 'D7' SELECT * FROM YammerGroupsActivityDetail WHERE Date = '2023-04-19'
Columns
| Name | Type | Description |
| ReportRefreshDate | Date | The date when the Yammer group activity report was last refreshed. Represents the latest available snapshot of group-level metrics. |
| GroupDisplayName | String | The name of the Yammer group as displayed in the user interface. This is the public or internal name shown to users. |
| IsDeleted | Boolean | Indicates whether the Yammer group has been deleted. A value of true means the group is no longer active or accessible. |
| OwnerPrincipalName | String | The user principal name (UPN) of the person who owns or administers the Yammer group. Typically displayed in email format. |
| LastActivityDate | Date | The most recent date when any member of the group performed an activity such as posting, reading, or liking messages. |
| GroupType | String | Specifies the type of Yammer group. Common values include Private, Public, and Secret, which determine group visibility and access. |
| Office365Connected | String | Indicates whether the Yammer group is connected to a Microsoft 365 group. A connected group integrates with services like SharePoint, Outlook, and Teams. |
| MemberCount | Integer | The total number of active members in the Yammer group at the time of reporting. |
| PostedCount | String | The total number of messages or posts created in the Yammer group during the reporting period. |
| ReadCount | String | The total number of messages viewed by group members during the reporting period. Helps indicate engagement level. |
| LikedCount | String | The total number of posts that received 'likes' within the Yammer group during the reporting window. |
| ReportPeriod | Integer | The duration of the reporting period, in days. Typical values are 7, 30, 90, or 180, indicating how far back activity is measured. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Period | String | Specifies the standardized aggregation range for the report. Accepted values include D7, D30, D90, and D180, where Dn represents the number of days.
The allowed values are D7, D30, D90, D180. The default value is D7. |
| Date | Date | The specific date (formatted as YYYY-MM-DD) for which activity data is returned. Only dates from the past 30 days are supported in this report. |