HubSpot fields

174 metrics402 dimensionsCustom fields

Search fields

ANALYTICS

analytics_page_type

Field label	Page type
Description	Page type, i.e. blog-posts
Field type	dimension
Data type	string.text.value

analytics_page_id

Field label	Page ID
Description	ID of the page
Field type	dimension
Data type	string.text.value

analytics_page

Field label	Page
Description	Page name - blog post, landing page, etc
Field type	dimension
Data type	string.text.value

analytics_page_url

Field label	Page URL
Description	Page URL
Field type	dimension
Data type	string.text.url

analytics_source

Field label	Source
Description	Source through which people originally found your site
Field type	dimension
Data type	string.text.value

analytics_source_drill_down_1

Field label	Source Drill-Down 1
Description	First Drill-Down when reporting by source
Field type	dimension
Data type	string.text.value

analytics_source_drill_down_2

Field label	Source Drill-Down 2
Description	Second Drill-Down when reporting by source
Field type	dimension
Data type	string.text.value

analytics_sessions

Field label	Sessions
Description	The number of times a user visited your website during this period
Field type	metric
Data type	int.number.value

traffic_analytics_sessions

Field label	Traffic sessions
Description	The number of times a user visited your website during this period
Field type	metric
Data type	int.number.value

analytics_new_visitor_sessions

Field label	Traffic new visitor sessions
Description	The number of sessions from visitors who have never been to your website before
Field type	metric
Data type	int.number.value

analytics_bounces

Field label	Bounces
Description	The number of sessions that started on a page and did not move beyond that page
Field type	metric
Data type	int.number.value

traffic_analytics_bounces

Field label	Traffic bounces
Description	The number of sessions that started on a page and did not move beyond that page
Field type	metric
Data type	int.number.value

analytics_bounce_rate

Field label	Bounce rate (%)
Description	The percentage of sessions that started on a page and did not move beyond that page
Field type	metric
Data type	float.number.percentage

traffic_analytics_bounce_rate

Field label	Traffic bounce rate (%)
Description	The percentage of sessions that started on a page and did not move beyond that page
Field type	metric
Data type	float.number.percentage

analytics_session_avg_time

Field label	Avg. session length (seconds)
Description	The average time between the start and end of a session in seconds
Field type	metric
Data type	int.duration.seconds

traffic_analytics_session_avg_time

Field label	Avg. traffic session length (seconds)
Description	The average time between the start and end of a session in seconds
Field type	metric
Data type	int.duration.seconds

analytics_session_contact_rate

Field label	Session to contact rate
Description	The number of new contacts divided by the number of sessions
Field type	metric
Data type	float.number.percentage

traffic_analytics_session_contact_rate

Field label	Traffic session to contact rate
Description	The number of new contacts divided by the number of sessions
Field type	metric
Data type	float.number.percentage

analytics_contact_customer_rate

Field label	Traffic contact to customer rate
Description	The number of customers divided by contacts
Field type	metric
Data type	float.number.percentage

analytics_new_session_rate

Field label	New session (%)
Description	The percentage of total sessions from new visitors
Field type	metric
Data type	float.number.percentage

traffic_analytics_new_session_rate

Field label	New traffic sessions (%)
Description	The percentage of total sessions from new visitors
Field type	metric
Data type	float.number.percentage

analytics_page_views

Field label	Page views
Description	The total number of page views
Field type	metric
Data type	int.number.value

traffic_analytics_page_views

Field label	Traffic page views
Description	The total number of page views
Field type	metric
Data type	int.number.value

analytics_page_view_avg_time

Field label	Avg. time on page (seconds)
Description	The average amount of time a visitor stays on this page
Field type	metric
Data type	int.duration.seconds

analytics_page_views_per_session

Field label	Avg. page views per session
Description	Average unique page views per session
Field type	metric
Data type	float.number.value

traffic_analytics_page_views_per_session

Field label	Avg. traffic page views per session
Description	Average unique page views per session
Field type	metric
Data type	float.number.value

analytics_entrances

Field label	Entrances
Description	The number of sessions that started with viewing this page first
Field type	metric
Data type	int.number.value

analytics_exits

Field label	Exits
Description	The number of sessions that ended with viewing this page last
Field type	metric
Data type	int.number.value

analytics_exit_rate

Field label	Exit rate (%)
Description	The percentage of sessions that ended with viewing this page last
Field type	metric
Data type	float.number.percentage

analytics_submissions

Field label	Submissions
Description	The number of submissions
Field type	metric
Data type	int.number.value

analytics_cta_views

Field label	CTA views
Description	The number of times a call-to-action (CTA) button has been viewed on a website page
Field type	metric
Data type	int.number.value

analytics_cta_clicks

Field label	CTA clicks
Description	The number of times a call-to-action (CTA) button has been clicked on a website page
Field type	metric
Data type	int.number.value

analytics_cta_rate

Field label	CTA rate (%)
Description	The percentage of visitors who view a call-to-action (CTA) button and then click on the same CTA
Field type	metric
Data type	float.number.percentage

analytics_conversion_rate

Field label	Conversion rate (%)
Description	Submissions divided by entrances
Field type	metric
Data type	float.number.percentage

blog_instant_subscriber_count

Field label	Instant blog subscribers
Description	Blog subscribers with subscription type instant
Field type	metric
Data type	int.number.value

blog_daily_subscriber_count

Field label	Daily blog subscribers
Description	Blog subscribers with subscription type daily
Field type	metric
Data type	int.number.value

blog_weekly_subscriber_count

Field label	Weekly blog subscribers
Description	Blog subscribers with subscription type weekly
Field type	metric
Data type	int.number.value

blog_monthly_subscriber_count

Field label	Monthly blog subscribers
Description	Blog subscribers with subscription type monthly
Field type	metric
Data type	int.number.value

AUDIENCE ACCESS

contact_membership_registration_domain_sent_to

Field label	Domain to which registration email was sent
Description	The domain to which the registration invitation email for content membership was sent to. Marketing Hub Enterprise only
Field type	dimension
Data type	string.text.value

contact_email_confirmed

Field label	Email confirmed
Description	The confirmation from the contact. Marketing Hub Enterprise only
Field type	dimension
Data type	bool

contact_membership_notes

Field label	Membership notes
Description	The notes relating to the contact`s content membership
Field type	dimension
Data type	string.text.value

contact_registered_at

Field label	Registered at
Description	The datetime at which the contact set up his content membership
Field type	dimension
Data type	string.time.datetime

contact_membership_status

Field label	Membership status
Description	The status of the contact`s content membership
Field type	dimension
Data type	string.text.value

contact_membership_email_sent_at

Field label	Time registration email was sent
Description	The datetime when the registration email was sent to the contact
Field type	dimension
Data type	string.time.datetime

BLOG

blog_id

Field label	Blog ID
Description	ID of the blog
Field type	dimension
Data type	string.text.value

blog_name

Field label	Blog name
Description	Name of the blog
Field type	dimension
Data type	string.text.value

blog_root_url

Field label	Blog URL
Description	Root URL of the blog
Field type	dimension
Data type	string.text.url

blog_description

Field label	Blog description
Description	Description of the blog
Field type	dimension
Data type	string.text.value

blog_post_author_name

Field label	Blog post author
Description	Display name of the blog post author
Field type	dimension
Data type	string.text.value

BOUNCE

bounce_response

Field label	Bounce response
Field type	dimension
Data type	string.text.value

bounce_status

Field label	Bounce status
Field type	dimension
Data type	string.text.value

COMPANY

company_id

Field label	Company ID
Description	ID of the company
Field type	dimension
Data type	int.number.value

company_name

Field label	Company name
Description	The name of the company
Field type	dimension
Data type	string.text.value

company_ui_link

Field label	Link to company in HubSpot UI
Field type	dimension
Data type	string.text.url

company_about_us

Field label	About us
Description	A short description of the company
Field type	dimension
Data type	string.text.value

company_description

Field label	Company description
Description	A short statement about the company`s mission and goals
Field type	dimension
Data type	string.text.value

company_street_address_1

Field label	Company address
Description	The street address of the company
Field type	dimension
Data type	string.geo.street

company_street_address_2

Field label	Company address 2
Description	Additional address information for the company
Field type	dimension
Data type	string.geo.street

company_zip_code

Field label	Company postal code
Description	Postal or zip code for the company
Field type	dimension
Data type	string.geo.zip

company_city

Field label	Company city
Description	The city where the company is located
Field type	dimension
Data type	string.geo.city

company_region

Field label	Company state/region
Description	The state or region where the company is located
Field type	dimension
Data type	string.geo.region

company_country

Field label	Company country
Description	The country where the company is located
Field type	dimension
Data type	string.geo.country

company_country_code

Field label	Company Country/Region Code
Description	The code for the country or region where the company is located
Field type	dimension
Data type	string.geo.region.code

company_domain_name

Field label	Company domain name
Description	The company`s website domain
Field type	dimension
Data type	string.text.value

company_website_url

Field label	Company website URL
Description	The company`s web address
Field type	dimension
Data type	string.text.url

company_phone_number

Field label	Company phone number
Description	The company`s primary phone number
Field type	dimension
Data type	string.text.phone

company_industry

Field label	Company industry
Description	The type of business the company performs
Field type	dimension
Data type	string.text.value

company_is_public

Field label	Is company public
Description	Indicates that the company is publicly traded
Field type	dimension
Data type	bool

company_child_companies

Field label	Child companies
Description	The number of child companies of this company
Field type	dimension
Data type	int.number.value

company_annual_revenue

