Stream contact, customer, lead, deal, pipeline and contract data from HubSpot to Snowflake
About HubSpot
About 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:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- 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.
2. In Select Destination select Snowflake as destination
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
| name | type | description |
|---|---|---|
| Account ID | TEXT | Your Hubspot account ID |
| Account Name | TEXT | Your Hubspot account name |
| Company Name | TEXT | Alias for contact_company |
| Company About Us | TEXT | Short about-company |
| Company Street Address | TEXT | The street address of the company or organization, including unit number. Powered by HubSpot Insights. |
| Company Street Address 2 | TEXT | The additional address of the company or organization. Powered by HubSpot Insights. |
| Company Annual Revenue | NUMERIC | The actual or estimated annual revenue of the company. Powered by HubSpot Insights. |
| Company City | CITY | The city where the company is located. Powered by HubSpot Insights. |
| Company Close Date | TIMESTAMP | The date the company or organization was closed as a customer |
| Company Country/Region | COUNTRY | The country/region in which the company or organization is located. Powered by HubSpot Insights. |
| Company Create Date | TIMESTAMP | The date the company or organization was added to the database |
| Company Days to Close | NUMERIC | The number of days between when the company record was created and when they closed as a customer. |
| Company Description | TEXT | A short statement about the company's mission and goals. Powered by HubSpot Insights. |
| Company Domain Name | TEXT | The domain name of the company or organization |
| Company Date of last meeting booked in meetings tool | TIMESTAMP | The date of the most recent meeting an associated contact has booked through the meetings tool. |
| Company Campaign of last booking in meetings tool | TEXT | This 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 tool | TEXT | This 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 tool | TEXT | This 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 Page | TEXT | The URL of the Facebook company page for the company or organization |
| Company Facebook Fans | NUMERIC | Number of facebook fans |
| Company First Contact Create Date | TIMESTAMP | The date that the first contact from this company entered the system, which could pre-date the company's create date |
| Company First Conversion Date | TIMESTAMP | The first conversion date across all contacts associated this company or organization |
| Company First Conversion | TEXT | The first form submitted across all contacts associated this company or organization |
| Company First Deal Created Date | TIMESTAMP | The create date of the first deal associated with this company record. |
| Company Year Founded | TEXT | The year the company was created. Powered by HubSpot Insights. |
| Company Google Plus Page | TEXT | The URL of the Google Plus page for the company or organization |
| Company Time First Seen | TIMESTAMP | The first activity for any contact associated with this company or organization |
| Company First Touch Converting Campaign | TEXT | The campaign responsible for the first touch creation of the first contact associated with this company |
| Company Time of First Session | TIMESTAMP | Time of first session across all contacts associated with this company or organization |
| Company Time Last Seen | TIMESTAMP | Time last seen across all contacts associated with this company or organization |
| Company Last Touch Converting Campaign | TEXT | The campaign responsible for the last touch creation of the first contact associated with this company |
| Company Time of Last Session | TIMESTAMP | Time of the last session attributed to any contacts that are associated with this company record. |
| Company Number of Pageviews | NUMERIC | Total number of page views across all contacts associated with this company or organization |
| Company Number of Sessions | NUMERIC | Total number of sessions across all contacts associated with this company or organization |
| Company Original Source Type | TEXT | Original source for the contact with the earliest activity for this company or organization |
| Company Original Source Data 1 | TEXT | Additional information about the original source for the contact with the earliest activity for this company or organization |
| Company Original Source Data 2 | TEXT | Additional information about the original source for the contact with the earliest activity for this company or organization |
| Company object create date/time | TIMESTAMP | The 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 Tier | TEXT | This 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 Account | BOOLEAN | The Target Account property identifies the companies that you are marketing and selling to as part of your account-based strategy. |
| Company Last Booked Meeting Date | TIMESTAMP | The last date of booked meetings associated with the company |
| Company Last Logged Call Date | TIMESTAMP | The last date of logged calls associated with the company |
| Company Last Open Task Date | TIMESTAMP | The last due date of open tasks associated with the company |
| Company Last Engagement Date | TIMESTAMP | The 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 Date | TIMESTAMP | Most 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 Status | TEXT | The company's sales, prospecting or outreach status |
| Company Number of blockers | NUMERIC | The number of contacts associated with this company with the role of blocker. |
| Company Number of child companies | NUMERIC | The number of child companies of this company |
| Company Number of contacts with a buying role | NUMERIC | The number of contacts associated with this company with a buying role. |
| Company Number of decision makers | NUMERIC | The number of contacts associated with this company with the role of decision maker. |
| Company Number of open deals | NUMERIC | The number of open deals associated with this company. |
| Company ID | NUMERIC | The unique ID for this company. This unique ID is automatically populated by HubSpot and cannot be changed. |
| Parent Company | NUMERIC | The parent company of this company |
| Company Likelihood to close | NUMERIC | The 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 value | NUMERIC | The total value, in your company's currency, of all open deals associated with this company |
| Company Owner Assigned Date | TIMESTAMP | The timestamp when an owner was assigned to this company |
| Company owner | TEXT | The owner of the company |
| Company HubSpot Team | TEXT | The team of the owner of the company. |
| Company Industry | TEXT | The 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 Public | BOOLEAN | Indicates that the company is publicly traded. Powered by HubSpot Insights. |
| Company Lifecycle Stage | TEXT | The most advanced lifecycle stage across all contacts associated with this company or organization |
| LinkedIn Company Page | TEXT | The URL of the LinkedIn company page for the company or organization |
| Company LinkedIn Bio | TEXT | The LinkedIn bio for the company or organization |
| Company Name (Duplicate) | TEXT | The name of the company or organization. Powered by HubSpot Insights. |
| Company Last Contacted | TIMESTAMP | The last timestamp when a call, email or meeting was logged for a contact at this company. |
| Company Last Activity Date | TIMESTAMP | The 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 Date | TIMESTAMP | The date of the next upcoming scheduled sales activity for this company record. |
| Company Associated Contacts | NUMERIC | The number of contacts associated with this company |
| Company Associated Deals | NUMERIC | The number of deals associated with this company |
| Company Number of times contacted | NUMERIC | The number of times a call, email or meeting was logged for this company |
| Company Number of Form Submissions | NUMERIC | The number of forms submission for all contacts associated with this company or organization |
| Company Number of Employees | NUMERIC | The total number of employees who work for the company or organization |
| Company HubSpot Owner Email | TEXT | HubSpot owner email for this company or organization |
| Company HubSpot Owner Name | TEXT | HubSpot owner name for this company or organization |
| Company Phone Number | TEXT | A company's primary phone number. Powered by HubSpot Insights. |
| Company Recent Conversion Date | TIMESTAMP | The most recent conversion date across all contacts associated this company or organization |
| Company Recent Conversion | TEXT | The last form submitted across all contacts associated this company or organization |
| Company Recent Deal Amount | NUMERIC | The amount of the last deal closed |
| Company Recent Deal Close Date | TIMESTAMP | The date of the last `closed won` deal associated with this company record. |
| Company State/Region | REGION | The state or region in which the company or organization is located. Powered by HubSpot Insights. |
| Company Time Zone | TEXT | The time zone where the company or organization is located. Powered by HubSpot Insights. |
| Company Total Money Raised | TEXT | The total amount of money raised by the company. Powered by HubSpot Insights. |
| Company Total Revenue | NUMERIC | The total amount of closed won deals |
| Company Twitter Bio | TEXT | The Twitter bio of the company or organization |
| Company Twitter Followers | NUMERIC | The number of Twitter followers of the company or organization |
| Company Twitter Handle | TEXT | The main twitter account of the company or organization |
| Company Type | TEXT | The optional classification of this company record - prospect, partner, etc. |
| Company Web Technologies | TEXT | The web technologies used by the company or organization. Powered by HubSpot Insights. |
| Company Website URL | TEXT | The main website of the company or organization. This property is used to identify unique companies. Powered by HubSpot Insights. |
| Company Postal Code | TEXT | The postal or zip code of the company or organization. Powered by HubSpot Insights. |
| Contact Street Address | TEXT | A contact's street address, including apartment or unit # |
| Contact Annual Revenue | TEXT | Annual company revenue |
| Contact City | CITY | A contact's city of residence |
| Contact Close Date | TIMESTAMP | The 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 Name | TEXT | The 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 size | TEXT | A 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/Region | COUNTRY | The contact's country/region of residence. This might be set via import, form, or integration. |
| Contact Create Date | TIMESTAMP | The date that a contact entered the system |
| Contact Currently in workflow | TEXT | If the contact is currently enrolled in any workflow |
| Contact Date of birth | TEXT | A 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 Close | NUMERIC | The 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 Degree | TEXT | A contact's degree. This property is required for the Facebook Ads Integration. This property will be automatically synced to via Lead Ads tool |
| Contact Email | TEXT | A contact's email address |
| Contact date of last meeting booked in meetings tool | TIMESTAMP | The date of the most recent meeting a contact has booked through the meetings tool. |
| Contact Campaign of last booking in meetings tool | TEXT | This 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 tool | TEXT | This 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 tool | TEXT | This 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 Number | TEXT | A contact's primary fax number |
| Contact Field of study | TEXT | A 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 Date | TIMESTAMP | The date this contact first submitted a form |
| Contact First Conversion | TEXT | The first form this contact submitted |
| Contact First Deal Created Date | TIMESTAMP | The 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 Name | TEXT | A contact's first name |
| Contact Follower Count | NUMERIC | The number of Twitter followers a contact has |
| Contact Gender | TEXT | |
| Contact Graduation date | TEXT | A 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 Pageviews | NUMERIC | The average number of pages a contact sees. This is automatically set by HubSpot for each contact. |
| Contact First Referring Site | TEXT | The first website that referred a contact to your website. This is automatically set by HubSpot for each contact. |
| Contact Time First Seen | TIMESTAMP | The first time a contact has been seen. This is automatically set by HubSpot for each contact. |
| Contact First Touch Converting Campaign | TEXT | The campaign responsible for the first touch creation of this contact |
| Contact First Page Seen | TEXT | The first page a contact saw on your website. This is automatically set by HubSpot for each contact. |
| Contact time of First Session | TIMESTAMP | The first time a contact visited your website. This is automatically set by HubSpot for each contact. |
| Contact Last Referring Site | TEXT | The last website that referred a contact to your website. This is automatically set by HubSpot for each contact. |
| Contact Time Last Seen | TIMESTAMP | The last time and date a contact has viewed a page on your website. |
| Contact Last Touch Converting Campaign | TEXT | The campaign responsible for the last touch creation of this contact |
| Contact Last Page Seen | TEXT | The last page a contact saw on your website. This is automatically set by HubSpot for each contact. |
| Contact time of Last Session | TIMESTAMP | The last time and date a contact visited your website. |
| Contact Number of event completions | NUMERIC | The sum of all events a contact has experienced. This is automatically set by HubSpot for each contact. |
| Contact Number of Pageviews | NUMERIC | The sum of all pages a contact has seen on your website. This is automatically set by HubSpot for each contact. |
| Contact Number of Sessions | NUMERIC | The sum of all sessions a contact has made to your website. This is automatically set by HubSpot for each contact. |
| Contact Event Revenue | NUMERIC | Event 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 Source | TEXT | First known source the contact used to find your website. Set automatically, but may be updated manually. |
| Contact Original Source Drill-Down 1 | TEXT | Additional information about the source through which a contact first found your website. This property is automatically set by HubSpot. |
| Contact Original Source Drill-Down 2 | TEXT | Additional information about the source through which a contact first found your website. This property is automatically set by HubSpot. |
| Contact Buying Role | TEXT | The 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 Confirmed | BOOLEAN | Email Confirmation status of user of Content Membership |
| Contact Membership Notes | TEXT | The notes relating to the contact's content membership. |
| Contact Registered At | TIMESTAMP | Datetime at which this user was set up for Content Membership |
| Contact Domain to which registration email was sent | TEXT | Domain to which the registration invitation email for Content Membership was sent to |
| Contact Time registration email was sent | TIMESTAMP | Datetime at which this user was sent a registration invitation email for Content Membership |
| Contact Status | TEXT | The status of the contact's content membership. |
| Contact Object create date/time | TIMESTAMP | The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified. |
| Contact Invalid email address | BOOLEAN | The email address associated with this contact is invalid. |
| Contact Marketing emails bounced | NUMERIC | The number of marketing emails that bounced for the current email address. This is automatically set by HubSpot. |
| Contact Marketing emails clicked | NUMERIC | The number of marketing emails which have had link clicks for the current email address. This is automatically set by HubSpot. |
| Contact Email address quarantine reason | TEXT | The reason why the email address has been quarantined. |
| Contact Marketing emails delivered | NUMERIC | The number of marketing emails delivered for the current email address. This is automatically set by HubSpot. |
| Contact Email Domain | TEXT | A contact's email address domain |
| Contact First marketing email click date | TIMESTAMP | The 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 date | TIMESTAMP | The 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 date | TIMESTAMP | The 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 date | TIMESTAMP | The date of the earliest delivery for any marketing email to the current email address. This is automatically set by HubSpot. |
| Contact Email hard bounce reason | TEXT | The 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 date | TIMESTAMP | The 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 name | TEXT | The name of the last marketing email sent to the current email address. This is automatically set by HubSpot. |
| Contact Last marketing email open date | TIMESTAMP | The 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 date | TIMESTAMP | The 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 date | TIMESTAMP | The date of the most recent delivery for any marketing email to the current email address. This is automatically set by HubSpot. |
| Contact Marketing emails opened | NUMERIC | The number of marketing emails opened for the current email address. This is automatically set by HubSpot. |
| Contact Unsubscribed from all email | BOOLEAN | Indicates that the current email address has opted out of all email. |
| Contact Email Address Quarantined | BOOLEAN | Indicates 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 reason | TEXT | The automated reason why the email address has been quarantined. |
| Contact Marketing emails replied | NUMERIC | The number of marketing emails replied to by the current email address. This is automatically set by HubSpot. |
| Contact Sends Since Last Engagement | NUMERIC | The 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 status | TEXT | The status of a contact's eligibility to receive marketing email. This is automatically set by HubSpot. |
| Contact Facebook click id | TEXT | |
| Contact Last NPS survey comment | TEXT | Last NPS survey comment that this contact gave |
| Contact Last NPS survey rating | TEXT | Last NPS survey rating that this contact gave |
| Contact Last NPS survey date | TIMESTAMP | The time that this contact last submitted a NPS survey response. This is automatically set by HubSpot. |
| Contact Google ad click id | TEXT | |
| Contact IP Timezone | TEXT | The timezone reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting. |
| Contact unworked | BOOLEAN | Contact has not been assigned or has not been engaged after last owner assignment/re-assignment |
| Contact Preferred language | TEXT | Set your contact's preferred language for communications. This property can be changed from an import, form, or integration. |
| Contact Last Engagement Date | TIMESTAMP | The 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 date | TIMESTAMP | The last sequence ended date. |
| Contact Last sequence enrolled | NUMERIC | The last sequence enrolled. |
| Contact Last sequence enrolled date | TIMESTAMP | The last sequence enrolled date. |
| Contact Lead Status | TEXT | The contact's sales, prospecting or outreach status |
| Contact Legal basis for processing contact's data | TEXT | Legal basis for processing contact's data; 'Not applicable' will exempt the contact from GDPR protections |
| Contact Became a Customer Date | TIMESTAMP | The date when a contact's lifecycle stage changed to Customer. This is automatically set by HubSpot for each contact. |
| Contact Became an Evangelist Date | TIMESTAMP | The date when a contact's lifecycle stage changed to Evangelist. This is automatically set by HubSpot for each contact. |
| Contact Became a Lead Date | TIMESTAMP | The 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 Date | TIMESTAMP | The date when a contact's lifecycle stage changed to MQL. This is automatically set by HubSpot for each contact. |
| Contact Became an Opportunity Date | TIMESTAMP | The date when a contact's lifecycle stage changed to Opportunity. This is automatically set by HubSpot for each contact. |
| Contact Became an Other Lifecycle Date | TIMESTAMP | The 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 Date | TIMESTAMP | The date when a contact's lifecycle stage changed to SQL. This is automatically set by HubSpot for each contact. |
| Contact Became a Subscriber Date | TIMESTAMP | The date when a contact's lifecycle stage changed to Subscriber. This is automatically set by HubSpot for each contact. |
| Contact Marketing contact status source name | TEXT | The ID of the activity that set the contact as a marketing contact |
| Contact Marketing contact status source type | TEXT | The type of the activity that set the contact as a marketing contact |
| Contact Marketing contact status | TEXT | The marketing status of a contact |
| Contact Marketing contact until next update | TEXT | Specifies if this contact will be set as non-marketing on renewal |
| Contact ID | TEXT | The unique ID for this contact. This unique ID is automatically populated by HubSpot and cannot be changed. |
| Contact Persona | TEXT | A contact's persona |
| Contact Predictive Lead Score | NUMERIC | A score calculated by HubSpot that represents a contact's likelihood to become a customer |
| Contact Likelihood to close | NUMERIC | The 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 Rating | TEXT | The rating of this contact based on their predictive lead score |
| Contact priority | TEXT | A 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 Date | TIMESTAMP | The last time a tracked sales email was clicked by this user |
| Contact Recent Sales Email Opened Date | TIMESTAMP | The 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 Date | TIMESTAMP | The 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 enrolled | NUMERIC | The number of sequences enrolled. |
| Contact Currently in Sequence | BOOLEAN | A yes/no field that indicates whether the contact is currently in a Sequence. |
| Contact Facebook Clicks | NUMERIC | The number clicks on links shared on Facebook |
| Contact Google Plus Clicks | NUMERIC | The number clicks on links shared on Google Plus |
| Contact Most Recent Social Click | TIMESTAMP | The date of the most recent click on a published social message. This is set automatically by HubSpot for each contact. |
| Contact LinkedIn Clicks | NUMERIC | The number clicks on links shared on LinkedIn |
| Contact Broadcast Clicks | NUMERIC | The number of clicks on published social messages. This is set automatically by HubSpot for each contact. |
| Contact Twitter Clicks | NUMERIC | The 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 close | NUMERIC | |
| Contact Time between contact creation and deal creation | NUMERIC | |
| Contact Time to move from lead to customer | NUMERIC | 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 customer | NUMERIC | 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 customer | NUMERIC | 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 customer | NUMERIC | 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 customer | NUMERIC | How long it takes for a contact to move from the HubSpot subscriber stage to the HubSpot customer stage. |
| Contact Owner Assigned Date | TIMESTAMP | The 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 owner | TEXT | The owner of a contact. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows. |
| Contact HubSpot Team | TEXT | The team of the owner of a contact. |
| Contact HubSpot Score | NUMERIC | The number that shows qualification of contacts to sales readiness. It can be set in HubSpot's Lead Scoring app. |
| Contact Industry | TEXT | The industry a contact is in |
| Contact IP City | CITY | The city reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting. |
| Contact IP Country | COUNTRY | The 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 Code | TEXT | The 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/Region | REGION | The 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 Code | TEXT | The 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 function | TEXT | A 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 Title | TEXT | A contact's job title |
| Contact Klout Score | NUMERIC | A contact's Klout score, a measure of Internet influence |
| Contact Last Modified Date | TIMESTAMP | The date any property on this contact was modified |
| Contact Last Name | TEXT | A contact's last name |
| Contact Lifecycle Stage | TEXT | The qualification of contacts to sales readiness. It can be set through imports, forms, workflows, and manually on a per contact basis. |
| Contact LinkedIn Bio | TEXT | A contact's LinkedIn bio |
| Contact LinkedIn Connections | NUMERIC | How many LinkedIn connections they have |
| Contact Marital Status | TEXT | A 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 Message | TEXT | A default property to be used for any message or comments a contact may want to leave on a form. |
| Contact Military status | TEXT | A 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 Number | TEXT | A contact's mobile phone number |
| Contact Last Contacted | TIMESTAMP | The 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 Date | TIMESTAMP | The 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 Date | TIMESTAMP | The 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 Deals | NUMERIC | The number of deals associated with this contact. This is set automatically by HubSpot. |
| Contact number of times contacted | NUMERIC | The 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 Submissions | NUMERIC | The number of forms this contact has submitted |
| Contact Number of Sales Activities | NUMERIC | The 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 Submitted | NUMERIC | The number of different forms this contact has submitted |
| Contact Number of Employees | TEXT | The number of company employees |
| Contact HubSpot Owner Email (legacy) | TEXT | A 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) | TEXT | A legacy property used to identify the name of the owner of the contact. This property is no longer in use. |
| Contact Phone Number | TEXT | A contact's primary phone number |
| Contact Recent Conversion Date | TIMESTAMP | The date this contact last submitted a form |
| Contact Recent Conversion | TEXT | The last form this contact submitted |
| Contact Recent Deal Amount | NUMERIC | The 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 Date | TIMESTAMP | The 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 Status | TEXT | A 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 Status | TEXT | Sales status |
| Contact Salutation | TEXT | The title used to address a contact |
| Contact School | TEXT | A contact's school. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool |
| Contact Seniority | TEXT | A contact's seniority. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool |
| Contact Source | TEXT | The contact source |
| Contact Start date | TEXT | A 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/Region | REGION | The contact's state of residence. This might be set via import, form, or integration. |
| Contact Total Revenue | NUMERIC | The 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 Bio | TEXT | The contact's Twitter bio. This is set by HubSpot using the contact's email address. |
| Contact Twitter Username | TEXT | The contact's Twitter handle. This is set by HubSpot using the contact's email address. |
| Contact Twitter Profile Photo | TEXT | The contact's Twitter profile photo. This is set by HubSpot using the contact's email address. |
| Contact Type | TEXT | The contact type |
| Contact Website URL | TEXT | The contact's company website |
| Contact Work email | TEXT | A 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 Code | TEXT | The contact's zip code. This might be set via import, form, or integration. |
| Created Date | TIMESTAMP | Alias for contact_createdate |
| Custom Field Modified Date | TIMESTAMP | Most recent timestamp of any property update for this custom object. |
| Custom Field Last Modified Date | TIMESTAMP | Most recent timestamp of any property update for this custom object. |
| Custom Object Created at | TIMESTAMP | The date the custom object was created. |
| Custom Object Description | TEXT | The custom object description. |
| Custom Object Display Order | TEXT | The custom object display order. |
| Custom Object Field Type | TEXT | The custom object field type |
| Custom Object Group Name | TEXT | The custom object group name. |
| Custom Object Hidden | BOOLEAN | The custom object is hiddnen or not. |
| Custom Object ID | TEXT | The custom object type ID. |
| Custom Object Label | TEXT | The custom object label. |
| Custom object name | TEXT | Most 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 name | TEXT | Name of the custom object properties (fields). |
| Custom Object Type | TEXT | The custom object type. |
| Custom Object Updated At | TIMESTAMP | Most 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. |
| Last Modified Date | DATE | The timestamp that specifies when the stage was modified |
| Deal Amount | NUMERIC | The total amount of the deal |
| Deal Amount in company currency | NUMERIC | The amount of the deal, using the exchange rate, in your company's currency |
| Deal Closed Lost Reason | TEXT | Reason why this deal was lost |
| Deal Closed Won Reason | TEXT | Reason why this deal was won |
| DealClose Date | TIMESTAMP | The expected close date of the deal |
| DealCreate Date | TIMESTAMP | The date the deal was created. This property is set automatically by HubSpot. |
| Deal Currency | TEXT | Currency code for the deal. |
| DealName | TEXT | The name given to this deal. |
| DealStage | TEXT | The stage of the deal. Deal stages allow you to categorize and track the progress of the deals that you are working on. |
| DealType | TEXT | The type of deal. By default, categorize your deal as either a New Business or Existing Business. |
| DealDescription | TEXT | Description of the deal |
| Deal Date of last meeting booked in meetings tool | TIMESTAMP | The date of the most recent meeting an associated contact has booked through the meetings tool. |
| Deal Campaign of last booking in meetings tool | TEXT | This 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 tool | TEXT | This 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 tool | TEXT | This 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 value | NUMERIC | The annual contract value (ACV) of this deal. |
| Deal Original Source Type | TEXT | Original source for the contact with the earliest activity for this deal. |
| Deal Original Source Data 1 | TEXT | Additional 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 2 | TEXT | Additional 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 revenue | NUMERIC | The annual recurring revenue (ARR) of this deal. |
| Deal Forecast Amount | NUMERIC | The forecasted deal value calculated by multiplying the forecast probability and deal amount |
| Deal Forecast Probability | NUMERIC | The percent probability the deal will close, expressed as a decimal. |
| Deal Last Modified Date | TIMESTAMP | Most 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 category | TEXT | The likelihood a deal will close. This property is used for manual forecasting your deals. |
| Deal Monthly recurring revenue | NUMERIC | The monthly recurring revenue (MRR) of this deal. |
| Deal Next step | TEXT | A short description of the next step for the deal |
| DealID | NUMERIC | The unique ID for this deal. This unique ID is automatically populated by HubSpot and cannot be changed. |
| Deal Priority | TEXT | |
| Deal Total contract value | NUMERIC | The total contract value (TCV) of this deal. |
| Deal Owner Assigned Date | TIMESTAMP | The date the most recent deal owner was assigned to a deal. This is updated automatically by HubSpot. |
| Dealowner | TEXT | The owner of the deal |
| Deal HubSpot Team | TEXT | The team of the owner of the deal. |
| DealLast Contacted | TIMESTAMP | The last time a call, sales email, or meeting was logged for this deal. This is set automatically by HubSpot based on user actions. |
| DealLast Activity Date | TIMESTAMP | The 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. |
| DealNext Activity Date | TIMESTAMP | The 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 Contacts | NUMERIC | The number of contacts associated with this deal. This property is set automatically by HubSpot. |
| DealNumber of times contacted | NUMERIC | The number of times a call, email or meeting was logged for this deal |
| Deal Number of Sales Activities | NUMERIC | The total number of sales activities (notes, calls, emails, meetings, or tasks) logged for a deal. This is updated automatically by HubSpot. |
| Deal Pipeline | TEXT | The pipeline the deal is in. This determines which stages are options for the deal. |
| TEXT | Alias for contact_email | |
| Email engagement bounced | NUMERIC | The 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 clicks | NUMERIC | The recipient clicked on a link within the message. |
| Email engagement deferred | NUMERIC | The 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 delivered | NUMERIC | The 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 dropped | NUMERIC | The 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 timestamp | TIMESTAMP | Email engagement timestamp |
| Email engagement opened | NUMERIC | The recipient opened the message. |
| Email engagement processed | NUMERIC | 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.and no further attempts will be made to deliver the message. |
| Email recipient | TEXT | Email recipient |
| Email engagement sent | NUMERIC | The message was sent to and received by our delivery provider. |
| First Name | TEXT | Alias for contact_firstname |
| Last Name | TEXT | Alias for contact_lastname |
| Lifecycle Stage | TEXT | Alias for contact_lifecyclestage |
| Owner Archived | TEXT | Owner Archived |
| Owner Created At | TEXT | Owner Created At |
| Owner Email | TEXT | Owner Email |
| Owner First Name | TEXT | Owner First Name |
| Owner Last Name | TEXT | Owner Last Name |
| Owner Id | TEXT | Owner Id |
| Owner Updated At | TEXT | Owner Updated At |
| Owner User Id | TEXT | Owner User Id |
| Phone Number | TEXT | Alias for contact_phone |
| Pipeline ID | TEXT | Pipeline ID |
| Pipeline Name | TEXT | Pipeline name |
| Pipeline Stage Created Date | TIMESTAMP | The timestamp that specifies when the stage was created |
| Pipeline Stage Display Order Number | NUMERIC | Stage display order number |
| Pipeline Stage ID | TEXT | Stage ID |
| Pipeline Is Stage Archived | BOOLEAN | Is stage archived |
| Pipeline Is Closed | BOOLEAN | Is deal closed |
| Pipeline Stage Name | TEXT | Stage name |
| Pipeline Probablity | TEXT | Deal probability |
| Pipeline Stage Last Modified Date | TIMESTAMP | The timestamp that specifies when the stage was modified |
| Today | DATE | Today's date |
Easily connect HubSpot to Snowflake
See the value and return on every marketing touchpoint
Providing 70+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.