- 08 Jul 2024
- 5 minute read
- Print
- DarkLight
- PDF
Capture Higher Ed Integration
- Updated 08 Jul 2024
- 5 minute read
- Print
- DarkLight
- PDF
The Capture Higher Ed integration lets you send prospective student data to Capture and receive behavioral engagement data in return.
💭 Questions about this integration? Reach out to [email protected].
To configure this integration, you’ll do the following:
Create a Capture Higher Ed service account in Slate
Provide the service account username to Capture
Use Suitcase to import data objects created by Capture, including custom fields, prompts, queries, and source formats
Customize the imported queries and schedule them for export
Configure the imported source formats
📝 This article should be read in conjunction with the Capture to Slate Integration Guide provided in Basecamp by your Capture Higher Ed client success manager.
Step 1: Create the Capture Higher Ed service account
The Capture Higher Ed service account provides Capture SFTP access to pick up files generated by the Capture Higher Ed data export and to drop daily files for import into Slate.
Select Database from the main navigation.
Under Configurations, select Slate Template Library (legacy tool).
Select the Users section to expand it.
Next to Capture Higher Ed Service Account, select Add. A popup appears.
Confirm the addition of the service account by selecting Add.
Select Refresh Slate Template Library at the top of the page.
🔔 Do not adjust the service account.
Step 2: Provide Capture with the service account username
Capture requires the service account’s username to configure the integration on their end.
To find the Capture Higher Ed service account username:
Select Database from the main navigation.
Under Users & Access, select User Permissions.
Select the Service Account, Capture Higher Ed from the list of users.
Select Edit User.
Select the Roles tab.
Scroll down to the SFTP Access section.
Copy the username.
Provide the username to Capture via the [email protected] email address.
While you await their confirmation, continue with the following steps.
Step 3: Import Capture Higher Ed objects with Suitcase
Use these import packages provided by Capture to jump-start your integration. The Suitcase IDs provided with each import package pull in custom fields, prompts, forms, queries, and source formats.
📖 Required reading
You must use Suitcase Import to bring these objects into your database.
First-Year/Transfer with Apply Model
Use this Suitcase ID to import these objects into your database.
💼 Suitcase IDb230cb45-48de-437a-b29d-d8709b67b6d2:cpt
Objects in this Suitcase include:
Queries
Capture Higher Ed: Prospects Export FY/TR
Capture Higher Ed: Applicants Export FY/TR
Capture Higher Ed: Merged Records
Source formats
Capture Higher Ed: New Inquiries
Capture Higher Ed: Behavioral Data Updates
Daily Capture to Slate Apply
Forms
Capture Higher Ed: Custom Tab w/Apply
First-Year/Transfer without Apply Model
Use the following Suitcase ID to import these objects into your database:
💼 Suitcase ID3e93ab44-a920-4338-933a-6a10a09e2289:cpt
Objects in this Suitcase include:
Queries
Capture Higher Ed: Prospects Export FY/TR
Capture Higher Ed: Applicants Export FY/TR
Capture Higher Ed: Merged Records
Source formats
Capture Higher Ed: New Inquiries
Capture Higher Ed: Behavioral Data Updates
Forms
Capture Higher Ed: Custom Tab
Graduate
Use the following Suitcase ID to import these objects into your database:
💼 Suitcase IDb343b512-2b3b-4e52-a26a-a6f8da1a7235:cpt
Objects in this Suitcase include:
Queries
Capture Higher Ed: Prospects Export Graduate
Capture Higher Ed: Applicants Export Graduate
Capture Higher Ed: Merged Records
Source formats
Capture Higher Ed: New Inquiries
Capture Higher Ed: Behavioral Data Updates
Forms
Capture Higher Ed: Custom Tab
See the Capture to Slate Integration Guide provided by your Client Success Manager in Basecamp for details on the fields and prompts added via the suitcase.
Step 4: Customize Capture queries and schedule for export
The Capture Export query contains over 50 export values, arranged, and formatted to specifically comply with the standards needed for a file to be consumed within Capture.
You must customize this query before Capture can process records from your database. Since many of the data points required by Capture are stored as custom fields in Slate, there are certain placeholder export values that must be replaced or updated.
Your Capture client success manager will have provided you with the Capture to Slate Integration Guide. Consult this guide for detailed instructions on editing and scheduling-for-export the following queries:
Capture Higher Ed: Prospects Export
Capture Higher Ed: Applicants Export
Capture Higher Ed: Merged Records
To customize your Capture Export queries:
Select Queries / Reports from the main navigation.
Select Capture Higher Ed: Prospects Export.
Select Edit Query.
Select Copy. A popup appears.
Configure the following settings:
Destination: New Query
Query Name: Enter a name.
Folder: Optionally select a new folder for the copied query, or select Other to create a new one.
Select Save. You are redirected to the new query's Edit page.
Consult the Capture to Slate Integration guide provided by your Capture client success manager to update, replace, and add new exports and filters to the queries.
Select Schedule Export.
Configure the following settings:
Select Save.
🔔 Do not change the following export settings: Path, Format, Delimiter, Headers, Text Qualifiers, Encoding, and Line Endings.
📖 Further reading
Step 5: Configure remap settings for the source formats
For each Capture Higher Ed source format, the remap settings must be configured.
Capture Higher Ed: New Inquiries
The Capture Higher Ed: New Inquiries source format is pre-configured to match a record and update its status to Inquiry
if the status is not already inquiry or higher.
Capture Higher Ed: Weekly Updates
The Capture Higher Ed: Weekly Updates source format is pre-configured to store the weekly data, including engagement metrics and the calculated Capture Engagement Score (CES) and Capture Affinity Index (CAI) as timestamped Capture Higher Ed research data.
Like the New Inquiries source format, this source format is also configured to upgrade a prospect's status to Inquiry
if it is identified as such in the file.
To configure the remap settings for each source format:
Select Database from the main navigation.
Under Import, select Source Formats.
From the list, select either Capture Higher Ed: Behavioral Data Updates or Capture Higher Ed: New Inquiries.
Select Edit Mappings.
Map the Capture ID to the custom unique field created earlier.
Update the remaining settings according to your institution's needs.
Select Save.
Once you are satisfied with the Remap settings, use the breadcrumb navigation to return to the source format's landing page.
Select Edit.
Set Remap Active to Active.
Select Save.
Repeat these steps for the remaining Capture source format.