HubSpot: Import Contacts and Activity
Import contacts and email activity from HubSpot to drive better engagement through Lytics.
Integration Details
- Implementation Type: Server-side
- Implementation Technique: REST API
- Frequency: Batch
- Resulting data: User profiles, raw event data
If contacts are selected to be imported the following will be repeated until all contacts have been processed:
- A page of contacts will be requested from hubspot
- Any contacts that haven't been modified since Import Contacts Since date will be filtered out.
- The contacts will be ingested into Lytics profiles
If events are selected to be imported the following will be repeated until all email events have been processed:
- A page of email events will be requested from hubspot that have occurred after Import Email Events Since.
- The email events will be ingested into activity on Lytics profiles
Fields
The following fields are included in the default mapping of the hubspot_contacts stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
email(identity-profiles[0].identities[1].value) | email unique id | string | |
| properties.firstname.value | first_name | First Name | string |
| properties.lastname.value | last_name | Last Name | string |
| vid | hs_vid unique id | hubspot Vid | int |
The following fields are included in the default mapping of the hubspot_activity stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
| count(type) | hs_bounce_ct | Hubspot Hard Bounce Count | int |
| count(type) | hs_click_ct | Hubspot Click Count | int |
| count(type) | hs_open_ct | Hubspot OPEN Count | int |
| count(type) | hs_send_ct | Hubspot Send Count | int |
| count(type) | hs_spam_report_ct | Hubspot Soft Bounce Count | int |
| duration | hs_open_duration | Hubspot OPENs Duration | string |
| email(recipient) | email unique id | string | |
| epochms() | hs_send_ts | Hubspot Last Send Time | date |
| max(epochms()) | hs_last_bounce_ts | Hubspot Last Hard Bounce | date |
| max(epochms()) | hs_last_click_ts | Hubspot Last Click | date |
| max(epochms()) | hs_last_open_ts | Hubspot Last OPEN | date |
| max(epochms()) | hs_last_spam_report_ts | Hubspot Last Soft Bounce | date |
| max(epochms()) | last_active_ts | Last Active | date |
| min(epochms()) | hs_first_bounce_ts | Hubspot First Hard Bounce | date |
| min(epochms()) | hs_first_click_ts | Hubspot First Click | date |
| min(epochms()) | hs_first_open_ts | Hubspot First OPEN | date |
| min(epochms()) | hs_first_spam_report_ts | Hubspot First Soft Bounce | date |
| urlmain(url) | hs_email_url | Hubspot URL | string |
| valuect(hash(urlmain(url))) | hashedurls | Hashed URLs Visited | map[string]intsum |
| valuect(hourofday()) | hs_hourly_open | Hubspot Hourly types | map[string]intsum |
| valuect(hourofweek()) | hs_hour_of_week | Hubspot Hour of Week types | map[string]intsum |
| valuect(type) | hs_email_type | Hubspot Email types | map[string]intsum |
| valuect(yymm()) | hs_monthly | Hubspot OPENs By Month | map[string]intsum |
Configuration
Follow these steps to set up and configure an import job for HubSpot in the Lytics platform. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information.
- Select HubSpot from the list of providers.
- Select the import job type from the list.
- Select the Authorization you would like to use or create a new one.
- Enter a Label to identify this job you are creating in Lytics.
- (Optional) Enter a Description for further context on your job.
- Complete the configuration steps for your job.
- (optional) Select the Import Contacts checkbox, to import contacts from Hubspot into Lytics.
- (optional) In the Import Contacts Since text box, enter the date to import contacts from Hubspot that have been modified after this date; yyyy-mm-dd HH:MM:SS format. If left blank, all contacts will be imported.
- (optional) Select the Import Email Events checkbox, to import email events from Hubspot into Lytics.
- (optional) In the Import Email Events Since text box, enter the date to import email events from Hubspot that have occurred after this date; yyyy-mm-dd HH:MM:SS format. If left blank, all email events will be imported.
- (optional) Select the Keep Updated checkbox, to continuously import from Hubspot.
- (Optional) Toggle Show Advanced Options.
- (optional) From the Import Frequency input, select how often a repeated import should run.
- (optional) From the Time of Day input, select the time of day to start the import, ignore for hourly imports.
- (optional) From the Timezone input, select the timezone for time of day.
- Click the Start job button to start the job
