Windsor brings all your HubSpot data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

HubSpot Field Reference

Sample

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]

Available Options

ID	Type	Name	Description	Options
analytics_breakdowns	SELECT_MULTI	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. Default: sessions	sessions; sources; geolocation; utm-campaigns; utm-contents; utm-mediums; utm-sources; utm-terms;

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
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
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
analytics_breakdown	TEXT	Analytics Breakdown	The specific breakdown of data based on the defined type, providing a detailed view of segmented analytics.	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
analytics_contacts	NUMERIC	Analytics Contacts	The total number of contacts made through the website, such as form submissions, inquiries, or other touchpoints.	Analytics
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
analytics_contacttocustomerrate	PERCENT	Analytics Contact To Customer Rate	The conversion rate that represents the percentage of contacts successfully converted into customers.	Analytics
analytics_customers	NUMERIC	Analytics Customers	The total number of customers acquired during the specified time frame, representing successful conversions.	Analytics
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
analytics_date	DATE	Analytics Date	The date on which the analytics data was collected or recorded.	Analytics
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
analytics_opportunities	NUMERIC	Analytics Opportunities	The total number of sales or engagement opportunities identified based on user activity, indicating lead generation.	Analytics
analytics_others	NUMERIC	Analytics Others	The total amount of traffic from other unspecified sources or categories.	Analytics
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
analytics_pageviewspersession	NUMERIC	Analytics Page Views Per Session	The average number of page views generated during each session, representing user engagement per session.	Analytics
analytics_rawviews	NUMERIC	Analytics Raw Views	The total number of raw page views recorded without applying filters or adjustments.	Analytics
analytics_returningvisits	NUMERIC	Analytics Returning Visits	The total number of visits from users who have previously visited the site, reflecting returning user engagement.	Analytics
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
analytics_standardviews	NUMERIC	Analytics Standard Views	The total number of standard views filtered based on specific predefined criteria or metrics.	Analytics
analytics_subscribers	NUMERIC	Analytics Subscribers	The total number of users who subscribed to newsletters, updates, or services through the website.	Analytics
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
analytics_timepersession	NUMERIC	Analytics Time Per Session	The average amount of time spent per session by users on the website, indicating session duration.	Analytics
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
analytics_total_bounces	NUMERIC	Analytics Total Bounces	The total number of single-page visits where the user left the site without engaging further.	Analytics
analytics_total_contacts	NUMERIC	Analytics Total Contacts	The total number of contacts made through the website, including form submissions and other contact points.	Analytics
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
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
analytics_total_customers	NUMERIC	Analytics Total Customers	The total number of customers acquired through the website, reflecting successful conversions.	Analytics
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
analytics_total_desktop	NUMERIC	Analytics Total Desktop	The total number of sessions initiated from desktop devices, indicating desktop traffic levels.	Analytics
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
analytics_total_emailmarketing	NUMERIC	Analytics Total Email Marketing	The total number of visitors driven to the website through email marketing campaigns.	Analytics
analytics_total_mobile	NUMERIC	Analytics Total Mobile	The total number of sessions originating from mobile devices, representing mobile traffic.	Analytics
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
analytics_total_opportunities	NUMERIC	Analytics Total Opportunities	The total number of sales or engagement opportunities generated from user activity, indicating lead generation.	Analytics
analytics_total_organicsearch	NUMERIC	Analytics Total Organic Search	The total number of visitors who arrived at the website through organic search engine results.	Analytics
analytics_total_othercampaigns	NUMERIC	Analytics Total Other Campaigns	The total number of visitors generated through other marketing campaigns outside of typical channels.	Analytics
analytics_total_others	NUMERIC	Analytics Total Others	Total traffic from other unspecified or miscellaneous sources that don’t fit into predefined categories.	Analytics
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
analytics_total_pageviewspersession	NUMERIC	Analytics Total Page Views Per Session	The average number of page views generated during each user session, reflecting user activity.	Analytics
analytics_total_paidsearch	NUMERIC	Analytics Total Paid Search	The total number of visitors generated through paid search engine advertising, such as Google Ads.	Analytics
analytics_total_rawviews	NUMERIC	Analytics Total Raw Views	The total number of unfiltered raw page views, providing an overall count of page interactions.	Analytics
analytics_total_referrals	NUMERIC	Analytics Total Referrals	The total amount of traffic referred from external websites or links.	Analytics
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
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
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
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
analytics_total_subscribers	NUMERIC	Analytics Total Subscribers	The total number of users who subscribed to newsletters or other services via the website.	Analytics
analytics_total_time	NUMERIC	Analytics Total Time	The total time users spent on the website during a given period, reflecting overall user engagement.	Analytics
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
analytics_total_visitors	NUMERIC	Analytics Total Visitors	The total number of unique visitors to the website, indicating the overall reach of the site.	Analytics
analytics_total_visits	NUMERIC	Analytics Total Visits	The total number of visits to the website, including repeat visits from the same users.	Analytics
analytics_visitors	NUMERIC	Analytics Visitors	The total number of unique visitors to the website, representing distinct individuals accessing the site.	Analytics
analytics_visits	NUMERIC	Analytics Visits	The total number of visits to the website, including multiple visits from the same user.	Analytics
calls_count	NUMERIC	Calls count	Amount of Calls	calls
calls_hs_activity_type	TEXT	Calls Call and meeting type	Calls Call and meeting type	calls
calls_hs_all_accessible_team_ids	TEXT	Calls All teams	Calls All teams	calls
calls_hs_all_assigned_business_unit_ids	TEXT	Calls Business units	Calls Business units	calls
calls_hs_all_owner_ids	TEXT	Calls All owner IDs	Calls All owner IDs	calls
calls_hs_all_team_ids	TEXT	Calls All team IDs	Calls All team IDs	calls
calls_hs_at_mentioned_owner_ids	TEXT	Calls At-Mentioned Owner Ids	Calls At-Mentioned Owner Ids	calls
calls_hs_attachment_ids	TEXT	Calls Attached file IDs	Calls Attached file IDs	calls
calls_hs_body_preview	TEXT	Calls Call notes preview	Calls Call notes preview	calls
calls_hs_body_preview_html	TEXT	Calls HTML Body Preview	Calls HTML Body Preview	calls
calls_hs_body_preview_is_truncated	TEXT	Calls Body Preview Truncated	Calls Body Preview Truncated	calls
calls_hs_call_app_id	TEXT	Calls Integrating App ID	Calls Integrating App ID	calls
calls_hs_call_authed_url_provider	TEXT	Calls Authenticated recording files url provider	Calls Authenticated recording files url provider	calls
calls_hs_call_body	TEXT	Calls Call notes	Calls Call notes	calls
calls_hs_call_callee_object_id	TEXT	Calls Callee object ID	Calls Callee object ID	calls
calls_hs_call_callee_object_type	TEXT	Calls Callee object type	Calls Callee object type	calls
calls_hs_call_deal_stage_during_call	TEXT	Calls Deal Stage During Call	Calls Deal Stage During Call	calls
calls_hs_call_direction	TEXT	Calls Call direction	Calls Call direction	calls
calls_hs_call_disposition	TEXT	Calls Call outcome	Calls Call outcome	calls
calls_hs_call_duration	NUMERIC	Calls Call duration	Calls Call duration	calls
calls_hs_call_external_account_id	TEXT	Calls External Account ID	Calls External Account ID	calls
calls_hs_call_external_id	TEXT	Calls External ID	Calls External ID	calls
calls_hs_call_from_number	TEXT	Calls From number	Calls From number	calls
calls_hs_call_from_number_nickname	TEXT	Calls From Number Name	Calls From Number Name	calls
calls_hs_call_has_transcript	BOOLEAN	Calls Transcript Available	Calls Transcript Available	calls
calls_hs_call_has_voicemail	BOOLEAN	Calls Voicemail Available	Calls Voicemail Available	calls
calls_hs_call_meeting_id	TEXT	Calls Meeting ID	Calls Meeting ID	calls
calls_hs_call_ms_teams_payload	TEXT	Calls MsTeams payload	Calls MsTeams payload	calls
calls_hs_call_primary_deal	TEXT	Calls Primary Deal	Calls Primary Deal	calls
calls_hs_call_recording_duration	NUMERIC	Calls Recording duration	Calls Recording duration	calls
calls_hs_call_recording_url	TEXT	Calls Recording URL	Calls Recording URL	calls
calls_hs_call_source	TEXT	Calls Call Source	Calls Call Source	calls
calls_hs_call_status	TEXT	Calls Call status	Calls Call status	calls
calls_hs_call_suggested_next_actions	TEXT	Calls Call suggested next actions	Calls Call suggested next actions	calls
calls_hs_call_summary	TEXT	Calls Call summary	Calls Call summary	calls
calls_hs_call_summary_execution_id	TEXT	Calls Call Summary Execution ID	Calls Call Summary Execution ID	calls
calls_hs_call_title	TEXT	Calls Call Title	Calls Call Title	calls
calls_hs_call_to_number	TEXT	Calls To Number	Calls To Number	calls
calls_hs_call_to_number_nickname	TEXT	Calls To Number Name	Calls To Number Name	calls
calls_hs_call_transcript_audio_num_channels	NUMERIC	Calls Call Transcript Audio Channel Count	Calls Call Transcript Audio Channel Count	calls
calls_hs_call_transcript_tracked_terms	TEXT	Calls Tracked terms	Calls Tracked terms	calls
calls_hs_call_transcription_id	TEXT	Calls Call transcription ID	Calls Call transcription ID	calls
calls_hs_call_video_meeting_type	TEXT	Calls Call video meeting type	Calls Call video meeting type	calls
calls_hs_call_video_recording_url	TEXT	Calls Video url	Calls Video url	calls
calls_hs_call_zoom_meeting_uuid	TEXT	Calls Unique Zoom Meeting ID	Calls Unique Zoom Meeting ID	calls
calls_hs_calls_service_call_id	TEXT	Calls Service Call ID	Calls Service Call ID	calls
calls_hs_connected_count	NUMERIC	Calls Connected count	Calls Connected count	calls
calls_hs_created_by	TEXT	Calls Activity created by	Calls Activity created by	calls
calls_hs_created_by_user_id	TEXT	Calls Created by user ID	Calls Created by user ID	calls
calls_hs_createdate	DATE	Calls Create date	Calls Create date	calls
calls_hs_engagement_source	TEXT	Calls Engagement Source	Calls Engagement Source	calls
calls_hs_engagement_source_id	TEXT	Calls Engagement Source ID	Calls Engagement Source ID	calls
calls_hs_follow_up_action	TEXT	Calls Follow up action	Calls Follow up action	calls
calls_hs_gdpr_deleted	BOOLEAN	Calls GDPR deleted	Calls GDPR deleted	calls
calls_hs_lastmodifieddate	DATE	Calls Last modified date	Calls Last modified date	calls
calls_hs_merged_object_ids	TEXT	Calls Merged record IDs	Calls Merged record IDs	calls
calls_hs_modified_by	NUMERIC	Calls Updated by	Calls Updated by	calls
calls_hs_object_id	TEXT	Calls Record ID	Calls Record ID	calls
calls_hs_object_source	TEXT	Calls Record Creation Source	Calls Record Creation Source	calls
calls_hs_object_source_detail_1	TEXT	Calls Record Source Detail 1	Calls Record Source Detail 1	calls
calls_hs_object_source_detail_2	TEXT	Calls Record Source Detail 2	Calls Record Source Detail 2	calls
calls_hs_object_source_detail_3	TEXT	Calls Record Source Detail 3	Calls Record Source Detail 3	calls
calls_hs_object_source_id	TEXT	Calls Record Creation Source ID	Calls Record Creation Source ID	calls
calls_hs_object_source_label	TEXT	Calls Record Source	Calls Record Source	calls
calls_hs_object_source_user_id	NUMERIC	Calls Record Creation Source User ID	Calls Record Creation Source User ID	calls
calls_hs_product_name	TEXT	Calls Product name	Calls Product name	calls
calls_hs_queue_membership_ids	TEXT	Calls Queue Memberships	Calls Queue Memberships	calls
calls_hs_read_only	TEXT	Calls Read Only Object	Calls Read Only Object	calls
calls_hs_shared_team_ids	TEXT	Calls Shared Team IDs	Calls Shared Team IDs	calls
calls_hs_shared_user_ids	TEXT	Calls Shared User IDs	Calls Shared User IDs	calls
calls_hs_timestamp	TIMESTAMP	Calls Activity date	Calls Activity date	calls
calls_hs_unique_creation_key	TEXT	Calls Unique creation key	Calls Unique creation key	calls
calls_hs_unique_id	TEXT	Calls Unique ID	Calls Unique ID	calls
calls_hs_unknown_visitor_conversation	TEXT	Calls Unknown Visitor Conversation	Calls Unknown Visitor Conversation	calls
calls_hs_updated_by_user_id	NUMERIC	Calls Updated by user ID	Calls Updated by user ID	calls
calls_hs_user_ids_of_all_notification_followers	TEXT	Calls User IDs of all notification followers	Calls User IDs of all notification followers	calls
calls_hs_user_ids_of_all_notification_unfollowers	TEXT	Calls User IDs of all notification unfollowers	Calls User IDs of all notification unfollowers	calls
calls_hs_user_ids_of_all_owners	TEXT	Calls User IDs of all owners	Calls User IDs of all owners	calls
calls_hs_voicemail_count	NUMERIC	Calls Voicemail count	Calls Voicemail count	calls
calls_hs_was_imported	TEXT	Calls Performed in an import	Calls Performed in an import	calls
calls_hubspot_owner_assigneddate	DATE	Calls Owner Assigned Date	Calls Owner Assigned Date	calls
calls_hubspot_owner_id	TEXT	Calls Activity assigned to	Calls Activity assigned to	calls
calls_hubspot_team_id	TEXT	Calls HubSpot Team ID	Calls HubSpot Team ID	calls
campaignemails_active_domain	TEXT	Campaign Emails Active domain	Campaign Emails Active domain	campaignemails
campaignemails_archived	BOOLEAN	Campaign Emails Archived	Campaign Emails Archived	campaignemails
campaignemails_business_unit_id	TEXT	Campaign Emails Business unit id	Campaign Emails Business unit id	campaignemails
campaignemails_count	NUMERIC	Campaign Emails count	Amount of Campaign Emails	campaignemails
campaignemails_created_at	TIMESTAMP	Campaign Emails Created at	Campaign Emails Created at	campaignemails
campaignemails_created_by_id	TEXT	Campaign Emails Created by id	Campaign Emails Created by id	campaignemails
campaignemails_deleted_at	TIMESTAMP	Campaign Emails Deleted at	Campaign Emails Deleted at	campaignemails
campaignemails_from_custom_reply_to	TEXT	Campaign Emails From custom reply to	Campaign Emails From custom reply to	campaignemails
campaignemails_from_from_name	TEXT	Campaign Emails From from name	Campaign Emails From from name	campaignemails
campaignemails_from_reply_to	TEXT	Campaign Emails From reply to	Campaign Emails From reply to	campaignemails
campaignemails_id	TEXT	Campaign Emails Id	Campaign Emails Id	campaignemails
campaignemails_is_published	BOOLEAN	Campaign Emails Is published	Campaign Emails Is published	campaignemails
campaignemails_is_transactional	BOOLEAN	Campaign Emails Is transactional	Campaign Emails Is transactional	campaignemails
campaignemails_language	TEXT	Campaign Emails Language	Campaign Emails Language	campaignemails
campaignemails_name	TEXT	Campaign Emails Name	Campaign Emails Name	campaignemails
campaignemails_publish_date	TIMESTAMP	Campaign Emails Publish date	Campaign Emails Publish date	campaignemails
campaignemails_published_by_id	TEXT	Campaign Emails Published by id	Campaign Emails Published by id	campaignemails
campaignemails_send_on_publish	BOOLEAN	Campaign Emails Send on publish	Campaign Emails Send on publish	campaignemails
campaignemails_state	TEXT	Campaign Emails State	Campaign Emails State	campaignemails
campaignemails_stats_counters_bounce	NUMERIC	Campaign Emails Stats counters bounce	Campaign Emails Stats counters bounce	campaignemails
campaignemails_stats_counters_click	NUMERIC	Campaign Emails Stats counters click	Campaign Emails Stats counters click	campaignemails
campaignemails_stats_counters_contactslost	NUMERIC	Campaign Emails Stats counters contactslost	Campaign Emails Stats counters contactslost	campaignemails
campaignemails_stats_counters_delivered	NUMERIC	Campaign Emails Stats counters delivered	Campaign Emails Stats counters delivered	campaignemails
campaignemails_stats_counters_dropped	NUMERIC	Campaign Emails Stats counters dropped	Campaign Emails Stats counters dropped	campaignemails
campaignemails_stats_counters_hardbounced	NUMERIC	Campaign Emails Stats counters hardbounced	Campaign Emails Stats counters hardbounced	campaignemails
campaignemails_stats_counters_notsent	NUMERIC	Campaign Emails Stats counters notsent	Campaign Emails Stats counters notsent	campaignemails
campaignemails_stats_counters_open	NUMERIC	Campaign Emails Stats counters open	Campaign Emails Stats counters open	campaignemails
campaignemails_stats_counters_pending	NUMERIC	Campaign Emails Stats counters pending	Campaign Emails Stats counters pending	campaignemails
campaignemails_stats_counters_reply	NUMERIC	Campaign Emails Stats counters reply	Campaign Emails Stats counters reply	campaignemails
campaignemails_stats_counters_selected	NUMERIC	Campaign Emails Stats counters selected	Campaign Emails Stats counters selected	campaignemails
campaignemails_stats_counters_sent	NUMERIC	Campaign Emails Stats counters sent	Campaign Emails Stats counters sent	campaignemails
campaignemails_stats_counters_softbounced	NUMERIC	Campaign Emails Stats counters softbounced	Campaign Emails Stats counters softbounced	campaignemails
campaignemails_stats_counters_spamreport	NUMERIC	Campaign Emails Stats counters spamreport	Campaign Emails Stats counters spamreport	campaignemails
campaignemails_stats_counters_suppressed	NUMERIC	Campaign Emails Stats counters suppressed	Campaign Emails Stats counters suppressed	campaignemails
campaignemails_stats_counters_unsubscribed	NUMERIC	Campaign Emails Stats counters unsubscribed	Campaign Emails Stats counters unsubscribed	campaignemails
campaignemails_stats_device_breakdown_click_device_type_computer	NUMERIC	Campaign Emails Stats device breakdown click device type computer	Campaign Emails Stats device breakdown click device type computer	campaignemails
campaignemails_stats_device_breakdown_click_device_type_mobile	NUMERIC	Campaign Emails Stats device breakdown click device type mobile	Campaign Emails Stats device breakdown click device type mobile	campaignemails
campaignemails_stats_device_breakdown_click_device_type_unknown	NUMERIC	Campaign Emails Stats device breakdown click device type unknown	Campaign Emails Stats device breakdown click device type unknown	campaignemails
campaignemails_stats_device_breakdown_open_device_type_computer	NUMERIC	Campaign Emails Stats device breakdown open device type computer	Campaign Emails Stats device breakdown open device type computer	campaignemails
campaignemails_stats_device_breakdown_open_device_type_mobile	NUMERIC	Campaign Emails Stats device breakdown open device type mobile	Campaign Emails Stats device breakdown open device type mobile	campaignemails
campaignemails_stats_device_breakdown_open_device_type_unknown	NUMERIC	Campaign Emails Stats device breakdown open device type unknown	Campaign Emails Stats device breakdown open device type unknown	campaignemails
campaignemails_stats_ratios_bounceratio	PERCENT	Campaign Emails Stats ratios bounceratio	Campaign Emails Stats ratios bounceratio	campaignemails
campaignemails_stats_ratios_clickratio	PERCENT	Campaign Emails Stats ratios clickratio	Campaign Emails Stats ratios clickratio	campaignemails
campaignemails_stats_ratios_clickthroughratio	PERCENT	Campaign Emails Stats ratios clickthroughratio	Campaign Emails Stats ratios clickthroughratio	campaignemails
campaignemails_stats_ratios_contactslostratio	PERCENT	Campaign Emails Stats ratios contactslostratio	Campaign Emails Stats ratios contactslostratio	campaignemails
campaignemails_stats_ratios_deliveredratio	PERCENT	Campaign Emails Stats ratios deliveredratio	Campaign Emails Stats ratios deliveredratio	campaignemails
campaignemails_stats_ratios_hardbounceratio	PERCENT	Campaign Emails Stats ratios hardbounceratio	Campaign Emails Stats ratios hardbounceratio	campaignemails
campaignemails_stats_ratios_notsentratio	PERCENT	Campaign Emails Stats ratios notsentratio	Campaign Emails Stats ratios notsentratio	campaignemails
campaignemails_stats_ratios_openratio	PERCENT	Campaign Emails Stats ratios openratio	Campaign Emails Stats ratios openratio	campaignemails
campaignemails_stats_ratios_pendingratio	PERCENT	Campaign Emails Stats ratios pendingratio	Campaign Emails Stats ratios pendingratio	campaignemails
campaignemails_stats_ratios_replyratio	PERCENT	Campaign Emails Stats ratios replyratio	Campaign Emails Stats ratios replyratio	campaignemails
campaignemails_stats_ratios_softbounceratio	PERCENT	Campaign Emails Stats ratios softbounceratio	Campaign Emails Stats ratios softbounceratio	campaignemails
campaignemails_stats_ratios_spamreportratio	PERCENT	Campaign Emails Stats ratios spamreportratio	Campaign Emails Stats ratios spamreportratio	campaignemails
campaignemails_stats_ratios_unsubscribedratio	PERCENT	Campaign Emails Stats ratios unsubscribedratio	Campaign Emails Stats ratios unsubscribedratio	campaignemails
campaignemails_subcategory	TEXT	Campaign Emails Subcategory	Campaign Emails Subcategory	campaignemails
campaignemails_subject	TEXT	Campaign Emails Subject	Campaign Emails Subject	campaignemails
campaignemails_subscription_details_office_location_id	TEXT	Campaign Emails Subscription details office location id	Campaign Emails Subscription details office location id	campaignemails
campaignemails_subscription_details_subscription_id	TEXT	Campaign Emails Subscription details subscription id	Campaign Emails Subscription details subscription id	campaignemails
campaignemails_to_suppress_graymail	BOOLEAN	Campaign Emails To suppress graymail	Campaign Emails To suppress graymail	campaignemails
campaignemails_type	TEXT	Campaign Emails Type	Campaign Emails Type	campaignemails
campaignemails_updated_at	TIMESTAMP	Campaign Emails Updated at	Campaign Emails Updated at	campaignemails
campaignemails_updated_by_id	TEXT	Campaign Emails Updated by id	Campaign Emails Updated by id	campaignemails
campaignemails_webversion_domain	TEXT	Campaign Emails Webversion domain	Campaign Emails Webversion domain	campaignemails
campaignemails_webversion_is_page_redirected	BOOLEAN	Campaign Emails Webversion is page redirected	Campaign Emails Webversion is page redirected	campaignemails
campaignemails_webversion_slug	TEXT	Campaign Emails Webversion slug	Campaign Emails Webversion slug	campaignemails
campaignemails_webversion_url	TEXT	Campaign Emails Webversion url	Campaign Emails Webversion url	campaignemails
channelaccounts_channel_id	TEXT	Channel Account Channel ID	The channel ID of the channel account.	channelaccounts
channelaccounts_created_at	TIMESTAMP	Channel Account CreatedAt	The creation time of the channel account.	channelaccounts
channelaccounts_id	TEXT	Channel Account ID	The ID of the channel account.	channelaccounts
channelaccounts_name	TEXT	Channel Account Name	The name of the channel account.	channelaccounts
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
company	TEXT	Contact Company Name (Alias)	Alias for contact_company	contact
company_about_us	TEXT	Company About Us	Short about-company	company
company_address	TEXT	Company Street Address	The street address of the company or organization, including unit number. Powered by HubSpot Insights.	company
company_address2	TEXT	Company Street Address 2	The additional address of the company or organization. Powered by HubSpot Insights.	company
company_annualrevenue	NUMERIC	Company Annual Revenue	The actual or estimated annual revenue of the company. Powered by HubSpot Insights.	company
company_city	CITY	Company City	The city where the company is located. Powered by HubSpot Insights.	company
company_closedate	TIMESTAMP	Company Close Date	The date the company or organization was closed as a customer	company
company_count	NUMERIC	Company count	Amount of companies	company
company_country	COUNTRY	Company Country/Region	The country/region in which the company or organization is located. Powered by HubSpot Insights.	company
company_createdate	TIMESTAMP	Company Create Date	The date the company or organization was added to the database	company
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
company_description	TEXT	Company Description	A short statement about the company's mission and goals. Powered by HubSpot Insights.	company
company_domain	TEXT	Company Domain Name	The domain name of the company or organization	company
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
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
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
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
company_facebook_company_page	TEXT	Company Facebook Company Page	The URL of the Facebook company page for the company or organization	company
company_facebookfans	NUMERIC	Company Facebook Fans	Number of facebook fans	company
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
company_first_conversion_date	TIMESTAMP	Company First Conversion Date	The first conversion date across all contacts associated this company or organization	company
company_first_conversion_event_name	TEXT	Company First Conversion	The first form submitted across all contacts associated this company or organization	company
company_first_deal_created_date	TIMESTAMP	Company First Deal Created Date	The create date of the first deal associated with this company record.	company
company_founded_year	TEXT	Company Year Founded	The year the company was created. Powered by HubSpot Insights.	company
company_googleplus_page	TEXT	Company Google Plus Page	The URL of the Google Plus page for the company or organization	company
company_hs_analytics_first_timestamp	TIMESTAMP	Company Time First Seen	The first activity for any contact associated with this company or organization	company
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
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
company_hs_analytics_last_timestamp	TIMESTAMP	Company Time Last Seen	Time last seen across all contacts associated with this company or organization	company
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
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
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
company_hs_analytics_num_visits	NUMERIC	Company Number of Sessions	Total number of sessions across all contacts associated with this company or organization	company
company_hs_analytics_source	TEXT	Company Original Source Type	Original source for the contact with the earliest activity for this company or organization	company
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
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
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
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
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
company_hs_last_booked_meeting_date	TIMESTAMP	Company Last Booked Meeting Date	The last date of booked meetings associated with the company	company
company_hs_last_logged_call_date	TIMESTAMP	Company Last Logged Call Date	The last date of logged calls associated with the company	company
company_hs_last_open_task_date	TIMESTAMP	Company Last Open Task Date	The last due date of open tasks associated with the company	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
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
company_hs_lead_status	TEXT	Company Lead Status	The company's sales, prospecting or outreach status	company
company_hs_num_blockers	NUMERIC	Company Number of blockers	The number of contacts associated with this company with the role of blocker.	company
company_hs_num_child_companies	NUMERIC	Company Number of child companies	The number of child companies of this company	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
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
company_hs_num_open_deals	NUMERIC	Company Number of open deals	The number of open deals associated with this company.	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
company_hs_parent_company_id	NUMERIC	Parent Company	The parent company of this company	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
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
company_hubspot_owner_assigneddate	TIMESTAMP	Company Owner Assigned Date	The timestamp when an owner was assigned to this company	company
company_hubspot_owner_id	TEXT	Company owner	The owner of the company	company
company_hubspot_team_id	TEXT	Company HubSpot Team	The team of the owner of the company.	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
company_is_public	BOOLEAN	Company Is Public	Indicates that the company is publicly traded. Powered by HubSpot Insights.	company
company_lifecyclestage	TEXT	Company Lifecycle Stage	The most advanced lifecycle stage across all contacts associated with this company or organization	company
company_linkedin_company_page	TEXT	LinkedIn Company Page	The URL of the LinkedIn company page for the company or organization	company
company_linkedinbio	TEXT	Company LinkedIn Bio	The LinkedIn bio for the company or organization	company
company_name	TEXT	Company Name (Duplicate)	The name of the company or organization. Powered by HubSpot Insights.	company
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
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
company_notes_next_activity_date	TIMESTAMP	Company Next Activity Date	The date of the next upcoming scheduled sales activity for this company record.	company
company_num_associated_contacts	NUMERIC	Company Associated Contacts	The number of contacts associated with this company	company
company_num_associated_deals	NUMERIC	Company Associated Deals	The number of deals associated with this company	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
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
company_numberofemployees	NUMERIC	Company Number of Employees	The total number of employees who work for the company or organization	company
company_owneremail	TEXT	Company HubSpot Owner Email	HubSpot owner email for this company or organization	company
company_ownername	TEXT	Company HubSpot Owner Name	HubSpot owner name for this company or organization	company
company_phone	TEXT	Company Phone Number	A company's primary phone number. Powered by HubSpot Insights.	company
company_recent_conversion_date	TIMESTAMP	Company Recent Conversion Date	The most recent conversion date across all contacts associated this company or organization	company
company_recent_conversion_event_name	TEXT	Company Recent Conversion	The last form submitted across all contacts associated this company or organization	company
company_recent_deal_amount	NUMERIC	Company Recent Deal Amount	The amount of the last deal closed	company
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
company_state	REGION	Company State/Region	The state or region in which the company or organization is located. Powered by HubSpot Insights.	company
company_timezone	TEXT	Company Time Zone	The time zone where the company or organization is located. Powered by HubSpot Insights.	company
company_total_money_raised	TEXT	Company Total Money Raised	The total amount of money raised by the company. Powered by HubSpot Insights.	company
company_total_revenue	NUMERIC	Company Total Revenue	The total amount of closed won deals	company
company_twitterbio	TEXT	Company Twitter Bio	The Twitter bio of the company or organization	company
company_twitterfollowers	NUMERIC	Company Twitter Followers	The number of Twitter followers of the company or organization	company
company_twitterhandle	TEXT	Company Twitter Handle	The main twitter account of the company or organization	company
company_type	TEXT	Company Type	The optional classification of this company record - prospect, partner, etc.	company
company_web_technologies	TEXT	Company Web Technologies	The web technologies used by the company or organization. Powered by HubSpot Insights.	company
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
company_zip	TEXT	Company Postal Code	The postal or zip code of the company or organization. Powered by HubSpot Insights.	company
contact_address	TEXT	Contact Street Address	A contact's street address, including apartment or unit #	contact
contact_annualrevenue	TEXT	Contact Annual Revenue	Annual company revenue	contact
contact_city	CITY	Contact City	A contact's city of residence	contact
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
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
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
contact_count	NUMERIC	Contact count	Amount of contacts	contact
contact_country	COUNTRY	Contact Country/Region	The contact's country/region of residence. This might be set via import, form, or integration.	contact
contact_createdate	TIMESTAMP	Contact Create Date	The date that a contact entered the system	contact
contact_currentlyinworkflow	TEXT	Contact Currently in workflow	If the contact is currently enrolled in any workflow	contact
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
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
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
contact_email	TEXT	Contact Email	A contact's email address	contact
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
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
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
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
contact_fax	TEXT	Contact Fax Number	A contact's primary fax number	contact
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
contact_first_conversion_date	TIMESTAMP	Contact First Conversion Date	The date this contact first submitted a form	contact
contact_first_conversion_event_name	TEXT	Contact First Conversion	The first form this contact submitted	contact
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
contact_firstname	TEXT	Contact First Name	A contact's first name	contact
contact_followercount	NUMERIC	Contact Follower Count	The number of Twitter followers a contact has	contact
contact_gender	TEXT	Contact Gender		contact
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
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
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
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
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
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
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
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
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
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
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
contact_hs_analytics_last_visit_timestamp	TIMESTAMP	Contact time of Last Session	The last time and date a contact visited your website.	contact
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.	contact
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
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
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
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
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
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
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
contact_hs_content_membership_email_confirmed	BOOLEAN	Contact Email Confirmed	Email Confirmation status of user of Content Membership	contact
contact_hs_content_membership_notes	TEXT	Contact Membership Notes	The notes relating to the contact's content membership.	contact
contact_hs_content_membership_registered_at	TIMESTAMP	Contact Registered At	Datetime at which this user was set up for Content Membership	contact
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
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
contact_hs_content_membership_status	TEXT	Contact Status	The status of the contact's content membership.	contact
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
contact_hs_email_bad_address	BOOLEAN	Contact Invalid email address	The email address associated with this contact is invalid.	contact
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
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
contact_hs_email_customer_quarantined_reason	TEXT	Contact Email address quarantine reason	The reason why the email address has been quarantined.	contact
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
contact_hs_email_domain	TEXT	Contact Email Domain	A contact's email address domain	contact
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
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
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
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
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
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
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
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
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
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
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
contact_hs_email_optout	BOOLEAN	Contact Unsubscribed from all email	Indicates that the current email address has opted out of all email.	contact
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
contact_hs_email_quarantined_reason	TEXT	Contact Email address automated quarantine reason	The automated reason why the email address has been quarantined.	contact
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
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
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
contact_hs_facebook_click_id	TEXT	Contact Facebook click id		contact
contact_hs_feedback_last_nps_follow_up	TEXT	Contact Last NPS survey comment	Last NPS survey comment that this contact gave	contact
contact_hs_feedback_last_nps_rating	TEXT	Contact Last NPS survey rating	Last NPS survey rating that this contact gave	contact
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
contact_hs_google_click_id	TEXT	Contact Google ad click id		contact
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
contact_hs_is_unworked	BOOLEAN	Contact unworked	Contact has not been assigned or has not been engaged after last owner assignment/re-assignment	contact
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
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
contact_hs_latest_sequence_ended_date	TIMESTAMP	Contact Last sequence ended date	The last sequence ended date.	contact
contact_hs_latest_sequence_enrolled	NUMERIC	Contact Last sequence enrolled	The last sequence enrolled.	contact
contact_hs_latest_sequence_enrolled_date	TIMESTAMP	Contact Last sequence enrolled date	The last sequence enrolled date.	contact
contact_hs_lead_status	TEXT	Contact Lead Status	The contact's sales, prospecting or outreach status	contact
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
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
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
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
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
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
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
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
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
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
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
contact_hs_marketable_status	TEXT	Contact Marketing contact status	The marketing status of a contact	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
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
contact_hs_persona	TEXT	Contact Persona	A contact's persona	contact
contact_hs_predictivecontactscore	NUMERIC	Contact Predictive Lead Score	A score calculated by HubSpot that represents a contact's likelihood to become a customer	contact
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
contact_hs_predictivecontactscorebucket	TEXT	Contact Lead Rating	The rating of this contact based on their predictive lead score	contact
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
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
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
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
contact_hs_sequences_enrolled_count	NUMERIC	Contact Number of sequences enrolled	The number of sequences enrolled.	contact
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
contact_hs_social_facebook_clicks	NUMERIC	Contact Facebook Clicks	The number clicks on links shared on Facebook	contact
contact_hs_social_google_plus_clicks	NUMERIC	Contact Google Plus Clicks	The number clicks on links shared on Google Plus	contact
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
contact_hs_social_linkedin_clicks	NUMERIC	Contact LinkedIn Clicks	The number clicks on links shared on LinkedIn	contact
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
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.	contact
contact_hs_time_between_contact_creation_and_deal_close	NUMERIC	Contact Time between contact creation and deal close		contact
contact_hs_time_between_contact_creation_and_deal_creation	NUMERIC	Contact Time between contact creation and deal creation		contact
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
contact_hubspot_team_id	TEXT	Contact HubSpot Team	The team of the owner of a contact.	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
contact_industry	TEXT	Contact Industry	The industry a contact is in	contact
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
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
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
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.	contact
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
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
contact_jobtitle	TEXT	Contact Job Title	A contact's job title	contact
contact_kloutscoregeneral	NUMERIC	Contact Klout Score	A contact's Klout score, a measure of Internet influence	contact
contact_lastmodifieddate	TIMESTAMP	Contact Last Modified Date	The date any property on this contact was modified	contact
contact_lastname	TEXT	Contact Last Name	A contact's last name	contact
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
contact_linkedinbio	TEXT	Contact LinkedIn Bio	A contact's LinkedIn bio	contact
contact_linkedinconnections	NUMERIC	Contact LinkedIn Connections	How many LinkedIn connections they have	contact
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
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
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
contact_mobilephone	TEXT	Contact Mobile Phone Number	A contact's mobile phone number	contact
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
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
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
contact_num_associated_deals	NUMERIC	Contact Associated Deals	The number of deals associated with this contact. This is set automatically by HubSpot.	contact
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
contact_num_conversion_events	NUMERIC	Contact Number of Form Submissions	The number of forms this contact has submitted	contact
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
contact_num_unique_conversion_events	NUMERIC	Contact Number of Unique Forms Submitted	The number of different forms this contact has submitted	contact
contact_numemployees	TEXT	Contact Number of Employees	The number of company employees	contact
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
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
contact_phone	TEXT	Contact Phone Number	A contact's primary phone number	contact
contact_recent_conversion_date	TIMESTAMP	Contact Recent Conversion Date	The date this contact last submitted a form	contact
contact_recent_conversion_event_name	TEXT	Contact Recent Conversion	The last form this contact submitted	contact
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
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
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
contact_sales_status	TEXT	Sales Status	Sales status	contact
contact_salutation	TEXT	Contact Salutation	The title used to address a contact	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
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
contact_source	TEXT	Contact Source	The contact source	contact
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
contact_state	REGION	Contact State/Region	The contact's state of residence. This might be set via import, form, or integration.	contact
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
contact_twitterbio	TEXT	Contact Twitter Bio	The contact's Twitter bio. This is set by HubSpot using the contact's email address.	contact
contact_twitterhandle	TEXT	Contact Twitter Username	The contact's Twitter handle. This is set by HubSpot using the contact's email address.	contact
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
contact_type	TEXT	Contact Type	The contact type	contact
contact_website	TEXT	Contact Website URL	The contact's company website	contact
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
contact_zip	TEXT	Contact Postal Code	The contact's zip code. This might be set via import, form, or integration.	contact
createddate	TIMESTAMP	Created Date	Alias for contact_createdate	contact
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
customobject_count	NUMERIC	Custom Object count	Amount of custom objects	custom_object
customobject_createdat	TIMESTAMP	Custom Object Created at	The date the custom object was created.	custom_object
customobject_description	TEXT	Custom Object Description	The custom object description.	custom_object
customobject_display_order	TEXT	Custom Object Display Order	The custom object display order.	custom_object
customobject_field_type	TEXT	Custom Object Field Type	The custom object field type	custom_object
customobject_group_name	TEXT	Custom Object Group Name	The custom object group name.	custom_object
customobject_hidden	BOOLEAN	Custom Object Hidden	The custom object is hiddnen or not.	custom_object
customobject_id	TEXT	Custom Object ID	The custom object type ID.	custom_object
customobject_label	TEXT	Custom Object Label	The custom object label.	custom_object
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.	custom_object
customobject_property_name	TEXT	Custom object property name	Name of the custom object properties (fields).	custom_object
customobject_type	TEXT	Custom Object Type	The custom object type.	custom_object
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.	custom_object
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
deal_amount	NUMERIC	Deal Amount	The total amount of the deal	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
deal_closed_lost_reason	TEXT	Deal Closed Lost Reason	Reason why this deal was lost	deal
deal_closed_won_reason	TEXT	Deal Closed Won Reason	Reason why this deal was won	deal
deal_closedate	TIMESTAMP	Deal Close Date	The expected close date of the deal	deal
deal_count	NUMERIC	Deal count	Amount of deals	deal
deal_createdate	TIMESTAMP	Deal Create Date	The date the deal was created. This property is set automatically by HubSpot.	deal
deal_currency_code	TEXT	Deal Currency	Currency code for the deal.	deal
deal_dealname	TEXT	Deal Name	The name given to this deal.	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.	deal
deal_dealtype	TEXT	Deal Type	The type of deal. By default, categorize your deal as either a New Business or Existing Business.	deal
deal_description	TEXT	Deal Description	Description of the deal	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
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
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
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
deal_hs_acv	NUMERIC	Deal Annual contract value	The annual contract value (ACV) of this deal.	deal
deal_hs_analytics_source	TEXT	Deal Original Source Type	Original source for the contact with the earliest activity for this deal.	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
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
deal_hs_arr	NUMERIC	Deal Annual recurring revenue	The annual recurring revenue (ARR) of this deal.	deal
deal_hs_forecast_amount	NUMERIC	Deal Forecast Amount	The forecasted deal value calculated by multiplying the forecast probability and deal amount	deal
deal_hs_forecast_probability	NUMERIC	Deal Forecast Probability	The percent probability the deal will close, expressed as a decimal.	deal
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
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
deal_hs_mrr	NUMERIC	Deal Monthly recurring revenue	The monthly recurring revenue (MRR) of this deal.	deal
deal_hs_next_step	TEXT	Deal Next step	A short description of the next step for the deal	deal
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
deal_hs_priority	TEXT	Deal Priority		deal
deal_hs_tcv	NUMERIC	Deal Total contract value	The total contract value (TCV) of this deal.	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
deal_hubspot_owner_id	TEXT	Deal Owner ID	The owner of the deal	deal
deal_hubspot_team_id	TEXT	Deal HubSpot Team	The team of the owner of the deal.	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
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
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
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
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
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
deal_pipeline	TEXT	Deal Pipeline	The pipeline the deal is in. This determines which stages are options for the deal.	deal
email	TEXT	Email	Alias for contact_email	contact
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
email_clicked	NUMERIC	Email engagement clicks	The recipient clicked on a link within the message.	email
email_clicked_on_link	NUMERIC	Email engagement click on identified link	The recipient click on identified link in the email.	email
email_count	NUMERIC	Email count	Amount of emails	email
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
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
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
email_errored	NUMERIC	Email engagement error		email
email_event_created	TIMESTAMP	Email engagement timestamp	Email engagement timestamp	email
email_forwarded	NUMERIC	Email engagement forwarded	The recipient forwarded the email.	email
email_id	TEXT	Email ID	Email ID	email
email_mta_dropped	NUMERIC	Email engagement mta dropped		email
email_opened	NUMERIC	Email engagement opened	The recipient opened the message.	email
email_optinchange	NUMERIC	Email engagement spam opt in change		email
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
email_recipient	TEXT	Email recipient	Email recipient	email
email_replied	NUMERIC	Email engagement replied	The recipient replied to the email.	email
email_selected	NUMERIC	Email engagement selected		email
email_sent	NUMERIC	Email engagement sent	The message was sent to and received by our delivery provider.	email
email_spamreported	NUMERIC	Email engagement spam reported	The recipient flagged the message as spam.	email
email_statuschange	NUMERIC	Email engagement status changed	The recipient changed their email subscriptions in some way.	email
email_suppressed	NUMERIC	Email engagement suppressed	The message was not sent, the recipient has been unengaged with previous marketing emails.	email
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
email_unsubscribed	NUMERIC	Email engagement unsubscribed	The recipient unsubscribed from subscription.	email
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
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
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
emailstats_aggregations_counters_delivered	NUMERIC	Emailstats Aggregations Counters Delivered	The number of emails succesfully delivered to an inbox	emailstats
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
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
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
emailstats_aggregations_counters_open	NUMERIC	Emailstats Aggregations Counters Open	The total number of unique opens	emailstats
emailstats_aggregations_counters_pending	NUMERIC	Emailstats Aggregations Counters Pending	The number of emails still trying to reach a contact's inbox.	emailstats
emailstats_aggregations_counters_reply	NUMERIC	Emailstats Aggregations Counters Reply	Emails Stats Counters Reply	emailstats
emailstats_aggregations_counters_selected	NUMERIC	Emailstats Aggregations Counters Selected	The number of contacts selected to receive this email.	emailstats
emailstats_aggregations_counters_sent	NUMERIC	Emailstats Aggregations Counters Sent	The total number of sent emails	emailstats
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
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
emailstats_aggregations_counters_suppressed	NUMERIC	Emailstats Aggregations Counters Suppressed	The number of contacts that did not receive your email due to graymail suppression.	emailstats
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
emailstats_aggregations_devicebreakdown_click_device_type_computer	NUMERIC	Emailstats Aggregations Devicebreakdown Click Device Type Computer	Click broken down by device type computer.	emailstats
emailstats_aggregations_devicebreakdown_click_device_type_mobile	NUMERIC	Emailstats Aggregations Devicebreakdown Click Device Type Mobile	Click broken down by device type mobile.	emailstats
emailstats_aggregations_devicebreakdown_click_device_type_unknown	NUMERIC	Emailstats Aggregations Devicebreakdown Click Device Type Unknown	Click broken down by device type unknown.	emailstats
emailstats_aggregations_devicebreakdown_open_device_type_computer	NUMERIC	Emailstats Aggregations Devicebreakdown Open Device Type Computer	Open broken down by device type computer.	emailstats
emailstats_aggregations_devicebreakdown_open_device_type_mobile	NUMERIC	Emailstats Aggregations Devicebreakdown Open Device Type Mobile	Open broken down by device type mobile.	emailstats
emailstats_aggregations_devicebreakdown_open_device_type_unknown	NUMERIC	Emailstats Aggregations Devicebreakdown Open Device Type Unknown	Open broken down by device type unknown.	emailstats
emailstats_aggregations_qualifierstats	NUMERIC	Emailstats Aggregations Qualifierstats	Emailstats Aggregations Qualifiers	emailstats
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
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
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
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
emailstats_aggregations_ratios_deliveredratio	PERCENT	Emailstats Aggregations Ratios Deliveredratio	The number of succesfull deliveries over the number of selected contacts.	emailstats
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
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
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
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
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
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
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
emailstats_aggregations_ratios_unsubscribedratio	PERCENT	Emailstats Aggregations Ratios Unsubscribedratio	the number of contacts that have unsubscribed over the total number of selected contacts	emailstats
emailstats_interval_end	TIMESTAMP	Emailstats Interval End	End of the daily interval.	emailstats
emailstats_interval_start	TIMESTAMP	Emailstats Interval Start	Start of the daily interval.	emailstats
firstname	TEXT	First Name	Alias for contact_firstname	contact
formanalytics_clickthroughperformview	PERCENT	Form Analytics Click Through Per Form View	Form Analytics Click Through Per Form View	Form Analytics
formanalytics_contactsubmissions	NUMERIC	Form Analytics Contact Submissions	Form Analytics Contact Submissions	Form Analytics
formanalytics_date	DATE	Form Analytics Date	Date of the Form Analytics	Form Analytics
formanalytics_form_id	TEXT	Form Analytics Form ID	Form Analytics Form ID	Form Analytics
formanalytics_formviews	NUMERIC	Form Analytics Form Views	Form Analytics Form Views	Form Analytics
formanalytics_interactions	NUMERIC	Form Analytics Interactions	Form Analytics Interactions	Form Analytics
formanalytics_noncontactsubmissions	NUMERIC	Form Analytics Non Contact Submissions	Form Analytics Non Contact Submissions	Form Analytics
formanalytics_submissions	NUMERIC	Form Analytics Submissions	Form Analytics Submissions	Form Analytics
formanalytics_submissionsperclickthrough	PERCENT	Form Analytics Submissions Per Click Through	Form Analytics Submissions Per Click Through	Form Analytics
formanalytics_submissionsperformview	PERCENT	Form Analytics Submissions Per Form View	Form Analytics Submissions Per Form View	Form Analytics
formanalytics_visibles	NUMERIC	Form Analytics Visibles	Form Analytics Visibles	Form Analytics
forms_archived	BOOLEAN	Forms Archived	Whether this form is archived	forms
forms_count	NUMERIC	Forms count	Amount of Forms	forms
forms_createdat	TIMESTAMP	Forms Created Timestamp	When this form was created	forms
forms_defaultvalue	TEXT	Forms Form Field Default Value	Default Value for this form field	forms
forms_description	TEXT	Forms Form description	Form description	forms
forms_field_name	TEXT	Forms Form Field Name	Forms Form Field Name	forms
forms_fieldtype	TEXT	Forms Form Field Type	Forms Form Field Type	forms
forms_formtype	TEXT	Forms Form Type	Forms Form Type	forms
forms_grouptype	TEXT	Forms Form Group Type	Forms Form Group Type	forms
forms_hidden	BOOLEAN	Forms hidden	Whether this form is hidden	forms
forms_id	TEXT	Forms Form ID	ID of this form	forms
forms_label	TEXT	Forms Form Field Label	Forms Form Field Label	forms
forms_name	TEXT	Forms Form Name	Form Name	forms
forms_objecttypeid	TEXT	Forms Form Object Type ID	Forms Form Object Type ID	forms
forms_placeholder	TEXT	Forms Form Field Placeholder	Forms Form Field Placeholder	forms
forms_required	BOOLEAN	Forms Form Field Required	Forms Form Field Required	forms
forms_richtexttype	TEXT	Forms Form Rich Text Type	Forms Form Rich Text Type	forms
forms_updatedat	TIMESTAMP	Forms Updated Timestamp	When this form was updated	forms
forms_usecountrycodeselect	TEXT	Forms Form Use Country Code Select	Forms Form Use Country Code Select	forms
forms_validation_maxalloweddigits	TEXT	Forms Forms Form Field Maximum Allowed Digits	Forms Form Field Maximum Allowed Digits	forms
forms_validation_minalloweddigits	TEXT	Forms Forms Form Field Minimum Allowed Digits	Forms Forms Form Field Minimum Allowed Digits	forms
forms_validation_usedefaultblocklist	BOOLEAN	Forms Form Validation Use Default Block List	Forms Form Validation Use Default Block List	forms
lastname	TEXT	Last Name	Alias for contact_lastname	contact
lifecyclestage	TEXT	Lifecycle Stage	Alias for contact_lifecyclestage	contact
marketingemail_ab	TEXT	ab	ab	marketingemail
marketingemail_abhourstowait	TEXT	abHoursToWait	abHoursToWait	marketingemail
marketingemail_absamplesizedefault	TEXT	abSampleSizeDefault	abSampleSizeDefault	marketingemail
marketingemail_absamplingdefault	TEXT	abSamplingDefault	abSamplingDefault	marketingemail
marketingemail_absoluteurl	TEXT	absoluteUrl	absoluteUrl	marketingemail
marketingemail_absuccessmetric	TEXT	abSuccessMetric	abSuccessMetric	marketingemail
marketingemail_abtestpercentage	TEXT	abTestPercentage	abTestPercentage	marketingemail
marketingemail_abvariation	TEXT	abVariation	abVariation	marketingemail
marketingemail_allemailcampaignids	TEXT	allEmailCampaignIds	allEmailCampaignIds	marketingemail
marketingemail_analyticspageid	TEXT	analyticsPageId	analyticsPageId	marketingemail
marketingemail_analyticspagetype	TEXT	analyticsPageType	analyticsPageType	marketingemail
marketingemail_archivedat	TEXT	archivedAt	archivedAt	marketingemail
marketingemail_archivedindashboard	TEXT	archivedInDashboard	archivedInDashboard	marketingemail
marketingemail_audienceaccess	TEXT	audienceAccess	audienceAccess	marketingemail
marketingemail_author	TEXT	author	author	marketingemail
marketingemail_authorname	TEXT	authorName	authorName	marketingemail
marketingemail_blogrsssettings	TEXT	blogRssSettings	blogRssSettings	marketingemail
marketingemail_canspamsettingsid	TEXT	canSpamSettingsId	canSpamSettingsId	marketingemail
marketingemail_categoryid	TEXT	categoryId	categoryId	marketingemail
marketingemail_contentaccessruleids	TEXT	contentAccessRuleIds	contentAccessRuleIds	marketingemail
marketingemail_contentaccessruletypes	TEXT	contentAccessRuleTypes	contentAccessRuleTypes	marketingemail
marketingemail_contenttypecategory	TEXT	contentTypeCategory	contentTypeCategory	marketingemail
marketingemail_count	NUMERIC	Marketing Email count	Amount of Marketing Emails	marketingemail
marketingemail_created	TIMESTAMP	created	created	marketingemail
marketingemail_createdbyid	TEXT	createdById	createdById	marketingemail
marketingemail_createpage	TEXT	createPage	createPage	marketingemail
marketingemail_currentlypublished	TEXT	currentlyPublished	currentlyPublished	marketingemail
marketingemail_currentstate	TEXT	currentState	currentState	marketingemail
marketingemail_customreplyto	TEXT	customReplyTo	customReplyTo	marketingemail
marketingemail_customreplytoenabled	TEXT	customReplyToEnabled	customReplyToEnabled	marketingemail
marketingemail_domain	TEXT	domain	domain	marketingemail
marketingemail_emailbody	TEXT	emailBody	emailBody	marketingemail
marketingemail_emailcampaigngroupid	TEXT	emailCampaignGroupId	emailCampaignGroupId	marketingemail
marketingemail_emailnote	TEXT	emailNote	emailNote	marketingemail
marketingemail_emailtemplatemode	TEXT	emailTemplateMode	emailTemplateMode	marketingemail
marketingemail_emailtype	TEXT	emailType	emailType	marketingemail
marketingemail_feedbacksurveyid	TEXT	feedbackSurveyId	feedbackSurveyId	marketingemail
marketingemail_flexareas	TEXT	flexAreas	flexAreas	marketingemail
marketingemail_freezedate	TIMESTAMP	freezeDate	freezeDate	marketingemail
marketingemail_fromname	TEXT	fromName	fromName	marketingemail
marketingemail_hascontentaccessrules	TEXT	hasContentAccessRules	hasContentAccessRules	marketingemail
marketingemail_htmltitle	TEXT	htmlTitle	htmlTitle	marketingemail
marketingemail_id	TEXT	id	id	marketingemail
marketingemail_iscreatedfomsandboxsync	TEXT	isCreatedFomSandboxSync	isCreatedFomSandboxSync	marketingemail
marketingemail_isgraymailsuppressionenabled	TEXT	isGraymailSuppressionEnabled	isGraymailSuppressionEnabled	marketingemail
marketingemail_isinstancelayoutpage	TEXT	isInstanceLayoutPage	isInstanceLayoutPage	marketingemail
marketingemail_ispublished	TEXT	isPublished	isPublished	marketingemail
marketingemail_isrecipientfatiguesuppressionenabled	TEXT	isRecipientFatigueSuppressionEnabled	isRecipientFatigueSuppressionEnabled	marketingemail
marketingemail_language	TEXT	language	language	marketingemail
marketingemail_layoutsections	TEXT	layoutSections	layoutSections	marketingemail
marketingemail_livedomain	TEXT	liveDomain	liveDomain	marketingemail
marketingemail_mailinglistsexcluded	TEXT	mailingListsExcluded	mailingListsExcluded	marketingemail
marketingemail_mailinglistsincluded	TEXT	mailingListsIncluded	mailingListsIncluded	marketingemail
marketingemail_maxrssentries	TEXT	maxRssEntries	maxRssEntries	marketingemail
marketingemail_metadescription	TEXT	metaDescription	metaDescription	marketingemail
marketingemail_name	TEXT	name	name	marketingemail
marketingemail_pageexpiryenabled	TEXT	pageExpiryEnabled	pageExpiryEnabled	marketingemail
marketingemail_pageredirected	TEXT	pageRedirected	pageRedirected	marketingemail
marketingemail_pastmabexperimentids	TEXT	pastMabExperimentIds	pastMabExperimentIds	marketingemail
marketingemail_portalid	TEXT	portalId	portalId	marketingemail
marketingemail_previewkey	TEXT	previewKey	previewKey	marketingemail
marketingemail_primaryemailcampaignid	TEXT	primaryEmailCampaignId	primaryEmailCampaignId	marketingemail
marketingemail_primaryrichtextmodulehtml	TEXT	primaryRichTextModuleHtml	primaryRichTextModuleHtml	marketingemail
marketingemail_processingstatus	TEXT	processingStatus	processingStatus	marketingemail
marketingemail_publishdate	TIMESTAMP	publishDate	publishDate	marketingemail
marketingemail_publishedat	TEXT	publishedAt	publishedAt	marketingemail
marketingemail_publishedbyemail	TEXT	publishedByEmail	publishedByEmail	marketingemail
marketingemail_publishedbyid	TEXT	publishedById	publishedById	marketingemail
marketingemail_publishedbyname	TEXT	publishedByName	publishedByName	marketingemail
marketingemail_publishedurl	TEXT	publishedUrl	publishedUrl	marketingemail
marketingemail_replyto	TEXT	replyTo	replyTo	marketingemail
marketingemail_resolveddomain	TEXT	resolvedDomain	resolvedDomain	marketingemail
marketingemail_rssemailbytext	TEXT	rssEmailByText	rssEmailByText	marketingemail
marketingemail_rssemailclickthroughtext	TEXT	rssEmailClickThroughText	rssEmailClickThroughText	marketingemail
marketingemail_rssemailcommenttext	TEXT	rssEmailCommentText	rssEmailCommentText	marketingemail
marketingemail_rssemailentrytemplateenabled	TEXT	rssEmailEntryTemplateEnabled	rssEmailEntryTemplateEnabled	marketingemail
marketingemail_rssemailimagemaxwidth	TEXT	rssEmailImageMaxWidth	rssEmailImageMaxWidth	marketingemail
marketingemail_rssemailurl	TEXT	rssEmailUrl	rssEmailUrl	marketingemail
marketingemail_scrubssubscriptionlinks	TEXT	scrubsSubscriptionLinks	scrubsSubscriptionLinks	marketingemail
marketingemail_sections	TEXT	sections	sections	marketingemail
marketingemail_securitystate	TEXT	securityState	securityState	marketingemail
marketingemail_slug	TEXT	slug	slug	marketingemail
marketingemail_smartemailfields	TEXT	smartEmailFields	smartEmailFields	marketingemail
marketingemail_state	TEXT	state	state	marketingemail
marketingemail_stylesettings	TEXT	styleSettings	styleSettings	marketingemail
marketingemail_subcategory	TEXT	subcategory	subcategory	marketingemail
marketingemail_subject	TEXT	subject	subject	marketingemail
marketingemail_subscription	TEXT	subscription	subscription	marketingemail
marketingemail_subscriptionname	TEXT	subscriptionName	subscriptionName	marketingemail
marketingemail_teamperms	TEXT	teamPerms	teamPerms	marketingemail
marketingemail_templatepath	TEXT	templatePath	templatePath	marketingemail
marketingemail_transactional	TEXT	transactional	transactional	marketingemail
marketingemail_translations	TEXT	translations	translations	marketingemail
marketingemail_unpublishedat	TEXT	unpublishedAt	unpublishedAt	marketingemail
marketingemail_updated	TIMESTAMP	updated	updated	marketingemail
marketingemail_updatedbyid	TEXT	updatedById	updatedById	marketingemail
marketingemail_url	TEXT	url	url	marketingemail
marketingemail_userperms	TEXT	userPerms	userPerms	marketingemail
marketingemail_userssheadlineassubject	TEXT	useRssHeadlineAsSubject	useRssHeadlineAsSubject	marketingemail
marketingemail_vidsexcluded	TEXT	vidsExcluded	vidsExcluded	marketingemail
marketingemail_vidsincluded	TEXT	vidsIncluded	vidsIncluded	marketingemail
marketingemail_visibletoall	TEXT	visibleToAll	visibleToAll	marketingemail
meetings_count	NUMERIC	Meetings count	Amount of Meetings	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
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
meetings_hs_createdate	TIMESTAMP	Meetings Create Date	Created date for the meeting.	meetings
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
meetings_hs_meeting_body	TEXT	Meetings Hubspot Meeting Body	The meeting description.	meetings
meetings_hs_meeting_end_time	TIMESTAMP	Meetings Hubspot Meeting End Time	The date and time when the meeting ends.	meetings
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
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
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
meetings_hs_meeting_title	TEXT	Meetings Hs Meeting Title	The title of the meeting.	meetings
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
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
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.	meetings
month	TEXT	Month	Number of the month
owner_archived	TEXT	Owner Archived	Owner Archived	owner
owner_count	NUMERIC	Owner count	Amount of owners	owner
owner_created_at	TIMESTAMP	Owner Created At	Owner Created At	owner
owner_email	TEXT	Owner Email	Owner Email	owner
owner_first_name	TEXT	Owner First Name	Owner First Name	owner
owner_last_name	TEXT	Owner Last Name	Owner Last Name	owner
owner_owner_id	TEXT	Owner Id	Owner Id	owner
owner_updated_at	TIMESTAMP	Owner Updated At	Owner Updated At	owner
owner_user_id	TEXT	Owner User Id	Owner User Id	owner
phone	TEXT	Phone Number	Alias for contact_phone	contact
pipeline_count	NUMERIC	Pipeline count	Amount of pipelines	pipeline
pipeline_id	TEXT	Pipeline ID	Pipeline ID	pipeline
pipeline_name	TEXT	Pipeline Name	Pipeline name	pipeline
pipeline_stage_created_at	TIMESTAMP	Pipeline Stage Created Date	The timestamp that specifies when the stage was created	pipeline
pipeline_stage_display_order	NUMERIC	Pipeline Stage Display Order Number	Stage display order number	pipeline
pipeline_stage_id	TEXT	Pipeline Stage ID	Stage ID	pipeline
pipeline_stage_is_archived	BOOLEAN	Pipeline Is Stage Archived	Is stage archived	pipeline
pipeline_stage_is_closed	BOOLEAN	Pipeline Is Closed	Is deal closed	pipeline
pipeline_stage_name	TEXT	Pipeline Stage Name	Stage name	pipeline
pipeline_stage_probability	TEXT	Pipeline Probablity	Deal probability	pipeline
pipeline_stage_updated_at	TIMESTAMP	Pipeline Stage Last Modified Date	The timestamp that specifies when the stage was modified	pipeline
source	TEXT	Source	The name of the Windsor connector returning the row
tickets_closed_date	TIMESTAMP	Close date	The date the ticket was closed	tickets
tickets_content	TEXT	Ticket description	Description of the ticket	tickets
tickets_count	NUMERIC	Tickets count	Amount of Tickets	tickets
tickets_created_by	TEXT	Created by	VID of contact that created the ticket	tickets
tickets_createdate	TIMESTAMP	Create date	The date the ticket was created	tickets
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
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
tickets_hs_all_assigned_business_unit_ids	TEXT	Business units	The business units this record is assigned to.	tickets
tickets_hs_all_associated_contact_companies	TEXT	All associated contact companies	All associated contact companies	tickets
tickets_hs_all_associated_contact_emails	TEXT	All associated contact emails	All associated contact emails	tickets
tickets_hs_all_associated_contact_firstnames	TEXT	All associated contact first names	All associated contact first names	tickets
tickets_hs_all_associated_contact_lastnames	TEXT	All associated contact last names	All associated contact last names	tickets
tickets_hs_all_associated_contact_mobilephones	TEXT	All associated contact mobile phones	All associated contact mobile phones	tickets
tickets_hs_all_associated_contact_phones	TEXT	All associated contact phones	All associated contact phones	tickets
tickets_hs_all_conversation_mentions	TEXT	All conversation mentions	All mentioned users on the associated conversations	tickets
tickets_hs_all_owner_ids	TEXT	All owner ids	The value of all owner referencing properties for this object, both default and custom	tickets
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
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
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
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
tickets_hs_assignment_method	TEXT	Assignment Method	defines how the Object Assignment is done	tickets
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
tickets_hs_conversations_originating_message_id	TEXT	Originating Conversations Message Id	Conversations Message Id of the message that originated this ticket	tickets
tickets_hs_conversations_originating_thread_id	TEXT	Conversations originating thread id	Thread that this ticket was originally created for	tickets
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
tickets_hs_createdate	TIMESTAMP	HubSpot create date	Internal read-only property representing the date the ticket was created in HubSpot	tickets
tickets_hs_custom_inbox	TEXT	Custom inbox ID	ID of the custom inbox the ticket is associated with	tickets
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
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
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
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
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
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
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
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
tickets_hs_email_subject	TEXT	Email subject	Email subject	tickets
tickets_hs_external_object_ids	TEXT	External object ids	Unique ids corresponding to tickets in a system outside of HubSpot	tickets
tickets_hs_feedback_last_ces_follow_up	TEXT	Last CES survey comment	Last CES survey comment that this contact gave for this ticket	tickets
tickets_hs_feedback_last_ces_rating	TEXT	Last CES survey rating	Last CES survey rating that this contact gave for this ticket	tickets
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.	tickets
tickets_hs_file_upload	TEXT	File upload	Files attached to a support form by a contact.	tickets
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
tickets_hs_helpdesk_sort_timestamp	TIMESTAMP	Helpdesk Sort Timestamp	A calculated property to help with sorting in the Helpdesk	tickets
tickets_hs_in_helpdesk	TEXT	In Help Desk	Is this Ticket rendered in the Help Desk	tickets
tickets_hs_inbox_id	TEXT	Inbox ID	Inbox the ticket is in	tickets
tickets_hs_is_latest_message_failed	TEXT	Is latest message failed	Is latest message failed	tickets
tickets_hs_is_visible_in_help_desk	TEXT	Is Visible in Help desk	Whether the ticket is visible in help desk	tickets
tickets_hs_last_email_activity	TEXT	Last email activity	The type of the last email activity with the contact associated with the ticket.	tickets
tickets_hs_last_email_date	TIMESTAMP	Last email date	The date of the last email activity with the contact associated with the ticket.	tickets
tickets_hs_last_message_from_visitor	TIMESTAMP	Last message from visitor	Whether the last message came from visitor	tickets
tickets_hs_last_message_received_at	TIMESTAMP	Last message received date	The date of the last response from the visitor	tickets
tickets_hs_last_message_sent_at	TIMESTAMP	Last response date	The date of the last response from an agent or bot	tickets
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
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
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
tickets_hs_latest_message_attachment_types	TEXT	Latest message attachment types	List of attachment types from the latest message	tickets
tickets_hs_latest_message_is_forwarded_email	TEXT	Latest message is forwarded email	Is latest message a forwarded email	tickets
tickets_hs_latest_message_is_thread_comment	TEXT	Latest message is thread comment	Is latest message a thread comment	tickets
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
tickets_hs_latest_message_text	TEXT	Latest Message Text	Latest message text (truncated)	tickets
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
tickets_hs_most_relevant_sla_status	TEXT	Most relevant SLA status	Most relevant sla status	tickets
tickets_hs_most_relevant_sla_type	TEXT	Most Relevant SLA Type	Most relevant SLA type between Close By, First Response, Next Response	tickets
tickets_hs_msteams_message_id	TEXT	Microsoft Teams message ID for this ticket.	Microsoft Teams message ID for this ticket.	tickets
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
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
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
tickets_hs_num_associated_companies	TEXT	Number of Associated Companies	Number of companies associated with this ticket	tickets
tickets_hs_num_associated_conversations	TEXT	Number of Associated Conversations	Number of conversations associated to the ticket	tickets
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
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
tickets_hs_object_source	TEXT	Record Creation Source	Source (PropertySource) that created this object record	tickets
tickets_hs_object_source_detail_1	TEXT	Record Source Detail 1	First level of detail on how this record was created	tickets
tickets_hs_object_source_detail_2	TEXT	Record Source Detail 2	Second level of detail on how this record was created	tickets
tickets_hs_object_source_detail_3	TEXT	Record Source Detail 3	Third level of detail on how this record was created	tickets
tickets_hs_object_source_id	TEXT	Record Creation Source ID	The sourceId -- further detail -- of the source that created this object record	tickets
tickets_hs_object_source_label	TEXT	Record Source	How this record was created	tickets
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
tickets_hs_originating_channel_instance_id	TEXT	Originating channel account	First channel account used when conversation was started	tickets
tickets_hs_originating_email_engagement_id	TEXT	Originating email engagement id	Engagement id of the email originating this ticket	tickets
tickets_hs_originating_generic_channel_id	TEXT	Originating channel type	The channel the conversation is in	tickets
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
tickets_hs_pipeline	TEXT	Pipeline	The pipeline that contains this ticket	tickets
tickets_hs_pipeline_stage	TEXT	Ticket status	The pipeline stage that contains this ticket	tickets
tickets_hs_primary_company	TEXT	Primary Company	Primary company of a ticket	tickets
tickets_hs_primary_company_id	TEXT	Primary Company ID	Primary company ID of a ticket	tickets
tickets_hs_primary_company_name	TEXT	Primary Company Name	Primary company name of a ticket	tickets
tickets_hs_read_only	TEXT	Read Only Object	Is the object read only	tickets
tickets_hs_resolution	TEXT	Resolution	The action taken to resolve the ticket	tickets
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
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
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
tickets_hs_tag_ids	TEXT	Ticket Tags	List of tag ids applicable to a ticket. This property is set automatically by HubSpot.	tickets
tickets_hs_thread_ids_to_restore	TEXT	Thread IDs To Restore	Thread IDs (from cv-threads) used to implement custom cascading delete/restore	tickets
tickets_hs_ticket_category	TEXT	Tickets Hubspot Category	Main reason customer reached out for help	tickets
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
tickets_hs_ticket_priority	TEXT	Tickets Hubspot Priority	The level of attention needed on the ticket	tickets
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
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
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
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
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
tickets_hs_time_to_close_sla_status	TEXT	Time to Close SLA Ticket Status	Current Time to Close SLA status of ticket	tickets
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
tickets_hs_time_to_first_response_sla_status	TEXT	Time to First Response SLA Status	Current Time to First Response SLA status.	tickets
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
tickets_hs_time_to_next_response_sla_status	TEXT	Time to Next Response SLA Status	Current Time to Next Response SLA status	tickets
tickets_hs_unique_creation_key	TEXT	Unique creation key	Unique property used for idempotent creates	tickets
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
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
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
tickets_hs_user_ids_of_all_owners	TEXT	User IDs of all owners	The user IDs of all owners of this object	tickets
tickets_hs_was_imported	TEXT	Performed in an import	Object is part of an import	tickets
tickets_hubspot_owner_assigneddate	TIMESTAMP	Owner assigned date	The date an owner was assigned to the ticket	tickets
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
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
tickets_last_engagement_date	TIMESTAMP	Date of last engagement	The date of the last reply or note	tickets
tickets_last_reply_date	TIMESTAMP	Last customer reply date	The date of the last customer response	tickets
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
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.	tickets
tickets_notes_next_activity_date	TIMESTAMP	Next Activity Date (Ticket Note)	The date of the next upcoming activity for this ticket	tickets
tickets_nps_follow_up_answer	TEXT	NPS follow up	Answer to NPS follow up question	tickets
tickets_nps_follow_up_question_version	TEXT	NPS follow up question	Specific version of NPS follow up question that was asked	tickets
tickets_nps_score	TEXT	Conversation NPS score	NPS score received after ticket resolution	tickets
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
tickets_num_notes	TEXT	Number of Sales Activities	Number of sales activities for this ticket	tickets
tickets_source_ref	TEXT	Reference to source-specific object	The id of a connected source object	tickets
tickets_source_thread_id	TEXT	Reference to email thread	The id of an email thread with ticket conversation	tickets
tickets_source_type	TEXT	Tickets Source Type	Channel where ticket was originally submitted	tickets
tickets_subject	TEXT	Ticket name	Short summary of ticket	tickets
tickets_tags	TEXT	Tags	Tags associated with your tickets	tickets
tickets_time_to_close	TEXT	Time to close	The time between when the ticket was created and closed	tickets
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	tickets
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_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