Field label	Annual revenue
Description	The actual or estimated annual revenue of the company
Field type	dimension
Data type	float.currency.value

company_employees

Field label	Employees
Description	Total number of people who work for the company
Field type	dimension
Data type	int.number.value

company_type

Field label	Company type
Description	The company`s relationship to you (prospect, partner, reseller, vendor, or other)
Field type	dimension
Data type	string.text.value

company_lead_status

Field label	Company lead status
Description	The company`s sales, prospecting, or outreach status
Field type	dimension
Data type	string.text.value

company_lifecycle_stage

Field label	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_owner

Field label	Company owner
Description	The HubSpot user that the company is assigned to
Field type	dimension
Data type	string.text.value

company_first_contact_create_date

Field label	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_deal_create_date

Field label	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_create_date

Field label	Company create date
Description	The date the company was added to your account
Field type	dimension
Data type	string.time.date

company_close_date

Field label	Company close date
Description	The date the company became your customer
Field type	dimension
Data type	string.time.date

company_last_contacted

Field label	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

Field label	Company last modified date
Description	The last time any property was modified for this company
Field type	dimension
Data type	string.time.date

company_next_activity

Field label	Company next activity date
Description	The date of the next upcoming activity for this company
Field type	dimension
Data type	string.time.date

company_last_activity

Field label	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_owner_assigned_date

Field label	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_parent_company_id

Field label	Parent company ID
Description	The company ID of the company`s parent company
Field type	dimension
Data type	int.number.value

company_recent_deal_date

Field label	Recent deal date
Description	The date of the last associated deal closed as won
Field type	dimension
Data type	string.time.date

company_time_zone

Field label	Company time zone
Description	The time zone where the company or organization is located
Field type	dimension
Data type	string.time.timezone

company_total_money_raised

Field label	Company money raised
Description	The amount of money raised by the company
Field type	dimension
Data type	string.text.value

company_year_founded

Field label	Year founded
Description	The year the company was created
Field type	dimension
Data type	string.text.value

company_facebook_page

Field label	Facebook company page
Description	The URL of the company`s Facebook page
Field type	dimension
Data type	string.text.url

company_facebook_fans

Field label	Facebook fans
Description	The number of Facebook fans the company has
Field type	dimension
Data type	int.number.value

company_linkedin_bio

Field label	LinkedIn bio
Description	The company`s LinkedIn bio
Field type	dimension
Data type	string.text.value

company_linkedin_page

Field label	LinkedIn company page
Description	The URL of the company`s LinkedIn page
Field type	dimension
Data type	string.text.url

company_twitter_bio

Field label	Twitter bio
Description	The company`s Twitter bio
Field type	dimension
Data type	string.text.value

company_twitter_followers

Field label	Twitter followers
Description	The number of Twitter followers the company has
Field type	dimension
Data type	int.number.value

company_twitter_handle

Field label	Twitter handle
Description	The company`s Twitter handle
Field type	dimension
Data type	string.text.value

company_days_to_close

Field label	Company days to close
Description	The number of days between the day the company was added to your account and the day they became a customer
Field type	dimension
Data type	int.number.value

company_first_seen_date

Field label	Company first seen date
Description	The first activity of any contact associated with this company
Field type	dimension
Data type	string.time.date

company_last_seen_date

Field label	Company last seen date
Description	The most recent activity of any contact associated with this company
Field type	dimension
Data type	string.time.date

company_first_visit_date

Field label	Company first visit date
Description	The time of the first visit by a contact associated with this company
Field type	dimension
Data type	string.time.date

company_last_visit_date

Field label	Company last visit date
Description	The time of the most recent session of a contact associated with this company
Field type	dimension
Data type	string.time.date

company_first_conversion

Field label	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

Field label	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_recent_conversion

Field label	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

Field label	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_total_count

Field label	Companies
Description	Number of companies
Field type	metric
Data type	int.number.value

company_page_views

Field label	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_sessions

Field label	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_form_submissions

Field label	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 OWNER

company_owner_id

Field label	Company owner ID
Description	ID of company owner
Field type	dimension
Data type	string.text.value

company_owner_type

Field label	Company owner type
Description	Type of company owner
Field type	dimension
Data type	string.text.value

company_owner_name

Field label	Company owner name
Description	Full name of company owner
Field type	dimension
Data type	string.text.value

CONTACT

contact_vid

Field label	Contact VID
Description	The unique visitor ID of the contact
Field type	dimension
Data type	int.number.value

contact_canonical_vid

Field label	Contact canonical VID
Field type	dimension
Data type	int.number.value

contact_profile_url

Field label	Link to contact in HubSpot UI
Field type	dimension
Data type	string.text.url

contact_total_count

Field label	Contacts
Description	Number of contacts
Field type	metric
Data type	int.number.value

contact_lead_count

Field label	Leads
Description	Number of new leads in the time period
Field type	metric
Data type	int.number.value

contact_marketing_qualified_lead_count

Field label	Marketing qualified leads
Description	Number of new marketing qualified in the time period
Field type	metric
Data type	int.number.value

contact_sales_qualified_lead_count

Field label	Sales qualified leads
Description	Number of new sales qualified leads in the time period
Field type	metric
Data type	int.number.value

contact_customer_count

Field label	Customers
Description	Number of new customers in the time period
Field type	metric
Data type	int.number.value

contact_subscriber_count

Field label	Subscribers
Description	Number of new subscribers in the time period
Field type	metric
Data type	int.number.value

contact_opportunity_count

Field label	Opportunities
Description	Number of new opportunities in the time period
Field type	metric
Data type	int.number.value

contact_evangelist_count

Field label	Evangelists
Description	Number of new evangelists in the time period
Field type	metric
Data type	int.number.value

contact_hubspotscore

Field label	Contact hubspot score
Description	The number that shows qualification of contacts to sales readiness
Field type	metric
Data type	float.number.value

CONTACT CONTENT VIEWS

contact_first_url

Field label	First page seen
Description	The first page the contact saw on your website
Field type	dimension
Data type	string.text.url

contact_first_referrer

Field label	First referring site
Description	The first website that referred the contact to your website
Field type	dimension
Data type	string.text.url

contact_first_touch_converting_campaign

Field label	First touch converting campaign
Description	The campaign responsible for the first touch creation of this contact
Field type	dimension
Data type	string.text.value

contact_last_url

Field label	Last page seen
Description	The last page the contact saw on your website
Field type	dimension
Data type	string.text.url

contact_last_referrer

Field label	Last referring site
Description	The last website that referred the contact to your website. This analytics property looks at the last page viewed, so this site can be internal or external
Field type	dimension
Data type	string.text.url

contact_last_touch_converting_campaign

Field label	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_first_seen

Field label	Contact first seen date
Description	The time and date when the contact first interacted with your business (website visit, form submission, manual contact creation or import)
Field type	dimension
Data type	string.time.date

contact_last_seen

Field label	Contact last seen date
Description	The last time and date the contact has viewed a page on your website
Field type	dimension
Data type	string.time.date

contact_first_visit

Field label	Contact first visit date
Description	The first time a contact visited your website
Field type	dimension
Data type	string.time.date

contact_last_visit

Field label	Contact last visit date
Description	The last time and date the contact visited your website
Field type	dimension
Data type	string.time.date

contact_event_completions

Field label	Event completions
Description	The sum of all events the contact has experienced
Field type	metric
Data type	int.number.value

contact_event_revenue

Field label	Event revenue
Description	Event revenue can be set on a contact using HubSpot`s events tool (Marketing Hub Enterprise only)
Field type	metric
Data type	float.currency.value

contact_page_views

Field label	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_avg_page_views

Field label	Average page views
Description	The average number of pages the contact sees
Field type	metric
Data type	int.number.value

CONTACT INFORMATION

contact_first_name

Field label	First name
Description	The contact`s first name
Field type	dimension
Data type	string.text.value

contact_last_name

Field label	Last name
Description	The contact`s last name
Field type	dimension
Data type	string.text.value

contact_job_title

Field label	Job title
Description	The contact`s job title
Field type	dimension
Data type	string.text.value

contact_company

Field label	Contact company name
Description	The contact's company name
Field type	dimension
Data type	string.text.value

contact_lifecycle_stage

Field label	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_address

Field label	Contact street address
Description	The contact`s street address, including apartment or unit #
Field type	dimension
Data type	string.geo.street

contact_zip_code

Field label	Contact postal code
Description	The contact`s postal (zip) code
Field type	dimension
Data type	string.geo.zip

contact_city

Field label	Contact city
Description	A contact`s city of residence
Field type	dimension
Data type	string.geo.city

contact_region

Field label	Contact state/region
Description	The contact`s state of residence
Field type	dimension
Data type	string.geo.region

contact_country

Field label	Contact country
Description	The contact`s country of residence
Field type	dimension
Data type	string.geo.country

contact_email

Field label	Email
Description	The contact`s primary email address
Field type	dimension
Data type	string.text.email

contact_fax

Field label	Fax
Description	The contact`s primary fax number
Field type	dimension
Data type	string.text.value

contact_message

Field label	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_phone

Field label	Contact phone number
Description	The contact`s primary phone number
Field type	dimension
Data type	string.text.value

contact_mobile_phone

Field label	Contact mobile phone number
Description	The contact`s mobile phone number
Field type	dimension
Data type	string.text.phone

contact_create_date

Field label	Contact create date
Description	The date that a contact entered the system
Field type	dimension
Data type	string.time.date

contact_subscriber_date

Field label	Became a subscriber date
Description	The date that a contact`s lifecycle stage changed to Subscriber
Field type	dimension
Data type	string.time.date

