Viewing and Exporting Drop-in Data

The Check-Ins tab in your admin panel shows data for each drop-in student-provider interaction for Log and Queue mode. There are two tabs: Search and Manage. This data can be exported into a CSV file through the Manage tab. 

Viewing Check-In Data

Within Check-Ins > Search, you'll see a table. All rows in this table correspond to a Drop-In interaction between a single student and provider.

When viewing this table, not all columns will fit on your screen, so you will need to scroll to the right to see all of the information. When you export the check-in detail into a CSV, more columns and information will be available compared to what you see on the search tab. This is described in the header below, "Manage Tab - exporting drop_in_check_ins.csv". 

Editing Check-In Details

Some Check-In data fields are editable. More information on this can be found in the article Admins: Drop-In Flow, under the header, "Editing Check-In Details". 

Drop-in Kiosk Guest and Check-In Matching

A check-in that occurs via your drop-in Kiosk will be considered "guest check-ins". We collect email or student ID and log that as the student information. If the Student Data Integration is enabled, Penji will try to connect the Kiosk check-in information to a student Penji account. This happens automatically. We can also turn a "warning" on. The warning is discussed in the article Admins: Drop-In Settings, under the header, "Turn on the check-in warning (Penji Controlled)".

If the system cannot connect the check-in information to a Penji account, the student information used to check in will be shown under the "Student" column vs. their name. This is demonstrated below. The system was able to match Talia's email to their Penji account and could not match Leah's. 

The Student Data Integration is described in the article, IT Integrations.

Exporting the drop_in_check_ins.csv

Within Check-Ins > Manage, you have the ability to export the check_in.csv.

The check_in.csv has several columns and is a complete list of all check-in details. With the check_ins.csv, you have the ability to organize, analyze and present the data in a useful manner for your reporting. For more ways to use the check_ins.csv, review the article Admins: Excel Template Reports.

Above is an example screenshot of the check-in export CSV

Standard Columns (in order) 

• Status
  • Log mode status
    
    • Check-In: In Log mode, there is one status to represent that a student has checked in. This status will appear once a student has checked in using the kiosk. 
  • Queue mode statuses 
    • Waiting: When a student checks into the Queue and is waiting for a provider to select them from the Queue, the status will be waiting 
    • In Progress: Once a provider has started working with the student, tapped "Start Tutoring", and has selected them out of the Queue the status will be in progress
    • Completed: After the provider has ended the drop-in session, tapped "End Session", the interaction will be recorded as complete 
    • Canceled: If a student decides to leave the Queue or was removed, the drop-in interaction will be recorded as canceled 
• Student Email
• Student SSO ID
• Student ID
• Student Name
• Mode
  • This will indicate the drop-in mode, either "Log" or "Queue"
• Check In At Date
  • This will show what day the student checked in to the drop-in location.
    • For Log Mode, this will always equal "Started At Date" 
    • For Queue Mode, this is not necessarily when the provider started working with the student, that will be the "Started At Date". We would assume that "Check In At Date" and "Started At Date" would be the same. However, the difference indicates how long the student waited before they were able to receive help. 
• Check In At Time
  • This will show what time the student checked in to the drop-in location.
    • For Log Mode, this will always equal "Started At Time" 
    • For Queue Mode, this is not necessarily when the provider started working with the student, that will be the "Started At Time".  The difference in these two fields indicate how long the student waited before they were able to receive help. 
• Tutor Email
• Tutor SSO ID
• Tutor Name
  
• Course
• Resource is what the student has come to the center for, that is not tied to any provider hours. Resources can be set within the drop-in location CSV file.
  • Resources are only used in Log mode
• Topic
  • There is a general question asked of students before they complete their Queue mode check-in (what would you like to work on/discuss)
    • The topic question is only asked/available in Queue mode
• Location
• Started At Date
  • This will show what day the student started working with the provider/receiveing help
    • For Log Mode, this will always equal "Started At Date" 
    • For Queue Mode, we would assume that "Check In At Date" and "Started At Date" would be the same. However, the difference indicates how long the student waited before they were able to receive help. 
• Started At Time
  • This will show what time the student started working with the provider/receiveing help.
    • For Log Mode, this will always equal "Started At Time" 
    • For Queue Mode, the difference between "Check In At Time" and "Started At Time" indicates how long the student waited before they were able to receive help. 
• Ended At Date
  • This shows the day when the check-in was complete. Either the student checked themselves out of the Kiosk (Log Mode or Physical Queue Mode) or the provider ended the drop-in interaction (Online Queue Mode).
• Ended At Time
  • This shows the time when the check-in was complete. Either the student checked themselves out of the Kiosk (Log Mode or Physical Queue Mode) or the provider ended the drop-in interaction (Online Queue Mode).
• Duration Minutes
  • How long was the student there for drop-in help. This will be the time between Started at Date/Time and Ended at Date/Time
• Cancelled At Date
• Cancelled At Time
• Cancel Reason
  • There is an option for the canceller to explain why they are cancelling their drop-in check in
• Canceller Email
  • Who cancelled the drop-in check in
• Check In Feedback From Tutor
  
  • Feedback is only asked/available in Queue mode
• Requested Tutor Name shows what provider the student requested to work with. If you would like students to be able to request a specific provider when they use Drop-In Queue mode, contact [e-mail]
  • This feature is demonstrated in the article Admins: Drop-In Settings, under the header, "Turn on specific Provider (Penji Controlled)"

The next few columns are customizable and vary from community to community. These columns are all student metadata fields. 

• Student Metadata 
  • This is the information imported into Penji from your own IT system. We attach the metadata information we receive from your school to each check-in so that the admin can easily perform analytics.