Article summary: Administrators may occasionally notice that the user count visible within the Speakap interface does not perfectly align with downloaded CSV or Excel data exports. This guide explains why these numerical differences occur based on user activation states and outlines how to audit and reconcile user lists.
1. The Core Issue: Mismatched User Counts
Administrators may notice that user metrics displayed directly inside the platform do not always match the rows of data inside a downloaded CSV or Excel sheet.
- Example scenario: A Business Unit might display 100 members directly inside the application interface, but a downloaded data export registers 125 users.
This variation is not a system bug or a sign of missing data. Instead, it comes down to how different features filter user account activation statuses.
2. Understanding User Activation Statuses
To understand the data, it helps to look at how the user directory is divided:
- Activated Users: Employees who received their Speakap invitation email or login details, clicked the activation link, and successfully logged into the system for the first time.
- Non-Activated (Pending) Users: Employees who have been securely provisioned into the system and assigned to their respective groups (often automatically via an HR-IS User Sync integration) but have not yet completed their onboarding setup or signed in.
3. Why the Numbers Differ
The numerical variance occurs because the platform UI and various report filters serve different operational purposes:
- Platform UI (Groups & Networks): The visual user count displayed in a live group or department typically centers around Activated accounts. This shows you exactly who is actively capable of viewing or engaging with that group's timeline.
- Data Exports & Analytics: Many high-level data exports and background analytics reports aggregate data for both Activated + Non-Activated users. Because pending users have not yet generated platform activity, completed profile cards, or accepted terms of service, they can cause numbers to shift. Depending on the specific report type, including these users can make the export row count look higher, while strictly activity-based reports can make it look lower.
4. How to Verify and Reconcile User Statuses
If you need to audit your user directory to determine exactly which accounts are accounting for the difference, you can extract a comprehensive status log from your administrator dashboard:
- Navigate to Network settings.
- Select Users from the configuration menu.
- Use the built-in export option to generate a master employee spreadsheet containing all system records (both activated and non-activated).
- Filter and compare the total number of profiles marked "Active" versus those flagged as "Invited" or "Pending". Your live platform interface metrics should closely align with the "Active" user column.