Output files can be delivered to either the Othot SFTP or to another SFTP owned/managed by your institution (e.g., Slate’s SFTP). Once files are delivered, you'll need to schedule/script the system to pick up the files and import them into your CRM or other system.
The output file will be a .csv file which uses commas as the delimiter character and double quotes as the text qualifier. The first row in the file is the header row containing the field names. By default, the file will be named predict-output.csv, but we can customize it if needed. Additionally, we can add a date/time stamp to the end of the file name. If added, the date/timestamp uses Coordinated Universal Time (UTC) and is formatted as follows: predict-output_YYYY-MM-DDTHH:MM:SSZ.csv.
If you choose to have Othot deliver files to the Othot SFTP, the file will be delivered to the output directory.
If you chose to have Othot deliver files to an different SFTP location, you'll need to do the following:
In most cases, the output file is configured to be exported immediately following a new prediction, but it can also be configured to run on a schedule separate from a prediction job. If you want to have the output file exported separate from the prediction job, let us know when you'd like it to run.
We can also limit/filter the records sent in output files. If you'd like to do so, provide us with the following information:
In addition to filtering the population, we can send records based on whether the data about that record has changed. For partner institutions with very large populations, this option may be useful in preventing large imports with no changes.
The export can include any fields available in Othot. This includes:
The following table describes the fields in the output file that are configured by default (some fields may not apply or be available):
Field Name (e.g. File Header) |
Display Name (e.g. Equivalent Field Name in Othot) |
Description |
Data Type |
Example Value |
---|---|---|---|---|
M_F_N |
Recommendation 1 |
The What-If action that is predicted to have the single most significant impact towards increasing the individual's Likelihood Score. |
String/Text |
High School Visit: App |
M_F_V |
Recommendation 1 Value |
The value corresponding to the Recommendation 1 that is predicted to have the greatest impact on the individual's Likelihood Score. |
String/Text |
YES |
***VARIES*** |
***VARIES*** |
The Student ID(s) provided by you that uniquely identify each student. In most cases, this is a Reference ID from Slate, a Contact ID from TargetX/Salesforce, or the equivalent from whichever CRM system you're using. We can configure more than one ID, if needed. |
***VARIES*** |
123456789 |
M_F_E |
Recommendation 1 Delta |
The predicted increase to the individual's Likelihood Score if the corresponding Recommendation 1 and Value is enacted. |
Numeric/Float (Values between 0 and 1) |
0.21 |
***VARIES*** |
***VARIES*** |
The individual's Entry Term and Year. |
***VARIES*** |
Fall 2021 |
L_C |
Life Cycle |
The funnel stage in which the individual currently resides (e.g., applicant, admit, confirmed, etc.). |
String/Text |
Applicant |
D_V |
Decile (Numeric) |
The decile in which the individual’s current likelihood score falls. Decile 1 = the top 10% of likelihood scores. Decile 10 = the bottom 10% of likelihood scores. |
Numeric/Integer (Values between 1-10) |
2 |
UNIQUE_IDENTIFIER |
Othot ID |
An alphanumeric unique identifier created by Othot. |
String/Text |
HODU23K0YY7XLSKZOHVTLW
|
DEEP_LINK |
N/A |
A URL which can be imbedded into individual records in your CRM. This provides direct access to the individual page for that record in Othot. A URL that ties directly to an individual record page in Othot. Not available in the grid. |
String/Text (URL) |
https://prod.othot.com/<...> |
L_F |
Likelihood Factor |
A relative value that can be used to compare prospective students in different Life Cycle phases. A Likelihood Factor of 1.0 indicates the student's current Likelihood Score is equal to the average Likelihood Score within their current Life Cycle phase. |
Numeric/Float |
1.11 |
PREDICTION |
Likelihood Score |
A probability value (tied to the High Impact Question) that indicates the likelihood that a prospect will enroll, be retained, etc. The higher the value, the more likely. |
Numeric/Float (Values between 0 and 1) |
0.57 |
The following image is an example of how one Othot partner decided to import and display Othot predictions and other fields in Slate.