MarketingEvents
Marketing events in HubSpot.
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Id [KEY] | String | True | True |
The unique identifier of the marketing event. | |
| EventName | String | False |
The name of the marketing event. | ||
| EventDescription | String | False |
The description of the marketing event. | ||
| EventType | String | False |
Describes what type of event this is. For example: WEBINAR, CONFERENCE, WORKSHOP. | ||
| EventOrganizer | String | False |
The name of the organizer of the marketing event. | ||
| EventUrl | String | False |
A URL in the external event application where the marketing event can be managed. | ||
| EventStatus | String | True |
The status of the marketing event. | ||
| EventCancelled | Boolean | False |
Indicates if the marketing event has been cancelled. Defaults to false. | ||
| StartDateTime | Datetime | False |
The start date and time of the marketing event. | ||
| EndDateTime | Datetime | False |
The end date and time of the marketing event. | ||
| CreatedAt | Datetime | True |
The date and time of the marketing event creation. | ||
| UpdatedAt | Datetime | True |
The date and time of the last update to the marketing event. | ||
| Registrants | Int | True |
The number of registrants for the marketing event. | ||
| Attendees | Int | True |
The number of attendees for the marketing event. | ||
| NoShows | Int | True |
The number of no-shows for the marketing event. | ||
| Cancellations | Int | True |
The number of cancellations for the marketing event. | ||
| AppInfoId | String | True |
The ID of the app that created the marketing event. | ||
| AppInfoName | String | True |
The name of the app that created the marketing event. | ||
| CustomProperties | String | False |
A list of PropertyValues. | ||
| ExternalEventId | String | False |
The ID of the marketing event in the external event application. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 詳細については、WHERE 句のセクションを参照してください。
| Name | Type | Description |
| ExternalAccountId | String |
The account ID that is associated with this marketing event in the external event application. |