AnalyticsSessions
Get analytics data broken down by sessions.
Table Specific Information
Get analytics data broken down by sessions.
SELECT
When selecting analytics for event completions, they can only be filtered by the StartDate, EndDate, Granularity, Filter, FirstDrilldown, SecondDrilldown, Exclude, FilterId, Sort or SortDirection. The filters must use an exact comparison. For example:
SELECT * FROM AnalyticsSessions WHERE Granularity = 'total' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018' SELECT * FROM AnalyticsSessions WHERE Granularity = 'monthly' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018' AND Filter = 'hubspot'
Columns
| Name | Type | References | Description |
| Sessions | String | Analytics data for sessions. | |
| Desktop | Long | Desktop sessions. | |
| DirectTraffic | Long | Direct sessions. | |
| EmailMarketing | Long | Email marketing sessions. | |
| Mobile | Long | Mobile sessions. | |
| OrganicSearch | Long | Organic search sessions. | |
| OtherCampaigns | Long | Other campaigns sessions. | |
| Others | Long | Other sessions. | |
| PaidSearch | Long | Paid search sessions. | |
| PaidSocial | Long | Paid social sessions. | |
| Referrals | Long | Referrals sessions. | |
| SocialMedia | Long | Social media sessions. | |
| FirstDrilldown | String | Used to drilldown into the data. This parameter is designed to reflect the functionality of the HubSpot sources reports. | |
| SecondDrilldown | String | Used to further drill down into the data. Similar to FirstDrilldown, this reflects the functionality of the sources report. | |
| 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. |