contact_lead_date

Field label	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_marketing_lead_date

Field label	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_sales_lead_date

Field label	Became a sales qualified lead date
Description	The date that a contact`s lifecycle stage changed to Sales Qualified Lead
Field type	dimension
Data type	string.time.date

contact_opportunity_date

Field label	Became an opportunity date
Description	The date that a contact`s lifecycle stage changed to Opportunity
Field type	dimension
Data type	string.time.date

contact_customer_date

Field label	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_evangelist_date

Field label	Became an evangelist date
Description	The date that a contact`s lifecycle stage changed to Evangelist
Field type	dimension
Data type	string.time.date

contact_other_date

Field label	Became an other lifecycle date
Description	The date that a contact`s lifecycle stage changed to Other
Field type	dimension
Data type	string.time.date

contact_close_date

Field label	Close date
Description	The date that a contact became a Customer
Field type	dimension
Data type	string.time.date

contact_priority

Field label	Contact priority
Description	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. Marketing Hub Enterprise, Sales Hub Enterprise, and Service Hub Enterprise only
Field type	dimension
Data type	string.text.value

contact_likelihood_to_close

Field label	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_days_to_close

Field label	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_owner_assigned_date

Field label	Contact owner assigned date
Description	The most recent date that a contact owner was assigned to a contact
Field type	dimension
Data type	string.time.date

contact_persona

Field label	Persona
Description	The contact`s persona
Field type	dimension
Data type	string.text.value

contact_language

Field label	Preferred language
Description	The contact`s preferred language for communications
Field type	dimension
Data type	string.text.value

contact_salutation

Field label	Salutation
Description	The title used to address the contact
Field type	dimension
Data type	string.text.value

CONTACT LIST

contact_list_id

Field label	List ID
Description	The unique ID of the list
Field type	dimension
Data type	int.number.value

contact_list_name

Field label	List name
Description	The name of the list
Field type	dimension
Data type	string.text.value

contact_list_type

Field label	List type
Description	One of DYNAMIC or STATIC
Field type	dimension
Data type	string.text.value

contact_list_processing_status

Field label	List processing status
Description	One of DONE, REFRESHING, INITIALIZING, or PROCESSING
Field type	dimension
Data type	string.text.value

contact_list_error_message

Field label	List processing error
Description	Any errors that happened the last time the list was processed
Field type	dimension
Data type	string.text.value

contact_list_last_processing_status_change_time

Field label	Processing last status change time
Description	The last time that the processing state changed
Field type	dimension
Data type	string.time.datetime

contact_list_created_time

Field label	List created time
Description	The time the list was created
Field type	dimension
Data type	string.time.datetime

contact_list_updated_time

Field label	List updated time
Description	The time that the list was last modified
Field type	dimension
Data type	string.time.datetime

contact_list_last_size_change_time

Field label	List last size change time
Description	Last size change time
Field type	dimension
Data type	string.time.datetime

contact_list_is_archived

Field label	List is archived
Description	Indicated whether the list is archived
Field type	dimension
Data type	bool

contact_list_is_deleteable

Field label	List is deletable
Description	If this is false, this is a system list and cannot be deleted
Field type	dimension
Data type	bool

contact_list_membership_timestamp

Field label	Contact added to list date
Description	Date when the contact was added to the contacts
Field type	dimension
Data type	string.time.date

CONTACT OWNER

contact_owner_id

Field label	Contact owner ID
Description	ID of contact owner
Field type	dimension
Data type	string.text.value

contact_owner_type

Field label	Contact owner type
Description	Type of contact owner
Field type	dimension
Data type	string.text.value

contact_owner_name

Field label	Contact owner name
Description	Full name of contact owner
Field type	dimension
Data type	string.text.value

CONVERSION INFORMATION

contact_first_conversion

Field label	Contact first conversion
Description	The first landing page and form the contact submitted on
Field type	dimension
Data type	string.text.value

contact_first_conversion_date

Field label	Contact first conversion date
Description	The date the contact first submitted a form
Field type	dimension
Data type	string.time.date

contact_recent_conversion

Field label	Contact recent conversion
Description	The last landing page and form the contact submitted
Field type	dimension
Data type	string.text.value

contact_recent_conversion_date

Field label	Contact recent conversion date
Description	The date the contact last submitted a form
Field type	dimension
Data type	string.time.date

contact_ip_city

Field label	IP city
Description	The city reported by the contact`s IP address when they fill out a form
Field type	dimension
Data type	string.geo.city

contact_ip_region

Field label	IP state/region
Description	The state or region reported by a contact`s IP address
Field type	dimension
Data type	string.geo.region

contact_ip_region_code

Field label	IP state/region code
Description	The state code or region code reported by a contact`s IP address
Field type	dimension
Data type	string.text.value

contact_ip_country

Field label	IP country
Description	The country reported by the contact`s IP address when they fill out a form
Field type	dimension
Data type	string.geo.country

contact_ip_country_code

Field label	IP country code
Description	The country code reported by a contact`s IP address
Field type	dimension
Data type	string.geo.country.twolettercode

DATASOURCE

dataSourceName

Field label	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value
Destinations	API, Data warehouse

system_metadata.data_source_logins

Field label	Data source logins
Description	The data source login accounts that were used to authenticate against the data source
Field type	dimension
Data type	string.text.json

system_metadata.data_source_login_owners

Field label	Data source login owners
Description	The Supermetrics users that created the data source login connections
Field type	dimension
Data type	string.text.json

DEAL

deal_id

Field label	Deal ID
Description	ID of the deal
Field type	dimension
Data type	string.text.value

deal_name

Field label	Deal name
Description	Name of the deal
Field type	dimension
Data type	string.text.value

deal_ui_link

Field label	Link to deal in HubSpot UI
Field type	dimension
Data type	string.text.url

deal_description

Field label	Deal description
Field type	dimension
Data type	string.text.value

deal_currency

Field label	Deal Currency
Description	The currency in which the deal was made
Field type	dimension
Data type	string.currency.code

deal_owner_assigned_date

Field label	Deal owner assigned date
Description	The date the most recent deal owner was assigned to a deal
Field type	dimension
Data type	string.time.datetime

deal_hubspot_team

Field label	Deal owner's team ID
Description	ID of the Primary team assigned to the deal owner for the deal
Field type	dimension
Data type	string.text.value

owner_team_name

Field label	Deal owner's team name
Description	Name of the Primary team assigned to the deal owner for the deal
Field type	dimension
Data type	string.text.value

deal_stage

Field label	Deal stage
Description	Deal stages allow you to categorize and track the progress of the deals that you are working on
Field type	dimension
Data type	string.text.value

deal_stage_probability

Field label	Deal probability
Description	The probability a deal will close. This defaults to the deal stage probability setting
Field type	dimension
Data type	string.text.value

deal_is_deleted

Field label	Deal is deleted
Field type	dimension
Data type	bool

deal_type

Field label	Deal type
Description	By default, categorize your deal as either a New Business or Existing Business
Field type	dimension
Data type	string.text.value

deal_pipeline

Field label	Deal pipeline
Description	The pipeline a deal is in, which determines the deal stages the deal will move through
Field type	dimension
Data type	string.text.value

deal_created

Field label	Deal created date
Description	The date the deal was created. This property is set automatically by HubSpot
Field type	dimension
Data type	string.time.date

deal_last_modified

Field label	Deal last modified date
Description	The most recent date that any property on a deal was updated
Field type	dimension
Data type	string.time.date

deal_last_activity_date

Field label	Deal last activity date
Description	The last time a note, call, email, meeting, or task was logged for a deal
Field type	dimension
Data type	string.time.date

deal_last_contacted

Field label	Deal last contacted
Description	The last time a chat conversation, call, sales email, or meeting was logged for this deal
Field type	dimension
Data type	string.time.date

deal_next_activity_date

Field label	Deal next activity date
Description	The date of the next upcoming activity for a deal
Field type	dimension
Data type	string.time.date

deal_closed

Field label	Deal closed date
Description	The day the deal is expected to close, or was closed
Field type	dimension
Data type	string.time.date

deal_closed_lost_reason

Field label	Deal lost reason
Description	Reason why the deal was lost
Field type	dimension
Data type	string.text.value

deal_closed_won_reason

Field label	Deal won reason
Description	Reason why the deal was won
Field type	dimension
Data type	string.text.value

original_source

Field label	Original source
Description	The original source for the contact, company or deal (Organic search, Paid search, Email marketing, Social media, Referrals, Other campaigns, Direct traffic, or Offline sources)
Field type	dimension
Data type	string.text.value

original_source_data_1

Field label	Original source Drill-Down 1
Description	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
Field type	dimension
Data type	string.text.value

original_source_data_2

Field label	Original source Drill-Down 2
Description	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
Field type	dimension
Data type	string.text.value

deal_recurring_revenue_deal_type

Field label	Recurring revenue deal type
Description	Type of recurring revenue deal
Field type	dimension
Data type	string.text.value

deal_recurring_revenue_inactive_date

Field label	Recurring revenue inactive date
Description	Date of recurring revenue deal becoming inactive
Field type	dimension
Data type	string.time.date

deal_recurring_revenue_inactive_reason

Field label	Recurring revenue inactive reason
Description	Reason of recurring revenue deal becoming inactive
Field type	dimension
Data type	string.text.value

DEAL OWNER

owner_id

Field label	Deal owner ID
Description	ID of deal owner
Field type	dimension
Data type	string.text.value

owner_type

Field label	Deal owner type
Description	Type of deal owner
Field type	dimension
Data type	string.text.value

owner_name

Field label	Deal owner name
Description	Full name of deal owner
Field type	dimension
Data type	string.text.value

DEFERRED

deferred_response

Field label	Deferred response
Field type	dimension
Data type	string.text.value

deferred_attempt

Field label	Deferred attempt
Field type	dimension
Data type	int.number.value

DELIVERED

delivered_response

Field label	Delivered response
Field type	dimension
Data type	string.text.value

delivered_smtp_id

Field label	Delivered SMTP ID
Field type	dimension
Data type	string.text.value

DEPRECATED

workflow_only_biz_days

Field label	Only executed on business days
Description	Whether the workflow is only executed on business days or not.
Field type	dimension
Data type	bool
🚫 Deprecated	Deprecated on 2023-08-09

contact_ip_time_zone

Field label	IP time zone
Description	The timezone reported by a contact`s IP address.
Field type	dimension
Data type	string.text.value
🚫 Deprecated	Deprecated on 2024-11-05

