Cmdlets for HubSpot

Build 24.0.9032

AnalyticsContents

Get analytics data for your HubSpot hosted content. This would include your website and landing pages, as well as any blog pages hosted on HubSpot.

Table Specific Information

Get analytics data for your HubSpot hosted content. This would include your website and landing pages, as well as any blog pages hosted on HubSpot.

SELECT

When selecting analytics by content type, they can only be filtered by the StartDate, EndDate, Granularity, ContentType, Filter, Exclude, FilterId, Sort or SortDirection. Defaults to the StandardPages dimension. The filters must use an exact comparison. For example:

SELECT LandingPages FROM AnalyticsContents WHERE Granularity = 'total' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018'
SELECT ListingPages FROM AnalyticsContents WHERE Granularity = 'total' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018'
SELECT BlogPosts FROM AnalyticsContents WHERE Granularity = 'total' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018' AND Filter = 'hubspot'

Columns

Name Type References Description
LandingPages String Pull data for landing pages.
StandardPages String Pull data for website pages.
BlogPosts String Pull data for individual posts.
ListingPages String Pull data for blog listing pages.
KnowledgeArticles String Pull data for knowledge base articles.
AllPages String Get data for all URLs with data collected by HubSpot tracking code. The results are broken down by URL.
Contacts Long The total number of new contacts generated.
ContactsPerPageview Double The ratio of contacts to raw views.
CtaViews Long The number of CallsToAction views.
Entrances Long The number of entrances.
Exits Long The number of exits.
ExitsPerPageview Double The ratio of exits over page views.
Leads Long The number of leads.
PageBounceRate Double The rate of page bounces.
PageBounces Long The number of page bounces.
PageTime Long The time spent on page.
RawViews Long The number of raw views.
Submissions Long The number of submissions.
SubmissionsPerPageview Double The ratio of submissions over page views.
TimePerPageview Double The ratio of time over page views.
BreakdownDate Date The start date of the time period for which the breakdown data are grouped. This column is applicable only for Granularity types: daily, weekly, monthly, summarize/daily, summarize/weekly and summarize/monthly.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 詳細については、WHERE 句のセクションを参照してください。

Name Type Description
StartDate Date The beginning value of the query range.
EndDate Date The ending value of the query range.
Granularity String The time period used to group the data. Must be one of: total, daily, weekly, monthly, summarize/daily, summarize/weekly, summarize/monthly.
Filter String Filter the returned data to include only the specified breakdown. This parameter can be included multiple times to filter for multiple breakdowns.
Exclude String Exclude data for the specified breakdown. This parameter can be included multiple times to exclude multiple breakdowns.
FilterId String The ID of an Analytics view. If included, the returned data will only include data that matches the view.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9032