Export data from Yammer Enterprise

As a verified admin, you can export Yammer Enterprise data to monitor usage and content and for discovery and compliance purposes. The following table lists the four ways to export data.

Method
Purpose
Export user and admin list
Identify status of current admins and users, and review email, title, location, and department of each user.
Export Yammer network data by date range and network
View and audit all network data for all users. You can specify a date range, and choose whether to include files and external network data.
Export data for one user
Identify all data related to one user. You can use this export to identify data that needs to be deleted to comply with a GDPR data subject request.
Set up automatic data exports
Automate exports that need to be done on an ongoing basis for compliance by using the DataExport API .

Note

Exported data can't be used for migrating content between Yammer networks. For migration information, see Network migration: Consolidate multiple Yammer networks.

Export user and admin list

  1. In Yammer, click the Yammer settings icon Yammer settings icon, and then click Network Admin.

  2. Click Export Users.

    Yammer Export Users menu

  3. On the Export Users page, choose Export all users, and then click Export.

    Yammer Export Users options - Export all users or Export all users since (date)

  4. Save the exported file. The file is saved as a compressed file with a .zip file name extension.

  5. Go to the location where you saved the compressed file and expand it.

    The export contains the following files:

File
Contents
log.txt
Summary of the export.
request.txt
The parameters of the export.
Admins.csv
A list of current admins, their email addresses, and whether they are a verified admin or a network admin.
For more information on the types of admins in Yammer, see Manage Yammer admins.
Networks.csv
Information about your home network and any external networks, including the name, URL, creation date, whether it is moderated, whether it has a usage policy, and the number of users.
Users.csv
The ID, name, email, job title, location, department, user ID, deletion status (deletion date, name and id of person who deleted the user), join date, suspension status (deactivated date, name and ID of person who deactivated the user), and the state of the user (active or soft-deleted).

A user is who is in the soft_delete state means the user is either:

- pending, if there are no joined_at, suspended_at, or deleted_at values)

- suspended (deactivated), if there is a suspended_at value, but no deleted_at value

- deleted, if there is a deleted_at value

Guest users can be identified in the user export by reviewing the email address field. If the email address doesn't match the domain of the home network, the user is aguest.

The api_url is the URL used to obtain user metadata. For more information about using the data in this field, see the Yammer developer documentation.

Export Yammer network data by date range and network

  1. In the Yammer admin center, go to Content and Security > Export Network Data.

  2. Specify the data to include:

    Export page, showing export options

    • Date range: Only data in the specified date range will be included.

    • Include attachments: If not selected, you'll get a list of files. If selected, you also get a Files folder with all files in their native format.

    • Include external networks: If not selected, you'll only get data from your home network. If selected, you'll get a separate folder for the data from each network. Each network is identified by its ID, and the full network names are listed in Networks.csv.

    Each network has its own folder, labeled with the network ID

  3. Click Export.

    Data is exported into a .zip file. If there is more than one network exported, a separate folder is created for each network.

File
Contents
log.txt
Summary of the export.
request.txt
The parameters of the export.
Admins.csv
Lists the name, email, and type of all Yammer admins for each selected network.
Files.csv
For any file added or modified during the specified date range, lists the Yammer ID, type of file, name, description, and path to the file in Yammer, along with metadata including the group it was posted in.

Files.csv does not contain the actual file. If you selected to include attachments in your export, files can be found in the Files folder of the .zip file. Use the ID from Files.csv to identify a specific file in the Files folder.

For information about how to go directly to a specific file in Yammer, see Find and delete specific messages or files.
Groups.csv
For any group created or modified during the specified date range, lists the Yammer ID, name, description, privacy status, whether the group is internal or external, link to the group, who created the group, creation date, and updated date.
Messages.csv
For any message sent or modified during the specified date range, lists the message ID, thread ID, group ID, group name, privacy status, sender ID, name and email, the full body of the message, attachments, and creation and deletion information.

For information about how to go directly to a specific message in Yammer, see Find and delete specific messages or files.
MessageThreadsOutbound.csv
Includes IDs of external participants in outbound messages.
MessageVersions.csv
Includes IDs and modification information for messages that have been edited.
Networks.csv
Lists your home network and all external networks included in the export.
Pages.csv
For any page created or modified during the specified date range, lists the IDs, dates, and owners of the page.
Topics.csv
For any topic created during the specified date range, lists the creation information and a link to the topic.
Users.csv
For any user who joined, or was deleted or suspended during the specified date range, lists email, job-title, location, department, a link to the user, and information about the users current state.

A user is who is in the soft_delete state means the user is either

- pending, if there are no joined_at, suspended_at, or deleted_at values)

- suspended (deactivated), if there is a suspended_at value, but no deleted_at value

- deleted, if there is a deleted_at value

Guest users can be identified in the user export by reviewing the email address field. If the email address doesn't match the domain of the home network, the user is aguest.

