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.

Cooladata’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 Cooladata project please contact your customer success manager or email us at support@cooladata.com.

 

Table Name: hs_events

FieldDescriptionExample
appIdAn ID referencing the HubSpot Application which sent the email message22809
campaign_idAn ID referencing the HubSpot email which the user interact with49635963
email_nameTitle of the emailTop Deals
email_subjectBody of the emailBeautiful hotels, great prices!
event_idA randomly-generated ID for this event.16103650-83c5-4cdd-9ebc
event_nameName of the action done by the recipientopen/click/sent/bounce
event_time_tsThe actual timestamp when the event occurred42858.7895833
groupIdA unique identifier fot a group of the identical emails (has value in case mail is sent with smart send feature)49566019
hmidA randomly-generated ID which corresponds to the header 'X-HubSpot-MID' in the email message.CiQxNjEwMzY1MC04M2M1LM5...
sent_fromThe 'from' field of the email message.Deals Club "deals@deals.com"
user_emailRecipient's mail addressexample@yahooc.com

 

Table Name: hs_campaigns

FieldDescriptionExample
appIdAn ID referencing the HubSpot Application which sent the email message22809
appNameThe name of the HubSpot Application which sent the email message. Note that this is a derived value, and may be modified at any timeLocalTimeBatch
bouncedThe 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_idUnique idendifier for a single mail sending49635963
click_rateclick / delivered (percentage)12
clickedThe recipient clicked on a link within the message.
contentIdThe 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 times4979414943
deferredThe 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_ratedeliver / sent (percentage)66
deliveredThe recipient's email server has accepted the message and the message has been successfully delivered to the recipient.
droppedThe message was rejected, either by HubSpot or by our delivery provider, and no attempt will be made to deliver the message.
email_nameTitle of the emailTop Deals!
email_subjectBody of the emailBeautiful hotels, great prices!
forwardThe recipient forwarded the message.
groupIdA unique identifier fot a group of the identical emails (has value in case mail is sent with smart send feature)49566019
mta_droppedThe delivery provider decided to drop the message
openThe recipient opened the message.
open_rateopen / delivered (percentage)88
printThe recipient printed the message.
processedThe 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_dateThe date where campaign / email was first created42463
sending_methodWhat is responsible for scheduling the email sendingAUTOMATED_EMAIL, LOCALTIME_EMAIL, AB_EMAIL, BATCH_EMAIL
sentThe message was sent to and received by our delivery provider, which has queued it for further handling.
spamreportThe recipient flagged the message as spam.
statuschangeThe recipient changed her email subscriptions in some way.
unsubscribedThe recipients unsubscribed to your email communications

 

Table Name: hs_campaigns_trend

FieldDescription
appIdAn ID referencing the HubSpot Application which sent the email message
appNameThe name of the HubSpot Application which sent the email message. Note that this is a derived value, and may be modified at any time
bouncedThe 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_idUnique idendifier for a single mail sending
clickedThe recipient clicked on a link within the message.
contentIdThe 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
deferredThe 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.
deliveredThe recipient's email server has accepted the message and the message has been successfully delivered to the recipient.
droppedThe message was rejected, either by HubSpot or by our delivery provider, and no attempt will be made to deliver the message.
email_nameTitle of the email
email_subjectBody of the email
forwardThe recipient forwarded the message.
groupIdA unique identifier fot a group of the identical emails (has value in case mail is sent with smart send feature)
insert_dateThe date in which all data within the record (open,click etc.) refer to
mta_dropped
openThe recipient opened the message.
printThe recipient printed the message.
processedThe 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
sentThe message was sent to and received by our delivery provider, which has queued it for further handling.
spamreportThe recipient flagged the message as spam.
statuschangeThe recipient changed her email subscriptions in some way.
unsubscribed

 

Print Friendly, PDF & Email