Capture Higher Ed Integration
  • 28 Nov 2023
  • 8 minute read
  • Dark
    Light
  • PDF

Capture Higher Ed Integration

  • Dark
    Light
  • PDF

Article Summary

Capture Higher Ed uses their Behavioral Intelligence Platform to help institutions reduce their marketing spend per student and increase enrollment. This integration allows institutions to send their prospective student data to Capture and to receive engagement scores back from Capture into Slate.

The standard resources necessary for this integration can all be located within the Research Configuration Library, including:

  • Capture Higher Ed research source: Stores weekly engagement scores sent from Capture

  • Capture Higher Ed: Prospects Export query: Exports selected prospective student data to Capture

  • Capture Higher Ed: Merged Records: Exports to Capture records that have been merged in Slate

  • Capture Higher Ed: New Inquiries source format: Imports a daily file from Capture that identifies prospects to upgrade to Inquiry status based on their engagement with Capture campaigns

  • Capture Higher Ed: Weekly Updates source format: Imports a weekly file from Capture that includes updated engagement scores

  • Capture Higher Ed Service Account: Provides Capture SFTP access to pick up files generated by the Capture Higher Ed data export and to drop off weekly and daily files for import into Slate.

Add the Capture Higher Ed Research Source

All of the elements needed for a seamless integration with Capture are in the Research Configuration Library.

To add the Capture Higher Ed Research Source:

  1. Select Database from the top navigation.

  2. Under Configurations, select Research Configurations. 

  3. From the right-hand navigation, select Library.

  4. Select Capture Higher Ed from the list, under the Admissions folder. 

  5. To the right of the the research source name, click the plus sign icon. Add_Research_Source.png A confirmation popup appears.

  6. Select OK. Use the breadcrumb navigation to return to the Research Configuration Library and see that the Capture Higher Ed research source has been added to your database.

Add Additional Capture Configurations

In addition to the data keys needed for the Capture Higher Ed research source and the prompts associated with those data keys, both of which were added to your database automatically, the Capture Higher Ed research source lets you easily add the following items to your database from one convenient location:

  • The Capture Higher Ed Service Account, which provides access to the SFTP subdirectories: /incoming/capturehighered/, /incoming/processed/capturehighered/, and /outgoing/capturehighered/

    • Note: Do not make any changes to the Capture user account.

  • The data keys needed for the Capture source (included by default)

  • The prompts associated with certain data keys (included by default)

  • A query, formatted to Capture specifications, that can be exported as a comma-separated value (CSV) file

  • Two source formats:

    • Capture Higher Ed: New Inquiries

    • Capture Higher Ed: Weekly Updates

To add these additional elements:

  1. Click the plus sign icon Add_Research_Source.png next to the item. A summary popup appears.
    Note: If you do not see this icon next to the item, you may need to refresh your Slate Template Library resources. This can be accomplished using the refresh the Slate Template Library link on the Database > Slate Template Library page.

  2.  Click Add. 

  3. If the item has a confirmation popup, click OK

Now that the Capture items have been added from the library, use the next section to perform additional configurations.

Create a Capture Higher Ed ID field

Capture Higher Ed sends a 36-character unique ID in its data files that can be used for matching purposes on both sides of the integration. Use the following steps to create this custom, unique for merging field:

  1. Select Database from the top navigation.

  2. Under Records, select Fields.

  3. Select New Field

  4. Create a field with the following settings:
    Scope: Person
    Value: Store Value
    Unique for Merging: Value contains a unique ID which identifies a single record for merging. The ID, name, and tab can configured as desired.

    capture.png

  5. Click Save.

Customize the Capture Query and Schedule for Export

The Capture Export query contains 55 export values, arranged and formatted to specifically comply with the standards needed for a file to be consumed within Capture. However, there are certain customizations that must take place before Capture can process records from your database.

Since many of the data points needed by Capture are stored as custom data points within Slate, there are certain placeholder export values that use Literal values to indicate that they need to be replaced. 

