HubSpot Fields

Suggest Edits

Dimensions (41)

Account

NinjaCat System ID: hubspot:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

Author Email

API Name: author_email

NinjaCat System ID: hubspot:DIM_authorEmail

Data Type: text

Author Full Name

API Name: author_full_name

NinjaCat System ID: hubspot:DIM_authorFullName

Data Type: text

Author Username

API Name: author_username

NinjaCat System ID: hubspot:DIM_authorUsername

Data Type: text

Browser

API Name: browser

NinjaCat System ID: hubspot:DIM_browser

Data Type: text

campaign

API Name: campaignName

NinjaCat System ID: hubspot:DIM_campaign

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

Campaign Group

NinjaCat System ID: hubspot:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

Campaign UTM

API Name: campaign_utm

NinjaCat System ID: hubspot:DIM_campaign_utm

Data Type: text

Canmpaign ID

API Name: campaignId

NinjaCat System ID: hubspot:DIM_campaignId

Data Type: text

Company

API Name: company

NinjaCat System ID: hubspot:DIM_company

Data Type: text

Contact

API Name: contact

NinjaCat System ID: hubspot:DIM_contact

Data Type: text

Currency

NinjaCat System ID: hubspot:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: hubspot:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date

API Name: created

NinjaCat System ID: hubspot:DIM_date

Data Type: date

Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: hubspot:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: hubspot:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

Event Type

API Name: type

NinjaCat System ID: hubspot:DIM_eventType

Data Type: text

External Id

NinjaCat System ID: hubspot:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

Featured Image

API Name: featured_image

NinjaCat System ID: hubspot:DIM_featuredImage

Data Type: text

HTML Title

API Name: html_title

NinjaCat System ID: hubspot:DIM_htmlTitle

Data Type: text

Landing Page

API Name: landing_page

NinjaCat System ID: hubspot:DIM_landing_page

Data Type: text

Month Of Year

NinjaCat System ID: hubspot:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: hubspot:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Page Label

API Name: label

NinjaCat System ID: hubspot:DIM_page_label

Data Type: text

Page Name

API Name: name

NinjaCat System ID: hubspot:DIM_page_name

Data Type: text

Page screenshot

API Name: screenshot_preview_url

NinjaCat System ID: hubspot:DIM_screenshot_preview_url

Data Type: text

Display As: image

Page Title

API Name: page_title

NinjaCat System ID: hubspot:DIM_page_title

Data Type: text

Post Body

API Name: body

NinjaCat System ID: hubspot:DIM_body

Data Type: text

Post Display

NinjaCat System ID: hubspot:DIM_post

Data Type: text

Display As: hubspot_blog_post

Post Meta Description

API Name: meta_description

NinjaCat System ID: hubspot:DIM_metaDescription

Data Type: text

Post Summary

API Name: summary

NinjaCat System ID: hubspot:DIM_summary

Data Type: text

Post Title

API Name: title

NinjaCat System ID: hubspot:DIM_title

Data Type: text

Publish Date

API Name: publish_date

NinjaCat System ID: hubspot:DIM_publishDate

Data Type: datetime

Display As: date_time

Row

NinjaCat System ID: hubspot:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

Slug

API Name: slug

NinjaCat System ID: hubspot:DIM_slug

Data Type: text

Source

API Name: sources

NinjaCat System ID: hubspot:DIM_source

Data Type: text

State

API Name: status

NinjaCat System ID: hubspot:DIM_status

Data Type: text

Display As: title_case

Aggregates To: DIM_STATE

System Account ID

NinjaCat System ID: hubspot:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

Url

API Name: url

NinjaCat System ID: hubspot:DIM_url

Data Type: text

Display As: url

Week Of Year

NinjaCat System ID: hubspot:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: hubspot:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

Metrics (49)

Archived

API Name: archived

NinjaCat System ID: hubspot:MET_archived

Data Type: integer

Bounce Rate

NinjaCat System ID: hubspot:MET_bounceRate

Data Type: decimal

Display As: percent

Formula: (hubspot:MET_pageBounces / hubspot:MET_entrances)

Bounces

API Name: pageBounces

NinjaCat System ID: hubspot:MET_pageBounces

Data Type: integer

Aggregates To: MET_BOUNCES

Click %

NinjaCat System ID: hubspot:MET_PercentClicked

Data Type: decimal

Display As: percent

Formula: (hubspot:MET_uniqueClicks / hubspot:MET_delivered)

Clicks

API Name: click

NinjaCat System ID: hubspot:MET_clicks

Data Type: integer

Aggregates To: MET_CLICKS

Close Rate

NinjaCat System ID: hubspot:MET_closeRate

Data Type: decimal

Display As: percent

Formula: (hubspot:MET_customers / hubspot:MET_leads)

Comments

API Name: comment_count

NinjaCat System ID: hubspot:MET_comments

Data Type: integer

Aggregates To: MET_COMMENTS

Contacts

API Name: contacts

NinjaCat System ID: hubspot:MET_contacts

Data Type: integer

Contact To Customer Rate

NinjaCat System ID: hubspot:MET_contactToCustomerRate

Data Type: decimal

Display As: percent

Formula: (hubspot:MET_contacts / hubspot:MET_customers)

Conv. Rate

NinjaCat System ID: hubspot:MET_conversionRate

Data Type: decimal

Display As: percent

Aggregates To: MET_CONVERSION_RATE

Formula: (hubspot:MET_customers / hubspot:MET_sessions )

Count (Unique Dimensions)

NinjaCat System ID: hubspot:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

CTA Views

API Name: ctaViews

