Glossary

Host site for a Users One Drive files. Historically it has held other artifacts. Users could go and create libraries, blogs or other SharePoint classic concepts.

Analyst accessed the OData link for a query.

An access request to a site, folder, or document was accepted and the requesting user has been granted access.

User requests access to a site, folder, or document they don't have permissions to access.

An access request to a site, folder, or document was denied.

An access request to an item was updated.

All guest users who were active for the report period and are also flagged as activebased on todays user data. Used in the site collection activity table to display the number of Site Collection Guests simply titled 'Guests.'

All internal users who were active for the report period and are flagged as having an active active directory account (have not had their active directory account deleted or inactivated). Used in the site collection activity table to display the number of Site Collection users simply titled 'Users.'

Number of active Yammer user accounts for a specified timeframe.

'SharePoint Site Activity'[Active Files] + 'SharePoint Site Activity'[Page Views]

A descpription of the activity that took place. This includes everything from users being added to a group, checking files in/out, sharing policy/invitation changes and more.

All drive activities where the object was a file. Total Activities where 'Activity Type' [Object Type] = File

All file activities where the activity was from automatic syncronization.

A grouping of activity types into three main categories: Sharing, System, and Usage. This can be used to quickly filter down activity types or can be added to a visualizations 'legend' to make the grouping clear and colour coded.

User added a member or guest to a SharePoint group. This might have been an intentional action or the result of another activity, such as a sharing event. For details check out this Microsoft article(...)

A user was added to the list of entities who can use a secure sharing link.

The total groups that a user is a Group Administrator of in Yammer. This is great for counting groups that are administrated by each user, and flagging users who are group admins. This visual can be found on the Group Activity page of most Yammer reports.

All Activity = [Email - User Activities] + [Teams - All Messages] + [SharePoint - User Activities] + [OneDrive - User Activities] + [Skype - Sessions] + [Yammer - User Activity]

Total files for the selected site or site collection.

All Users who are from outside of the organization'stenant. Any users with the #ext added to their name are external to the tenant and are included within this total.

All Users from within the companies tenant. Any users with the #ext added to their name are external to the tenant and are not included within this total.

The total SharePointactivities captured by the tyGraph Harvester for the report period. These activities inlcude the following:AccessRequestCreated, AddedToSecureLink, AnonymousLinkCreated, AnonymousLinkRemoved, AnonymousLinkUsed, CompanyLinkCreated, CompanyLinkUseds, FileAccessed,(...)

Total site collections.

Total sites

Calculation = [Likes] + [Posts] + [Reads].

Display page for lists and libraries. This is not unique to a particular list or library. When analyzing "Object Name" we recommend you do it in the context of a single site or with the "Object Path" included in the visual othewise you are seeing activity for the all items page across(...)

A SharePoint or global administrator added an allowed data location in a multi-geo environment.

A SharePoint or global administrator removed an allowed data location in a multi-geo environment.

Site administrator or owner adds a permission level to a site that allows a user assigned that permission to create a group for that site.

Anonymous users are users who have a shareable link to a folder or document and can view or edit the document or upload to the folder (depending on the type of link) without having to log in with a username or password. Anonymous links can be freely passed around between users and are valid(...)

User created an anonymous link to a resource. Anyone with this link can access the resource without having to be authenticated.

User removed an anonymous link to a resource. The link can no longer be used to access the resource.

User updated an anonymous link to a resource. The updated field is included in the EventData property when you export the search results.

An anonymous user accessed a resource by using an anonymous link. The user's identity might be unknown, but you can get other details such as the user's IP address.

Total attachments added to messages. This can be pivoted by the message, user, date and group (both public and private).

You can share sites, files, and folders with users who have a Microsoft Account or a work or school account from another Office 365 subscription in much the same way that you share sites and documents with your internal users. Permissions and groups work the same for authenticated external(...)

You can share files and folders with anyone who has an email address. If the person you're sharing with doesn't have a Microsoft Account or a work or school account, they will be sent a one-time access code for authentication each time they access the file or folder. You can't share sites with(...)

The average time between each message in a thread including the initiating message. This can be aggregated at the Channel or Team level. Example: John posts on 1 Dec gets a reply on 2 Dec, and then a user comments again on 7 Dec, the Avg = (1+6)/2 = 3.5. The average is NOT the difference(...)

The total time in days between responses in Yammer for the previous days to the current report period. If you're filtered to the last 7 days then the previous period is the 7 days prior to the last date of your current period. For example March 25th - March 31st. Previous period would be March(...)

The average number of days that passed before a thread or group of threads received a response.

The average days to respond divided by the average days to respond across all groups in the dataset.

The average days to respond for all groups regardess of your group filtering selection

This is the same as the Avg. Days to Respond POP but with an up and down arrow KPI Indicator

The longest avergage days to respond for a thread or group. We use this for the max value on guage visuals.

The percentage change of average days to respond for the current report period compared to the previous period.

Average days to respond but down to the hour, This is only for those of you who like to be extra precise!

A hidden tyGraph measure calculating the average number of Thread Views for all conversations in each group.

A tyGraph tool that anonamously aggregates and displays basic network statistics for the use of comparison and goal setting. This allows customers to benchmark scores like Engaged Members %, Engaged Groups, and MAE Score with customers of similar charictaristics anonymously. This program is(...)

A user adds a bot to a team.

A user removes a bot from a team.

A compontent of the Influencer Score. This is the number of groups that you have contributed to for the report period multipiled by 100 to make it relative to other scores in the Influencer Score.

Breadth Points measures the extent of a users channel participation. The more channels that a user has joined the higher their Breadth Points. Breadth Points = Sum of User Channels

Analyst canceled a running query.

The month over month difference in engaged members expressed as a percentage. This metric is intended for time series visualizations and therefore should always be pivoted on Month Year Short or an equivalent time intelligence axis or row context.

The difference in engaged members from the previous full month and the month prior to the previous full month expressed as a percentage. Example. On 14 October the metric would calculate the difference in engaged members for the month of August compared to the month of September. This is best(...)

The month over month difference in MAE Score expressed as a percentage. This metric is intended for time series visualizations and therefore should always be pivoted on Month Year Short or an equivalent time intelligence axis or row context.

The difference in MAE Score from the previous full month and the month prior to the previous full month expressed as a percentage. Example. On 14 October the metric would calculate the difference in engaged members for the month of August compared to the month of September. This is best(...)

The month over month difference in messages expressed as a percentage. This metric is intended for time series visualizations and therefore should always be pivoted on Month Year Short or an equivalent time intelligence axis or row context.

The difference in messages from the previous full month and the month prior to the previous full month expressed as a percentage. Example. On 14 October the metric would calculate the difference in engaged members for the month of August compared to the month of September. This is best(...)

A user adds a channel to a team.

A user deletes a channel from a team.

Total number of teams channels on the network. Currently this is based on a the current date and is not historic. This can be pivoted on Member Name to reflect the number of channels to which each user is a member.

The specific type of platform used to send a yammer message. A subsection of client type group, allowing a drilldown into client type group. Categories include: Android, Chrome Extension, Email, iPhone, TripIt, Twitter, unknown, Web, Windows 8, Windows Phone, etc. A great use of Client type(...)

