Field Mappings & Custom Properties

Configure how HubSpot fields map to Quotient fields and work with custom properties

Overview

Field mappings control how data flows between HubSpot and Quotient, ensuring that information is correctly synchronized between the two systems. Quotient uses a sophisticated two-phase transformation system that combines built-in mappings for critical fields with user-configurable mappings for custom business needs.

How Field Mappings Work

Two-Phase Transformation System

Quotient processes HubSpot data through two distinct phases:

Phase 1: Built-in Transformations

• Non-configurable logic for critical and complex fields
• Handles essential data like email addresses, IDs, and relationships
• Manages complex transformations like address parsing and revenue calculations

Phase 2: Configurable Mappings

• User-customizable mappings for standard and custom fields
• Default mappings provided for common HubSpot properties
• Support for custom properties and business-specific fields

This approach ensures data integrity for critical fields while providing flexibility for your unique business requirements.

Default Field Mappings

Quotient provides sensible default mappings for common HubSpot properties. These can be customized to match your specific needs.

Contact (HubSpot) → Person (Quotient)

HubSpot Field	Quotient Field	Type	Direction
email	emailAddress	Built-in	Bi-directional
firstname	firstName	Default	Inbound
lastname	lastName	Default	Inbound
jobtitle	jobTitle	Default	Inbound
phone	mainPhoneNumber	Default	Inbound
department	department	Default	Inbound

Company (HubSpot) → Company (Quotient)

HubSpot Field	Quotient Field	Type	Direction
name	name	Built-in + Default	Bi-directional
description	description	Default	Inbound
industry	industry	Built-in + Default	Inbound
website	website	Default	Inbound
phone	phoneNumber	Default	Inbound
annualrevenue	revenue	Built-in	Inbound
numberofemployees	totalEmployees	Built-in	Inbound

Built-in Transformations

These transformations are automatically applied and cannot be modified to ensure data integrity:

Contact Built-ins

• emailAddress: Critical for person identification and deduplication
• hubspotId: Maintains sync relationship between systems
• source: Automatically set to "HUBSPOT" for tracking
• associatedCompanyHubspotIds: Preserves company relationships
• Email Marketing Defaults: New contacts default to "NOT_SUBSCRIBED"

Company Built-ins

• Address Parsing: HubSpot's combined address fields are decomposed into:
  • address (street address)
  • city
  • state
  • zip
  • country
• Revenue Processing: Handles currency conversion and formatting
• Industry Arrays: Converts HubSpot industry strings to Quotient arrays
• Social Media Links: Extracts and formats social media URLs

Deal Built-ins

• Pipeline Mapping: Preserves HubSpot pipeline and stage information
• Amount Formatting: Handles currency and decimal formatting
• Date Processing: Converts HubSpot date formats to Quotient standards

Custom Properties

Creating Custom Properties in HubSpot

Before mapping custom properties, ensure they exist in HubSpot:

1. In HubSpot, go to Settings → Properties
2. Select the object type (Contacts, Companies, or Deals)
3. Create a new property with these considerations:
   • Choose an appropriate field type (text, number, date, etc.)
   • Set a clear internal name (this will be used in mappings)
   • Configure field options if using dropdowns or checkboxes

Supported Property Types

Quotient supports all HubSpot property types with automatic data conversion:

HubSpot Type	Quotient Type	Notes
Single-line text	STRING	Direct mapping
Multi-line text	STRING	Preserves line breaks
Number	NUMBER	Handles decimals and integers
Date picker	DATE	Date only, no time
Date & time picker	DATETIME	Full timestamp with timezone
Dropdown select	ENUM	Maps option values
Multiple checkboxes	ENUM	Semicolon-separated values
Radio select	ENUM	Single value selection
Yes/No	BOOLEAN	True/false values
HubSpot user	USER	Maps to Quotient users

Mapping Custom Properties

To create a custom field mapping:

