HubSpot

Sources

report_type: sources · 26 metrics · 27 dimensions

Metrics

Field name	Label	Type
`contactToCustomerRate`	Contact to customer rateformula	NUMBER
`timePerSession`	Time per sessionformula	NUMBER
`pageviewsPerSession`	Pageviews per sessionformula	NUMBER
`bounceRate`	Bounce rate (traffic)formula	NUMBER
`newVisitorSessionRate`	New visitor session rateformula	NUMBER
`contactsPerPageview`	View to contact rateformula	NUMBER
`sessionToContactRate`	Session to contact rateformula	NUMBER
`customersPerPageview`	Customers per pageviewformula	NUMBER
`leadsPerView`	Leads per viewformula	NUMBER
`bounces`	Bounces (email)	NUMBER
`contacts`	Contacts	NUMBER
`customers`	Customers	NUMBER
`evangelists`	Evangelists	NUMBER
`leads`	Leads	NUMBER
`marketingQualifiedLeads`	Marketing qualified leads	NUMBER
`opportunities`	Opportunities	NUMBER
`others`	Others	NUMBER
`pageviewsMinusExits`	Pageviews minus exits	NUMBER
`rawViews`	Raw views	NUMBER
`returningVisits`	Returning visits	NUMBER
`salesQualifiedLeads`	Sales qualified leads	NUMBER
`standardViews`	Standard views	NUMBER
`subscribers`	Subscribers	NUMBER
`time`	Time	NUMBER
`visitors`	Visitors	NUMBER
`visits`	Visits	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`breakdown`	Breakdown by sources	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Forms (daily)

report_type: forms_daily · 12 metrics · 26 dimensions

Metrics

Field name	Label	Type
`submissionsPerFormView`	Submissions per form viewformula	NUMBER
`clickThroughPerFormView`	Clickthrough per form viewformula	NUMBER
`submissionsPerClickThrough`	Submissions per clickthroughformula	NUMBER
`completions`	Completions	NUMBER
`completionsAndUnenrolls`	Completions and unenrolls	NUMBER
`contactSubmissions`	Contact submissions	NUMBER
`formViews`	Form views	NUMBER
`installs`	Installs	NUMBER
`interactions`	Interactions	NUMBER
`nonContactSubmissions`	Non-contact submissions	NUMBER
`submissions`	Submissions	NUMBER
`visibles`	Visibles	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`year_week`	Year weekformula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Lists

report_type: lists · 1 metric · 30 dimensions

Metrics

Field name	Label	Type
`size`	Size	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`lastSizeChangeAt`	Last size change at	STRING
`list_id`	List ID	STRING
`list_name`	List name	STRING
`list_type`	List type	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Email stats

report_type: emails_stats · 32 metrics · 39 dimensions

Metrics

Field name	Label	Type
`clickratio`	Click rateformula	NUMBER
`clickthroughratio`	CTRformula	NUMBER
`deliveredratio`	Delivered rateformula	NUMBER
`openratio`	Open rateformula	NUMBER
`unsubscribedratio`	Unsubscribed rateformula	NUMBER
`spamreportratio`	Spam report rateformula	NUMBER
`bounceratio`	Bounce rate (email)formula	NUMBER
`hardbounceratio`	Hard bounce rateformula	NUMBER
`softbounceratio`	Soft bounce rateformula	NUMBER
`contactslostratio`	Contacts lost rateformula	NUMBER
`pendingratio`	Pending rateformula	NUMBER
`notsentratio`	Not sent rateformula	NUMBER
`bounce`	Bounce	NUMBER
`click`	Email clicks (email stats)	NUMBER
`click_device_breakdown_value`	Click device breakdown value	NUMBER
`contactslost`	Contacts lost	NUMBER
`deferred`	Deferred	NUMBER
`delivered`	Delivered	NUMBER
`dropped`	Dropped	NUMBER
`hardbounced`	Hard bounced	NUMBER
`notsent`	Not sent	NUMBER
`open`	Open	NUMBER
`open_device_breakdown_value`	Open device breakdown value	NUMBER
`pending`	Pending	NUMBER
`processed`	Processed	NUMBER
`reply`	Reply	NUMBER
`selected`	Selected	NUMBER
`sent`	Sent	NUMBER
`softbounced`	Soft bounced	NUMBER
`spamreport`	Spam report	NUMBER
`suppressed`	Suppressed	NUMBER
`unsubscribed`	Unsubscribed	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`campaignName`	Campaign name	STRING
`campaignUtm`	Campaign UTM	STRING
`click_device_breakdown_key`	Click device breakdown key	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`fromName`	From name	STRING
`name`	Email name	STRING
`open_device_breakdown_key`	Open device breakdown key	STRING
`primaryEmailCampaignId`	Primary email campaign ID	STRING
`publishDate`	Publish date	STRING
`replyTo`	Reply to	STRING
`reportId`	Report ID	STRING
`subject`	Subject / ticket name	STRING
`type`	Type	STRING
`url`	URL	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Landing pages (daily)