NinjaCat System ID: hubspot:MET_ctaViews

Data Type: integer

Customers

API Name: customers

NinjaCat System ID: hubspot:MET_customers

Data Type: integer

Deleted

API Name: deleted

NinjaCat System ID: hubspot:MET_deleted

Data Type: integer

Delivered

API Name: delivered

NinjaCat System ID: hubspot:MET_delivered

Data Type: integer

Aggregates To: MET_DELIVERED

Delivery %

NinjaCat System ID: hubspot:MET_PercentDelivered

Data Type: decimal

Display As: percent

Formula: (hubspot:MET_delivered / hubspot:MET_sent)

Drafts

API Name: draft

NinjaCat System ID: hubspot:MET_draft

Data Type: integer

Entrances

API Name: entrances

NinjaCat System ID: hubspot:MET_entrances

Data Type: integer

Exits

API Name: exits

NinjaCat System ID: hubspot:MET_exits

Data Type: integer

Aggregates To: MET_EXITS

Exits / Page View

NinjaCat System ID: hubspot:MET_exitsPerPageView

Data Type: decimal

Display As: float

Formula: (hubspot:MET_exits / hubspot:MET_views)

Leads

API Name: leads

NinjaCat System ID: hubspot:MET_leads

Data Type: integer

Aggregates To: MET_LEADS

Marketing Qualified Leads

API Name: marketingQualifiedLeads

NinjaCat System ID: hubspot:MET_marketingQualifiedLeads

Data Type: integer

New Visitors

API Name: newVisitors

NinjaCat System ID: hubspot:MET_newVisitors

Data Type: integer

New Visitor / Session Rate

NinjaCat System ID: hubspot:MET_newVisitorSessionRate

Data Type: decimal

Display As: percent

Formula: (hubspot:MET_newVisitors / hubspot:MET_sessions )

New Visitors Raw Views

API Name: newVisitorRawViews

NinjaCat System ID: hubspot:MET_newVisitorRawViews

Data Type: integer

Non Contact Submissions

API Name: nonContactSubmissions

NinjaCat System ID: hubspot:MET_nonContactSubmissions

Data Type: integer

Open

API Name: open

NinjaCat System ID: hubspot:MET_open

Data Type: integer

Aggregates To: MET_OPENS

Open %

NinjaCat System ID: hubspot:MET_PercentOpened

Data Type: decimal

Display As: percent

Formula: (hubspot:MET_uniqueOpens / hubspot:MET_delivered)

Opportunities

API Name: opportunities

NinjaCat System ID: hubspot:MET_opportunities

Data Type: integer

Page Time

API Name: pageTime

NinjaCat System ID: hubspot:MET_pageTime

Data Type: integer

Pageviews / Session

NinjaCat System ID: hubspot:MET_pageviewsPerSession

Data Type: decimal

Display As: float

Formula: (hubspot:MET_views / hubspot:MET_sessions)

Published

API Name: published

NinjaCat System ID: hubspot:MET_published

Data Type: integer

Sales Qualified Leads

API Name: salesQualifiedLeads

NinjaCat System ID: hubspot:MET_salesQualifiedLeads

Data Type: integer

Sent

API Name: sent

NinjaCat System ID: hubspot:MET_sent

Data Type: integer

Aggregates To: MET_SENT

Sessions

API Name: sessions

NinjaCat System ID: hubspot:MET_sessions

Data Type: integer

Aggregates To: MET_SESSIONS

Session To Contact Rate

NinjaCat System ID: hubspot:MET_sessionToContactRate

Data Type: decimal

Display As: percent

Formula: (hubspot:MET_contacts / hubspot:MET_sessions)

Standard Views

API Name: standardViews

NinjaCat System ID: hubspot:MET_standardViews

Data Type: integer

Submissions

API Name: submissions

NinjaCat System ID: hubspot:MET_submissions

Data Type: integer

Subscribers

API Name: subscribers

NinjaCat System ID: hubspot:MET_subscribers

Data Type: integer

Time / Page View

NinjaCat System ID: hubspot:MET_timePerPageView

Data Type: decimal

Display As: float

Formula: (hubspot:MET_pageTime / hubspot:MET_views)

Unique Clicks

API Name: uniqueclick

NinjaCat System ID: hubspot:MET_uniqueClicks

Data Type: integer

Aggregates To: MET_UNIQUE_CLICKS

Unique Opens

API Name: uniqueopen

NinjaCat System ID: hubspot:MET_uniqueOpens

Data Type: integer

Aggregates To: MET_UNIQUE_OPENS

Unsubscribed

API Name: unsubscribed

NinjaCat System ID: hubspot:MET_unsubscribed

Data Type: integer

Aggregates To: MET_UNSUBSCRIBED

Views

API Name: views

NinjaCat System ID: hubspot:MET_views

Data Type: integer

Aggregates To: MET_VIEWS

Visitors

API Name: visitors

NinjaCat System ID: hubspot:MET_visitors

Data Type: integer

Aggregates To: MET_VISITORS

Visits

API Name: visits

NinjaCat System ID: hubspot:MET_visits

Data Type: integer

Aggregates To: MET_VISITS

Visits

Deprecated: 2024-11-07T01:28:37.866Z

API Name: visits

NinjaCat System ID: hubspot:MET_bounces

Data Type: integer

Visits

API Name: visits

NinjaCat System ID: hubspot:MET_pageviewsMinusExits

Data Type: integer

Visits

API Name: visits

NinjaCat System ID: hubspot:MET_time

Data Type: text

Display As: time

Updated 4 months ago