Goals
Retrieves all goal records configured in HubSpot, supporting goal tracking and performance management.
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 | False | Describes if the goal target can be treated as deleted. | |
| Ad account asset IDs | String | False | A list of ';'-separated universally unique IDs of ad accounts, each formatted: {AD_NETWORK}-{ACCOUNT_ID} | |
| Ad campaign asset ids | String | False | A list of ';'-separated universally unique IDs of ad campaigns, each formatted: {NETWORK}-{CAMPAIGN_ID} | |
| All teams | String | False | The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom. | |
| Business units | String | False | The business units this record is assigned to. | |
| All owner ids | String | False | The value of all owner referencing properties for this object, both default and custom. | |
| Team ids | String | False | Which team owns the goal (there should only ever be one team). | |
| Assignee team ID | Decimal | False | 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 | False | The user ID of the assigned user of the goal (unpopulated if the goal is not user-assigned). | |
| Campaign asset ids | String | False | List of marketing campaign asset ids. | |
| Contact lifecycle stage | String | False | The lifecycle stage selected for the contact lifecycle goal. | |
| Created by user ID | Decimal | False | The user that created this object. This value is automatically set by HubSpot and may not be modified. | |
| Object create date/time | Datetime | False | The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified. | |
| currency | String | False | DEPRECATED - DO NOT USE! Code for the currency conversion. | |
| Currency Exchange Rate | Decimal | False | 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 | False | A serialized list of DEAL pipeline IDs used to filter the KPI value calculation. | |
| Edit updates notification frequency | String | False | The frequency of goal edit update notifications. | |
| End date | Date | False | The last day covered by the Goal Target's date range. | |
| End datetime | Datetime | False | The last day covered by the Goal Target's date range. | |
| Fiscal year offset | Decimal | False | 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 | False | The name of the goal. | |
| Goal target currency code | String | False | Currency code for the goal target. | |
| Goal Target Group ID | Decimal | False | Object ID of the associated Goal Target Group. | |
| Goal type | String | False | The goal type. | |
| Group correlation UUID | String | False | Unique ID set on all Goal Targets and Goal Target Groups created by a single request. | |
| Is forecastable | String | False | 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 \\ | |
| IsLegacy | String | False | Describes if the object was created during the migration process and it comes from the old app. | |
| KPI Display Unit | String | False | Display units for goals based on duration properties. | |
| KpiFilterGroups | String | False | Filter groups for KPI calculations. | |
| KPI is team rollup | Bool | False | Indicates whether this is a rollup goal: whether the KPI allows contributions from child teams (in addition to the assigned team). | |
| KpiMetricType | String | False | Type of metric used to aggregate the property name. | |
| KpiObjectType | String | False | The name of the CrmObject the KPI values are based on. | |
| Kpi object type id | String | False | The ObjectTypeId of the object the KPI values are based on. | |
| KpiPropertyName | String | False | Name of the property on the object type aggregated as the KPI value. | |
| KpiSingleObjectCustomGoalTypeName | String | False | Single object custom goal components (metric type, object type, property name). | |
| KpiTimePeriodProperty | String | False | Time period property. | |
| KpiTrackingMethod | String | False | Tracking method for progress directionality. | |
| Kpi unit type | String | False | Unit type of the kpi calculation. | |
| KPI value | Decimal | False | The latest KPI value for this goal target. | |
| KPI value calculated at | Decimal | False | The time that latest KPI value was calculated. | |
| KPI value last calculated at | Datetime | False | The time that latest KPI value was calculated. | |
| Object last modified date/time | Datetime | False | 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 | False | Migrated value describing if the goal is active or soft deleted. | |
| LegacyCreatedAt | Decimal | False | Migrated value of created at. | |
| LegacyCreatedBy | Decimal | False | Migrated value of created by. | |
| LegacyQuarterlyTargetCompositeId | String | False | 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 | False | Id of the migrated goal target in the old system. This has been deprecated for legacy_unique_sql_id. | |
| LegacyUniqueSqlId | Decimal | False | Id of the migrated goal target in the old system. This property has a unique value to ensure no duplicate migrated goals. | |
| LegacyUpdatedAt | Decimal | False | Migrated value of updated at. | |
| LegacyUpdatedBy | Decimal | False | Migrated value of updated by. | |
| Merged record IDs | String | False | 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 | False | Describes if the goal target can be treated as deleted. | |
| Milestone | String | False | The period during which a Goal Target is active. | |
| Record ID | Decimal | False | The unique ID for this record. This value is automatically set by HubSpot and may not be modified. | |
| Record Creation Source | String | False | Source (PropertySource) that created this object record. | |
| Record Creation Source ID | String | False | The sourceId -- further detail -- of the source that created this object record. | |
| Record Creation Source User ID | Decimal | False | User ID of the user who initiated creation of this object record. | |
| Outcome | String | False | Goal Target outcome. | |
| Owner ids of all owners | String | False | The owner IDs of all owners of this object. | |
| Participant type | String | False | The type of participant for the Goal Target. | |
| Pipeline ids | String | False | List of deal pipelines that the quota applies to. Used to calculate kpi values. | |
| Pipelines | String | False | A serialized list of pipeline IDs used to filter the KPI value calculation. | |
| Progress updates notification frequency | String | False | The frequency of goal progress update notifications. | |
| Read Only Object | Bool | False | Is the object read only. | |
| Notify on goal achieved | String | False | Opt into notifications when goal is achieved. | |
| Notify with goal edit updates | String | False | Opt into goal edit update notifications. | |
| Notify on goal exceeded | String | False | Opt into notifications when goal is exceeded. | |
| Notify on goal kickoff | String | False | Opt into notifications when a goal is kicked off. | |
| Notify on goal missed | String | False | Opt into notifications when a goal is missed. | |
| Notify with progress updates | String | False | Opt into goal progress updates notifications. | |
| ShouldRecalculate | String | False | Property used to flag Goal targets that need to be recalculated. | |
| Start datetime | Datetime | False | The first day that goal target's date range covers. | |
| Static KPI Filter Groups | String | False | Goal Target Filter Groups for all filters except time-based filters. | |
| Status | String | False | The status of the Goal Target. | |
| Status display order | Decimal | False | The goal status display order. | |
| Target amount | Decimal | False | The target amount for this goal target. | |
| Target amount in company currency | Decimal | False | The amount of the goal target, using the exchange rate, in your company's currency. | |
| Team ID | Decimal | False | The team ID associated with the Goal Target. | |
| Ticket pipelines | String | False | A serialized list of TICKET pipeline IDs used to filter the KPI value calculation. | |
| Unique creation key | String | False | Unique property used for idempotent creates. | |
| Updated by user ID | Decimal | False | The user that last updated this object. This value is automatically set by HubSpot and may not be modified. | |
| User ID | Decimal | False | The user ID associated with the Goal Target. | |
| User IDs of all notification followers | String | False | 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 | False | 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 | False | The user IDs of all owners of this object. | |
| Performed in an import | Bool | False | Object is part of an import. | |
| Owner Assigned Date | Datetime | False | 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 | False | The owner of the object. | |
| HubSpot Team | String | False | The primary team of the owner. | |
| Start date | Date | False | The first day that goal target's date range covers. | |
| Kpi progress percent | Decimal | False | Progress percent is represented by the kpi value as a percent of the target amount. |