CData Python Connector for HubSpot

Build 23.0.8839

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839