A summary of Client Type. Groups all Client Types into four major categories: Web, Email, Mobile, and Other. This allows for convenient comparison of message posting patterns within your network. Though this visual is often seen categorizing messages posted, it can be used with metrics such as(...)

User created a company-wide link to a resource. company-wide links can only be used by members in your organization. They can't be used by guests.

User removed a company-wide link to a resource. The link can no longer be used to access the resource.

User accessed a resource by using a company-wide link.

A document that was classified as a record was deleted. A document is considered a record when a retention label that classifies content as a record is applied to the document.

A retention label was applied to or removed from a document. This event is triggered when a retention label is manually or automatically applied to a message.

When two or more filters compound with each other in a PowerBI report to prodouce an overall filter result unintended by the user (usualy all blanks). When two or more filters are applied simultaniously the report will return data that fits the criteria for both. Example: a report level(...)

A user adds a connector to a channel.

A user removes connector from a channel.

A user modified a connector in a channel.

Sum of passive actions made by a user in Yammer. The total of this value is used for the lurker ratio. Consumption Score = Message Likes + File Downloads + File Views + Note Views. This score is the nominal component used to account for passive actions taken on the network, also known as(...)

The category of a given file. Example: application, video, image etc. An example of the difference between the content type and file type is, an application that is uploaded as a .txt file. Content type would designate it as an application but the file type remains a document.

This is a subscore (component of the Influencer Score) that weights a users contribution by assigning weighting to conversational actions. Threads = 2 Points, Messages = 1 Point, Likes = 0.5 Points. Contribution Score = (Threads* 2)+ (Messages)+ (Likes* 0.5)

A weighted total of points given to a user for contributing content in conversations. Where Announcements are worth3 Points,Threads Initiated 2 Points, Replies, Praises, and Shares are worth 1 Point, and Likes are worth 0.5 points.

Sum of concerted actions made by a user in Yammer. The total of this value is used for the contribution component of the Lurker ratio. Contribution Score = Messages + Message Shares + Topic Mentions + User Mentions + User Praises + File Uploads + Notes. The goal of this score is to separate(...)

Date and time the group was created at in the format YYYY-MM-DD HH:MM:SS. Useful for reference when analyzing the lifespan of a group.

The date that the site was created

Date that the corresponding network was created.

The exact date and time when the thread was created, formatted as YYYY-MM-DD HH:MM:SS.

The ability to filter all of the visuals on a Power BI page by selecting a datapoint on a neighboring visual. Example: Selecting Dean Swann on the Influencer bar chart, will filter all other visuals on the tab to Dean Swann (where visual interaction is selected, see visual interactions for details).

Number of users that currently have an active Yammer account. I.e. not suspended, deleted, or pending. Not time sliceable.

A SharePoint or global administrator customized the list of exempt user agents in the SharePoint admin center. You can specify which user agents to exempt from receiving an entire web page to index. This means when a user agent you've specified as exempt encounters an InfoPath form, the form(...)

Verified admin exports Yammer network data. Only verified admins can perform this operation.

Unique dates. Ranging from Network Create Date to present day.

An integer created based on Date field in YYYYMMDD format. Used to join all other tables with Date fields.

Day value of date.

Day of the week for given date value.

Day of week represented with a numeric value. Example: Wednesday =4, Saturday =7.

A comprehensive document outlining the features we added in our Dec 2019 release!

A comprehensive document outlining the features we added in our Dec 2019 release!

A comprehensive document outlining the features we added in our Dec 2019 release!

A comprehensive document outlining the features we added in our Dec 2019 release!

A column in the messages table that showsmessages that identifies if the message has notbeen deleted in Yammer. So if this flag is "True" then the message has not been removed. For users looking to see what messages have been deletedselect "False" for this column.

Analyst deleted a query result.

An optional field where a users company department can be entered. Useful for the management of combined operations between departments.

DTS = ((DTS - Email]*1)+([DTS - OneDrive]*3)+([DTS - SharePoint]*3)+([DTS - Skype]*3)+([DTS - Teams]*5)+([DTS - Yammer]*5)

The domain from the user's email address, typically the company website.

Analyst downloaded a query result file.

Total drives in the tenant or selection. This measure can be seen on the OneDrive Overview page where it is used as the baseline of the Engaged Drives guage.

The total days that a user has sent or recieved email multiplied by one.

Total days that a user has had one drive activity multiplied by three.

The total daysthat eachuser has taken an action in SharePoint multiplied by three. The SharePoint activities considered in this measure is File Views/Edits, Files Shared Externally, Files Shared Internally, Files Synced, Pages Visited.

The total days that each user has taken an action in Skype multiplie by three (see DTS weighting image for overview). ASkype activity is defined as when Total Sessions is >0. See the 'Skype Sessions Table' in Power BI for details.

This is the total days for each user that has taken an action in Teams multiplied by five. For this measure Teams activity is defined as when a user has any chat messages, meetings, private messages, or voice calls. For details see the Teams Activity table. For an overview see the DTS(...)

This is the total days for each user that has taken an action in Yammer multiplied by five. For this measure Yammer activity is defined likes, reads or posts. For an overview see the DTS Weighting visual.

The total of all selected Dynamic Actions. This measure is important because you can shape your engagement metrics based on activities that you value. See the Metricsetrics slicer in the left pane of your default report pages.

Total files downloaded. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.

Total downloads where only the first download per user per file is counted. This is better if you want to reduce the weighting of downloads in your engagement measure and thereby reduce volitility in the MAE Score. This measure is dynamic because can be toggled in or out of the reports using(...)

Files uploaded to Yammer. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.

Total file view activities in Yammer. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.

Total file views where only the first view per user per file is counted. This is better if you want to reduce the weighting of downloads in your engagement measure and thereby reduce volitility in the MAE Score. This is especially popular where communications teams are only interested in the(...)

Total likes. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.

The total of all selected MAE Actions. This measure is important because you can shape your engagement score based on activities that you value. See the MAE Score slicer in the left pane of your default report pages.

Total mentions. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.

Total shares. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.

Total messages. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.

Total hashtags or topics used in a thread. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.

Total hashtags or topics used in a thread. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.

Total notes. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.

Total praises. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.

Total hashtags or topics used in a thread. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.

Email address of the given user

