Cmdlets for HubSpot

Build 24.0.9032

AnalyticsEventCompletions

Get analytics data for event completion objects.

Table Specific Information

Get analytics data for event completion objects.

SELECT

When selecting analytics for event completions, they can only be filtered by the StartDate, EndDate, Granularity, Filter, Exclude, FilterId, Sort or SortDirection. The filters must use an exact comparison. For example:

SELECT * FROM AnalyticsEventCompletions WHERE Granularity = 'total' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018'
SELECT * FROM AnalyticsEventCompletions WHERE Granularity = 'summarize/weekly' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018'

Columns

Name Type References Description
EventCompletions String Analytics data for event completions.
Completions Long The number of event completions.
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