workflow_only_enrolls_manually

Field label	Only enrolls manually
Description	Whether the workflow enrolls only manually or not.
Field type	dimension
Data type	bool
🚫 Deprecated	Deprecated on 2023-08-09

DROPPED

dropped_reason

Field label	Drop reason
Description	The reason why the email message was dropped
Field type	dimension
Data type	string.text.value

dropped_message

Field label	Drop message
Description	The raw message describing why the email message was dropped
Field type	dimension
Data type	string.text.value

EMAIL

recipient

Field label	Recipient
Description	The email address of the recipient of the email message
Field type	dimension
Data type	string.text.email

email_subject

Field label	Subject
Description	The subject line of the email message
Field type	dimension
Data type	string.text.value

email_from

Field label	Sender email
Description	The email in the 'from' field of the email message
Field type	dimension
Data type	string.text.email

email_from_name

Field label	Sender name
Description	The name in the 'from' field of the email message
Field type	dimension
Data type	string.text.value

email_reply_to

Field label	Reply to email
Description	The 'reply-to' field of the email message
Field type	dimension
Data type	string.text.value

email_cc

Field label	Email CC
Description	The 'cc' field of the email message
Field type	dimension
Data type	string.text.value

email_bcc

Field label	Email BCC
Description	The 'bcc' field of the email message
Field type	dimension
Data type	string.text.value

email_click_url

Field label	Click URL
Description	The URL within the message that the recipient clicked
Field type	dimension
Data type	string.text.url

email_link_id

Field label	Link ID
Description	Email URL id that distinguishes between same email URL
Field type	dimension
Data type	string.text.value

email_click_referer

Field label	Click referer URL
Description	The URL of the webpage that linked to the URL clicked
Field type	dimension
Data type	string.text.url

ip_address

Field label	Recipient IP address
Description	The IP address where the event originated
Field type	dimension
Data type	string.text.value

device_type

Field label	Recipient device type
Description	Type of the device
Field type	dimension
Data type	string.text.value

email_sent

Field label	Sent
Description	Number of emails sent
Field type	metric
Data type	int.number.value

email_dropped

Field label	Not sent
Description	Number of emails dropped
Field type	metric
Data type	int.number.value

email_dropped_rate

Field label	Not sent (%)
Description	Dropped rate based on sent
Field type	metric
Data type	float.number.percentage

email_processed

Field label	Processed
Description	Number of emails processed
Field type	metric
Data type	int.number.value

email_processed_rate

Field label	Processed (%)
Description	Processed rate based on sent
Field type	metric
Data type	float.number.percentage

email_delivered

Field label	Successful deliveries
Description	Number of successful email deliveries
Field type	metric
Data type	int.number.value

email_delivered_rate

Field label	Successful deliveries (%)
Description	Successful delivery rate based on sent
Field type	metric
Data type	float.number.percentage

email_deferred

Field label	Deferred
Description	Number of emails deferred
Field type	metric
Data type	int.number.value

email_deferred_rate

Field label	Deferred (%)
Description	Deferred rate based on sent
Field type	metric
Data type	float.number.percentage

email_opened

Field label	Opens
Description	Number of emails opened by recipients
Field type	metric
Data type	int.number.value

email_opened_unique

Field label	Unique opens
Field type	metric
Data type	int.number.value

email_opened_rate

Field label	Opens (%)
Description	Open rate based on successful deliveries
Field type	metric
Data type	float.number.percentage

email_ctr

Field label	Opens CTR (%)
Description	Click-through rate based on opens
Field type	metric
Data type	float.number.percentage

email_clicked

Field label	Clicks
Description	Number of clicks by recipients
Field type	metric
Data type	int.number.value

email_clicked_unique

Field label	Unique clicks
Description	Number of unique clicks by recipients
Field type	metric
Data type	int.number.value

email_clicked_rate

Field label	Clicks (%)
Description	Click rate based on successful deliveries
Field type	metric
Data type	float.number.percentage

email_printed

Field label	Prints
Description	Number of prints by recipients
Field type	metric
Data type	int.number.value

email_printed_rate

Field label	Prints (%)
Description	Print rate based on opens
Field type	metric
Data type	float.number.percentage

email_forwarded

Field label	Forwarded
Description	Number of forwards by recipients
Field type	metric
Data type	int.number.value

email_forwarded_rate

Field label	Forwarded (%)
Description	Forward rate based on opens
Field type	metric
Data type	float.number.percentage

email_spam_report

Field label	Marked as spam
Description	Number of recipients that marked the email as spam
Field type	metric
Data type	int.number.value

email_spam_report_rate

Field label	Marked as spam (%)
Description	Rate of marked as spam based on successful deliveries
Field type	metric
Data type	float.number.percentage

email_opened_duration

Field label	Avg. open duration
Description	The average approximate number of seconds recipients had opened the email for
Field type	metric
Data type	float.number.value

email_opened_glanced

Field label	Glanced
Description	Number of unique recipients that glanced over the email
Field type	metric
Data type	int.number.value

email_opened_glanced_rate

Field label	Glanced (%)
Description	Glanced rate based on opened
Field type	metric
Data type	float.number.percentage

email_opened_skim_read

Field label	Skim read
Description	Number of unique recipients that skim read the email
Field type	metric
Data type	int.number.value

email_opened_skim_read_rate

Field label	Skim read (%)
Description	Skim open rate based on opened
Field type	metric
Data type	float.number.percentage

email_opened_read

Field label	Read
Description	Number of unique recipients that read the email
Field type	metric
Data type	int.number.value

email_opened_read_rate

Field label	Read (%)
Description	Read rate based on opened
Field type	metric
Data type	float.number.percentage

email_bounce_total

Field label	Total bounces
Field type	metric
Data type	int.number.value

email_bounce_rate

Field label	Bounce rate (%)
Field type	metric
Data type	float.number.percentage

email_bounce_hard

Field label	Hard bounces
Description	Number of hard bounces
Field type	metric
Data type	int.number.value

email_bounce_hard_rate

Field label	Hard bounces (%)
Description	Hard bounce rate based on sent
Field type	metric
Data type	float.number.percentage

email_bounce_soft

Field label	Soft bounces
Description	Number of soft bounces
Field type	metric
Data type	int.number.value

email_bounce_soft_rate

Field label	Soft bounces (%)
Description	Soft bounce rate based on sent
Field type	metric
Data type	float.number.percentage

email_bounce_pending

Field label	Pending bounces
Description	Number of pending bounces
Field type	metric
Data type	int.number.value

email_bounce_pending_rate

Field label	Pending bounces (%)
Description	Pending bounce rate based on sent
Field type	metric
Data type	float.number.percentage

unsubscribes

Field label	Unsubscribes
Description	The amount of people who have unsubscribed from the email campaign
Field type	metric
Data type	int.number.value

unsubscribe_rate

Field label	Unsubscribe rate (%)
Description	The unsubscribe rate based on emails sent
Field type	metric
Data type	float.number.percentage

EMAIL CAMPAIGN

app_id

Field label	App ID
Description	An ID referencing the HubSpot Application which sent the email message
Field type	dimension
Data type	int.number.value

campaign_app_name

Field label	App name
Field type	dimension
Data type	string.text.value

email_campaign_id

Field label	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

campaign_ui_link

Field label	Link to email campaign in HubSpot UI
Field type	dimension
Data type	string.text.url

campaign_name

Field label	Email campaign name
Field type	dimension
Data type	string.text.value

campaign_group_id

Field label	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_type

Field label	Email campaign type
Field type	dimension
Data type	string.text.value

campaign_subtype

Field label	Email campaign subtype
Field type	dimension
Data type	string.text.value

campaign_subject

Field label	Email campaign subject
Field type	dimension
Data type	string.text.value

campaign_content_id

Field label	Email campaign content ID
Field type	dimension
Data type	int.number.value

EMAIL CLIENT

browser_user_agent

Field label	Email client user agent
Description	User agent string of the email client
Field type	dimension
Data type	string.text.value

browser_name

Field label	Email client name
Description	Name of the email client. For example: Firefox 59.0
Field type	dimension
Data type	string.text.value

browser_family

Field label	Email client family
Description	Family to which the email client belongs to. For example: Firefox
Field type	dimension
Data type	string.text.value

browser_producer

Field label	Email client producer
Description	Producer of the email client
Field type	dimension
Data type	string.text.value

browser_producer_url

Field label	Email client producer URL
Description	Website of the email client producer
Field type	dimension
Data type	string.text.url

browser_type

Field label	Email client type
Description	Type of the email client. For example: Browser, Email client, etc
Field type	dimension
Data type	string.text.value

browser_version

