HubSpot Connector Reference

275 metrics782 dimensions

Fields Options

The HubSpot connector allows to retrieve HubSpot data from standard and custom objects.

Important: Custom fields and custom objects are not available on the list below. To make them available go to https://onboard.windsor.ai/app/hubspot and connect your HubSpot account.

http://connectors.windsor.ai/hubspot?fields=contact_firstname,contact_lastname,contact_email,contact_company,contact_phone,contact_lifecyclestage&api_key=[your API key]

The HubSpot connector exposes 1,057 fields (275 metrics, 782 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Available options

analytics_breakdowns Analytics Breakdowns

Breakdowns to include when requesting analytics data. Check https://legacydocs.hubspot.com/docs/methods/analytics/get-analytics-data-breakdowns (Breakdown by) for more details. Content-type breakdowns such as landing-pages attribute the view metrics to each individual page. Default: sources

Possible values (9)

sessionssourcesdefaultgeolocationutm-campaignsutm-contentsutm-mediumsutm-sourcesutm-termslanding-pages

base_association_entity Base Association Entity

Base association entity to merge other entities with. Other entities will be returned only if they are assotiated with main one. Date range selection (date_from/date_to/date_preset) is applied only to the base entity.

Possible values (6)

dealcontactcompanymeetingsticketscalls

HubSpot Fields

HubSpot Analytics fields

The Analytics report of the HubSpot connector includes 54 fields.

HubSpot Analytics fields (analytics_bouncerate to analytics_total_pageviewspersession)

ID	Type	Name	Description
analytics_bouncerate	PERCENT	Analytics Bounce Rate	The percentage of visitors who left the site after viewing only one page, representing the bounce rate of the site.
analytics_bounces	NUMERIC	Analytics Bounces	The total number of single-page visits where users left the site without any further interaction, contributing to the site's bounce rate.
analytics_breakdown	TEXT	Analytics Breakdown	The specific breakdown of data based on the defined type, providing a detailed view of segmented analytics.
analytics_breakdown_type	TEXT	Analytics Breakdown Type	Defines the category of breakdown, such as session types, traffic sources, or user demographics, used to segment analytics data.
analytics_contacts	NUMERIC	Analytics Contacts	The total number of contacts made through the website, such as form submissions, inquiries, or other touchpoints.
analytics_contactsperpageview	NUMERIC	Analytics Contacts Per Page View	The average number of contacts generated per page view, indicating how effective each page is at driving user engagement.
analytics_contacttocustomerrate	PERCENT	Analytics Contact To Customer Rate	The conversion rate that represents the percentage of contacts successfully converted into customers.
analytics_customers	NUMERIC	Analytics Customers	The total number of customers acquired during the specified time frame, representing successful conversions.
analytics_customersperpageview	NUMERIC	Analytics Customers Per Page View	The average number of customers acquired per page view, indicating the efficiency of individual pages in converting users.
analytics_date	DATE	Analytics Date	The date on which the analytics data was collected or recorded.
analytics_newvisitorsessionrate	PERCENT	Analytics New Visitor Session Rate	The percentage of new visitors who initiated a session, representing how well the site attracts new users.
analytics_opportunities	NUMERIC	Analytics Opportunities	The total number of sales or engagement opportunities identified based on user activity, indicating lead generation.
analytics_others	NUMERIC	Analytics Others	The total amount of traffic from other unspecified sources or categories.
analytics_pageviewsminusexits	NUMERIC	Analytics Page Views Minus Exits	The total number of page views that exclude visits where the user exited the site, reflecting user engagement beyond initial interaction.
analytics_pageviewspersession	NUMERIC	Analytics Page Views Per Session	The average number of page views generated during each session, representing user engagement per session.
analytics_rawviews	NUMERIC	Analytics Raw Views	The total number of raw page views recorded without applying filters or adjustments.
analytics_returningvisits	NUMERIC	Analytics Returning Visits	The total number of visits from users who have previously visited the site, reflecting returning user engagement.
analytics_sessiontocontactrate	PERCENT	Analytics Session To Contact Rate	The percentage of sessions that resulted in a user making contact, reflecting engagement levels from site visits.
analytics_standardviews	NUMERIC	Analytics Standard Views	The total number of standard views filtered based on specific predefined criteria or metrics.
analytics_subscribers	NUMERIC	Analytics Subscribers	The total number of users who subscribed to newsletters, updates, or services through the website.
analytics_time	NUMERIC	Analytics Time	The total time users spent on the website during a given period, reflecting overall user engagement and session duration.
analytics_timepersession	NUMERIC	Analytics Time Per Session	The average amount of time spent per session by users on the website, indicating session duration.
analytics_total_bouncerate	PERCENT	Analytics Total Bounce Rate	The percentage of visitors who leave the site after viewing only one page, representing site engagement issues.
analytics_total_bounces	NUMERIC	Analytics Total Bounces	The total number of single-page visits where the user left the site without engaging further.
analytics_total_contacts	NUMERIC	Analytics Total Contacts	The total number of contacts made through the website, including form submissions and other contact points.
analytics_total_contactsperpageview	NUMERIC	Analytics Total Contacts Per Page View	The average number of contacts generated per page view, reflecting the efficiency of page content in driving interactions.
analytics_total_contacttocustomerrate	PERCENT	Analytics Total Contact To Customer Rate	The conversion rate representing the percentage of contacts that were successfully turned into paying customers.
analytics_total_customers	NUMERIC	Analytics Total Customers	The total number of customers acquired through the website, reflecting successful conversions.
analytics_total_customersperpageview	NUMERIC	Analytics Total Customers Per Page View	The average number of customers acquired per page view, offering insight into the sales effectiveness of the website.
analytics_total_desktop	NUMERIC	Analytics Total Desktop	The total number of sessions initiated from desktop devices, indicating desktop traffic levels.
analytics_total_directtraffic	NUMERIC	Analytics Total Direct Traffic	The total number of visitors who accessed the website directly, without being referred by another source.
analytics_total_emailmarketing	NUMERIC	Analytics Total Email Marketing	The total number of visitors driven to the website through email marketing campaigns.
analytics_total_mobile	NUMERIC	Analytics Total Mobile	The total number of sessions originating from mobile devices, representing mobile traffic.
analytics_total_newvisitorsessionrate	PERCENT	Analytics Total New Visitor Session Rate	The percentage of new visitors who initiated a session, providing insights into the acquisition of new users.
analytics_total_opportunities	NUMERIC	Analytics Total Opportunities	The total number of sales or engagement opportunities generated from user activity, indicating lead generation.
analytics_total_organicsearch	NUMERIC	Analytics Total Organic Search	The total number of visitors who arrived at the website through organic search engine results.
analytics_total_othercampaigns	NUMERIC	Analytics Total Other Campaigns	The total number of visitors generated through other marketing campaigns outside of typical channels.
analytics_total_others	NUMERIC	Analytics Total Others	Total traffic from other unspecified or miscellaneous sources that don't fit into predefined categories.
analytics_total_pageviewsminusexits	NUMERIC	Analytics Total Page Views Minus Exits	The total number of page views that occurred without the user exiting the website, offering a view of sustained engagement.
analytics_total_pageviewspersession	NUMERIC	Analytics Total Page Views Per Session	The average number of page views generated during each user session, reflecting user activity.

HubSpot Analytics fields (analytics_total_paidsearch to analytics_visits)

ID	Type	Name	Description
analytics_total_paidsearch	NUMERIC	Analytics Total Paid Search	The total number of visitors generated through paid search engine advertising, such as Google Ads.
analytics_total_rawviews	NUMERIC	Analytics Total Raw Views	The total number of unfiltered raw page views, providing an overall count of page interactions.
analytics_total_referrals	NUMERIC	Analytics Total Referrals	The total amount of traffic referred from external websites or links.
analytics_total_returningvisits	NUMERIC	Analytics Total Returning Visits	The total number of return visits from users who have previously visited the website, indicating user retention.
analytics_total_sessiontocontactrate	PERCENT	Analytics Total Session To Contact Rate	The percentage of website sessions that resulted in a user making contact, indicating engagement levels.
analytics_total_socialmedia	NUMERIC	Analytics Total Social Media	The total volume of traffic coming from social media platforms, indicating the impact of social channels.
analytics_total_standardviews	NUMERIC	Analytics Total Standard Views	The total number of standard views, filtered based on criteria like page type or content category.
analytics_total_subscribers	NUMERIC	Analytics Total Subscribers	The total number of users who subscribed to newsletters or other services via the website.
analytics_total_time	NUMERIC	Analytics Total Time	The total time users spent on the website during a given period, reflecting overall user engagement.
analytics_total_timepersession	NUMERIC	Analytics Total Time Per Session	The average time spent per session by users on the website, offering insights into session duration and engagement.
analytics_total_visitors	NUMERIC	Analytics Total Visitors	The total number of unique visitors to the website, indicating the overall reach of the site.
analytics_total_visits	NUMERIC	Analytics Total Visits	The total number of visits to the website, including repeat visits from the same users.
analytics_visitors	NUMERIC	Analytics Visitors	The total number of unique visitors to the website, representing distinct individuals accessing the site.
analytics_visits	NUMERIC	Analytics Visits (Sessions)	The total number of visits to the website, including multiple visits from the same user.

HubSpot analyticsevents fields

The analyticsevents report of the HubSpot connector includes 4 fields.

ID	Type	Name	Description
analyticsevents_breakdown	TEXT	Analytics Events Event	The analytics event whose completions are reported (event id or name).
analyticsevents_breakdown_type	TEXT	Analytics Events Breakdown Type	The analytics report type producing this row, i.e. event-completions.
analyticsevents_completions	NUMERIC	Analytics Events Completions	The number of times the event was completed on the date.
analyticsevents_date	DATE	Analytics Events Date	The date on which the event completions were recorded.

HubSpot blogpost fields

The blogpost report of the HubSpot connector includes 61 fields.

HubSpot blogpost fields (blogpost_ab_status to blogpost_page_expiry_redirect_url)

ID	Type	Name	Description
blogpost_ab_status	TEXT	Blog Post AB Status	The A/B test status of the blog post.
blogpost_ab_test_id	TEXT	Blog Post AB Test ID	The ID of the A/B test associated with the blog post.
blogpost_archived_at	NUMERIC	Blog Post Archived At	The archived time of the blog post. This is a timestamp.
blogpost_archived_in_dashboard	BOOLEAN	Blog Post Archived In Dashboard	Whether the blog post is archived in the dashboard. This is a boolean field.
blogpost_attached_stylesheets	TEXT	Blog Post Attached Stylesheets	The attached stylesheets of the blog post. This is a list of stylesheets that are attached to the blog post.
blogpost_author_name	TEXT	Blog Post Author Name	The author name of the blog post.
blogpost_blog_author_id	TEXT	Blog Post Blog Author ID	The ID of the blog author associated with the blog post.
blogpost_campaign	TEXT	Blog Post Campaign	The campaign associated with the blog post.
blogpost_category_id	TEXT	Blog Post Category ID	The ID of the category associated with the blog post.
blogpost_content_group_id	TEXT	Blog Post Content Group ID	The ID of the content group associated with the blog post.
blogpost_content_type_category	TEXT	Blog Post Content Type Category	The content type category of the blog post.
blogpost_created	TIMESTAMP	Blog Post Created At	The creation time of the blog post.
blogpost_created_by_id	TEXT	Blog Post Created By ID	The user ID of the user that originally created the blog post.
blogpost_current_state	TEXT	Blog Post Current State	The current state of the blog post.
blogpost_currently_published	BOOLEAN	Blog Post Currently Published	Whether the blog post is currently published. This is a boolean field.
blogpost_domain	TEXT	Blog Post Domain	The domain of the blog post.
blogpost_dynamic_page_data_source_id	TEXT	Blog Post Dynamic Page Data Source ID	The ID of the dynamic page data source associated with the blog post.
blogpost_dynamic_page_data_source_type	NUMERIC	Blog Post Dynamic Page Data Source Type	The type of the dynamic page data source.
blogpost_dynamic_page_hub_db_table_id	TEXT	Blog Post Dynamic Page Hub DB Table ID	The ID of the HubDB table that the dynamic page is using.
blogpost_enable_domain_stylesheets	BOOLEAN	Blog Post Enable Domain Stylesheets	Whether the blog post has domain stylesheets enabled.This is a boolean field.
blogpost_enable_google_amp_output_override	BOOLEAN	Blog Post Enable Google AMP Output Override	Whether the blog post has Google AMP output override enabled.This is a boolean field.
blogpost_enable_layout_stylesheets	BOOLEAN	Blog Post Enable Layout Stylesheets	Whether the blog post has layout stylesheets enabled.This is a boolean field.
blogpost_featured_image	TEXT	Blog Post Featured Image	The featured image of the blog post.
blogpost_featured_image_alt_text	TEXT	Blog Post Featured Image Alt Text	The alt text of the featured image of the blog post.
blogpost_folder_id	TEXT	Blog Post Folder ID	The ID of the folder that the blog post is in.
blogpost_footer_html	TEXT	Blog Post Footer HTML	The footer HTML of the blog post.
blogpost_head_html	TEXT	Blog Post Head HTML	The head HTML of the blog post.
blogpost_html_title	TEXT	Blog Post HTML Title	The HTML title of the blog post.
blogpost_id	TEXT	Blog Post ID	The ID of the blog post.
blogpost_include_default_custom_css	BOOLEAN	Blog Post Include Default Custom CSS	Whether the blog post includes default custom CSS.This is a boolean field.
blogpost_language	TEXT	Blog Post Language	The language of the blog post.
blogpost_layout_sections	TEXT	Blog Post Layout Sections	The layout sections of the blog post. This is a dictionary.
blogpost_link_rel_canonical_url	TEXT	Blog Post Link Rel Canonical URL	The canonical URL of the blog post. This is a link rel canonical URL.
blogpost_mab_experiment_id	TEXT	Blog Post MAB Experiment ID	The ID of the MAB experiment associated with the blog post.
blogpost_meta_description	TEXT	Blog Post Meta Description	The meta description of the blog post.
blogpost_name	TEXT	Blog Post Name	The name of the blog post.
blogpost_page_expiry_date	NUMERIC	Blog Post Page Expiry Date	The date when the blog post will expire. This is a timestamp.
blogpost_page_expiry_enabled	BOOLEAN	Blog Post Page Expiry Enabled	Whether the blog post has page expiry enabled. This is a boolean field.
blogpost_page_expiry_redirect_id	NUMERIC	Blog Post Page Expiry Redirect ID	The ID of the page expiry redirect associated with the blog post.
blogpost_page_expiry_redirect_url	TEXT	Blog Post Page Expiry Redirect URL	The URL of the page expiry redirect associated with the blog post.

HubSpot blogpost fields (blogpost_password to blogpost_widgets)

ID	Type	Name	Description
blogpost_password	TEXT	Blog Post Password	The password of the blog post.
blogpost_post_body	TEXT	Blog Post Post Body	The post body of the blog post.
blogpost_post_summary	TEXT	Blog Post Post Summary	The post summary of the blog post.
blogpost_public_access_rules	TEXT	Blog Post Public Access Rules	The public access rules of the blog post. This is a list.
blogpost_public_access_rules_enabled	BOOLEAN	Blog Post Public Access Rules Enabled	Whether the blog post has public access rules enabled. This is a boolean field.
blogpost_publish_date	TIMESTAMP	Blog Post Published At	The publication time of the blog post.
blogpost_publish_immediately	BOOLEAN	Blog Post Publish Immediately	Whether the blog post is published immediately. This is a boolean field.
blogpost_rss_body	TEXT	Blog Post RSS Body	The RSS body of the blog post.
blogpost_rss_summary	TEXT	Blog Post RSS Summary	The RSS summary of the blog post.
blogpost_slug	TEXT	Blog Post Slug	The slug of the blog post.
blogpost_state	TEXT	Blog Post State	The publish state of the blog post. This includes PUBLISHED, DRAFT, and SCHEDULED.
blogpost_tag_ids	TEXT	Blog Post Tag IDs	The IDs of the tags associated with the blog post. This is a list of tag IDs.
blogpost_theme_settings_values	TEXT	Blog Post Theme Settings Values	The theme settings values of the blog post. This is a dictionary.
blogpost_translated_from_id	TEXT	Blog Post Translated From ID	The ID of the blog post that this blog post was translated from.
blogpost_translations	TEXT	Blog Post Translations	The translations of the blog post. This is a dictionary.
blogpost_updated	TIMESTAMP	Blog Post Updated At	The last updated time of the blog post.
blogpost_updated_by_id	TEXT	Blog Post Updated By ID	The ID of the user that last updated the blog post.
blogpost_url	TEXT	Blog Post URL	The URL of the blog post.
blogpost_use_featured_image	BOOLEAN	Blog Post Use Featured Image	Whether the blog post uses the featured image. This is a boolean field.
blogpost_widget_containers	TEXT	Blog Post Widget Containers	The widget containers of the blog post. This is a dictionary.
blogpost_widgets	TEXT	Blog Post Widgets	The widgets of the blog post. This is a dictionary.

HubSpot calls fields

The calls report of the HubSpot connector includes 83 fields.

HubSpot calls fields (calls_count to calls_hs_call_transcript_audio_num_channels)

ID	Type	Name	Description
calls_count	NUMERIC	Calls count	Amount of Calls
calls_hs_activity_type	TEXT	Calls Call and meeting type	Calls Call and meeting type
calls_hs_all_accessible_team_ids	TEXT	Calls All teams	Calls All teams
calls_hs_all_assigned_business_unit_ids	TEXT	Calls Business units	Calls Business units
calls_hs_all_owner_ids	TEXT	Calls All owner IDs	Calls All owner IDs
calls_hs_all_team_ids	TEXT	Calls All team IDs	Calls All team IDs
calls_hs_at_mentioned_owner_ids	TEXT	Calls At-Mentioned Owner Ids	Calls At-Mentioned Owner Ids
calls_hs_attachment_ids	TEXT	Calls Attached file IDs	Calls Attached file IDs
calls_hs_body_preview	TEXT	Calls Call notes preview	Calls Call notes preview
calls_hs_body_preview_html	TEXT	Calls HTML Body Preview	Calls HTML Body Preview
calls_hs_body_preview_is_truncated	TEXT	Calls Body Preview Truncated	Calls Body Preview Truncated
calls_hs_call_app_id	TEXT	Calls Integrating App ID	Calls Integrating App ID
calls_hs_call_authed_url_provider	TEXT	Calls Authenticated recording files url provider	Calls Authenticated recording files url provider
calls_hs_call_body	TEXT	Calls Call notes	Calls Call notes
calls_hs_call_callee_object_id	TEXT	Calls Callee object ID	Calls Callee object ID
calls_hs_call_callee_object_type	TEXT	Calls Callee object type	Calls Callee object type
calls_hs_call_deal_stage_during_call	TEXT	Calls Deal Stage During Call	Calls Deal Stage During Call
calls_hs_call_direction	TEXT	Calls Call direction	Calls Call direction
calls_hs_call_disposition	TEXT	Calls Call outcome	Calls Call outcome
calls_hs_call_duration	NUMERIC	Calls Call duration	Calls Call duration
calls_hs_call_external_account_id	TEXT	Calls External Account ID	Calls External Account ID
calls_hs_call_external_id	TEXT	Calls External ID	Calls External ID
calls_hs_call_from_number	TEXT	Calls From number	Calls From number
calls_hs_call_from_number_nickname	TEXT	Calls From Number Name	Calls From Number Name
calls_hs_call_has_transcript	BOOLEAN	Calls Transcript Available	Calls Transcript Available
calls_hs_call_has_voicemail	BOOLEAN	Calls Voicemail Available	Calls Voicemail Available
calls_hs_call_meeting_id	TEXT	Calls Meeting ID	Calls Meeting ID
calls_hs_call_ms_teams_payload	TEXT	Calls MsTeams payload	Calls MsTeams payload
calls_hs_call_primary_deal	TEXT	Calls Primary Deal	Calls Primary Deal
calls_hs_call_recording_duration	NUMERIC	Calls Recording duration	Calls Recording duration
calls_hs_call_recording_url	TEXT	Calls Recording URL	Calls Recording URL
calls_hs_call_source	TEXT	Calls Call Source	Calls Call Source
calls_hs_call_status	TEXT	Calls Call status	Calls Call status
calls_hs_call_suggested_next_actions	TEXT	Calls Call suggested next actions	Calls Call suggested next actions
calls_hs_call_summary	TEXT	Calls Call summary	Calls Call summary
calls_hs_call_summary_execution_id	TEXT	Calls Call Summary Execution ID	Calls Call Summary Execution ID
calls_hs_call_title	TEXT	Calls Call Title	Calls Call Title
calls_hs_call_to_number	TEXT	Calls To Number	Calls To Number
calls_hs_call_to_number_nickname	TEXT	Calls To Number Name	Calls To Number Name
calls_hs_call_transcript_audio_num_channels	NUMERIC	Calls Call Transcript Audio Channel Count	Calls Call Transcript Audio Channel Count

HubSpot calls fields (calls_hs_call_transcript_tracked_terms to calls_hs_was_imported)

ID	Type	Name	Description
calls_hs_call_transcript_tracked_terms	TEXT	Calls Tracked terms	Calls Tracked terms
calls_hs_call_transcription_id	TEXT	Calls Call transcription ID	Calls Call transcription ID
calls_hs_call_video_meeting_type	TEXT	Calls Call video meeting type	Calls Call video meeting type
calls_hs_call_video_recording_url	TEXT	Calls Video url	Calls Video url
calls_hs_call_zoom_meeting_uuid	TEXT	Calls Unique Zoom Meeting ID	Calls Unique Zoom Meeting ID
calls_hs_calls_service_call_id	TEXT	Calls Service Call ID	Calls Service Call ID
calls_hs_connected_count	NUMERIC	Calls Connected count	Calls Connected count
calls_hs_created_by	TEXT	Calls Activity created by	Calls Activity created by
calls_hs_created_by_user_id	TEXT	Calls Created by user ID	Calls Created by user ID
calls_hs_createdate	DATE	Calls Create date	Calls Create date
calls_hs_engagement_source	TEXT	Calls Engagement Source	Calls Engagement Source
calls_hs_engagement_source_id	TEXT	Calls Engagement Source ID	Calls Engagement Source ID
calls_hs_follow_up_action	TEXT	Calls Follow up action	Calls Follow up action
calls_hs_gdpr_deleted	BOOLEAN	Calls GDPR deleted	Calls GDPR deleted
calls_hs_lastmodifieddate	DATE	Calls Last modified date	Calls Last modified date
calls_hs_merged_object_ids	TEXT	Calls Merged record IDs	Calls Merged record IDs
calls_hs_modified_by	NUMERIC	Calls Updated by	Calls Updated by
calls_hs_object_id	TEXT	Calls Record ID	Calls Record ID
calls_hs_object_source	TEXT	Calls Record Creation Source	Calls Record Creation Source
calls_hs_object_source_detail_1	TEXT	Calls Record Source Detail 1	Calls Record Source Detail 1
calls_hs_object_source_detail_2	TEXT	Calls Record Source Detail 2	Calls Record Source Detail 2
calls_hs_object_source_detail_3	TEXT	Calls Record Source Detail 3	Calls Record Source Detail 3
calls_hs_object_source_id	TEXT	Calls Record Creation Source ID	Calls Record Creation Source ID
calls_hs_object_source_label	TEXT	Calls Record Source	Calls Record Source
calls_hs_object_source_user_id	NUMERIC	Calls Record Creation Source User ID	Calls Record Creation Source User ID
calls_hs_product_name	TEXT	Calls Product name	Calls Product name
calls_hs_queue_membership_ids	TEXT	Calls Queue Memberships	Calls Queue Memberships
calls_hs_read_only	TEXT	Calls Read Only Object	Calls Read Only Object
calls_hs_shared_team_ids	TEXT	Calls Shared Team IDs	Calls Shared Team IDs
calls_hs_shared_user_ids	TEXT	Calls Shared User IDs	Calls Shared User IDs
calls_hs_timestamp	TIMESTAMP	Calls Activity date	Calls Activity date
calls_hs_unique_creation_key	TEXT	Calls Unique creation key	Calls Unique creation key
calls_hs_unique_id	TEXT	Calls Unique ID	Calls Unique ID
calls_hs_unknown_visitor_conversation	TEXT	Calls Unknown Visitor Conversation	Calls Unknown Visitor Conversation
calls_hs_updated_by_user_id	NUMERIC	Calls Updated by user ID	Calls Updated by user ID
calls_hs_user_ids_of_all_notification_followers	TEXT	Calls User IDs of all notification followers	Calls User IDs of all notification followers
calls_hs_user_ids_of_all_notification_unfollowers	TEXT	Calls User IDs of all notification unfollowers	Calls User IDs of all notification unfollowers
calls_hs_user_ids_of_all_owners	TEXT	Calls User IDs of all owners	Calls User IDs of all owners
calls_hs_voicemail_count	NUMERIC	Calls Voicemail count	Calls Voicemail count
calls_hs_was_imported	TEXT	Calls Performed in an import	Calls Performed in an import

HubSpot calls fields (calls_hubspot_owner_assigneddate to calls_hubspot_team_id)

ID	Type	Name	Description
calls_hubspot_owner_assigneddate	DATE	Calls Owner Assigned Date	Calls Owner Assigned Date
calls_hubspot_owner_id	TEXT	Calls Activity assigned to	Calls Activity assigned to
calls_hubspot_team_id	TEXT	Calls HubSpot Team ID	Calls HubSpot Team ID

HubSpot Campaign fields

The Campaign report of the HubSpot connector includes 26 fields.

ID	Type	Name	Description
campaign_audience	TEXT	Campaign Audience	The campaign's audience.
campaign_budget	NUMERIC	Campaign Budget	The sum of all budget items.
campaign_color_hex	TEXT	Campaign Color Hex	The color of the campaign in hex color code.
campaign_contacts	NUMERIC	Campaign Contacts	The number of contacts associated with the campaign.
campaign_created_at	TIMESTAMP	Campaign Created At	The creation time of the campaign.
campaign_created_by	TEXT	Campaign Created By	The user ID of the user that originally created the campaign.
campaign_currency_code	TEXT	Campaign Currency Code	The currency code used for the campaign.
campaign_deal_amount	NUMERIC	Campaign Deal Amount	The total deal amount associated with the campaign.
campaign_deals	NUMERIC	Campaign Deals	The number of deals associated with the campaign.
campaign_end_date	DATE	Campaign End Date	The campaign's end date.
campaign_goal	TEXT	Campaign Goal	The campaign's goal.
campaign_id	TEXT	Campaign ID	The ID of the campaign.
campaign_influenced_contacts	NUMERIC	Campaign Influenced Contacts	The number of contacts influenced by this campaign.
campaign_name	TEXT	Campaign Name	The campaign's name.
campaign_new_contacts_first_touch	NUMERIC	Campaign New Contacts First Touch	The number of new contacts generated where this campaign was the first touch point.
campaign_new_contacts_last_touch	NUMERIC	Campaign New Contacts Last Touch	The number of new contacts generated where this campaign was the last touch point.
campaign_notes	TEXT	Campaign Notes	Any notes about the campaign.
campaign_object_id	TEXT	Campaign Object ID	The internal CRM object id.
campaign_owner	TEXT	Campaign Owner	The user ID of the user that owns the campaign.
campaign_remaining_budget	NUMERIC	Campaign Remaining Budget	The remaining budget for the campaign.
campaign_revenue	NUMERIC	Campaign Revenue	The total revenue amount generated by the campaign.
campaign_sessions	NUMERIC	Campaign Sessions	The number of web sessions attributed to the campaign.
campaign_spend	NUMERIC	Campaign Spend	The sum of all spend items.
campaign_start_date	DATE	Campaign Start Date	The campaign's start date.
campaign_status	TEXT	Campaign Status	The status of the campaign. This includes planned, in_progress, active, paused, and completed.
campaign_updated_at	TIMESTAMP	Campaign Updated At	The last updated time of the campaign.

HubSpot campaignemails fields

The campaignemails report of the HubSpot connector includes 88 fields.

HubSpot campaignemails fields (campaignemails_active_domain to campaignemails_stats_counters_pending)

ID	Type	Name	Description
campaignemails_active_domain	TEXT	Campaign Emails Active domain	Campaign Emails Active domain
campaignemails_archived	BOOLEAN	Campaign Emails Archived	Campaign Emails Archived
campaignemails_business_unit_id	TEXT	Campaign Emails Business unit id	Campaign Emails Business unit id
campaignemails_campaign_id	TEXT	Campaign Emails Campaign ID	Campaign Emails Campaign ID
campaignemails_campaign_name	TEXT	Campaign Emails Campaign Name	Campaign Emails Campaign Name
campaignemails_campaign_utm	TEXT	Campaign Emails Campaign UTM	Campaign Emails Campaign UTM
campaignemails_cloned_from	TEXT	Campaign Emails Cloned From	Campaign Emails Cloned From
campaignemails_content_plain_text_version	TEXT	Campaign Emails Content Plain Text Version	Campaign Emails Content Plain Text Version
campaignemails_content_template_path	TEXT	Campaign Emails Content Template Path	Campaign Emails Content Template Path
campaignemails_count	NUMERIC	Campaign Emails count	Amount of Campaign Emails
campaignemails_created_at	TIMESTAMP	Campaign Emails Created at	Campaign Emails Created at
campaignemails_created_by_id	TEXT	Campaign Emails Created by id	Campaign Emails Created by id
campaignemails_deleted_at	TIMESTAMP	Campaign Emails Deleted at	Campaign Emails Deleted at
campaignemails_email_campaign_group_id	TEXT	Campaign Emails Email Campaign Group ID	Campaign Emails Email Campaign Group ID
campaignemails_feedback_survey_id	TEXT	Campaign Emails Feedback Survey ID	The ID of the feedback survey linked to the email.
campaignemails_folder_id	TEXT	Campaign Emails Folder ID	Campaign Emails Folder ID
campaignemails_from_custom_reply_to	TEXT	Campaign Emails From custom reply to	Campaign Emails From custom reply to
campaignemails_from_from_name	TEXT	Campaign Emails From from name	Campaign Emails From from name
campaignemails_from_reply_to	TEXT	Campaign Emails From reply to	Campaign Emails From reply to
campaignemails_id	TEXT	Campaign Emails Id	Campaign Emails Id
campaignemails_is_published	BOOLEAN	Campaign Emails Is published	Campaign Emails Is published
campaignemails_is_transactional	BOOLEAN	Campaign Emails Is transactional	Campaign Emails Is transactional
campaignemails_language	TEXT	Campaign Emails Language	Campaign Emails Language
campaignemails_name	TEXT	Campaign Emails Name	Campaign Emails Name
campaignemails_publish_date	TIMESTAMP	Campaign Emails Publish date	Campaign Emails Publish date
campaignemails_published_at	TIMESTAMP	Campaign Emails Published At	The date and time the email was published at.
campaignemails_published_by_email	TEXT	Campaign Emails Published by Email	Campaign Emails Published by Email
campaignemails_published_by_id	TEXT	Campaign Emails Published by id	Campaign Emails Published by id
campaignemails_published_by_name	TEXT	Campaign Emails Published by Name	Campaign Emails Published by Name
campaignemails_send_on_publish	BOOLEAN	Campaign Emails Send on publish	Campaign Emails Send on publish
campaignemails_state	TEXT	Campaign Emails State	Campaign Emails State
campaignemails_stats_counters_bounce	NUMERIC	Campaign Emails Stats counters bounce	Campaign Emails Stats counters bounce
campaignemails_stats_counters_click	NUMERIC	Campaign Emails Stats counters click	Campaign Emails Stats counters click
campaignemails_stats_counters_contactslost	NUMERIC	Campaign Emails Stats counters contactslost	Campaign Emails Stats counters contactslost
campaignemails_stats_counters_delivered	NUMERIC	Campaign Emails Stats counters delivered	Campaign Emails Stats counters delivered
campaignemails_stats_counters_dropped	NUMERIC	Campaign Emails Stats counters dropped	Campaign Emails Stats counters dropped
campaignemails_stats_counters_hardbounced	NUMERIC	Campaign Emails Stats counters hardbounced	Campaign Emails Stats counters hardbounced
campaignemails_stats_counters_notsent	NUMERIC	Campaign Emails Stats counters notsent	Campaign Emails Stats counters notsent
campaignemails_stats_counters_open	NUMERIC	Campaign Emails Stats counters open	Campaign Emails Stats counters open
campaignemails_stats_counters_pending	NUMERIC	Campaign Emails Stats counters pending	Campaign Emails Stats counters pending

HubSpot campaignemails fields (campaignemails_stats_counters_reply to campaignemails_webversion_expires_at)

HubSpot campaignemails fields (campaignemails_webversion_is_page_redirected to campaignemails_webversion_url)

ID	Type	Name	Description
campaignemails_webversion_is_page_redirected	BOOLEAN	Campaign Emails Webversion is page redirected	Campaign Emails Webversion is page redirected
campaignemails_webversion_meta_description	TEXT	Campaign Emails Webversion Meta Description	Campaign Emails Webversion Meta Description
campaignemails_webversion_page_expiry_enabled	BOOLEAN	Campaign Emails Webversion Page Expiry Enabled	Campaign Emails Webversion Page Expiry Enabled
campaignemails_webversion_redirect_to_page_id	TEXT	Campaign Emails Webversion Redirect to Page ID	Campaign Emails Webversion Redirect to Page ID
campaignemails_webversion_redirect_to_url	TEXT	Campaign Emails Webversion Redirect to URL	Campaign Emails Webversion Redirect to URL
campaignemails_webversion_slug	TEXT	Campaign Emails Webversion slug	Campaign Emails Webversion slug
campaignemails_webversion_title	TEXT	Campaign Emails Webversion Title	Campaign Emails Webversion Title
campaignemails_webversion_url	TEXT	Campaign Emails Webversion url	Campaign Emails Webversion url

HubSpot channelaccounts fields

The channelaccounts report of the HubSpot connector includes 4 fields.

ID	Type	Name	Description
channelaccounts_channel_id	TEXT	Channel Account Channel ID	The channel ID of the channel account.
channelaccounts_created_at	TIMESTAMP	Channel Account CreatedAt	The creation time of the channel account.
channelaccounts_id	TEXT	Channel Account ID	The ID of the channel account.
channelaccounts_name	TEXT	Channel Account Name	The name of the channel account.

HubSpot cmspages fields

The cmspages report of the HubSpot connector includes 15 fields.

ID	Type	Name	Description
cmspages_archived	BOOLEAN	CMS Page Archived	Whether the site page is archived.
cmspages_authorname	TEXT	CMS Page Author Name	The name of the page author.
cmspages_created	TIMESTAMP	CMS Page Created At	The date the site page was created.
cmspages_currentstate	TEXT	CMS Page Current State	The current publish status of the page.
cmspages_domain	TEXT	CMS Page Domain	The domain the site page is published on.
cmspages_htmltitle	TEXT	CMS Page Title	The public-facing page title used in the browser and for SEO.
cmspages_id	TEXT	CMS Page ID	The unique identifier of the site page.
cmspages_language	TEXT	CMS Page Language	The language of the site page.
cmspages_name	TEXT	CMS Page Internal Name	The internal name of the site page as shown in the HubSpot CMS UI (not visible to visitors).
cmspages_publishdate	TIMESTAMP	CMS Page Publish Date	The date the site page was (or is scheduled to be) published.
cmspages_slug	TEXT	CMS Page Slug	The path segment of the page URL.
cmspages_state	TEXT	CMS Page State	The publish state of the page, e.g. DRAFT or PUBLISHED.
cmspages_templatepath	TEXT	CMS Page Template Path	The path of the template used to render the page.
cmspages_updated	TIMESTAMP	CMS Page Updated At	The date the site page was last updated.
cmspages_url	TEXT	CMS Page URL	The full public URL of the site page.

HubSpot company fields

The company report of the HubSpot connector includes 88 fields.

HubSpot company fields (company_about_us to company_hs_last_logged_call_date)

ID	Type	Name	Description
company_about_us	TEXT	Company About Us	Short about-company
company_address	TEXT	Company Street Address	The street address of the company or organization, including unit number. Powered by HubSpot Insights.
company_address2	TEXT	Company Street Address 2	The additional address of the company or organization. Powered by HubSpot Insights.
company_annualrevenue	NUMERIC	Company Annual Revenue	The actual or estimated annual revenue of the company. Powered by HubSpot Insights.
company_city	CITY	Company City	The city where the company is located. Powered by HubSpot Insights.
company_closedate	TIMESTAMP	Company Close Date	The date the company or organization was closed as a customer
company_count	NUMERIC	Company count	Amount of companies
company_country	COUNTRY	Company Country/Region	The country/region in which the company or organization is located. Powered by HubSpot Insights.
company_createdate	TIMESTAMP	Company Create Date	The date the company or organization was added to the database
company_days_to_close	NUMERIC	Company Days to Close	The number of days between when the company record was created and when they closed as a customer.
company_description	TEXT	Company Description	A short statement about the company's mission and goals. Powered by HubSpot Insights.
company_domain	TEXT	Company Domain Name	The domain name of the company or organization
company_engagements_last_meeting_booked	TIMESTAMP	Company Date of last meeting booked in meetings tool	The date of the most recent meeting an associated contact has booked through the meetings tool.
company_engagements_last_meeting_booked_campaign	TEXT	Company Campaign of last booking in meetings tool	This UTM parameter shows which marketing campaign (e.g. a specific email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
company_engagements_last_meeting_booked_medium	TEXT	Company Medium of last booking in meetings tool	This UTM parameter shows which channel (e.g. email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
company_engagements_last_meeting_booked_source	TEXT	Company Source of last booking in meetings tool	This UTM parameter shows which site (e.g. Twitter) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
company_facebook_company_page	TEXT	Company Facebook Company Page	The URL of the Facebook company page for the company or organization
company_facebookfans	NUMERIC	Company Facebook Fans	Number of facebook fans
company_first_contact_createdate	TIMESTAMP	Company First Contact Create Date	The date that the first contact from this company entered the system, which could pre-date the company's create date
company_first_conversion_date	TIMESTAMP	Company First Conversion Date	The first conversion date across all contacts associated this company or organization
company_first_conversion_event_name	TEXT	Company First Conversion	The first form submitted across all contacts associated this company or organization
company_first_deal_created_date	TIMESTAMP	Company First Deal Created Date	The create date of the first deal associated with this company record.
company_founded_year	TEXT	Company Year Founded	The year the company was created. Powered by HubSpot Insights.
company_googleplus_page	TEXT	Company Google Plus Page	The URL of the Google Plus page for the company or organization
company_hs_analytics_first_timestamp	TIMESTAMP	Company Time First Seen	The first activity for any contact associated with this company or organization
company_hs_analytics_first_touch_converting_campaign	TEXT	Company First Touch Converting Campaign	The campaign responsible for the first touch creation of the first contact associated with this company
company_hs_analytics_first_visit_timestamp	TIMESTAMP	Company Time of First Session	Time of first session across all contacts associated with this company or organization
company_hs_analytics_last_timestamp	TIMESTAMP	Company Time Last Seen	Time last seen across all contacts associated with this company or organization
company_hs_analytics_last_touch_converting_campaign	TEXT	Company Last Touch Converting Campaign	The campaign responsible for the last touch creation of the first contact associated with this company
company_hs_analytics_last_visit_timestamp	TIMESTAMP	Company Time of Last Session	Time of the last session attributed to any contacts that are associated with this company record.
company_hs_analytics_num_page_views	NUMERIC	Company Number of Pageviews	Total number of page views across all contacts associated with this company or organization
company_hs_analytics_num_visits	NUMERIC	Company Number of Sessions	Total number of sessions across all contacts associated with this company or organization
company_hs_analytics_source	TEXT	Company Original Source Type	Original source for the contact with the earliest activity for this company or organization
company_hs_analytics_source_data_1	TEXT	Company Original Source Data 1	Additional information about the original source for the contact with the earliest activity for this company or organization
company_hs_analytics_source_data_2	TEXT	Company Original Source Data 2	Additional information about the original source for the contact with the earliest activity for this company or organization
company_hs_createdate	TIMESTAMP	Company object create date/time	The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
company_hs_ideal_customer_profile	TEXT	Company Ideal Customer Profile Tier	This property shows how well a Company matches your Ideal Customer Profile. Companies that are Tier 1 should be a great fit for your products/services where Tier 3 might be acceptable, but low priority
company_hs_is_target_account	BOOLEAN	Company Target Account	The Target Account property identifies the companies that you are marketing and selling to as part of your account-based strategy.
company_hs_last_booked_meeting_date	TIMESTAMP	Company Last Booked Meeting Date	The last date of booked meetings associated with the company
company_hs_last_logged_call_date	TIMESTAMP	Company Last Logged Call Date	The last date of logged calls associated with the company

HubSpot company fields (company_hs_last_open_task_date to company_total_money_raised)

ID	Type	Name	Description
company_hs_last_open_task_date	TIMESTAMP	Company Last Open Task Date	The last due date of open tasks associated with the company
company_hs_last_sales_activity_timestamp	TIMESTAMP	Company Last Engagement Date	The last time a contact engaged with your site or a form, document, meetings link, or tracked email. This doesn't include marketing emails or emails to multiple contacts.
company_hs_lastmodifieddate	TIMESTAMP	Company Last Modified Date	Most recent timestamp of any property update for this company. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
company_hs_lead_status	TEXT	Company Lead Status	The company's sales, prospecting or outreach status
company_hs_num_blockers	NUMERIC	Company Number of blockers	The number of contacts associated with this company with the role of blocker.
company_hs_num_child_companies	NUMERIC	Company Number of child companies	The number of child companies of this company
company_hs_num_contacts_with_buying_roles	NUMERIC	Company Number of contacts with a buying role	The number of contacts associated with this company with a buying role.
company_hs_num_decision_makers	NUMERIC	Company Number of decision makers	The number of contacts associated with this company with the role of decision maker.
company_hs_num_open_deals	NUMERIC	Company Number of open deals	The number of open deals associated with this company.
company_hs_object_id	TEXT	Company HubSpot ID	The unique ID for this company. This unique ID is automatically populated by HubSpot and cannot be changed.
company_hs_parent_company_id	NUMERIC	Parent Company	The parent company of this company
company_hs_predictivecontactscore_v2	NUMERIC	Company Likelihood to close	The highest probability that a contact associated with this company will become a customer within the next 90 days. This score is based on standard contact properties and behavior.
company_hs_total_deal_value	NUMERIC	Company Total open deal value	The total value, in your company's currency, of all open deals associated with this company
company_hubspot_owner_assigneddate	TIMESTAMP	Company Owner Assigned Date	The timestamp when an owner was assigned to this company
company_hubspot_owner_id	TEXT	Company owner	The owner of the company
company_hubspot_team_id	TEXT	Company HubSpot Team	The team of the owner of the company.
company_industry	TEXT	Company Industry	The type of business the company performs. By default, this property has approximately 150 pre-defined options to select from. While these options cannot be deleted as they used by HubSpot Insights, you can add new custom options to meet your needs.
company_is_public	BOOLEAN	Company Is Public	Indicates that the company is publicly traded. Powered by HubSpot Insights.
company_lifecyclestage	TEXT	Company Lifecycle Stage	The most advanced lifecycle stage across all contacts associated with this company or organization
company_linkedin_company_page	TEXT	LinkedIn Company Page	The URL of the LinkedIn company page for the company or organization
company_linkedinbio	TEXT	Company LinkedIn Bio	The LinkedIn bio for the company or organization
company_name	TEXT	Company Name (Duplicate)	The name of the company or organization. Powered by HubSpot Insights.
company_notes_last_contacted	TIMESTAMP	Company Last Contacted	The last timestamp when a call, email or meeting was logged for a contact at this company.
company_notes_last_updated	TIMESTAMP	Company Last Activity Date	The last time a note, call, meeting, or task was logged for a company. This is set automatically by HubSpot based on user actions in the company record.
company_notes_next_activity_date	TIMESTAMP	Company Next Activity Date	The date of the next upcoming scheduled sales activity for this company record.
company_num_associated_contacts	NUMERIC	Company Associated Contacts	The number of contacts associated with this company
company_num_associated_deals	NUMERIC	Company Associated Deals	The number of deals associated with this company
company_num_contacted_notes	NUMERIC	Company Number of times contacted	The number of times a call, email or meeting was logged for this company
company_num_conversion_events	NUMERIC	Company Number of Form Submissions	The number of forms submission for all contacts associated with this company or organization
company_numberofemployees	NUMERIC	Company Number of Employees	The total number of employees who work for the company or organization
company_owneremail	TEXT	Company HubSpot Owner Email	HubSpot owner email for this company or organization
company_ownername	TEXT	Company HubSpot Owner Name	HubSpot owner name for this company or organization
company_phone	TEXT	Company Phone Number	A company's primary phone number. Powered by HubSpot Insights.
company_recent_conversion_date	TIMESTAMP	Company Recent Conversion Date	The most recent conversion date across all contacts associated this company or organization
company_recent_conversion_event_name	TEXT	Company Recent Conversion	The last form submitted across all contacts associated this company or organization
company_recent_deal_amount	NUMERIC	Company Recent Deal Amount	The amount of the last deal closed
company_recent_deal_close_date	TIMESTAMP	Company Recent Deal Close Date	The date of the last `closed won` deal associated with this company record.
company_state	REGION	Company State/Region	The state or region in which the company or organization is located. Powered by HubSpot Insights.
company_timezone	TEXT	Company Time Zone	The time zone where the company or organization is located. Powered by HubSpot Insights.
company_total_money_raised	TEXT	Company Total Money Raised	The total amount of money raised by the company. Powered by HubSpot Insights.

HubSpot company fields (company_total_revenue to company_zip)

ID	Type	Name	Description
company_total_revenue	NUMERIC	Company Total Revenue	The total amount of closed won deals
company_twitterbio	TEXT	Company Twitter Bio	The Twitter bio of the company or organization
company_twitterfollowers	NUMERIC	Company Twitter Followers	The number of Twitter followers of the company or organization
company_twitterhandle	TEXT	Company Twitter Handle	The main twitter account of the company or organization
company_type	TEXT	Company Type	The optional classification of this company record - prospect, partner, etc.
company_web_technologies	TEXT	Company Web Technologies	The web technologies used by the company or organization. Powered by HubSpot Insights.
company_website	TEXT	Company Website URL	The main website of the company or organization. This property is used to identify unique companies. Powered by HubSpot Insights.
company_zip	TEXT	Company Postal Code	The postal or zip code of the company or organization. Powered by HubSpot Insights.

HubSpot contact fields

The contact report of the HubSpot connector includes 211 fields.

HubSpot contact fields (company to contact_hs_analytics_num_event_completions)

ID	Type	Name	Description
company	TEXT	Contact Company Name (Alias)	Alias for contact_company
contact_address	TEXT	Contact Street Address	A contact's street address, including apartment or unit #
contact_annualrevenue	TEXT	Contact Annual Revenue	Annual company revenue
contact_city	CITY	Contact City	A contact's city of residence
contact_closedate	TIMESTAMP	Contact Close Date	The date that a contact became a customer. This property is set automatically by HubSpot when a deal or opportunity is marked as closed-won. It can also be set manually or programmatically.
contact_company	TEXT	Contact Company Name	The name of the contact's company. This is separate from the Name property of the contact's associated company and can be set independently.
contact_company_size	TEXT	Contact Company size	A contact's company size. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
contact_count	NUMERIC	Contact count	Amount of contacts
contact_country	COUNTRY	Contact Country/Region	The contact's country/region of residence. This might be set via import, form, or integration.
contact_createdate	TIMESTAMP	Contact Create Date	The date that a contact entered the system
contact_currentlyinworkflow	TEXT	Contact Currently in workflow	If the contact is currently enrolled in any workflow
contact_date_of_birth	TEXT	Contact Date of birth	A contact's date of birth. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
contact_days_to_close	NUMERIC	Contact Days To Close	The days that elapsed from when a contact was created until they closed as a customer. This is set automatically by HubSpot and can be used for segmentation and reporting.
contact_degree	TEXT	Contact Degree	A contact's degree. This property is required for the Facebook Ads Integration. This property will be automatically synced to via Lead Ads tool
contact_email	TEXT	Contact Email	A contact's email address
contact_engagements_last_meeting_booked	TIMESTAMP	Contact date of last meeting booked in meetings tool	The date of the most recent meeting a contact has booked through the meetings tool.
contact_engagements_last_meeting_booked_campaign	TEXT	Contact Campaign of last booking in meetings tool	This UTM parameter shows which marketing campaign (e.g. a specific email) referred the contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
contact_engagements_last_meeting_booked_medium	TEXT	Contact Medium of last booking in meetings tool	This UTM parameter shows which channel (e.g. email) referred the contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
contact_engagements_last_meeting_booked_source	TEXT	Contact Source of last booking in meetings tool	This UTM parameter shows which site (e.g. Twitter) referred the contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
contact_fax	TEXT	Contact Fax Number	A contact's primary fax number
contact_field_of_study	TEXT	Contact Field of study	A contact's field of study. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
contact_first_conversion_date	TIMESTAMP	Contact First Conversion Date	The date this contact first submitted a form
contact_first_conversion_event_name	TEXT	Contact First Conversion	The first form this contact submitted
contact_first_deal_created_date	TIMESTAMP	Contact First Deal Created Date	The date the first deal for a contact was created. This is automatically set by HubSpot and can be used for segmentation and reporting.
contact_firstname	TEXT	Contact First Name	A contact's first name
contact_followercount	NUMERIC	Contact Follower Count	The number of Twitter followers a contact has
contact_gender	TEXT	Contact Gender	Contact Gender
contact_graduation_date	TEXT	Contact Graduation date	A contact's graduation date. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
contact_hs_analytics_average_page_views	NUMERIC	Contact Average Pageviews	The average number of pages a contact sees. This is automatically set by HubSpot for each contact.
contact_hs_analytics_first_referrer	TEXT	Contact First Referring Site	The first website that referred a contact to your website. This is automatically set by HubSpot for each contact.
contact_hs_analytics_first_timestamp	TIMESTAMP	Contact Time First Seen	The first time a contact has been seen. This is automatically set by HubSpot for each contact.
contact_hs_analytics_first_touch_converting_campaign	TEXT	Contact First Touch Converting Campaign	The campaign responsible for the first touch creation of this contact
contact_hs_analytics_first_url	TEXT	Contact First Page Seen	The first page a contact saw on your website. This is automatically set by HubSpot for each contact.
contact_hs_analytics_first_visit_timestamp	TIMESTAMP	Contact time of First Session	The first time a contact visited your website. This is automatically set by HubSpot for each contact.
contact_hs_analytics_last_referrer	TEXT	Contact Last Referring Site	The last website that referred a contact to your website. This is automatically set by HubSpot for each contact.
contact_hs_analytics_last_timestamp	TIMESTAMP	Contact Time Last Seen	The last time and date a contact has viewed a page on your website.
contact_hs_analytics_last_touch_converting_campaign	TEXT	Contact Last Touch Converting Campaign	The campaign responsible for the last touch creation of this contact
contact_hs_analytics_last_url	TEXT	Contact Last Page Seen	The last page a contact saw on your website. This is automatically set by HubSpot for each contact.
contact_hs_analytics_last_visit_timestamp	TIMESTAMP	Contact time of Last Session	The last time and date a contact visited your website.
contact_hs_analytics_num_event_completions	NUMERIC	Contact Number of event completions	The sum of all events a contact has experienced. This is automatically set by HubSpot for each contact.

HubSpot contact fields (contact_hs_analytics_num_page_views to contact_hs_feedback_last_nps_rating)

ID	Type	Name	Description
contact_hs_analytics_num_page_views	NUMERIC	Contact Number of Pageviews	The sum of all pages a contact has seen on your website. This is automatically set by HubSpot for each contact.
contact_hs_analytics_num_visits	NUMERIC	Contact Number of Sessions	The sum of all sessions a contact has made to your website. This is automatically set by HubSpot for each contact.
contact_hs_analytics_revenue	NUMERIC	Contact Event Revenue	Event revenue can be set on a contact though HubSpot's enterprise Events. http://help.hubspot.com/articles/KCS_Article/Reports/How-do-I-create-Events-in-HubSpot
contact_hs_analytics_source	TEXT	Contact Original Source	First known source the contact used to find your website. Set automatically, but may be updated manually.
contact_hs_analytics_source_data_1	TEXT	Contact Original Source Drill-Down 1	Additional information about the source through which a contact first found your website. This property is automatically set by HubSpot.
contact_hs_analytics_source_data_2	TEXT	Contact Original Source Drill-Down 2	Additional information about the source through which a contact first found your website. This property is automatically set by HubSpot.
contact_hs_buying_role	TEXT	Contact Buying Role	The role that a contact plays during the sales process. Contacts can have more than one role, and they can share the same role with another contact.
contact_hs_content_membership_email_confirmed	BOOLEAN	Contact Email Confirmed	Email Confirmation status of user of Content Membership
contact_hs_content_membership_notes	TEXT	Contact Membership Notes	The notes relating to the contact's content membership.
contact_hs_content_membership_registered_at	TIMESTAMP	Contact Registered At	Datetime at which this user was set up for Content Membership
contact_hs_content_membership_registration_domain_sent_to	TEXT	Contact Domain to which registration email was sent	Domain to which the registration invitation email for Content Membership was sent to
contact_hs_content_membership_registration_email_sent_at	TIMESTAMP	Contact Time registration email was sent	Datetime at which this user was sent a registration invitation email for Content Membership
contact_hs_content_membership_status	TEXT	Contact Status	The status of the contact's content membership.
contact_hs_createdate	TIMESTAMP	Contact Object create date/time	The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
contact_hs_email_bad_address	BOOLEAN	Contact Invalid email address	The email address associated with this contact is invalid.
contact_hs_email_bounce	NUMERIC	Contact Marketing emails bounced	The number of marketing emails that bounced for the current email address. This is automatically set by HubSpot.
contact_hs_email_click	NUMERIC	Contact Marketing emails clicked	The number of marketing emails which have had link clicks for the current email address. This is automatically set by HubSpot.
contact_hs_email_customer_quarantined_reason	TEXT	Contact Email address quarantine reason	The reason why the email address has been quarantined.
contact_hs_email_delivered	NUMERIC	Contact Marketing emails delivered	The number of marketing emails delivered for the current email address. This is automatically set by HubSpot.
contact_hs_email_domain	TEXT	Contact Email Domain	A contact's email address domain
contact_hs_email_first_click_date	TIMESTAMP	Contact First marketing email click date	The date of the earliest link click for any marketing email to the current email address. This is automatically set by HubSpot.
contact_hs_email_first_open_date	TIMESTAMP	Contact Concat first marketing email open date	The date of the earliest open for any marketing email to the current email address. This is automatically set by HubSpot.
contact_hs_email_first_reply_date	TIMESTAMP	Contact First marketing email reply date	The date of the earliest reply for any marketing email to the current email address. This is automatically set by HubSpot.
contact_hs_email_first_send_date	TIMESTAMP	Contact first marketing email send date	The date of the earliest delivery for any marketing email to the current email address. This is automatically set by HubSpot.
contact_hs_email_hard_bounce_reason_enum	TEXT	Contact Email hard bounce reason	The issue that caused a contact to hard bounce from your emails. If this is an error or a temporary issue, you can unbounce this contact from the contact record.
contact_hs_email_last_click_date	TIMESTAMP	Contact last marketing email click date	The date of the most recent link click for any marketing email to the current email address. This is automatically set by HubSpot.
contact_hs_email_last_email_name	TEXT	Contact Last marketing email name	The name of the last marketing email sent to the current email address. This is automatically set by HubSpot.
contact_hs_email_last_open_date	TIMESTAMP	Contact Last marketing email open date	The date of the most recent open for any marketing email to the current email address. This is automatically set by HubSpot.
contact_hs_email_last_reply_date	TIMESTAMP	Contact Last marketing email reply date	The date of the latest reply for any marketing email to the current email address. This is automatically set by HubSpot.
contact_hs_email_last_send_date	TIMESTAMP	Contact Contac last marketing email send date	The date of the most recent delivery for any marketing email to the current email address. This is automatically set by HubSpot.
contact_hs_email_open	NUMERIC	Contact Marketing emails opened	The number of marketing emails opened for the current email address. This is automatically set by HubSpot.
contact_hs_email_optout	BOOLEAN	Contact Unsubscribed from all email	Indicates that the current email address has opted out of all email.
contact_hs_email_quarantined	BOOLEAN	Contact Email Address Quarantined	Indicates that the current email address has been quarantined for anti-abuse reasons and any marketing email sends to it will be blocked. This is automatically set by HubSpot.
contact_hs_email_quarantined_reason	TEXT	Contact Email address automated quarantine reason	The automated reason why the email address has been quarantined.
contact_hs_email_replied	NUMERIC	Contact Marketing emails replied	The number of marketing emails replied to by the current email address. This is automatically set by HubSpot.
contact_hs_email_sends_since_last_engagement	NUMERIC	Contact Sends Since Last Engagement	The number of marketing emails that have been sent to the current email address since the last engagement (open or link click). This is automatically set by HubSpot.
contact_hs_emailconfirmationstatus	TEXT	Contact Marketing email confirmation status	The status of a contact's eligibility to receive marketing email. This is automatically set by HubSpot.
contact_hs_facebook_click_id	TEXT	Contact Facebook click id	Contact Facebook click id
contact_hs_feedback_last_nps_follow_up	TEXT	Contact Last NPS survey comment	Last NPS survey comment that this contact gave
contact_hs_feedback_last_nps_rating	TEXT	Contact Last NPS survey rating	Last NPS survey rating that this contact gave

HubSpot contact fields (contact_hs_feedback_last_survey_date to contact_hs_social_twitter_clicks)

ID	Type	Name	Description
contact_hs_feedback_last_survey_date	TIMESTAMP	Contact Last NPS survey date	The time that this contact last submitted a NPS survey response. This is automatically set by HubSpot.
contact_hs_google_click_id	TEXT	Contact Google ad click id	Contact Google ad click id
contact_hs_ip_timezone	TEXT	Contact IP Timezone	The timezone reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
contact_hs_is_unworked	BOOLEAN	Contact unworked	Contact has not been assigned or has not been engaged after last owner assignment/re-assignment
contact_hs_language	TEXT	Contact Preferred language	Set your contact's preferred language for communications. This property can be changed from an import, form, or integration.
contact_hs_last_sales_activity_timestamp	TIMESTAMP	Contact Last Engagement Date	The last time a contact engaged with your site or a form, document, meetings link, or tracked email. This doesn't include marketing emails or emails to multiple contacts.
contact_hs_latest_sequence_ended_date	TIMESTAMP	Contact Last sequence ended date	The last sequence ended date.
contact_hs_latest_sequence_enrolled	NUMERIC	Contact Last sequence enrolled	The last sequence enrolled.
contact_hs_latest_sequence_enrolled_date	TIMESTAMP	Contact Last sequence enrolled date	The last sequence enrolled date.
contact_hs_lead_status	TEXT	Contact Lead Status	The contact's sales, prospecting or outreach status
contact_hs_legal_basis	TEXT	Contact Legal basis for processing contact's data	Legal basis for processing contact's data; 'Not applicable' will exempt the contact from GDPR protections
contact_hs_lifecyclestage_customer_date	TIMESTAMP	Contact Became a Customer Date	The date when a contact's lifecycle stage changed to Customer. This is automatically set by HubSpot for each contact.
contact_hs_lifecyclestage_evangelist_date	TIMESTAMP	Contact Became an Evangelist Date	The date when a contact's lifecycle stage changed to Evangelist. This is automatically set by HubSpot for each contact.
contact_hs_lifecyclestage_lead_date	TIMESTAMP	Contact Became a Lead Date	The date when a contact's lifecycle stage changed to Lead. This is automatically set by HubSpot for each contact.
contact_hs_lifecyclestage_marketingqualifiedlead_date	TIMESTAMP	Contact Became a Marketing Qualified Lead Date	The date when a contact's lifecycle stage changed to MQL. This is automatically set by HubSpot for each contact.
contact_hs_lifecyclestage_opportunity_date	TIMESTAMP	Contact Became an Opportunity Date	The date when a contact's lifecycle stage changed to Opportunity. This is automatically set by HubSpot for each contact.
contact_hs_lifecyclestage_other_date	TIMESTAMP	Contact Became an Other Lifecycle Date	The date when a contact's lifecycle stage changed to Other. This is automatically set by HubSpot for each contact.
contact_hs_lifecyclestage_salesqualifiedlead_date	TIMESTAMP	Contact Became a Sales Qualified Lead Date	The date when a contact's lifecycle stage changed to SQL. This is automatically set by HubSpot for each contact.
contact_hs_lifecyclestage_subscriber_date	TIMESTAMP	Contact Became a Subscriber Date	The date when a contact's lifecycle stage changed to Subscriber. This is automatically set by HubSpot for each contact.
contact_hs_marketable_reason_id	TEXT	Contact Marketing contact status source name	The ID of the activity that set the contact as a marketing contact
contact_hs_marketable_reason_type	TEXT	Contact Marketing contact status source type	The type of the activity that set the contact as a marketing contact
contact_hs_marketable_status	TEXT	Contact Marketing contact status	The marketing status of a contact
contact_hs_marketable_until_renewal	TEXT	Contact Marketing contact until next update	Specifies if this contact will be set as non-marketing on renewal
contact_hs_object_id	TEXT	Contact ID (HubSpot)	The unique ID for this contact. This unique ID is automatically populated by HubSpot and cannot be changed.
contact_hs_persona	TEXT	Contact Persona	A contact's persona
contact_hs_predictivecontactscore	NUMERIC	Contact Predictive Lead Score	A score calculated by HubSpot that represents a contact's likelihood to become a customer
contact_hs_predictivecontactscore_v2	NUMERIC	Contact Likelihood to close	The probability that a contact will become a customer within the next 90 days. This score is based on standard contact properties and behavior.
contact_hs_predictivecontactscorebucket	TEXT	Contact Lead Rating	The rating of this contact based on their predictive lead score
contact_hs_predictivescoringtier	TEXT	Contact priority	A ranking system of contacts evenly assigned into four tiers. Contacts in tier one are more likely to become customers than contacts in tier four.
contact_hs_sales_email_last_clicked	TIMESTAMP	Contact Recent Sales Email Clicked Date	The last time a tracked sales email was clicked by this user
contact_hs_sales_email_last_opened	TIMESTAMP	Contact Recent Sales Email Opened Date	The last time a tracked sales email was opened by this contact. This property does not update for emails that were sent to more than one contact.
contact_hs_sales_email_last_replied	TIMESTAMP	Contact Recent Sales Email Replied Date	The last time a tracked sales email was replied to by this user. This is set automatically by HubSpot based on user actions in the contact record.
contact_hs_sequences_enrolled_count	NUMERIC	Contact Number of sequences enrolled	The number of sequences enrolled.
contact_hs_sequences_is_enrolled	BOOLEAN	Contact Currently in Sequence	A yes/no field that indicates whether the contact is currently in a Sequence.
contact_hs_social_facebook_clicks	NUMERIC	Contact Facebook Clicks	The number clicks on links shared on Facebook
contact_hs_social_google_plus_clicks	NUMERIC	Contact Google Plus Clicks	The number clicks on links shared on Google Plus
contact_hs_social_last_engagement	TIMESTAMP	Contact Most Recent Social Click	The date of the most recent click on a published social message. This is set automatically by HubSpot for each contact.
contact_hs_social_linkedin_clicks	NUMERIC	Contact LinkedIn Clicks	The number clicks on links shared on LinkedIn
contact_hs_social_num_broadcast_clicks	NUMERIC	Contact Broadcast Clicks	The number of clicks on published social messages. This is set automatically by HubSpot for each contact.
contact_hs_social_twitter_clicks	NUMERIC	Contact Twitter Clicks	The number of times a contact clicked on links you shared on Twitter through HubSpot. This is set automatically by HubSpot and can be used for segmentation.

HubSpot contact fields (contact_hs_time_between_contact_creation_and_deal_close to contact_ip_state)

ID	Type	Name	Description
contact_hs_time_between_contact_creation_and_deal_close	NUMERIC	Contact Time between contact creation and deal close	Contact Time between contact creation and deal close
contact_hs_time_between_contact_creation_and_deal_creation	NUMERIC	Contact Time between contact creation and deal creation	Contact Time between contact creation and deal creation
contact_hs_time_to_move_from_lead_to_customer	NUMERIC	Contact Time to move from lead to customer	How long it takes for a contact to move from the HubSpot lead stage to the HubSpot customer stage.
contact_hs_time_to_move_from_marketingqualifiedlead_to_customer	NUMERIC	Contact Time to move from marketing qualified lead to customer	How long it takes for a contact to move from the HubSpot marketing qualified lead stage to the HubSpot customer stage.
contact_hs_time_to_move_from_opportunity_to_customer	NUMERIC	Contact Time to move from opportunity to customer	How long it takes for a contact to move from the HubSpot opportunity stage to the HubSpot customer stage.
contact_hs_time_to_move_from_salesqualifiedlead_to_customer	NUMERIC	Contact Time to move from sales qualified lead to customer	How long it takes for a contact to move from the HubSpot sales qualified lead stage to the HubSpot customer stage.
contact_hs_time_to_move_from_subscriber_to_customer	NUMERIC	Contact Time to move from subscriber to customer	How long it takes for a contact to move from the HubSpot subscriber stage to the HubSpot customer stage.
contact_hs_v2_date_exited_customer	TIMESTAMP	Contact Exited Customer Date	The date when a contact's lifecycle stage changed from Customer. This is automatically set by HubSpot for each contact.
contact_hs_v2_date_exited_evangelist	TIMESTAMP	Contact Exited Evangelist Date	The date when a contact's lifecycle stage changed from Evangelist. This is automatically set by HubSpot for each contact.
contact_hs_v2_date_exited_lead	TIMESTAMP	Contact Exited Lead Date	The date when a contact's lifecycle stage changed from Lead. This is automatically set by HubSpot for each contact.
contact_hs_v2_date_exited_opportunity	TIMESTAMP	Contact Exited Opportunity Date	The date when a contact's lifecycle stage changed from Opportunity. This is automatically set by HubSpot for each contact.
contact_hs_v2_date_exited_other	TIMESTAMP	Contact Exited Other Date	The date when a contact's lifecycle stage changed from Other. This is automatically set by HubSpot for each contact.
contact_hs_v2_date_exited_salesqualifiedlead	TIMESTAMP	Contact Exited Sales Qualified Lead Date	The date when a contact's lifecycle stage changed from Sales Qualified Lead. This is automatically set by HubSpot for each contact.
contact_hs_v2_date_exited_subscriber	TIMESTAMP	Contact Exited Subscriber Date	The date when a contact's lifecycle stage changed from Subscriber. This is automatically set by HubSpot for each contact.
contact_hs_v2_date_exitedmarketingqualifiedlead	TIMESTAMP	Contact Exited Marketing Qualified Lead Date	The date when a contact's lifecycle stage changed from Marketing Qualified Lead. This is automatically set by HubSpot for each contact.
contact_hs_v2_latest_time_in_customer	NUMERIC	Contact Latest Time in Customer Stage	The latest time period (in milliseconds) when a contact was in Customer stage.
contact_hs_v2_latest_time_in_evangelist	NUMERIC	Contact Latest Time in Evangelist Stage	The latest time period (in milliseconds) when a contact was in Evangelist stage.
contact_hs_v2_latest_time_in_lead	NUMERIC	Contact Latest Time in Lead Stage	The latest time period (in milliseconds) when a contact was in Lead stage.
contact_hs_v2_latest_time_in_marketingqualifiedlead	NUMERIC	Contact Latest Time in Marketing Qualified Lead Stage	The latest time period (in milliseconds) when a contact was in Marketing Qualified Lead stage.
contact_hs_v2_latest_time_in_opportunity	NUMERIC	Contact Latest Time in Opportunity Stage	The latest time period (in milliseconds) when a contact was in Opportunity stage.
contact_hs_v2_latest_time_in_other	NUMERIC	Contact Latest Time in Other Stage	The latest time period (in milliseconds) when a contact was in Other stage.
contact_hs_v2_latest_time_in_salesqualifiedlead	NUMERIC	Contact Latest Time in Sales Qualified Lead Stage	The latest time period (in milliseconds) when a contact was in Opportunity stage.
contact_hs_v2_latest_time_in_subscriber	NUMERIC	Contact Latest Time in Subscriber Stage	The latest time period (in milliseconds) when a contact was in Subscriber stage.
contact_hs_v2_total_time_in_customer	NUMERIC	Contact Total Time in Customer Stage	The total time (in milliseconds) a contact was in Customer stage.
contact_hs_v2_total_time_in_evangelist	NUMERIC	Contact Total Time in Evangelist Stage	The total time (in milliseconds) a contact was in Evangelist stage.
contact_hs_v2_total_time_in_lead	NUMERIC	Contact Total Time in Lead Stage	The total time (in milliseconds) a contact was in Lead stage.
contact_hs_v2_total_time_in_marketingqualifiedlead	NUMERIC	Contact Total Time in Marketing Qualified Lead Stage	The total time (in milliseconds) a contact was in Marketing Qualified Lead stage.
contact_hs_v2_total_time_in_opportunity	NUMERIC	Contact Total Time in Opportunity Stage	The total time (in milliseconds) a contact was in Opportunity stage.
contact_hs_v2_total_time_in_other	NUMERIC	Contact Total Time in Other Stage	The total time (in milliseconds) a contact was in Other stage.
contact_hs_v2_total_time_in_salesqualifiedlead	NUMERIC	Contact Total Time in Sales Qualified Lead Stage	The total time (in milliseconds) a contact was in Sales Qualified Lead stage.
contact_hs_v2_total_time_in_subscriber	NUMERIC	Contact Total Time in Subscriber Stage	The total time (in milliseconds) a contact was in Subscriber stage.
contact_hubspot_owner_assigneddate	TIMESTAMP	Contact Owner Assigned Date	The most recent date a HubSpot Owner was assigned to a contact. This is set automatically by HubSpot and can be used for segmentation and reporting.
contact_hubspot_owner_id	TEXT	Contact owner	The owner of a contact. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows.
contact_hubspot_team_id	TEXT	Contact HubSpot Team	The team of the owner of a contact.
contact_hubspotscore	NUMERIC	Contact HubSpot Score	The number that shows qualification of contacts to sales readiness. It can be set in HubSpot's Lead Scoring app.
contact_industry	TEXT	Contact Industry	The industry a contact is in
contact_ip_city	CITY	Contact IP City	The city reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
contact_ip_country	COUNTRY	Contact IP Country	The country reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
contact_ip_country_code	COUNTRY	Contact IP Country Code	The country code reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
contact_ip_state	REGION	Contact IP State/Region	The state or region reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.

HubSpot contact fields (contact_ip_state_code to contact_twitterhandle)

ID	Type	Name	Description
contact_ip_state_code	TEXT	Contact IP State Code/Region Code	The state code or region code reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
contact_job_function	TEXT	Contact Job function	A contact's job function. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
contact_jobtitle	TEXT	Contact Job Title	A contact's job title
contact_kloutscoregeneral	NUMERIC	Contact Klout Score	A contact's Klout score, a measure of Internet influence
contact_lastmodifieddate	TIMESTAMP	Contact Last Modified Date	The date any property on this contact was modified
contact_lastname	TEXT	Contact Last Name	A contact's last name
contact_lifecyclestage	TEXT	Contact Lifecycle Stage	The qualification of contacts to sales readiness. It can be set through imports, forms, workflows, and manually on a per contact basis.
contact_linkedinbio	TEXT	Contact LinkedIn Bio	A contact's LinkedIn bio
contact_linkedinconnections	NUMERIC	Contact LinkedIn Connections	How many LinkedIn connections they have
contact_marital_status	TEXT	Contact Marital Status	A contact's marital status. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
contact_message	TEXT	Contact Message	A default property to be used for any message or comments a contact may want to leave on a form.
contact_military_status	TEXT	Contact Military status	A contact's military status. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
contact_mobilephone	TEXT	Contact Mobile Phone Number	A contact's mobile phone number
contact_notes_last_contacted	TIMESTAMP	Contact Last Contacted	The last time a call, email, or meeting was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
contact_notes_last_updated	TIMESTAMP	Contact Notes Last Activity Date	The last time a note, call, email, meeting, or task was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
contact_notes_next_activity_date	TIMESTAMP	Contact Next Activity Date	The date of the next upcoming activity for a contact. This is set automatically by HubSpot based on user actions in the contact record.
contact_num_associated_deals	NUMERIC	Contact Associated Deals	The number of deals associated with this contact. This is set automatically by HubSpot.
contact_num_contacted_notes	NUMERIC	Contact number of times contacted	The number of times a call, email, or meeting was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
contact_num_conversion_events	NUMERIC	Contact Number of Form Submissions	The number of forms this contact has submitted
contact_num_notes	NUMERIC	Contact Number of Sales Activities	The number of sales activities for a contact. This is set automatically by HubSpot based on user actions in the contact record.
contact_num_unique_conversion_events	NUMERIC	Contact Number of Unique Forms Submitted	The number of different forms this contact has submitted
contact_numemployees	TEXT	Contact Number of Employees	The number of company employees
contact_owneremail	TEXT	Contact HubSpot Owner Email (legacy)	A legacy property used to identify the email address of the owner of the contact. This property is no longer in use.
contact_ownername	TEXT	Contact HubSpot Owner Name (legacy)	A legacy property used to identify the name of the owner of the contact. This property is no longer in use.
contact_phone	TEXT	Contact Phone Number	A contact's primary phone number
contact_recent_conversion_date	TIMESTAMP	Contact Recent Conversion Date	The date this contact last submitted a form
contact_recent_conversion_event_name	TEXT	Contact Recent Conversion	The last form this contact submitted
contact_recent_deal_amount	NUMERIC	Contact Recent Deal Amount	The amount of the last closed won deal associated with a contact. This is set automatically by HubSpot based on information from the Deals object.
contact_recent_deal_close_date	TIMESTAMP	Contact Recent Deal Close Date	The date that the last deal associated with a contact was won. This is automatically set by HubSpot based on information from the Deals object.
contact_relationship_status	TEXT	Contact Relationship Status	A contact's relationship status. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
contact_sales_status	TEXT	Sales Status	Sales status
contact_salutation	TEXT	Contact Salutation	The title used to address a contact
contact_school	TEXT	Contact School	A contact's school. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
contact_seniority	TEXT	Contact Seniority	A contact's seniority. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
contact_source	TEXT	Contact Source	The contact source
contact_start_date	TEXT	Contact Start date	A contact's start date. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
contact_state	REGION	Contact State/Region	The contact's state of residence. This might be set via import, form, or integration.
contact_total_revenue	NUMERIC	Contact Total Revenue	The sum from all closed won deal revenue associated with a contact. This is automatically set by HubSpot and can be used for segmentation and reporting.
contact_twitterbio	TEXT	Contact Twitter Bio	The contact's Twitter bio. This is set by HubSpot using the contact's email address.
contact_twitterhandle	TEXT	Contact Twitter Username	The contact's Twitter handle. This is set by HubSpot using the contact's email address.

HubSpot contact fields (contact_twitterprofilephoto to phone)

ID	Type	Name	Description
contact_twitterprofilephoto	TEXT	Contact Twitter Profile Photo	The contact's Twitter profile photo. This is set by HubSpot using the contact's email address.
contact_type	TEXT	Contact Type	The contact type
contact_website	TEXT	Contact Website URL	The contact's company website
contact_work_email	TEXT	Contact Work email	A contact's work email. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool
contact_zip	TEXT	Contact Zip Code	The contact's zip code. This might be set via import, form, or integration.
createddate	TIMESTAMP	Created Date	Alias for contact_createdate
email	TEXT	Email	Alias for contact_email
firstname	TEXT	First Name	Alias for contact_firstname
lastname	TEXT	Last Name	Alias for contact_lastname
lifecyclestage	TEXT	Lifecycle Stage	Alias for contact_lifecyclestage
phone	TEXT	Phone Number	Alias for contact_phone

HubSpot custom_object fields

The custom_object report of the HubSpot connector includes 13 fields.

ID	Type	Name	Description
customobject_count	NUMERIC	Custom Object count	Amount of custom objects
customobject_createdat	TIMESTAMP	Custom Object Created at	The date the custom object was created.
customobject_description	TEXT	Custom Object Description	The custom object description.
customobject_display_order	TEXT	Custom Object Display Order	The custom object display order.
customobject_field_type	TEXT	Custom Object Field Type	The custom object field type
customobject_group_name	TEXT	Custom Object Group Name	The custom object group name.
customobject_hidden	BOOLEAN	Custom Object Hidden	The custom object is hiddnen or not.
customobject_id	TEXT	Custom Object ID	The custom object type ID.
customobject_label	TEXT	Custom Object Label	The custom object label.
customobject_name	TEXT	Custom object name	Most recent timestamp of any property update for this custom object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
customobject_property_name	TEXT	Custom object property name	Name of the custom object properties (fields).
customobject_type	TEXT	Custom Object Type	The custom object type.
customobject_updatedat	TIMESTAMP	Custom Object Updated At	Most recent timestamp of any property update for this custom object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.

HubSpot deal fields

The deal report of the HubSpot connector includes 56 fields.

HubSpot deal fields (deal_amount to deal_hs_next_step)

ID	Type	Name	Description
deal_amount	NUMERIC	Deal Amount	The total amount of the deal
deal_amount_in_home_currency	NUMERIC	Deal Amount in company currency	The amount of the deal, using the exchange rate, in your company's currency
deal_associated_company_id	TEXT	Deal Associated Company ID	The id of the primary company associated with the deal, resolved via the CRM associations API. Enables joining deals to companies.
deal_closed_lost_reason	TEXT	Deal Closed Lost Reason	Reason why this deal was lost
deal_closed_won_reason	TEXT	Deal Closed Won Reason	Reason why this deal was won
deal_closedate	TIMESTAMP	Deal Close Date	The expected close date of the deal
deal_count	NUMERIC	Deal count	Amount of deals
deal_createdate	TIMESTAMP	Deal Create Date	The date the deal was created. This property is set automatically by HubSpot.
deal_currency_code	TEXT	Deal Currency	Currency code for the deal.
deal_days_to_close	NUMERIC	Deal Days To Close	The number of days between deal creation and close.
deal_dealname	TEXT	Deal Name	The name given to this deal.
deal_dealstage	TEXT	Deal Stage	The stage of the deal. Deal stages allow you to categorize and track the progress of the deals that you are working on. The value of this field is inferred from deal's pipeline stage.
deal_dealtype	TEXT	Deal Type	The type of deal. By default, categorize your deal as either a New Business or Existing Business.
deal_description	TEXT	Deal Description	Description of the deal
deal_engagements_last_meeting_booked	TIMESTAMP	Deal Date of last meeting booked in meetings tool	The date of the most recent meeting an associated contact has booked through the meetings tool.
deal_engagements_last_meeting_booked_campaign	TEXT	Deal Campaign of last booking in meetings tool	This UTM parameter shows which marketing campaign (e.g. a specific email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
deal_engagements_last_meeting_booked_medium	TEXT	Deal Medium of last booking in meetings tool	This UTM parameter shows which channel (e.g. email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
deal_engagements_last_meeting_booked_source	TEXT	Deal Source of last booking in meetings tool	This UTM parameter shows which site (e.g. Twitter) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
deal_hs_acv	NUMERIC	Deal Annual contract value	The annual contract value (ACV) of this deal.
deal_hs_analytics_latest_source	TEXT	Deal Latest Analytics Source	The latest source through which the deal was created.
deal_hs_analytics_latest_source_data_1	TEXT	Deal Latest Analytics Source Data 1	Additional detail about the deal's latest analytics source.
deal_hs_analytics_latest_source_data_2	TEXT	Deal Latest Analytics Source Data 2	Additional detail about the deal's latest analytics source.
deal_hs_analytics_source	TEXT	Deal Original Source Type	Original source for the contact with the earliest activity for this deal.
deal_hs_analytics_source_data_1	TEXT	Deal Original Source Data 1	Additional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property.
deal_hs_analytics_source_data_2	TEXT	Deal Original Source Data 2	Additional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property.
deal_hs_arr	NUMERIC	Deal Annual recurring revenue	The annual recurring revenue (ARR) of this deal.
deal_hs_closed_amount	NUMERIC	Deal Closed Amount	The deal amount once the deal is closed.
deal_hs_closed_amount_in_home_currency	NUMERIC	Deal Closed Amount In Home Currency	The closed deal amount in the account's home currency.
deal_hs_created_by_user_id	TEXT	Deal Created By User ID	The id of the user who created the deal.
deal_hs_deal_amount_calculation_preference	TEXT	Deal Amount Calculation Preference	How the deal amount is calculated from associated line items.
deal_hs_deal_stage_probability	NUMERIC	Deal Stage Probability	The probability a deal will close, based on its current deal stage.
deal_hs_forecast_amount	NUMERIC	Deal Forecast Amount	The forecasted deal value calculated by multiplying the forecast probability and deal amount
deal_hs_forecast_probability	NUMERIC	Deal Forecast Probability	The percent probability the deal will close, expressed as a decimal.
deal_hs_is_closed	BOOLEAN	Deal Is Closed	Whether the deal is in a closed (won or lost) stage.
deal_hs_is_closed_won	BOOLEAN	Deal Is Closed Won	Whether the deal is in a closed won stage.
deal_hs_lastmodifieddate	TIMESTAMP	Deal Last Modified Date	Most recent timestamp of any property update for this deal. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
deal_hs_latest_meeting_activity	TIMESTAMP	Deal Latest Meeting Activity	The date of the most recent meeting logged on the deal.
deal_hs_manual_forecast_category	TEXT	Deal Forecast category	The likelihood a deal will close. This property is used for manual forecasting your deals.
deal_hs_mrr	NUMERIC	Deal Monthly recurring revenue	The monthly recurring revenue (MRR) of this deal.
deal_hs_next_step	TEXT	Deal Next step	A short description of the next step for the deal

HubSpot deal fields (deal_hs_object_id to deal_pipeline)

ID	Type	Name	Description
deal_hs_object_id	TEXT	Deal ID (HubSpot)	The unique ID for this deal. This unique ID is automatically populated by HubSpot and cannot be changed.
deal_hs_priority	TEXT	Deal Priority	Deal Priority
deal_hs_projected_amount	NUMERIC	Deal Projected Amount	The deal amount multiplied by the deal stage probability.
deal_hs_projected_amount_in_home_currency	NUMERIC	Deal Projected Amount In Home Currency	The projected deal amount in the account's home currency.
deal_hs_tcv	NUMERIC	Deal Total contract value	The total contract value (TCV) of this deal.
deal_hs_updated_by_user_id	TEXT	Deal Updated By User ID	The id of the user who last updated the deal.
deal_hubspot_owner_assigneddate	TIMESTAMP	Deal Owner Assigned Date	The date the most recent deal owner was assigned to a deal. This is updated automatically by HubSpot.
deal_hubspot_owner_id	TEXT	Deal Owner ID	The owner of the deal
deal_hubspot_team_id	TEXT	Deal HubSpot Team	The team of the owner of the deal.
deal_notes_last_contacted	TIMESTAMP	Deal Last Contacted	The last time a call, sales email, or meeting was logged for this deal. This is set automatically by HubSpot based on user actions.
deal_notes_last_updated	TIMESTAMP	Deal Last Activity Date	The last time a note, call, email, meeting, or task was logged for a deal. This is set automatically by HubSpot based on user actions in the deal record.
deal_notes_next_activity_date	TIMESTAMP	Deal Next Activity Date	The date of the next upcoming activity for a deal. This property is set automatically by HubSpot based on user action. This includes logging a future call, sales email, or meeting using the Log feature, as well as creating a future task or scheduling a future meeting. This is updated automatically by HubSpot.
deal_num_associated_contacts	NUMERIC	Deal Number of Contacts	The number of contacts associated with this deal. This property is set automatically by HubSpot.
deal_num_contacted_notes	NUMERIC	Deal Number of times contacted	The number of times a call, email or meeting was logged for this deal
deal_num_notes	NUMERIC	Deal Number of Sales Activities	The total number of sales activities (notes, calls, emails, meetings, or tasks) logged for a deal. This is updated automatically by HubSpot.
deal_pipeline	TEXT	Deal Pipeline	The pipeline the deal is in. This determines which stages are options for the deal.

HubSpot email fields

The email report of the HubSpot connector includes 24 fields.

ID	Type	Name	Description
email_bounced	NUMERIC	Email engagement bounced	The recipient's email server couldn't or wouldn't accept the message, and no further attempts will be made to deliver the message.
email_clicked	NUMERIC	Email engagement clicks	The recipient clicked on a link within the message.
email_clicked_on_link	NUMERIC	Email engagement click on identified link	The recipient click on identified link in the email.
email_count	NUMERIC	Email count	Amount of emails
email_deferred	NUMERIC	Email engagement deferred	The recipient's email server has temporarily rejected message, and subsequent attempts will be made to deliver the message.
email_delivered	NUMERIC	Email engagement delivered	The recipient's email server has accepted the message and the message has been successfully delivered to the recipient.
email_dropped	NUMERIC	Email engagement dropped	The message was rejected, either by HubSpot or by our delivery provider, and no attempt will be made to deliver the message.
email_errored	NUMERIC	Email engagement error	Email engagement error
email_event_created	TIMESTAMP	Email engagement timestamp	Email engagement timestamp
email_forwarded	NUMERIC	Email engagement forwarded	The recipient forwarded the email.
email_id	TEXT	Email ID	Email ID
email_mta_dropped	NUMERIC	Email engagement mta dropped	Email engagement mta dropped
email_opened	NUMERIC	Email engagement opened	The recipient opened the message.
email_optinchange	NUMERIC	Email engagement spam opt in change	Email engagement spam opt in change
email_processed	NUMERIC	Email engagement processed	The message has been received by our delivery provider, which has indicated it will attempt to deliver the message to the recipient's email server.
email_recipient	TEXT	Email recipient	Email recipient
email_replied	NUMERIC	Email engagement replied	The recipient replied to the email.
email_selected	NUMERIC	Email engagement selected	Email engagement selected
email_sent	NUMERIC	Email engagement sent	The message was sent to and received by our delivery provider.
email_spamreported	NUMERIC	Email engagement spam reported	The recipient flagged the message as spam.
email_statuschange	NUMERIC	Email engagement status changed	The recipient changed their email subscriptions in some way.
email_suppressed	NUMERIC	Email engagement suppressed	The message was not sent, the recipient has been unengaged with previous marketing emails.
email_unbounced	NUMERIC	Email engagement unbounced	This events occur when a particular email address is either automatically or manually unbounced by HubSpot. This resets the bounce status of the recipient, potentially allowing them to receive emails from your portal.
email_unsubscribed	NUMERIC	Email engagement unsubscribed	The recipient unsubscribed from subscription.

HubSpot emailstats fields

The emailstats report of the HubSpot connector includes 38 fields.

ID	Type	Name	Description
emailstats_aggregations_counters_bounce	NUMERIC	Emailstats Aggregations Counters Bounce	The number of times contacts were sent your email, but they didn't receive it because either their address is invalid, your email hit their spam filter, or your email was marked as spam by other people.
emailstats_aggregations_counters_click	NUMERIC	Emailstats Aggregations Counters Click	The number of unique recipients who clicked on any link in your email, excluding the Unsubscribe and Subscription Preferences links.
emailstats_aggregations_counters_contactslost	NUMERIC	Emailstats Aggregations Counters Contactslost	The sum of contacts that have unsubscribed, marked the email as spam, or have hardbounced.
emailstats_aggregations_counters_delivered	NUMERIC	Emailstats Aggregations Counters Delivered	The number of emails succesfully delivered to an inbox
emailstats_aggregations_counters_dropped	NUMERIC	Emailstats Aggregations Counters Dropped	The number of contacts that were not sent your email. This may be because they previously hard bounced, unsubscribed, marked you as spam, or because they have not engaged with any of your recent emails.
emailstats_aggregations_counters_hardbounced	NUMERIC	Emailstats Aggregations Counters Hardbounced	These contacts were sent your email, but they didn't receive it because either their address is invalid, your email hit their spam filter, or your email was marked as spam by other people.
emailstats_aggregations_counters_notsent	NUMERIC	Emailstats Aggregations Counters Notsent	These contacts were not sent your email. This may be because they previously hard bounced, unsubscribed, marked you as spam, or because they have not engaged with any of your recent emails.
emailstats_aggregations_counters_open	NUMERIC	Emailstats Aggregations Counters Open	The total number of unique opens
emailstats_aggregations_counters_pending	NUMERIC	Emailstats Aggregations Counters Pending	The number of emails still trying to reach a contact's inbox.
emailstats_aggregations_counters_reply	NUMERIC	Emailstats Aggregations Counters Reply	Emails Stats Counters Reply
emailstats_aggregations_counters_selected	NUMERIC	Emailstats Aggregations Counters Selected	The number of contacts selected to receive this email.
emailstats_aggregations_counters_sent	NUMERIC	Emailstats Aggregations Counters Sent	The total number of sent emails
emailstats_aggregations_counters_softbounced	NUMERIC	Emailstats Aggregations Counters Softbounced	Soft bounces occur when a contact's inbox has a temporary problem. You can still send to these people in the future. Contacts who hard bounce will be ineligible for later sends.
emailstats_aggregations_counters_spamreport	NUMERIC	Emailstats Aggregations Counters Spamreport	The number of contacts received your email and marked it as spam. They won't be sent to in the future.
emailstats_aggregations_counters_suppressed	NUMERIC	Emailstats Aggregations Counters Suppressed	The number of contacts that did not receive your email due to graymail suppression.
emailstats_aggregations_counters_unsubscribed	NUMERIC	Emailstats Aggregations Counters Unsubscribed	The number of contacts who received your email and unsubscribed. They won't be sent to in the future.
emailstats_aggregations_devicebreakdown_click_device_type_computer	NUMERIC	Emailstats Aggregations Devicebreakdown Click Device Type Computer	Click broken down by device type computer.
emailstats_aggregations_devicebreakdown_click_device_type_mobile	NUMERIC	Emailstats Aggregations Devicebreakdown Click Device Type Mobile	Click broken down by device type mobile.
emailstats_aggregations_devicebreakdown_click_device_type_unknown	NUMERIC	Emailstats Aggregations Devicebreakdown Click Device Type Unknown	Click broken down by device type unknown.
emailstats_aggregations_devicebreakdown_open_device_type_computer	NUMERIC	Emailstats Aggregations Devicebreakdown Open Device Type Computer	Open broken down by device type computer.
emailstats_aggregations_devicebreakdown_open_device_type_mobile	NUMERIC	Emailstats Aggregations Devicebreakdown Open Device Type Mobile	Open broken down by device type mobile.
emailstats_aggregations_devicebreakdown_open_device_type_unknown	NUMERIC	Emailstats Aggregations Devicebreakdown Open Device Type Unknown	Open broken down by device type unknown.
emailstats_aggregations_qualifierstats	NUMERIC	Emailstats Aggregations Qualifierstats	Emailstats Aggregations Qualifiers
emailstats_aggregations_ratios_bounceratio	PERCENT	Emailstats Aggregations Ratios Bounceratio	The number of contacts that bounced from the email over the total number of selected contacts.
emailstats_aggregations_ratios_clickratio	PERCENT	Emailstats Aggregations Ratios Clickratio	Click rate is the percentage of people who clicked a link in your email out of the people who were delivered your email.
emailstats_aggregations_ratios_clickthroughratio	PERCENT	Emailstats Aggregations Ratios Clickthroughratio	This is the percentage of people who clicked a link in your email out of the people who opened your email.
emailstats_aggregations_ratios_contactslostratio	PERCENT	Emailstats Aggregations Ratios Contactslostratio	The number of contacts that can no longer recive emails from the portal over the total number of selected contacts.
emailstats_aggregations_ratios_deliveredratio	PERCENT	Emailstats Aggregations Ratios Deliveredratio	The number of succesfull deliveries over the number of selected contacts.
emailstats_aggregations_ratios_hardbounceratio	PERCENT	Emailstats Aggregations Ratios Hardbounceratio	The number of contacts that hard bounced from the email over the total number of selected contacts.
emailstats_aggregations_ratios_notsentratio	NUMERIC	Emailstats Aggregations Ratios Notsentratio	The number of contacts that were not sent emails over the total number of selected contacts.
emailstats_aggregations_ratios_openratio	PERCENT	Emailstats Aggregations Ratios Openratio	Open rate is the percentage of people who opened your email out of the people who were delivered your email.
emailstats_aggregations_ratios_pendingratio	PERCENT	Emailstats Aggregations Ratios Pendingratio	The number of contacts that soft bounced from the email over the total number of selected contacts.
emailstats_aggregations_ratios_replyratio	PERCENT	Emailstats Aggregations Ratios Replyratio	Open rate is the percentage of people who replied to your email out of the people who were delivered your email.
emailstats_aggregations_ratios_softbounceratio	PERCENT	Emailstats Aggregations Ratios Softbounceratio	The number of contacts that soft bounced from the email over the total number of selected contacts.
emailstats_aggregations_ratios_spamreportratio	PERCENT	Emailstats Aggregations Ratios Spamreportratio	The number of contacts that mark the email as spam over the total number of selected contacts.
emailstats_aggregations_ratios_unsubscribedratio	PERCENT	Emailstats Aggregations Ratios Unsubscribedratio	the number of contacts that have unsubscribed over the total number of selected contacts
emailstats_interval_end	TIMESTAMP	Emailstats Interval End	End of the daily interval.
emailstats_interval_start	TIMESTAMP	Emailstats Interval Start	Start of the daily interval.

HubSpot Form Analytics fields

The Form Analytics report of the HubSpot connector includes 11 fields.

ID	Type	Name	Description
formanalytics_clickthroughperformview	PERCENT	Form Analytics Click Through Per Form View	Form Analytics Click Through Per Form View
formanalytics_contactsubmissions	NUMERIC	Form Analytics Contact Submissions	Form Analytics Contact Submissions
formanalytics_date	DATE	Form Analytics Date	Date of the Form Analytics
formanalytics_form_id	TEXT	Form Analytics Form ID	Form Analytics Form ID
formanalytics_formviews	NUMERIC	Form Analytics Form Views	Form Analytics Form Views
formanalytics_interactions	NUMERIC	Form Analytics Interactions	Form Analytics Interactions
formanalytics_noncontactsubmissions	NUMERIC	Form Analytics Non Contact Submissions	Form Analytics Non Contact Submissions
formanalytics_submissions	NUMERIC	Form Analytics Submissions	Form Analytics Submissions
formanalytics_submissionsperclickthrough	PERCENT	Form Analytics Submissions Per Click Through	Form Analytics Submissions Per Click Through
formanalytics_submissionsperformview	PERCENT	Form Analytics Submissions Per Form View	Form Analytics Submissions Per Form View
formanalytics_visibles	NUMERIC	Form Analytics Visibles	Form Analytics Visibles

HubSpot forms fields

The forms report of the HubSpot connector includes 22 fields.

ID	Type	Name	Description
forms_archived	BOOLEAN	Forms Archived	Whether this form is archived
forms_count	NUMERIC	Forms count	Amount of Forms
forms_createdat	TIMESTAMP	Forms Created Timestamp	When this form was created
forms_defaultvalue	TEXT	Forms Form Field Default Value	Default Value for this form field
forms_description	TEXT	Forms Form description	Form description
forms_field_name	TEXT	Forms Form Field Name	Forms Form Field Name
forms_fieldtype	TEXT	Forms Form Field Type	Forms Form Field Type
forms_formtype	TEXT	Forms Form Type	Forms Form Type
forms_grouptype	TEXT	Forms Form Group Type	Forms Form Group Type
forms_hidden	BOOLEAN	Forms hidden	Whether this form is hidden
forms_id	TEXT	Forms Form ID	ID of this form
forms_label	TEXT	Forms Form Field Label	Forms Form Field Label
forms_name	TEXT	Forms Form Name	Form Name
forms_objecttypeid	TEXT	Forms Form Object Type ID	Forms Form Object Type ID
forms_placeholder	TEXT	Forms Form Field Placeholder	Forms Form Field Placeholder
forms_required	BOOLEAN	Forms Form Field Required	Forms Form Field Required
forms_richtexttype	TEXT	Forms Form Rich Text Type	Forms Form Rich Text Type
forms_updatedat	TIMESTAMP	Forms Updated Timestamp	When this form was updated
forms_usecountrycodeselect	TEXT	Forms Form Use Country Code Select	Forms Form Use Country Code Select
forms_validation_maxalloweddigits	TEXT	Forms Forms Form Field Maximum Allowed Digits	Forms Form Field Maximum Allowed Digits
forms_validation_minalloweddigits	TEXT	Forms Forms Form Field Minimum Allowed Digits	Forms Forms Form Field Minimum Allowed Digits
forms_validation_usedefaultblocklist	BOOLEAN	Forms Form Validation Use Default Block List	Forms Form Validation Use Default Block List

HubSpot formsubmissions fields

The formsubmissions report of the HubSpot connector includes 5 fields.

ID	Type	Name	Description
formsubmissions_formguid	TEXT	Form Submissions Form GUID	GUID of the form that was submitted
formsubmissions_pagetitle	TEXT	Form Submissions Page Title	Title of the page where the form was submitted
formsubmissions_pageurl	TEXT	Form Submissions Page URL	URL of the page where the form was submitted
formsubmissions_submissionid	TEXT	Form Submissions Submission ID	Unique ID of the form submission
formsubmissions_submittedat	TIMESTAMP	Form Submissions Submitted At	Timestamp when the form was submitted

HubSpot landingpages fields

The landingpages report of the HubSpot connector includes 15 fields.

ID	Type	Name	Description
landingpages_archived	BOOLEAN	Landing Page Archived	Whether the landing page is archived.
landingpages_authorname	TEXT	Landing Page Author Name	The name of the page author.
landingpages_created	TIMESTAMP	Landing Page Created At	The date the landing page was created.
landingpages_currentstate	TEXT	Landing Page Current State	The current publish status of the page.
landingpages_domain	TEXT	Landing Page Domain	The domain the landing page is published on.
landingpages_htmltitle	TEXT	Landing Page Title (Duplicate)	The public-facing page title used in the browser and for SEO.
landingpages_id	TEXT	Landing Page ID	The unique identifier of the landing page.
landingpages_language	TEXT	Landing Page Language	The language of the landing page.
landingpages_name	TEXT	Landing Page Internal Name	The internal name of the landing page as shown in the HubSpot CMS UI (not visible to visitors).
landingpages_publishdate	TIMESTAMP	Landing Page Publish Date	The date the landing page was (or is scheduled to be) published.
landingpages_slug	TEXT	Landing Page Slug	The path segment of the page URL.
landingpages_state	TEXT	Landing Page State	The publish state of the page, e.g. DRAFT or PUBLISHED.
landingpages_templatepath	TEXT	Landing Page Template Path	The path of the template used to render the page.
landingpages_updated	TIMESTAMP	Landing Page Updated At	The date the landing page was last updated.
landingpages_url	TEXT	Landing Page URL (Duplicate)	The full public URL of the landing page.

HubSpot leads fields

The leads report of the HubSpot connector includes 9 fields.

ID	Type	Name	Description
leads_count	NUMERIC	Lead count	Amount of leads.
leads_createdate	TIMESTAMP	Lead Create Date	The date the lead was created.
leads_hs_lastmodifieddate	TIMESTAMP	Lead Last Modified Date (Duplicate)	The date the lead was last modified.
leads_hs_lead_label	TEXT	Lead Label	The label assigned to the lead.
leads_hs_lead_name	TEXT	Lead Name	The name of the lead.
leads_hs_lead_type	TEXT	Lead Type	The type of the lead.
leads_hs_object_id	TEXT	Lead ID (Duplicate)	The unique identifier of the lead.
leads_hs_pipeline	TEXT	Lead Pipeline	The pipeline the lead belongs to.
leads_hs_pipeline_stage	TEXT	Lead Pipeline Stage	The current stage of the lead within its pipeline.

HubSpot lists fields

The lists report of the HubSpot connector includes 10 fields.

ID	Type	Name	Description
lists_createdate	TIMESTAMP	List Created At	The date the list was created.
lists_id	TEXT	List ID (Duplicate)	The unique identifier (ILS list id) of the list.
lists_last_record_added_at	TIMESTAMP	List Last Record Added At	The date the most recent record was added to the list.
lists_last_record_removed_at	TIMESTAMP	List Last Record Removed At	The date the most recent record was removed from the list.
lists_name	TEXT	List Name	The name of the list.
lists_object_type_id	TEXT	List Object Type ID	The object type the list contains, e.g. 0-1 for contacts.
lists_processing_type	TEXT	List Processing Type	How the list is processed: MANUAL, SNAPSHOT or DYNAMIC.
lists_size	NUMERIC	List Size	The current number of records that are members of the list.
lists_size_week_delta	NUMERIC	List Size Week Delta	The net change in list membership over the past week.
lists_updatedate	TIMESTAMP	List Updated At	The date the list was last updated.

HubSpot marketingemail fields

The marketingemail report of the HubSpot connector includes 102 fields.

HubSpot marketingemail fields (marketingemail_ab to marketingemail_fromname)

ID	Type	Name	Description
marketingemail_ab	TEXT	(Deprecated) ab	(Deprecated) ab
marketingemail_abhourstowait	TEXT	(Deprecated) abHoursToWait	(Deprecated) abHoursToWait
marketingemail_absamplesizedefault	TEXT	(Deprecated) abSampleSizeDefault	(Deprecated) abSampleSizeDefault
marketingemail_absamplingdefault	TEXT	(Deprecated) abSamplingDefault	(Deprecated) abSamplingDefault
marketingemail_absoluteurl	TEXT	(Deprecated) absoluteUrl	(Deprecated) absoluteUrl
marketingemail_absuccessmetric	TEXT	(Deprecated) abSuccessMetric	(Deprecated) abSuccessMetric
marketingemail_abtestpercentage	TEXT	(Deprecated) abTestPercentage	(Deprecated) abTestPercentage
marketingemail_abvariation	TEXT	(Deprecated) abVariation	(Deprecated) abVariation
marketingemail_allemailcampaignids	TEXT	(Deprecated) allEmailCampaignIds	(Deprecated) allEmailCampaignIds
marketingemail_analyticspageid	TEXT	(Deprecated) analyticsPageId	(Deprecated) analyticsPageId
marketingemail_analyticspagetype	TEXT	(Deprecated) analyticsPageType	(Deprecated) analyticsPageType
marketingemail_archivedat	TEXT	(Deprecated) archivedAt	archivedAt
marketingemail_archivedindashboard	TEXT	archivedInDashboard	(Deprecated) archivedInDashboard
marketingemail_audienceaccess	TEXT	(Deprecated) audienceAccess	(Deprecated) audienceAccess
marketingemail_author	TEXT	(Deprecated) author	(Deprecated) author
marketingemail_authorname	TEXT	(Deprecated) authorName	(Deprecated) authorName
marketingemail_blogrsssettings	TEXT	(Deprecated) blogRssSettings	(Deprecated) blogRssSettings
marketingemail_canspamsettingsid	TEXT	(Deprecated) canSpamSettingsId	(Deprecated) canSpamSettingsId
marketingemail_categoryid	TEXT	(Deprecated) categoryId	(Deprecated) categoryId
marketingemail_contentaccessruleids	TEXT	(Deprecated) contentAccessRuleIds	(Deprecated) contentAccessRuleIds
marketingemail_contentaccessruletypes	TEXT	(Deprecated) contentAccessRuleTypes	(Deprecated) contentAccessRuleTypes
marketingemail_contenttypecategory	TEXT	(Deprecated) contentTypeCategory	(Deprecated) contentTypeCategory
marketingemail_count	NUMERIC	(Deprecated) Marketing Email count	(Deprecated) Amount of Marketing Emails
marketingemail_created	TIMESTAMP	(Deprecated) created	(Deprecated) created
marketingemail_createdbyid	TEXT	(Deprecated) createdById	(Deprecated) createdById
marketingemail_createpage	TEXT	(Deprecated) createPage	(Deprecated) createPage
marketingemail_currentlypublished	TEXT	(Deprecated) currentlyPublished	(Deprecated) currentlyPublished
marketingemail_currentstate	TEXT	(Deprecated) currentState	(Deprecated) currentState
marketingemail_customreplyto	TEXT	(Deprecated) customReplyTo	(Deprecated) customReplyTo
marketingemail_customreplytoenabled	TEXT	(Deprecated) customReplyToEnabled	(Deprecated) customReplyToEnabled
marketingemail_domain	TEXT	(Deprecated) domain	(Deprecated) domain
marketingemail_emailbody	TEXT	(Deprecated) emailBody	(Deprecated) emailBody
marketingemail_emailcampaigngroupid	TEXT	(Deprecated) emailCampaignGroupId	(Deprecated) emailCampaignGroupId
marketingemail_emailnote	TEXT	(Deprecated) emailNote	(Deprecated) emailNote
marketingemail_emailtemplatemode	TEXT	(Deprecated) emailTemplateMode	(Deprecated) emailTemplateMode
marketingemail_emailtype	TEXT	(Deprecated) emailType	(Deprecated) emailType
marketingemail_feedbacksurveyid	TEXT	(Deprecated) feedbackSurveyId	(Deprecated) feedbackSurveyId
marketingemail_flexareas	TEXT	(Deprecated) flexAreas	(Deprecated) flexAreas
marketingemail_freezedate	TIMESTAMP	(Deprecated) freezeDate	(Deprecated) freezeDate
marketingemail_fromname	TEXT	(Deprecated) fromName	(Deprecated) fromName

HubSpot marketingemail fields (marketingemail_hascontentaccessrules to marketingemail_sections)

ID	Type	Name	Description
marketingemail_hascontentaccessrules	TEXT	(Deprecated) hasContentAccessRules	(Deprecated) hasContentAccessRules
marketingemail_htmltitle	TEXT	(Deprecated) htmlTitle	(Deprecated) htmlTitle
marketingemail_id	TEXT	(Deprecated) id	(Deprecated) id
marketingemail_iscreatedfomsandboxsync	TEXT	(Deprecated) isCreatedFomSandboxSync	(Deprecated) isCreatedFomSandboxSync
marketingemail_isgraymailsuppressionenabled	TEXT	(Deprecated) isGraymailSuppressionEnabled	(Deprecated) isGraymailSuppressionEnabled
marketingemail_isinstancelayoutpage	TEXT	(Deprecated) isInstanceLayoutPage	(Deprecated) isInstanceLayoutPage
marketingemail_ispublished	TEXT	(Deprecated) isPublished	(Deprecated) isPublished
marketingemail_isrecipientfatiguesuppressionenabled	TEXT	(Deprecated) isRecipientFatigueSuppressionEnabled	(Deprecated) isRecipientFatigueSuppressionEnabled
marketingemail_language	TEXT	(Deprecated) language	(Deprecated) language
marketingemail_layoutsections	TEXT	(Deprecated) layoutSections	(Deprecated) layoutSections
marketingemail_livedomain	TEXT	(Deprecated) liveDomain	(Deprecated) liveDomain
marketingemail_mailinglistsexcluded	TEXT	(Deprecated) mailingListsExcluded	(Deprecated) mailingListsExcluded
marketingemail_mailinglistsincluded	TEXT	(Deprecated) mailingListsIncluded	(Deprecated) mailingListsIncluded
marketingemail_maxrssentries	TEXT	(Deprecated) maxRssEntries	(Deprecated) maxRssEntries
marketingemail_metadescription	TEXT	(Deprecated) metaDescription	(Deprecated) metaDescription
marketingemail_name	TEXT	(Deprecated) name	(Deprecated) name
marketingemail_pageexpiryenabled	TEXT	(Deprecated) pageExpiryEnabled	(Deprecated) pageExpiryEnabled
marketingemail_pageredirected	TEXT	(Deprecated) pageRedirected	(Deprecated) pageRedirected
marketingemail_pastmabexperimentids	TEXT	(Deprecated) pastMabExperimentIds	(Deprecated) pastMabExperimentIds
marketingemail_portalid	TEXT	(Deprecated) portalId	(Deprecated) portalId
marketingemail_previewkey	TEXT	(Deprecated) previewKey	(Deprecated) previewKey
marketingemail_primaryemailcampaignid	TEXT	(Deprecated) primaryEmailCampaignId	(Deprecated) primaryEmailCampaignId
marketingemail_primaryrichtextmodulehtml	TEXT	(Deprecated) primaryRichTextModuleHtml	(Deprecated) primaryRichTextModuleHtml
marketingemail_processingstatus	TEXT	(Deprecated) processingStatus	(Deprecated) processingStatus
marketingemail_publishdate	TIMESTAMP	(Deprecated) publishDate	(Deprecated) publishDate
marketingemail_publishedat	TEXT	(Deprecated) publishedAt	(Deprecated) publishedAt
marketingemail_publishedbyemail	TEXT	(Deprecated) publishedByEmail	(Deprecated) publishedByEmail
marketingemail_publishedbyid	TEXT	(Deprecated) publishedById	(Deprecated) publishedById
marketingemail_publishedbyname	TEXT	(Deprecated) publishedByName	(Deprecated) publishedByName
marketingemail_publishedurl	TEXT	(Deprecated) publishedUrl	(Deprecated) publishedUrl
marketingemail_replyto	TEXT	(Deprecated) replyTo	(Deprecated) replyTo
marketingemail_resolveddomain	TEXT	(Deprecated) resolvedDomain	(Deprecated) resolvedDomain
marketingemail_rssemailbytext	TEXT	(Deprecated) rssEmailByText	(Deprecated) rssEmailByText
marketingemail_rssemailclickthroughtext	TEXT	(Deprecated) rssEmailClickThroughText	(Deprecated) rssEmailClickThroughText
marketingemail_rssemailcommenttext	TEXT	(Deprecated) rssEmailCommentText	(Deprecated) rssEmailCommentText
marketingemail_rssemailentrytemplateenabled	TEXT	(Deprecated) rssEmailEntryTemplateEnabled	(Deprecated) rssEmailEntryTemplateEnabled
marketingemail_rssemailimagemaxwidth	TEXT	(Deprecated) rssEmailImageMaxWidth	(Deprecated) rssEmailImageMaxWidth
marketingemail_rssemailurl	TEXT	(Deprecated) rssEmailUrl	(Deprecated) rssEmailUrl
marketingemail_scrubssubscriptionlinks	TEXT	(Deprecated) scrubsSubscriptionLinks	(Deprecated) scrubsSubscriptionLinks
marketingemail_sections	TEXT	(Deprecated) sections	(Deprecated) sections

HubSpot marketingemail fields (marketingemail_securitystate to marketingemail_visibletoall)

ID	Type	Name	Description
marketingemail_securitystate	TEXT	(Deprecated) securityState	(Deprecated) securityState
marketingemail_slug	TEXT	(Deprecated) slug	(Deprecated) slug
marketingemail_smartemailfields	TEXT	(Deprecated) smartEmailFields	(Deprecated) smartEmailFields
marketingemail_state	TEXT	(Deprecated) state	(Deprecated) state
marketingemail_stylesettings	TEXT	(Deprecated) styleSettings	(Deprecated) styleSettings
marketingemail_subcategory	TEXT	(Deprecated) subcategory	(Deprecated) subcategory
marketingemail_subject	TEXT	(Deprecated) subject	(Deprecated) subject
marketingemail_subscription	TEXT	(Deprecated) subscription	(Deprecated) subscription
marketingemail_subscriptionname	TEXT	(Deprecated) subscriptionName	(Deprecated) subscriptionName
marketingemail_teamperms	TEXT	(Deprecated) teamPerms	(Deprecated) teamPerms
marketingemail_templatepath	TEXT	(Deprecated) templatePath	(Deprecated) templatePath
marketingemail_transactional	TEXT	(Deprecated) transactional	(Deprecated) transactional
marketingemail_translations	TEXT	(Deprecated) translations	(Deprecated) translations
marketingemail_unpublishedat	TEXT	(Deprecated) unpublishedAt	(Deprecated) unpublishedAt
marketingemail_updated	TIMESTAMP	(Deprecated) updated	(Deprecated) updated
marketingemail_updatedbyid	TEXT	(Deprecated) updatedById	(Deprecated) updatedById
marketingemail_url	TEXT	(Deprecated) url	(Deprecated) url
marketingemail_userperms	TEXT	(Deprecated) userPerms	(Deprecated) userPerms
marketingemail_userssheadlineassubject	TEXT	(Deprecated) useRssHeadlineAsSubject	(Deprecated) useRssHeadlineAsSubject
marketingemail_vidsexcluded	TEXT	(Deprecated) vidsExcluded	(Deprecated) vidsExcluded
marketingemail_vidsincluded	TEXT	(Deprecated) vidsIncluded	(Deprecated) vidsIncluded
marketingemail_visibletoall	TEXT	(Deprecated) visibleToAll	(Deprecated) visibleToAll

HubSpot meetings fields

The meetings report of the HubSpot connector includes 14 fields.

ID	Type	Name	Description
meetings_count	NUMERIC	Meetings count	Amount of Meetings
meetings_hs_activity_type	TEXT	Meetings Hubspot Activity Type	The type of meeting. The options are based on the meeting types set in your HubSpot account.
meetings_hs_attachment_ids	TEXT	Meetings Hubspot Attachment Ids	The IDs of the meeting's attachments. Multiple attachment IDs are separated by a semi-colon.
meetings_hs_createdate	TIMESTAMP	Meetings Create Date	Created date for the meeting.
meetings_hs_internal_meeting_notes	TEXT	Meetings Hubspot Internal Meeting Notes	The internal notes you take for your team during a meeting that are not included in the attendee meeting description.
meetings_hs_meeting_body	TEXT	Meetings Hubspot Meeting Body	The meeting description.
meetings_hs_meeting_end_time	TIMESTAMP	Meetings Hubspot Meeting End Time	The date and time when the meeting ends.
meetings_hs_meeting_external_url	TEXT	Meetings Hubspot Meeting External URL	The external URL for the calendar event. For example, this could be a Google calendar link or a Microsoft Outlook calendar link.
meetings_hs_meeting_location	TEXT	Meetings Hubspot Meeting Location	The internal notes you take for your team during a meeting that are not included in the attendee meeting description.
meetings_hs_meeting_start_time	TIMESTAMP	Meetings Hubspot Meeting Start Time	The date and time when the meeting starts. The value for this property should match the value for hs_timestamp.
meetings_hs_meeting_title	TEXT	Meetings Hs Meeting Title	The title of the meeting.
meetings_hs_object_id	TEXT	Meeting ID (Hubspot)	The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
meetings_hs_timestamp	TIMESTAMP	Meetings Hs Timestamp	This field marks the date and time that the meeting occurred. You can use either a Unix timestamp in milliseconds or UTC format.
meetings_hubspot_owner_id	TEXT	Meetings Hubspot Owner Id	The ID of the owner associated with the meeting. This field determines the user listed as the meeting creator on the record timeline.

HubSpot owner fields

The owner report of the HubSpot connector includes 9 fields.

ID	Type	Name	Description
owner_archived	TEXT	Owner Archived	Owner Archived
owner_count	NUMERIC	Owner count	Amount of owners
owner_created_at	TIMESTAMP	Owner Created At	Owner Created At
owner_email	TEXT	Owner Email	Owner Email
owner_first_name	TEXT	Owner First Name	Owner First Name
owner_last_name	TEXT	Owner Last Name	Owner Last Name
owner_owner_id	TEXT	Owner Id	Owner Id
owner_updated_at	TIMESTAMP	Owner Updated At	Owner Updated At
owner_user_id	TEXT	Owner User Id	Owner User Id

HubSpot pipeline fields

The pipeline report of the HubSpot connector includes 11 fields.

ID	Type	Name	Description
pipeline_count	NUMERIC	Pipeline count	Amount of pipelines
pipeline_id	TEXT	Pipeline ID	Pipeline ID
pipeline_name	TEXT	Pipeline Name	Pipeline name
pipeline_stage_created_at	TIMESTAMP	Pipeline Stage Created Date	The timestamp that specifies when the stage was created
pipeline_stage_display_order	NUMERIC	Pipeline Stage Display Order Number	Stage display order number
pipeline_stage_id	TEXT	Pipeline Stage ID	Stage ID
pipeline_stage_is_archived	BOOLEAN	Pipeline Is Stage Archived	Is stage archived
pipeline_stage_is_closed	BOOLEAN	Pipeline Is Closed	Is deal closed
pipeline_stage_name	TEXT	Pipeline Stage Name	Stage name
pipeline_stage_probability	TEXT	Pipeline Probablity	Deal probability
pipeline_stage_updated_at	TIMESTAMP	Pipeline Stage Last Modified Date	The timestamp that specifies when the stage was modified

HubSpot tickets fields

The tickets report of the HubSpot connector includes 133 fields.

HubSpot tickets fields (tickets_closed_date to tickets_hs_feedback_last_survey_date)

ID	Type	Name	Description
tickets_closed_date	TIMESTAMP	Close date	The date the ticket was closed
tickets_content	TEXT	Ticket description	Description of the ticket
tickets_count	NUMERIC	Tickets count	Amount of Tickets
tickets_created_by	TEXT	Created by	VID of contact that created the ticket
tickets_createdate	TIMESTAMP	Create date	The date the ticket was created
tickets_first_agent_reply_date	TIMESTAMP	First agent email response date	The date of the first email response from an agent after a ticket was created
tickets_hs_all_accessible_team_ids	TEXT	All teams	The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom
tickets_hs_all_assigned_business_unit_ids	TEXT	Business units	The business units this record is assigned to.
tickets_hs_all_associated_contact_companies	TEXT	All associated contact companies	All associated contact companies
tickets_hs_all_associated_contact_emails	TEXT	All associated contact emails	All associated contact emails
tickets_hs_all_associated_contact_firstnames	TEXT	All associated contact first names	All associated contact first names
tickets_hs_all_associated_contact_lastnames	TEXT	All associated contact last names	All associated contact last names
tickets_hs_all_associated_contact_mobilephones	TEXT	All associated contact mobile phones	All associated contact mobile phones
tickets_hs_all_associated_contact_phones	TEXT	All associated contact phones	All associated contact phones
tickets_hs_all_conversation_mentions	TEXT	All conversation mentions	All mentioned users on the associated conversations
tickets_hs_all_owner_ids	TEXT	All owner ids	The value of all owner referencing properties for this object, both default and custom
tickets_hs_all_team_ids	TEXT	All team ids	The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom
tickets_hs_applied_sla_rule_config_at	TEXT	Applied SLA Rule Config Date	Timestamp the current SLA Rule Config was applied to the ticket
tickets_hs_applied_sla_rule_config_id	TEXT	Applied SLA Rule Config ID	Reference to the SLA rule that was applied to this ticket
tickets_hs_assigned_team_ids	TEXT	Assigned Teams	The target main teams or the user's main team assigned to the ticket by automatic assignment.
tickets_hs_assignment_method	TEXT	Assignment Method	defines how the Object Assignment is done
tickets_hs_auto_generated_from_thread_id	TEXT	Auto-generated from thread id	Thread that this ticket was automatically created for using ticket rules
tickets_hs_conversations_originating_message_id	TEXT	Originating Conversations Message Id	Conversations Message Id of the message that originated this ticket
tickets_hs_conversations_originating_thread_id	TEXT	Conversations originating thread id	Thread that this ticket was originally created for
tickets_hs_created_by_user_id	TEXT	Created by user ID	The user that created this object. This value is automatically set by HubSpot and may not be modified.
tickets_hs_createdate	TIMESTAMP	HubSpot create date	Internal read-only property representing the date the ticket was created in HubSpot
tickets_hs_custom_inbox	TEXT	Custom inbox ID	ID of the custom inbox the ticket is associated with
tickets_hs_date_entered_1	TIMESTAMP	Date entered 'New (Support Pipeline)'	The date and time when the ticket entered the 'New' stage, 'Support Pipeline' pipeline
tickets_hs_date_entered_2	TIMESTAMP	Date entered 'Waiting on contact (Support Pipeline)'	The date and time when the ticket entered the 'Waiting on contact' stage, 'Support Pipeline' pipeline
tickets_hs_date_entered_3	TIMESTAMP	Date entered 'Waiting on us (Support Pipeline)'	The date and time when the ticket entered the 'Waiting on us' stage, 'Support Pipeline' pipeline
tickets_hs_date_entered_4	TIMESTAMP	Date entered 'Closed (Support Pipeline)'	The date and time when the ticket entered the 'Closed' stage, 'Support Pipeline' pipeline
tickets_hs_date_exited_1	TIMESTAMP	Date exited 'New (Support Pipeline)'	The date and time when the ticket exited the 'New' stage, 'Support Pipeline' pipeline
tickets_hs_date_exited_2	TIMESTAMP	Date exited 'Waiting on contact (Support Pipeline)'	The date and time when the ticket exited the 'Waiting on contact' stage, 'Support Pipeline' pipeline
tickets_hs_date_exited_3	TIMESTAMP	Date exited 'Waiting on us (Support Pipeline)'	The date and time when the ticket exited the 'Waiting on us' stage, 'Support Pipeline' pipeline
tickets_hs_date_exited_4	TIMESTAMP	Date exited 'Closed (Support Pipeline)'	The date and time when the ticket exited the 'Closed' stage, 'Support Pipeline' pipeline
tickets_hs_email_subject	TEXT	Email subject	Email subject
tickets_hs_external_object_ids	TEXT	External object ids	Unique ids corresponding to tickets in a system outside of HubSpot
tickets_hs_feedback_last_ces_follow_up	TEXT	Last CES survey comment	Last CES survey comment that this contact gave for this ticket
tickets_hs_feedback_last_ces_rating	TEXT	Last CES survey rating	Last CES survey rating that this contact gave for this ticket
tickets_hs_feedback_last_survey_date	TIMESTAMP	Last CES survey date	The time that this contact last submitted a CES survey response. This is automatically set by HubSpot.

HubSpot tickets fields (tickets_hs_file_upload to tickets_hs_originating_email_engagement_id)

ID	Type	Name	Description
tickets_hs_file_upload	TEXT	File upload	Files attached to a support form by a contact.
tickets_hs_first_agent_message_sent_at	TIMESTAMP	First agent response date	The date of the first response from an agent out of all associated conversations
tickets_hs_helpdesk_sort_timestamp	TIMESTAMP	Helpdesk Sort Timestamp	A calculated property to help with sorting in the Helpdesk
tickets_hs_in_helpdesk	TEXT	In Help Desk	Is this Ticket rendered in the Help Desk
tickets_hs_inbox_id	TEXT	Inbox ID	Inbox the ticket is in
tickets_hs_is_latest_message_failed	TEXT	Is latest message failed	Is latest message failed
tickets_hs_is_visible_in_help_desk	TEXT	Is Visible in Help desk	Whether the ticket is visible in help desk
tickets_hs_last_email_activity	TEXT	Last email activity	The type of the last email activity with the contact associated with the ticket.
tickets_hs_last_email_date	TIMESTAMP	Last email date	The date of the last email activity with the contact associated with the ticket.
tickets_hs_last_message_from_visitor	TIMESTAMP	Last message from visitor	Whether the last message came from visitor
tickets_hs_last_message_received_at	TIMESTAMP	Last message received date	The date of the last response from the visitor
tickets_hs_last_message_sent_at	TIMESTAMP	Last response date	The date of the last response from an agent or bot
tickets_hs_lastactivitydate	TIMESTAMP	Last activity date	The last time a note, call, email, meeting, or task was logged for a ticket. This is updated automatically by HubSpot.
tickets_hs_lastcontacted	TIMESTAMP	Last contacted date	The last time a call, chat conversation, LinkedIn message, postal mail, meeting, sales email, SMS, or WhatsApp message was logged for a ticket. This is set automatically by HubSpot based on user actions in the ticket record.
tickets_hs_lastmodifieddate	TIMESTAMP	Last modified date	Most recent timestamp of any property update for this ticket. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
tickets_hs_latest_message_attachment_types	TEXT	Latest message attachment types	List of attachment types from the latest message
tickets_hs_latest_message_is_forwarded_email	TEXT	Latest message is forwarded email	Is latest message a forwarded email
tickets_hs_latest_message_is_thread_comment	TEXT	Latest message is thread comment	Is latest message a thread comment
tickets_hs_latest_message_seen_by_agent_ids	TEXT	Latest message seen by agent ids	Agents who have seen the newest message across all conversations associated to the ticket
tickets_hs_latest_message_text	TEXT	Latest Message Text	Latest message text (truncated)
tickets_hs_merged_object_ids	TEXT	Merged Ticket IDs	The list of Ticket record IDs that have been merged into this Ticket. This value is automatically set by HubSpot and may not be modified.
tickets_hs_most_relevant_sla_status	TEXT	Most relevant SLA status	Most relevant sla status
tickets_hs_most_relevant_sla_type	TEXT	Most Relevant SLA Type	Most relevant SLA type between Close By, First Response, Next Response
tickets_hs_msteams_message_id	TEXT	Microsoft Teams message ID for this ticket.	Microsoft Teams message ID for this ticket.
tickets_hs_nextactivitydate	TIMESTAMP	Next activity date	The date of the next upcoming activity for a ticket. This property is set automatically by HubSpot based on user action. This includes logging a future call, email, or meeting using the Log feature, as well as creating a future task or scheduling a future meeting. This is updated automatically by HubSpot.
tickets_hs_notes_next_activity	TEXT	Next Activity	The coordinates of the next upcoming activity for a ticket. This is set automatically by HubSpot based on user actions in the ticket record.
tickets_hs_notes_next_activity_type	TEXT	Next Activity Type	The type of the next upcoming activity for a ticket. This property is set automatically by HubSpot based on user action. This includes logging a future call, email, or meeting using the Log feature, as well as creating a future task or scheduling a future meeting. This is updated automatically by HubSpot.
tickets_hs_num_associated_companies	TEXT	Number of Associated Companies	Number of companies associated with this ticket
tickets_hs_num_associated_conversations	TEXT	Number of Associated Conversations	Number of conversations associated to the ticket
tickets_hs_num_times_contacted	TEXT	Number of times contacted	The number of times a call, email, or meeting was logged on the ticket
tickets_hs_object_id	TEXT	Record ID	The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
tickets_hs_object_source	TEXT	Record Creation Source	Source (PropertySource) that created this object record
tickets_hs_object_source_detail_1	TEXT	Record Source Detail 1	First level of detail on how this record was created
tickets_hs_object_source_detail_2	TEXT	Record Source Detail 2	Second level of detail on how this record was created
tickets_hs_object_source_detail_3	TEXT	Record Source Detail 3	Third level of detail on how this record was created
tickets_hs_object_source_id	TEXT	Record Creation Source ID	The sourceId -- further detail -- of the source that created this object record
tickets_hs_object_source_label	TEXT	Record Source	How this record was created
tickets_hs_object_source_user_id	TEXT	Record Creation Source User ID	User ID of the user who initiated creation of this object record
tickets_hs_originating_channel_instance_id	TEXT	Originating channel account	First channel account used when conversation was started
tickets_hs_originating_email_engagement_id	TEXT	Originating email engagement id	Engagement id of the email originating this ticket

HubSpot tickets fields (tickets_hs_originating_generic_channel_id to tickets_notes_last_updated)

ID	Type	Name	Description
tickets_hs_originating_generic_channel_id	TEXT	Originating channel type	The channel the conversation is in
tickets_hs_pinned_engagement_id	TEXT	Pinned Engagement ID	The object ID of the current pinned engagement. This will only be shown if there is already an association to the engagement.
tickets_hs_pipeline	TEXT	Pipeline	The pipeline that contains this ticket
tickets_hs_pipeline_stage	TEXT	Ticket status	The pipeline stage that contains this ticket
tickets_hs_primary_company	TEXT	Primary Company	Primary company of a ticket
tickets_hs_primary_company_id	TEXT	Primary Company ID	Primary company ID of a ticket
tickets_hs_primary_company_name	TEXT	Primary Company Name	Primary company name of a ticket
tickets_hs_read_only	TEXT	Read Only Object	Is the object read only
tickets_hs_resolution	TEXT	Resolution	The action taken to resolve the ticket
tickets_hs_sales_email_last_replied	TEXT	Recent Sales Email Replied Date	The last time a tracked sales email was replied to for this ticket
tickets_hs_seen_by_agent_ids	TEXT	Users interaction	Stores a list of users who have viewed the most recent interaction on a ticket
tickets_hs_source_object_id	TEXT	Source Object ID	The ID of the object from which the data was migrated. This is set automatically during portal data migration.
tickets_hs_tag_ids	TEXT	Ticket Tags	List of tag ids applicable to a ticket. This property is set automatically by HubSpot.
tickets_hs_thread_ids_to_restore	TEXT	Thread IDs To Restore	Thread IDs (from cv-threads) used to implement custom cascading delete/restore
tickets_hs_ticket_category	TEXT	Tickets Hubspot Category	Main reason customer reached out for help
tickets_hs_ticket_id	TEXT	Ticket ID	The unique ID for this ticket. This unique ID is automatically populated by HubSpot and cannot be changed.
tickets_hs_ticket_priority	TEXT	Tickets Hubspot Priority	The level of attention needed on the ticket
tickets_hs_time_in_1	TEXT	Time in 'New (Support Pipeline)'	The total time in seconds spent by the ticket in the 'New' stage, 'Support Pipeline' pipeline
tickets_hs_time_in_2	TEXT	Time in 'Waiting on contact (Support Pipeline)'	The total time in seconds spent by the ticket in the 'Waiting on contact' stage, 'Support Pipeline' pipeline
tickets_hs_time_in_3	TEXT	Time in 'Waiting on us (Support Pipeline)'	The total time in seconds spent by the ticket in the 'Waiting on us' stage, 'Support Pipeline' pipeline
tickets_hs_time_in_4	TEXT	Time in 'Closed (Support Pipeline)'	The total time in seconds spent by the ticket in the 'Closed' stage, 'Support Pipeline' pipeline
tickets_hs_time_to_close_sla_at	TEXT	Time to Close SLA Due Date	When the ticket falls out of Time to Close SLA.
tickets_hs_time_to_close_sla_status	TEXT	Time to Close SLA Ticket Status	Current Time to Close SLA status of ticket
tickets_hs_time_to_first_response_sla_at	TIMESTAMP	Time to First Response SLA Due Date	When the ticket falls out of the Time to First Response SLA
tickets_hs_time_to_first_response_sla_status	TEXT	Time to First Response SLA Status	Current Time to First Response SLA status.
tickets_hs_time_to_next_response_sla_at	TIMESTAMP	Time to Next Response SLA Due Date	When the ticket falls out of Time to Next Response SLA
tickets_hs_time_to_next_response_sla_status	TEXT	Time to Next Response SLA Status	Current Time to Next Response SLA status
tickets_hs_unique_creation_key	TEXT	Unique creation key	Unique property used for idempotent creates
tickets_hs_updated_by_user_id	TEXT	Updated by user ID	The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
tickets_hs_user_ids_of_all_notification_followers	TEXT	User IDs of all notification followers	The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications
tickets_hs_user_ids_of_all_notification_unfollowers	TEXT	User IDs of all notification unfollowers	The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications
tickets_hs_user_ids_of_all_owners	TEXT	User IDs of all owners	The user IDs of all owners of this object
tickets_hs_was_imported	TEXT	Performed in an import	Object is part of an import
tickets_hubspot_owner_assigneddate	TIMESTAMP	Owner assigned date	The date an owner was assigned to the ticket
tickets_hubspot_owner_id	TEXT	Ticket owner	The user from your team that the ticket is assigned to. You can assign additional users to a ticket record by creating a custom HubSpot user property.
tickets_hubspot_team_id	TEXT	HubSpot team	The Primary team of the ticket owner for the ticket. This property is set automatically by HubSpot.
tickets_last_engagement_date	TIMESTAMP	Date of last engagement	The date of the last reply or note
tickets_last_reply_date	TIMESTAMP	Last customer reply date	The date of the last customer response
tickets_notes_last_contacted	TEXT	Last Contacted (Ticket Note)	The last time a call, chat conversation, LinkedIn message, postal mail, meeting, note, sales email, SMS, or WhatsApp message was logged for a ticket. This is set automatically by HubSpot based on user actions in the ticket record.
tickets_notes_last_updated	TIMESTAMP	Last Activity Date (Ticket Note)	The last time a note, call, email, meeting, or task was logged for a ticket. This is set automatically by HubSpot based on user actions in the ticket record.

HubSpot tickets fields (tickets_notes_next_activity_date to tickets_time_to_first_agent_reply)

ID	Type	Name	Description
tickets_notes_next_activity_date	TIMESTAMP	Next Activity Date (Ticket Note)	The date of the next upcoming activity for this ticket
tickets_nps_follow_up_answer	TEXT	NPS follow up	Answer to NPS follow up question
tickets_nps_follow_up_question_version	TEXT	NPS follow up question	Specific version of NPS follow up question that was asked
tickets_nps_score	TEXT	Conversation NPS score	NPS score received after ticket resolution
tickets_num_contacted_notes	TEXT	Number of times contacted (Ticket Note)	The number of times a call, email or meeting was logged for this ticket
tickets_num_notes	TEXT	Number of Sales Activities	Number of sales activities for this ticket
tickets_source_ref	TEXT	Reference to source-specific object	The id of a connected source object
tickets_source_thread_id	TEXT	Reference to email thread	The id of an email thread with ticket conversation
tickets_source_type	TEXT	Tickets Source Type	Channel where ticket was originally submitted
tickets_subject	TEXT	Ticket name	Short summary of ticket
tickets_tags	TEXT	Tags	Tags associated with your tickets
tickets_time_to_close	TEXT	Time to close	The time between when the ticket was created and closed
tickets_time_to_first_agent_reply	TEXT	Time to first agent email reply	The time from the ticket create date to the first agent email reply

HubSpot ticketspipeline fields

The ticketspipeline report of the HubSpot connector includes 10 fields.

ID	Type	Name	Description
ticketspipeline_count	NUMERIC	Tickets Pipeline count	Amount of pipelines
ticketspipeline_id	TEXT	Tickets Pipeline ID	Tickets pipeline ID
ticketspipeline_name	TEXT	Tickets Pipeline Name	Tickets pipeline name
ticketspipeline_stage_created_at	TIMESTAMP	Tickets Pipeline Stage Created Date	The timestamp that specifies when the stage was created
ticketspipeline_stage_display_order	NUMERIC	Tickets Pipeline Stage Display Order Number	Ticket stage display order number
ticketspipeline_stage_id	TEXT	Tickets Pipeline Stage ID	Ticket stage ID
ticketspipeline_stage_is_archived	BOOLEAN	Tickets Pipeline Is Stage Archived	Is stage archived
ticketspipeline_stage_is_closed	BOOLEAN	Tickets Pipeline Is Closed	Is ticket closed
ticketspipeline_stage_name	TEXT	Tickets Pipeline Stage Name	Ticket stage name
ticketspipeline_stage_updated_at	TIMESTAMP	Tickets Pipeline Stage Last Modified Date	The timestamp that specifies when the stage was modified

HubSpot other fields

The HubSpot connector has 25 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Object
account_id	TEXT	Account ID	Your Hubspot account ID	Account
account_name	TEXT	Account Name	Your Hubspot account name	Account
channels_id	TEXT	Channel's ID	The ID of the channel (e.g. 1000, 1001, 1002).	channels
channels_name	TEXT	Channel's Name	The name of the channel (e.g. LIVE_CHAT, EMAIL, FB_MESSENGER).	channels
customfield_hs_createdate	TIMESTAMP	Custom Field Modified Date	Most recent timestamp of any property update for this custom object.	customfield
customfield_hs_lastmodifieddate	TIMESTAMP	Custom Field Last Modified Date	Most recent timestamp of any property update for this custom object.	customfield
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	The Date
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors