How to Get "Recent Activity" in an Export: Solution
My question came from this: I run a couple External Networks, and lurker metrics are notoriously harder to get than for Home Networks. I wanted to see how many people were viewing my YamJam Summary Note. While I can see in the Recent Activity ticker that "Persons A, B, and 53 others" viewed my Note, I'm not able to look at that ticker 24/7. How can I get the Recent Activity feed in an export?
From there, I can slice, dice, and search for exactly what I want--such as a YamJam Summary Note. Grab the number at the end of the URL on your note or file and do a Ctrl-F on your document to see who's viewing and who's downloading. Even if you don't look up the usernames, you can get a count.
Your tool of choice can depend on how much data you have. I also am not sure if either of the above tools really returns all the data I think I'm pulling. So it's best not to wait too long to check on the success of a file or note.
And it's worth mentioning that it's not easy to get YamJam metrics if you have a bunch of lurkers, so making sure you provide something for people to click on helps you just as much as it helps them.
[I didn't do this next part, but you might find it more useful than the route I'm going.]
You can also get Excel to connect directly to the XML output produced by a Yammer API.
In a blank Excel sheet, click the Data tab, click From Other Sources in the Get External Data group, click From XML Data Import from the drop down list, and in the File name: box, instead of a file on your computer or network, paste the Yammer API, except replace the final .json with .xml. e.g. https://www.yammer.com/api/v1/streams/activities.xml ... and click Open.
So long as you have IE or Edge already logged into your target Yammer network, Excel should use the same underlying connection to pull data directly from the Yammer API XML feed.
If the connection is successful, you will get an Excel dialog box stating that "The specified XML source does not refer to a schema. Excel will create a schema based on the XML source data." - click OK, choose where you want the output to be located, and you should get a tabular list of the API output, and, crucially, it is a dynamic link - just click the Refresh All button in the Data tab to get an up to date output.
There are ways to make the import a bit better, by creating your own XML maps to tell Excel exactly how to treat the incoming data stream.
(Originally posted in the ITProNetwork.) Edited for formatting issues.