HubSpot data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: EMAIL

campaign_group_id
Display name Email campaign group ID
Description An ID referencing the email campaign group which the email message is part of
Field type dimension
Data type int.number.value
campaign_name
Display name Email campaign name
Field type dimension
Data type string.text.value
campaign_subject
Display name Email campaign subject
Field type dimension
Data type string.text.value
campaign_subtype
Display name Email campaign subtype
Field type dimension
Data type string.text.value
campaign_type
Display name Email campaign type
Field type dimension
Data type string.text.value
date
Display name Date
Field type dimension
Data type string.time.date
email_bcc
Display name Email BCC
Description The 'bcc' field of the email message
Field type dimension
Data type string.text.value
email_bounce_hard
Display name Hard bounces
Description Number of hard bounces
Field type metric
Data type int.number.value
email_bounce_total
Display name Total bounces
Field type metric
Data type int.number.value
email_campaign_id
Display name Email campaign ID
Description An ID referencing the email campaign which the email message is part of
Field type dimension
Data type int.number.value
email_cc
Display name Email CC
Description The 'cc' field of the email message
Field type dimension
Data type string.text.value
email_clicked
Display name Clicks
Description Number of clicks by recipients
Field type metric
Data type int.number.value
email_clicked_unique
Display name Unique clicks
Description Number of unique clicks by recipients
Field type metric
Data type int.number.value
email_deferred
Display name Deferred
Description Number of emails deferred
Field type metric
Data type int.number.value
email_forwarded
Display name Forwarded
Description Number of forwards by recipients
Field type metric
Data type int.number.value
email_from
Display name Sender email
Description The email in the 'from' field of the email message
Field type dimension
Data type string.text.email
email_from_name
Display name Sender name
Description The name in the 'from' field of the email message
Field type dimension
Data type string.text.value
email_opened
Display name Opens
Description Number of emails opened by recipients
Field type metric
Data type int.number.value
email_opened_glanced
Display name Glanced
Description Number of unique recipients that glanced over the email
Field type metric
Data type int.number.value
email_opened_read
Display name Read
Description Number of unique recipients that read the email
Field type metric
Data type int.number.value
email_opened_skim_read
Display name Skim read
Description Number of unique recipients that skim read the email
Field type metric
Data type int.number.value
email_opened_unique
Display name Unique opens
Field type metric
Data type int.number.value
email_printed
Display name Prints
Description Number of prints by recipients
Field type metric
Data type int.number.value
email_reply_to
Display name Reply to email
Description The 'reply-to' field of the email message
Field type dimension
Data type string.text.value
email_spam_report
Display name Marked as spam
Description Number of recipients that marked the email as spam
Field type metric
Data type int.number.value
email_subject
Display name Subject
Description The subject line of the email message
Field type dimension
Data type string.text.value
portal_domain
Display name Portal domain
Description HubSpot Portal or Hub domain
Field type dimension
Data type string.text.value
portal_id
Display name Portal ID
Description HubSpot Portal ID. Often called the Hub ID
Field type dimension
Data type string.text.value
portal_subscription_status
Display name Portal subscription status
Field type dimension
Data type string.text.value
recipient
Display name Recipient
Description The email address of the recipient of the email message
Field type dimension
Data type string.text.email
unsubscribes
Display name Unsubscribes
Description The amount of people who have unsubscribed from the email campaign
Field type metric
Data type int.number.value

Table: COMPANY

