How to Export Yammer Data by Country or Region
Question details
The user wants to export Yammer network or user data categorized by the users' specific country or region.
- Product
- Yammer
- Device & OS
- not provided
- Scenario
- Attempting to generate geographical or regional reports of Yammer network usage for administrative purposes.
- Observed behavior
- Standard Yammer administrative export tools do not provide an out-of-the-box report that identifies users specifically by their country or region.
Ensure you have the necessary Yammer Network Administrator privileges, as standard users cannot access enterprise data export features.
Review Enterprise Data Export Options
Check standard Yammer enterprise export tools to see what user information is currently available in your network's data dumps.
Yammer provides broad data exports for administrators, but demographic data relies heavily on what is synced or filled out in user profiles. You may need to cross-reference this export with Azure Active Directory.
Log in to Yammer with your administrator account, click on the Settings gear icon, and navigate to the Network Admin settings.
Select 'Export Data' from the left-hand administrative menu to view the available report types and date range options.
Choose to export network data and review the generated Users.csv file. Look for location-based fields, keeping in mind that country or region fields may not be included by default.
Submit a Feature Request via Microsoft Feedback
If country-level reporting is entirely unavailable in your tenant, you can request this functionality through official Microsoft channels.
Analyze Exported Yammer Data Efficiently with WPS Office
While Yammer exports may not have built-in country filters, you can use WPS Spreadsheet to efficiently open, filter, and cross-reference your large exported CSV reports with other directory data. WPS Office is a free, lightweight alternative that offers seamless compatibility with Microsoft Office file formats.
- 1. Open WPS Spreadsheet: Launch WPS Office and click on Spreadsheet to open a new workspace.
- 2. Import Yammer CSV: Go to Menu > Open and select the exported Yammer user data CSV file.
- 3. Filter and Cross-Reference: Use the Data tab to apply filters, or use VLOOKUP functions to match Yammer user IDs with regional data from your HR or Azure AD exports.
Frequently Asked Questions
Can I link Yammer export data to Azure Active Directory to get country information?
Yes, administrators often export the Yammer user list and cross-reference it with Azure AD reports. Azure AD typically maintains more reliable and standardized user location and country fields than Yammer's native profile data.
Why isn't country data explicitly included in standard Yammer exports?
Yammer's native reporting focuses heavily on network engagement, conversation metrics, and community activity rather than geographical mapping. Demographic data in Yammer often depends on what fields users choose to fill out or what is mapped during directory synchronization.
What format does the Yammer data export provide?
Yammer enterprise data exports are generated as .zip archives. When extracted, they contain multiple .csv (Comma Separated Values) files detailing users, messages, topics, and groups, which can be opened in spreadsheet software like Excel or WPS Spreadsheet.