report_type: landing_pages_daily · 24 metrics · 26 dimensions

Metrics

Field name	Label	Type
`contactToCustomerRate`	Contact to customer rateformula	NUMBER
`contactsPerPageview`	View to contact rateformula	NUMBER
`customersPerPageview`	Customers per pageviewformula	NUMBER
`leadsPerView`	Leads per viewformula	NUMBER
`exitsPerPageview`	Exits per pageviewformula	NUMBER
`timePerPageview`	Avg time on pageformula	NUMBER
`submissionsPerPageview`	View to submission rateformula	NUMBER
`pageBounceRate`	Page bounce rateformula	NUMBER
`contacts`	Contacts	NUMBER
`customers`	Customers	NUMBER
`entrances`	Entrances	NUMBER
`exits`	Exits	NUMBER
`leads`	Leads	NUMBER
`marketingQualifiedLeads`	Marketing qualified leads	NUMBER
`nonContactSubmissions`	Non-contact submissions	NUMBER
`opportunities`	Opportunities	NUMBER
`pageBounces`	Page bounces	NUMBER
`pageTime`	Page time	NUMBER
`pageviewsMinusExits`	Pageviews minus exits	NUMBER
`rawViews`	Raw views	NUMBER
`salesQualifiedLeads`	Sales qualified leads	NUMBER
`standardViews`	Standard views	NUMBER
`submissions`	Submissions	NUMBER
`subscribers`	Subscribers	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`year_week`	Year weekformula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Landing pages

report_type: landing_pages · 30 metrics · 27 dimensions

Metrics

Field name	Label	Type
`contactToCustomerRate`	Contact to customer rateformula	NUMBER
`contactsPerPageview`	View to contact rateformula	NUMBER
`customersPerPageview`	Customers per pageviewformula	NUMBER
`leadsPerView`	Leads per viewformula	NUMBER
`exitsPerPageview`	Exits per pageviewformula	NUMBER
`timePerPageview`	Avg time on pageformula	NUMBER
`submissionsPerPageview`	View to submission rateformula	NUMBER
`submissionsPerCtaClick`	Submissions per CTA clickformula	NUMBER
`pageBounceRate`	Page bounce rateformula	NUMBER
`ctaRate`	CTA rateformula	NUMBER
`contacts`	Contacts	NUMBER
`ctaClicks`	CTA clicks	NUMBER
`ctaViews`	CTA views	NUMBER
`customers`	Customers	NUMBER
`entrances`	Entrances	NUMBER
`evangelists`	Evangelists	NUMBER
`exits`	Exits	NUMBER
`leads`	Leads	NUMBER
`marketingQualifiedLeads`	Marketing qualified leads	NUMBER
`nonContactSubmissions`	Non-contact submissions	NUMBER
`opportunities`	Opportunities	NUMBER
`others`	Others	NUMBER
`pageBounces`	Page bounces	NUMBER
`pageTime`	Page time	NUMBER
`pageviewsMinusExits`	Pageviews minus exits	NUMBER
`rawViews`	Raw views	NUMBER
`salesQualifiedLeads`	Sales qualified leads	NUMBER
`standardViews`	Standard views	NUMBER
`submissions`	Submissions	NUMBER
`subscribers`	Subscribers	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`landing_page_id`	Landing page ID	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Geo

report_type: geo · 3 metrics · 27 dimensions

Metrics

