Goals
Retrieve the available Goals in HubSpot.
Columns
Name | Type | References | Filterable | Description |
Id [KEY] | Long | True | Unique identifier of the object. | |
Archived | Bool | False | Whether the object is archived or not. | |
CreatedAt | Datetime | False | When the object was created. | |
UpdatedAt | Datetime | False | When the object was last updated. | |
MigrationSoftDeleteDeprecated | String | True | Describes if the goal target can be treated as deleted. | |
Ad account asset IDs | String | True | A list of ';'-separated universally unique IDs of ad accounts, each formatted: {AD_NETWORK}-{ACCOUNT_ID} | |
Ad campaign asset ids | String | True | A list of ';'-separated universally unique IDs of ad campaigns, each formatted: {NETWORK}-{CAMPAIGN_ID} | |
All teams | String | True | The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom. | |
Business units | String | True | The business units this record is assigned to. | |
All owner ids | String | True | The value of all owner referencing properties for this object, both default and custom. | |
Team ids | String | True | Which team owns the goal (there should only ever be one team). | |
Assignee team ID | Decimal | True | The team ID of the assigned team of the goal (unpopulated if the goal is not team-assigned or team-by-user-assigned). | |
Assignee user ID | Decimal | True | The user ID of the assigned user of the goal (unpopulated if the goal is not user-assigned). | |
Campaign asset ids | String | True | List of marketing campaign asset ids. | |
Contact lifecycle stage | String | True | The lifecycle stage selected for the contact lifecycle goal. | |
Created by user ID | Decimal | True | The user that created this object. This value is automatically set by HubSpot and may not be modified. | |
Object create date/time | Datetime | True | The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified. | |
currency | String | True | DEPRECATED - DO NOT USE! Code for the currency conversion. | |
Currency Exchange Rate | Decimal | True | Exchange rate to be used for calculated properties reflecting currency-based values in home currencies. Value is automatically set for in-progress goals. Once a goal has ended, the value should be alterable by admins only. | |
Deal pipelines | String | True | A serialized list of DEAL pipeline IDs used to filter the KPI value calculation. | |
Edit updates notification frequency | String | True | The frequency of goal edit update notifications. | |
End date | Date | True | The last day covered by the Goal Target's date range. | |
End datetime | Datetime | True | The last day covered by the Goal Target's date range. | |
Fiscal year offset | Decimal | True | Represents the number of months the fiscal year is away from a standard calendar year (0 means the fiscal year starts in January). | |
Goal name | String | True | The name of the goal. | |
Goal target currency code | String | True | Currency code for the goal target. | |
Goal Target Group ID | Decimal | True | Object ID of the associated Goal Target Group. | |
Goal type | String | True | The goal type. | |
Group correlation UUID | String | True | Unique ID set on all Goal Targets and Goal Target Groups created by a single request. | |
Is forecastable | String | True | READ ME! (kind of) indicates whether the goal should appear in the forecasting app - this property may be true even if the goal should NOT appear in the forecasting app. As of April 2023, this property will be true if hs_milestone is either \\“monthly\\” or \\“quarterly\\“, and if the count of pipelines in hs_pipelines 0 or 1. No other checks are made! | |
IsLegacy | String | True | Describes if the object was created during the migration process and it comes from the old app. | |
KPI Display Unit | String | True | Display units for goals based on duration properties. | |
KpiFilterGroups | String | True | Filter groups for KPI calculations. | |
KPI is team rollup | Bool | True | Indicates whether this is a rollup goal: whether the KPI allows contributions from child teams (in addition to the assigned team). | |
KpiMetricType | String | True | Type of metric used to aggregate the property name. | |
KpiObjectType | String | True | The name of the CrmObject the KPI values are based on. | |
Kpi object type id | String | True | The ObjectTypeId of the object the KPI values are based on. | |
KpiPropertyName | String | True | Name of the property on the object type aggregated as the KPI value. | |
KpiSingleObjectCustomGoalTypeName | String | True | Single object custom goal components (metric type, object type, property name). | |
KpiTimePeriodProperty | String | True | Time period property. | |
KpiTrackingMethod | String | True | Tracking method for progress directionality. | |
Kpi unit type | String | True | Unit type of the kpi calculation. | |
KPI value | Decimal | True | The latest KPI value for this goal target. | |
KPI value calculated at | Decimal | True | The time that latest KPI value was calculated. | |
KPI value last calculated at | Datetime | True | The time that latest KPI value was calculated. | |
Object last modified date/time | Datetime | True | Most recent timestamp of any property update for this object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically. | |
LegacyActive | String | True | Migrated value describing if the goal is active or soft deleted. | |
LegacyCreatedAt | Decimal | True | Migrated value of created at. | |
LegacyCreatedBy | Decimal | True | Migrated value of created by. | |
LegacyQuarterlyTargetCompositeId | String | True | Concatenated value of the 3 sql_ids that form a quarterly GT separated by a '-'. Used to be able to update both monthly and quarterly legacy Goal Targets. | |
LegacySqlId | Decimal | True | Id of the migrated goal target in the old system. This has been deprecated for legacy_unique_sql_id. | |
LegacyUniqueSqlId | Decimal | True | Id of the migrated goal target in the old system. This property has a unique value to ensure no duplicate migrated goals. | |
LegacyUpdatedAt | Decimal | True | Migrated value of updated at. | |
LegacyUpdatedBy | Decimal | True | Migrated value of updated by. | |
Merged record IDs | String | True | The list of record IDs that have been merged into this record. This value is automatically set by HubSpot and may not be modified. | |
MigrationSoftDelete | String | True | Describes if the goal target can be treated as deleted. | |
Milestone | String | True | The period during which a Goal Target is active. | |
Record ID | Decimal | True | The unique ID for this record. This value is automatically set by HubSpot and may not be modified. | |
Record Creation Source | String | True | Source (PropertySource) that created this object record. | |
Record Creation Source ID | String | True | The sourceId -- further detail -- of the source that created this object record. | |
Record Creation Source User ID | Decimal | True | User ID of the user who initiated creation of this object record. | |
Outcome | String | True | Goal Target outcome. | |
Owner ids of all owners | String | True | The owner IDs of all owners of this object. | |
Participant type | String | True | The type of participant for the Goal Target. | |
Pipeline ids | String | True | List of deal pipelines that the quota applies to. Used to calculate kpi values. | |
Pipelines | String | True | A serialized list of pipeline IDs used to filter the KPI value calculation. | |
Progress updates notification frequency | String | True | The frequency of goal progress update notifications. | |
Read Only Object | Bool | True | Is the object read only. | |
Notify on goal achieved | String | True | Opt into notifications when goal is achieved. | |
Notify with goal edit updates | String | True | Opt into goal edit update notifications. | |
Notify on goal exceeded | String | True | Opt into notifications when goal is exceeded. | |
Notify on goal kickoff | String | True | Opt into notifications when a goal is kicked off. | |
Notify on goal missed | String | True | Opt into notifications when a goal is missed. | |
Notify with progress updates | String | True | Opt into goal progress updates notifications. | |
ShouldRecalculate | String | True | Property used to flag Goal targets that need to be recalculated. | |
Start datetime | Datetime | True | The first day that goal target's date range covers. | |
Static KPI Filter Groups | String | True | Goal Target Filter Group(s) for all filters except time-based filters. | |
Status | String | True | The status of the Goal Target. | |
Status display order | Decimal | True | The goal status display order. | |
Target amount | Decimal | True | The target amount for this goal target. | |
Target amount in company currency | Decimal | True | The amount of the goal target, using the exchange rate, in your company's currency. | |
Team ID | Decimal | True | The team ID associated with the Goal Target. | |
Ticket pipelines | String | True | A serialized list of TICKET pipeline IDs used to filter the KPI value calculation. | |
Unique creation key | String | True | Unique property used for idempotent creates. | |
Updated by user ID | Decimal | True | The user that last updated this object. This value is automatically set by HubSpot and may not be modified. | |
User ID | Decimal | True | The user ID associated with the Goal Target. | |
User IDs of all notification followers | String | True | The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications. | |
User IDs of all notification unfollowers | String | True | The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications. | |
User IDs of all owners | String | True | The user IDs of all owners of this object. | |
Performed in an import | Bool | True | Object is part of an import. | |
Owner Assigned Date | Datetime | True | The most recent date an owner was assigned to this object. This is set automatically by HubSpot and can be used for segmentation and reporting. | |
Owner | String | True | The owner of the object. | |
HubSpot Team | String | True | The primary team of the owner. | |
Start date | Date | True | The first day that goal target's date range covers. | |
Kpi progress percent | Decimal | True | Progress percent is represented by the kpi value as a percent of the target amount. |