Connect HubSpot to Snowflake

snowflake hubspot integration

Stream contact, customer, lead, deal, pipeline and contract data from HubSpot to Snowflake

Connect Hubspot to Snowflake in 2023

It is very simple to connect HubSpot to Snowflake, it can be done in a fast and easy manner with Windsor.ai.

 

First Step

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. 
  2. Create the WINDSOR_UPLOAD role (name has no importance) 
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
  • Get the username 
  • Get the password 
  • Get the account 
  • Get the warehouse 
  • Get the database 
  • Get the schema 
  • Get the table name 

 

Second step

1.You need to select Hubspot as a Data Source and Grant Access to Windsor.ai.

hubspot looker studio integration

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3. Enter all the credentials required and click Save

4. Your data will now be streamed from Linkedin Ads to Snowflake. In case there is an error you will be notified.

HubSpot metrics and dimensions available for streaming into Snowflake

Connect your data

 

nametypedescription
Account IDTEXTYour Hubspot account ID
Account NameTEXTYour Hubspot account name
Contact Company Name (Alias)TEXTAlias for contact_company
Company About UsTEXTShort about-company
Company Street AddressTEXTThe street address of the company or organization, including unit number. Powered by HubSpot Insights.
Company Street Address 2TEXTThe additional address of the company or organization. Powered by HubSpot Insights.
Company Annual RevenueNUMERICThe actual or estimated annual revenue of the company. Powered by HubSpot Insights.
Company CityCITYThe city where the company is located. Powered by HubSpot Insights.
Company Close DateTIMESTAMPThe date the company or organization was closed as a customer
Company Country/RegionCOUNTRYThe country/region in which the company or organization is located. Powered by HubSpot Insights.
Company Create DateTIMESTAMPThe date the company or organization was added to the database
Company Days to CloseNUMERICThe number of days between when the company record was created and when they closed as a customer.
Company DescriptionTEXTA short statement about the company's mission and goals. Powered by HubSpot Insights.
Company Domain NameTEXTThe domain name of the company or organization
Company Date of last meeting booked in meetings toolTIMESTAMPThe date of the most recent meeting an associated contact has booked through the meetings tool.
Company Campaign of last booking in meetings toolTEXTThis UTM parameter shows which marketing campaign (e.g. a specific email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Company Medium of last booking in meetings toolTEXTThis UTM parameter shows which channel (e.g. email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Company Source of last booking in meetings toolTEXTThis UTM parameter shows which site (e.g. Twitter) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Company Facebook Company PageTEXTThe URL of the Facebook company page for the company or organization
Company Facebook FansNUMERICNumber of facebook fans
Company First Contact Create DateTIMESTAMPThe date that the first contact from this company entered the system, which could pre-date the company's create date
Company First Conversion DateTIMESTAMPThe first conversion date across all contacts associated this company or organization
Company First ConversionTEXTThe first form submitted across all contacts associated this company or organization
Company First Deal Created DateTIMESTAMPThe create date of the first deal associated with this company record.
Company Year FoundedTEXTThe year the company was created. Powered by HubSpot Insights.
Company Google Plus PageTEXTThe URL of the Google Plus page for the company or organization
Company Time First SeenTIMESTAMPThe first activity for any contact associated with this company or organization
Company First Touch Converting CampaignTEXTThe campaign responsible for the first touch creation of the first contact associated with this company
Company Time of First SessionTIMESTAMPTime of first session across all contacts associated with this company or organization
Company Time Last SeenTIMESTAMPTime last seen across all contacts associated with this company or organization
Company Last Touch Converting CampaignTEXTThe campaign responsible for the last touch creation of the first contact associated with this company
Company Time of Last SessionTIMESTAMPTime of the last session attributed to any contacts that are associated with this company record.
Company Number of PageviewsNUMERICTotal number of page views across all contacts associated with this company or organization
Company Number of SessionsNUMERICTotal number of sessions across all contacts associated with this company or organization
Company Original Source TypeTEXTOriginal source for the contact with the earliest activity for this company or organization
Company Original Source Data 1TEXTAdditional information about the original source for the contact with the earliest activity for this company or organization
Company Original Source Data 2TEXTAdditional information about the original source for the contact with the earliest activity for this company or organization
Company object create date/timeTIMESTAMPThe date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
Company Ideal Customer Profile TierTEXTThis property shows how well a Company matches your Ideal Customer Profile. Companies that are Tier 1 should be a great fit for your products/services where Tier 3 might be acceptable, but low priority
Company Target AccountBOOLEANThe Target Account property identifies the companies that you are marketing and selling to as part of your account-based strategy.
Company Last Booked Meeting DateTIMESTAMPThe last date of booked meetings associated with the company
Company Last Logged Call DateTIMESTAMPThe last date of logged calls associated with the company
Company Last Open Task DateTIMESTAMPThe last due date of open tasks associated with the company
Company Last Engagement DateTIMESTAMPThe last time a contact engaged with your site or a form, document, meetings link, or tracked email. This doesn't include marketing emails or emails to multiple contacts.
Company Last Modified DateTIMESTAMPMost recent timestamp of any property update for this company. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
Company Lead StatusTEXTThe company's sales, prospecting or outreach status
Company Number of blockersNUMERICThe number of contacts associated with this company with the role of blocker.
Company Number of child companiesNUMERICThe number of child companies of this company
Company Number of contacts with a buying roleNUMERICThe number of contacts associated with this company with a buying role.
Company Number of decision makersNUMERICThe number of contacts associated with this company with the role of decision maker.
Company Number of open dealsNUMERICThe number of open deals associated with this company.
Company IDNUMERICThe unique ID for this company. This unique ID is automatically populated by HubSpot and cannot be changed.
Parent CompanyNUMERICThe parent company of this company
Company Likelihood to closeNUMERICThe highest probability that a contact associated with this company will become a customer within the next 90 days. This score is based on standard contact properties and behavior.
Company Total open deal valueNUMERICThe total value, in your company's currency, of all open deals associated with this company
Company Owner Assigned DateTIMESTAMPThe timestamp when an owner was assigned to this company
Company ownerTEXTThe owner of the company
Company HubSpot TeamTEXTThe team of the owner of the company.
Company IndustryTEXTThe type of business the company performs. By default, this property has approximately 150 pre-defined options to select from. While these options cannot be deleted as they used by HubSpot Insights, you can add new custom options to meet your needs.
Company Is PublicBOOLEANIndicates that the company is publicly traded. Powered by HubSpot Insights.
Company Lifecycle StageTEXTThe most advanced lifecycle stage across all contacts associated with this company or organization
LinkedIn Company PageTEXTThe URL of the LinkedIn company page for the company or organization
Company LinkedIn BioTEXTThe LinkedIn bio for the company or organization
Company Name (Duplicate)TEXTThe name of the company or organization. Powered by HubSpot Insights.
Company Last ContactedTIMESTAMPThe last timestamp when a call, email or meeting was logged for a contact at this company.
Company Last Activity DateTIMESTAMPThe last time a note, call, meeting, or task was logged for a company. This is set automatically by HubSpot based on user actions in the company record.
Company Next Activity DateTIMESTAMPThe date of the next upcoming scheduled sales activity for this company record.
Company Associated ContactsNUMERICThe number of contacts associated with this company
Company Associated DealsNUMERICThe number of deals associated with this company
Company Number of times contactedNUMERICThe number of times a call, email or meeting was logged for this company
Company Number of Form SubmissionsNUMERICThe number of forms submission for all contacts associated with this company or organization
Company Number of EmployeesNUMERICThe total number of employees who work for the company or organization
Company HubSpot Owner EmailTEXTHubSpot owner email for this company or organization
Company HubSpot Owner NameTEXTHubSpot owner name for this company or organization
Company Phone NumberTEXTA company's primary phone number. Powered by HubSpot Insights.
Company Recent Conversion DateTIMESTAMPThe most recent conversion date across all contacts associated this company or organization
Company Recent ConversionTEXTThe last form submitted across all contacts associated this company or organization
Company Recent Deal AmountNUMERICThe amount of the last deal closed
Company Recent Deal Close DateTIMESTAMPThe date of the last `closed won` deal associated with this company record.
Company State/RegionREGIONThe state or region in which the company or organization is located. Powered by HubSpot Insights.
Company Time ZoneTEXTThe time zone where the company or organization is located. Powered by HubSpot Insights.
Company Total Money RaisedTEXTThe total amount of money raised by the company. Powered by HubSpot Insights.
Company Total RevenueNUMERICThe total amount of closed won deals
Company Twitter BioTEXTThe Twitter bio of the company or organization
Company Twitter FollowersNUMERICThe number of Twitter followers of the company or organization
Company Twitter HandleTEXTThe main twitter account of the company or organization
Company TypeTEXTThe optional classification of this company record - prospect, partner, etc.
Company Web TechnologiesTEXTThe web technologies used by the company or organization. Powered by HubSpot Insights.
Company Website URLTEXTThe main website of the company or organization. This property is used to identify unique companies. Powered by HubSpot Insights.
Company Postal CodeTEXTThe postal or zip code of the company or organization. Powered by HubSpot Insights.
Contact Street AddressTEXTA contact's street address, including apartment or unit #
Contact Annual RevenueTEXTAnnual company revenue
Contact CityCITYA contact's city of residence
Contact Close DateTIMESTAMPThe date that a contact became a customer. This property is set automatically by HubSpot when a deal or opportunity is marked as closed-won. It can also be set manually or programmatically.
Contact Company NameTEXTThe name of the contact's company. This is separate from the Name property of the contact's associated company and can be set independently.
Contact Company sizeTEXTA contact's company size. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
Contact Country/RegionCOUNTRYThe contact's country/region of residence. This might be set via import, form, or integration.
Contact Create DateTIMESTAMPThe date that a contact entered the system
Contact Currently in workflowTEXTIf the contact is currently enrolled in any workflow
Contact Date of birthTEXTA contact's date of birth. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
Contact Days To CloseNUMERICThe days that elapsed from when a contact was created until they closed as a customer. This is set automatically by HubSpot and can be used for segmentation and reporting.
Contact DegreeTEXTA contact's degree. This property is required for the Facebook Ads Integration. This property will be automatically synced to via Lead Ads tool
Contact EmailTEXTA contact's email address
Contact date of last meeting booked in meetings toolTIMESTAMPThe date of the most recent meeting a contact has booked through the meetings tool.
Contact Campaign of last booking in meetings toolTEXTThis UTM parameter shows which marketing campaign (e.g. a specific email) referred the contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Contact Medium of last booking in meetings toolTEXTThis UTM parameter shows which channel (e.g. email) referred the contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Contact Source of last booking in meetings toolTEXTThis UTM parameter shows which site (e.g. Twitter) referred the contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Contact Fax NumberTEXTA contact's primary fax number
Contact Field of studyTEXTA contact's field of study. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
Contact First Conversion DateTIMESTAMPThe date this contact first submitted a form
Contact First ConversionTEXTThe first form this contact submitted
Contact First Deal Created DateTIMESTAMPThe date the first deal for a contact was created. This is automatically set by HubSpot and can be used for segmentation and reporting.
Contact First NameTEXTA contact's first name
Contact Follower CountNUMERICThe number of Twitter followers a contact has
Contact GenderTEXT
Contact Graduation dateTEXTA contact's graduation date. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
Contact Average PageviewsNUMERICThe average number of pages a contact sees. This is automatically set by HubSpot for each contact.
Contact First Referring SiteTEXTThe first website that referred a contact to your website. This is automatically set by HubSpot for each contact.
Contact Time First SeenTIMESTAMPThe first time a contact has been seen. This is automatically set by HubSpot for each contact.
Contact First Touch Converting CampaignTEXTThe campaign responsible for the first touch creation of this contact
Contact First Page SeenTEXTThe first page a contact saw on your website. This is automatically set by HubSpot for each contact.
Contact time of First SessionTIMESTAMPThe first time a contact visited your website. This is automatically set by HubSpot for each contact.
Contact Last Referring SiteTEXTThe last website that referred a contact to your website. This is automatically set by HubSpot for each contact.
Contact Time Last SeenTIMESTAMPThe last time and date a contact has viewed a page on your website.
Contact Last Touch Converting CampaignTEXTThe campaign responsible for the last touch creation of this contact
Contact Last Page SeenTEXTThe last page a contact saw on your website. This is automatically set by HubSpot for each contact.
Contact time of Last SessionTIMESTAMPThe last time and date a contact visited your website.
Contact Number of event completionsNUMERICThe sum of all events a contact has experienced. This is automatically set by HubSpot for each contact.
Contact Number of PageviewsNUMERICThe sum of all pages a contact has seen on your website. This is automatically set by HubSpot for each contact.
Contact Number of SessionsNUMERICThe sum of all sessions a contact has made to your website. This is automatically set by HubSpot for each contact.
Contact Event RevenueNUMERICEvent revenue can be set on a contact though HubSpot's enterprise Events. http://help.hubspot.com/articles/KCS_Article/Reports/How-do-I-create-Events-in-HubSpot
Contact Original SourceTEXTFirst known source the contact used to find your website. Set automatically, but may be updated manually.
Contact Original Source Drill-Down 1TEXTAdditional information about the source through which a contact first found your website. This property is automatically set by HubSpot.
Contact Original Source Drill-Down 2TEXTAdditional information about the source through which a contact first found your website. This property is automatically set by HubSpot.
Contact Buying RoleTEXTThe role that a contact plays during the sales process. Contacts can have more than one role, and they can share the same role with another contact.
Contact Email ConfirmedBOOLEANEmail Confirmation status of user of Content Membership
Contact Membership NotesTEXTThe notes relating to the contact's content membership.
Contact Registered AtTIMESTAMPDatetime at which this user was set up for Content Membership
Contact Domain to which registration email was sentTEXTDomain to which the registration invitation email for Content Membership was sent to
Contact Time registration email was sentTIMESTAMPDatetime at which this user was sent a registration invitation email for Content Membership
Contact StatusTEXTThe status of the contact's content membership.
Contact Object create date/timeTIMESTAMPThe date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
Contact Invalid email addressBOOLEANThe email address associated with this contact is invalid.
Contact Marketing emails bouncedNUMERICThe number of marketing emails that bounced for the current email address. This is automatically set by HubSpot.
Contact Marketing emails clickedNUMERICThe number of marketing emails which have had link clicks for the current email address. This is automatically set by HubSpot.
Contact Email address quarantine reasonTEXTThe reason why the email address has been quarantined.
Contact Marketing emails deliveredNUMERICThe number of marketing emails delivered for the current email address. This is automatically set by HubSpot.
Contact Email DomainTEXTA contact's email address domain
Contact First marketing email click dateTIMESTAMPThe date of the earliest link click for any marketing email to the current email address. This is automatically set by HubSpot.
Contact Concat first marketing email open dateTIMESTAMPThe date of the earliest open for any marketing email to the current email address. This is automatically set by HubSpot.
Contact First marketing email reply dateTIMESTAMPThe date of the earliest reply for any marketing email to the current email address. This is automatically set by HubSpot.
Contact first marketing email send dateTIMESTAMPThe date of the earliest delivery for any marketing email to the current email address. This is automatically set by HubSpot.
Contact Email hard bounce reasonTEXTThe issue that caused a contact to hard bounce from your emails. If this is an error or a temporary issue, you can unbounce this contact from the contact record.
Contact last marketing email click dateTIMESTAMPThe date of the most recent link click for any marketing email to the current email address. This is automatically set by HubSpot.
Contact Last marketing email nameTEXTThe name of the last marketing email sent to the current email address. This is automatically set by HubSpot.
Contact Last marketing email open dateTIMESTAMPThe date of the most recent open for any marketing email to the current email address. This is automatically set by HubSpot.
Contact Last marketing email reply dateTIMESTAMPThe date of the latest reply for any marketing email to the current email address. This is automatically set by HubSpot.
Contact Contac last marketing email send dateTIMESTAMPThe date of the most recent delivery for any marketing email to the current email address. This is automatically set by HubSpot.
Contact Marketing emails openedNUMERICThe number of marketing emails opened for the current email address. This is automatically set by HubSpot.
Contact Unsubscribed from all emailBOOLEANIndicates that the current email address has opted out of all email.
Contact Email Address QuarantinedBOOLEANIndicates that the current email address has been quarantined for anti-abuse reasons and any marketing email sends to it will be blocked. This is automatically set by HubSpot.
Contact Email address automated quarantine reasonTEXTThe automated reason why the email address has been quarantined.
Contact Marketing emails repliedNUMERICThe number of marketing emails replied to by the current email address. This is automatically set by HubSpot.
Contact Sends Since Last EngagementNUMERICThe number of marketing emails that have been sent to the current email address since the last engagement (open or link click). This is automatically set by HubSpot.
Contact Marketing email confirmation statusTEXTThe status of a contact's eligibility to receive marketing email. This is automatically set by HubSpot.
Contact Facebook click idTEXT
Contact Last NPS survey commentTEXTLast NPS survey comment that this contact gave
Contact Last NPS survey ratingTEXTLast NPS survey rating that this contact gave
Contact Last NPS survey dateTIMESTAMPThe time that this contact last submitted a NPS survey response. This is automatically set by HubSpot.
Contact Google ad click idTEXT
Contact IP TimezoneTEXTThe timezone reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
Contact unworkedBOOLEANContact has not been assigned or has not been engaged after last owner assignment/re-assignment
Contact Preferred languageTEXTSet your contact's preferred language for communications. This property can be changed from an import, form, or integration.
Contact Last Engagement DateTIMESTAMPThe last time a contact engaged with your site or a form, document, meetings link, or tracked email. This doesn't include marketing emails or emails to multiple contacts.
Contact Last sequence ended dateTIMESTAMPThe last sequence ended date.
Contact Last sequence enrolledNUMERICThe last sequence enrolled.
Contact Last sequence enrolled dateTIMESTAMPThe last sequence enrolled date.
Contact Lead StatusTEXTThe contact's sales, prospecting or outreach status
TEXTLegal basis for processing contact's data; 'Not applicable' will exempt the contact from GDPR protections
Contact Became a Customer DateTIMESTAMPThe date when a contact's lifecycle stage changed to Customer. This is automatically set by HubSpot for each contact.
Contact Became an Evangelist DateTIMESTAMPThe date when a contact's lifecycle stage changed to Evangelist. This is automatically set by HubSpot for each contact.
Contact Became a Lead DateTIMESTAMPThe date when a contact's lifecycle stage changed to Lead. This is automatically set by HubSpot for each contact.
Contact Became a Marketing Qualified Lead DateTIMESTAMPThe date when a contact's lifecycle stage changed to MQL. This is automatically set by HubSpot for each contact.
Contact Became an Opportunity DateTIMESTAMPThe date when a contact's lifecycle stage changed to Opportunity. This is automatically set by HubSpot for each contact.
Contact Became an Other Lifecycle DateTIMESTAMPThe date when a contact's lifecycle stage changed to Other. This is automatically set by HubSpot for each contact.
Contact Became a Sales Qualified Lead DateTIMESTAMPThe date when a contact's lifecycle stage changed to SQL. This is automatically set by HubSpot for each contact.
Contact Became a Subscriber DateTIMESTAMPThe date when a contact's lifecycle stage changed to Subscriber. This is automatically set by HubSpot for each contact.
Contact Marketing contact status source nameTEXTThe ID of the activity that set the contact as a marketing contact
Contact Marketing contact status source typeTEXTThe type of the activity that set the contact as a marketing contact
Contact Marketing contact statusTEXTThe marketing status of a contact
Contact Marketing contact until next updateTEXTSpecifies if this contact will be set as non-marketing on renewal
Contact ID (HubSpot)TEXTThe unique ID for this contact. This unique ID is automatically populated by HubSpot and cannot be changed.
Contact PersonaTEXTA contact's persona
Contact Predictive Lead ScoreNUMERICA score calculated by HubSpot that represents a contact's likelihood to become a customer
Contact Likelihood to closeNUMERICThe probability that a contact will become a customer within the next 90 days. This score is based on standard contact properties and behavior.
Contact Lead RatingTEXTThe rating of this contact based on their predictive lead score
Contact priorityTEXTA ranking system of contacts evenly assigned into four tiers. Contacts in tier one are more likely to become customers than contacts in tier four.
Contact Recent Sales Email Clicked DateTIMESTAMPThe last time a tracked sales email was clicked by this user
Contact Recent Sales Email Opened DateTIMESTAMPThe last time a tracked sales email was opened by this contact. This property does not update for emails that were sent to more than one contact.
Contact Recent Sales Email Replied DateTIMESTAMPThe last time a tracked sales email was replied to by this user. This is set automatically by HubSpot based on user actions in the contact record.
Contact Number of sequences enrolledNUMERICThe number of sequences enrolled.
Contact Currently in SequenceBOOLEANA yes/no field that indicates whether the contact is currently in a Sequence.
Contact Facebook ClicksNUMERICThe number clicks on links shared on Facebook
Contact Google Plus ClicksNUMERICThe number clicks on links shared on Google Plus
Contact Most Recent Social ClickTIMESTAMPThe date of the most recent click on a published social message. This is set automatically by HubSpot for each contact.
Contact LinkedIn ClicksNUMERICThe number clicks on links shared on LinkedIn
Contact Broadcast ClicksNUMERICThe number of clicks on published social messages. This is set automatically by HubSpot for each contact.
Contact Twitter ClicksNUMERICThe number of times a contact clicked on links you shared on Twitter through HubSpot. This is set automatically by HubSpot and can be used for segmentation.
Contact Time between contact creation and deal closeNUMERIC
Contact Time between contact creation and deal creationNUMERIC
Contact Time to move from lead to customerNUMERIC How long it takes for a contact to move from the HubSpot lead stage to the HubSpot customer stage.
Contact Time to move from marketing qualified lead to customerNUMERIC How long it takes for a contact to move from the HubSpot marketing qualified lead stage to the HubSpot customer stage.
Contact Time to move from opportunity to customerNUMERIC How long it takes for a contact to move from the HubSpot opportunity stage to the HubSpot customer stage.
Contact Time to move from sales qualified lead to customerNUMERIC How long it takes for a contact to move from the HubSpot sales qualified lead stage to the HubSpot customer stage.
Contact Time to move from subscriber to customerNUMERIC How long it takes for a contact to move from the HubSpot subscriber stage to the HubSpot customer stage.
Contact Owner Assigned DateTIMESTAMPThe most recent date a HubSpot Owner was assigned to a contact. This is set automatically by HubSpot and can be used for segmentation and reporting.
Contact ownerTEXTThe owner of a contact. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows.
Contact HubSpot TeamTEXTThe team of the owner of a contact.
Contact HubSpot ScoreNUMERICThe number that shows qualification of contacts to sales readiness. It can be set in HubSpot's Lead Scoring app.
Contact IndustryTEXTThe industry a contact is in
Contact IP CityCITYThe city reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
Contact IP CountryCOUNTRYThe country reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
Contact IP Country CodeCOUNTRYThe country code reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
Contact IP State/RegionREGIONThe state or region reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
Contact IP State Code/Region CodeTEXTThe state code or region code reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
Contact Job functionTEXTA contact's job function. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
Contact Job TitleTEXTA contact's job title
Contact Klout ScoreNUMERICA contact's Klout score, a measure of Internet influence
Contact Last Modified DateTIMESTAMPThe date any property on this contact was modified
Contact Last NameTEXTA contact's last name
Contact Lifecycle StageTEXTThe qualification of contacts to sales readiness. It can be set through imports, forms, workflows, and manually on a per contact basis.
Contact LinkedIn BioTEXTA contact's LinkedIn bio
Contact LinkedIn ConnectionsNUMERICHow many LinkedIn connections they have
Contact Marital StatusTEXTA contact's marital status. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
Contact MessageTEXTA default property to be used for any message or comments a contact may want to leave on a form.
Contact Military statusTEXTA contact's military status. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
Contact Mobile Phone NumberTEXTA contact's mobile phone number
Contact Last ContactedTIMESTAMPThe last time a call, email, or meeting was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Contact Notes Last Activity DateTIMESTAMPThe last time a note, call, email, meeting, or task was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Contact Next Activity DateTIMESTAMPThe date of the next upcoming activity for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Contact Associated DealsNUMERICThe number of deals associated with this contact. This is set automatically by HubSpot.
Contact number of times contactedNUMERICThe number of times a call, email, or meeting was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Contact Number of Form SubmissionsNUMERICThe number of forms this contact has submitted
Contact Number of Sales ActivitiesNUMERICThe number of sales activities for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Contact Number of Unique Forms SubmittedNUMERICThe number of different forms this contact has submitted
Contact Number of EmployeesTEXTThe number of company employees
Contact HubSpot Owner Email (legacy)TEXTA legacy property used to identify the email address of the owner of the contact. This property is no longer in use.
Contact HubSpot Owner Name (legacy)TEXTA legacy property used to identify the name of the owner of the contact. This property is no longer in use.
Contact Phone NumberTEXTA contact's primary phone number
Contact Recent Conversion DateTIMESTAMPThe date this contact last submitted a form
Contact Recent ConversionTEXTThe last form this contact submitted
Contact Recent Deal AmountNUMERICThe amount of the last closed won deal associated with a contact. This is set automatically by HubSpot based on information from the Deals object.
Contact Recent Deal Close DateTIMESTAMPThe date that the last deal associated with a contact was won. This is automatically set by HubSpot based on information from the Deals object.
Contact Relationship StatusTEXTA contact's relationship status. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
Sales StatusTEXTSales status
Contact SalutationTEXTThe title used to address a contact
Contact SchoolTEXTA contact's school. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
Contact SeniorityTEXTA contact's seniority. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
Contact SourceTEXTThe contact source
Contact Start dateTEXTA contact's start date. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
Contact State/RegionREGIONThe contact's state of residence. This might be set via import, form, or integration.
Contact Total RevenueNUMERICThe sum from all closed won deal revenue associated with a contact. This is automatically set by HubSpot and can be used for segmentation and reporting.
Contact Twitter BioTEXTThe contact's Twitter bio. This is set by HubSpot using the contact's email address.
Contact Twitter UsernameTEXTThe contact's Twitter handle. This is set by HubSpot using the contact's email address.
Contact Twitter Profile PhotoTEXTThe contact's Twitter profile photo. This is set by HubSpot using the contact's email address.
Contact TypeTEXTThe contact type
Contact Website URLTEXTThe contact's company website
Contact Work emailTEXTA contact's work email. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
Contact Postal CodeTEXTThe contact's zip code. This might be set via import, form, or integration.
Created DateTIMESTAMPAlias for contact_createdate
Custom Field Modified DateTIMESTAMPMost recent timestamp of any property update for this custom object.
Custom Field Last Modified DateTIMESTAMPMost recent timestamp of any property update for this custom object.
Custom Object Created atTIMESTAMPThe date the custom object was created.
Custom Object DescriptionTEXTThe custom object description.
Custom Object Display OrderTEXTThe custom object display order.
Custom Object Field TypeTEXTThe custom object field type
Custom Object Group NameTEXTThe custom object group name.
Custom Object HiddenBOOLEANThe custom object is hiddnen or not.
Custom Object IDTEXTThe custom object type ID.
Custom Object LabelTEXTThe custom object label.
Custom object nameTEXTMost recent timestamp of any property update for this custom object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
Custom object property nameTEXTName of the custom object properties (fields).
Custom Object TypeTEXTThe custom object type.
Custom Object Updated AtTIMESTAMPMost recent timestamp of any property update for this custom object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
Data SourceTEXTThe name of the Windsor connector returning the row
DateDATEThe Date
Day of monthTEXTDay of the month
Deal AmountNUMERICThe total amount of the deal
Deal Amount in company currencyNUMERICThe amount of the deal, using the exchange rate, in your company's currency
Deal Closed Lost ReasonTEXTReason why this deal was lost
Deal Closed Won ReasonTEXTReason why this deal was won
Deal Close DateTIMESTAMPThe expected close date of the deal
Deal Create DateTIMESTAMPThe date the deal was created. This property is set automatically by HubSpot.
Deal CurrencyTEXTCurrency code for the deal.
Deal NameTEXTThe name given to this deal.
Deal StageTEXTThe stage of the deal. Deal stages allow you to categorize and track the progress of the deals that you are working on.
Deal TypeTEXTThe type of deal. By default, categorize your deal as either a New Business or Existing Business.
Deal DescriptionTEXTDescription of the deal
Deal Date of last meeting booked in meetings toolTIMESTAMPThe date of the most recent meeting an associated contact has booked through the meetings tool.
Deal Campaign of last booking in meetings toolTEXTThis UTM parameter shows which marketing campaign (e.g. a specific email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Deal Medium of last booking in meetings toolTEXTThis UTM parameter shows which channel (e.g. email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Deal Source of last booking in meetings toolTEXTThis UTM parameter shows which site (e.g. Twitter) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Deal Annual contract valueNUMERICThe annual contract value (ACV) of this deal.
Deal Original Source TypeTEXTOriginal source for the contact with the earliest activity for this deal.
Deal Original Source Data 1TEXTAdditional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property.
Deal Original Source Data 2TEXTAdditional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property.
Deal Annual recurring revenueNUMERICThe annual recurring revenue (ARR) of this deal.
Deal Forecast AmountNUMERICThe forecasted deal value calculated by multiplying the forecast probability and deal amount
Deal Forecast ProbabilityNUMERICThe percent probability the deal will close, expressed as a decimal.
Deal Last Modified DateTIMESTAMPMost recent timestamp of any property update for this deal. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
Deal Forecast categoryTEXTThe likelihood a deal will close. This property is used for manual forecasting your deals.
Deal Monthly recurring revenueNUMERICThe monthly recurring revenue (MRR) of this deal.
Deal Next stepTEXTA short description of the next step for the deal
Deal ID (HubSpot)NUMERICThe unique ID for this deal. This unique ID is automatically populated by HubSpot and cannot be changed.
Deal PriorityTEXT
Deal Total contract valueNUMERICThe total contract value (TCV) of this deal.
Deal Owner Assigned DateTIMESTAMPThe date the most recent deal owner was assigned to a deal. This is updated automatically by HubSpot.
Deal Owner IDTEXTThe owner of the deal
Deal HubSpot TeamTEXTThe team of the owner of the deal.
Deal Last ContactedTIMESTAMPThe last time a call, sales email, or meeting was logged for this deal. This is set automatically by HubSpot based on user actions.
Deal Last Activity DateTIMESTAMPThe last time a note, call, email, meeting, or task was logged for a deal. This is set automatically by HubSpot based on user actions in the deal record.
Deal Next Activity DateTIMESTAMPThe date of the next upcoming activity for a deal. This property is set automatically by HubSpot based on user action. This includes logging a future call, sales email, or meeting using the Log feature, as well as creating a future task or scheduling a future meeting. This is updated automatically by HubSpot.
Deal Number of ContactsNUMERICThe number of contacts associated with this deal. This property is set automatically by HubSpot.
Deal Number of times contactedNUMERICThe number of times a call, email or meeting was logged for this deal
Deal Number of Sales ActivitiesNUMERICThe total number of sales activities (notes, calls, emails, meetings, or tasks) logged for a deal. This is updated automatically by HubSpot.
Deal PipelineTEXTThe pipeline the deal is in. This determines which stages are options for the deal.
EmailTEXTAlias for contact_email
Email engagement bouncedNUMERICThe recipient's email server couldn't or wouldn't accept the message, and no further attempts will be made to deliver the message.
Email engagement clicksNUMERICThe recipient clicked on a link within the message.
Email engagement deferredNUMERICThe recipient’s email server has temporarily rejected message, and subsequent attempts will be made to deliver the message.and no further attempts will be made to deliver the message.
Email engagement deliveredNUMERICThe recipient's email server has accepted the message and the message has been successfully delivered to the recipient.and no further attempts will be made to deliver the message.
Email engagement droppedNUMERICThe message was rejected, either by HubSpot or by our delivery provider, and no attempt will be made to deliver the message.and no further attempts will be made to deliver the message.
Email engagement timestampTIMESTAMPEmail engagement timestamp
Email engagement openedNUMERICThe recipient opened the message.
Email engagement processedNUMERICThe message has been received by our delivery provider, which has indicated it will attempt to deliver the message to the recipient's email server.and no further attempts will be made to deliver the message.
Email recipientTEXTEmail recipient
Email engagement sentNUMERICThe message was sent to and received by our delivery provider.
First NameTEXTAlias for contact_firstname
Last NameTEXTAlias for contact_lastname
Lifecycle StageTEXTAlias for contact_lifecyclestage
abTEXTab
abHoursToWaitTEXTabHoursToWait
abSampleSizeDefaultTEXTabSampleSizeDefault
abSamplingDefaultTEXTabSamplingDefault
absoluteUrlTEXTabsoluteUrl
abSuccessMetricTEXTabSuccessMetric
abTestPercentageTEXTabTestPercentage
abVariationTEXTabVariation
allEmailCampaignIdsTEXTallEmailCampaignIds
analyticsPageIdTEXTanalyticsPageId
analyticsPageTypeTEXTanalyticsPageType
archivedAtTEXTarchivedAt
archivedInDashboardTEXTarchivedInDashboard
audienceAccessTEXTaudienceAccess
authorTEXTauthor
authorNameTEXTauthorName
blogRssSettingsTEXTblogRssSettings
canSpamSettingsIdTEXTcanSpamSettingsId
categoryIdTEXTcategoryId
contentAccessRuleIdsTEXTcontentAccessRuleIds
contentAccessRuleTypesTEXTcontentAccessRuleTypes
contentTypeCategoryTEXTcontentTypeCategory
createdTIMESTAMPcreated
createdByIdTEXTcreatedById
createPageTEXTcreatePage
currentlyPublishedTEXTcurrentlyPublished
currentStateTEXTcurrentState
customReplyToTEXTcustomReplyTo
customReplyToEnabledTEXTcustomReplyToEnabled
domainTEXTdomain
emailBodyTEXTemailBody
emailCampaignGroupIdTEXTemailCampaignGroupId
emailNoteTEXTemailNote
emailTemplateModeTEXTemailTemplateMode
emailTypeTEXTemailType
feedbackSurveyIdTEXTfeedbackSurveyId
flexAreasTEXTflexAreas
freezeDateTIMESTAMPfreezeDate
fromNameTEXTfromName
hasContentAccessRulesTEXThasContentAccessRules
htmlTitleTEXThtmlTitle
idTEXTid
isCreatedFomSandboxSyncTEXTisCreatedFomSandboxSync
isGraymailSuppressionEnabledTEXTisGraymailSuppressionEnabled
isInstanceLayoutPageTEXTisInstanceLayoutPage
isPublishedTEXTisPublished
isRecipientFatigueSuppressionEnabledTEXTisRecipientFatigueSuppressionEnabled
languageTEXTlanguage
layoutSectionsTEXTlayoutSections
liveDomainTEXTliveDomain
mailingListsExcludedTEXTmailingListsExcluded
mailingListsIncludedTEXTmailingListsIncluded
maxRssEntriesTEXTmaxRssEntries
metaDescriptionTEXTmetaDescription
nameTEXTname
pageExpiryEnabledTEXTpageExpiryEnabled
pageRedirectedTEXTpageRedirected
pastMabExperimentIdsTEXTpastMabExperimentIds
portalIdTEXTportalId
previewKeyTEXTpreviewKey
primaryEmailCampaignIdTEXTprimaryEmailCampaignId
primaryRichTextModuleHtmlTEXTprimaryRichTextModuleHtml
processingStatusTEXTprocessingStatus
publishDateTIMESTAMPpublishDate
publishedAtTEXTpublishedAt
publishedByEmailTEXTpublishedByEmail
publishedByIdTEXTpublishedById
publishedByNameTEXTpublishedByName
publishedUrlTEXTpublishedUrl
replyToTEXTreplyTo
resolvedDomainTEXTresolvedDomain
rssEmailByTextTEXTrssEmailByText
rssEmailClickThroughTextTEXTrssEmailClickThroughText
rssEmailCommentTextTEXTrssEmailCommentText
rssEmailEntryTemplateEnabledTEXTrssEmailEntryTemplateEnabled
rssEmailImageMaxWidthTEXTrssEmailImageMaxWidth
rssEmailUrlTEXTrssEmailUrl
TEXTscrubsSubscriptionLinks
sectionsTEXTsections
securityStateTEXTsecurityState
slugTEXTslug
smartEmailFieldsTEXTsmartEmailFields
stateTEXTstate
styleSettingsTEXTstyleSettings
subcategoryTEXTsubcategory
subjectTEXTsubject
subscriptionTEXTsubscription
subscriptionNameTEXTsubscriptionName
teamPermsTEXTteamPerms
templatePathTEXTtemplatePath
transactionalTEXTtransactional
translationsTEXTtranslations
unpublishedAtTEXTunpublishedAt
updatedTIMESTAMPupdated
updatedByIdTEXTupdatedById
urlTEXTurl
userPermsTEXTuserPerms
useRssHeadlineAsSubjectTEXTuseRssHeadlineAsSubject
vidsExcludedTEXTvidsExcluded
vidsIncludedTEXTvidsIncluded
visibleToAllTEXTvisibleToAll
MonthTEXTNumber of the month
Owner ArchivedTEXTOwner Archived
Owner Created AtTIMESTAMPOwner Created At
Owner EmailTEXTOwner Email
Owner First NameTEXTOwner First Name
Owner Last NameTEXTOwner Last Name
Owner IdTEXTOwner Id
Owner Updated AtTIMESTAMPOwner Updated At
Owner User IdTEXTOwner User Id
Phone NumberTEXTAlias for contact_phone
Pipeline IDTEXTPipeline ID
Pipeline NameTEXTPipeline name
Pipeline Stage Created DateTIMESTAMPThe timestamp that specifies when the stage was created
Pipeline Stage Display Order NumberNUMERICStage display order number
Pipeline Stage IDTEXTStage ID
Pipeline Is Stage ArchivedBOOLEANIs stage archived
Pipeline Is ClosedBOOLEANIs deal closed
Pipeline Stage NameTEXTStage name
Pipeline ProbablityTEXTDeal probability
Pipeline Stage Last Modified DateTIMESTAMPThe timestamp that specifies when the stage was modified
SourceTEXTThe name of the Windsor connector returning the row
TodayDATEToday's date
WeekTEXTWeek (Sun-Sat).
Day of week and day numberTEXTWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
Day of week and day number, ISOTEXTWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
Week ISOTEXTWeek, ISO format (Mon-Sun).
YearTEXTYear
YearmonthTEXTYear and month, e.g. 2024|3
Year of weekTEXTThe year that contains first day of the week (Sun-Sat).
Year of week, ISOTEXTThe year that contains first day of the ISO week (Mon-Sun).
Year weekTEXTYear and week for US weeks (Sun-Sat), e.g. 2024|15
Year week ISOTEXTYear and week for ISO weeks (Mon-Sun), e.g. 2024|20

Easily connect HubSpot to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 70+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your HubSpot and Snowflake Integrations