/
Property Mapping and List Importing

Property Mapping and List Importing


About HubSpot Property Mapping and List Importing

HubSpot Property Mapping and HubSpot List Importing are essential tools for efficiently managing and organizing your data within HubSpot CRM. Together, these features streamline the import process, maintain data consistency, and improve overall productivity by making your data manageable and actionable within HubSpot CRM.

HubSpot Property Mapping ensures that each field of your data corresponds accurately to a specific HubSpot property, such as student information fields (e.g., First Name, Email, Program). Mapping each data field to the appropriate HubSpot property makes tracking, updating, and managing records within the CRM easier.

HubSpot List Importing allows you to upload and organize bulk data from an external file (typically in CSV or Excel format) directly into HubSpot. This process is highly beneficial for importing student data, contacts, companies, deals, or other records and ensures that all your information is centrally stored and easily accessible for future use.


HubSpot Property Mapping

The table below defines HubSpot properties that correspond to essential student information fields. Mapping each student data field to a specific HubSpot property ensures efficient tracking, updating, and management of student records within HubSpot. Each field is described with a clear explanation of its purpose and how it should be used.

The descriptions include examples to help maintain consistency and accuracy when entering or importing data. This mapping ensures that all student information is organized correctly, making it easier to segment, communicate, and report on student data within HubSpot.

Field

HubSpot Property

Description/Example

First Name

First Name

Description: The student's first name.
Example: John

Last Name

Last Name

Description: The student's last name.
Example: Doe

Maricopa Email

Email

Description: The student’s primary email address, typically provided by the college.
Example: johndoe@maricopa.edu

Personal Email

Additional Email Address

Description: Additional Email fields (Personal and Home) allow for more than one email for the student in HubSpot, which may help in cases where there is a preferred email that’s not their Maricopa email.
Example: john.doe@gmail.com

Home Email

Additional Email Address

Description: Additional Email fields (Personal and Home) allow for more than one email for the student in HubSpot, which may help in cases where there is a preferred email that’s not their Maricopa email.
Example: john.doe123@outlook.com

Phone

Phone Number

Description: The student's phone number for contact. Include the country code and extension, if applicable.
Example: +1 1234567890

Student MEID

Student MEID Number

Description: The unique student identifier in the Maricopa system.
Example: 12345678

Application Date

Application Date

Description: The date the student applied to the college.
Example: 01/15/2024

Enrollment Status

Student Lifecycle

Description: The student’s current status in the enrollment process (e.g., Enrolled, Accepted, etc.).
Example: Enrolled

FOI

FOI

Description: The field of interest or the area of study the student is pursuing.
Example: Healthcare

Academic Program

Program Award

Description: The specific academic program or degree the student is pursuing.
Example: Associate of Science in Nursing

HS Status

Are You Currently a High School Student?

Description: Indicates whether the student is currently a high school student.
Example: Yes

High School

High School

Description: The name of the high school the student attended or is currently attending.
Example: Desert Ridge High School

High School Graduation Date

High School Graduation Date

Description: The expected or actual date the student will graduate from high school.
Example: 05/2025

Admit Term (by College)

Admit Term

Description: The term (e.g., Fall, Spring) the student was admitted for.
Example: Fall 2024

FAFSA Aid Year

FAFSA Aid Year

Description: The financial aid year for which the student has applied for aid.
Example: 2024-2025

FAFSA Status

FAFSA Status

Description: The status of the student's FAFSA application (e.g., Submitted, Completed, Pending).
Example: Completed

College

Business Units

Description: The name of the college the student is attending (if applicable, may be part of a larger district).
Example: GateWay Community College

SMS Opt-Out

Salesmsg: Opt-in Status

Description: SMS Opt-Out is important for communication preferences and compliance with privacy preferences.
Example: Opt-in

SID

Student ID

Description: The student's unique identification number used by the institution.
Example: 987654321

Specific programs such as Trades, Social Media Marketing, Cybersecurity, Administrative Professional, etc

Program

Description: Refers to the specific program or course the student is enrolled in or is interested in. It is more focused on the exact field or course of study the student is pursuing. This could be a specific degree or certificate program.
Example: Cybersecurity, trade programs, certifications, etc

Student's Program of Interest is any of:
Accounting, Banking, and Finance, Artificial Intelligence, Automotive and Collision Repair, Aviation & Aircraft Maintenance Technology, Behavioral Science and Human Services, Business, Construction and Trades, Education, Environmental Studies, Health and Fitness, Healthcare, Hospitality, Tourism, and Culinary Arts, Information Technology, Law, Public Safety, Corrections & Security, Liberal Arts, Manufacturing, Nursing, Science, Technology, Engineering and Mathematics, Undecided, University Transfer, Visual and Performing Arts, Web Design, Programming and Mobile Applications

Program Area

Description: Refers to the broad category or field that encompasses related programs. It groups similar programs into broader categories based on career paths, skills, or industries. This helps to classify a group of programs that share a common focus.
Example: Healthcare, Business, Visual and Performing Arts, Information Technology

Classes

Classes

Description: The specific classes the student is enrolled in or interested in taking.
Example: Introduction to Programming, Algebra 101

Lead Status

Student Lifecycle

Description: This mapping will help you align Lead Status with Student Lifecycle in HubSpot, ensuring consistency and clarity when tracking students' progress through various stages.

Stages

  • Prospect: A potential student who has shown interest but has not yet applied.

  • Application Started: A student who has begun the application process but hasn't completed it yet.

  • Applicant: A student who has completed their application and is now under review.

  • Matriculate: A student who has been accepted and is preparing to attend.

  • Enrolled: A student who is actively enrolled in classes.

  • Graduate: A student who has completed their program and graduated.

  • Employee: Faculty or staff


HubSpot List Importing

HubSpot List Importing is a powerful feature within HubSpot that allows you to upload and organize data directly into the HubSpot CRM. This process involves importing a list of records, such as student data, contacts, or any other relevant information, from an external file (typically in CSV or Excel format) into HubSpot. This feature ensures that your data is centrally managed and easily accessible for future use, such as communications, reporting, or segmentation.

How to Use the List Import Template:

  1. Prepare Your Data: Ensure the student data you want to import is organized in a spreadsheet or CSV format with columns corresponding to the fields in the template.

  2. Correct Column Headers: Ensure that the column headers in your file exactly match the HubSpot Property names in the template (e.g., "First Name," "Email," "Program," etc.). Align your columns with the HubSpot Property names.

  3. Import to HubSpot: Once your data is formatted according to the mapping, use HubSpot's import functionality to upload the list into the system.

  4. Verify the Mapping: During the import process, HubSpot will allow you to map each field in your file to the corresponding property in HubSpot. Double-check that each column matches the correct property.

  5. Finalize the Import: After mapping, confirm and finish the import. Your student data will now be organized in HubSpot and available for further actions like segmentation, reporting, and communication.

https://docs.google.com/spreadsheets/d/1SA4KzsX0N3nbsBusywkb-h9XRxzZoLLAxueRA_0EJWw/edit?gid=2033466119#gid=2033466119


Related content