Field name	Label	Type
`geo_newVisitorSessionRate`	New visitor session rate (geo)formula	NUMBER
`geo_visitors`	Geo visitors	NUMBER
`geo_visits`	Geo visits	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`country`	Country	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

UTM campaign

report_type: utm_campaign · 27 metrics · 27 dimensions

Metrics

Field name	Label	Type
`contactToCustomerRate`	Contact to customer rateformula	NUMBER
`timePerSession`	Time per sessionformula	NUMBER
`pageviewsPerSession`	Pageviews per sessionformula	NUMBER
`bounceRate`	Bounce rate (traffic)formula	NUMBER
`newVisitorSessionRate`	New visitor session rateformula	NUMBER
`contactsPerPageview`	View to contact rateformula	NUMBER
`sessionToContactRate`	Session to contact rateformula	NUMBER
`customersPerPageview`	Customers per pageviewformula	NUMBER
`leadsPerView`	Leads per viewformula	NUMBER
`bounces`	Bounces (email)	NUMBER
`contacts`	Contacts	NUMBER
`customers`	Customers	NUMBER
`evangelists`	Evangelists	NUMBER
`leads`	Leads	NUMBER
`mappedBreakdown`	Mapped breakdown	NUMBER
`marketingQualifiedLeads`	Marketing qualified leads	NUMBER
`opportunities`	Opportunities	NUMBER
`others`	Others	NUMBER
`pageviewsMinusExits`	Pageviews minus exits	NUMBER
`rawViews`	Raw views	NUMBER
`returningVisits`	Returning visits	NUMBER
`salesQualifiedLeads`	Sales qualified leads	NUMBER
`standardViews`	Standard views	NUMBER
`subscribers`	Subscribers	NUMBER
`time`	Time	NUMBER
`visitors`	Visitors	NUMBER
`visits`	Visits	NUMBER

Dimensions

Field name	Label	Type
`utm_campaign`	UTM campaign	STRING
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

UTM source

report_type: utm_source · 27 metrics · 27 dimensions

Same metrics as UTM campaign. Unique dimension: utm_source (UTM source).

Dimensions (unique to this report type)

Field name	Label	Type
`utm_source`	UTM source	STRING

UTM medium

report_type: utm_medium · 27 metrics · 27 dimensions

Same metrics as UTM campaign. Unique dimension: utm_medium (UTM medium).

Dimensions (unique to this report type)

Field name	Label	Type
`utm_medium`	UTM medium	STRING

UTM content

report_type: utm_content · 27 metrics · 27 dimensions

Same metrics as UTM campaign. Unique dimension: utm_content (UTM content).

Dimensions (unique to this report type)

Field name	Label	Type
`utm_content`	UTM content	STRING

UTM term

report_type: utm_term · 27 metrics · 27 dimensions

Same metrics as UTM campaign. Unique dimension: utm_term (UTM term).

Dimensions (unique to this report type)

Field name	Label	Type
`utm_term`	UTM term	STRING

Forms

report_type: forms · 12 metrics · 29 dimensions

Metrics

Field name	Label	Type
`submissionsPerFormView`	Submissions per form viewformula	NUMBER
`clickThroughPerFormView`	Clickthrough per form viewformula	NUMBER
`submissionsPerClickThrough`	Submissions per clickthroughformula	NUMBER
`completions`	Completions	NUMBER
`completionsAndUnenrolls`	Completions and unenrolls	NUMBER
`contactSubmissions`	Contact submissions	NUMBER
`formViews`	Form views	NUMBER
`installs`	Installs	NUMBER
`interactions`	Interactions	NUMBER
`nonContactSubmissions`	Non-contact submissions	NUMBER
`submissions`	Submissions	NUMBER
`visibles`	Visibles	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`form_id`	Form ID	STRING
`form_name`	Form name	STRING
`form_type`	Form type	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Pages

report_type: pages · 14 metrics · 28 dimensions

Metrics

