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. |