List of HubSpot Objects and Metrics that are needed to build Alta Dashboards.
In order to build dashboards and analytics for your revenue engines the following tables need to be synced from your HubSpot account to Alta:
Contacts (created at, updated at, archived, properties, companies id)
Deals (archived, updated at, created at, companies id, line_items, contacts, properties)
Contacts and Deals Properties:
Analytics
hs_analytics_source
hs_analytics_first_url
hs_analytics_last_url
hs_analytics_first_timestamp
hs_analytics_last_timestamp
hs_analytics_average_page_views
hs_analytics_num_page_views
hs_analytics_first_visit_timestamp
hs_analytics_last_visit_timestamp
hs_analytics_num_visits
utm_source
utm_campaign
utm_term
utm_medium
utm_content
Engagement Metrics
engagements_last_meeting_booked
engagements_last_meeting_booked_medium
engagements_last_meeting_booked_source
engagements_last_meeting_booked_campaign
hs_email_first_open_date
hs_email_last_open_date
hs_email_first_click_date
hs_email_last_click_date
hs_email_sends_since_last_engagement
hs_email_last_reply_date
hs_email_last_email_name
hs_sales_email_last_replied
hs_sales_email_last_opened
hs_sales_email_last_clicked
hs_last_sales_activity_date
Customer Information
name
firstname
lastname
email
hs_additional_emails
state
country
jobtitle
industry
job_function
department
seniority
company
company_size
associatedcompanyid
linkedin_url
Customer Journey
hs_lead_status
hs_lifecyclestage_lead_date
hs_lifecyclestage_subscriber_date
hs_lifecyclestage_customer_date
hs_lifecyclestage_salesqualifiedlead_date
hs_lifecyclestage_opportunity_date
hs_lifecyclestage_evangelist_date
hs_lifecyclestage_ma__ingqualifiedlead_date
hs_date_entered_lead
hs_date_exited_lead
hs_date_entered_subscriber
hs_date_exited_subscriber
hs_date_entered_customer
hs_date_exited_customer
hs_date_entered_salesqualifiedlead
hs_date_exited_salesqualifiedlead
hs_date_entered_opportunity
hs_date_exited_opportunity
hs_date_entered_evangelist
hs_date_exited_evangelist
hs_date_entered_other
hs_date_exited_other
hs_time_to_move_from_lead_to_customer
hs_time_to_move_from__portunity_to_customer
hs_time_to_move_from_subscriber_to_customer
hs_time_to_move_from__iedlead_to_customer_1
hs_time_to_move_from__ifiedlead_to_customer
hs_time_to_first_engagement
hs_time_in_lead
hs_time_in_subscriber
hs_time_in_customer
hs_time_in_salesqualifiedlead
hs_time_in_marketingqualifiedlead
hs_time_in_opportunity
hs_time_in_evangelist
hs_time_in_other
recent_conversion_date
recent_conversion_event_name
Sales
recent_deal_name
recent_deal_close_date
recent_deal_amount
recent_deal_customer_demo_date
recent_deal_customer_number_of_assets
recent_deal_company_website
num_associated_deals
days_to_close
closedate
hs_time_between_cont__ion_and_deal_creation
hs_time_between_cont__eation_and_deal_close
trial_leave_detail
trial_close_reason___detailed
trial_extend___detailed
trial_extend
trial_assets_quote
amount_of_assets
total_revenue
hs_count_is_worked
hs_marketable_until_renewal
hs_marketable_status
Custom fields/objects
Custom fields are supported for all objects. If you need data from a HubSpot custom object, please contact our team with the name of the object, and we will add the source manually.
