How to get data on your users

Here’s a guide on how to get information on all of your users, from simple counts to a detailed spreadsheet.

General user data

Firstly, head to the cog in the top right-hand corner of the page and click Users. If all you'd like is a quick snapshot of how many users you have, take a look at the following tabs on the users table.

All

Every user of all types, confirmed and unconfirmed, that is registered to your site.

Users

All of the people-type users that are confirmed users of your site, i.e. they have completed registration (note that this list includes users who were uploaded via bulk CSV upload).

Organisations

All of the organisation-type users that are confirmed users of your site.

(To learn more about how to update a user's profile type, check out our guide.)

Admins

All of the users that are in a group with the user type ‘Admin’. To check which groups have been configured in this way, click the cog in the top right-hand corner of the page and select Groups. From here, you will be able to verify the user type of each group using the tab below the group name.

Unconfirmed

All of the users that have started but are yet to complete registration. If you would like to prompt any of these users to complete registration, go to the three dots at the end of their table row and click 'Resend confirmation' to resend the invitation email.

Pending Deletion

All of the users that are scheduled to be deleted permanently. This process takes 1 hour to complete.

In-depth user data

If you are looking for more detailed user information, keep reading this guide!

(Note that in order to action this, you will need to be in a group with the 'Download user data' ability.)

Still on the Users page, locate the 'Export Users (.csv)' button just below the invitation bar. Click it and a message will appear indicating that the user data has been sent to your email address.

You will receive a spreadsheet containing a complete overview of the users on your site. If your site has a large number of users the data may take a couple of minutes to arrive in your inbox.

This spreadsheet will contain all your confirmed and unconfirmed users, including a large amount of data on each account. Here is a rundown of some of the less obvious fields included in the export.

User ID

The unique numerical identifier Zapnito assigns to each user. This can also be found in the URL of user profiles on your site as highlighted in bold below:

https://community.zapnito.com/users/15142-alex-thompson

Public Email

If they have set one, this is the email that the user has added to the contact details section of their profile so others can contact them. This is displayed in the Online Elsewhere section of the profile page.

Profile

This field displays the user's bio, inputted in the About You section of the edit profile page.

Terms

This indicates whether the user has accepted your site T&Cs. If ‘FALSE’ it is almost certainly because the user has been invited to your site but has not continued the registration process

Note that unconfirmed users that have accepted the site T&Cs but not completed the registration process will have ‘TRUE’ in this column.

Active

This will almost always be ‘TRUE’. ‘FALSE’ is only used to indicate users who Zapnito has blocked from registering on Zapnito.

Created At

The date on which the user was first created on any Zapnito site, not necessarily your own. This is because Zapnito user data is held within a centralised database that incorporates all Zapnito customer sites.

Campaign Link

If the user registered using a URL generated via our Campaigns tool, the campaign link will be shown here.

If you'd like to learn more about creating campaign links on your Zapnito site, check out this guide.