Dataslayer Dimensions | Hub Account | hub_account |
|
| Dimension |
Dataslayer Dimensions | Connector name | connector_name |
|
| Dimension |
Time | Year | year |
|
| Dimension |
Time | Year-Month | year_month |
|
| Dimension |
Time | Year-Week (Starting on Monday) | year_week |
|
| Dimension |
Time | Month | month |
|
| Dimension |
Time | Week (Starting on Monday) | week |
|
| Dimension |
Time | Date | date |
|
| Dimension |
Portal | Portal ID | portal_id |
|
| Dimension |
Portal | Portal Currency | portal_currency |
|
| Dimension |
Portal | Portal Hub Domain | portal_domain |
|
| Dimension |
Email | Email ID | email_id |
|
| Dimension |
Email | Email Author | email_author |
|
| Dimension |
Email | Email Author email | email_author_email |
|
| Dimension |
Email | Email Author name | email_author_name |
|
| Dimension |
Email | Email Author Id | email_author_id |
|
| Dimension |
Email | Absolute Url | absolute_url |
|
| Dimension |
Email | Analytics Page Id | analytics_page_id |
|
| Dimension |
Email | Analytics Page Type | analytics_page_type |
|
| Dimension |
Email | Category Id | category_id |
|
| Dimension |
Email | Content Type Category | content_type_category |
|
| Dimension |
Email | Email Created Date | email_created |
|
| Dimension |
Email | Current State | email_current_state |
|
| Dimension |
Email | Domain | domain |
|
| Dimension |
Email | Email Body | email_body |
|
| Dimension |
Email | Email Note | email_note |
|
| Dimension |
Email | Email Type | email_type |
|
| Dimension |
Email | Emailbody Plaintext | emailbody_plaintext |
|
| Dimension |
Email | From Name | from_name |
|
| Dimension |
Email | Html Title | html_title |
|
| Dimension |
Email Campaign | Email Campaign Id | email_campaign_id |
|
| Dimension |
Email Campaign | Campaign App Name | email_campaign_app_name |
|
| Dimension |
Email Campaign | Campaign App Id | email_campaign_app_id |
|
| Dimension |
Email Campaign | Campaign Name | email_campaign_name |
|
| Dimension |
Email Campaign | Campaign Subject | email_campaign_subject |
|
| Dimension |
Email Campaign | Campaign Type | email_campaign_type |
|
| Dimension |
Email Campaign | Campaign Subtype | email_campaign_subtype |
|
| Dimension |
Companies | Company ID | company_id |
|
| Dimension |
Companies | About Us | about_us |
|
| Dimension |
Companies | closedate_timestamp_earliest_value_a2a17e6e | closedate_timestamp_earliest_value_a2a17e6e |
|
| Dimension |
Companies | first_contact_createdate_timestamp_earliest_value_78b50eea | first_contact_createdate_timestamp_earliest_value_78b50eea |
|
| Dimension |
Companies | First Conversion Date | company_first_conversion_date |
|
| Dimension |
Companies | first_conversion_date_timestamp_earliest_value_61f58f2c | first_conversion_date_timestamp_earliest_value_61f58f2c |
|
| Dimension |
Companies | First Conversion | company_first_conversion_event_name |
|
| Dimension |
Companies | first_conversion_event_name_timestamp_earliest_value_68ddae0a | first_conversion_event_name_timestamp_earliest_value_68ddae0a |
|
| Dimension |
Companies | First Deal Created Date | company_first_deal_created_date |
|
| Dimension |
Companies | Year Founded | founded_year |
|
| Dimension |
Companies | Record ID | company_hs_object_id |
|
| Dimension |
Companies | Record Creation Source User ID | company_hs_object_source_user_id |
|
| Dimension |
Companies | Pinned Engagement ID | company_hs_pinned_engagement_id |
|
| Dimension |
Companies | Created by user ID | company_hs_created_by_user_id |
|
| Dimension |
Companies | Source Object ID | company_hs_source_object_id |
|
| Dimension |
Companies | Updated by user ID | company_hs_updated_by_user_id |
|
| Dimension |
Companies | Additional Domains | hs_additional_domains |
|
| Dimension |
Companies | Business units | company_hs_all_assigned_business_unit_ids |
|
| Dimension |
Companies | Time First Seen | company_hs_analytics_first_timestamp |
|
| Dimension |
Companies | hs_analytics_first_timestamp_timestamp_earliest_value_11e3a63a | hs_analytics_first_timestamp_timestamp_earliest_value_11e3a63a |
|
| Dimension |
Companies | First Touch Converting Campaign | company_hs_analytics_first_touch_converting_campaign |
|
| Dimension |
Companies | hs_analytics_first_touch_converting_campaign_timestamp_earliest_value_4757fe10 | hs_analytics_first_touch_converting_campaign_timestamp_earliest_value_4757fe10 |
|
| Dimension |
Companies | Time of First Session | company_hs_analytics_first_visit_timestamp |
|
| Dimension |
Companies | hs_analytics_first_visit_timestamp_timestamp_earliest_value_accc17ae | hs_analytics_first_visit_timestamp_timestamp_earliest_value_accc17ae |
|
| Dimension |
Companies | Time Last Seen | company_hs_analytics_last_timestamp |
|
| Dimension |
Companies | hs_analytics_last_timestamp_timestamp_latest_value_4e16365a | hs_analytics_last_timestamp_timestamp_latest_value_4e16365a |
|
| Dimension |
Companies | Last Touch Converting Campaign | company_hs_analytics_last_touch_converting_campaign |
|
| Dimension |
Companies | hs_analytics_last_touch_converting_campaign_timestamp_latest_value_81a64e30 | hs_analytics_last_touch_converting_campaign_timestamp_latest_value_81a64e30 |
|
| Dimension |
Companies | Time of Last Session | company_hs_analytics_last_visit_timestamp |
|
| Dimension |
Companies | hs_analytics_last_visit_timestamp_timestamp_latest_value_999a0fce | hs_analytics_last_visit_timestamp_timestamp_latest_value_999a0fce |
|
| Dimension |
Companies | Latest Source | hs_analytics_latest_source |
|
| Dimension |
Companies | Latest Source Data 1 | hs_analytics_latest_source_data_1 |
|
| Dimension |
Companies | Latest Source Data 2 | hs_analytics_latest_source_data_2 |
|
| Dimension |
Companies | Latest Source Timestamp | hs_analytics_latest_source_timestamp |
|
| Dimension |
Companies | hs_analytics_num_page_views_cardinality_sum_e46e85b0 | hs_analytics_num_page_views_cardinality_sum_e46e85b0 |
|
| Dimension |
Companies | hs_analytics_num_visits_cardinality_sum_53d952a6 | hs_analytics_num_visits_cardinality_sum_53d952a6 |
|
| Dimension |
Companies | Original Source Type | company_hs_analytics_source |
|
| Dimension |
Companies | Original Source Data 1 | company_hs_analytics_source_data_1 |
|
| Dimension |
Companies | hs_analytics_source_data_1_timestamp_earliest_value_9b2f1fa1 | hs_analytics_source_data_1_timestamp_earliest_value_9b2f1fa1 |
|
| Dimension |
Companies | Original Source Data 2 | company_hs_analytics_source_data_2 |
|
| Dimension |
Companies | hs_analytics_source_data_2_timestamp_earliest_value_9b2f9400 | hs_analytics_source_data_2_timestamp_earliest_value_9b2f9400 |
|
| Dimension |
Companies | hs_analytics_source_timestamp_earliest_value_25a3a52c | hs_analytics_source_timestamp_earliest_value_25a3a52c |
|
| Dimension |
Companies | Annual Revenue Currency Code | hs_annual_revenue_currency_code |
|
| Dimension |
Companies | Avatar FileManager key | company_hs_avatar_filemanager_key |
|
| Dimension |
Companies | Object create date/time | company_hs_createdate |
|
| Dimension |
Companies | Company Date entered 'Customer (Lifecycle Stage Pipeline)' | company_hs_date_entered_customer |
|
| Dimension |
Companies | Company Date entered 'Evangelist (Lifecycle Stage Pipeline)' | company_hs_date_entered_evangelist |
|
| Dimension |
Companies | Company Date entered 'Lead (Lifecycle Stage Pipeline)' | company_hs_date_entered_lead |
|
| Dimension |
Companies | Company Date entered 'Marketing Qualified Lead (Lifecycle Stage Pipeline)' | company_hs_date_entered_marketingqualifiedlead |
|
| Dimension |
Companies | Company Date entered 'Opportunity (Lifecycle Stage Pipeline)' | company_hs_date_entered_opportunity |
|
| Dimension |
Companies | Company Date entered 'Other (Lifecycle Stage Pipeline)' | company_hs_date_entered_other |
|
| Dimension |
Companies | Company Date entered 'Sales Qualified Lead (Lifecycle Stage Pipeline)' | company_hs_date_entered_salesqualifiedlead |
|
| Dimension |
Companies | Company Date entered 'Subscriber (Lifecycle Stage Pipeline)' | company_hs_date_entered_subscriber |
|
| Dimension |
Companies | Company Date exited 'Customer (Lifecycle Stage Pipeline)' | company_hs_date_exited_customer |
|
| Dimension |
Companies | Company Date exited 'Evangelist (Lifecycle Stage Pipeline)' | company_hs_date_exited_evangelist |
|
| Dimension |
Companies | Company Date exited 'Lead (Lifecycle Stage Pipeline)' | company_hs_date_exited_lead |
|
| Dimension |
Companies | Company Date exited 'Marketing Qualified Lead (Lifecycle Stage Pipeline)' | company_hs_date_exited_marketingqualifiedlead |
|
| Dimension |
Companies | Company Date exited 'Opportunity (Lifecycle Stage Pipeline)' | company_hs_date_exited_opportunity |
|
| Dimension |
Companies | Company Date exited 'Other (Lifecycle Stage Pipeline)' | company_hs_date_exited_other |
|
| Dimension |
Companies | Company Date exited 'Sales Qualified Lead (Lifecycle Stage Pipeline)' | company_hs_date_exited_salesqualifiedlead |
|
| Dimension |
Companies | Company Date exited 'Subscriber (Lifecycle Stage Pipeline)' | company_hs_date_exited_subscriber |
|
| Dimension |
Companies | Ideal Customer Profile Tier | hs_ideal_customer_profile |
|
| Dimension |
Companies | Target Account | hs_is_target_account |
|
| Dimension |
Companies | Last Booked Meeting Date | hs_last_booked_meeting_date |
|
| Dimension |
Companies | Last Logged Call Date | hs_last_logged_call_date |
|
| Dimension |
Companies | Last Open Task Date | hs_last_open_task_date |
|
| Dimension |
Companies | last sales activity date old | company_hs_last_sales_activity_date |
|
| Dimension |
Companies | Last Engagement Date | company_hs_last_sales_activity_timestamp |
|
| Dimension |
Companies | Last Engagement Type | company_hs_last_sales_activity_type |
|
| Dimension |
Companies | Last Modified Date | company_hs_lastmodifieddate |
|
| Dimension |
Companies | Latest create date of active subscriptions | hs_latest_createdate_of_active_subscriptions |
|
| Dimension |
Companies | Merged Company IDs | company_hs_merged_object_ids |
|
| Dimension |
Companies | Record Creation Source | company_hs_object_source |
|
| Dimension |
Companies | Record Creation Source ID | company_hs_object_source_id |
|
| Dimension |
Companies | Record Source | company_hs_object_source_label |
|
| Dimension |
Companies | Company Pipeline | company_hs_pipeline |
|
| Dimension |
Companies | hs_predictivecontactscore_v2_next_max_max_d4e58c1e | hs_predictivecontactscore_v2_next_max_max_d4e58c1e |
|
| Dimension |
Companies | Read Only Object | company_hs_read_only |
|
| Dimension |
Companies | Target Account | hs_target_account |
|
| Dimension |
Companies | Target Account Recommendation Snooze Time | hs_target_account_recommendation_snooze_time |
|
| Dimension |
Companies | Target Account Recommendation State | hs_target_account_recommendation_state |
|
| Dimension |
Companies | Time in 'Customer (Lifecycle Stage Pipeline)' | company_hs_time_in_customer |
|
| Dimension |
Companies | Time in 'Evangelist (Lifecycle Stage Pipeline)' | company_hs_time_in_evangelist |
|
| Dimension |
Companies | Time in 'Lead (Lifecycle Stage Pipeline)' | company_hs_time_in_lead |
|
| Dimension |
Companies | Time in 'Marketing Qualified Lead (Lifecycle Stage Pipeline)' | company_hs_time_in_marketingqualifiedlead |
|
| Dimension |
Companies | Time in 'Opportunity (Lifecycle Stage Pipeline)' | company_hs_time_in_opportunity |
|
| Dimension |
Companies | Time in 'Other (Lifecycle Stage Pipeline)' | company_hs_time_in_other |
|
| Dimension |
Companies | Time in 'Sales Qualified Lead (Lifecycle Stage Pipeline)' | company_hs_time_in_salesqualifiedlead |
|
| Dimension |
Companies | Time in 'Subscriber (Lifecycle Stage Pipeline)' | company_hs_time_in_subscriber |
|
| Dimension |
Companies | Unique creation key | company_hs_unique_creation_key |
|
| Dimension |
Companies | User IDs of all notification followers | company_hs_user_ids_of_all_notification_followers |
|
| Dimension |
Companies | User IDs of all notification unfollowers | company_hs_user_ids_of_all_notification_unfollowers |
|
| Dimension |
Companies | User IDs of all owners | company_hs_user_ids_of_all_owners |
|
| Dimension |
Companies | Performed in an import | company_hs_was_imported |
|
| Dimension |
Companies | Owner Assigned Date | company_hubspot_owner_assigneddate |
|
| Dimension |
Companies | Is Public | is_public |
|
| Dimension |
Companies | num_conversion_events_cardinality_sum_d095f14b | num_conversion_events_cardinality_sum_d095f14b |
|
| Dimension |
Companies | Recent Conversion Date | company_recent_conversion_date |
|
| Dimension |
Companies | recent_conversion_date_timestamp_latest_value_72856da1 | recent_conversion_date_timestamp_latest_value_72856da1 |
|
| Dimension |
Companies | Recent Conversion | company_recent_conversion_event_name |
|
| Dimension |
Companies | recent_conversion_event_name_timestamp_latest_value_66c820bf | recent_conversion_event_name_timestamp_latest_value_66c820bf |
|
| Dimension |
Companies | Recent Deal Close Date | company_recent_deal_close_date |
|
| Dimension |
Companies | Time Zone | timezone |
|
| Dimension |
Companies | Total Money Raised | total_money_raised |
|
| Dimension |
Companies | Total Revenue | total_revenue |
|
| Dimension |
Companies | Company name | name |
|
| Dimension |
Companies | HubSpot Owner Email | company_owneremail |
|
| Dimension |
Companies | Twitter Handle | company_twitterhandle |
|
| Dimension |
Companies | HubSpot Owner Name | company_ownername |
|
| Dimension |
Companies | Phone Number | company_phone |
|
| Dimension |
Companies | Twitter Bio | company_twitterbio |
|
| Dimension |
Companies | Street Address | company_address |
|
| Dimension |
Companies | Street Address 2 | address2 |
|
| Dimension |
Companies | Facebook Company Page | facebook_company_page |
|
| Dimension |
Companies | City | company_city |
|
| Dimension |
Companies | LinkedIn Company Page | linkedin_company_page |
|
| Dimension |
Companies | LinkedIn Bio | company_linkedinbio |
|
| Dimension |
Companies | State/Region | company_state |
|
| Dimension |
Companies | Google Plus Page | googleplus_page |
|
| Dimension |
Companies | Date of last meeting booked in meetings tool | company_engagements_last_meeting_booked |
|
| Dimension |
Companies | Campaign of last booking in meetings tool | company_engagements_last_meeting_booked_campaign |
|
| Dimension |
Companies | Medium of last booking in meetings tool | company_engagements_last_meeting_booked_medium |
|
| Dimension |
Companies | Source of last booking in meetings tool | company_engagements_last_meeting_booked_source |
|
| Dimension |
Companies | Latest meeting activity | company_hs_latest_meeting_activity |
|
| Dimension |
Companies | Recent Sales Email Replied Date | company_hs_sales_email_last_replied |
|
| Dimension |
Companies | Company owner | company_hubspot_owner_id |
|
| Dimension |
Companies | Last Contacted | company_notes_last_contacted |
|
| Dimension |
Companies | Last Activity Date | company_notes_last_updated |
|
| Dimension |
Companies | Next Activity Date | company_notes_next_activity_date |
|
| Dimension |
Companies | Postal Code | company_zip |
|
| Dimension |
Companies | Country/Region | company_country |
|
| Dimension |
Companies | HubSpot Team | company_hubspot_team_id |
|
| Dimension |
Companies | All owner ids | company_hs_all_owner_ids |
|
| Dimension |
Companies | Website URL | company_website |
|
| Dimension |
Companies | Company Domain Name | company_domain |
|
| Dimension |
Companies | All team ids | company_hs_all_team_ids |
|
| Dimension |
Companies | All teams | company_hs_all_accessible_team_ids |
|
| Dimension |
Companies | Industry | company_industry |
|
| Dimension |
Companies | Lifecycle Stage | company_lifecyclestage |
|
| Dimension |
Companies | Lead Status | company_hs_lead_status |
|
| Dimension |
Companies | Type | type |
|
| Dimension |
Companies | Description | description |
|
| Dimension |
Companies | Create Date | company_createdate |
|
| Dimension |
Companies | Company Close Date | company_closedate |
|
| Dimension |
Companies | First Contact Create Date | first_contact_createdate |
|
| Dimension |
Companies | Days to Close | company_days_to_close |
|
| Dimension |
Companies | Web Technologies | web_technologies |
|
| Dimension |
Contacts | Contact Id | contact_id |
|
| Dimension |
Contacts | Contact Email | contact_email |
|
| Dimension |
Contacts | Contact First Name | contact_first_name |
|
| Dimension |
Contacts | Contact Last Name | contact_last_name |
|
| Dimension |
Contacts | Contact Create Date | contact_created |
|
| Dimension |
Contacts | Contact Last Modified Date | contact_last_modified_date |
|
| Dimension |
Contacts | Contact Website | contact_website |
|
| Dimension |
Contacts | Contact Phone | contact_phone |
|
| Dimension |
Contacts | Contact City | contact_city |
|
| Dimension |
Contacts | Contact lifecycle Stage | contact_lifecycleStage |
|
| Dimension |
Contacts | Contact lifecycle lead date | hs_lifecyclestage_lead_date |
|
| Dimension |
Contacts | Contact lifecycle opportunity date | hs_lifecyclestage_opportunity_date |
|
| Dimension |
Contacts | Contact lifecycle marketing qualified lead date | hs_lifecyclestage_marketingqualifiedlead_date |
|
| Dimension |
Contacts | Contact lifecycle sales qualified lead date | hs_lifecyclestage_salesqualifiedlead_date |
|
| Dimension |
Contacts | Contact lifecycle evangelist date | hs_lifecyclestage_evangelist_date |
|
| Dimension |
Contacts | Contact lifecycle customer date | hs_lifecyclestage_customer_date |
|
| Dimension |
Contacts | Contact lifecycle subscriber date | hs_lifecyclestage_subscriber_date |
|
| Dimension |
Contacts | Contact lifecycle other date | hs_lifecyclestage_other_date |
|
| Dimension |
Contacts | Company size | company_size |
|
| Dimension |
Contacts | Date of birth | date_of_birth |
|
| Dimension |
Contacts | Degree | degree |
|
| Dimension |
Contacts | Field of study | field_of_study |
|
| Dimension |
Contacts | First Conversion Date | first_conversion_date |
|
| Dimension |
Contacts | First Conversion | first_conversion_event_name |
|
| Dimension |
Contacts | First Deal Created Date | first_deal_created_date |
|
| Dimension |
Contacts | Gender | gender |
|
| Dimension |
Contacts | Graduation date | graduation_date |
|
| Dimension |
Contacts | Additional email addresses | hs_additional_emails |
|
| Dimension |
Contacts | Business units | hs_all_assigned_business_unit_ids |
|
| Dimension |
Contacts | All vids for a contact | hs_all_contact_vids |
|
| Dimension |
Contacts | First Touch Converting Campaign | hs_analytics_first_touch_converting_campaign |
|
| Dimension |
Contacts | Last Touch Converting Campaign | hs_analytics_last_touch_converting_campaign |
|
| Dimension |
Contacts | Avatar FileManager key | hs_avatar_filemanager_key |
|
| Dimension |
Contacts | Buying Role | hs_buying_role |
|
| Dimension |
Contacts | All form submissions for a contact | hs_calculated_form_submissions |
|
| Dimension |
Contacts | Merged vids with timestamps of a contact | hs_calculated_merged_vids |
|
| Dimension |
Contacts | Calculated Mobile Number in International Format | hs_calculated_mobile_number |
|
| Dimension |
Contacts | Calculated Phone Number in International Format | hs_calculated_phone_number |
|
| Dimension |
Contacts | Calculated Phone Number Area Code | hs_calculated_phone_number_area_code |
|
| Dimension |
Contacts | Calculated Phone Number Country Code | hs_calculated_phone_number_country_code |
|
| Dimension |
Contacts | Calculated Phone Number Region | hs_calculated_phone_number_region_code |
|
| Dimension |
Contacts | Clicked on a LinkedIn Ad | hs_clicked_linkedin_ad |
|
| Dimension |
Contacts | Member email | hs_content_membership_email |
|
| Dimension |
Contacts | Email Confirmed | hs_content_membership_email_confirmed |
|
| Dimension |
Contacts | Time enrolled in registration follow up emails | hs_content_membership_follow_up_enqueued_at |
|
| Dimension |
Contacts | Membership Notes | hs_content_membership_notes |
|
| Dimension |
Contacts | Registered At | hs_content_membership_registered_at |
|
| Dimension |
Contacts | Domain to which registration email was sent | hs_content_membership_registration_domain_sent_to |
|
| Dimension |
Contacts | Time registration email was sent | hs_content_membership_registration_email_sent_at |
|
| Dimension |
Contacts | Status | hs_content_membership_status |
|
| Dimension |
Contacts | Conversations visitor email | hs_conversations_visitor_email |
|
| Dimension |
Contacts | Count of unengaged contacts | hs_count_is_unworked |
|
| Dimension |
Contacts | Count of engaged contacts | hs_count_is_worked |
|
| Dimension |
Contacts | Created By Conversations | hs_created_by_conversations |
|
| Dimension |
Contacts | Object create date/time | hs_createdate |
|
| Dimension |
Contacts | Ads Consent from Forms | hs_data_privacy_ads_consent |
|
| Dimension |
Contacts | Date entered 'Customer (Lifecycle Stage Pipeline)' | hs_date_entered_customer |
|
| Dimension |
Contacts | Date entered 'Evangelist (Lifecycle Stage Pipeline)' | hs_date_entered_evangelist |
|
| Dimension |
Contacts | Date entered 'Lead (Lifecycle Stage Pipeline)' | hs_date_entered_lead |
|
| Dimension |
Contacts | Date entered 'Marketing Qualified Lead (Lifecycle Stage Pipeline)' | hs_date_entered_marketingqualifiedlead |
|
| Dimension |
Contacts | Date entered 'Opportunity (Lifecycle Stage Pipeline)' | hs_date_entered_opportunity |
|
| Dimension |
Contacts | Date entered 'Other (Lifecycle Stage Pipeline)' | hs_date_entered_other |
|
| Dimension |
Contacts | Date entered 'Sales Qualified Lead (Lifecycle Stage Pipeline)' | hs_date_entered_salesqualifiedlead |
|
| Dimension |
Contacts | Date entered 'Subscriber (Lifecycle Stage Pipeline)' | hs_date_entered_subscriber |
|
| Dimension |
Contacts | Date exited 'Customer (Lifecycle Stage Pipeline)' | hs_date_exited_customer |
|
| Dimension |
Contacts | Date exited 'Evangelist (Lifecycle Stage Pipeline)' | hs_date_exited_evangelist |
|
| Dimension |
Contacts | Date exited 'Lead (Lifecycle Stage Pipeline)' | hs_date_exited_lead |
|
| Dimension |
Contacts | Date exited 'Marketing Qualified Lead (Lifecycle Stage Pipeline)' | hs_date_exited_marketingqualifiedlead |
|
| Dimension |
Contacts | Date exited 'Opportunity (Lifecycle Stage Pipeline)' | hs_date_exited_opportunity |
|
| Dimension |
Contacts | Date exited 'Other (Lifecycle Stage Pipeline)' | hs_date_exited_other |
|
| Dimension |
Contacts | Date exited 'Sales Qualified Lead (Lifecycle Stage Pipeline)' | hs_date_exited_salesqualifiedlead |
|
| Dimension |
Contacts | Date exited 'Subscriber (Lifecycle Stage Pipeline)' | hs_date_exited_subscriber |
|
| Dimension |
Contacts | Recent Document Revisit Date | hs_document_last_revisited |
|
| Dimension |
Contacts | Invalid email address | hs_email_bad_address |
|
| Dimension |
Contacts | Email address quarantine reason | hs_email_customer_quarantined_reason |
|
| Dimension |
Contacts | Email Domain | hs_email_domain |
|
| Dimension |
Contacts | Email hard bounce reason | hs_email_hard_bounce_reason |
|
| Dimension |
Contacts | Email hard bounce reason | hs_email_hard_bounce_reason_enum |
|
| Dimension |
Contacts | Email Address Quarantined | hs_email_quarantined |
|
| Dimension |
Contacts | Email address automated quarantine reason | hs_email_quarantined_reason |
|
| Dimension |
Contacts | Email Address Recipient Fatigue Next Available Sending Time | hs_email_recipient_fatigue_recovery_time |
|
| Dimension |
Contacts | Marketing email confirmation status | hs_emailconfirmationstatus |
|
| Dimension |
Contacts | Clicked Facebook ad | hs_facebook_ad_clicked |
|
| Dimension |
Contacts | Facebook click id | hs_facebook_click_id |
|
| Dimension |
Contacts | Facebook ID | hs_facebookid |
|
| Dimension |
Contacts | Last NPS survey comment | hs_feedback_last_nps_follow_up |
|
| Dimension |
Contacts | Last NPS survey rating | hs_feedback_last_nps_rating |
|
| Dimension |
Contacts | Last NPS survey date | hs_feedback_last_survey_date |
|
| Dimension |
Contacts | Should be shown an NPS web survey | hs_feedback_show_nps_web_survey |
|
| Dimension |
Contacts | First outreach date | hs_first_outreach_date |
|
| Dimension |
Contacts | First subscription create date | hs_first_subscription_create_date |
|
| Dimension |
Contacts | Google ad click id | hs_google_click_id |
|
| Dimension |
Contacts | googleplus ID | hs_googleplusid |
|
| Dimension |
Contacts | Contact has an active subscription | hs_has_active_subscription |
|
| Dimension |
Contacts | IP Timezone | hs_ip_timezone |
|
| Dimension |
Contacts | Is a contact | hs_is_contact |
|
| Dimension |
Contacts | Contact unworked | hs_is_unworked |
|
| Dimension |
Contacts | last sales activity date old | hs_last_sales_activity_date |
|
| Dimension |
Contacts | Last Engagement Date | hs_last_sales_activity_timestamp |
|
| Dimension |
Contacts | Last Engagement Type | hs_last_sales_activity_type |
|
| Dimension |
Contacts | Object last modified date/time | hs_lastmodifieddate |
|
| Dimension |
Contacts | Latest Disqualified Lead Date | hs_latest_disqualified_lead_date |
|
| Dimension |
Contacts | Latest Open Lead Date | hs_latest_open_lead_date |
|
| Dimension |
Contacts | Latest Qualified Lead Date | hs_latest_qualified_lead_date |
|
| Dimension |
Contacts | Last sequence ended date | hs_latest_sequence_ended_date |
|
| Dimension |
Contacts | Last sequence enrolled date | hs_latest_sequence_enrolled_date |
|
| Dimension |
Contacts | Last sequence finished date | hs_latest_sequence_finished_date |
|
| Dimension |
Contacts | Last sequence unenrolled date | hs_latest_sequence_unenrolled_date |
|
| Dimension |
Contacts | Latest Source Date | hs_latest_source_timestamp |
|
| Dimension |
Contacts | Latest subscription create date | hs_latest_subscription_create_date |
|
| Dimension |
Contacts | Lead Status | hs_lead_status |
|
| Dimension |
Contacts | Legal basis for processing contact's data | hs_legal_basis |
|
| Dimension |
Contacts | Clicked LinkedIn Ad | hs_linkedin_ad_clicked |
|
| Dimension |
Contacts | Linkedin ID | hs_linkedinid |
|
| Dimension |
Contacts | Marketing contact status source name | hs_marketable_reason_id |
|
| Dimension |
Contacts | Marketing contact status source type | hs_marketable_reason_type |
|
| Dimension |
Contacts | Marketing contact status | hs_marketable_status |
|
| Dimension |
Contacts | Marketing contact until next update | hs_marketable_until_renewal |
|
| Dimension |
Contacts | Merged Contact IDs | hs_merged_object_ids |
|
| Dimension |
Contacts | Record Creation Source | hs_object_source |
|
| Dimension |
Contacts | Record Creation Source ID | hs_object_source_id |
|
| Dimension |
Contacts | Record Source | hs_object_source_label |
|
| Dimension |
Contacts | Contacts Pipeline | hs_pipeline |
|
| Dimension |
Contacts | Contact priority | hs_predictivescoringtier |
|
| Dimension |
Contacts | Read Only Object | hs_read_only |
|
| Dimension |
Contacts | Date of first engagement | hs_sa_first_engagement_date |
|
| Dimension |
Contacts | Description of first engagement | hs_sa_first_engagement_descr |
|
| Dimension |
Contacts | Type of first engagement | hs_sa_first_engagement_object_type |
|
| Dimension |
Contacts | Recent Sales Email Clicked Date | hs_sales_email_last_clicked |
|
| Dimension |
Contacts | Recent Sales Email Opened Date | hs_sales_email_last_opened |
|
| Dimension |
Contacts | Calculated Mobile Number with country code | hs_searchable_calculated_international_mobile_number |
|
| Dimension |
Contacts | Calculated Phone Number with country code | hs_searchable_calculated_international_phone_number |
|
| Dimension |
Contacts | Calculated Mobile Number without country code | hs_searchable_calculated_mobile_number |
|
| Dimension |
Contacts | Calculated Phone Number without country code | hs_searchable_calculated_phone_number |
|
| Dimension |
Contacts | Currently in Sequence | hs_sequences_is_enrolled |
|
| Dimension |
Contacts | testpurge | hs_testpurge |
|
| Dimension |
Contacts | testrollback | hs_testrollback |
|
| Dimension |
Contacts | Time between contact creation and deal close | hs_time_between_contact_creation_and_deal_close |
|
| Dimension |
Contacts | Time between contact creation and deal creation | hs_time_between_contact_creation_and_deal_creation |
|
| Dimension |
Contacts | Time in 'Customer (Lifecycle Stage Pipeline)' | hs_time_in_customer |
|
| Dimension |
Contacts | Time in 'Evangelist (Lifecycle Stage Pipeline)' | hs_time_in_evangelist |
|
| Dimension |
Contacts | Time in 'Lead (Lifecycle Stage Pipeline)' | hs_time_in_lead |
|
| Dimension |
Contacts | Time in 'Marketing Qualified Lead (Lifecycle Stage Pipeline)' | hs_time_in_marketingqualifiedlead |
|
| Dimension |
Contacts | Time in 'Opportunity (Lifecycle Stage Pipeline)' | hs_time_in_opportunity |
|
| Dimension |
Contacts | Time in 'Other (Lifecycle Stage Pipeline)' | hs_time_in_other |
|
| Dimension |
Contacts | Time in 'Sales Qualified Lead (Lifecycle Stage Pipeline)' | hs_time_in_salesqualifiedlead |
|
| Dimension |
Contacts | Time in 'Subscriber (Lifecycle Stage Pipeline)' | hs_time_in_subscriber |
|
| Dimension |
Contacts | Time to move from lead to customer | hs_time_to_move_from_lead_to_customer |
|
| Dimension |
Contacts | Time to move from marketing qualified lead to customer | hs_time_to_move_from_marketingqualifiedlead_to_customer |
|
| Dimension |
Contacts | Time to move from opportunity to customer | hs_time_to_move_from_opportunity_to_customer |
|
| Dimension |
Contacts | Time to move from sales qualified lead to customer | hs_time_to_move_from_salesqualifiedlead_to_customer |
|
| Dimension |
Contacts | Time to move from subscriber to customer | hs_time_to_move_from_subscriber_to_customer |
|
| Dimension |
Contacts | Time Zone | hs_timezone |
|
| Dimension |
Contacts | Twitter ID | hs_twitterid |
|
| Dimension |
Contacts | Unique creation key | hs_unique_creation_key |
|
| Dimension |
Contacts | User IDs of all notification followers | hs_user_ids_of_all_notification_followers |
|
| Dimension |
Contacts | User IDs of all notification unfollowers | hs_user_ids_of_all_notification_unfollowers |
|
| Dimension |
Contacts | User IDs of all owners | hs_user_ids_of_all_owners |
|
| Dimension |
Contacts | Date entered "Customer (Lifecycle Stage Pipeline)" | hs_v2_date_entered_customer |
|
| Dimension |
Contacts | Date entered "Evangelist (Lifecycle Stage Pipeline)" | hs_v2_date_entered_evangelist |
|
| Dimension |
Contacts | Date entered "Lead (Lifecycle Stage Pipeline)" | hs_v2_date_entered_lead |
|
| Dimension |
Contacts | Date entered "Marketing Qualified Lead (Lifecycle Stage Pipeline)" | hs_v2_date_entered_marketingqualifiedlead |
|
| Dimension |
Contacts | Date entered "Opportunity (Lifecycle Stage Pipeline)" | hs_v2_date_entered_opportunity |
|
| Dimension |
Contacts | Date entered "Other (Lifecycle Stage Pipeline)" | hs_v2_date_entered_other |
|
| Dimension |
Contacts | Date entered "Sales Qualified Lead (Lifecycle Stage Pipeline)" | hs_v2_date_entered_salesqualifiedlead |
|
| Dimension |
Contacts | Date entered "Subscriber (Lifecycle Stage Pipeline)" | hs_v2_date_entered_subscriber |
|
| Dimension |
Contacts | Date exited "Customer (Lifecycle Stage Pipeline)" | hs_v2_date_exited_customer |
|
| Dimension |
Contacts | Date exited "Evangelist (Lifecycle Stage Pipeline)" | hs_v2_date_exited_evangelist |
|
| Dimension |
Contacts | Date exited "Lead (Lifecycle Stage Pipeline)" | hs_v2_date_exited_lead |
|
| Dimension |
Contacts | Date exited "Marketing Qualified Lead (Lifecycle Stage Pipeline)" | hs_v2_date_exited_marketingqualifiedlead |
|
| Dimension |
Contacts | Date exited "Opportunity (Lifecycle Stage Pipeline)" | hs_v2_date_exited_opportunity |
|
| Dimension |
Contacts | Date exited "Other (Lifecycle Stage Pipeline)" | hs_v2_date_exited_other |
|
| Dimension |
Contacts | Date exited "Sales Qualified Lead (Lifecycle Stage Pipeline)" | hs_v2_date_exited_salesqualifiedlead |
|
| Dimension |
Contacts | Date exited "Subscriber (Lifecycle Stage Pipeline)" | hs_v2_date_exited_subscriber |
|
| Dimension |
Contacts | Performed in an import | hs_was_imported |
|
| Dimension |
Contacts | WhatsApp Phone Number | hs_whatsapp_phone_number |
|
| Dimension |
Contacts | Owner Assigned Date | hubspot_owner_assigneddate |
|
| Dimension |
Contacts | IP City | ip_city |
|
| Dimension |
Contacts | IP Country | ip_country |
|
| Dimension |
Contacts | IP Country Code | ip_country_code |
|
| Dimension |
Contacts | IP Latitude & Longitude | ip_latlon |
|
| Dimension |
Contacts | IP State/Region | ip_state |
|
| Dimension |
Contacts | IP State Code/Region Code | ip_state_code |
|
| Dimension |
Contacts | IP Zipcode | ip_zipcode |
|
| Dimension |
Contacts | Job function | job_function |
|
| Dimension |
Contacts | Last Modified Date | lastmodifieddate |
|
| Dimension |
Contacts | Marital Status | marital_status |
|
| Dimension |
Contacts | Military status | military_status |
|
| Dimension |
Contacts | Recent Conversion Date | recent_conversion_date |
|
| Dimension |
Contacts | Recent Conversion | recent_conversion_event_name |
|
| Dimension |
Contacts | Recent Deal Close Date | recent_deal_close_date |
|
| Dimension |
Contacts | Relationship Status | relationship_status |
|
| Dimension |
Contacts | School | school |
|
| Dimension |
Contacts | Seniority | seniority |
|
| Dimension |
Contacts | Start date | start_date |
|
| Dimension |
Contacts | Work email | work_email |
|
| Dimension |
Contacts | First Name | firstname |
|
| Dimension |
Contacts | First Page Seen | hs_analytics_first_url |
|
| Dimension |
Contacts | Opted out of email: Customer Service Communication | hs_email_optout_231661924 |
|
| Dimension |
Contacts | Opted out of email: One to One | hs_email_optout_231661926 |
|
| Dimension |
Contacts | Twitter Username | twitterhandle |
|
| Dimension |
Contacts | Currently in workflow | currentlyinworkflow |
|
| Dimension |
Contacts | Last Page Seen | hs_analytics_last_url |
|
| Dimension |
Contacts | Last Name | lastname |
|
| Dimension |
Contacts | Salutation | salutation |
|
| Dimension |
Contacts | Twitter Profile Photo | twitterprofilephoto |
|
| Dimension |
Contacts | Email | email |
|
| Dimension |
Contacts | Persona | hs_persona |
|
| Dimension |
Contacts | Most Recent Social Click | hs_social_last_engagement |
|
| Dimension |
Contacts | Unsubscribed from all email | hs_email_optout |
|
| Dimension |
Contacts | Mobile Phone Number | mobilephone |
|
| Dimension |
Contacts | Phone Number | phone |
|
| Dimension |
Contacts | Fax Number | fax |
|
| Dimension |
Contacts | Time First Seen | hs_analytics_first_timestamp |
|
| Dimension |
Contacts | Last marketing email name | hs_email_last_email_name |
|
| Dimension |
Contacts | Last marketing email send date | hs_email_last_send_date |
|
| Dimension |
Contacts | Street Address | address |
|
| Dimension |
Contacts | Date of last meeting booked in meetings tool | engagements_last_meeting_booked |
|
| Dimension |
Contacts | Campaign of last booking in meetings tool | engagements_last_meeting_booked_campaign |
|
| Dimension |
Contacts | Medium of last booking in meetings tool | engagements_last_meeting_booked_medium |
|
| Dimension |
Contacts | Source of last booking in meetings tool | engagements_last_meeting_booked_source |
|
| Dimension |
Contacts | Time of First Session | hs_analytics_first_visit_timestamp |
|
| Dimension |
Contacts | Last marketing email open date | hs_email_last_open_date |
|
| Dimension |
Contacts | Latest meeting activity | hs_latest_meeting_activity |
|
| Dimension |
Contacts | Recent Sales Email Replied Date | hs_sales_email_last_replied |
|
| Dimension |
Contacts | Contact owner | hubspot_owner_id |
|
| Dimension |
Contacts | Last Contacted | notes_last_contacted |
|
| Dimension |
Contacts | Last Activity Date | notes_last_updated |
|
| Dimension |
Contacts | Next Activity Date | notes_next_activity_date |
|
| Dimension |
Contacts | HubSpot Owner Email (legacy) | owneremail |
|
| Dimension |
Contacts | HubSpot Owner Name (legacy) | ownername |
|
| Dimension |
Contacts | City | city |
|
| Dimension |
Contacts | Time Last Seen | hs_analytics_last_timestamp |
|
| Dimension |
Contacts | Last marketing email click date | hs_email_last_click_date |
|
| Dimension |
Contacts | HubSpot Team | hubspot_team_id |
|
| Dimension |
Contacts | LinkedIn Bio | linkedinbio |
|
| Dimension |
Contacts | Twitter Bio | twitterbio |
|
| Dimension |
Contacts | All owner ids | hs_all_owner_ids |
|
| Dimension |
Contacts | Time of Last Session | hs_analytics_last_visit_timestamp |
|
| Dimension |
Contacts | First marketing email send date | hs_email_first_send_date |
|
| Dimension |
Contacts | State/Region | state |
|
| Dimension |
Contacts | All team ids | hs_all_team_ids |
|
| Dimension |
Contacts | Original Source | hs_analytics_source |
|
| Dimension |
Contacts | First marketing email open date | hs_email_first_open_date |
|
| Dimension |
Contacts | Latest Source | hs_latest_source |
|
| Dimension |
Contacts | Postal Code | zip |
|
| Dimension |
Contacts | Country/Region | country |
|
| Dimension |
Contacts | All teams | hs_all_accessible_team_ids |
|
| Dimension |
Contacts | Original Source Drill-Down 1 | hs_analytics_source_data_1 |
|
| Dimension |
Contacts | First marketing email click date | hs_email_first_click_date |
|
| Dimension |
Contacts | Latest Source Drill-Down 1 | hs_latest_source_data_1 |
|
| Dimension |
Contacts | Original Source Drill-Down 2 | hs_analytics_source_data_2 |
|
| Dimension |
Contacts | Is globally ineligible | hs_email_is_ineligible |
|
| Dimension |
Contacts | Preferred language | hs_language |
|
| Dimension |
Contacts | Latest Source Drill-Down 2 | hs_latest_source_data_2 |
|
| Dimension |
Contacts | First Referring Site | hs_analytics_first_referrer |
|
| Dimension |
Contacts | First marketing email reply date | hs_email_first_reply_date |
|
| Dimension |
Contacts | Job Title | jobtitle |
|
| Dimension |
Contacts | Photo | photo |
|
| Dimension |
Contacts | Last Referring Site | hs_analytics_last_referrer |
|
| Dimension |
Contacts | Last marketing email reply date | hs_email_last_reply_date |
|
| Dimension |
Contacts | Message | message |
|
| Dimension |
Contacts | Contact Close Date | closedate |
|
| Dimension |
Contacts | Lifecycle Stage | lifecyclestage |
|
| Dimension |
Contacts | Create Date | createdate |
|
| Dimension |
Contacts | HubSpot Score | hubspotscore |
|
| Dimension |
Contacts | Company Name | company |
|
| Dimension |
Contacts | Website URL | website |
|
| Dimension |
Contacts | Number of Employees | numemployees |
|
| Dimension |
Contacts | Annual Revenue | annualrevenue |
|
| Dimension |
Contacts | Industry | industry |
|
| Dimension |
Contacts | Days To Close | days_to_close |
|
| Dimension |
Contacts | Created by user ID | hs_created_by_user_id |
|
| Dimension |
Contacts | ID of first engagement | hs_first_engagement_object_id |
|
| Dimension |
Contacts | Last sequence enrolled | hs_latest_sequence_enrolled |
|
| Dimension |
Contacts | Record ID | hs_object_id |
|
| Dimension |
Contacts | Record Creation Source User ID | hs_object_source_user_id |
|
| Dimension |
Contacts | Pinned engagement ID | hs_pinned_engagement_id |
|
| Dimension |
Contacts | Source Object ID | hs_source_object_id |
|
| Dimension |
Contacts | Source Portal ID | hs_source_portal_id |
|
| Dimension |
Contacts | Lead response time | hs_time_to_first_engagement |
|
| Dimension |
Contacts | Updated by user ID | hs_updated_by_user_id |
|
| Dimension |
Contacts | Primary Associated Company ID | associatedcompanyid |
|
| Dimension |
Contacts | Lead Rating | hs_predictivecontactscorebucket |
|
| Dimension |
Contacts Lists | Contact List ID | contact_list_id |
|
| Dimension |
Contacts Lists | Contact List internal ID | contact_list_internal_id |
|
| Dimension |
Contacts Lists | Contact List name | contact_list_name |
|
| Dimension |
Contacts Lists | Contact List type | contact_list_type |
|
| Dimension |
Deals | Deal ID | deal_id |
|
| Dimension |
Deals | Deal Name | deal_name |
|
| Dimension |
Deals | Deal Stage | deal_stage |
|
| Dimension |
Deals | Deal Pipeline | deal_pipeline |
|
| Dimension |
Deals | Deal is archived | deal_is_archived |
|
| Dimension |
Deals | Deal Created Date | deal_created |
|
| Dimension |
Deals | Deal Close Date | deal_close_date |
|
| Dimension |
Deals | Deal last updated date | deal_last_updated |
|
| Dimension |
Deals | Amount in company currency | amount_in_home_currency |
|
| Dimension |
Deals | Days to close | deal_days_to_close |
|
| Dimension |
Deals | Currency | deal_currency_code |
|
| Dimension |
Deals | Business units | deal_hs_all_assigned_business_unit_ids |
|
| Dimension |
Deals | Deal Collaborator | hs_all_collaborator_owner_ids |
|
| Dimension |
Deals | Deal Split Users | hs_all_deal_split_owner_ids |
|
| Dimension |
Deals | Latest Source Company | hs_analytics_latest_source_company |
|
| Dimension |
Deals | Latest Source Contact | hs_analytics_latest_source_contact |
|
| Dimension |
Deals | Latest Source Data 1 Company | hs_analytics_latest_source_data_1_company |
|
| Dimension |
Deals | Latest Source Data 1 Contact | hs_analytics_latest_source_data_1_contact |
|
| Dimension |
Deals | Latest Source Data 2 Company | hs_analytics_latest_source_data_2_company |
|
| Dimension |
Deals | Latest Source Data 2 Contact | hs_analytics_latest_source_data_2_contact |
|
| Dimension |
Deals | Latest Source Timestamp Company | hs_analytics_latest_source_timestamp_company |
|
| Dimension |
Deals | Latest Source Timestamp Contact | hs_analytics_latest_source_timestamp_contact |
|
| Dimension |
Deals | Original Source Type | deal_hs_analytics_source |
|
| Dimension |
Deals | Original Source Data 1 | deal_hs_analytics_source_data_1 |
|
| Dimension |
Deals | Original Source Data 2 | deal_hs_analytics_source_data_2 |
|
| Dimension |
Deals | HubSpot Campaign | hs_campaign |
|
| Dimension |
Deals | Closed Deal Amount | hs_closed_amount |
|
| Dimension |
Deals | Closed Deal Amount In Home Currency | hs_closed_amount_in_home_currency |
|
| Dimension |
Deals | Closed Won Date (Internal) | hs_closed_won_date |
|
| Dimension |
Deals | Date entered 'Appointment Scheduled (Sales Pipeline)' | hs_date_entered_appointmentscheduled |
|
| Dimension |
Deals | Date entered 'Closed Lost (Sales Pipeline)' | hs_date_entered_closedlost |
|
| Dimension |
Deals | Date entered 'Closed Won (Sales Pipeline)' | hs_date_entered_closedwon |
|
| Dimension |
Deals | Date entered 'Contract Sent (Sales Pipeline)' | hs_date_entered_contractsent |
|
| Dimension |
Deals | Date entered 'Decision Maker Bought-In (Sales Pipeline)' | hs_date_entered_decisionmakerboughtin |
|
| Dimension |
Deals | Date entered 'Presentation Scheduled (Sales Pipeline)' | hs_date_entered_presentationscheduled |
|
| Dimension |
Deals | Date entered 'Qualified To Buy (Sales Pipeline)' | hs_date_entered_qualifiedtobuy |
|
| Dimension |
Deals | Date exited 'Appointment Scheduled (Sales Pipeline)' | hs_date_exited_appointmentscheduled |
|
| Dimension |
Deals | Date exited 'Closed Lost (Sales Pipeline)' | hs_date_exited_closedlost |
|
| Dimension |
Deals | Date exited 'Closed Won (Sales Pipeline)' | hs_date_exited_closedwon |
|
| Dimension |
Deals | Date exited 'Contract Sent (Sales Pipeline)' | hs_date_exited_contractsent |
|
| Dimension |
Deals | Date exited 'Decision Maker Bought-In (Sales Pipeline)' | hs_date_exited_decisionmakerboughtin |
|
| Dimension |
Deals | Date exited 'Presentation Scheduled (Sales Pipeline)' | hs_date_exited_presentationscheduled |
|
| Dimension |
Deals | Date exited 'Qualified To Buy (Sales Pipeline)' | hs_date_exited_qualifiedtobuy |
|
| Dimension |
Deals | Days to close (without rounding) | hs_days_to_close_raw |
|
| Dimension |
Deals | Deal amount calculation preference | hs_deal_amount_calculation_preference |
|
| Dimension |
Deals | Deal stage probability shadow | hs_deal_stage_probability_shadow |
|
| Dimension |
Deals | Is Deal Closed? | hs_is_closed |
|
| Dimension |
Deals | Is Closed Won | hs_is_closed_won |
|
| Dimension |
Deals | Deal Split Added | hs_is_deal_split |
|
| Dimension |
Deals | Is open count | hs_is_open_count |
|
| Dimension |
Deals | Last Modified Date | deal_hs_lastmodifieddate |
|
| Dimension |
Deals | Global Term Line Item Discount Percentage | hs_line_item_global_term_hs_discount_percentage |
|
| Dimension |
Deals | Global Term Line Item Discount Percentage Enabled | hs_line_item_global_term_hs_discount_percentage_enabled |
|
| Dimension |
Deals | Global Term Line Item Recurring Billing Period | hs_line_item_global_term_hs_recurring_billing_period |
|
| Dimension |
Deals | Global Term Line Item Recurring Billing Period Enabled | hs_line_item_global_term_hs_recurring_billing_period_enabled |
|
| Dimension |
Deals | Global Term Line Item Recurring Billing Start Date | hs_line_item_global_term_hs_recurring_billing_start_date |
|
| Dimension |
Deals | Global Term Line Item Recurring Billing Start Date Enabled | hs_line_item_global_term_hs_recurring_billing_start_date_enabled |
|
| Dimension |
Deals | Global Term Line Item Recurring Billing Frequency | hs_line_item_global_term_recurringbillingfrequency |
|
| Dimension |
Deals | Global Term Line Item Recurring Billing Frequency Enabled | hs_line_item_global_term_recurringbillingfrequency_enabled |
|
| Dimension |
Deals | Forecast category | hs_manual_forecast_category |
|
| Dimension |
Deals | Merged Deal IDs | deal_hs_merged_object_ids |
|
| Dimension |
Deals | Next step | hs_next_step |
|
| Dimension |
Deals | Record Creation Source | deal_hs_object_source |
|
| Dimension |
Deals | Record Creation Source ID | deal_hs_object_source_id |
|
| Dimension |
Deals | Record Source | deal_hs_object_source_label |
|
| Dimension |
Deals | The predicted deal amount | hs_predicted_amount |
|
| Dimension |
Deals | The predicted deal amount in your company's currency | hs_predicted_amount_in_home_currency |
|
| Dimension |
Deals | Priority | hs_priority |
|
| Dimension |
Deals | Weighted amount | hs_projected_amount |
|
| Dimension |
Deals | Weighted amount in company currency | hs_projected_amount_in_home_currency |
|
| Dimension |
Deals | Read Only Object | deal_hs_read_only |
|
| Dimension |
Deals | Deal Tags | hs_tag_ids |
|
| Dimension |
Deals | Created by user ID | deal_hs_created_by_user_id |
|
| Dimension |
Deals | Record ID | deal_hs_object_id |
|
| Dimension |
Deals | Record Creation Source User ID | deal_hs_object_source_user_id |
|
| Dimension |
Deals | Pinned Engagement ID | deal_hs_pinned_engagement_id |
|
| Dimension |
Deals | Source Object ID | deal_hs_source_object_id |
|
| Dimension |
Deals | Updated by user ID | deal_hs_updated_by_user_id |
|
| Dimension |
Deals | Time in 'Appointment Scheduled (Sales Pipeline)' | hs_time_in_appointmentscheduled |
|
| Dimension |
Deals | Time in 'Closed Lost (Sales Pipeline)' | hs_time_in_closedlost |
|
| Dimension |
Deals | Time in 'Closed Won (Sales Pipeline)' | hs_time_in_closedwon |
|
| Dimension |
Deals | Time in 'Contract Sent (Sales Pipeline)' | hs_time_in_contractsent |
|
| Dimension |
Deals | Time in 'Decision Maker Bought-In (Sales Pipeline)' | hs_time_in_decisionmakerboughtin |
|
| Dimension |
Deals | Time in 'Presentation Scheduled (Sales Pipeline)' | hs_time_in_presentationscheduled |
|
| Dimension |
Deals | Time in 'Qualified To Buy (Sales Pipeline)' | hs_time_in_qualifiedtobuy |
|
| Dimension |
Deals | Unique creation key | deal_hs_unique_creation_key |
|
| Dimension |
Deals | User IDs of all notification followers | deal_hs_user_ids_of_all_notification_followers |
|
| Dimension |
Deals | User IDs of all notification unfollowers | deal_hs_user_ids_of_all_notification_unfollowers |
|
| Dimension |
Deals | User IDs of all owners | deal_hs_user_ids_of_all_owners |
|
| Dimension |
Deals | Date entered "Appointment Scheduled (Sales Pipeline)" | hs_v2_date_entered_appointmentscheduled |
|
| Dimension |
Deals | Date entered "Closed Lost (Sales Pipeline)" | hs_v2_date_entered_closedlost |
|
| Dimension |
Deals | Date entered "Closed Won (Sales Pipeline)" | hs_v2_date_entered_closedwon |
|
| Dimension |
Deals | Date entered "Contract Sent (Sales Pipeline)" | hs_v2_date_entered_contractsent |
|
| Dimension |
Deals | Date entered "Decision Maker Bought-In (Sales Pipeline)" | hs_v2_date_entered_decisionmakerboughtin |
|
| Dimension |
Deals | Date entered "Presentation Scheduled (Sales Pipeline)" | hs_v2_date_entered_presentationscheduled |
|
| Dimension |
Deals | Date entered "Qualified To Buy (Sales Pipeline)" | hs_v2_date_entered_qualifiedtobuy |
|
| Dimension |
Deals | Date exited "Appointment Scheduled (Sales Pipeline)" | hs_v2_date_exited_appointmentscheduled |
|
| Dimension |
Deals | Date exited "Closed Lost (Sales Pipeline)" | hs_v2_date_exited_closedlost |
|
| Dimension |
Deals | Date exited "Closed Won (Sales Pipeline)" | hs_v2_date_exited_closedwon |
|
| Dimension |
Deals | Date exited "Contract Sent (Sales Pipeline)" | hs_v2_date_exited_contractsent |
|
| Dimension |
Deals | Date exited "Decision Maker Bought-In (Sales Pipeline)" | hs_v2_date_exited_decisionmakerboughtin |
|
| Dimension |
Deals | Date exited "Presentation Scheduled (Sales Pipeline)" | hs_v2_date_exited_presentationscheduled |
|
| Dimension |
Deals | Date exited "Qualified To Buy (Sales Pipeline)" | hs_v2_date_exited_qualifiedtobuy |
|
| Dimension |
Deals | Performed in an import | deal_hs_was_imported |
|
| Dimension |
Deals | Owner Assigned Date | deal_hubspot_owner_assigneddate |
|
| Dimension |
Deals | Deal Name | dealname |
|
| Dimension |
Deals | Deal Stage | dealstage |
|
| Dimension |
Deals | Deal Close Date | deal_closedate |
|
| Dimension |
Deals | Create Date | deal_createdate |
|
| Dimension |
Deals | Date of last meeting booked in meetings tool | deal_engagements_last_meeting_booked |
|
| Dimension |
Deals | Campaign of last booking in meetings tool | deal_engagements_last_meeting_booked_campaign |
|
| Dimension |
Deals | Medium of last booking in meetings tool | deal_engagements_last_meeting_booked_medium |
|
| Dimension |
Deals | Source of last booking in meetings tool | deal_engagements_last_meeting_booked_source |
|
| Dimension |
Deals | Latest meeting activity | deal_hs_latest_meeting_activity |
|
| Dimension |
Deals | Recent Sales Email Replied Date | deal_hs_sales_email_last_replied |
|
| Dimension |
Deals | Deal owner | deal_hubspot_owner_id |
|
| Dimension |
Deals | Last Contacted | deal_notes_last_contacted |
|
| Dimension |
Deals | Last Activity Date | deal_notes_last_updated |
|
| Dimension |
Deals | Next Activity Date | deal_notes_next_activity_date |
|
| Dimension |
Deals | HubSpot Create Date | deal_hs_createdate |
|
| Dimension |
Deals | HubSpot Team | deal_hubspot_team_id |
|
| Dimension |
Deals | Deal Type | dealtype |
|
| Dimension |
Deals | All owner ids | deal_hs_all_owner_ids |
|
| Dimension |
Deals | Deal Description | deal_description |
|
| Dimension |
Deals | All team ids | deal_hs_all_team_ids |
|
| Dimension |
Deals | All teams | deal_hs_all_accessible_team_ids |
|
| Dimension |
Deals | Closed Lost Reason | closed_lost_reason |
|
| Dimension |
Deals | Closed Won Reason | closed_won_reason |
|
| Dimension |
Tickets | Ticket ID | ticket_id |
|
| Dimension |
Tickets | Created by | created_by |
|
| Dimension |
Tickets | Applied SLA Rule Config ID | hs_applied_sla_rule_config_id |
|
| Dimension |
Tickets | Created by user ID | ticket_hs_created_by_user_id |
|
| Dimension |
Tickets | Custom inbox ID | hs_custom_inbox |
|
| Dimension |
Tickets | Inbox ID | hs_inbox_id |
|
| Dimension |
Tickets | Record ID | ticket_hs_object_id |
|
| Dimension |
Tickets | Record Creation Source User ID | ticket_hs_object_source_user_id |
|
| Dimension |
Tickets | Originating email engagement id | hs_originating_email_engagement_id |
|
| Dimension |
Tickets | Pinned Engagement ID | ticket_hs_pinned_engagement_id |
|
| Dimension |
Tickets | Source Object ID | ticket_hs_source_object_id |
|
| Dimension |
Tickets | Updated by user ID | ticket_hs_updated_by_user_id |
|
| Dimension |
Tickets | Close date | closed_date |
|
| Dimension |
Tickets | Create date | ticket_createdate |
|
| Dimension |
Tickets | First agent email response date | first_agent_reply_date |
|
| Dimension |
Tickets | Business units | ticket_hs_all_assigned_business_unit_ids |
|
| Dimension |
Tickets | All associated contact companies | hs_all_associated_contact_companies |
|
| Dimension |
Tickets | All associated contact emails | hs_all_associated_contact_emails |
|
| Dimension |
Tickets | All associated contact first names | hs_all_associated_contact_firstnames |
|
| Dimension |
Tickets | All associated contact last names | hs_all_associated_contact_lastnames |
|
| Dimension |
Tickets | All associated contact mobile phones | hs_all_associated_contact_mobilephones |
|
| Dimension |
Tickets | All associated contact phones | hs_all_associated_contact_phones |
|
| Dimension |
Tickets | All conversation mentions | hs_all_conversation_mentions |
|
| Dimension |
Tickets | Assigned Teams | hs_assigned_team_ids |
|
| Dimension |
Tickets | Assignment Method | hs_assignment_method |
|
| Dimension |
Tickets | Originating Conversations Message Id | hs_conversations_originating_message_id |
|
| Dimension |
Tickets | HubSpot create date | ticket_hs_createdate |
|
| Dimension |
Tickets | Date entered 'New (Support Pipeline)' | hs_date_entered_1 |
|
| Dimension |
Tickets | Date entered 'Waiting on contact (Support Pipeline)' | hs_date_entered_2 |
|
| Dimension |
Tickets | Date entered 'Waiting on us (Support Pipeline)' | hs_date_entered_3 |
|
| Dimension |
Tickets | Date entered 'Closed (Support Pipeline)' | hs_date_entered_4 |
|
| Dimension |
Tickets | Date exited 'New (Support Pipeline)' | hs_date_exited_1 |
|
| Dimension |
Tickets | Date exited 'Waiting on contact (Support Pipeline)' | hs_date_exited_2 |
|
| Dimension |
Tickets | Date exited 'Waiting on us (Support Pipeline)' | hs_date_exited_3 |
|
| Dimension |
Tickets | Date exited 'Closed (Support Pipeline)' | hs_date_exited_4 |
|
| Dimension |
Tickets | External object ids | hs_external_object_ids |
|
| Dimension |
Tickets | Last CES survey comment | hs_feedback_last_ces_follow_up |
|
| Dimension |
Tickets | Last CES survey rating | hs_feedback_last_ces_rating |
|
| Dimension |
Tickets | Last CES survey date | ticket_hs_feedback_last_survey_date |
|
| Dimension |
Tickets | File upload | hs_file_upload |
|
| Dimension |
Tickets | First agent response date | hs_first_agent_message_sent_at |
|
| Dimension |
Tickets | Helpdesk Sort Timestamp | hs_helpdesk_sort_timestamp |
|
| Dimension |
Tickets | In Help Desk | hs_in_helpdesk |
|
| Dimension |
Tickets | Is Visible in Help desk | hs_is_visible_in_help_desk |
|
| Dimension |
Tickets | Last email activity | hs_last_email_activity |
|
| Dimension |
Tickets | Last email date | hs_last_email_date |
|
| Dimension |
Tickets | Last message from visitor | hs_last_message_from_visitor |
|
| Dimension |
Tickets | Last message received date | hs_last_message_received_at |
|
| Dimension |
Tickets | Last response date | hs_last_message_sent_at |
|
| Dimension |
Tickets | Last activity date | hs_lastactivitydate |
|
| Dimension |
Tickets | Last contacted date | hs_lastcontacted |
|
| Dimension |
Tickets | Last modified date | ticket_hs_lastmodifieddate |
|
| Dimension |
Tickets | Latest message seen by agent ids | hs_latest_message_seen_by_agent_ids |
|
| Dimension |
Tickets | Merged Ticket IDs | ticket_hs_merged_object_ids |
|
| Dimension |
Tickets | Most relevant SLA status | hs_most_relevant_sla_status |
|
| Dimension |
Tickets | Most Relevant SLA Type | hs_most_relevant_sla_type |
|
| Dimension |
Tickets | Microsoft Teams message ID for this ticket. | hs_msteams_message_id |
|
| Dimension |
Tickets | Next activity date | hs_nextactivitydate |
|
| Dimension |
Tickets | Record Creation Source | ticket_hs_object_source |
|
| Dimension |
Tickets | Record Creation Source ID | ticket_hs_object_source_id |
|
| Dimension |
Tickets | Record Source | ticket_hs_object_source_label |
|
| Dimension |
Tickets | Originating channel account | hs_originating_channel_instance_id |
|
| Dimension |
Tickets | Originating channel type | hs_originating_generic_channel_id |
|
| Dimension |
Tickets | Ticket Pipeline | ticket_hs_pipeline |
|
| Dimension |
Tickets | Ticket status | hs_pipeline_stage |
|
| Dimension |
Tickets | Primary Company | hs_primary_company |
|
| Dimension |
Tickets | Primary Company ID | hs_primary_company_id |
|
| Dimension |
Tickets | Primary Company Name | hs_primary_company_name |
|
| Dimension |
Tickets | Read Only Object | ticket_hs_read_only |
|
| Dimension |
Tickets | Resolution | hs_resolution |
|
| Dimension |
Tickets | Users interaction | hs_seen_by_agent_ids |
|
| Dimension |
Tickets | Ticket Tags | ticket_hs_tag_ids |
|
| Dimension |
Tickets | Thread IDs To Restore | hs_thread_ids_to_restore |
|
| Dimension |
Tickets | Category | hs_ticket_category |
|
| Dimension |
Tickets | Ticket ID | hs_ticket_id |
|
| Dimension |
Tickets | Priority | hs_ticket_priority |
|
| Dimension |
Tickets | Time in 'New (Support Pipeline)' | hs_time_in_1 |
|
| Dimension |
Tickets | Time in 'Waiting on contact (Support Pipeline)' | hs_time_in_2 |
|
| Dimension |
Tickets | Time in 'Waiting on us (Support Pipeline)' | hs_time_in_3 |
|
| Dimension |
Tickets | Time in 'Closed (Support Pipeline)' | hs_time_in_4 |
|
| Dimension |
Tickets | Time to Close SLA Due Date | hs_time_to_close_sla_at |
|
| Dimension |
Tickets | Time to Close SLA Ticket Status | hs_time_to_close_sla_status |
|
| Dimension |
Tickets | Time to First Response SLA Due Date | hs_time_to_first_response_sla_at |
|
| Dimension |
Tickets | Time to First Response SLA Status | hs_time_to_first_response_sla_status |
|
| Dimension |
Tickets | Time to Next Response SLA Due Date | hs_time_to_next_response_sla_at |
|
| Dimension |
Tickets | Time to Next Response SLA Status | hs_time_to_next_response_sla_status |
|
| Dimension |
Tickets | Unique creation key | ticket_hs_unique_creation_key |
|
| Dimension |
Tickets | User IDs of all notification followers | ticket_hs_user_ids_of_all_notification_followers |
|
| Dimension |
Tickets | User IDs of all notification unfollowers | ticket_hs_user_ids_of_all_notification_unfollowers |
|
| Dimension |
Tickets | User IDs of all owners | ticket_hs_user_ids_of_all_owners |
|
| Dimension |
Tickets | Performed in an import | ticket_hs_was_imported |
|
| Dimension |
Tickets | Owner assigned date | ticket_hubspot_owner_assigneddate |
|
| Dimension |
Tickets | Date of last engagement | last_engagement_date |
|
| Dimension |
Tickets | Last customer reply date | last_reply_date |
|
| Dimension |
Tickets | NPS follow up | nps_follow_up_answer |
|
| Dimension |
Tickets | Conversation NPS score | nps_score |
|
| Dimension |
Tickets | Reference to email thread | source_thread_id |
|
| Dimension |
Tickets | Time to close | time_to_close |
|
| Dimension |
Tickets | Ticket name | subject |
|
| Dimension |
Tickets | Ticket description | content |
|
| Dimension |
Tickets | Source | source_type |
|
| Dimension |
Tickets | Reference to source-specific object | source_ref |
|
| Dimension |
Tickets | Tags | tags |
|
| Dimension |
Tickets | Recent Sales Email Replied Date | ticket_hs_sales_email_last_replied |
|
| Dimension |
Tickets | Ticket owner | ticket_hubspot_owner_id |
|
| Dimension |
Tickets | Last Contacted (Ticket Note) | ticket_notes_last_contacted |
|
| Dimension |
Tickets | Last Activity Date (Ticket Note) | ticket_notes_last_updated |
|
| Dimension |
Tickets | Next Activity Date (Ticket Note) | ticket_notes_next_activity_date |
|
| Dimension |
Tickets | HubSpot team | ticket_hubspot_team_id |
|
| Dimension |
Tickets | All owner ids | ticket_hs_all_owner_ids |
|
| Dimension |
Tickets | All team ids | ticket_hs_all_team_ids |
|
| Dimension |
Tickets | All teams | ticket_hs_all_accessible_team_ids |
|
| Dimension |
Line Items | Line Item ID | line_item_id |
|
| Dimension |
Line Items | Net price | amount |
|
| Dimension |
Line Items | Create Date | line_item_createdate |
|
| Dimension |
Line Items | Description | line_item_description |
|
| Dimension |
Line Items | Annual contract value | hs_acv |
|
| Dimension |
Line Items | All teams | line_item_hs_all_accessible_team_ids |
|
| Dimension |
Line Items | Business units | line_item_hs_all_assigned_business_unit_ids |
|
| Dimension |
Line Items | All owner ids | line_item_hs_all_owner_ids |
|
| Dimension |
Line Items | All team ids | line_item_hs_all_team_ids |
|
| Dimension |
Line Items | External LineItem id | hs_external_id |
|
| Dimension |
Line Items | Created by user ID | line_item_hs_created_by_user_id |
|
| Dimension |
Line Items | Record ID | line_item_hs_object_id |
|
| Dimension |
Line Items | Record Creation Source User ID | line_item_hs_object_source_user_id |
|
| Dimension |
Line Items | Product ID | hs_product_id |
|
| Dimension |
Line Items | Updated by user ID | line_item_hs_updated_by_user_id |
|
| Dimension |
Line Items | Variant id of the product | hs_variant_id |
|
| Dimension |
Line Items | Allow buyer selected quantity | hs_allow_buyer_selected_quantity |
|
| Dimension |
Line Items | Annual recurring revenue | hs_arr |
|
| Dimension |
Line Items | Billing Period End Date | hs_billing_period_end_date |
|
| Dimension |
Line Items | Billing Period Start Date | hs_billing_period_start_date |
|
| Dimension |
Line Items | Start billing terms | hs_billing_start_delay_type |
|
| Dimension |
Line Items | Object create date/time | line_item_hs_createdate |
|
| Dimension |
Line Items | Image URL | hs_images |
|
| Dimension |
Line Items | Last Modified Date | line_item_hs_lastmodifieddate |
|
| Dimension |
Line Items | Currency | hs_line_item_currency_code |
|
| Dimension |
Line Items | Margin | hs_margin |
|
| Dimension |
Line Items | Annual contract value margin | hs_margin_acv |
|
| Dimension |
Line Items | Annual recurring revenue margin | hs_margin_arr |
|
| Dimension |
Line Items | Monthly recurring revenue margin | hs_margin_mrr |
|
| Dimension |
Line Items | Total contract value margin | hs_margin_tcv |
|
| Dimension |
Line Items | Merged record IDs | line_item_hs_merged_object_ids |
|
| Dimension |
Line Items | Monthly recurring revenue | hs_mrr |
|
| Dimension |
Line Items | Record Creation Source | line_item_hs_object_source |
|
| Dimension |
Line Items | Record Creation Source ID | line_item_hs_object_source_id |
|
| Dimension |
Line Items | Record Source | line_item_hs_object_source_label |
|
| Dimension |
Line Items | Net Price after tax | hs_post_tax_amount |
|
| Dimension |
Line Items | Pre Discount Amount | hs_pre_discount_amount |
|
| Dimension |
Line Items | Product Type | hs_product_type |
|
| Dimension |
Line Items | Read Only Object | line_item_hs_read_only |
|
| Dimension |
Line Items | Billing end date | hs_recurring_billing_end_date |
|
| Dimension |
Line Items | Number of payments | hs_recurring_billing_number_of_payments |
|
| Dimension |
Line Items | Term | hs_recurring_billing_period |
|
| Dimension |
Line Items | Billing start date | hs_recurring_billing_start_date |
|
| Dimension |
Line Items | Billing terms | hs_recurring_billing_terms |
|
| Dimension |
Line Items | SKU | hs_sku |
|
| Dimension |
Line Items | Tax Amount | hs_tax_amount |
|
| Dimension |
Line Items | Tax Type | hs_tax_type |
|
| Dimension |
Line Items | Total contract value | hs_tcv |
|
| Dimension |
Line Items | Term in months | hs_term_in_months |
|
| Dimension |
Line Items | Calculated Total Discount | hs_total_discount |
|
| Dimension |
Line Items | Unique creation key | line_item_hs_unique_creation_key |
|
| Dimension |
Line Items | URL | hs_url |
|
| Dimension |
Line Items | User IDs of all notification followers | line_item_hs_user_ids_of_all_notification_followers |
|
| Dimension |
Line Items | User IDs of all notification unfollowers | line_item_hs_user_ids_of_all_notification_unfollowers |
|
| Dimension |
Line Items | User IDs of all owners | line_item_hs_user_ids_of_all_owners |
|
| Dimension |
Line Items | Performed in an import | line_item_hs_was_imported |
|
| Dimension |
Line Items | Owner Assigned Date | line_item_hubspot_owner_assigneddate |
|
| Dimension |
Line Items | Owner | line_item_hubspot_owner_id |
|
| Dimension |
Line Items | HubSpot Team | line_item_hubspot_team_id |
|
| Dimension |
Line Items | Name | line_item_name |
|
| Dimension |
Line Items | Billing frequency | recurringbillingfrequency |
|
| Dimension |
Products | Product ID | product_id |
|
| Dimension |
Products | Create Date | product_createdate |
|
| Dimension |
Products | Product description | product_description |
|
| Dimension |
Products | All teams | product_hs_all_accessible_team_ids |
|
| Dimension |
Products | Business units | product_hs_all_assigned_business_unit_ids |
|
| Dimension |
Products | All owner ids | product_hs_all_owner_ids |
|
| Dimension |
Products | All team ids | product_hs_all_team_ids |
|
| Dimension |
Products | Avatar FileManager key | product_hs_avatar_filemanager_key |
|
| Dimension |
Products | Object create date/time | product_hs_createdate |
|
| Dimension |
Products | Folder | hs_folder |
|
| Dimension |
Products | Folder name | hs_folder_name |
|
| Dimension |
Products | Image Url | product_hs_images |
|
| Dimension |
Products | Last Modified Date | product_hs_lastmodifieddate |
|
| Dimension |
Products | Merged record IDs | product_hs_merged_object_ids |
|
| Dimension |
Products | Record Creation Source | product_hs_object_source |
|
| Dimension |
Products | Record Creation Source ID | product_hs_object_source_id |
|
| Dimension |
Products | Record Source | product_hs_object_source_label |
|
| Dimension |
Products | Product Type | product_hs_product_type |
|
| Dimension |
Products | Read Only Object | product_hs_read_only |
|
| Dimension |
Products | Term | product_hs_recurring_billing_period |
|
| Dimension |
Products | Start Date | product_hs_recurring_billing_start_date |
|
| Dimension |
Products | SKU | product_hs_sku |
|
| Dimension |
Products | Unique creation key | product_hs_unique_creation_key |
|
| Dimension |
Products | URL | product_hs_url |
|
| Dimension |
Products | User IDs of all notification followers | product_hs_user_ids_of_all_notification_followers |
|
| Dimension |
Products | User IDs of all notification unfollowers | product_hs_user_ids_of_all_notification_unfollowers |
|
| Dimension |
Products | User IDs of all owners | product_hs_user_ids_of_all_owners |
|
| Dimension |
Products | Performed in an import | product_hs_was_imported |
|
| Dimension |
Products | Owner Assigned Date | product_hubspot_owner_assigneddate |
|
| Dimension |
Products | Owner | product_hubspot_owner_id |
|
| Dimension |
Products | HubSpot Team | product_hubspot_team_id |
|
| Dimension |
Products | Name | product_name |
|
| Dimension |
Products | Created by user ID | product_hs_created_by_user_id |
|
| Dimension |
Products | Folder Id | hs_folder_id |
|
| Dimension |
Products | Record ID | product_hs_object_id |
|
| Dimension |
Products | Record Creation Source User ID | product_hs_object_source_user_id |
|
| Dimension |
Products | Updated by user ID | product_hs_updated_by_user_id |
|
| Dimension |
Products | Billing frequency | product_recurringbillingfrequency |
|
| Dimension |
Forms | Form ID | form_id |
|
| Dimension |
Forms | Form name | form_name |
|
| Dimension |
Forms | Form created date | form_created_date |
|
| Dimension |
Forms | Form is archived | form_is_archived |
|
| Dimension |
Analytics Breakdowns | Sessions | breakdown_sessions |
|
| Dimension |
Analytics Breakdowns | Sources | breakdown_sources |
|
| Dimension |
Analytics Breakdowns | Locations | breakdown_geolocations |
|
| Dimension |
Analytics Breakdowns | UTM Campaigns | breakdown_utm_campaigns |
|
| Dimension |
Analytics Breakdowns | UTM Contents | breakdown_utm_contents |
|
| Dimension |
Analytics Breakdowns | UTM Mediums | breakdown_utm_mediums |
|
| Dimension |
Analytics Breakdowns | UTM Sources | breakdown_utm_sources |
|
| Dimension |
Analytics Breakdowns | UTM Terms | breakdown_utm_terms |
|
| Dimension |
Email Campaign | Campaign Sent | campaign_email_sent |
|
| Metric |
Email Campaign | Emails Delivered | campaign_email_delivered |
|
| Metric |
Email Campaign | Emails Open | campaign_email_open |
|
| Metric |
Email Campaign | Emails Processed | campaign_email_processed |
|
| Metric |
Email Stats | Emails Sent | email_sent |
|
| Metric |
Email Stats | Emails Open | email_open |
|
| Metric |
Email Stats | Emails Delivered | email_delivered |
|
| Metric |
Email Stats | Emails Bounce | email_bounce |
|
| Metric |
Email Stats | Emails Unsubscribed | email_unsubscribed |
|
| Metric |
Email Stats | Emails Click | email_click |
|
| Metric |
Email Stats | Emails Dropped | email_dropped |
|
| Metric |
Email Stats | Emails Selected | email_selected |
|
| Metric |
Email Stats | Emails Spam report | email_spamreport |
|
| Metric |
Email Stats | Emails Suppressed | email_suppressed |
|
| Metric |
Email Stats | Emails Hard bounced | email_hardbounced |
|
| Metric |
Email Stats | Emails Soft bounced | email_softbounced |
|
| Metric |
Email Stats | Emails Pending | email_pending |
|
| Metric |
Email Stats | Emails Contacts lost | email_contacts_lost |
|
| Metric |
Email Stats | Emails not Sent | email_not_sent |
|
| Metric |
Companies | Facebook Fans | facebookfans |
|
| Metric |
Companies | Number of Pageviews | company_hs_analytics_num_page_views |
|
| Metric |
Companies | Number of Sessions | company_hs_analytics_num_visits |
|
| Metric |
Companies | Number of blockers | hs_num_blockers |
|
| Metric |
Companies | Number of contacts with a buying role | hs_num_contacts_with_buying_roles |
|
| Metric |
Companies | Number of decision makers | hs_num_decision_makers |
|
| Metric |
Companies | Number of open deals | hs_num_open_deals |
|
| Metric |
Companies | Likelihood to close | company_hs_predictivecontactscore_v2 |
|
| Metric |
Companies | Target Account Probability | hs_target_account_probability |
|
| Metric |
Companies | Total open deal value | hs_total_deal_value |
|
| Metric |
Companies | Number of Associated Contacts | num_associated_contacts |
|
| Metric |
Companies | Number of Associated Deals | company_num_associated_deals |
|
| Metric |
Companies | Number of Form Submissions | company_num_conversion_events |
|
| Metric |
Companies | Recent Deal Amount | company_recent_deal_amount |
|
| Metric |
Companies | Twitter Followers | twitterfollowers |
|
| Metric |
Companies | Number of times contacted | company_num_contacted_notes |
|
| Metric |
Companies | Number of Sales Activities | company_num_notes |
|
| Metric |
Companies | Number of Employees | numberofemployees |
|
| Metric |
Companies | Annual Revenue | annualrevenue |
|
| Metric |
Companies | Parent Company | hs_parent_company_id |
|
| Metric |
Companies | Number of child companies | hs_num_child_companies |
|
| Metric |
Companies | HubSpot Score | hubspotscore |
|
| Metric |
Contacts | Contacts number | contact_num_contacts |
|
| Metric |
Contacts | Contact Unique conversion events | contact_num_unique_conversion_events |
|
| Metric |
Contacts | Contact num visits | hs_analytics_num_visits |
|
| Metric |
Contacts | Contact social linkedin clicks | hs_social_linkedin_clicks |
|
| Metric |
Contacts | Contact social num broadcast clicks | hs_social_num_broadcast_clicks |
|
| Metric |
Contacts | Contact social google plus clicks | hs_social_google_plus_clicks |
|
| Metric |
Contacts | Contact social facebook clicks | hs_social_facebook_clicks |
|
| Metric |
Contacts | Contact social twitter clicks | hs_social_twitter_clicks |
|
| Metric |
Contacts | Contact social total clicks | hs_social_total_clicks |
|
| Metric |
Contacts | Contact Revenue | hs_analytics_revenue |
|
| Metric |
Contacts | Contact num page views | hs_analytics_num_page_views |
|
| Metric |
Contacts | Contact average page views | hs_analytics_average_page_views |
|
| Metric |
Contacts | Contact num conversion events | num_conversion_events |
|
| Metric |
Contacts | Sends Since Last Engagement | hs_email_sends_since_last_engagement |
|
| Metric |
Contacts | Likelihood to close | hs_predictivecontactscore_v2 |
|
| Metric |
Contacts | Number of sequences actively enrolled | hs_sequences_actively_enrolled_count |
|
| Metric |
Contacts | Number of sequences enrolled | hs_sequences_enrolled_count |
|
| Metric |
Contacts | Cumulative time in "Customer (Lifecycle Stage Pipeline)" | hs_v2_cumulative_time_in_customer |
|
| Metric |
Contacts | Cumulative time in "Evangelist (Lifecycle Stage Pipeline)" | hs_v2_cumulative_time_in_evangelist |
|
| Metric |
Contacts | Cumulative time in "Lead (Lifecycle Stage Pipeline)" | hs_v2_cumulative_time_in_lead |
|
| Metric |
Contacts | Cumulative time in "Marketing Qualified Lead (Lifecycle Stage Pipeline)" | hs_v2_cumulative_time_in_marketingqualifiedlead |
|
| Metric |
Contacts | Cumulative time in "Opportunity (Lifecycle Stage Pipeline)" | hs_v2_cumulative_time_in_opportunity |
|
| Metric |
Contacts | Cumulative time in "Other (Lifecycle Stage Pipeline)" | hs_v2_cumulative_time_in_other |
|
| Metric |
Contacts | Cumulative time in "Sales Qualified Lead (Lifecycle Stage Pipeline)" | hs_v2_cumulative_time_in_salesqualifiedlead |
|
| Metric |
Contacts | Cumulative time in "Subscriber (Lifecycle Stage Pipeline)" | hs_v2_cumulative_time_in_subscriber |
|
| Metric |
Contacts | Latest time in "Customer (Lifecycle Stage Pipeline)" | hs_v2_latest_time_in_customer |
|
| Metric |
Contacts | Latest time in "Evangelist (Lifecycle Stage Pipeline)" | hs_v2_latest_time_in_evangelist |
|
| Metric |
Contacts | Latest time in "Lead (Lifecycle Stage Pipeline)" | hs_v2_latest_time_in_lead |
|
| Metric |
Contacts | Latest time in "Marketing Qualified Lead (Lifecycle Stage Pipeline)" | hs_v2_latest_time_in_marketingqualifiedlead |
|
| Metric |
Contacts | Latest time in "Opportunity (Lifecycle Stage Pipeline)" | hs_v2_latest_time_in_opportunity |
|
| Metric |
Contacts | Latest time in "Other (Lifecycle Stage Pipeline)" | hs_v2_latest_time_in_other |
|
| Metric |
Contacts | Latest time in "Sales Qualified Lead (Lifecycle Stage Pipeline)" | hs_v2_latest_time_in_salesqualifiedlead |
|
| Metric |
Contacts | Latest time in "Subscriber (Lifecycle Stage Pipeline)" | hs_v2_latest_time_in_subscriber |
|
| Metric |
Contacts | Number of Associated Deals | num_associated_deals |
|
| Metric |
Contacts | Number of Unique Forms Submitted | num_unique_conversion_events |
|
| Metric |
Contacts | Recent Deal Amount | recent_deal_amount |
|
| Metric |
Contacts | Total Revenue | total_revenue |
|
| Metric |
Contacts | Marketing emails delivered | hs_email_delivered |
|
| Metric |
Contacts | Follower Count | followercount |
|
| Metric |
Contacts | Marketing emails opened | hs_email_open |
|
| Metric |
Contacts | Marketing emails clicked | hs_email_click |
|
| Metric |
Contacts | Marketing emails bounced | hs_email_bounce |
|
| Metric |
Contacts | Number of event completions | hs_analytics_num_event_completions |
|
| Metric |
Contacts | Number of times contacted | num_contacted_notes |
|
| Metric |
Contacts | Number of Sales Activities | num_notes |
|
| Metric |
Contacts | SurveyMonkey Event Last Updated | surveymonkeyeventlastupdated |
|
| Metric |
Contacts | Webinar Event Last Updated | webinareventlastupdated |
|
| Metric |
Contacts | LinkedIn Connections | linkedinconnections |
|
| Metric |
Contacts | Klout Score | kloutscoregeneral |
|
| Metric |
Contacts | Marketing emails replied | hs_email_replied |
|
| Metric |
Contacts | Associated Company Last Updated | associatedcompanylastupdated |
|
| Metric |
Contacts | Predictive Lead Score | hs_predictivecontactscore |
|
| Metric |
Deals | Deal number of contacts | deal_num_contacts |
|
| Metric |
Deals | Deal Amount | deal_amount |
|
| Metric |
Deals | Annual contract value | hs_acv |
|
| Metric |
Deals | Latest Source | hs_analytics_latest_source |
|
| Metric |
Deals | Latest Source Data 1 | hs_analytics_latest_source_data_1 |
|
| Metric |
Deals | Latest Source Data 2 | hs_analytics_latest_source_data_2 |
|
| Metric |
Deals | Annual recurring revenue | hs_arr |
|
| Metric |
Deals | Closed won count | hs_closed_won_count |
|
| Metric |
Deals | Deal Score | hs_deal_score |
|
| Metric |
Deals | Deal probability | hs_deal_stage_probability |
|
| Metric |
Deals | Exchange rate | hs_exchange_rate |
|
| Metric |
Deals | Forecast amount | hs_forecast_amount |
|
| Metric |
Deals | Forecast probability | hs_forecast_probability |
|
| Metric |
Deals | Likelihood to close by the close date | hs_likelihood_to_close |
|
| Metric |
Deals | Monthly recurring revenue | hs_mrr |
|
| Metric |
Deals | Number of Active Deal Registrations | hs_num_associated_active_deal_registrations |
|
| Metric |
Deals | Number of Deal Registrations | hs_num_associated_deal_registrations |
|
| Metric |
Deals | Number of Deal Splits | hs_num_associated_deal_splits |
|
| Metric |
Deals | Number of Associated Line Items | hs_num_of_associated_line_items |
|
| Metric |
Deals | Number of target accounts | hs_num_target_accounts |
|
| Metric |
Deals | Total contract value | hs_tcv |
|
| Metric |
Deals | Latest Source Timestamp | hs_analytics_latest_source_timestamp |
|
| Metric |
Deals | Cumulative time in "Appointment Scheduled (Sales Pipeline)" | hs_v2_cumulative_time_in_appointmentscheduled |
|
| Metric |
Deals | Cumulative time in "Closed Lost (Sales Pipeline)" | hs_v2_cumulative_time_in_closedlost |
|
| Metric |
Deals | Cumulative time in "Closed Won (Sales Pipeline)" | hs_v2_cumulative_time_in_closedwon |
|
| Metric |
Deals | Cumulative time in "Contract Sent (Sales Pipeline)" | hs_v2_cumulative_time_in_contractsent |
|
| Metric |
Deals | Cumulative time in "Decision Maker Bought-In (Sales Pipeline)" | hs_v2_cumulative_time_in_decisionmakerboughtin |
|
| Metric |
Deals | Cumulative time in "Presentation Scheduled (Sales Pipeline)" | hs_v2_cumulative_time_in_presentationscheduled |
|
| Metric |
Deals | Cumulative time in "Qualified To Buy (Sales Pipeline)" | hs_v2_cumulative_time_in_qualifiedtobuy |
|
| Metric |
Deals | Latest time in "Appointment Scheduled (Sales Pipeline)" | hs_v2_latest_time_in_appointmentscheduled |
|
| Metric |
Deals | Latest time in "Closed Lost (Sales Pipeline)" | hs_v2_latest_time_in_closedlost |
|
| Metric |
Deals | Latest time in "Closed Won (Sales Pipeline)" | hs_v2_latest_time_in_closedwon |
|
| Metric |
Deals | Latest time in "Contract Sent (Sales Pipeline)" | hs_v2_latest_time_in_contractsent |
|
| Metric |
Deals | Latest time in "Decision Maker Bought-In (Sales Pipeline)" | hs_v2_latest_time_in_decisionmakerboughtin |
|
| Metric |
Deals | Latest time in "Presentation Scheduled (Sales Pipeline)" | hs_v2_latest_time_in_presentationscheduled |
|
| Metric |
Deals | Latest time in "Qualified To Buy (Sales Pipeline)" | hs_v2_latest_time_in_qualifiedtobuy |
|
| Metric |
Deals | Amount | amount |
|
| Metric |
Deals | Number of times contacted | deal_num_contacted_notes |
|
| Metric |
Deals | Number of Sales Activities | deal_num_notes |
|
| Metric |
Deals | Number of Associated Contacts | deal_num_associated_contacts |
|
| Metric |
Tickets | Auto-generated from thread id | hs_auto_generated_from_thread_id |
|
| Metric |
Tickets | Conversations originating thread id | hs_conversations_originating_thread_id |
|
| Metric |
Tickets | Number of Associated Companies | hs_num_associated_companies |
|
| Metric |
Tickets | Number of Associated Conversations | hs_num_associated_conversations |
|
| Metric |
Tickets | Number of times contacted | hs_num_times_contacted |
|
| Metric |
Tickets | NPS follow up question | nps_follow_up_question_version |
|
| Metric |
Tickets | Time to first agent email reply | time_to_first_agent_reply |
|
| Metric |
Tickets | Number of times contacted (Ticket Note) | ticket_num_contacted_notes |
|
| Metric |
Tickets | Number of Sales Activities | ticket_num_notes |
|
| Metric |
Line Items | Unit discount | discount |
|
| Metric |
Line Items | Delayed billing start by days | hs_billing_start_delay_days |
|
| Metric |
Line Items | Delayed billing start by months | hs_billing_start_delay_months |
|
| Metric |
Line Items | Unit cost | hs_cost_of_goods_sold |
|
| Metric |
Line Items | Discount Percentage | hs_discount_percentage |
|
| Metric |
Line Items | Position on quote | hs_position_on_quote |
|
| Metric |
Line Items | Sync amount | hs_sync_amount |
|
| Metric |
Line Items | Tax Rate | hs_tax_rate |
|
| Metric |
Line Items | Unit price | price |
|
| Metric |
Line Items | Quantity | quantity |
|
| Metric |
Line Items | Tax | tax |
|
| Metric |
Products | Net price | product_amount |
|
| Metric |
Products | Unit discount | product_discount |
|
| Metric |
Products | Unit cost | product_hs_cost_of_goods_sold |
|
| Metric |
Products | Discount Percentage | product_hs_discount_percentage |
|
| Metric |
Products | Unit price | product_price |
|
| Metric |
Products | Quantity | product_quantity |
|
| Metric |
Products | Tax | product_tax |
|
| Metric |
Analytics | Raw Views | analytics_raw_views |
|
| Metric |
Analytics | Leads | analytics_leads |
|
| Metric |
Analytics | Visits | analytics_visits |
|
| Metric |
Analytics | Number of contacts | analytics_num_contacts |
|
| Metric |