CData BizTalk Adapter for HubSpot 2019 - Online Help
Questions / Feedback?

AnalyticsSessions

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

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 Integer Desktop sessions.
DirectTraffic Integer Direct sessions.
EmailMarketing Integer Email marketing sessions.
Mobile Integer Mobile sessions.
OrganicSearch Integer Organic search sessions.
OtherCampaigns Integer Other campaigns sessions.
Others Integer Other sessions.
PaidSearch Integer Paid search sessions.
Referrals Integer Referrals sessions.
SocialMedia Integer 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.

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 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) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7424.0