Forum Discussion

Lucas_Morales123's avatar
Lucas_Morales123
Copper Contributor
Jul 03, 2025

Fewer users in "Users" table than in "Messages" — how to ensure full user data?

Hi,

I'm analyzing Viva Engage exported data and noticed that the Users table contains fewer users than the number of unique user IDs appearing in the Messages table.

Some user IDs in the Messages table (as message authors) do not have corresponding entries in the Users table. Is there a known reason why some users might be excluded from the Users export?

Is there a way to ensure all users who post or interact are included in the Users table? Any insight into how to resolve or explain this discrepancy would be greatly appreciated.

Thanks in advance!

analytics

1 Reply

Sort By
  • RobSoto's avatar
    RobSoto
    Iron Contributor
    Jul 24, 2025

    Hi Lucas_Morales123​ 

    How large is the discrepancy? 5-10 users or dozens?

    Did you open up the Admins table as well? It's possible that there are many admins and those are not listed in the Users table. I tested the data export and noticed that detail. But I didn't find a Messages table in the ZIP export from the new Engage admin center. Can you elaborate on the Messages table and where you found it?

    -Rob

Resources