Jul 18 2017 10:48 AM
Jul 18 2017 10:48 AM
Share your experience around getting insights about Yammer from the Office 365 Admin Center usage reporting. While waiting for roles are you able to access these reports? Do you lean on the adoption content pack? Do you officially sit in IT?
Just curious about lived experience with Yammer and analytics needs.
Jul 18 2017 02:40 PM
I've tried a couple times to get the Analytics Adoption Pack to work in PowerBI to no avail, but I haven't tried Support yet (I'm also not a PowerBI guy).
The stats in the O365 Admin center are okay. We really need Group-level reporting.
I'm an IT service owner for Yammer and other O365 tools.
Jul 19 2017 10:14 AM
Jul 19 2017 11:35 AM
I'm a consultant leading the Yammer adoption at this company. Because of that, I don't have Verified Admin rights which is a real problem, as the folks that do are still learning how the system works. The inability to easily see robust metrics (why does it need to have a PowerBI guru set it up?) is going to be a real hindrance to the adoption process.
Jul 19 2017 01:08 PM
Sounds like a great opportunity, Ori! I hope you get the metrics piece situated. It's already a serious challenge *without* insights. That's probably why @Simon Denton made metrics a requirement for his involvement with cultivating Yammer use.
I don't believe the Power BI portion is all that difficult. You just have to have the right permissions if I'm not mistaken. How are you planning to proceed with the project, Ori?
Jul 19 2017 09:28 PM - edited Jul 19 2017 09:35 PM
Jul 20 2017 12:15 AM
We make use of three sources for Yammer usage. I'm a Global Admin as well as a SharePoint and Yammer Admin where we've had Yammer since 2012 and have around 8,000 employees.
The first is the Yammer Analytics Dashboard in the Yammer Admin portal. This gives us an idea of the number of members 'engaged', the number of (private and public) messages, and which groups were most active.
The second is the'Yammer Activity' section in the Office 365 Reports - Usage area. This gives us an idea of the number of items posted, read and liked - our 'posted' to 'read' ratio appears to be about 1/99. The activity graph over a period of time is useful and we can see how many items each user posted, read and liked (telling us who are the most active posters or readers).
The third is the Power BI Office 365 Adoption Preview. This gives us an insight into Office 365 adoption, which is just starting here - which is why the above two reports are very useful. The 'Product usage' tab gives an idea of Yammer usage compared with other products, but this is not yet overly useful. The 'Communication' tab compares Exchange and Yammer but it is not yet overly helpful; this may change once Exchange usage in the cloud picks up. The 'Access from Anywhere' tab tells us how people are accessing Yammer- we can see that mobile access is picking up. In the 'Yammer User Activity' tab, the two sections 'Ten most active companies' and 'Ten most active departments' are not helpful as they are both 'blank'. This may be a symptom of our just starting out with Office 365.
Jul 20 2017 02:08 PM
Unfortunately, it doesn't provide nearly as much info as I would've liked. The one thing it does have an advantage over the one I created is that it can see aggregate views/reads, but beyond that it doesn't provide much more than you can create inside Tableau in a few hours. If you don't have Tableau experience, it might take a few hours a day for a week or two.
Here is my Tableau Report. I've included it so u can perhaps see what things I may consider important but also realize the shortcomings of the data and provide something more robust for us. I've removed the data, but I made these dashboards in Tableau with JUST the messages csv. The export is run at set intervals and Tableau server refreshes it. The only things I'm missing is including likes(though I have ways to collect data and include dates), Access data(simply logging in), and view/read count (per message), which for us are very important metrics to measure overall engagement and campaigns (#hashtag)
I could easily include the ability to dive down into the data right inside Tableau as well.
Jul 20 2017 02:36 PM
Finally got the Adoption Pack to work, though as not a PowerBI person it still seems difficult to use to slice/dice data. For sure this is a learning topic for me. (but, please Microsoft, don't take away the easier to use basic reports in the Admin Center).
Jul 20 2017 03:42 PM
Kudos for getting the adoption content pack plugged in, @Kevin Crossman. I attempted a few times to slice and dice but I quickly learned that wasn't really the intent here unfortunately.
I agree that group level analytics is where the magic happens in large orgs, @Mandy Clark. @Andrew Warland, departments and companies are likely pulled from Azure AD so I would take a look there for that tab to be useful. That segmenting is the one only I find somewhat interesting as I can break out how department use compares to one another.
@Victor Nguyen, thank you for sharing your Yammer dashboard built off the native export! Is this Tableau report shared beyond admins? Are you watching how much use the report gets? The weekly / monthly message deltas / changes likely highlight the cyclical nature of networks. Do you intervene in certain scenarios? I attempted to time (down to the hour) posts when peak activity occurred in the network and alert others to popular times as well. Have you aggregated, for example, Monday activity by hour? I echo your list of missing insights.
Jul 20 2017 06:17 PM
@Noah Sparks- we have been using the 'free' Yammer service since 2012. Until our Yammer service is fully connected with the Office 365 environment, user's profiles are not tied with AD and so Departments won't show (or won't show correctly - we disabled 'Org Chart' as it was creating confusion).
Aug 11 2017 12:48 PM
Aug 11 2017 01:40 PM
I saw this in our O365 Admin Message Center this week>
Nov 28 2017 05:11 PM
I seem to have issues with the more easily accessible engagement statistics of Yammer (I am Yammer admin, no O365 admin). Any insights what is happening? We have lots of activity, but it does no longer report it. Love to see the other reports as well (but will not be able to get to it as no O365 admin role, so a fix would really help). Also, I believe this analytics should be closer to the users, why can only admin people see this. Please open up as our users want to understand engagement in more detail as well.
Jun 07 2019 05:28 AM
I'd like to see a more sophisticated level of reporting within PowerBI for Yammer, at individual group level and overall.
The data exists, and yet the level of analysis that can be reached by 'downloading full report' is minimal.
Other analytics platforms are way ahead of the curve on this. It should be standard to identify:
* Most active users - by name
* Most influential users - by name
* Most engaged users
* Most liked posts
* Group placement - most active group
Yes, I'm aware that you offer the Adoption Pack, but this is clunky and not particularly helpful from a community management perspective. Similarly, plugging in each individual report from a CSV is time-consuming, and still doesn't provide the level of data that I need.
What are the plans in this space?
Jun 07 2019 11:20 AM