company_about_us
Display name About us
Description A short description of the company
Field type dimension
Data type string.text.value
company_annual_revenue
Display name Annual revenue
Description The actual or estimated annual revenue of the company
Field type dimension
Data type float.currency.value
company_child_companies
Display name Child companies
Description The number of child companies of this company
Field type dimension
Data type int.number.value
company_city
Display name Company city
Description The city where the company is located
Field type dimension
Data type string.geo.city
company_close_date
Display name Company close date
Description The date the company became your customer
Field type dimension
Data type string.time.date
company_country
Display name Company country
Description The country where the company is located
Field type dimension
Data type string.geo.country
company_create_date
Display name Company create date
Description The date the company was added to your account
Field type dimension
Data type string.time.date
company_description
Display name Company description
Description A short statement about the company`s mission and goals
Field type dimension
Data type string.text.value
company_domain_name
Display name Company domain name
Description The company`s website domain
Field type dimension
Data type string.text.value
company_employees
Display name Employees
Description Total number of people who work for the company
Field type dimension
Data type int.number.value
company_facebook_fans
Display name Facebook fans
Description The number of Facebook fans the company has
Field type dimension
Data type int.number.value
company_facebook_page
Display name Facebook company page
Description The URL of the company`s Facebook page
Field type dimension
Data type string.text.url
company_first_contact_create_date
Display name First contact create date
Description The date the first contact for this company was created in your account. This can pre-date the company`s Create date property
Field type dimension
Data type string.time.date
company_first_conversion
Display name Company first conversion
Description The first form submitted by any contact associated with the company
Field type dimension
Data type string.text.value
company_first_conversion_date
Display name Company first conversion date
Description The date of the first conversion by any contact associated with the company
Field type dimension
Data type string.time.date
company_first_deal_create_date
Display name First deal create date
Description The date the first deal was created for a contact at this company
Field type dimension
Data type string.time.date
company_form_submissions
Display name Number of form submissions
Description The total number of forms submitted by all contacts associated with the company
Field type metric
Data type int.number.value
company_id
Display name Company ID
Description ID of the company
Field type dimension
Data type int.number.value
company_industry
Display name Company industry
Description The type of business the company performs
Field type dimension
Data type string.text.value
company_is_public
Display name Is company public
Description Indicates that the company is publicly traded
Field type dimension
Data type bool
company_last_activity
Display name Company last activity date
Description The last time a note, call, meeting, or task was logged for a company
Field type dimension
Data type string.time.date
company_last_contacted
Display name Company last contacted
Description The timestamp from the most recent chat conversation, call, email, or meeting logged for this company
Field type dimension
Data type string.time.datetime
company_last_modified
Display name Company last modified date
Description The last time any property was modified for this company
Field type dimension
Data type string.time.date
company_lead_status
Display name Company lead status
Description The company`s sales, prospecting, or outreach status
Field type dimension
Data type string.text.value
company_lifecycle_stage
Display name Company lifecycle stage
Description The most advanced lifecycle stage (Subscriber, Lead, Marketing Qualified Lead, Sales Qualified Lead, Opportunity, Customer, Evangelist, or Other) of any contact associated with this company
Field type dimension
Data type string.text.value
company_linkedin_bio
Display name LinkedIn bio
Description The company`s LinkedIn bio
Field type dimension
Data type string.text.value
company_linkedin_page
Display name LinkedIn company page
Description The URL of the company`s LinkedIn page
Field type dimension
Data type string.text.url
company_name
Display name Company name
Description The name of the company
Field type dimension
Data type string.text.value
company_next_activity
Display name Company next activity date
Description The date of the next upcoming activity for this company
Field type dimension
Data type string.time.date
company_owner
Display name Company owner
Description The HubSpot user that the company is assigned to
Field type dimension
Data type string.text.value
company_owner_assigned_date
Display name Company owner assigned date
Description Timestamp for when a company owner was assigned to the company
Field type dimension
Data type string.time.date
company_page_views
Display name Company page views
Description The total number of page views for all contacts associated with this company
Field type metric
Data type int.number.value
company_parent_company_id
Display name Parent company ID
Description The company ID of the company`s parent company
Field type dimension
Data type int.number.value
company_phone_number
Display name Company phone number
Description The company`s primary phone number
Field type dimension
Data type string.text.phone
company_recent_conversion
Display name Company recent conversion
Description The last form submitted by a contact associated with the company
Field type dimension
Data type string.text.value
company_recent_conversion_date
Display name Company recent conversion date
Description The date of the most recent conversion by a contact associated with the company
Field type dimension
Data type string.time.date
company_recent_deal_date
Display name Recent deal date
Description The date of the last associated deal closed as won
Field type dimension
Data type string.time.date
company_region
Display name Company state/region
Description The state or region where the company is located
Field type dimension
Data type string.geo.region
company_sessions
Display name Number of sessions
Description The total number of sessions for all contacts associated with this company
Field type metric
Data type int.number.value
company_street_address_1
Display name Company address
Description The street address of the company
Field type dimension
Data type string.geo.street
company_street_address_2
Display name Company address 2
Description Additional address information for the company
Field type dimension
Data type string.geo.street
company_time_zone
Display name Company time zone
Description The time zone where the company or organization is located
Field type dimension
Data type string.time.timezone
company_total_count
Display name Companies
Description Number of companies
Field type metric
Data type int.number.value
company_total_money_raised
Display name Company money raised
Description The amount of money raised by the company
Field type dimension
Data type string.text.value
company_twitter_bio
Display name Twitter bio
Description The company`s Twitter bio
Field type dimension
Data type string.text.value
company_twitter_followers
Display name Twitter followers
Description The number of Twitter followers the company has
Field type dimension
Data type int.number.value
company_twitter_handle
Display name Twitter handle
Description The company`s Twitter handle
Field type dimension
Data type string.text.value
company_type
Display name Company type
Description The company`s relationship to you (prospect, partner, reseller, vendor, or other)
Field type dimension
Data type string.text.value
company_website_url
Display name Company website URL
Description The company`s web address
Field type dimension
Data type string.text.url
company_year_founded
Display name Year founded
Description The year the company was created
Field type dimension
Data type string.text.value
company_zip_code
Display name Company postal code
Description Postal or zip code for the company
Field type dimension
Data type string.geo.zip

Table: CONTACT

analytics_page_url
Display name Page URL
Description Page URL
Field type dimension
Data type string.text.url
company_close_date
Display name Company close date
Description The date the company became your customer
Field type dimension
Data type string.time.date
company_country
Display name Company country
Description The country where the company is located
Field type dimension
Data type string.geo.country
company_create_date
Display name Company create date
Description The date the company was added to your account
Field type dimension
Data type string.time.date
company_description
Display name Company description
Description A short statement about the company`s mission and goals
Field type dimension
Data type string.text.value
company_domain_name
Display name Company domain name
Description The company`s website domain
Field type dimension
Data type string.text.value
company_employees
Display name Employees
Description Total number of people who work for the company
Field type dimension
Data type int.number.value
company_facebook_fans
Display name Facebook fans
Description The number of Facebook fans the company has
Field type dimension
Data type int.number.value
company_facebook_page
Display name Facebook company page
Description The URL of the company`s Facebook page
Field type dimension
Data type string.text.url
company_first_contact_create_date
Display name First contact create date
Description The date the first contact for this company was created in your account. This can pre-date the company`s Create date property
Field type dimension
Data type string.time.date
company_first_conversion
Display name Company first conversion
Description The first form submitted by any contact associated with the company
Field type dimension
Data type string.text.value
company_first_conversion_date
Display name Company first conversion date
Description The date of the first conversion by any contact associated with the company
Field type dimension
Data type string.time.date
company_first_deal_create_date
Display name First deal create date
Description The date the first deal was created for a contact at this company
Field type dimension
Data type string.time.date
contact_address
Display name Contact street address
Description The contact`s street address, including apartment or unit #
Field type dimension
Data type string.geo.street
contact_city
Display name Contact city
Description A contact`s city of residence
Field type dimension
Data type string.geo.city
contact_close_date
Display name Close date
Description The date that a contact became a Customer
Field type dimension
Data type string.time.date
contact_company
Display name Contact company name
Description The contact's company name
Field type dimension
Data type string.text.value
contact_country
Display name Contact country
Description The contact`s country of residence
Field type dimension
Data type string.geo.country
contact_create_date
Display name Contact create date
Description The date that a contact entered the system
Field type dimension
Data type string.time.date
contact_customer_date
Display name Became a customer date
Description The date that a contact`s lifecycle stage changed to Customer
Field type dimension
Data type string.time.date
contact_days_to_close
Display name Contact days to close
Description The days that elapsed from when a contact was created until they closed as a customer
Field type dimension
Data type int.number.value
contact_email
Display name Email
Description The contact`s primary email address
Field type dimension
Data type string.text.email
contact_first_name
Display name First name
Description The contact`s first name
Field type dimension
Data type string.text.value
contact_first_referrer
Display name First referring site
Description The first website that referred the contact to your website
Field type dimension
Data type string.text.url
contact_first_url
Display name First page seen
Description The first page the contact saw on your website
Field type dimension
Data type string.text.url
contact_first_visit
Display name Contact first visit date
Description The first time a contact visited your website
Field type dimension
Data type string.time.date
contact_job_title
Display name Job title
Description The contact`s job title
Field type dimension
Data type string.text.value
contact_language
Display name Preferred language
Description The contact`s preferred language for communications
Field type dimension
Data type string.text.value
contact_last_name
Display name Last name
Description The contact`s last name
Field type dimension
Data type string.text.value
contact_last_touch_converting_campaign
Display name Last touch converting campaign
Description The campaign responsible for the last touch creation of this contact
Field type dimension
Data type string.text.value
contact_last_url
Display name Last page seen
Description The last page the contact saw on your website
Field type dimension
Data type string.text.url
contact_lead_date
Display name Became a lead date
Description The date that a contact`s lifecycle stage changed to Lead
Field type dimension
Data type string.time.date
contact_lifecycle_stage
Display name Contact lifecycle stage
Description A property used to indicate at what point the contact is within the marketing/sales process
Field type dimension
Data type string.text.value
contact_likelihood_to_close
Display name Likelihood to close
Description The probability that a contact will become a customer within the next 90 days. This score is based on standard contact properties and behavior. Marketing Hub Enterprise, Sales Hub Enterprise, and Sales Hub Enterprise only
Field type dimension
Data type int.number.percentage
contact_marketing_lead_date
Display name Became a marketing qualified lead date
Description The date that a contact`s lifecycle stage changed to Marketing Qualified Lead
Field type dimension
Data type string.time.date
contact_message
Display name Message
Description A default property to be used for any message or comments a contact may want to leave on a form
Field type dimension
Data type string.text.value
contact_mobile_phone
Display name Contact mobile phone number
Description The contact`s mobile phone number
Field type dimension
Data type string.text.phone
contact_page_views
Display name Contact page views
Description The sum of all pages the contact has seen on your website
Field type metric
Data type int.number.value
contact_phone
Display name Contact phone number
Description The contact`s primary phone number
Field type dimension
Data type string.text.value
contact_region
Display name Contact state/region
Description The contact`s state of residence
Field type dimension
Data type string.geo.region