SSP Contacts File - Column Reference
Contact/household records with address, communication preferences, and web portal credentials
Quick Reference
| Metric | Value |
|---|---|
| File Name | Contacts.xlsx |
| Total Columns | 17 |
| Required Columns | 1 |
| Primary Key | zk_ContactID |
| Foreign Keys | 0 |
All Columns
| Column Name | Description | Data Type | Required | Compatible S360 Types |
|---|---|---|---|---|
zk_ContactID PK Required |
Contact ID (primary key) | ID/Key | Yes | Plain Text, Single Selection |
EXP_AddressLine1 |
Street address line 1 | Text | No | Plain Text, Formatted Text, Single Selection |
EXP_AddressLine2 |
Street address line 2 | Text | No | Plain Text, Formatted Text, Single Selection |
EXP_City |
City | Text | No | Plain Text, Formatted Text, Single Selection |
EXP_StateProv |
State/province | Text | No | Plain Text, Formatted Text, Single Selection |
EXP_PostalCode |
ZIP/postal code | Text | No | Plain Text, Formatted Text, Single Selection |
Neighborhood |
Neighborhood name | Text | No | Plain Text, Formatted Text, Single Selection |
PhoneHome |
Home phone number | Phone | No | Phone Number, Plain Text |
Language |
Primary language | Text | No | Plain Text, Formatted Text, Single Selection |
Language2 |
Secondary language | Text | No | Plain Text, Formatted Text, Single Selection |
PhotoWaiver |
Photo waiver status | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
OptInRecurringCharges |
Opted in to recurring charges | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
DoNotEmail |
Do not email flag | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
DoNotMail |
Do not mail flag | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
DoNotSolicit |
Do not solicit flag | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
Username |
Web portal username | Text | No | Plain Text, Formatted Text, Single Selection |
Password |
Web portal password | Text | No | Plain Text, Formatted Text, Single Selection |
Field Details by Category
Primary Key
This field uniquely identifies each record and is required for data matching during sync operations.
zk_ContactID- Contact ID (primary key)
Mapping to Simply360
When configuring the SSP integration, map these columns to Data Fields in your Simply360 Data Collections. The "Compatible S360 Types" column above shows which Data Field types can accept data from each SSP column.
Data Type Compatibility Guide
- ID/Key fields → Use
PLAIN_TEXTto store SSP identifiers - Text fields → Use
PLAIN_TEXT,FORMATTED_TEXT, orSINGLE_SELECTION_FROM_LIST - Number fields → Use
NUMBER,DECIMAL, orPERCENTAGE - Currency fields → Use
MONEYfor proper currency formatting - Date fields → Use
DATEorDATE_TIME - Boolean fields → Use
BOOLEANfor yes/no values - Email fields → Use
EMAIL_ADDRESSfor email validation - Phone fields → Use
PHONE_NUMBERfor phone formatting