Connect Hubspot to Google Data Studio
Directly connect Hubspot to Looker Studio in an easy-to-use format.
Analyze Your Marketing Metrics from Hubspot in GDS
About Hubspot
About Google Data Studio
Why integrate Hubspot with Google Data Studio?
- Integrating data from Hubspot CRM to Looker Studio can provide powerful insights into your customer base and how they interact with your products or services.
- Understanding which leads are the most qualified and valuable allows you to direct your marketing efforts toward those leads rather than wasting time and resources contacting low-quality prospects.
- You’ll also be able to identify relationships between different customer groups, which will aid in the development of targeted marketing campaigns.
- The powerful reporting features of Looker Studio will enable you to make informed decisions based on the data collected.
- Looker Studio will allow you to identify patterns in campaign performance, generate insights, and freely share your data.
About the Hubspot Google Data Studio Connector
The Hubspot Google Data Studio Connector pulls metrics and dimensions for Hubspot CRM. The Insights are retrieved at the campaign and ad levels.
Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.
Prerequisites
To set up the connector, the user should have:
- A Hubspot advertiser account (Visit our privacy policy and terms of use)
- Google account for Hubspot to Google Data Studio integration.
- A Windsor account. Start your free trial now.
How to connect Hubspot to Google Data Studio?
Do you plan to connect and visualize your Hubspot in Google Data Studio? Follow the Tutorial Below:
Select the fields on the right to later use in your data source. For example, you can include metrics such as Cost per Click, Cost per Action or Total Spend. Go to “Select Destination” and choose Google Data Studio. Once done, select “connect” and authorize access to your data source.
Google Data Studio Templates for Hubspot
These free and customizable Google Data Studio Hubspot templates will assist you in visualizing your data for easy reporting and analysis.
Hubspot metrics & dimensions available for streaming into Google Data Studio
name type description 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 TEXT 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 TEXT 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 TEXT 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. Email 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 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
Easily connect Hubspot to Looker Studio
See the value and return on every marketing touchpoint
Providing 50+ 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.