AnalyticsContents
Returns analytics data for all HubSpot-hosted content, including websites, landing pages, and blogs, offering insights into content engagement.
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 | Retrieves analytics data specifically for landing pages, useful for lead generation performance tracking. | |
| StandardPages | String | Retrieves data for standard website pages, helping measure general website engagement. | |
| BlogPosts | String | Provides analytics for individual blog posts, useful for tracking blog post popularity and engagement. | |
| ListingPages | String | Retrieves data for blog listing pages, offering insights into overall blog category performance. | |
| KnowledgeArticles | String | Provides analytics data for knowledge base articles, supporting content effectiveness analysis. | |
| AllPages | String | Returns data for all tracked URLs where HubSpot's tracking code is installed, broken down by each URL. | |
| Contacts | Long | Displays the total number of new contacts generated from page views during the reporting period. | |
| ContactsPerPageview | Double | Shows the ratio of contacts generated per raw page view, indicating lead conversion efficiency. | |
| CtaViews | Long | Total number of views on Calls-to-Action (CTAs) placed on pages, useful for CTA engagement analysis. | |
| Entrances | Long | Counts how many times visitors entered the website through a specific page, representing entry points. | |
| Exits | Long | Counts how many times visitors exited the website from a specific page. | |
| ExitsPerPageview | Double | Ratio of page exits compared to total page views, helpful for understanding drop-off points. | |
| Leads | Long | Total number of leads captured through forms or other conversion points on the page. | |
| PageBounceRate | Double | Bounce rate specific to the page, representing the percentage of single-page sessions. | |
| PageBounces | Long | Total number of times visitors bounced (left without interaction) from the page. | |
| PageTime | Long | Total time visitors spent on the page, measured in seconds. | |
| RawViews | Long | Total number of raw page views recorded, regardless of visitor uniqueness. | |
| Submissions | Long | Total number of form submissions or conversions completed on the page. | |
| SubmissionsPerPageview | Double | Ratio of submissions completed per page view, used to measure conversion effectiveness. | |
| TimePerPageview | Double | Average time spent per page view, indicating visitor engagement duration. | |
| BreakdownDate | Date | Start date of the breakdown data aggregation period. Applicable for these granularity types: daily, weekly, monthly, summarize/daily, summarize/weekly, summarize/monthly. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.
| Name | Type | Description | |
| StartDate | Date | Specifies the starting date of the query range to filter results. | |
| EndDate | Date | Specifies the ending date of the query range to limit results. | |
| Granularity | String | Defines the time interval for data grouping. Acceptable values include total, daily, weekly, monthly, summarize/daily, summarize/weekly, summarize/monthly. | |
| Filter | String | Filters results to include only records matching the specified breakdowns. Multiple filters can be applied. | |
| Exclude | String | Excludes records matching the specified breakdowns from the results. Multiple exclusions are supported. | |
| FilterId | String | Specifies the ID of a HubSpot Analytics view. Filters the returned data to match the selected view. |