To customize your Capture Export query:

  1. Select Queries from Queries / Reports from the main navigation.

  2. Use the search bar to find and select the query Capture Export

  3. Click Edit Query.

  4. Click Save Copy to make a copy of the query so that you can reference the original, standard query or start over if necessary.

    1. Provide a name and (optionally) select a new folder for the copied query.

    2. Click Copy.  This will direct you to the new query's edit page.

  5. For each Literal export that features the text ** Custom (for example, admit_indicator):

    1. Add a new export to the query that targets the appropriate data point within Slate. Give this export the same name as the literal export with which it corresponds.

      Important!

      Refer to the table Capture Higher Ed Export Data Points below these steps to learn which Slate data points the Capture exports refer to.

    2. Adjust the order of the export so that it is directly above or below the placeholder export.

    3. Click the X to delete the placeholder export.

  6. Add additional filter criteria to further limit the records sent to Capture. These filters will largely be determined by your institution's processes and target entry term data.

    Note: By default, the query contains filters that include the required data points that Capture needs to process the record. This includes the existence of a permanent or mailing address, name and email address. 

  7. (Optional) Adjust any standard exports to point to custom data points instead, if desired.

    Note: Make sure that the order of the export in the query, the export name, and the export data type remain the same.

  8. Once the query has been finalized, select Schedule Export from the right. The Schedule Export window appears.

  9. Configure the following settings within Schedule Export:
    Note: File format settings, including the Path, Format, Delimiter, Headers, Text Qualifiers, Encoding, and Line Endings have been pre-configured and should not be adjusted. 

    • Status: Active. This will automate the export.

    • Requested Delivery Window (Eastern Time): Set the time of day at which the export should run. Refer to the article Scheduling Exports for more information. 

    • Requested Weekdays: Select the days of the week at which the export should run. Refer to the article Scheduling Exports for more information. 

      mceclip1.png

Capture Higher Ed Export Data Points

Export Name

Data Point

Description

ref_id

Slate Ref ID

9-digit Slate Ref ID

slate_guid

Slate GUID

36-character uniqueidentifier (used for matching) 

first_name

Prospect First Name

 

last_name

Prospect Last Name

 

email

Prospect Email

 

address_line_1

Prospect Address 1

 

address_line_2

Prospect Address 2

 

city

Prospect City

 

state_abbr

Prospect State

2-character state abbreviation

postal_code

Prospect ZIP

5-digit ZIP Code

county

Prospect County

 

country

Prospect Country

 

home_phone

Prospect Home Phone

 

cell_phone

Prospect Cell Phone

 

gender

Prospect Gender

Values: M = Male; F= Female; Other; Blank

ethnicity

Prospect Race/Ethnicity

**Custom

IPEDs Designations

birth_date

Date of Birth

Date

internal_pipeline_status

Prospect Status

Values: Prospect; Inquiry; Applicant

suspect_indicator

Suspect/Prospect Indicator

Values: Binary (0 or 1)

inquiry_indicator

Inquiry Indicator

Values: Binary (0 or 1)

applicant_indicator

Applicant Indicator

Values: Binary (0 or 1)

admit_indicator

Admit Indicator

**Custom

Values: Binary (0 or 1)

deposit_indicator

Deposit Indicator

**Custom

Values: Binary (0 or 1)

enroll_indicator

Enroll Indicator

**Custom

Values: Binary (0 or 1)

date_of_suspect

Date of Suspect/Prospect

Timestamp of when the record became a Prospect

date_of_inquiry

Date of Inquiry

Timestamp of when the record became an Inquiry

date_of_application

Date of Application

Timestamp of when the record became an Applicant/application completion

date_of_admission

Date of Admission

**Custom

Date/Timestamp of the Admission decision

date_of_deposit

Date of Deposit

**Custom

Date/Timestamp of the Deposit

date_of_enrollment

Date of Enrollment

**Custom

Date/Timestamp of the Enrollment

date_of_first_visit

Date of First Campus Visit

**Custom

Date/Timestamp

application_cancelled

Cancelled Application Indicator

**Custom

Values: Binary (0 or 1)

withdrawn

Withdrawn Indicator

**Custom

Values: Binary (0 or 1)

application_rejected

Application Rejected Indicator

**Custom

Values: Binary (0 or 1)

do_not_contact

Do Not Contact Indicator

Values: Binary (0 or 1)

counselor_assigned

Counselor Assigned

**Custom

Internal value or Name

target_action_year

Enrollment Year

**Custom

4-digit year (e.g., 2021, 2022)

enroll_term

Enrollment Term

**Custom