The api_url is the URL used to obtain user metadata. For more information about using the data in this field, see the Yammer developer documentation.
Files folder:
This folder contain files that have been created or modified during the specified time period. Files are in their native format but are named with their Yammer ID. For example a PowerPoint presentation might be listed as 127815379.pptx.

For information about how to go directly to a specific file in Yammer, see Delete specific messages or files.

The following types of data are not included in this export:

  • Data available in the user's settings, including their profile, the networks they are members of, their account activity, applications, notifications, and language preferences, and their org chart.

  • User's activity data.

  • Bookmarked messages, group membership, followed or following users, or followed topics. To find this information for a user, click the user's name.

To find this data for an individual user, click the Yammer settings icon Yammer settings icon, click People, and click the name of the user whose data you want to view. This page shows the user's profile, conversations they've participated in, any files, images, and videos they have posted, along with their bookmarks, followed and following users, and followed topics.

Export data for one user

Note

You must export user data for each network the user is a member of.

  1. In the Yammer admin center, go to Content and Security > Export User Data.

  2. Type the user's name and select the user.

  3. Click Export.

    Data is exported into a .zip file containing the following files.

File
Contents
log.txt
Summarizes the number of entries in each .csv file, and lists any errors that occur during the export.
request.txt
Parameters use for the export.
Broadcast.csv
For any live event video posted by the user, includes the network ID, group ID and name, title, description, links to the video, and additional information about the video.
The video content is not included in the export. The video is saved in Microsoft Stream. To edit metadata or delete the video, you can open the video in Microsoft Stream admin mode. For more information see Admin capabilities in Microsoft Stream and Office 365 Data Subject Requests for the GDPR, Stream
Files.csv
For any file added or modified by this user, lists the Yammer ID, type of file, name, description, and path to the file in Yammer, along with metadata including the group it was posted in.

Files.csv does not contain the actual file. If you selected to include attachments in your export, files can be found in the Files folder of the zip file. The file ID in Files.csv can be used to identify the files in the Files folder or to go directly to the file in Yammer.
Groups.csv
For any group created or modified by the user, lists the Yammer group ID, name, description, privacy status, whether the group is internal or external, link to the group, creation date, and updated date. This file also includes the aggregated total number of polls the user voted on, and the polls the user created.
LikedMessages.csv
For any message liked by the user, lists the message ID, thread ID, group ID, group name, privacy status, sender ID, name and email, the full body of the message, the ids for attachments, and creation and deletion information. A list of polls you created will also be provided. For announcements, includes the title of the announcement.
Messages.csv
For any message sent or modified by the user, lists the message ID, thread ID, group ID, group name, privacy status, sender ID, name and email, the full body of the message, the ids for attachments, and creation and deletion information. A list of polls you created will also be provided. For announcements, includes the title of the announcement.
Topics.csv
For any topic created by the user during the specified date range, lists the creation information and a link to the topic.
Files folder.
This folder contain files that have been created or modified by the user during the specified time period. Files are in their native format and are named with their Yammer ID. For example a PowerPoint presentation might be listed as 127815379.pptx.
  1. When the user's account activity data is ready, you'll receive a Yammer inbox message with a link to the data. Click the link to open it.

Exported data does not contain bookmarked messages, group membership, followed or following users, followed topics, the user's notification, application, and language settings, and org chart. To find this data for an individual user, click the Yammer settings icon Yammer settings icon, click People, and click the name of the user whose data you want to view. This page shows the user's profile, conversations they've participated in, any files, images, and videos they have posted, along with their bookmarks, followed and following users, and followed topics.

Troubleshoot data export

  • If the .zip file is corrupted and can't be unzipped, try again. If this doesn't work, contact Support.

  • If the log.txt file shows export errors for one category of data, try again. If there are still errors, contact Support.

Find and delete specific messages or files

If you have the ID for a message or file, you can go directly to it in Yammer, and delete it if needed.

To find and delete a specific message in Yammer:

  1. Build the URL for the message. Use https://www.yammer.com/network_name/#/Threads/show?threadId= thread_id. For example, https://www.yammer.com/contosomkt.onmicrosoft.com/#/Threads/show?threadId=1040647232.

  2. In the message, click the More icon More icon (...), and then click Delete.

To find and delete a specific file in Yammer:

  • Use the Search box in Yammer. For example, for a file named 12345678.pptx in the export, search for 1235678.pptx. In the search results, click Go to File file, and then click Delete this File.

  • Or, build the URL for the file. Use https://www.yammer.com/network_name/#/files/file_number, for example https://www.yammer.com/contosomkt.onmicrosoft.com/#/files/12345678. On the Yammer page for the file, click Delete this File.

Set up automatic data exports

To set up automatic recurring exports, use the Yammer API. For information about the Data Export API, go to /export on the Yammer Developer Center.

See also

View Group Insights in Yammer

Office 365 Reports in the Admin Center - Yammer activity report

Export Yammer group members to a .csv file

Audit Yammer user data

Manage GDPR data subject requests in Yammer Enterprise

Manage Yammer data compliance