Field name	Label	Type
`exitsPerPageview`	Exits per pageviewformula	NUMBER
`timePerPageview`	Avg time on pageformula	NUMBER
`pageBounceRate`	Page bounce rateformula	NUMBER
`ctaRate`	CTA rateformula	NUMBER
`ampViews`	AMP views	NUMBER
`ctaClicks`	CTA clicks	NUMBER
`ctaViews`	CTA views	NUMBER
`entrances`	Entrances	NUMBER
`exits`	Exits	NUMBER
`pageBounces`	Page bounces	NUMBER
`pageTime`	Page time	NUMBER
`pageviewsMinusExits`	Pageviews minus exits	NUMBER
`rawViews`	Raw views	NUMBER
`standardViews`	Standard views	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`page_id`	Page ID	STRING
`page_name`	Page name	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Contacts

report_type: contacts · 16 metrics · 109 dimensions

Metrics

Field name	Label	Type
`days_to_close`	Days to close	NUMBER
`hs_analytics_num_page_views`	Number of page views	NUMBER
`hs_email_bounce`	Email bounce	NUMBER
`hs_email_click`	Email click (contacts)	NUMBER
`hs_email_delivered`	Email delivered	NUMBER
`hs_email_open`	Email open	NUMBER
`hs_sales_email_last_clicked`	Sales email last clicked	NUMBER
`hs_sales_email_last_opened`	Sales email last opened	NUMBER
`hs_sales_email_last_replied`	Sales email last replied	NUMBER
`hs_time_to_first_engagement`	Time to first engagement	NUMBER
`hubspotscore`	HubSpot score	NUMBER
`num_associated_deals`	Num associated deals	NUMBER
`num_contacted_notes`	Num contacted notes	NUMBER
`num_unique_conversion_events`	Num unique conversion events	NUMBER
`recent_deal_amount`	Recent deal amount	NUMBER
`total_revenue`	Total revenue	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`annualrevenue`	Annual revenue	STRING
`city`	Contact city	STRING
`closedate`	Recent deal close date	STRING
`company`	Company name (contacts)	STRING
`company_hs_object_id`	Company ID	STRING
`country`	Country	STRING
`createdate`	Create date	STRING
`custom`	Custom	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`date_actual`	Dateformula	STRING
`email`	Email	STRING
`first_conversion_date`	First conversion date	STRING
`first_conversion_event_name`	First conversion event name	STRING
`firstname`	First name	STRING
`hs_analytics_first_url`	Analytics first URL	STRING
`hs_analytics_source`	Original source	STRING
`hs_analytics_source_data_1`	Original source drill-down 1	STRING
`hs_analytics_source_data_2`	Original source drill-down 2	STRING
`hs_calculated_phone_number`	Calculated phone number	STRING
`hs_calculated_phone_number_country_code`	Calculated phone number country code	STRING
`hs_email_first_send_date`	Email first send date	STRING
`hs_email_last_email_name`	Last email name	STRING
`hs_email_last_send_date`	Last send date	STRING
`hs_lead_status`	Lead status	STRING
`hs_lifecyclestage_customer_date`	Lifecycle stage customer date	STRING
`hs_lifecyclestage_lead_date`	Lifecycle stage lead date	STRING
`hs_lifecyclestage_marketingqualifiedlead_date`	Lifecycle stage MQL date	STRING
`hs_lifecyclestage_opportunity_date`	Lifecycle stage opportunity date	STRING
`hs_lifecyclestage_salesqualifiedlead_date`	Lifecycle stage SQL date	STRING
`hs_lifecyclestage_subscriber_date`	Lifecycle stage subscriber date	STRING
`hs_user_ids_of_all_owners`	User IDs of all owners	STRING
`hs_v2_date_entered_subscriber`	Date entered subscriber lifecycle stage	STRING
`hubspot_owner`	Owner	STRING
`hubspot_owner_assigneddate`	Owner assigned date	STRING
`hubspot_owner_id`	Owner ID	STRING
`lastmodifieddate`	Last modified date (contacts)	STRING
`lastname`	Last name	STRING
`lifecyclestage`	Lifecycle stage	STRING
`marital_status`	Marital status	STRING
`mobilephone`	Mobile phone number	STRING
`notes_last_updated`	Notes last updated	STRING
`notes_next_activity_date`	Notes next activity date	STRING
`recent_conversion_date`	Recent conversion date	STRING
`recent_conversion_event_name`	Recent conversion event name	STRING
`recent_deal_close_date`	Recent deal close date	STRING
`relationship_status`	Relationship status	STRING
`start_date`	Start date	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`year_week`	Year weekformula	STRING
`createdate_year`	Year (create date)formula	STRING
`createdate_quarter`	Quarter (create date)formula	STRING
`createdate_year_quarter`	Year quarter (create date)formula	STRING
`createdate_month`	Year month (create date)formula	STRING
`createdate_week`	Week (create date)formula	STRING
`createdate_year_week`	Year week (create date)formula	STRING
`createdate_month_only`	Month (create date)formula	STRING
`createdate_day_of_week`	Day of week (create date)formula	STRING
`createdate_day_of_month`	Day of month (create date)formula	STRING
`createdate_hour`	Hour (create date)formula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Contacts stats