Field label	Email client version
Description	Version of the email client
Field type	dimension
Data type	string.text.value

EMAIL EVENT LOCATION

location_country

Field label	Country
Description	Email event country
Field type	dimension
Data type	string.geo.country

location_state

Field label	State
Description	Email event region
Field type	dimension
Data type	string.geo.region

location_city

Field label	City
Description	Email event city
Field type	dimension
Data type	string.geo.city

EMAIL INFORMATION

contact_currently_in_workflow

Field label	Currently in workflow
Description	Indicates if the contact is currently enrolled in any workflow
Field type	dimension
Data type	bool

contact_email_quarantined

Field label	Email address quarantined
Description	Indicates that the current email address has been quarantined for anti-abuse reasons and any marketing email sends to it will be blocked
Field type	dimension
Data type	bool

contact_email_confirmation_status

Field label	Email confirmation status
Description	The status of the contact`s eligibility to receive email
Field type	dimension
Data type	string.text.value

contact_email_first_send_date

Field label	First marketing email send date
Description	The date of the earliest email delivery for any marketing email
Field type	dimension
Data type	string.time.date

contact_email_first_open_date

Field label	First marketing email open date
Description	The date of the earliest email open for any marketing email
Field type	dimension
Data type	string.time.date

contact_email_first_click_date

Field label	First marketing email click date
Description	The date of the earliest link click for any marketing email
Field type	dimension
Data type	string.time.date

contact_email_last_send_date

Field label	Last marketing email send date
Description	The date of the most recent email delivery for any marketing email
Field type	dimension
Data type	string.time.date

contact_email_last_open_date

Field label	Last marketing email open date
Description	The date of the most recent email open for any marketing email
Field type	dimension
Data type	string.time.date

contact_email_last_click_date

Field label	Last marketing email click date
Description	The date of the most recent link click for any marketing email
Field type	dimension
Data type	string.time.date

contact_email_last_email_name

Field label	Last marketing email name
Description	The name of the last marketing email sent
Field type	dimension
Data type	string.text.value

contact_sends_since_last_engaged

Field label	Sends since last engagement
Description	The number of marketing emails that have been sent since the last engagement (open or link click)
Field type	metric
Data type	int.number.value

ENGAGEMENT

engagement_id

Field label	Engagement ID
Description	The unique ID for the engagement
Field type	dimension
Data type	string.text.value

engagement_is_active

Field label	Engagement is active
Description	Only active engagements will appear in the timeline
Field type	dimension
Data type	bool

engagement_created_date

Field label	Engagement create date
Description	Date when the engagement was created
Field type	dimension
Data type	string.time.date

engagement_last_updated_date

Field label	Engagement last updated date
Description	Date when the engagement was last updated
Field type	dimension
Data type	string.time.date

engagement_timestamp

Field label	Engagement timeline date
Description	Date when the engagement should appear in the timeline
Field type	dimension
Data type	string.time.date

ENGAGEMENT (CALL)

engagement_call_to_number

Field label	Engagement call to number
Description	The phone number that was called
Field type	dimension
Data type	string.text.phone

engagement_call_from_number

Field label	Engagement call from number
Description	The phone number from which the call was made
Field type	dimension
Data type	string.text.phone

engagement_call_status

Field label	Engagement call status
Description	Will be COMPLETED once the call is finished
Field type	dimension
Data type	string.text.value

engagement_call_external_id

Field label	Engagement call external ID
Description	For calls made in HubSpot, this will be the internal ID of the call
Field type	dimension
Data type	string.text.value

engagement_call_external_account_id

Field label	Engagement call external account ID
Description	For calls made in HubSpot, this will be the internal ID of the account used to make the call
Field type	dimension
Data type	string.text.value

engagement_call_body

Field label	Engagement call details
Description	The details or notes of the call
Field type	dimension
Data type	string.text.value

engagement_call_recording_url

Field label	Engagement call recording URL
Description	The URL of the recording file
Field type	dimension
Data type	string.text.url

engagement_call_disposition

Field label	Engagement call outcome
Description	The outcome of the call
Field type	dimension
Data type	string.text.value

engagement_call_duration

Field label	Engagement call duration
Description	The length of the call in seconds
Field type	metric
Data type	float.number.value

ENGAGEMENT (EMAIL)

engagement_email_sender_name

Field label	Engagement email sender
Description	The name of the sender
Field type	dimension
Data type	string.text.value

engagement_email_sender_email

Field label	Engagement email sender email
Description	The email address of the sender
Field type	dimension
Data type	string.text.email

engagement_email_recipient_name

Field label	Engagement email recipient
Description	The name of the recipient
Field type	dimension
Data type	string.text.value

engagement_email_recipient_email

Field label	Engagement email recipient email
Description	The email address of the recipient
Field type	dimension
Data type	string.text.email

engagement_email_subject

Field label	Engagement email subject
Description	The subject of the email
Field type	dimension
Data type	string.text.value

engagement_email_html

Field label	Engagement email HTML body
Description	The body of the HTML email
Field type	dimension
Data type	string.text.value

engagement_email_text

Field label	Engagement email text body
Description	The body of the text-only email
Field type	dimension
Data type	string.text.value

ENGAGEMENT (MEETING)

engagement_meeting_title

Field label	Engagement meeting title
Description	The title or subject of the meeting
Field type	dimension
Data type	string.text.value

engagement_meeting_body

Field label	Engagement meeting details
Description	The details or body of the meeting
Field type	dimension
Data type	string.text.value

engagement_meeting_start_time

Field label	Engagement meeting start time
Description	The start time of the meeting
Field type	dimension
Data type	string.time.datetime

engagement_meeting_end_time

Field label	Engagement meeting end time
Description	The end time of the meeting
Field type	dimension
Data type	string.time.datetime

ENGAGEMENT (NOTE)

engagement_note_body

Field label	Engagement note body
Description	The body of the note
Field type	dimension
Data type	string.text.value

ENGAGEMENT (TASK)

engagement_task_subject

Field label	Engagement task title
Description	The subject or title of the task
Field type	dimension
Data type	string.text.value

engagement_task_body

Field label	Engagement task details
Description	The body or details of the task
Field type	dimension
Data type	string.text.value

engagement_task_status

Field label	Engagement task status
Description	The status of the task
Field type	dimension
Data type	string.text.value

engagement_task_object_type

Field label	Engagement task object type
Description	One of CONTACT or COMPANY, what object type the task is for
Field type	dimension
Data type	string.text.value

FORM

form_guid

Field label	Form GUID
Description	The internal ID of the form
Field type	dimension
Data type	string.text.value

form_name

Field label	Form name
Description	The name of the form
Field type	dimension
Data type	string.text.value

form_css_class

Field label	CSS class
Description	The default css classes added to the form when embedded
Field type	dimension
Data type	string.text.value

form_redirect_url

Field label	Redirect URL
Description	The URL that the visitor is redirected to after filling out the form
Field type	dimension
Data type	string.text.url

form_submit_text

Field label	Submit text
Description	The text used for the submit button
Field type	dimension
Data type	string.text.value

form_inline_message

Field label	Inline message
Description	A thank you message that is displayed on the page after the form is submitted
Field type	dimension
Data type	string.text.value

form_notify_recipients

Field label	Notify recipients
Description	A comma-separated list of email addresses that should receive submission notifications
Field type	dimension
Data type	string.text.value

form_created_at

Field label	Form created date
Description	Date when the form was created
Field type	dimension
Data type	string.time.date

form_updated_at

Field label	Form last modified date
Description	Date when the form was last modified
Field type	dimension
Data type	string.time.date

form_ignore_current_values

Field label	Ignore current values
Description	If true, the form pre-populates fields with known values for know contacts
Field type	dimension
Data type	bool

form_captcha_enabled

Field label	Is captcha enabled
Description	Will be set to true for forms with captcha enabled
Field type	dimension
Data type	bool

form_is_cloneable

Field label	Is cloneable
Description	Whether or not the form can be cloned
Field type	dimension
Data type	bool

form_is_editable

Field label	Is editable
Description	Whether or not the form can be edited
Field type	dimension
Data type	bool

form_is_deletable

Field label	Is deletable
Description	If false, the form is a system form (such as a blog comment or subscription form) and cannot be deleted
Field type	dimension
Data type	bool

submission_date

Field label	Submitted on
Description	Date of the submission
Field type	dimension
Data type	string.time.date

form_submissions

Field label	Form submissions
Description	Number of form submissions
Field type	metric
Data type	int.number.value

FUNNEL

contact_new_to_subscriber_avg

Field label	Became a subscriber avg. contact time (days)
Description	Average number of days it took for a new contact to become a subscriber
Field type	metric
Data type	int.number.value

contact_became_lead_avg

Field label	Became a lead avg. lead time (days)
Description	Average number of days it took for a new contact to become a lead
Field type	metric
Data type	int.number.value

contact_new_to_mql_avg

Field label	Became a MQL avg. contact time (days)
Description	Average number of days it took for a new contact to become a marketing qualified lead
Field type	metric
Data type	int.number.value

contact_new_to_sql_avg

Field label	Became a SQL avg. contact time (days)
Description	Average number of days it took for a new contact to become a sales qualified lead
Field type	metric
Data type	int.number.value

contact_new_to_opportunity_avg

Field label	Became an opportunity avg. contact time (days)
Description	Average number of days it took for a new contact to become an opportunity
Field type	metric
Data type	int.number.value

contact_new_to_customer_avg

Field label	Became a customer avg. contact time (days)
Description	Average number of days it took for a new contact to become a customer
Field type	metric
Data type	int.number.value

contact_new_to_evangelist_avg

Field label	Became an evangelist avg. contact time (days)
Description	Average number of days it took for a new contact to become an evangelist
Field type	metric
Data type	int.number.value

contact_subscriber_to_lead_avg

Field label	Became a lead avg. subscriber time (days)
Description	Average number of days it took for a subscriber to become a lead
Field type	metric
Data type	int.number.value

contact_subscriber_to_mql_avg

Field label	Became a MQL avg. subscriber time (days)
Description	Average number of days it took for a subscriber to become a marketing qualified lead
Field type	metric
Data type	int.number.value

contact_subscriber_to_sql_avg

Field label	Became a SQL avg. subscriber time (days)
Description	Average number of days it took for a subscriber to become a sales qualified lead
Field type	metric
Data type	int.number.value

contact_subscriber_to_opportunity_avg

Field label	Became an opportunity avg. subscriber time (days)
Description	Average number of days it took for a subscriber to become an opportunity
Field type	metric
Data type	int.number.value

contact_subscriber_to_customer_avg

Field label	Became a customer avg. subscriber time (days)
Description	Average number of days it took for a subscriber to become a customer
Field type	metric
Data type	int.number.value

contact_subscriber_to_evangelist_avg

Field label	Became an evangelist avg. subscriber time (days)
Description	Average number of days it took for a subscriber to become an evangelist
Field type	metric
Data type	int.number.value

contact_became_mql_avg

Field label	Became an MQL avg. lead time (days)
Description	Average number of days it took for a lead to become a marketing qualified lead
Field type	metric
Data type	int.number.value

contact_became_sql_avg

Field label	Became an SQL avg. lead time (days)
Description	Average number of days it took for a lead to become a sales qualified lead
Field type	metric
Data type	int.number.value

contact_became_opportunity_avg

Field label	Became an opportunity lead time (days)
Description	Average number of days it took for a lead to become an opportunity
Field type	metric
Data type	int.number.value

contact_became_customer_avg

Field label	Became a customer avg. lead time (days)
Description	Average number of days it took for a lead to become a customer
Field type	metric
Data type	int.number.value

contact_lead_to_evangelist_avg

Field label	Became an evangelist avg. lead time (days)
Description	Average number of days it took for a lead to become an evangelist
Field type	metric
Data type	int.number.value

contact_mql_to_sql_avg

Field label	Became a SQL avg. MQL time (days)
Description	Average number of days it took for a marketing qualified lead to become a sales qualified lead
Field type	metric
Data type	int.number.value

contact_mql_to_opportunity_avg

Field label	Became an opportunity avg. MQL time (days)
Description	Average number of days it took for a marketing qualified lead to become an opportunity
Field type	metric
Data type	int.number.value

contact_mql_to_customer_avg

Field label	Became a customer avg. MQL time (days)
Description	Average number of days it took for a marketing qualified lead to become a customer
Field type	metric
Data type	int.number.value

contact_mql_to_evangelist_avg

Field label	Became an evangelist avg. MQL time (days)
Description	Average number of days it took for a marketing qualified lead to become an evangelist
Field type	metric
Data type	int.number.value

contact_sql_to_opportunity_avg

Field label	Became an opportunity avg. SQL time (days)
Description	Average number of days it took for a sales qualified lead to become an opportunity
Field type	metric
Data type	int.number.value

contact_sql_to_customer_avg

Field label	Became a customer avg. SQL time (days)
Description	Average number of days it took for a sales qualified lead to become a customer
Field type	metric
Data type	int.number.value

contact_sql_to_evangelist_avg

Field label	Became an evangelist avg. SQL time (days)
Description	Average number of days it took for a sales qualified lead to become an evangelist
Field type	metric
Data type	int.number.value

contact_opportunity_to_customer_avg

Field label	Became a customer avg. opportunity time (days)
Description	Average number of days it took for an opportunity to become a customer
Field type	metric
Data type	int.number.value

contact_opportunity_to_evangelist_avg

Field label	Became an evangelist avg. opportunity time (days)
Description	Average number of days it took for an opportunity to become an evangelist
Field type	metric
Data type	int.number.value

contact_customer_to_evangelist_avg

Field label	Became an evangelist avg. customer time (days)
Description	Average number of days it took for a customer to become an evangelist
Field type	metric
Data type	int.number.value

LEAD ADS

contact_date_of_birth

Field label	Lead date of birth
Description	The date of birth as provided through a lead ad form
Field type	dimension
Data type	string.time.date

contact_gender

Field label	Lead gender
Description	The gender as provided through a lead ad form
Field type	dimension
Data type	string.person.gender

contact_marital_status

Field label	Lead marital status
Description	The marital status as provided through a lead ad form
Field type	dimension
Data type	string.text.value

contact_relationship_status

Field label	Lead relationship status
Description	The relationship status as provided through a lead ad form
Field type	dimension
Data type	string.text.value

contact_military_status

Field label	Lead military status
Description	The military status as provided through a lead ad form
Field type	dimension
Data type	string.text.value

contact_work_email

Field label	Lead work email
Description	The work email as provided through a lead ad form
Field type	dimension
Data type	string.text.email

contact_job_function

Field label	Lead job function
Description	The job function as provided through a lead ad form
Field type	dimension
Data type	string.text.value

contact_seniority

Field label	Lead seniority
Description	The seniority in the company as provided through a lead ad form
Field type	dimension
Data type	string.text.value

contact_company_size

Field label	Lead company size
Description	The size of the company as provided through a lead ad form
Field type	dimension
Data type	string.text.value

contact_degree

Field label	Lead degree
Description	The degree as provided through a lead ad form
Field type	dimension
Data type	string.text.value

contact_field_of_study

Field label	Lead field of study
Description	The field of study as provided through a lead ad form
Field type	dimension
Data type	string.text.value

contact_school

Field label	Lead school
Description	The school as provided through a lead ad form
Field type	dimension
Data type	string.text.value

contact_education_start_date

Field label	Lead education start date
Description	The start date of education as provided through a lead ad form
Field type	dimension
Data type	string.time.date

contact_graduation_date

Field label	Lead graduation date
Description	The graduation date of education as provided through a lead ad form
Field type	dimension
Data type	string.time.date

LINE ITEMS

line_item_id

Field label	Line item ID
Description	ID of the line item
Field type	dimension
Data type	string.text.value

line_item_created_date

Field label	Line item created date
Description	The time when line item was created
Field type	dimension
Data type	string.time.date

line_item_updated_date

Field label	Line item updated date
Description	The time when line item was last modified
Field type	dimension
Data type	string.time.date

line_item_product_id

Field label	Line item product ID
Description	ID of the product this was copied from
Field type	dimension
Data type	string.text.value

line_item_name

Field label	Line item name
Description	Line item name
Field type	dimension
Data type	string.text.value

line_item_sku

Field label	Line item SKU
Description	Unique product identifier
Field type	dimension
Data type	string.text.value

line_item_description

Field label	Line item description
Description	Full description of the line item
Field type	dimension
Data type	string.text.value

line_item_images

Field label	Line item images
Description	Images of products used in the line item
Field type	dimension
Data type	string.text.value

line_item_url

Field label	Line item product URL
Description	Product URL used in the line item
Field type	dimension
Data type	string.text.url

line_item_currency

Field label	Line item currency
Description	Currency code for the line item
Field type	dimension
Data type	string.currency.code

line_item_recurring_billing_start_date

Field label	Line item billing start date
Description	Recurring billing start date for the line item
Field type	dimension
Data type	string.time.date

line_item_recurring_billing_end_date

Field label	Line item billing end date
Description	Recurring billing end date for the line item
Field type	dimension
Data type	string.time.date

line_item_recurring_billing_term

Field label	Line item billing term
Description	Product recurring billing duration
Field type	dimension
Data type	string.text.value

line_item_recurring_billing_frequency

Field label	Line item billing frequency
Description	How frequently the line item is billed
Field type	dimension
Data type	string.text.value

line_item_quantity

Field label	Line item quantity
Description	How many units of a product are in the line item
Field type	metric
Data type	int.number.value

line_item_term_in_months

Field label	Line item term in months
Description	The number of months in the term of the line item
Field type	metric
Data type	float.number.value

line_item_net_price

Field label	Line item net price
Description	The amount of the line item
Field type	metric
Data type	float.currency.value

line_item_unit_price

Field label	Line item unit price
Description	Cost of product in the line item
Field type	metric
Data type	float.currency.value

line_item_unit_cost

Field label	Line item unit cost
Description	The amount that sold goods cost the HubSpot customer
Field type	metric
Data type	float.currency.value

line_item_unit_discount

Field label	Line item unit discount
Description	The discount amount applied
Field type	metric
Data type	float.currency.value

line_item_discount_percentage

Field label	Line item discount percent
Description	The discount percentage applied
Field type	metric
Data type	float.number.percentage

line_item_acv

Field label	ACV
Description	The annual contract value (ACV) of the line item
Field type	metric
Data type	float.currency.value

line_item_mrr

Field label	MRR
Description	The monthly recurring revenue (MRR) of the line item
Field type	metric
Data type	float.currency.value

line_item_arr

Field label	ARR
Description	The annual recurring revenue (ARR) of the line item
Field type	metric
Data type	float.currency.value

line_item_tcv

Field label	TCV
Description	The total contract value (TCV) of the line item
Field type	metric
Data type	float.currency.value

line_item_margin

Field label	Line item margin
Description	The margin value of the line item
Field type	metric
Data type	float.currency.value

line_item_acv_margin

Field label	ACV margin
Description	The margin annual contract value of the line item
Field type	metric
Data type	float.currency.value

line_item_arr_margin

Field label	ARR margin
Description	The margin annual recurring revenue of the line item
Field type	metric
Data type	float.currency.value

line_item_mrr_margin

Field label	MRR margin
Description	The margin monthly recurring revenue of the line item
Field type	metric
Data type	float.currency.value

line_item_tcv_margin

Field label	TCV margin
Description	The margin total contract value of the line item
Field type	metric
Data type	float.currency.value

line_item_tax

Field label	Line item tax
Description	The tax amount applied
Field type	metric
Data type	float.currency.value

MARKETING EMAIL

marketing_email_ab_variation

Field label	A/B variation
Description	A/B variation in marketing email
Field type	dimension
Data type	bool

marketing_email_name

Field label	Marketing email name
Description	Name of marketing email
Field type	dimension
Data type	string.text.value

PORTAL

portal_id

Field label	Portal ID
Description	HubSpot Portal ID. Often called the Hub ID
Field type	dimension
Data type	string.text.value

portal_domain

Field label	Portal domain
Description	HubSpot Portal or Hub domain
Field type	dimension
Data type	string.text.value

portal_currency

Field label	Portal currency
Description	HubSpot portal currency
Field type	dimension
Data type	string.currency.code

PRODUCT

product_id

Field label	Product ID
Description	ID of the product
Field type	dimension
Data type	string.text.value

product_created_date

Field label	Product create date
Description	Date when the product was created
Field type	dimension
Data type	string.time.date

product_description

Field label	Product description
Description	Description of the product
Field type	dimension
Data type	string.text.value

product_last_modified_date

Field label	Product last modified date
Description	Date when the product was last modified
Field type	dimension
Data type	string.time.date

product_name

Field label	Product name
Description	Name of the product
Field type	dimension
Data type	string.text.value

product_recurring_billing_frequency

Field label	Product recurring billing frequency
Description	Recurring billing frequency of the product
Field type	dimension
Data type	string.text.value

product_recurring_billing_period

Field label	Product recurring billing period
Description	Recurring billing period of the product
Field type	dimension
Data type	string.text.value

product_recurring_billing_start_date

Field label	Product recurring billing start date
Description	Recurring billing start date of the product
Field type	dimension
Data type	string.time.date

product_sku

Field label	Product SKU
Description	SKU of the product
Field type	dimension
Data type	string.text.value

product_cost_of_goods_sold

Field label	Product cost of goods sold
Description	The amount that sold goods cost the HubSpot customer
Field type	metric
Data type	float.currency.value

product_discount

Field label	Product discount
Description	Discount of the product
Field type	metric
Data type	float.currency.value

product_discount_percentage

Field label	Product discount percentage
Description	Discount percentage of the product
Field type	metric
Data type	float.number.percentage

product_price

Field label	Product price
Description	Price of the product
Field type	metric
Data type	float.currency.value

product_quantity

Field label	Product quantity
Description	Quantity of the product
Field type	metric
Data type	int.number.value

product_tax

Field label	Product tax
Description	Tax of the product
Field type	metric
Data type	float.currency.value

QUERY

system_metadata.query_date_range_start

Field label	Start date
Description	The start date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_date_range_end

Field label	End date
Description	The end date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_timezone

Field label	Timezone
Description	The timezone that is supplied to the query
Field type	dimension
Data type	string.time.timezone

system_metadata.query_filters

Field label	Filters
Description	All filters used in the query
Field type	dimension
Data type	string.text.json

system_metadata.query_date_start

Field label	Start
Description	When the query was started
Field type	dimension
Data type	string.time.datetime

system_metadata.query_date_end

Field label	End
Description	When the query completed
Field type	dimension
Data type	string.time.datetime

system_metadata.query_duration

Field label	Duration
Description	The duration in seconds of the query
Field type	dimension
Data type	int.duration.seconds

system_metadata.query_accounts

Field label	Accounts
Description	A list of accounts of which the data was pulled from
Field type	dimension
Data type	string.text.json

SALES

contact_lead_status

Field label	Contact lead status
Description	The contact`s sales, prospecting or outreach status
Field type	dimension
Data type	string.text.value

