Connect HubSpot to Azure with Windsor.ai

hubspot

+

azure logo 2

Stream all your CRM data from HubSpot to Azure

About HubSpot

HubSpot offers a CRM and inbound marketing software which helps companies to manage sales, marketing and customer service. It’s key features are blogging and search engine optimisation, advertising data integration and customer relationship management features such as customer support and account management.

About Azure

Azure or Microsoft Azure is a cloud computing offering which allows management and hosting on Microsoft Managed data centers. It is used for business critical applications. In combination with Windsor.ai it allows joining marketing, analytics and CRM data to gain deeper insights.

HubSpot metrics and dimensions available for streaming into Azure

NameTypeDescription
Company NameTEXTAlias for contact_company
About UsTEXTShort about-company
Street AddressTEXTThe street address of the company or organization, including unit number. Powered by HubSpot Insights.
Street Address 2TEXTThe additional address of the company or organization. Powered by HubSpot Insights.
Annual RevenueNUMERICThe actual or estimated annual revenue of the company. Powered by HubSpot Insights.
CityTEXTThe city where the company is located. Powered by HubSpot Insights.
Close DateTIMESTAMPThe date the company or organization was closed as a customer
Country/RegionTEXTThe country/region in which the company or organization is located. Powered by HubSpot Insights.
Create DateTIMESTAMPThe date the company or organization was added to the database
Days to CloseNUMERICThe number of days between when the company record was created and when they closed as a customer.
DescriptionTEXTA short statement about the company's mission and goals. Powered by HubSpot Insights.
Company Domain NameTEXTThe domain name of the company or organization
Date of last meeting booked in meetings toolTIMESTAMPThe date of the most recent meeting an associated contact has booked through the meetings tool.
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.
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.
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.
Facebook Company PageTEXTThe URL of the Facebook company page for the company or organization
Facebook FansNUMERICNumber of facebook fans
First Contact Create DateTIMESTAMPThe date that the first contact from this company entered the system, which could pre-date the company's create date
First Conversion DateTIMESTAMPThe first conversion date across all contacts associated this company or organization
First ConversionTEXTThe first form submitted across all contacts associated this company or organization
First Deal Created DateTIMESTAMPThe create date of the first deal associated with this company record.
Year FoundedTEXTThe year the company was created. Powered by HubSpot Insights.
Google Plus PageTEXTThe URL of the Google Plus page for the company or organization
Time First SeenTIMESTAMPThe first activity for any contact associated with this company or organization
First Touch Converting CampaignTEXTThe campaign responsible for the first touch creation of the first contact associated with this company
Time of First SessionTIMESTAMPTime of first session across all contacts associated with this company or organization
Time Last SeenTIMESTAMPTime last seen across all contacts associated with this company or organization
Last Touch Converting CampaignTEXTThe campaign responsible for the last touch creation of the first contact associated with this company
Time of Last SessionTIMESTAMPTime of the last session attributed to any contacts that are associated with this company record.
Number of PageviewsNUMERICTotal number of page views across all contacts associated with this company or organization
Number of SessionsNUMERICTotal number of sessions across all contacts associated with this company or organization
Original Source TypeTEXTOriginal source for the contact with the earliest activity for this company or organization
Original Source Data 1TEXTAdditional information about the original source for the contact with the earliest activity for this company or organization
Original Source Data 2TEXTAdditional information about the original source for the contact with the earliest activity for this company or organization
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.
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
Target AccountBOOLEANThe Target Account property identifies the companies that you are marketing and selling to as part of your account-based strategy.
Last Booked Meeting DateTIMESTAMPThe last date of booked meetings associated with the company
Last Logged Call DateTIMESTAMPThe last date of logged calls associated with the company
Last Open Task DateTIMESTAMPThe last due date of open tasks associated with the 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.
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.
Lead StatusTEXTThe company's sales, prospecting or outreach status
Number of blockersNUMERICThe number of contacts associated with this company with the role of blocker.
Number of child companiesNUMERICThe number of child companies of this company
Number of contacts with a buying roleNUMERICThe number of contacts associated with this company with a buying role.
Number of decision makersNUMERICThe number of contacts associated with this company with the role of decision maker.
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
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.
Total open deal valueNUMERICThe total value, in your company's currency, of all open deals associated with this company
Owner Assigned DateTIMESTAMPThe timestamp when an owner was assigned to this company
Company ownerTEXTThe owner of the company
HubSpot TeamTEXTThe team of the owner of the 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.
Is PublicBOOLEANIndicates that the company is publicly traded. Powered by HubSpot Insights.
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
LinkedIn BioTEXTThe LinkedIn bio for the company or organization
NameTEXTThe name of the company or organization. Powered by HubSpot Insights.
Last ContactedTIMESTAMPThe last timestamp when a call, email or meeting was logged for a contact at this 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.
Next Activity DateTIMESTAMPThe date of the next upcoming scheduled sales activity for this company record.
Associated ContactsNUMERICThe number of contacts associated with this company
Associated DealsNUMERICThe number of deals associated with this company
Number of times contactedNUMERICThe number of times a call, email or meeting was logged for this company
Number of Form SubmissionsNUMERICThe number of forms submission for all contacts associated with this company or organization
Number of EmployeesNUMERICThe total number of employees who work for the company or organization
HubSpot Owner EmailTEXTHubSpot owner email for this company or organization
HubSpot Owner NameTEXTHubSpot owner name for this company or organization
Phone NumberTEXTA company's primary phone number. Powered by HubSpot Insights.
Recent Conversion DateTIMESTAMPThe most recent conversion date across all contacts associated this company or organization
Recent ConversionTEXTThe last form submitted across all contacts associated this company or organization
Recent Deal AmountNUMERICThe amount of the last deal closed
Recent Deal Close DateTIMESTAMPThe date of the last `closed won` deal associated with this company record.
State/RegionTEXTThe state or region in which the company or organization is located. Powered by HubSpot Insights.
Time ZoneTEXTThe time zone where the company or organization is located. Powered by HubSpot Insights.
Total Money RaisedTEXTThe total amount of money raised by the company. Powered by HubSpot Insights.
Total RevenueNUMERICThe total amount of closed won deals
Twitter BioTEXTThe Twitter bio of the company or organization
Twitter FollowersNUMERICThe number of Twitter followers of the company or organization
Twitter HandleTEXTThe main twitter account of the company or organization
TypeTEXTThe optional classification of this company record - prospect, partner, etc.
Web TechnologiesTEXTThe web technologies used by the company or organization. Powered by HubSpot Insights.
Website URLTEXTThe main website of the company or organization. This property is used to identify unique companies. Powered by HubSpot Insights.
Postal CodeTEXTThe postal or zip code of the company or organization. Powered by HubSpot Insights.
Street AddressTEXTA contact's street address, including apartment or unit #
Annual RevenueTEXTAnnual company revenue
CityTEXTA contact's city of residence
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.
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.
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
Country/RegionTEXTThe contact's country/region of residence. This might be set via import, form, or integration.
Create DateTIMESTAMPThe date that a contact entered the system
Currently in workflowTEXTIf the contact is currently enrolled in any workflow
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
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.
DegreeTEXTA contact's degree. This property is required for the Facebook Ads Integration. This property will be automatically synced to via Lead Ads tool
EmailTEXTA contact's email address
Date of last meeting booked in meetings toolTIMESTAMPThe date of the most recent meeting a contact has booked through the meetings tool.
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.
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.
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.
Fax NumberTEXTA contact's primary fax number
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
First Conversion DateTIMESTAMPThe date this contact first submitted a form
First ConversionTEXTThe first form this contact submitted
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.
First NameTEXTA contact's first name
Follower CountNUMERICThe number of Twitter followers a contact has
GenderTEXT
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
Average PageviewsNUMERICThe average number of pages a contact sees. This is automatically set by HubSpot for each contact.
First Referring SiteTEXTThe first website that referred a contact to your website. This is automatically set by HubSpot for each contact.
Time First SeenTIMESTAMPThe first time a contact has been seen. This is automatically set by HubSpot for each contact.
First Touch Converting CampaignTEXTThe campaign responsible for the first touch creation of this contact
First Page SeenTEXTThe first page a contact saw on your website. This is automatically set by HubSpot for each contact.
Time of First SessionTIMESTAMPThe first time a contact visited your website. This is automatically set by HubSpot for each contact.
Last Referring SiteTEXTThe last website that referred a contact to your website. This is automatically set by HubSpot for each contact.
Time Last SeenTIMESTAMPThe last time and date a contact has viewed a page on your website.
Last Touch Converting CampaignTEXTThe campaign responsible for the last touch creation of this contact
Last Page SeenTEXTThe last page a contact saw on your website. This is automatically set by HubSpot for each contact.
Time of Last SessionTIMESTAMPThe last time and date a contact visited your website.
Number of event completionsNUMERICThe sum of all events a contact has experienced. This is automatically set by HubSpot for each contact.
Number of PageviewsNUMERICThe sum of all pages a contact has seen on your website. This is automatically set by HubSpot for each contact.
Number of SessionsNUMERICThe sum of all sessions a contact has made to your website. This is automatically set by HubSpot for each 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
Original SourceTEXTFirst known source the contact used to find your website. Set automatically, but may be updated manually.
Original Source Drill-Down 1TEXTAdditional information about the source through which a contact first found your website. This property is automatically set by HubSpot.
Original Source Drill-Down 2TEXTAdditional information about the source through which a contact first found your website. This property is automatically set by HubSpot.
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.
Email ConfirmedBOOLEANEmail Confirmation status of user of Content Membership
Membership NotesTEXTThe notes relating to the contact's content membership.
Registered AtTIMESTAMPDatetime at which this user was set up for Content Membership
Domain to which registration email was sentTEXTDomain to which the registration invitation email for Content Membership was sent to
Time registration email was sentTIMESTAMPDatetime at which this user was sent a registration invitation email for Content Membership
StatusTEXTThe status of the contact's content membership.
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.
Invalid email addressBOOLEANThe email address associated with this contact is invalid.
Marketing emails bouncedNUMERICThe number of marketing emails that bounced for the current email address. This is automatically set by HubSpot.
Marketing emails clickedNUMERICThe number of marketing emails which have had link clicks for the current email address. This is automatically set by HubSpot.
Email address quarantine reasonTEXTThe reason why the email address has been quarantined.
Marketing emails deliveredNUMERICThe number of marketing emails delivered for the current email address. This is automatically set by HubSpot.
Email DomainTEXTA contact's email address domain
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.
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.
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.
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.
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.
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.
Last marketing email nameTEXTThe name of the last marketing email sent to the current email address. This is automatically set by HubSpot.
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.
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.
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.
Marketing emails openedNUMERICThe number of marketing emails opened for the current email address. This is automatically set by HubSpot.
Unsubscribed from all emailBOOLEANIndicates that the current email address has opted out of all email.
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.
Email address automated quarantine reasonTEXTThe automated reason why the email address has been quarantined.
Marketing emails repliedNUMERICThe number of marketing emails replied to by the current email address. This is automatically set by HubSpot.
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.
Marketing email confirmation statusTEXTThe status of a contact's eligibility to receive marketing email. This is automatically set by HubSpot.
Facebook click idTEXT
Last NPS survey commentTEXTLast NPS survey comment that this contact gave
Last NPS survey ratingTEXTLast NPS survey rating that this contact gave
Last NPS survey dateTIMESTAMPThe time that this contact last submitted a NPS survey response. This is automatically set by HubSpot.
Google ad click idTEXT
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
Preferred languageTEXTSet your contact's preferred language for communications. This property can be changed from an import, form, or integration.
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.
Last Modified DateTIMESTAMPThe date any property on this contact was modified
Last sequence ended dateTIMESTAMPThe last sequence ended date.
Last sequence enrolledNUMERICThe last sequence enrolled.
Last sequence enrolled dateTIMESTAMPThe last sequence enrolled date.
Lead StatusTEXTThe contact's sales, prospecting or outreach status
Legal basis for processing contact's dataTEXTLegal basis for processing contact's data; 'Not applicable' will exempt the contact from GDPR protections
Became a Customer DateTIMESTAMPThe date when a contact's lifecycle stage changed to Customer. This is automatically set by HubSpot for each contact.
Became an Evangelist DateTIMESTAMPThe date when a contact's lifecycle stage changed to Evangelist. This is automatically set by HubSpot for each contact.
Became a Lead DateTIMESTAMPThe date when a contact's lifecycle stage changed to Lead. This is automatically set by HubSpot for each 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.
Became an Opportunity DateTIMESTAMPThe date when a contact's lifecycle stage changed to Opportunity. This is automatically set by HubSpot for each 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.
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.
Became a Subscriber DateTIMESTAMPThe date when a contact's lifecycle stage changed to Subscriber. This is automatically set by HubSpot for each contact.
Marketing contact status source nameTEXTThe ID of the activity that set the contact as a marketing contact
Marketing contact status source typeTEXTThe type of the activity that set the contact as a marketing contact
Marketing contact statusTEXTThe marketing status of a contact
Marketing contact until next updateTEXTSpecifies if this contact will be set as non-marketing on renewal
Contact IDNUMERICThe unique ID for this contact. This unique ID is automatically populated by HubSpot and cannot be changed.
PersonaTEXTA contact's persona
Predictive Lead ScoreNUMERICA score calculated by HubSpot that represents a contact's likelihood to become a customer
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.
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.
Recent Sales Email Clicked DateTIMESTAMPThe last time a tracked sales email was clicked by this user
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.
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.
Number of sequences enrolledNUMERICThe number of sequences enrolled.
Currently in SequenceBOOLEANA yes/no field that indicates whether the contact is currently in a Sequence.
Facebook ClicksNUMERICThe number clicks on links shared on Facebook
Google Plus ClicksNUMERICThe number clicks on links shared on Google Plus
Most Recent Social ClickTIMESTAMPThe date of the most recent click on a published social message. This is set automatically by HubSpot for each contact.
LinkedIn ClicksNUMERICThe number clicks on links shared on LinkedIn
Broadcast ClicksNUMERICThe number of clicks on published social messages. This is set automatically by HubSpot for each 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.
Time between contact creation and deal closeNUMERIC
Time between contact creation and deal creationNUMERIC
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.
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.
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.
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.
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.
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.
HubSpot TeamTEXTThe team of the owner of a contact.
HubSpot ScoreNUMERICThe number that shows qualification of contacts to sales readiness. It can be set in HubSpot's Lead Scoring app.
IndustryTEXTThe industry a contact is in
IP CityTEXTThe city reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
IP CountryTEXTThe country reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
IP Country CodeTEXTThe country code reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
IP State/RegionTEXTThe state or region reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
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.
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
Job TitleTEXTA contact's job title
Klout ScoreNUMERICA contact's Klout score, a measure of Internet influence
Last NameTEXTA contact's last name
Lifecycle StageTEXTThe qualification of contacts to sales readiness. It can be set through imports, forms, workflows, and manually on a per contact basis.
LinkedIn BioTEXTA contact's LinkedIn bio
LinkedIn ConnectionsNUMERICHow many LinkedIn connections they have
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
MessageTEXTA default property to be used for any message or comments a contact may want to leave on a form.
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
Mobile Phone NumberTEXTA contact's mobile phone number
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.
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.
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.
Associated DealsNUMERICThe number of deals associated with this contact. This is set automatically by HubSpot.
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.
Number of Form SubmissionsNUMERICThe number of forms this contact has submitted
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.
Number of Unique Forms SubmittedNUMERICThe number of different forms this contact has submitted
Number of EmployeesTEXTThe number of company employees
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.
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.
Phone NumberTEXTA contact's primary phone number
Recent Conversion DateTIMESTAMPThe date this contact last submitted a form
Recent ConversionTEXTThe last form this contact submitted
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.
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.
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
SalutationTEXTThe title used to address a 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
SeniorityTEXTA contact's seniority. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
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
State/RegionTEXTThe contact's state of residence. This might be set via import, form, or integration.
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.
Twitter BioTEXTThe contact's Twitter bio. This is set by HubSpot using the contact's email address.
Twitter UsernameTEXTThe contact's Twitter handle. This is set by HubSpot using the contact's email address.
Twitter Profile PhotoTEXTThe contact's Twitter profile photo. This is set by HubSpot using the contact's email address.
Website URLTEXTThe contact's company website
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
Postal CodeTEXTThe contact's zip code. This might be set via import, form, or integration.
Created DateTIMESTAMPAlias for contact_createdate
Last Modified DateDATEThe timestamp that specifies when the stage was modified
AmountNUMERICThe total amount of the deal
Amount in company currencyNUMERICThe amount of the deal, using the exchange rate, in your company's currency
Closed Lost ReasonTEXTReason why this deal was lost
Closed Won ReasonTEXTReason why this deal was won
Close DateTIMESTAMPThe expected close date of the deal
Create DateTIMESTAMPThe date the deal was created. This property is set automatically by HubSpot.
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
Date of last meeting booked in meetings toolTIMESTAMPThe date of the most recent meeting an associated contact has booked through the meetings tool.
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.
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.
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.
Annual contract valueNUMERICThe annual contract value (ACV) of this deal.
Original Source TypeTEXTOriginal source for the contact with the earliest activity for this 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.
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.
Annual recurring revenueNUMERICThe annual recurring revenue (ARR) of this deal.
Forecast AmountNUMERICThe forecasted deal value calculated by multiplying the forecast probability and deal amount
Forecast ProbabilityNUMERICThe percent probability the deal will close, expressed as a decimal.
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.
Forecast categoryTEXTThe likelihood a deal will close. This property is used for manual forecasting your deals.
Monthly recurring revenueNUMERICThe monthly recurring revenue (MRR) of this deal.
Next stepTEXTA short description of the next step for the deal
Deal IDNUMERICThe unique ID for this deal. This unique ID is automatically populated by HubSpot and cannot be changed.
PriorityTEXT
Total contract valueNUMERICThe total contract value (TCV) of this deal.
Owner Assigned DateTIMESTAMPThe date the most recent deal owner was assigned to a deal. This is updated automatically by HubSpot.
Deal ownerTEXTThe owner of the deal
HubSpot TeamTEXTThe team of the owner of the 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.
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.
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.
Number of ContactsNUMERICThe number of contacts associated with this deal. This property is set automatically by HubSpot.
Number of times contactedNUMERICThe number of times a call, email or meeting was logged for this 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.
PipelineTEXTThe pipeline the deal is in. This determines which stages are options for the deal.
EmailTEXTAlias for contact_email
First NameTEXTAlias for contact_firstname
Last NameTEXTAlias for contact_lastname
Lifecycle StageTEXTAlias for contact_lifecyclestage
Phone NumberTEXTAlias for contact_phone
Pipeline IDTEXTPipeline ID
Pipeline NameTEXTPipeline name
Stage Created DateTIMESTAMPThe timestamp that specifies when the stage was created
Stage Display Order NumberNUMERICStage display order number
Stage IDTEXTStage ID
Is Stage ArchivedBOOLEANIs stage archived
Is ClosedBOOLEANIs deal closed
Stage NameTEXTStage name
ProbablityTEXTDeal probability
Stage Last Modified DateTIMESTAMPThe timestamp that specifies when the stage was modified

Windsor.ai: Easily connect HubSpot to Azure

See the value and return on every marketing touchpoint

data warehouse

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

insights

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

Start a free trial today.

Integrate all your data and measure what matters.