1. Navigate to HubSpot integration settings
2. Go to Field Mappings section
3. Click "Add Field Mapping"

4. Select the HubSpot Field: Choose from available HubSpot properties

5. Configure the mapping:
   • Quotient Field: Choose existing field or create new custom property
   • Data Type: Automatically detected but can be overridden
   • Sync Direction: Choose Inbound, Outbound, or Bi-directional

Example: Custom Lead Score Mapping

Let's say you have a custom "Lead Score" property in HubSpot that you want to sync to Quotient:

HubSpot Setup:

• Property name: lead_score
• Type: Number
• Used for: Lead qualification scoring

Quotient Mapping:

• HubSpot Field: lead_score
• Quotient Field: leadScore (custom property)
• Data Type: NUMBER
• Direction: INBOUND (HubSpot is the source of truth)

Advanced Mapping Scenarios

Handling Enumeration Fields

For HubSpot dropdown and checkbox properties:

HubSpot Options:

- Option 1: "Enterprise"
- Option 2: "Mid-Market"
- Option 3: "SMB"

Quotient Mapping:

• Values are mapped exactly as they appear in HubSpot
• Multiple selections are joined with semicolons
• Empty selections map to null values

Date and Time Handling

Date Fields:

• HubSpot date-only fields map to Quotient DATE type
• Time information is ignored for date-only fields
• Timezone is preserved for datetime fields

DateTime Fields:

• Full timestamp with timezone information
• Automatic conversion between HubSpot and Quotient formats
• Handles daylight saving time transitions

User and Owner Mappings

HubSpot Owner Fields:

• hubspot_owner_id maps to Quotient user assignments
• Requires users to exist in both systems
• Falls back to null if user mapping not found

Managing Field Mappings

Viewing Current Mappings

In the HubSpot integration settings:

1. Default Mappings: Pre-configured mappings for standard fields
2. Custom Mappings: Your business-specific field mappings
3. System Mappings: Built-in mappings that cannot be modified

Modifying Mappings

To Edit a Mapping:

1. Find the mapping in the Field Mappings section
2. Click the edit icon
3. Modify the configuration
4. Save changes (triggers a sync for affected records)

To Delete a Mapping:

1. Click the delete icon next to the mapping
2. Confirm the deletion
3. Data previously synced through this mapping remains unchanged

Testing Mappings

Field Mapping Validation:

• Test mappings with sample data before full deployment
• Use the "Test Sync" feature for individual records
• Monitor sync logs for mapping errors or data type issues

Troubleshooting Field Mappings

Common Issues

Data Not Syncing

• Verify the field exists in both HubSpot and Quotient
• Check that data types are compatible
• Ensure the mapping direction allows the desired data flow

Data Type Errors

• Review HubSpot property type vs Quotient field type
• Check for invalid data in source fields (e.g., text in number fields)
• Verify enumeration options match between systems

Missing Custom Properties

• Ensure custom properties are created in HubSpot first
• Check property permissions and visibility settings
• Verify the property is associated with the correct object type

Best Practices

Naming Conventions

• Use consistent naming between HubSpot and Quotient
• Avoid special characters in custom property names
• Use descriptive names that indicate the field's purpose

Data Type Selection

• Choose the most restrictive appropriate data type
• Use ENUM for fields with limited, known values
• Use STRING for flexible text fields

Sync Direction Strategy

• Use INBOUND when HubSpot is the authoritative source
• Use OUTBOUND when Quotient generates the data
• Use BIDIRECTIONAL carefully to avoid sync conflicts

Next Steps

Once you've configured field mappings:

1. Set Up List Synchronization - Configure list and segment sync
2. Enable Email Sync - Sync email templates and broadcasts
3. Monitor Sync Performance - Track and optimize sync operations

---

HubSpot Help Resources:

• HubSpot Properties Guide - How to create and manage properties
• Custom Properties in HubSpot - Step-by-step property creation
• HubSpot CRM Setup - General CRM configuration help