Exporting Data from Wisr

The purpose of this article is an overview of all data that can be exported from a site by a site administrator.

Overview

Most tables in the admin backend provide the option for a CSV. If you are not familiar with member tables, we recommend this article Managing Members. Below is a list of standard exports and where to find them in the admin backend. Each download will include every field available, regardless of the items you have checked in the View dropdown.

Downloading Exports

Once your exports have processed, you will receive an email to the email on your account with a link to download the export.

If you have any problems downloading your export try these solutions:

  • Copy the url and past it into any browser
  • Try using webmail to access the link
  • Email adminsupport@wisr.io for additional support

Summary of Downloads:

  • Members: Active and Pending
  • Members: Invited
  • Members: Pre-Verified
  • Discussions: Topics
  • Discussions: Posts
  • Connections
  • Activity
  • Matching Module

Filtering Downloads:

By applying filters to any fields in the data table, your download will only include the rows you are currently viewing. If you want a complete dataset, make sure to clear all field filters. 

Members: Active and Pending

{yoursite}.wisr.io/admin/members/active
{yoursite}.wisr.io/admin/members/pending

Covers demographic data and high-level usage statistics for all opted-in members. Active members have all been verified either by an admin or by pre-verification. Pending members still need to be approved to gain access to the site, but the data format is the same.

Field

Description

Unique ID

School’s pass-through ID

Member Type

The member’s current member type

Name

The member's full name
E-mail

The member's e-mail associated with their account

First Name

Last Name

Headline

Short description of the member’s current career

Summary

Longer summary of the member’s career

Tz

The time zone the member entered as their primary time zone

Last Seen

Timestamp of the last time we saw this member online

Created At

When the member opted into the site

LinkedIn Profile URL

Custom Fields

JSON field that contains all custom field data

Connections

Count of members that this member connected with

Requested Calls

Number of times the member requested a call

Completed Calls

Number of times the member completed a call

Chats

Number of unique 1:1 chats the member has had

Chat Messages

Total number of all chat messages the member has sent

Has Verified Email

True/False if the member verified their email address on file

Industries

Industry Groups

Goals

Volunteer Items



Members: Invited

{yoursite}.wisr.io/admin/members/invited

A list of all members that were invited to the site. This can help identify “champion” members that are good promoters.

Field

Description

Unique ID

School’s pass-through ID

Status

Status of the invitation (Sent, Accepted, Rejected)

Invited By

The member that sent the invitation

Created At

Timestamp of when the invitation was created

Last Sent At

Timestamp of when the invitation was last sent

Responded At

Timestamp of when the member responded to the invitation

Sent Count

The number of times the invitation was sent (via email)

Members: Pre-verified

{yoursite}.wisr.io/admin/members/pre-verified

A list of all contacts that have been pre-verified in the authentication system. This helps with sending marketing emails to promote new member adoption.

Field

Description

Unique ID

School’s pass-through ID

Member Type

The member’s current member type

First Name

Last Name

Invite Url

Unique invitation link for each member

Source

ADMIN_CREATE = 1

ADMIN_BULK_UPLOAD = 2

ADMIN_INVITE = 3

MEMBER_SIGNUP = 4

MEMBER_INVITE = 5

Verified By

The admin that performed the verification


Discussions: Topics

{yoursite}.wisr.io/admin/discussions/topics

Field

Description

Created by Unique ID

School’s pass-through ID

Created by Member Type

The member’s current member type

Created by Name

The member that created the topic

Title

The title of the topic

Excerpt

A short snippet of the first post’s body

Posts

The number of posts inside the topic

Views

The number of times the topic was viewed

Topic Url

A web link to the topic in Wisr

Created At

When the topic was created

Last Activity At

The last time something happened in the topic (e.g. someone created a new post)

Discussions: Posts

{yoursite}.wisr.io/admin/discussions/posts

Field

Description

Posted by Unique ID

School’s pass-through ID

Posted by Member Type

The member’s current member type

Posted by Name

The member that created the post

Topic

The topic that the post belongs to

Body

The post body content

Replies

The number of times the post was replied to

Post Url

A web link to the post in Wisr

Created At

When the post was created

Modified At

When the post was modified

Deleted At

When the post was deleted


Connections

{yoursite}.wisr.io/admin/connections/all

Captures how members connect with each other, who initiated the connection, and how much activity the connection has.

Field

Description

Initiated by Unique ID

School’s pass-through ID for the member that initiated

Initiated by Member Type

The initiating member’s current member type

Initiated by Name

The initiating member’s name

Connected with Unique ID

School’s pass-through ID for the connected member

Connected with Member Type

The current member type for the connected member

Connected with Name

The name of the connected member

Calls

The number of calls between these members

Messages

The number of messages between these members

Successful

If the connection was successful (call was completed, or the chat has messages going both ways)

Activity

{yoursite}.wisr.io/admin/activity

Full list of all member activity. Follows a standard activity format: An actor performed a verb on an object in a target.

Field

Description

Actor Unique ID

School’s pass-through ID for the member that performed the action

Actor Member Type

Member type for the member that performed the action

Actor Name

Name of the member that performed the action

Actor email

Email of the member that performed the action

Verb

The action that was performed

Object

What the action was performed on

Target

What the object was contained in (not always available)

Timestamp

When the action was performed

Matching Module

Available Matches

{yoursite}.wisr.io/admin/matching/available-matches

Field Description
Profile ID
Name Member full Name
Member Type Member Type
Unique ID School’s pass-through ID
Email Email of the member
Mentor Capacity How many mentor/mentees the member can have
Remaining Mentor Capacity
How many more mentors/mentees the member can take
Active Match Connection Count
How many active connections the member has
Form submitted at
When the mentor form was submitted on TypeForm

Match Run Results

{yoursite}.wisr.io/admin/matching/results

Field Description
Mentee Profile ID  Mentee Profile ID
Mentee Name Mentee full name
Mentee Member Type Mentee Type
Mentee Unique ID Mentee school pass-through ID
Mentee Email Mentee Email
Mentor Profile ID Mentor Profile ID
Mentor Name Mentor Full Name
Mentor Member Type Mentor Member Type
Mentor Unique ID Mentor Unique ID
Mentor Email Mentor Email
Score Score created based on compatibility of mentor/mentee pairing
Created At When the match was created
Accepted At When the match was accepted

Still need help? Contact Us Contact Us