1 of 2

Legend

🔑 = primary key

= foreign key relation

= external link

For extended ERD check the HubSpot Sales/CRM Schema

breakdown 🔑

bounce_rate

bounces

contacts

contacts_per_pageview

contact_to_customer_rate

customers

leads

leads_per_view

marketing_qualified_leads

new_visitor_session_rate

opportunities

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

sales_qualified_leads

session_to_contact_rate

standard_views

subscribers

time

time_per_session

visitors

visits

SOURCES_ANALYTICS_OVERALL_REPORT

breakdown 🔑

date 🔑

bounce_rate

bounces

contacts

contacts_per_pageview

contact_to_customer_rate

customers

leads

leads_per_view

marketing_qualified_leads

new_visitor_session_rate

opportunities

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

sales_qualified_leads

session_to_contact_rate

standard_views

subscribers

time

time_per_session

visitors

visits

SOURCES_ANALYTICS_MONTHLY_REPORT

breakdown 🔑

date 🔑

bounce_rate

bounces

contacts

contacts_per_pageview

contact_to_customer_rate

customers

leads

leads_per_view

marketing_qualified_leads

new_visitor_session_rate

opportunities

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

sales_qualified_leads

session_to_contact_rate

standard_views

subscribers

time

time_per_session

visitors

visits

SOURCES_ANALYTICS_WEEKLY_REPORT

breakdown 🔑

date 🔑

bounce_rate

bounces

contacts

contacts_per_pageview

contact_to_customer_rate

customers

leads

leads_per_view

marketing_qualified_leads

new_visitor_session_rate

opportunities

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

sales_qualified_leads

session_to_contact_rate

standard_views

subscribers

time

time_per_session

visitors

visits

SOURCES_ANALYTICS_DAILY_REPORT

breakdown 🔑

desktop

direct_traffic

email_marketing

mobile

other_campaigns

paid_search

social_media

SESSIONS_ANALYTICS_OVERALL_REPORT

breakdown 🔑

date 🔑

desktop

direct_traffic

email_marketing

mobile

other_campaigns

paid_search

social_media

SESSIONS_ANALYTICS_MONTHLY_REPORT

breakdown 🔑

date 🔑

desktop

direct_traffic

email_marketing

mobile

other_campaigns

paid_search

social_media

SESSIONS_ANALYTICS_WEEKLY_REPORT

breakdown 🔑

date 🔑

desktop

direct_traffic

email_marketing

mobile

other_campaigns

paid_search

social_media

SESSIONS_ANALYTICS_DAILY_REPORT

breakdown 🔑

bounce_rate

bounces

contacts

contacts_per_pageview

leads

leads_per_view

new_visitor_session_rate

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

session_to_contact_rate

standard_views

time

time_per_session

visitors

visits

GEOLOCATION_ANALYTICS_OVERALL_REPORT

breakdown 🔑

date 🔑

bounce_rate

bounces

contacts

contacts_per_pageview

leads

leads_per_view

new_visitor_session_rate

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

session_to_contact_rate

standard_views

time

time_per_session

visitors

visits

GEOLOCATION_ANALYTICS_MONTHLY_REPORT

breakdown 🔑

date 🔑

bounce_rate

bounces

contacts

contacts_per_pageview

leads

leads_per_view

new_visitor_session_rate

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

session_to_contact_rate

standard_views

time

time_per_session

visitors

visits

GEOLOCATION_ANALYTICS_WEEKLY_REPORT

breakdown 🔑

date 🔑

bounce_rate

bounces

contacts

contacts_per_pageview

leads

leads_per_view

new_visitor_session_rate

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

session_to_contact_rate

standard_views

time

time_per_session

visitors

visits

GEOLOCATION_ANALYTICS_DAILY_REPORT

2 of 2

Legend

🔑 = primary key

= foreign key relation

= external link

For extended ERD check the HubSpot Sales/CRM Schema

breakdown 🔑

utm_type 🔑

bounce_rate

bounces

new_visitor_session_rate

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

standard_views

time

time_per_session

visitors

visits

UTM_ANALYTICS_OVERALL_REPORT

breakdown 🔑

date 🔑

utm_type 🔑

bounce_rate

bounces

new_visitor_session_rate

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

standard_views

time

time_per_session

visitors

visits

UTM_ANALYTICS_MONTHLY_REPORT

breakdown 🔑

date 🔑

utm_type 🔑

bounce_rate

bounces

new_visitor_session_rate

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

standard_views

time

time_per_session

visitors

visits

UTM_ANALYTICS_WEEKLY_REPORT

breakdown 🔑

date 🔑

utm_type 🔑

bounce_rate

bounces

new_visitor_session_rate

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

standard_views

time

time_per_session

visitors

visits

UTM_ANALYTICS_DAILY_REPORT

date 🔑

contacts

contacts_per_pageview

leads

leads_per_view

new_visitor_session_rate

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

session_to_contact_rate

standard_views

visitors

visits

TOTALS_ANALYTICS_MONTHLY_REPORT

date 🔑

contacts

contacts_per_pageview

leads

leads_per_view

new_visitor_session_rate

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

session_to_contact_rate

standard_views

visitors

visits

TOTALS_ANALYTICS_WEEKLY_REPORT

date 🔑

contacts

contacts_per_pageview

leads

leads_per_view

new_visitor_session_rate

pageviews_minus_exits

pageviews_per_session

raw_views

returning_visits

session_to_contact_rate

standard_views

visitors

visits

TOTALS_ANALYTICS_DAILY_REPORT