Share via

Data Mapping for yammer activity data with message

Anonymous
2017-08-10T04:15:10+00:00

I would like to know how many liked, message replied to a specific topic which creates by the user and total vote for the poll.

is there anywhere for us to extract and map the data so that we can spot the hottest topic which causes the spike for the engagement rate.

***Post was moved by the moderator to the appropriate forum category.***

Microsoft 365 and Office | Install, redeem, activate | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-08-16T18:37:32+00:00

    Hello Veronie,

    Thank you for your post.

    I would request you kindly go through below points to generate a report from office 365 regarding yammer post and with this download Yammer export data from Yammer and get the post details from messages.csv file copy that in pivot table in excel and manipulate with below report and data.

    You can get the usage report from office 365 regarding the yammer from the UI by following below steps:-

    1. Go to the Office 365 admin center > Reports > Usage.
    2. Select the Yammer Activity widget on the Reports dashboard
    3. Or, select Yammer activity from the Select a report dropdown.
    4. Use the day tabs to view the Yammer activity report trends over the last 7 days, 30 days, 90 days, or 180 days.
    5. You can view the User chart to understand the trend of the amount of unique users who are generating the Yammer activities. You can look at the trend of users posting, reading, or liking Yammer messages.

    https://support.office.com/en-gb/article/View-the-Yammer-Activity-report-in-the-new-Office-365-admin-center-c7c9f938-5b8e-4d52-b1a2-c7c32cb2312a?ui=en-US&rs=en-GB&ad=GB

    In that file you will get few columns as

    <br>Data as of <br>User name <br>Display name <br>User state <br>State change date (UTC) <br>Last activity date (UTC) <br>Posted <br>Read <br>Liked <br>Products assigned <br>Reporting period in days
    • User name:- is the email address of the user. You can display the actual email address or make this field anonymous.
    • Display name:- is the full name of the user. You can display the actual email address or make this field anonymous.
    • User state :-is one of three values: Activated, Deleted, or Suspended.
    • State change date (UTC):- is the date on which the user's state was changed in Yammer.
    • Last activity date (UTC) :- refers to the last date that the user posted, read, or liked a message.
    • Posted:- is the number of unique messages the user posted during the time period you specified.
    • Read:- is the number of unique messages that the user read during the time period you specified.
    • Liked :- is the number of unique messages that the user liked during the time period you specified.
    • Product assigned:- is the Office 365 products that are assigned to this user.

    We would like to inform that On May 14, 2015, Microsoft announced that Yammer will be retiring the Yammer Analytics Dashboard and Leaderboards. These features will be replaced with the Office 365 Analytics dashboard and some third-party applications. To learn more about this change, read the announcement on the Information about Yammer leaderboard.

    However I was not able to find the PowerShell for this usage report from office 365 reports.

    https://technet.microsoft.com/en-us/library/dn683774.aspx?f=255&MSPPError=-2147217396

    Regards,

    Sushil Dhiwa.

    Microsoft Yammer support team.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments