Admin: Export Raw Data (Workplace)

(This feature is for SWOOP Admins only)

If you want to get your hands on the raw data which SWOOP has collected from Workplace, then you can export this by following the steps outlined in this article. You'll find this in the Admin part of SWOOP under 'Data Export' under the heading 'Export Raw Data'.

Click on the 'Export Raw Data' button and this will generate two files which together will include every single person who has ever had access to the platform  and every post, reply, reaction, and mention made during the selected date-range. A complete listing of the contents in the files is provided below: 

People.csv file:

• ID: This is the platform ID for each person
• Created Date: The date the person was created on the platform
• Status: The user status which can be Active, External, Pending, Pending-Claim, soft-delete.
• Deleted Date: The date the person was delete. Is set at 9999-01-01 if the person is not deleted. Timezone is UTC. 

Relationship.csv file

• Type: Post, reply, like, mention
• From User: The ID of the person who did it (eg. post, reply, like)
• To User: The person who received it
• Message ID: Platform ID of the message
• Replied To Message ID: Platform ID of the message that was responded to
• Message Thread ID: Platform ID of the thread
• Is Question: True or False
• Seen By Count: Only applies to Workplace. Includes the number of people who have seen the message
• Message Length: The character count of the message
• Group ID: The ID of the group/community/team the message was posted in
• Privacy: The privacy of the message. If posted in a private group it will be private. Otherwise public.
• Date: The date and timestamp of the message. Likes and mentions inherit the same timestamp as the message they relates to. Timezone is UTC.

Note: Names will only be included where the 'Include name in export file' option has been ticked in the Miner Admin page.

Sentiment.csv (only included if Sentiment Analysis as been enabled)

• MessageID: The ID of the message in which the keyword(s) appeared
• ThreadID: The ID of the thread in which the keyword(s) appeared
• SentimentPositive: A score between 0 and 1 that indicated how much positive sentiment was in the message
• SentimentNegative: A score between 0 and 1 that indicated how much negative sentiment was in the message

Topic_keywords.csv (only included if Sentiment Analysis as been enabled)

• MessageID: The ID of the message in which the keyword(s) appeared
• ThreadID: The ID of the thread in which the keyword(s) appeared
• Keyword: The keyword(s) associated with the message

Note: Keywords are only stored for messages posted in public groups.

Limitations of Microsoft Excel when opening large data sets

Please note that Microsoft Excel will only open the first 1,048,576 rows even when more exist in the file. You may need to open the file in another application.