contact_first_deal_created_date

Field label	First deal created date
Description	The date of the first deal a contact became associated with
Field type	dimension
Data type	string.time.date

contact_recent_deal_close_date

Field label	Recent deal close date
Description	The date of the last associated deal that was closed as won
Field type	dimension
Data type	string.time.date

contact_next_activity_date

Field label	Contact next activity date
Description	The date of the next upcoming activity for a contact. 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
Field type	dimension
Data type	string.time.date

contact_last_contacted

Field label	Contact last contacted
Description	The last time a call, sales email, or meeting was done with a contact
Field type	dimension
Data type	string.time.datetime

contact_sales_email_last_clicked

Field label	Recent sales email clicked date
Description	The date of the last time that a contact clicked on a sales email. Sales Hub Professional and Enterprise only
Field type	dimension
Data type	string.time.date

contact_sales_email_last_opened

Field label	Recent sales email opened date
Description	The date of the last time that a contact opened a sales email
Field type	dimension
Data type	string.time.date

contact_sales_email_last_replied

Field label	Recent sales email replied date
Description	The date of the last time that a contact replied to a sales email sent from your connected G Suite or Outlook 365 email account
Field type	dimension
Data type	string.time.date

contact_currently_in_sequence

Field label	Currently in sequence
Description	Indicates whether or not a contact has been enrolled in a sequence. Sales Hub Starter, Professional, and Enterprise only
Field type	dimension
Data type	bool