report_type: contacts_stats · 1 metric · 27 dimensions

Metrics

Field name	Label	Type
`statistics_contacts`	Total contacts	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`statistics_lastNewContactAt`	Last new contact	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Companies

report_type: companies · 1 metric · 53 dimensions

Metrics

Field name	Label	Type
`total_revenue`	Total revenue	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`company_hs_object_id`	Company ID	STRING
`company_name`	Company name (companies)	STRING
`country`	Country	STRING
`createdate`	Create date	STRING
`custom`	Custom	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`domain`	Domain	STRING
`hs_analytics_source`	Original source	STRING
`hs_analytics_source_data_1`	Original source drill-down 1	STRING
`hs_analytics_source_data_2`	Original source drill-down 2	STRING
`hs_lastmodifieddate`	Last modified date	STRING
`hs_lead_status`	Lead status	STRING
`hubspot_owner_id`	Owner ID	STRING
`hubspot_team_id`	Team ID	STRING
`lifecyclestage`	Lifecycle stage	STRING
`state`	State	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Deals

report_type: deals · 5 metrics · 61 dimensions

Metrics

Field name	Label	Type
`amount_in_home_currency`	Amount in company currency	NUMBER
`hs_closed_amount`	Closed deal amount	NUMBER
`hs_closed_amount_in_home_currency`	Closed deal amount in home currency	NUMBER
`hs_forecast_probability`	Forecast probability	NUMBER
`hs_is_closed`	Is deal closed	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`amount`	Amount	STRING
`closed_lost_reason`	Closed lost reason	STRING
`closed_won_reason`	Closed won reason	STRING
`closedate`	Recent deal close date	STRING
`createdate`	Create date	STRING
`custom`	Custom	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`deal_currency_code`	Currency	STRING
`deal_hs_object_id`	Deal ID	STRING
`dealname`	Deal name	STRING
`dealstage`	Deal stage	STRING
`dealtype`	Deal type	STRING
`description`	Deal description	STRING
`hs_analytics_source`	Original source	STRING
`hs_analytics_source_data_1`	Original source drill-down 1	STRING
`hs_analytics_source_data_2`	Original source drill-down 2	STRING
`hs_forecast_amount`	Forecast amount	STRING
`hubspot_owner`	Owner	STRING
`hubspot_owner_id`	Owner ID	STRING
`pipeline`	Pipeline (deals, line items)	STRING
`year`	Yearformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`year_week`	Year weekformula	STRING
`createdate_year`	Year (create date)formula	STRING
`createdate_year_quarter`	Year quarter (create date)formula	STRING
`createdate_month`	Year month (create date)formula	STRING
`createdate_year_week`	Year week (create date)formula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Tickets

report_type: tickets · 7 metrics · 57 dimensions

Metrics

Field name	Label	Type
`time_to_close_in_days`	Time to close — in daysformula	NUMBER
`time_to_first_agent_reply_in_days`	Time to first agent reply — in daysformula	NUMBER
`hs_feedback_last_ces_rating`	Feedback last CES rating	NUMBER
`hs_num_times_contacted`	Number of times contacted	NUMBER
`num_contacted_notes`	Num contacted notes	NUMBER
`time_to_close`	Time to close	NUMBER
`time_to_first_agent_reply`	Time to first agent reply	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`closed_date`	Tickets — closed date	STRING
`content`	Ticket description	STRING
`createdate`	Create date	STRING
`custom`	Custom	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`hs_feedback_last_ces_follow_up`	Feedback last CES follow-up	STRING
`hs_lastcontacted`	Last contacted	STRING
`hs_lastmodifieddate`	Last modified date	STRING
`hs_pipeline`	Pipeline (tickets)	STRING
`hs_pipeline_stage`	Ticket stage	STRING
`hs_resolution`	Resolution	STRING
`hs_ticket_category`	Ticket category	STRING
`hs_ticket_priority`	Ticket priority	STRING
`hubspot_owner`	Owner	STRING
`hubspot_owner_assigneddate`	Owner assigned date	STRING
`hubspot_owner_id`	Owner ID	STRING
`hubspot_team_id`	Team ID	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Posts

