CampusESP Integration

Updated 25 Aug 2025
4 minute read

Print
Share
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

CampusESP provides a modern, all-in-one family engagement platform that helps your institution share personalized, timely content with families across web, mobile, email, and SMS.

📖 See the CampusESP companion document to this article for more information.

This article describes how to integrate the CampusESP parent engagement platform with Slate.

Step 1: Adding the CampusESP service account

To add the CampusESP service account to your database:

From the main navigation, select Database.
Under Configurations, select Slate Template Library (legacy tool).
At the top of the page, select refresh the Slate Template Library.
Under the Users heading, next to the CampusESP Service Account, select Add.

To configure the CampusESP service account:

From the main navigation, select Database.
Under Users & Access, select User Permissions.
Select Service Account, CampusESP.
Select Edit User.
Select the Roles tab.
Copy the username.
Share this username with CampusESP to grant SFTP access.

The CampusESP service account uses an RSA Keypair for authentication, so no password is needed.

Step 2: Configuring the CampusESP data exports

The CampusESP Admission Dashboard - Checklist Query exports checklist data to the CampusESP Platform.

To import the CampusESP data exports:

Copy the following Suitcase ID:

23a11680-bf7f-4c5e-befa-752675341cda:cep-test

Go to Database → Suitcase Import.
Paste the Suitcase ID.
Select Import. The Import Suitcase popup appears.
Select Import.

To configure the CampusESP data exports:

Go to Queries / Reports.
Select either the CampusESP - Data Export query or the CampusESP Admission Dashboard - Checklist query.
Select Edit Query.
Select Copy. Having a copy lets you view original configurations or start over.
Enter a name for the copied query.
Select Save.
The query has standard data exports, a filter, and scheduled export settings. Configure the following:
- Adjust the exports and filters to send the desired records to CampusESP in the export.
- Update any fields from the suitcase that no longer exist.
- Ensure that the required fields, email, stage, and cohort have appropriate values for your instance.
- Review and update the subquery exports for fields, such as fafsa completion or visit indicator.
- CampusESP Admission Dashboard - Checklist query only: Update to target the appropriate student_cohort.
Select Schedule Export.
Select all Requested Weekdays.
Select Save.

Repeat for the remaining data export query as required.

💡 Tip: Find field definitions and descriptions in the CampusESP Export Dictionaries section.

Step 3 (Optional): Adding the source format

This CampusESP source format imports updates from the CampusESP parent portal.

By default, the import does not create new relation records, but it does allow updates to relation records when data in CampusESP differs from data in Slate.

From the main navigation, select Database.
Under Import and Data Processing, select Source Format Library.
Next to CampusESP - Data Import, select Add. A popup appears.
Select Add.
Confirm the browser dialog. You are redirected to the CampusESP - Data Import source format page.
Select Edit.
Make any necessary changes to the source format settings.
Select Save.
Several fields have been pre-mapped for convenience, but you can adjust these mappings as needed. Select Edit Mappings and review and update the destination field and value mappings as desired.
- 📝 Note: In order for Slate to match records in the Source Format, the Person and Relation GUIDs must remain mapped.

The /incoming/campus_esp/ directory is created the first time the SFTP sweep runs after the Source Format has been added to the database, which generally occurs approximately every 15 minutes. The directory can also be manually created if desired. This directory must exist before CampusESP connects via SFTP.

CampusESP data dictionaries

This data dictionary, provided by CampusESP, describes the function of the columns included in the standard export query and source format. Required fields are marked (Required).

CampusESP Admission Dashboard - Checklist query

Data field	Description
`emails` (Required)	Email of the parent/contact, multiple emails supported when separated by semicolon. Either can be named email or emails field.
`student_id`	The unique identifier of the student. 📝 Note: Any key can be used, so long as the value is immutable.
`student_first_name`	The student’s first name.
`student_last_name`	The student’s last name.
`student_cohort`	The name of the cohort associated with this record. Must match the cohort’s name in the funnel, otherwise an exception will occur.
`block_summary`	Total outstanding items to be completed. For example, `0` or `3`.
`item_completed_indicator`	`Yes` or `No`. If `Yes`, a checkmark appears.
`item_status`	Status such as `Optional`, `Required`, or `Received`.
`item_description`	User friendly description of the checklist item. Can include HTML (for example href links to other resources).
`item_long_description`	Detailed description of checklist item.
`item_completed_date`	Date item was completed. For example, `2024-01-01`.

CampusESP - Data Export query

Column Name	Slate Equivalent	Description
`parent crm id` (Required)	Relation GUID	User/parent’s unique ID in CRM Can be used to import data back into CRM
`relationship to student`	Relation Relationship	Associated student’s relationship
`first name`	Relation First	User/parent’s first name
`last name`	Relation Last	User/parent’s last name
`email` (Required)	Relation Email	User/parent’s email address Users are matched by email address and data are merged based on their email.
`phone`	Relation Phone	User/parent’s phone number
`address1`	Relation Address	User’s address (line 1)
`address2`	Relation Address 2	User’s address (line 2)
`city`	Relation Address City	User/parent’s city
`state`	Relation Address State	User/parent’s state/providence
`zip`	Relation Address Postal	User/parent’s postal code or zip code
`country code`	Relation Address Country	User’s country code (ISO ALPHA-2)
`student crm id` (Required)	Person GUID	Associated student’s ID
`student first name`	Person First	Associated student’s first name
`student last name`	Person Last	Associated student’s last name
`student email`	Person Email	Associated student’s email address
`cohort` (Required)	Custom Field	Current cohort or admit term for this student (used for comparison reports) For example, `Fall 2024`, `FA24`, or `2024FA`
`stage` (Required)	Rank 1 Decision, Application Status, Person Status.	Current stage for this student For example, `Inquiry`, `Application Complete`, or `Deposited` `Denied`, `Canceled`, or `Withdrawn` indicators can be sent via this field or via a separate field(s). Families will be added to their respective community and be unsubscribed
`counselor`	Custom Field (Staff Assigned by Default)	Counselor name or region assigned to student
`first gen`	Custom Field	Boolean (true or false) field indicating if a student is first generation
`fafsa completion`	Custom Field	Boolean (true or false) field indicating if FAFSA has been completed
`visit_indicator`	Custom Field or Form Subquery	Boolean (true or false) field indicating if the student has visited campus
`orientation registration status`	Custom Field or Form Subquery	Boolean (true or false) field indicating whether a student has or has not registered for orientation
`admitted student day registration status`	Custom Field or Form Subquery	Boolean (true or false) field indicating whether a student has registered for admitted student day
`housing contract status`	Custom Field or Form Subquery	Boolean (true or false) field indicating if a housing contract has been submitted
`college`	Literal	College to which the student has applied or is enrolled
`major`	Custom Field	Student’s chosen major
`missing items`	Checklist Subquery	Any missing items required for the application

Was this article helpful?

What's Next

GMAC Common Letter of Recommendation

Table of contents

Step 1: Adding the CampusESP service account
Step 2: Configuring the CampusESP data exports
Step 3 (Optional): Adding the source format
CampusESP data dictionaries