contact_last_meeting_booked

Field label	Last meeting booked
Description	The date of the last meeting booked with the contact through a meetings link
Field type	dimension
Data type	string.time.date

contact_last_meeting_booked_campaign

Field label	Last meeting booked campaign
Description	The campaign of the last meeting booked through the meetings tool (e.g., the specific email that was sent)
Field type	dimension
Data type	string.text.value

contact_last_meeting_booked_medium

Field label	Last meeting booked medium
Description	The medium of the last meeting booked through the meetings tool (e.g., email, website). This property will be populated only if you have UTM tracking parameters added to your meetings link
Field type	dimension
Data type	string.text.value

contact_last_meeting_booked_source

Field label	Last meeting booked source
Description	The source of the last meeting booked through the meetings tool (e.g., pql-email, landing-page). This property will be populated only if you have UTM tracking parameters added to your meetings link
Field type	dimension
Data type	string.text.value

times_contacted

Field label	Times contacted
Description	The total number of times contacted via a sales email or phone
Field type	metric
Data type	int.number.value

sales_activities

Field label	Sales activities
Description	The total number of sales activities (notes, calls, emails, meetings, or tasks)
Field type	metric
Data type	int.number.value

deal_amount

Field label	Amount
Description	The total value of the sales
Field type	metric
Data type	float.currency.value

deal_amount_closed_won

Field label	Amount won
Description	The total value of the won deals
Field type	metric
Data type	float.currency.value

deal_amount_closed_lost

Field label	Amount lost
Description	The total value of the lost deals
Field type	metric
Data type	float.currency.value

deal_total_count

Field label	Deals
Description	Number of deals
Field type	metric
Data type	int.number.value

average_deal_size

Field label	Average deal size
Description	Average value of a deal
Field type	metric
Data type	float.currency.value

deal_appointment_count

Field label	"Appointment scheduled" deals
Description	The total count of deals in "Appointment Scheduled" stage
Field type	metric
Data type	int.number.value

deal_qualified_to_buy_count

Field label	"Qualified to buy" deals
Description	The total count of deals in "Qualified To Buy" stage
Field type	metric
Data type	int.number.value

deal_presentation_count

Field label	"Presentation scheduled" deals
Description	The total count of deals in "Presentation Scheduled" stage
Field type	metric
Data type	int.number.value

deal_decision_maker_in_count

Field label	"Decision maker bought-in" deals
Description	The total count of deals with "Decision Maker Bought-In" stage
Field type	metric
Data type	int.number.value

deal_contact_sent_count

Field label	"Contact sent" deals
Description	The total count of deals in "Contact Sent" stage
Field type	metric
Data type	int.number.value

deal_closed_count

Field label	Closed deals
Description	The total count of closed deals
Field type	metric
Data type	int.number.value

deal_closed_won

Field label	Closed won deals
Description	The total count of won deals
Field type	metric
Data type	int.number.value

deal_closed_lost

Field label	Closed lost deals
Description	The total count of lost deals
Field type	metric
Data type	int.number.value

deal_hit_rate

Field label	Win rate (%)
Description	The deal win rate
Field type	metric
Data type	float.number.percentage

deal_avg_time_to_close_closed_won

Field label	Average days to close on won deals
Field type	metric
Data type	float.number.value

deal_recurring_revenue_amount

Field label	Recurring revenue amount
Description	Deal recurring revenue amount
Field type	metric
Data type	float.currency.value

SOCIAL PUBLISHING CHANNELS

spc_channel_id

Field label	Channel ID
Field type	dimension
Data type	string.text.value

spc_channel_guid

Field label	Channel GUID
Field type	dimension
Data type	string.text.value

spc_account_guid

Field label	Account GUID
Field type	dimension
Data type	string.text.value

spc_channel_key

Field label	Channel key
Field type	dimension
Data type	string.text.value

spc_account_type

Field label	Account type
Description	Type of account. For example Facebook for Instagram
Field type	dimension
Data type	string.text.value

spc_channel_type

Field label	Channel type
Description	Type of the channel. For example Instagram
Field type	dimension
Data type	string.text.value

spc_display_name

