Hubspot
Hubspot's services are centered around sales and marketing tools that help a company refocus their marketing efforts into inbound marketing. With Hubspot, a company can create content that attracts leads that are already interested in that company's products and services. Then, users can take advantage of Hubspot's marketing tools to collect contact information and customize visitors' experiences so that they are more likely to make the conversion from interested leads into happy customers.
Journey Analytics's integration with HubSpot empowers marketers to understand the entire user journey, from when the initial email campaign is sent to when the user converts. Critical email campaign decisions can be made based on a deeper time series analysis of email campaigns.
The integration runs daily, updating the previous day's end of day data in each table. See the full tables schemes below.
- hs_events: all events sent to Hubspot.
- hs_campaigns: contains one entry for each campaign, showing the latest aggregated data for that campaign.
- hs_campaigns_trend: contains the daily aggregated data for each campaign on each day, so you can analyze the campaign's performance over time.
To integrate Hubspot to your Journey Analytics project please contact your customer success manager or Medallia Support.
Table Name: hs_events
| Field | Description | Example |
|---|---|---|
| appId | An ID referencing the HubSpot Application which sent the email message | 22809 |
| campaign_id | An ID referencing the HubSpot email which the user interact with | 49635963 |
| email_name | Title of the email | Top Deals |
| email_subject | Body of the email | Beautiful hotels, great prices! |
| event_id | A randomly-generated ID for this event. | 16103650-83c5-4cdd-9ebc |
| event_name | Name of the action done by the recipient | open/click/sent/bounce |
| event_time_ts | The actual timestamp when the event occurred | 42858.7895833 |
| groupId | A unique identifier fot a group of the identical emails (has value in case mail is sent with smart send feature) | 49566019 |
| hmid | A randomly-generated ID which corresponds to the header 'X-HubSpot-MID' in the email message. | CiQxNjEwMzY1MC04M2M1LM5... |
| sent_from | The 'from' field of the email message. | Deals Club "deals@deals.com" |
| user_email | Recipient's mail address | example@yahooc.com |
Table Name: hs_campaigns
| Field | Description | Example |
|---|---|---|
| appId | An ID referencing the HubSpot Application which sent the email message | 22809 |
| appName | The name of the HubSpot Application which sent the email message. Note that this is a derived value, and may be modified at any time | LocalTimeBatch |
| bounced | The recipient's email server could not or would not accept the message, and no further attempts will be made to deliver the message. This is also referred to as a hard bounce. | |
| campaign_id | Unique idendifier for a single mail sending | 49635963 |
| click_rate | click / delivered (percentage) | 12 |
| clicked | The recipient clicked on a link within the message. | |
| contentId | The id of the email content, basically what you'd be editing in HubSpot. It's possible to have two campaigns for a single contentId if you send the same email multiple times | 4979414943 |
| deferred | The recipient's email server has temporarily rejected message, and subsequent attempts will be made to deliver the message. This is also referred to as a soft bounce. | |
| deliver_rate | deliver / sent (percentage) | 66 |
| delivered | The recipient's email server has accepted the message and the message has been successfully delivered to the recipient. | |
| dropped | The message was rejected, either by HubSpot or by our delivery provider, and no attempt will be made to deliver the message. | |
| email_name | Title of the email | Top Deals! |
| email_subject | Body of the email | Beautiful hotels, great prices! |
| forward | The recipient forwarded the message. | |
| groupId | A unique identifier fot a group of the identical emails (has value in case mail is sent with smart send feature) | 49566019 |
| mta_dropped | The delivery provider decided to drop the message | |
| open | The recipient opened the message. | |
| open_rate | open / delivered (percentage) | 88 |
| The recipient printed the message. | ||
| processed | The message has been received by our delivery provider, which has indicated it will attempt to deliver the message to the recipient's email server. | |
| selected | ||
| send_date | The date where campaign / email was first created | 42463 |
| sending_method | What is responsible for scheduling the email sending | AUTOMATED_EMAIL, LOCALTIME_EMAIL, AB_EMAIL, BATCH_EMAIL |
| sent | The message was sent to and received by our delivery provider, which has queued it for further handling. | |
| spamreport | The recipient flagged the message as spam. | |
| statuschange | The recipient changed her email subscriptions in some way. | |
| unsubscribed | The recipients unsubscribed to your email communications |
Table Name: hs_campaigns_trend
| Field | Description |
|---|---|
| appId | An ID referencing the HubSpot Application which sent the email message |
| appName | The name of the HubSpot Application which sent the email message. Note that this is a derived value, and may be modified at any time |
| bounced | The recipient's email server could not or would not accept the message, and no further attempts will be made to deliver the message. This is also referred to as a hard bounce. |
| campaign_id | Unique identifier for a single mail sending |
| clicked | The recipient clicked on a link within the message. |
| contentId | The id of the email content, basically what you'd be editing in HubSpot. It's possible to have two campaigns for a single contentId if you send the same email multiple times |
| deferred | The recipient's email server has temporarily rejected message, and subsequent attempts will be made to deliver the message. This is also referred to as a soft bounce. |
| delivered | The recipient's email server has accepted the message and the message has been successfully delivered to the recipient. |
| dropped | The message was rejected, either by HubSpot or by our delivery provider, and no attempt will be made to deliver the message. |
| email_name | Title of the email |
| email_subject | Body of the email |
| forward | The recipient forwarded the message. |
| groupId | A unique identifier fot a group of the identical emails (has value in case mail is sent with smart send feature) |
| insert_date | The date in which all data within the record (open,click etc.) refer to |
| mta_dropped | |
| open | The recipient opened the message. |
| The recipient printed the message. | |
| processed | The message has been received by our delivery provider, which has indicated it will attempt to deliver the message to the recipient's email server. |
| selected | |
| sent | The message was sent to and received by our delivery provider, which has queued it for further handling. |
| spamreport | The recipient flagged the message as spam. |
| statuschange | The recipient changed her email subscriptions in some way. |
| unsubscribed |