report_type: posts · 1 metric · 31 dimensions

Metrics

Field name	Label	Type
`clicks`	Clicks	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`channel`	Channel	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`post_id`	Post ID	STRING
`status`	Status	STRING
`text`	Text	STRING
`url`	URL	STRING
`year`	Yearformula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Landing pages dimensions

report_type: landing_pages_dimensions · 0 metrics · 23 dimensions

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`dataFreshness`	Data freshness	STRING
`landing_page_absolute_url`	Landing page absolute URL	STRING
`landing_page_author`	Landing page author	STRING
`landing_page_author_name`	Landing page author name	STRING
`landing_page_description`	Landing page description	STRING
`landing_page_id`	Landing page ID	STRING
`landing_page_image`	Landing page image	STRING
`landing_page_live_domain`	Landing page live domain	STRING
`landing_page_name`	Landing page name	STRING
`landing_page_publish_date`	Landing page publish date	STRING
`landing_page_title`	Landing page title	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Line items

report_type: line_items · 8 metrics · 48 dimensions

Metrics

Field name	Label	Type
`discount`	Discount	NUMBER
`hs_discount_percentage`	Discount percentage	NUMBER
`hs_pre_discount_amount`	Pre-discount amount	NUMBER
`hs_tcv`	Total contract value	NUMBER
`hs_total_discount`	Calculated total discount	NUMBER
`price`	Price	NUMBER
`quantity`	Quantity	NUMBER
`tax`	Tax	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`amount`	Amount	STRING
`createdate`	Create date	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`deal_hs_object_id`	Deal ID	STRING
`description`	Deal description	STRING
`hs_lastmodifieddate`	Last modified date	STRING
`hs_product_id`	Product ID	STRING
`hs_recurring_billing_start_date`	Start date	STRING
`hs_sku`	SKU	STRING
`hs_url`	URL	STRING
`name`	Email name	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Email stats period (daily)

report_type: email_stats_period · 19 metrics · 26 dimensions

Metrics

Field name	Label	Type
`open_total_rate`	Open rate (daily)formula	NUMBER
`click_total_rate`	Click rate (daily)formula	NUMBER
`ctor`	CTOR (daily)formula	NUMBER
`reply_rate`	Reply rate (daily)formula	NUMBER
`click_device_type_computer`	Clicks from desktop (daily)	NUMBER
`click_device_type_mobile`	Clicks from mobile (daily)	NUMBER
`click_device_type_unknown`	Clicks from unknown device (daily)	NUMBER
`open_device_type_computer`	Opens from desktop (daily)	NUMBER
`open_device_type_mobile`	Opens from mobile (daily)	NUMBER
`open_device_type_unknown`	Opens from unknown device (daily)	NUMBER
`total_bounce`	Bounces (daily)	NUMBER
`total_click`	Clicks (daily)	NUMBER
`total_delivered`	Total delivered (daily)	NUMBER
`total_hardbounced`	Hard bounces (daily)	NUMBER
`total_open`	Opens (daily)	NUMBER
`total_reply`	Replies (daily)	NUMBER
`total_sent`	Sent (daily)	NUMBER
`total_spamreport`	Spam reports (daily)	NUMBER
`total_unsubscribed`	Unsubscribes (daily)	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`account_id`	Hub ID	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`year_week`	Year weekformula	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Full CRM, marketing and traffic data in one warehouse

No native MCP

No native MCP

Every queryable field in PMA

Sources

Forms (daily)

Lists

Email stats

Landing pages (daily)

Landing pages

Geo

UTM campaign

UTM source

UTM medium

UTM content

UTM term

Forms

Pages

Contacts

Contacts stats

Companies

Deals

Tickets

Posts

Landing pages dimensions

Line items

Email stats period (daily)