Field label	Display name
Description	Display name of the channel
Field type	dimension
Data type	string.text.value

spc_username

Field label	Username
Description	Username for the connected account
Field type	dimension
Data type	string.text.value

spc_profile_url

Field label	Profile URL
Description	Link to the channel
Field type	dimension
Data type	string.text.url

spc_avatar_url

Field label	Avatar URL
Description	Link to the avatar image related to the channel
Field type	dimension
Data type	string.text.url

spc_created

Field label	Created
Description	When the channel was added to HubSpot
Field type	dimension
Data type	string.time.date

spc_updated

Field label	Updated
Description	When the channel was updated
Field type	dimension
Data type	string.time.date

spc_active

Field label	Active
Description	Is the channel active
Field type	dimension
Data type	bool

spc_shared

Field label	Shared
Description	Is the channel shared
Field type	dimension
Data type	bool

STATUS CHANGE

status_change_source

Field label	Status change source
Field type	dimension
Data type	string.text.value

status_change_requested_by

Field label	Status change requested by
Field type	dimension
Data type	string.text.email

status_change_recipient

Field label	Status change recipient
Field type	dimension
Data type	string.text.email

portal_subscription_status

Field label	Portal subscription status
Field type	dimension
Data type	string.text.value

subscriptions

Field label	Subscriptions
Field type	dimension
Data type	string.text.json

TICKET

ticket_id

Field label	Ticket ID
Description	The unique ID for this ticket
Field type	dimension
Data type	string.text.value

ticket_name

Field label	Ticket name
Description	Short summary of ticket
Field type	dimension
Data type	string.text.value

ticket_description

Field label	Ticket description
Description	Description of the ticket
Field type	dimension
Data type	string.text.value

ticket_owner

Field label	Ticket owner
Description	The owner of the ticket
Field type	dimension
Data type	string.text.value

ticket_status

Field label	Ticket status
Description	The pipeline stage that contains this ticket
Field type	dimension
Data type	string.text.value

ticket_category

Field label	Ticket category
Description	Main reason customer reached out for help
Field type	dimension
Data type	string.text.value

ticket_closed_date

Field label	Ticket close date
Description	The date the ticket was closed
Field type	dimension
Data type	string.time.date

ticket_create_date

Field label	Ticket create date
Description	The date the ticket was created
Field type	dimension
Data type	string.time.date

ticket_hubspot_team

Field label	Ticket owner's team ID
Description	ID of the Primary team of the ticket owner for the ticket
Field type	dimension
Data type	string.text.value

ticket_owner_team_name

Field label	Ticket owner's team name
Description	Name of the Primary team assigned to the ticket owner for the ticket
Field type	dimension
Data type	string.text.value

ticket_last_activity_date

Field label	Ticket last activity date
Description	The last time a note, call, email, meeting, or task was logged for a ticket
Field type	dimension
Data type	string.time.date

ticket_last_contacted_date

Field label	Ticket last contacted date
Description	The last time a call, conversation, email, or meeting was logged for this ticket
Field type	dimension
Data type	string.time.date

ticket_last_customer_reply_date

Field label	Ticket last customer reply date
Description	The date of the last customer response
Field type	dimension
Data type	string.time.date

ticket_last_modified_date

Field label	Ticket last modified date
Description	The last time any property on the ticket was modified
Field type	dimension
Data type	string.time.date

ticket_next_activity_date

Field label	Ticket next activity date
Description	The date of the next upcoming activity for a ticket
Field type	dimension
Data type	string.time.date

ticket_owner_assigned_date

Field label	Ticket owner assigned date
Description	The date an owner was assigned to the ticket
Field type	dimension
Data type	string.time.date

ticket_pipeline

Field label	Ticket pipeline
Description	The pipeline that contains this ticket
Field type	dimension
Data type	string.text.value

ticket_priority

Field label	Ticket priority
Description	The level of attention needed on the ticket
Field type	dimension
Data type	string.text.value

ticket_source

Field label	Ticket source
Description	Channel where ticket was originally submitted
Field type	dimension
Data type	string.text.value

ticket_first_agent_reply_date

Field label	Ticket first email response date
Description	The date of the first email response from an agent after a ticket was created
Field type	dimension
Data type	string.time.date

ticket_total_count

Field label	Tickets
Description	Number of tickets
Field type	metric
Data type	int.number.value

ticket_time_to_close

Field label	Ticket time to close (average in minutes)
Description	On average the time between when the ticket was created and closed
Field type	metric
Data type	int.number.value

ticket_time_to_first_agent_reply

Field label	Ticket time to first reply (average in minutes)
Description	On average the time from the ticket creation date to the first agent email reply
Field type	metric
Data type	int.number.value

ticket_number_of_times_contacted

Field label	Ticket number of times contacted (average)
Description	The average number of times a call, email, or meeting was logged on the ticket
Field type	metric
Data type	int.number.value

TIME

today

Field label	Today
Description	Today's date, e.g. 2017-01-31
Field type	dimension
Data type	string.time.date
Destinations	API, Data warehouse

year

Field label	Year
Field type	dimension
Data type	string.time.year

yearOfWeek

Field label	Year of week (Sun-Sat)
Field type	dimension
Data type	string.time.year

yearOfWeekIso

Field label	Year of week (Mon-Sun)
Field type	dimension
Data type	string.time.year

yearMonth

Field label	Year & month
Field type	dimension
Data type	string.time.yearmonth

month

Field label	Month
Field type	dimension
Data type	string.time.month

yearWeek

Field label	Year & week (Sun-Sat)
Field type	dimension
Data type	string.time.yearweek

yearWeekIso

Field label	Year & week (Mon-Sun)
Field type	dimension
Data type	string.time.yearweekiso

week

Field label	Week (Sun-Sat)
Field type	dimension
Data type	string.time.week

weekIso

Field label	Week (Mon-Sun)
Field type	dimension
Data type	string.time.weekiso

dayOfMonth

Field label	Day of month
Field type	dimension
Data type	string.time.dayofmonth

dayOfWeekName

Field label	Day of week (Sun-Sat)
Field type	dimension
Data type	string.time.dayofweek

dayOfWeekNameIso

Field label	Day of week (Mon-Sun)
Field type	dimension
Data type	string.time.dayofweekiso

date

Field label	Date
Field type	dimension
Data type	string.time.date

WORKFLOW

workflow_id

Field label	Workflow ID
Description	The ID of the workflow
Field type	dimension
Data type	string.text.value

workflow_name

Field label	Workflow name
Description	Name of the workflow
Field type	dimension
Data type	string.text.value

workflow_description

Field label	Workflow description
Description	Description of the workflow
Field type	dimension
Data type	string.text.value

workflow_type

Field label	Workflow type
Description	The type of the workflow
Field type	dimension
Data type	string.text.value

workflow_enabled

Field label	Is workflow enabled
Description	Whether the workflow is enabled or not
Field type	dimension
Data type	bool

workflow_listening

Field label	Is workflow listening
Description	Whether the workflow is listening or not
Field type	dimension
Data type	bool

workflow_is_segment_based

Field label	Is workflow segment based
Description	Whether the workflow is segment based or not
Field type	dimension
Data type	bool

workflow_inserted_at

Field label	Workflow create date
Description	Date when the workflow was created
Field type	dimension
Data type	string.time.datetime

workflow_updated_at

Field label	Workflow last update date
Description	Date when the workflow was last updated
Field type	dimension
Data type	string.time.datetime

workflow_allow_multi_trigger

Field label	Allow contact to trigger multiple times
Description	Whether the workflow allows a contact to trigger multiple times or not
Field type	dimension
Data type	bool

workflow_enroll_from_merge

Field label	Allow enrollment from merge
Description	Whether the workflow allows enrollment from merge or not
Field type	dimension
Data type	bool

workflow_start_list_done

Field label	Workflow starting list is done processing
Description	Whether the workflow starting list is done processing or not
Field type	dimension
Data type	bool

workflow_enrolled_count

Field label	Total workflow enrolled contacts
Description	The total number of contacts that enrolled the workflow
Field type	metric
Data type	int.number.value

workflow_active_count

Field label	Total workflow active contacts
Description	The total number of active contacts for the workflow
Field type	metric
Data type	int.number.value

workflow_completed_count

Field label	Total workflow completed contacts
Description	The total number of contacts that completed the workflow
Field type	metric
Data type	int.number.value

workflow_succeeded_count

Field label	Total workflow succeeded contacts
Description	The total number of contacts that reached the workflow goal
Field type	metric
Data type	int.number.value

workflow_starting_count

Field label	Total workflow starting contacts
Description	The total number of contacts that started the workflow
Field type	metric
Data type	int.number.value

workflow_conversion_rate

Field label	Total workflow conversion rate (%)
Description	Ratio for contacts that reached the workflow goal
Field type	metric
Data type	float.number.percentage

WORKFLOW PERFORMANCE

workflow_performance_enrolled

Field label	Contacts enrolled
Description	The number of workflow enrollment events
Field type	metric
Data type	int.number.value

workflow_performance_unenrolled

Field label	Contacts lost
Description	The number of workflow unenrollment events
Field type	metric
Data type	int.number.value

workflow_performance_completed

Field label	Contacts completed
Description	The number of workflow completion events
Field type	metric
Data type	int.number.value

workflow_performance_met_goal

Field label	Contacts met goals
Description	The number of workflow goals met events
Field type	metric
Data type	float.number.percentage

workflow_performance_conversion_rate

Field label	Ongoing conversion rate (%)
Description	Ratio for workflow enrolled to goals met events
Field type	metric
Data type	float.number.percentage