[Email - Active Users] / [Users - AllActive. Where "Email - Active Users" is all users who have sent or received an email for the report period, and "Users - Active Users" are any user with Office 365 activity for the report period and an Active Directory login.

A distinct count of users who have had any Email Activity for the report period as defined by the "Email - User Activities" calculation. Essentially the total unique users who have sent or recieved email for the report period.

Email of the user in the custom member list. Often used as an ID.

The total "items" in mailboxes based on the most recent record for each user in the filtered set.

Calculation = 'Email Activity'[Received]+ 'Email Activity'[Sent]. This is used to measure the total amount of email traffic by user or work group. There is no distincion made between the sender or the recipient for tyGraph Pulse. For details on email traffic interactions see the tyGraph for(...)

Calculation= [Email - Storage (GB)] / [Email - Storage Limit (GB)]. Where "Email - Storage (GB)" and "Email - Storage Limit (GB)] is based on the most recent record for that userin the report time frame.

Total devices utilzed by users given the most recent record for each user.

Total users/mailboxes with Mailbox usage for the report period.

Most recent activity date for a user or aggregate of users. Though perhaps self explanitory this measure is very helpful for determining unused accounts within work groups or divisions.

Calculation ='Email Activity'[Reads] / 'Email Activity'[Received]. Often refered to as the "open rate" by email marketers this measure allows you to see what percentage of emails a user is actually opening. Analysts also like to evaluate this on aggregate and over time to look for changes in(...)

Total emails opened. This does not indicate that the user actually read the content or spend any set period of time on the given email message.

Total emails receieved. Often pivoted on a user or work group.

Total emails sent. Where: "Send actionsis the number of times an email send action was recorded for the user." (full url to the microsoft docsin item url)

Calculation ='Email Activity'[Sent] / 'Email Activity'[Received]

Total email storage based on the most recent records for each mailbox.

The total or singular mailbox storage limit based on the "Prohibit send receive quota." The "Prohibit send receive quota (MB) refers to the storage limit when the mailbox can no longer send or receive emails. If your organization's policies prevents you from viewing reports where user(...)

Email storage based on the most recent record for each mailbox, expressed in terabytes.

Calculation = 'Email Activity'[Reads] + 'Email Activity'[Sent]

The distinct users who have had email activity recorded for the report period.

The number of engaged members represented as a percentage of the total group members. This metric is unique from Engaged Members, in that it excludes users who are not a member of the filtered group or not a member of any group at all. For example, in a group with 100 members, if 50 of them(...)

Unique group members who have taken one of your selected MAE Actions over all users currently in that group.

Total unique users who have taken one of your selected MAE Actions within a group.

Engaged Group members % POP but with an up and down arrow KPI Indicator

The percentage change in engaged group members from the previous period to the current. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your current(...)

The number of engaged group members from the previous period. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your current period. For example March 25th(...)

A count of all groups (for the defined time period) that generated activity (MAE points) and therefore are classified as engaged. The engaged classification is assigned to any group that has had activity that would generate a MAE value. This is time sliceable, meaning that it is possible for a(...)

The number of engaged groups expressed as a percentage of the total number of groups on the network. See Engaged Groups for details on what defines an engaged group.

The unique number of groups who have had any one of your selected MAE Score actions within the report period.

Same as engaged groups % but with a an up and down arrow KPI Indicator

The percentage change in engaged groups based on your MAE Score Selection but with an up and down arrow KPI Indicator.

Percentage change of engaged groups from the previous period to now. The goal is to be increasing or maintaining this percentage. To increase your percentage consider deleting/archiving in active groups. Another way to drive adoption is to add users, content, or influencers to your failing(...)

The percentage change in engaged groups based on your MAE Score Selection.

Engaged groups for the previous period. The previous period is the same span of dates immediately before your report period. For example, if you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your current period. For example March 25th - March(...)

The number of engaged groups from the previous period. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your current period. For example March 25th -(...)

A classification assigned to any unique user who has had activity that would generate a MAE value. This is time sliceable, meaning that it is possible for a user who is no longer part of the organization to be listed as an engaged member if your timeframe includes dates when they were active(...)

The number of engaged members divided by the number of registered members for the report context. Engaged members are any user who has taken at least one action for the report period. A registered member is any user who has joined the network and has not been suspended or deleted in the given(...)

The number of unique user who have taken any one of your selected MAE Score acts of engagement for the current report period.

Engaged members over total group members. This helps you understand what percentage of users are engaged out of the people who have actually joined the group. If this percentage is over 100% then it means that users are engaging in the group without joining it. This can only happen in public(...)

The percentage change in engaged members but with an up and down arrow KPI Indicator

The percentage change in engaged members who took any one of your selected MAE Score acts of engagement in the current report period.

Engaged Members Calculation fixed to the most recent full month. Often added under the tooltips section of a visual to show the total number of engaged members for the previous month when the user hovers the cursor over a country visual. Example Oct 23 this would show total engaged members for(...)

The number of unique users who took one of your selected acts of engagement in the previous period. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your(...)

Engaged Members over all users. This is the percentage of the entire network that is engaging in a particular group. This is useful to compare across groups in your tenant to see where your overall population is spending their time.

Engaged Members Calculation fixed to the 2nd full month. Often added under the tooltips section of a visual to show the total number of engaged members for the previous month when the user hovers the cursor over a country visual. Example Oct 23 this would show total engaged members for the(...)

The unique number of users who have taken any one of your selected MAE Score acts of engagement in the current report period but are not currently members of the group.

The percentage users who are engaged in your group but haven't joined except this measure has an up and down arrow KPI Indicator

The percentage change in non members but with an up and down arrow KPI Indicator

The percentage change of users in your group who haven't bothered to join from the previous period to now. You want this percentage to go down in most cases.

The percentage change in engaged non members from the previous period to the current one.

The number of users who are engaged in your group but haven't joined from the previous period. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your(...)

The unique number of users who have taken any one of your selected MAE Score acts of engagement in the previous period but haven't joined the group. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous(...)

The number of engaged members divided by the total number of team members. This measure is great for evaluating enagement percentages within a team context instead of engaged members % because sometimes a team can have more users engaged than are actually members. If you use Engaged Members %(...)

The total number of unique teams that have had an act of engagement for the report period. This is calculated in a similar was as Engaged members where an enaged team is based on teams where there has been MAE activity greater than or equal to one

The number of engaged teams divided by the total number of teams in the report context

Analyst ran a query.

A SharePoint or global administrator added a user agent to the list of exempt user agents in the SharePoint admin center.

A Power BI feature that allows a user to export a table or visual to an excel spreadsheet. Values will be expressed in excel as a table regardless of the visualization type. Example: Bar charts will be exported with the axis and the bar values expressed in a table style.

An external user is someone from outside your Office 365 subscription to whom you have given access to one or more sites, files, or folders. There are two types of external users.

Total file activities

Unstructured subtitle entered by the user to describe the document.

A value assigned to a file for the sake of categorization and easy indexing. Ex. All files starting with the letter A will have an A in the field.

The total number of downloads made for a given time period, including multiple downloads. This is often pivoted on file name giving you file downloads per file. Can also be pivoted on Member Name or Group Name.

The mean of the total file downloads across the filtered set of files. Typically used as an average across several files in a group. Example: Pivoting file downloads average on Group Name to result with file downloads per group.

Extension that the file belongs to.

The file name that the member list is associated with

The Member Name of the user who posted the document.

Total files that were entirely downloaded as part of a one drive or SharePoint sync. User establishes a sync relationship and successfully downloads files for the first time to their computer from a SharePoint or OneDrive for Business document library.User establishes a sync relationship and(...)

Total files that were uploaded for the first time. Microsoft defines this as when the user establishes a sync relationship and successfully uploads files for the first time from their computer to a SharePoint or OneDrive for Business document library.

Total files that were entirely downloaded as part of a one drive or SharePoint sync. User successfully downloads any changes to files from SharePoint or OneDrive for Business document library. This event indicates that any changes that were made to files in the document library were downloaded(...)

Total files that were uploaded as part of a small modification or change to an existing file in the cloud. Microsoft defines this as: User successfully uploads changes to files on a SharePoint or OneDrive for Business document library. This event indicates that any changes made to the local(...)

A category of the given file. Example: document, image, video. An example of the difference between the content type and file type is, an application that is uploaded as a .txt file. Content type would designate it as an application but the file type remains a document.

Number of unique files uploaded to the network.

The total number of views a file has recieved for a given time period, including multiple views. This is often pivoted on file name giving you views per file. Can also be pivoted on Member Name or Group Name. Due to the nature that views are provided by Yammer 95% of views are collected and(...)

The mean of the total file views across the filtered set of files. Typically used as an average across several files in a group. Example: Pivoting file views average on Member Name to result with file downloads for each user.

User or system account accesses a file.

This is related to the "Accessed file" (FileAccessed) activity. A FileAccessedExtended event is logged when the same person continually accesses a file for an extended period (up to 3 hours). The purpose of logging FileAccessedExtended events is to reduce the number of FileAccessed events that(...)

User checks in a document that they checked out from a document library.

User checks out a document located in a document library. Users can check out and make changes to documents that have been shared with them.

User discards (or undos) a checked out file. That means any changes they made to the file when it was checked out are discarded, and not saved to the version of the document in the document library.

User copies a document from a site. The copied file can be saved to another folder on the site.

User uploads a file.

User deletes a document from a site.

User deletes a file from the recycle bin of a site.

User deletes a file from the second-stage recycle bin of a site.

User downloads a file.

Unique numeric value assigned by Yammer used to identify a file. Useful for searching for a specific file or guarenteeing that a visual is calculating a metric for a specific file only.

SharePoint anti-virus engine detects malware in a file.

User or system account modifies the content or the properties of a document on a site.

This is related to the "Modified file" (FileModified) activity. A FileModifiedExtended event is logged when the same person continually modifies a file for an extended period (up to 3 hours). The purpose of logging FileModifiedExtended events is to reduce the number of FileModified events that(...)

User moves a document from its current location on a site to a new location.

User previews files on a SharePoint or OneDrive for Business site. These events typically occur in high volumes based on a single activity, such as viewing an image gallery.

User renames a document on a site.

User restores a document from the recycle bin of a site.

Total files belonging to an account, app, or reader.

Number of unique files downloaded by a member or members. Often used to compare the unique number of files that a user has downloaded rather than the number of downloads made by that user.

Number of unique files viewed by a member or members. Often used to compare the unique number of files that a user has viewed rather than the number of views made by that user.

User shares a file with another user.

User establishes a sync relationship and successfully downloads files for the first time to their computer from a document library.

User establishes a sync relationship and successfully uploads files for the first time from their computer to a document library.

User changes the description of a file.

User changes the name of a file.

User uploads a document to a folder on a site.

User deletes a version from the version history of a file. The deleted version is moved to the site's recycle bin.

User deletes all minor versions from the version history of a file. The deleted versions are moved to the site's recycle bin.

User deletes all versions from the version history of a file. The deleted versions are moved to the site's recycle bin.

User views a file.

A binary value used to remove anomalous files that dampen the true signal of a network. By default no files are filtered out, though tyGraph Admins may provide a list of files to flag as outliers.

User copies a folder from a site to another location in SharePoint or OneDrive for Business.

User creates a folder on a site.

User deletes a folder from a site.

User deletes a folder from the recycle bin on a site.

User deletes a folder from the second-stage recycle bin on a site.

User modifies a folder on a site. This includes changing the folder metadata, such as changing tags and properties.

User moves a folder to a different location on a site.

User renames a folder on a site.

User restores a deleted folder from the recycle bin on a site.

A users first and last name.

A SharePoint or global administrator added a user as a geo admin of a location.

A SharePoint or global administrator removed a user as a geo admin of a location.

A SharePoint or global administrator configured the storage quota for a geo location in a multi-geo environment.

The single user who founded a given group. Often used to find users on a network who are creating the most groups by pivoting groups on Group Creator and sorting by groups.

The email of the group creator. Useful for creating a table of Group Name and Group creator email for export (see Export data) and generating mass emails to group creators of a collection of groups. Example group creator emails of groups where the last message posted has been greater than a(...)

Displays the URL to a given groups delete options page in Yammer. If the user clicks on the displayed URL in tyGraph their a new browser window will open to the delete settings of that particular group.

A phonebook style value assigned to a group for the sake of categorization and easy indexing. Example: 'tyGraph for Yammer' group will have a T in the field. Example #2: 'The Yammer Champs' group would be categorized by T.

Basically the group url. We call it Group Feed URL so you can distinguish between this and the Group Settings URL or the Group Delete URL. Use this if you want a url taking you straight to the group from the report.

Uniquely identifies a group. Used for associating items like messages, threads, files, notes, and activities to a particular group.

A column in the Group Membership table of known Joined Dates for Yammer group members. The Joined Date is a column is taken from the Yammer Activity News Feed. It is backfilled into the group members table independently after group members have already been collected.

The total number of members that have joined a group and are currently a member. Often pivoted on Group Name or Group ID to show the number of members in a group. If this measure is pivoted on Member Name or User ID it will 1 for all users who have joined at least one group. (See 'Member(...)

Unstructured title assigned by the user to identify a group.

The general access guide for the group report. This report is availible through tyGraph Online only.

Displays the URL to a given groups settings page in Yammer. If the user clicks on the displayed URL in tyGraph a new browser tab/window will open to the settings of that particular group so long as that user is logged into Yammer and has permissions for that group.

Site administrator or owner creates a group for a site, or performs a task that results in a group being created. For example, the first time a user creates a link to share a file, a system group is added to the user's OneDrive for Business site. This event can also be a result of a user(...)

User creates a group.

A group is deleted from Yammer.

User deletes a group from a site.

The total number of groups on the Network. Often used as a baseline for other metrics or visuals. Example: The Engaged Groups gas guage.

The total number of groups that are SharePoint connected. The column that defines this for each group can be found in the'Office Groups' table under the [SharePoint Connected] column.

Calculation = [Groups - Public] / [Groups - Number of Groups]. This is a great measure for organizations encouraging work groups to work out loud by having public groups availible for the organization.

Site administrator or owner changes the settings of a group for a site. This can include changing the group's name, who can view or edit the group membership, and how membership requests are handled.

Total user logins where the user is a guest. Compared to other metrics this includes both active and inactive users.

The date of the most recent message currently in the dataset expressed in UTC. It is important to note that this date will not move forward if the tyGraph harvester collected no new messages on a particular day. This is more likely for small networks that generate no new messages especially on(...)

Value indicating users who have not changed their default Mugshot

An export of every help tip from our Microsoft Teams product. This document includes the help tip pop up that coincides with every visual for every page.

Can be found in the tyGraph for Yammer Dec 2019 report update. This shows interactions between users across groups between users where the size of a users dot is their influencer score and the strenth of the bond is the number of interactions they've had with each other. A user interaction is(...)

A SharePoint or global administrator changes the designated site to host personal or OneDrive for Business sites.

A site owner associates their site with a hub site.

A SharePoint or global administrator deleted an orphan hub site, which is a hub site that doesn't have any sites associated with it. An orphaned hub is likely caused by the deletion of the original hub site.

A SharePoint or global administrator creates a hub site. The results are that the site is registered to be a hub site.

A site owner disassociates their site from a hub site.

A SharePoint or global administrator unregisters a site as a hub site. When a hub site is unregistered, it no longer functions as a hub site.

A score that evaluates the impact of a user in a network, team, or channel. The more that collegues mention, reply to, or like messages by the user, the higher their score. Impact Points = [Replies by Others] + [Likes Recieved] + [Mentions Recieved]

This is is a sub component of the Influencer Score which applies points to actions that have impact on the network. Impact score is the only score that is entirely out of the users control in that all of the activities that it counts are done by other users interacting with the users content.(...)

Number of days that the site has been inactive. Note that this is based on the most recent harvest date.

A little slideshow put together by the team to help unpack the Influencer Score

This score applies a weighting of a users activity in teams to place value on collaborative actions rather than the raw nominal amount of actions that the user is taking. The score is usually used for ranking within a group or network context to find users of most influence in their community.(...)

Full name and Yammer ID of the user that UserUID (Member Name from User's table) has interacted with

Type of interaction; user like, message post(reply) or user mention.

An interaction is messages, likes, or mentions between you and others inside a conversation.

Total number of users who are from the home company that owns the site.

Flag for users who are from another tenant.

An "Is recommended" conversation is a thread where the Sentiment Score is low (less than 0.25) and the thread has been viewed by more users than usual for that group. We combine this with the unanswered threads to show conversations that have not been answered and fit this criteria. This often(...)

A binary (true/false) value indicating if the messages is active, i.e. not deleted.

A binary value that identifies networks that are not restricted to a common email domain. "Membership, messages and other data in the Community are completely separate from membership, messages and data in the parent company network; users must toggle between networks to access these separate(...)

A binary (true/false) value that indicates if a message was a direct message.

A flag for External Yammer Groups

A true/false categorization to identify files vs folder.

A binary (true/false) value that identifies the "user has #joined your network" messages.

Indicates if the praised user is a network admin.

A binary variable indicating if the note was marked as an official note on the network.

A binary (true/false) value indicating if a message is posted in a private group or as a direct message.

A binary (true/false) value indicating if the message is a share of another message.

A binary value indicating if a thread is generated by the system, i.e. "so-and-so user has joined your network"

A binary (true/false) value that indicates if the message was the first post of the thread; the thread starter.

A binary value indicating if a user's account is authorized the additional privileges of a Verified Administrator.

A binary value that identifies if the given topic was created as part of a "YamJam" event. tyGraph Admin needs to provide the list of Topics to be flagged as YamJams.

The company position or job title of the respective user.

Dean highlights five important keys to unlocking insights about your Yammer network. Looking for more information about tyGraph for Yammer? See tygraph.com or email us at tyGraph@unlimitedviz.com.

A grouping for inactive days made for easy toggling between activity ranges. This includes timeframes like 0-3 Months, Over 1 year etc.

A categorical variable assigned to group when the last message was posted at. Possible categories are: Zero messages 0-3 Months Ago, 3-6 Months Ago, 6-12 Months ago, Over 1 Year Ago.

The last date that the library item was modified.

The most recent activity date in the dataset.

Site administrator or owner adds the SharePoint 2013 Workflow Task content type to the site. Global administrators can also enable work flows for the entire organization in the SharePoint admin center.

The total number devices activated. This measure is based on the[Devices Activated] column in the Office Activations table.

A distinct count of all licensed users. Taken from the 'Product Plan Assignments' table.

A count of all Product Plans. Based on the Plan ID column in the 'Product Plans' table.

Total user licenses where the user has not been suspended or deleted. Total taken from the[Licenses] column in the'User Licenses table.

Number of likes on messages.

The total number of likes divided by the total number of messages for a selected filter range. Often pivoted on a group or thread to guage the popularity of messages and to quickly identify likely areas of collaboration.

Number of likes on a users messages.

A user deleted a SharePoint list column.

A user deleted a SharePoint list item.

Complete url of the given list

A user created a SharePoint list column. A list column is a column that's attached to one or more SharePoint lists.

A user updated a SharePoint list column by modifying one or more properties.

A user created a list content type. A list content type is a content type that's attached to one or more SharePoint lists.

A user deleted a list content type.

A user updated a list content type by modifying one or more properties.

A user created a SharePoint list.

A user deleted a SharePoint list.

A user created an item in an existing SharePoint list.

A user moved a SharePoint list item to the Recycle Bin.

A user restored a SharePoint list item from the Recycle Bin.

A user updated a SharePoint list item by modifying one or more properties.

A user restored a SharePoint list from the Recycle Bin.

A user updated a SharePoint list by modifying one or more properties.

A location provided by an HR Integration with the tyGraph dataset. Usually location is broken down into City, State/Province, Country, or Office Location.

The record status of a retention label that classifies a document as a record was locked. This means the document can't be modified or deleted. Only users assigned at least the contributor permission for a site can change the record status of a document.

The total consumption score divided by total overall contribution on the network (sum of contribution and consumption score). Lurker Ratio = Consumption Score /(Contribution Score+ Consumption Score). This is pivoted on Member Name in the content consumption page. Not to be confused with the(...)

The total number of users who have had activity without interacting with people.

Median MAE score across all groups for a specified timeframe. Excludes All Company and Direct Messages.

The total MAE score continually calculated to account for the cumulative MAE as it was generated for any given point in time.

Measure of Active Engagement: Users take actions on Yammer and these actions are measures of engagement. This includes the following 12 metrics: Messages, Message Likes, Message Shares, Topic Mentions, User Mentions, User Praises, File Uploads, File Downloads, File Views, New Notes, Note(...)

This is a MAE Score that uses Unique User Downloads, and Unique User File Views instead of the total downloads and file views. Calculation = [Messages]+[Likes]+[Message Shares]+[Topic Mentions]+[Mentions]+[Praises]+[File Uploads]+[File Downloads (unique)]+[File Views (unique)]+[Notes]+[Note(...)

MAE Score Calculation fixed to the most recent full month. Often added under the tooltips section of a visual to show the total MAE generated for the previous month when the user hovers the cursor over a country visual. Example Oct 23 this would show total MAE for the month of September.

A total of activities taken in teams. MAE Score = [Messages]+[Likes]+[Mentions]

MAE Score Calculation fixed to the 2nd full month. Often added under the tooltips section of a visual to show the total number of MAE generated for the previous month when the user hovers the cursor over a country visual. Example Oct 23 this would show total MAE for the month of August.

Analyst created a meeting exclusion rule.

A phonebook style value assigned to a members first name for the sake of categorization and easy indexing. Example: A member with first name of William would be summarized with the letter W.

A categorical variable assigned to summarize the number of members in a given group. This allows for the easy grouping of small, midsized and large Yammer groups. The 4 main groups are: N/A, 0-1, 2-9, 10-50.

A total number of groups of which a user is a member. Often pivoted on Member Name or User ID.

A phonebook style value assigned to a members last name for the sake of categorization and easy indexing. Example: A member with last name of Johnson would be summarized with the letter J.

The title or grouping assigned to a customized group of users. The Custom Member List (CML) offers a fast way of filtering more than two users. CMLs are assigned a name that corresponds to the team they represent. This allows the analyst to quickly select all users be removed or isolated for(...)

The first and last name of the user followed by their Yammer User ID in square brackets.

A team owner adds members to a team.

A team owner removes members from a team.

A team owner changes the role of members in a team. The following values indicate the Role type assigned to the user.

A binary value indicating if the given thread has user mentions.

The first and last name of the user who was mentioned followed by their Yammer User ID in square brackets.

Total number of at mentions from conversations. Depending on the context this measure can be used to show mentions received, given, or as a total of a aggregate such as group.

The number of @ mentions that a user has received from conversationsin the report period.

Unstructured data entered by the user to convey an idea. The first 100 characters of the contents of a message.

Unique number of members that posted any type of message on the network; including direct messages.

Number (and name) of files associated to a message.

Number of likes on messages.

A single message can be shared multiple times. This is a calculation of the number of times a private message has been shared; includes both direct messages and private group messages.

Number of times a public message has been shared.

Total number of times a message has been shared.

User deletes a message.

Unique numeric value assigned by Yammer that uniquely identifies a message.

Number of messages posted on the network; includes threads and replies for public group, private group, and direct messages.

Total number of messages per users for the given filter context. Included any type of post.

Average number of messages per day; includes any type of post.

Messages Calculation fixed to the most recent full month. Often added under the tooltips section of a visual to show the total number of messages for the previous month when the user hovers the cursor over a country visual. Example Oct 23 this would show total messages for the month of September.

Number of private messages posted on the network; includes threads and replies for private group and direct messages.

Number of private messages posted in a direct chat conversation.

Number of private messages posted in a private group.

Number of private messages posted on the network; includes threads and replies for public group messages.

Unique number of messages shared.

Messages Calculation fixed to the 2nd full month. Often added under the tooltips section of a visual to show the total number of messages for the previous month when the user hovers the cursor over a country visual. Example Oct 23 this would show total messages for the month of August.

A categorical value that describes the type of message. Categories include: announcement, chat,message,poll, praise, system.

https://docs.microsoft.com/en-us/azure/active-directory/users-groups-roles/licensing-service-plan-reference

https://msdn.microsoft.com/en-us/office-365/office-365-management-activity-api-schema

We collect data for modern SharePoint sites the same as traditional SharePoint sites.

Date filter based on month only. (example all Januaries all time)

Month and year for given date. (ex. January 2015)

The month represented in a 3 character string and the year. (ex. Jan 2015)

Also the most recent Sharepopint Activity Date in the dataset.

The most recent datpoint in the Yammer activity table.

The name the item commonly used by files only.

A division of networks based on the number of groups that they have on thier network for the month period. This is often used to analyze your engaged groups % against companies that feild a similar number of groups.

The name of the Yammer network.

Network or verified admin changes the Yammer network's configuration. This includes setting the interval for exporting data and enabling chat.

Verified admin updates the Yammer network's security configuration. This includes setting password expiration policies and restrictions on IP addresses. Only verified admins can perform this operation.

Network or verified admin suspends (deactivates) a user from Yammer.

Number of members that joined a group. A user that leaves and re-enters the group multiple times will count multiple times.

A list of groups created within the network. Can be used to count the number of groups added to a network for a given time period. Also used as a flag to identify new groups created within a given time frame.

A list of members added to a network for a defined period of time. Can also be used to count the number of users added to a network for a given time period.

Number of new users created in a specified timeframe. Also used as a flag to identify new members that have joined within a given time frame.

Site administrator or owner enables RSS feeds for a site. Global administrators can enable RSS feeds for the entire organization in the SharePoint admin center.

Unstructured subtitle entered by the user to describe his/her note.

Unstructured title entered by the user to describe the given note.

Number of views on a specific note.

Unique numeric value assigned by Yammer used to identify a note.

Number of unique notes created in a specified timeframe.

The name of the given file or folder.

A sub-grouping of activity type. For a full list of the breakdown see the linked image.

Site administrator enables Office on Demand, which lets users access the latest version of Office desktop applications. Office on Demand is enabled in the SharePoint admin center and requires an Office 365 subscription that includes full, installed Office applications.

Calculation =[OneDrive - Active Drives] / [OneDrive - Drives]. Where active drives are drives listed in the'OneDrive Usage" table and have File activity for the report period.

Total active One Drive files added up from the[File Activity] column in the'OneDrive Usage' table.

Distinct count of users listed in the'OneDrive Activity' table.

The number of unique OneDrive drives.

Total extenal shares where an external share is defined as any access granting action that opens an object to an entity outide of the organizational tenant.

Total shareing activities toward users within the tenant.

Total gigabytes of storage allocated for each drive based on the most recent record.

Total storage used for the most recent record of each drive.

Total files for each drive. Total taken from the [DailyFiles] column in the'OneDrive Usage' table.

Total activities taken by users in the drive. This is the total of all records in from the [File Activities] column in the'OneDrive Activity' table.

Distinct count of all users in the'OneDrive Activity' table.

The email of the site owner

A clickable url icon that opens an email client to the owner of the selected site.

Name of the site owner

Category to destinguish between owners that are users and generated group owners that are not linked to a users email.

Total number of pages created. This is defined by the Activity Type Detail 'Object Type'

The visits to unique pages by users within the selected SharePoint site.

User views a page on a site. This doesn't include using a Web browser to view files located in a document library.

This is related to the "Viewed page" (PageViewed) activity. A PageViewedExtended event is logged when the same person continually views a web page for an extended period (up to 3 hours). The purpose of logging PageViewedExtended events is to reduce the number of PageViewed events that are(...)

The site path for the item.

The full item url.

Site administrator creates the result source for People Searches for a site.

These measures compare the current time frame to data from the previous parallel period. For example, if I’m filtered to the last 30 days then these measures evaluate the previous 30 days before my current period.

A permission level was added to a site collection.

A permission level was changed on a site collection.

A permission level was removed from a site collection.

An item was changed so that it no longer inherits permission levels from its parent.

The first and last name of the user who was praised followed by their Yammer User ID in square brackets.

Site administrator enables document preview for a site.

The tyGraph Price Calculator allows you to determine the price of tyGraph based on your network size. If you are looking for more than two tyGraph products, then we have an Enterprise bundled price. This allows you to purchase all tyGraph products for one bundled price.

Number of active private groups as of the last harvest.

Network or verified admin changes the information that appears on member profiles for network users network.

Number of active public groups as of the last harvest.

tyGraph Pulse has a data refresh every 24 hours. Admin reports are reccomended to have thier refresh scheduled immidately prior to the time the analyst arrives at work. Ad-hoc (manual) refreshes can also be made at anytime for the Admin Dataset. Pulse reports in tyGraph Online are refreshed(...)

Quarter and year of the given date. (ex. Q1 2015)

Designates the appropriate quarter for the given date.

The number of people you interacted with on any of the threads where you contributed. See also: User Interactions

The unique number of collegues that the user has interacted with. Reach Points = [Unique users interacted with]

Any user who has been added to the Yammer network and has not had their account suspended or deleted. This metric is time sliceable. For any given or selected period it will give you the total Registered members for that period.

A size grouping that allows you to filter to networks of similar size. This is based on the number of registered members in your network for the report month.

The total number of external users who have joined the network and have not been suspended or deleted.

Any licensed user for Microsoft teams who has not been suspended or deleted in the report period regardless if the user has actually signed in or used teams before.

Rolling date filter that only displays data from the current day, previous day, or both as selected by user preference.

Rolling date filter that only displays data from the current month, previous month, or both as selected by user preference.

Rolling date filter that only displays data from the current year.

User removed a member or guest from a SharePoint group. This might have been an intentional action or the result of another activity, such as an unsharing event.

A user was removed from the list of entities who can use a secure sharing link.

A customer visible indicator of the HasReply field; showing values of "Has Reply" or "No Reply".

A visual aid designed to be added to any report at the discretion of the user. Allows you to quickly observe the time frame being applied to your report. This increases awareness of filtering settings and helps to prevent compounding filters. This reflects all active filters, slicers, and(...)

Number of threads that have received a response from a member (cannot be the thread initiator) when there were no members @mentioned. Excludes direct messages.

Total number of thread that qualify 'responded not @mentioned' divided by the total number of threads that contained a @mention in the initiating thread excluding direct messages.

Number of messages posted in the past 24 hours of the last data refresh.

The number of responses per thread.

Indicator for the result of activities. There are six possible results: NA, fail, failed, succeeded, success, and true.

One of the great advantages of reports presented in tyGraph Online is the ability to easily constrain the data under a pre-defined role using Row Level Security (RLS). For organizations that cannot access tyGraph Online can take advantage of Power BI Apps to create the same effect. This app(...)

Rolling date filter that restricts data to the most recent 3 months inclusive. Meaning that if the current month is August 2016 then data will include the May 2016- Aug 2016.

Rolling date filter that restricts data to the most recent 7 days inclusive.

Rolling date filter that restricts data to the most recent 12 months. Meaning that if the current month is August 2016 then data will include the Jul 2015- Aug 2016.

Rolling date filter that restricts data to the most recent 30 days inclusive.

A secure sharing link was created to this item.

A secure sharing link was deleted.

A user used a secure link.

Total users who have viewed a thread. This is not dynamic on a user level but is instead the lastest seen by count reported by yammer for each thread.

A submeasure used by tyGraph to determine what measures the user has chosen in the MAE Score selection pane.

A categorical value describing the user who wrote the message. Categories include: guide, user.

A SharePoint or global administrator creates a new Send To connection on the Records management page in the SharePoint admin center. A Send To connection specifies settings for a document repository or a records center. When you create a Send To connection, a Content Organizer can submit(...)

A SharePoint or global administrator deletes a Send To connection on the Records management page in the SharePoint admin center.

Sentiment Score is the average Sentiment Value for your selected messages. Negative messages will have a sentiment close to zero, positive messages will score closer to one. The sentiment value is calculated Microsoft Azure Text Analytics API from Azure Cognitive Services.

A value from zero to one given to messages by the Microsoft Azure Text Analytics API from Azure Cognitive Services. We then average these values to calculate a conversation, group, or users sentiment score. Some companies opt to only return Sentiment Values for a recent window (say the(...)

Calculation= [SharePoint - Active Files] / [SharePoint - Files]. Where [SharePoint - Active Files] is the total of active files.Active Files is the number of active files on the site. A file is considered active if it has been saved, synced, modified or shared within the specific time(...)

Calculation =[SharePoint - Active Sites] / [SharePoint - Sites]. Where an active site is any Site that has activity data in the[Activities] column in the'SharePoint Site Activity' table for the report period.[SharePoint - Sites] is a unique count of sites that have not been deleted.

A distinct count of all users in the 'SharePoint User Activity' table.

The total files recorded in SharePoint.

The total 'SharePoint Site Activity'[Files] omitting sites that have been deleted.

The most recent date recorded in the'SharePoint Site Activity' table.

The most recent date of data collected into the'SharePoint User Activity' table. This can be used to observe any differences between data in the SP User Activity table and the SP SiteActivity table.

A distinct count of all SharePointSiteID's in the'SharePoint Site Activity' table that have not been deleted.

The total storage space across sites based on the most recent quota foreach SharePoint site.

The total storage space used across all non deleted sharepoint sites.

This is just theSharePoint - Storage Used (GB) expressed in terabytes.

A simple total of the[SharePoint Activities] column from the 'SharePoint User Activity' table.

Total number of items shared. This is defined by the Activity Type Detail 'Object Type'

An item was changed so that it no longer inherits sharing permissions from its parent.

A change was made so that an item inherits sharing permissions from its parent.

User (member or guest) accepted a sharing invitation and was granted access to a resource. This event includes information about the user who was invited and the email address that was used to accept the invitation (they could be different). This activity is often accompanied by a second event(...)

User shared a resource in SharePoint Online or OneDrive for Business with a user who isn't in your organization's directory.

User withdrew a sharing invitation to a resource.

An external sharing invitation was updated.

User (member or guest) unshared a file, folder, or site that was previously shared with another user.

The full url of the site collection.

Total number of site collectons which had usage activity for the report period. This is defined by the Activity Type Detail 'Activity Type'

An ID for every site and personal portals.

A user created a site content type. A site content type is a content type that's attached to the parent site.

A clickable link to the site settings page.

The site full url

User requests to be added as a site collection administrator for a site collection. Site collection administrators have full control permissions for the site collection and all subsites.

Site collection administrator or owner removes a person as a site collection administrator for a site. This activity is also logged when an admin removes themselves from the list of site collection administrators for a user's OneDrive account (by editing the user profile in the SharePoint(...)

A SharePoint or global administrator creates a site collection in your SharePoint Online organization or a user provisions their OneDrive for Business site.

A user created a SharePoint site column. A site column is a column that isn't attached to a list. A site column is also a metadata structure that can be used by any list in a given web.

A user deleted a SharePoint site column.

A user updated a SharePoint site column by modifying one or more properties.

A user deleted a site content type.

A user updated a site content type by modifying one or more properties.

Site administrator deletes a site.

Site administrator or owner renames a site

Total number of SharePoint sites. Total is taken from the Sharepoint Sites table

Total number of SharePoint sites within the site collection that have had activity for the report period.

Calculation = [Skype - Meeting Attendees] / [Users - All Active]. Where All Active Users are users in active directory, that have an activated O365 license, and have not been suspended or deleted.

A count of devices being used for each user.

A distinct count of meeting attendes taken from the Skype Meeting Attendancetable.

A distinct count of users who have organized meetings. This is down to a user and is taken from the Skype Meetings table.

A total of sessions in Skype taken from the [Total Sessions] column in the 'Skype Sessions' table.

Verified admin updates the setting for the network data retention policy to either Hard Delete or Soft Delete. Only verified admins can perform this operation.

Total storage space availible to a Library Item in bytes

Total storage space availible to a Library Item in gigabytes

Total storage space availible to a Library Item in megabytes

Total system generated activities. This is defined by the Activity Type table.

A user adds a tab to a channel.

A user removes a tab from a channel.

A user modified a tab in a channel.

A user creates a team.

A team owner deletes a team.

Calculation = [Teams - Active Users] / [Users - All Active]. Where teams active users are any user who has: Posted a Chat Message, Private message, attended a call, attended a meeting, liking messages, apps, working on files, searching, following/favoritinga team, following/favoriting a channel.

Calculation =[Teams - Chat Messages] + [Teams - Private Messages] + [Teams - Voice Calls]

The total chat messages posted in teams. Where a chat messages are the number of unique messages that the user posted in a team chat during the specified time period.

The average number of people using each client type each day. Each person/device/date combination is counted once. Used in the Teams Device Usage Pie Chart on the Teams Page of tyGraph Pulse

Meetings is the number of participants who have attended a scheduled teams meetingduring the specified time period. This means that if you were on a group call with three other people there would be four meetings, one for each user who attended.The calculation is asimple total of the(...)

A simple total of the [Private Messages] column in the'Teams Activity' table where "Private Messages" are the number of unique messages that the user posted in a private chat during the specified time period.

Are the number of calls that the user participated in during the specified time period. Calls include incoming and outgoing calls. So if I phone you and you answer we both get one call. The calculatoin is a simple total of the [Voice Calls] column in the 'Teams Activity' table.

Calculation = [Teams - Chat Messages] / [Teams - All Messages]. Where chat messages are the number ofunique messages that the user posted in a team chat during the specified time period.

A user signs in to a Microsoft Teams client. This event doesn't capture token refresh activities.

The first message in a yammer conversation. Does not include messages within a thread.

([Thread Responses] + [Message Likes] + [Seen By]) * [Thread Contributors] /100

Text content of a thread.

The total number of responses under a thread. Not inclusive of the initial thread.

A comma delimited list of all topics associated to a thread.

A categorical value that describes the type of thread. Categories include: announcement, chat,message,poll, praise, system.

The Member Name of the user who started the thread.

Number of messages that initiated conversations.

The total threads divided by the total message contributors.

Total number of threads initiated in a day. Typically seen averaged out in scenarios where the time period is greater than one day.

Number of initiating messages that have an @mention.

Percent of initiating messages that have an @mention.

Number of initiating messages that have a response.

Percent of initiating messages that have a response.

Total number of threads *and all each threads subsequent messages* that have a topic or topics mentioned below. Example if a thread had 3 topics used in the conversation Threads with Topics would equal 1 for that thread.

A calculated value of the hour that a message was posted, ranging from 0 to 23.

Name in the form of a title often given to library folders

A continuous alphanumeric value preceded by a # used to identify the topic, i.e. topic name.

A value assigned to a topic for the sake of categorization and easy indexing. Ex. All topics starting with the letter A will have an A in the field.

Total number of users who have opted to followa a given topic.

Unique numeric value assigned by Yammer that uniquely identifies a topic.

Number of times a topic has been mentioned per thread. Example: If a topic is mentioned twice in messages after the initiating message, it will be counted once. A thread with a topic used in the initiating message and in subsequent ones, no matter how often will still be counted as one topic(...)

Cumulative total of topic mentions for a specified timeframe.

Unique number of topics.

Total number of active groups as of the last harvest. Not time sliceable.

Looking expand access to tyGraph tools to a larger audience in your organization? The tyGraph Access Methodology outlines the basic framework for how we deliver secure and dynamic data for a variety of business roles.

The business OneDrive assigned to each employee in the organization, we call the employee OneDrive. The business repository assigned to an employee, we call this the professional OneDrive. Personal OneDrive's are never inclueded in this product.

An excerpt from a September tyGraph Demo outlining the basics of tyGraph for SharePoint. The SharePoint component of the demo runs from 22:23 - 30:57.

An export of every help tip from our Yammer Admin report. This document includes the help-tip pop up information that coincides with every visual for every page.

Admins can control who sees the reports that they administrate. This interface allows each administrator to delegate admin and member rights to other users.

Will demonstrates how to access and set up a tyGraph Report from a Power BI desktop model.

An excerpt from a tyGraph demo that outlines the basics of tyGraph for Teams. The Teams component runs from 14:36-22:25

There are two types of external users:Authenticated users with Microsoft accounts and Authenticated users without Microsoft accounts

The unique number of users who have not taken any one of your selected MAE Score acts of engagement in the current report period.

Same as engaged members (POP%) but with an up and down arrow KPI Indicator

The percentage change un-engaged members but with an up and down arrow KPI Indicator

The number of users who have not taken any of your selected MAE Actions within for the report period.

The percentage change in members who have not taken any one of your selected MAE Score acts of engagement from the previous period to the current one.

The number of users who have not taken any of your selected MAE Actions in the previous period. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your(...)

The unique number of users who have not taken any one of your selected MAE Score acts of engagement in the previous period. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior(...)

Thread starters without a response; may include system messages such as "so and so has joined your network" if there was no reply.

Percent of threads that do not have a response.

The record status of a retention label that classifies a document as a record was unlocked. This means that the document can be modified or deleted. Only users assigned at least the contributor permission for a site can change the record status of a document.

Admin updated data access settings.

Admin updated privacy settings; for example, minimum group size.

Admin uploaded organizational data file.

Total activities generated by usage. Also defined by the Activity Type talbe

Activities made by users on a site basis. Used for tyGraph for SharePoint - Business User Report which is currently in pre-alpha. Often pivoted on AD data to define SharePoint activity by region, country, location, etc.

Number of current followers for a specified member.

Number of user interactions between two members. Used with Member Name from Users table in combination with Interacted With Member from User Interactions table. This is Date, Group, and Thread sliceable.

Number of likes made by a user. Often pivoted on member name to show the number of likes that member has made on a message(s).

"Total number of mentions. Depending on the context this measure can be used to show mentions received, given, or as a total of a aggregate such as group. By default we see User Mentions pivoted on Mentioned Member Name in the ""Top Mentioned Members"" visual on ""The Network"" page. This(...)

Number of messages posted by a user.

Number of times a member or members have been praised.

Unique numeric value assigned by Yammer for each user in the network.

Is a baseline score used as the denominator for most percentages in pulse that involve users. This is the a count of all users with an active directory account, O365 license, and are not suspended or deleted.

The distinct number of people a user has interacted with.

The total unique members that liked a messages.  This is subject to the filters that you have applied. So if you have selected a thread it will count likes from the responses as well. If you'd like to just count response likes you can filter using the Message table attribute:(...)

Number of unique members that have been mentioned.

Number of unique members that have been praised.

User account is suspended (deactivated).

Analyst viewed visualizations in one or more Explore page tabs.

An option in PowerBI to change the way that cross filtering works between visualizations on the same report tab.

A binary value indicating a message that had previously been private but has since been moved to a group.

The name of the template used to create the site

A web link to the Yammer site for the given network.

The access request settings were modified on a site.

A date range for selecting a week of the year. This weekly filter starts each week on a Sunday - Saturday calendar. For example the week of 1 Jul 2018 is Sunday 1 July 2018 - Saturday 7 July 2018

Teams messages formulated by the ratio of teams chat to total teams messages of a user. WOL Score = ([Teams Chat Messages]/[Total Teams Messages])*[Total Teams Messages]

This is a total of all public groups that currently exist in your Yammer Network. The baseline for the guage is the total number of Yammer Groups in your network.

Calculation = [Yammer - Active Users] / [Users - All Active]. Where[Yammer - Active Users] are any user who has Liked, Read, or Posted for the report period.

A distinct count of users who have Liked, Read, or Posted material in Yammer for the report period.

The average number of Yammer activities across all tyGraph Pulse (Yammer) activity types. ie. Likes, Reads, and Posts.

The total devices being used to access Yammer.

Total likes made byuser(s) in Yammer.

A total of all messages posted by a user in Yammer. This includes Threads, and replies.

The total threads rendered on a users screen, sometimes referred to a "scroll pasts"

Year value of the given date.