String (e.g., Fall)

major

Intended Major

**Custom

String

student_type

Student Type

**Custom

String

international

International Indicator

**Custom

Values: Binary (0 or 1)

source_of_prospect

Source of Prospect

**Custom

String

athlete

Recruited Athlete Status

**Custom

String

ip_address

IP Address

List of up to 5 known IP addresses for the record

fafsa

FAFSA Status

**Custom

String

gpa

Prospect GPA

 

act_comp

Prospect Composite ACT

 

sat_total

Prospect Total SAT

 

sat_math

SAT Math Score

 

sat_ebrw

SAT EBRW Score

 

ceeb

High School CEEB Code

 

parent_1_first_name

Parent First Name

 

parent_1_last_name

Parent Last Name

 

parent_1_email

Parent Email Address

 

capture_id

Capture ID

**Custom

Unique custom field storing the Capture ID (configured above)

 Customize the Merged Records Query

The Merged Records query exports to Capture records that were merged in Slate and uses the query base Duplicate Records. Capture receives the information from this export, consolidates any separate records you have marked as merged in Slate, and will return them to Slate in future data transfers from Capture as a single record.

To use the Merged Records query:

  1. Select Queries from Queries / Reports from the main navigation.

  2. Use the search bar to find and select the query Capture Higher Ed: Merged Records

  3. Click Edit Query.

  4. Click Save Copy to make a copy of the query so that you can reference the original, standard query or start over if necessary.

    1. Provide a name and (optionally) select a new folder for the copied query.

    2. Click Copy.  This will direct you to the new query's edit page.

  5. Double-click the Join Unique Capture Field. Confirm that the ID in the Field filter matches the field ID your institution uses to store the Capture Higher Ed ID.

    NOTE: If your institution does not import Capture Higher Ed IDs, this join and filter are unnecessary. See instructions below to deactivate the filter.
    Confirm_ID_Matches.png
    If the ID does not match your Capture Higher Ed ID, edit the filter and update the ID.
    Change_ID_if_Necessary.png

  6. Click Schedule Export.

  7. Set the Status to Active. All remaining settings are preconfigured and can remain as they are.
    Activate_Scheduled_Export.png

  8. Click Save.

Important!

Do not change the order of exports.
Order_of_Exports.png

Deactivating the Filter

If your institution does not import Capture Higher Ed IDs:

  1. Delete the filter Duplicate Records with Capture ID / Status.
    Delete_Filter_-_Duplicate_Records_with_Capture_ID_Status.png

  2. Delete the join Duplicate Records with Capture ID.
    Delete_Join_-_Duplicate_Records_with_Capture_ID.png

With these items deleted, the query includes IDs of all merged records in the data feed.

Configure the Remap Settings for the Source Formats

Once a file has been received from Capture Higher Ed for each of the source formats, the Remap settings must be configured and then activated:

  1. Select Database from the top navigation.

  2. Under Import, select Source Formats.

  3. From the list, select either Capture Higher Ed: Weekly Updates or Capture Higher Ed: New Inquiries.

  4. Select Remap to view the standard, pre-mapped Slate destinations and update the settings according to your institution's needs. Refer to the Source Formats section for additional details on configuring source formats.
    Remember to map the Capture ID to the custom unique field created earlier.
    mceclip1.png
    Note: The Capture Higher Ed: New Inquiries source format is pre-configured to match onto a record and update its status to Inquiry (if the status is not already Inquiry or higher).
    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.

  5. Once you are satisfied with the Remap settings, navigate back to the source format's landing page.

  6. Select Edit from the upper right.

  7. Update Remap Active, to Active.

  8. Repeat for the other Capture source format.

Configure the Integration with Capture Higher Ed

If you are interested in learning more about the integration between Slate and Capture Higher Ed, please request more information at [email protected]
You will need to provide the username for the Capture Higher Ed Service Account so that they can configure the integration on their end.  This can be found using the following steps:
Note: Do not make any adjustments to the service account, as it has been pre-configured with all necessary  settings for the integration.

  1. Select Database from the top navigation.

  2. Select User Permissions.

  3. Select the Capture Higher Ed Service Account from the list of users.

  4. Select the Roles tab.

  5. The Username is found in the SFTP Access section.
    Username within SFTP Access section


Was this article helpful?