ActiveCampaign fields list — Porter Metrics docs
Fields Reference · ActiveCampaign

ActiveCampaign Fields List

556 fields · 0 dimensions · 0 metrics · 33 groups

556 of 556
Field nameLabelCategoryDescription
accountAccounturlAccount Account Url AccountAccount Account Url
accountContactcountAccount Contact Count AccountAccount Contact Count
accountCreatedtimestampAccount Created Date AccountAccount Created Date
accountDealcountAccount Deal Count AccountAccount Deal Count
accountIdAccount ID AccountAccount ID
accountNameAccount Name AccountAccount Name
accountUpdatedtimestampAccount Updated Date AccountAccount Updated Date
campaignActiverss_intervalCampaign Activerss Interval CampaignIf this is an activerss-type campaign, how often it checks for new feed items. Same options as for recurring mailings.
campaignActiverss_itemsCampaign Activerss Items CampaignThe number of RSS items to display in the campaign.
campaignActiverss_urlCampaign Activerss Url CampaignThe RSS URL used to check for new feed items that get inserted into the campaign.
campaignAnalytics_campaign_nameCampaign Analytics Campaign Name CampaignThe Google Analytics campaign name, used for organizing within Google Analytics.
campaignCan_skip_approvalCampaign Can Skip Approval CampaignCampaign Can Skip Approval
campaignCdateCampaign Created Date CampaignDate the campaign was initially created.
campaignCreated_byCampaign Created By CampaignCampaign Created By
campaignEd_versionCampaign Edit Version CampaignCampaign Edit Version
campaignFacebookCampaign Facebook CampaignWhether or not this campaign auto-posted to Facebook.
campaignForwardsCampaign Forwards CampaignTotal amount of forwards for this campaign, including multiple forwards initiated by the same contact.
campaignHardbouncesCampaign Hard Bounces CampaignTotal number of hard bounces for this campaign.
campaignHas_predictive_contentCampaign Has Predictive Content CampaignCampaign Has Predictive Content
campaignIdCampaign ID CampaignCampaign ID
campaignLaststepCampaign Last Step CampaignThe last step of the campaign process saved.
campaignLinkclicksCampaign Link Clicks CampaignTotal amount of link clicks for this campaign, including multiple link clicks by the same contact.
campaignMdateCampaign Modified Date CampaignDate the campaign was last modified.
campaignNameCampaign Name CampaignInternal name of the campaign.
campaignOpensCampaign Opens CampaignTotal amount of opens for this campaign, including multiple opens by the same contact.
campaignPublicCampaign Public CampaignWhether or not this campaign is public.
campaignRecurringCampaign Recurring CampaignIf this is a recurring campaign, how often it repeats. Possible values: day1, day2, week1, week2, month1, month2, quarter1, quarter2, year1, year2.
campaignReminder_offsetCampaign Reminder Offset CampaignIf this is an auto-reminder type campaign, how many days/weeks/months/years from that date should it trigger.
campaignReminder_offset_signCampaign Reminder Offset Sign CampaignIf this is an auto-reminder type campaign.
campaignReminder_offset_typeCampaign Reminder Offset Type CampaignIf this is an auto-reminder type campaign.
campaignReminder_typeCampaign Reminder Type CampaignIf this is an auto-reminder type campaign, match just a month and the day, or match year as well.
campaignRepliesCampaign Replies CampaignTotal number of replies for this campaign, including multiple replies by the same contact.
campaignReplysysCampaign Reply Sys CampaignWhether or not reply tracking is enabled for this campaign.
campaignResponder_offsetCampaign Responder Offset CampaignIf this is an auto-responder type campaign, how many hours after subscription to send it.
campaignScheduleCampaign Schedule CampaignWhether or not this campaign is scheduled to send at a later date/time.
campaignScheduleddateCampaign Scheduled Date CampaignCampaign Scheduled Date
campaignScreenshotCampaign Screenshot CampaignCampaign Screenshot
campaignSdateCampaign Send Date CampaignDate the campaign started sending.
campaignSegmentnameCampaign Segment name CampaignCampaign Segment name
campaignSend_amtCampaign Sends CampaignTotal amount of contacts actually sent this campaign.
campaignSocialsharesCampaign Social Shares CampaignTotal number of social shares conducted for this campaign.
campaignSoftbouncesCampaign Soft Bounces CampaignTotal number of soft bounces for this campaign.
campaignSourceCampaign Source CampaignHow the campaign was created. Possible value: ‘web’, ‘api’, ‘copy’, ‘recurr’, ‘system’.
campaignSplit_offsetCampaign Split Offset CampaignIf this is a split-type campaign, the number of units to wait before determining the winner.
campaignSplit_offset_typeCampaign Split Offset Type CampaignIf this is a split-type campaign, the type of unit to wait before determining the winner. Possible values: ‘hour’, ‘day’, ‘week’, ‘month’
campaignSplit_typeCampaign Split Type CampaignIf this is a split-type campaign, the type of split mailing. Possible values: ‘even’, ‘read’, ‘click’. If ‘read’ or ‘click’ is used, ‘split_offset’ and ‘split_offset_type’ need to be present.
campaignSplit_winner_awaitingCampaign Split Winner Awaiting CampaignWhether or not a winner is still being determined.
campaignStatusCampaign Status CampaignStatus of this campaign. Possible values: 0 = Draft, 1 = Scheduled, 2 = Sending, 3 = Paused, 4 = Stopped, 5 = Completed, 6 = Disabled, 7 = Pending Approval
campaignSubscriberclicksCampaign Subscriber Clicks CampaignTotal amount of distinct contacts that clicked a link for this campaign.
campaignTracklinksCampaign Track Links CampaignType of link tracking enabled for the campaign. Possible values: ‘all’, ‘mime’, ‘html’, ‘text’, ‘none’
campaignTracklinksanalyticsCampaign Track Links Analytics CampaignWhether or not Google Analytics link tracking is enabled.
campaignTrackreadsCampaign Track Reads CampaignWhether or not read/open tracking is enabled for this campaign.
campaignTrackreadsanalyticsCampaign Track Reads Analytics CampaignWhether or not Google Analytics read tracking is enabled.
campaignTweetCampaign Twitter Mentions CampaignWhether or not this campaign auto-posted to Twitter.
campaignTypeCampaign Type CampaignType of campaign. Possible values: ‘single’, ‘recurring’, ‘responder’, ‘reminder’, ‘split’, ‘activerss’, ‘text’
campaignUniqueforwardsCampaign Unique Forwards CampaignTotal amount of distinct contacts that forwarded this campaign.
campaignUniquelinkclicksCampaign Unique Link Clicks CampaignTotal amount of distinct links clicked for this campaign.
campaignUniqueopensCampaign Unique Opens CampaignTotal amount of distinct contacts that opened this campaign.
campaignUniquerepliesCampaign Unique Replies CampaignTotal number of distinct contacts that replied to this campaign.
campaignUnsubreasonsCampaign Unsub Reasons CampaignTotal number of unsubscribe reasons provided for unsubscriptions for this campaign.
campaignUnsubscribesCampaign Unsubscribes CampaignTotal number of unsubscribes for this campaign.
campaignUpdated_byCampaign Updated By CampaignCampaign Updated By
campaignUpdatesCampaign Updates CampaignTotal number of contacts that updated their profile via this campaign.
campaignUse_quartz_schedulerCampaign Use Quartz Scheduler CampaignCampaign Use Quartz Scheduler
campaignVerified_opensCampaign Verified Opens CampaignCampaign Verified Opens
campaignVerified_unique_opensCampaign Verified Unique Opens CampaignCampaign Verified Unique Opens
gaCampaignContentGA Campaign Content CampaignGoogle Analytics Campaign Content (utm_content)
gaCampaignCustomsegmentGA Campaign Custom Segment CampaignGoogle Analytics Campaign Custom Segment
gaCampaignMediumGA Campaign Medium CampaignGoogle Analytics Campaign Medium (utm_medium)
gaCampaignNameGA Campaign Name CampaignGoogle Analytics Campaign Name (utm_campaign)
gaCampaignSourceGA Campaign Source CampaignGoogle Analytics Campaign Source (utm_source)
gaCampaignTermGA Campaign Term CampaignGoogle Analytics Campaign Term (utm_term)
day_of_monthDay of month TimeDay of month
contact_engagements_last_meeting_bookedContact date of last meeting booked in meetings tool Contact informationThe date of the meeting that is booked the farthest out from the current date
contact_engagements_last_meeting_booked_campaignContact campaign of last booking in meetings tool Contact informationThis UTM parameter shows which marketing campaign (e.g. a specific email) referred the contact to the meetings tool for their most recent booking
contact_engagements_last_meeting_booked_mediumContact medium of last booking in meetings tool Contact informationThis UTM parameter shows which channel (e.g. email) referred the contact to the meetings tool for their most recent booking
contact_engagements_last_meeting_booked_sourceContact source of last booking in meetings tool Contact informationThis UTM parameter shows which site (e.g. Twitter) referred the contact to the meetings tool for their most recent booking
contact_faxContact fax number Contact informationThe contact’s primary fax number
contact_first_deal_created_dateContact first deal created date Contact informationThe create date of the first deal the contact is associated to
contact_first_nameContact first name Contact informationThe contact’s first name
contact_hubspot_scoreContact HubSpot score Contact informationThe number that shows qualification of contacts to sales readiness based on the criteria set in HubSpot’s lead scoring tool
contact_hubspot_team_idContact HubSpot team Contact informationThe team assigned to the contact owner for the contact
contact_idContact ID Contact informationThe unique visitor ID of the contact
contact_industryContact industry Contact informationThe contact’s industry
contact_is_unworkedContact unworked Contact informationAn indication if the contact has been worked
contact_job_titleContact job title Contact informationThe contact’s job title
contact_languageContact preferred language Contact informationthe contact’s preferred language for communications. This might be set via import, form, or integration
contact_last_modified_dateContact last modified date Contact informationThe last date and time that a property related to the contact was modified
contact_last_nameContact last name Contact informationThe contact’s last name
contact_last_sales_activity_timestampContact last engagement date Contact informationThe last date and time of one-to-one email opens and clicks, lead revisits, meeting bookings, and form submissions on the contact record
contact_latest_sequence_enrolledContact last sequence enrolled Contact informationThe unique ID of the last sequence that the contact was enrolled in
contact_lead_statusContact lead status Contact informationThe contact and company property that indicates where the contact or company is within a buying cycle as a lead
contact_lifecycle_stageContact lifecycle stage Contact informationA property used to indicate at what point the contact is within the marketing/sales process
contact_lifecycle_stage_customer_dateContact became a customer date Contact informationThe date that the contact’s lifecycle stage changed to Customer
contact_lifecycle_stage_evangelist_dateContact became an evangelist date Contact informationThe date that the contact’s lifecycle stage changed to Evangelist
contact_lifecycle_stage_lead_dateContact became a lead date Contact informationThe date that the contact’s lifecycle stage changed to Lead
contact_lifecycle_stage_marketing_qualified_lead_dateContact became a marketing qualified lead date Contact informationThe date that the contact’s lifecycle stage changed to Marketing Qualified Lead
contact_lifecycle_stage_opportunity_dateContact became an opportunity date Contact informationThe date that the contact’s lifecycle stage changed to Opportunity
contact_lifecycle_stage_other_dateContact became an other lifecycle date Contact informationThe date that the contact’s lifecycle stage changed to Other
contact_lifecycle_stage_sales_qualified_lead_dateContact became a sales qualified lead date Contact informationThe date that the contact’s lifecycle stage changed to Sales Qualified Lead
contact_lifecycle_stage_subscriber_dateContact became a subscriber date Contact informationThe date that the contact’s lifecycle stage changed to Subscriber
contact_marketable_until_renewalContact marketing status Contact informationIndicates if the contact is currently a marketing or non-marketing contact
contact_messageContact message Contact informationA default property to be used for any message or comments the contact may want to leave on a form
contact_mobile_phoneContact mobile phone number Contact informationThe contact’s mobile phone number
contact_notes_last_contactedContact last contacted Contact informationThe last date and time a chat conversation, call, sales email, or meeting was logged for the contact
contact_notes_last_updatedContact last activity date Contact informationThe last date and time a note, call, tracked sales email, meeting, task, or chat was logged on the contact’s record
contact_notes_next_activity_dateContact next activity date Contact informationThe date of the next upcoming activity for the contact
contact_num_associated_dealsContact number of associated deals Contact informationThe total number of all associated deals
contact_num_contacted_notesContact number of times contacted Contact informationThe total number of times the contact received a sales email, received a call, or had a chat conversation
contact_num_employeesContact number of employees Contact informationThe number of company employees
contact_num_notesContact number of sales activities Contact informationThe total number of sales activities (notes, calls, emails, meetings, tasks, or chats) logged for the contact
contact_ownerContact owner Contact informationThe owner of the contact
contact_owner_assigned_dateContact owner assigned date Contact informationThe most recent date that the contact owner was assigned to the contact
contact_owner_idContact owner ID Contact informationThe owner ID of the contact
contact_personaContact persona Contact informationThe contact’s persona
contact_phoneContact phone number Contact informationThe contact’s primary phone number
contact_predictive_contact_scoreContact Likelihood to close (Marketing Hub Enterprise and Sales Hub Enterprise only) Contact informationThe probability that the contact will become a customer within the next 90 days
contact_predictive_scoring_tierContact priority (Marketing Hub Enterprise, Sales Hub Enterprise, and Service Hub Enterprise only) Contact informationA ranking system of contacts evenly assigned into four tiers
contact_recent_deal_amountContact recent deal amount Contact informationThe value of the last closed-won deal associated with that contact
contact_recent_deal_close_dateContact recent deal close date Contact informationThe date of the last associated deal that was closed as won
contact_sales_email_last_clickedContact recent sales email clicked date (Sales Hub Professional and Enterprise only) Contact informationThe date of the last time that the contact clicked on a sales email
contact_sales_email_last_openedContact recent sales email open date Contact informationThe date of the last time that the contact opened a sales email
contact_sales_email_last_repliedContact recent sales email replied date Contact informationThe date of the last time that the contact replied to a sales email sent from your connected G Suite or Outlook 365 email account
contact_salutationContact salutation Contact informationThe title used to address the contact
contact_sequences_enrolled_countContact number of sequences enrolled Contact informationThe number of times a contact was enrolled into a sequence
contact_stateContact state/region Contact informationThe contact’s state of residence
contact_time_between_contact_creation_and_deal_closeContact time between creation and deal close Contact informationThe amount of time between when a contact was created and when the contact’s lifecycle stage became Customer
contact_time_between_contact_creation_and_deal_creationContact time between creation and deal creation Contact informationThe amount of time between when a contact was created and when the contact was associated with a deal
contact_total_revenueContact total revenue Contact informationTotal dollar amount of all associated deals that have been closed as won
contact_websiteContact website URL Contact informationThe contact’s company website
contact_zipContact postal code Contact informationThe contact’s zip code
total_contactsTotal contacts Contact informationThe total contacts
total_leadTotal leads Contact informationTotal leads
total_mqlTotal marketing qualified leads Contact informationTotal marketing qualified leads
total_sqlTotal sales qualified leads Contact informationTotal sales qualified leads
mkt_email_bodyMarketing email body Marketing emailThe email body
mkt_email_bounceMarketing email bounce Marketing emailThe number of times contacts were sent your email, but they didn’t receive it because either their address is invalid, your email hit their spam filter, or your email was marked as spam by other people.
mkt_email_bounce_totalMarketing email bounce total Marketing emailThe number of times contacts were sent your email, but they didn’t receive it because either their address is invalid, your email hit their spam filter, or your email was marked as spam by other people, historically up to the current date.
mkt_email_bounceratioMarketing email bounce ratio Marketing emailThe number of contacts that bounced from the email over the total number of selected contacts.
mkt_email_campaign_idMarketing email campaign Id Marketing emailThe email campaign Id
mkt_email_campaign_nameMarketing email campaign name Marketing emailThe email campaign name
mkt_email_clickMarketing email click Marketing emailThe number of unique recipients who clicked on any link in your email, excluding the Unsubscribe and Subscription Preferences links.
mkt_email_click_totalMarketing email click total Marketing emailThe number of unique recipients who clicked on any link in your email, excluding the Unsubscribe and Subscription Preferences links, historically up to the current date.
mkt_email_clickratioMarketing email click ratio Marketing emailClick rate is the percentage of people who clicked a link in your email out of the people who were delivered your email.
mkt_email_clickthroughratioMarketing email click through ratio Marketing emailThis is the percentage of people who clicked a link in your email out of the people who opened your email.
mkt_email_contactslostMarketing email contacts lost Marketing emailThe sum of contacts that have unsubscribed, marked the email as spam, or have hardbounced.
mkt_email_contactslost_totalMarketing email contacts lost total Marketing emailThe sum of contacts that have unsubscribed, marked the email as spam, or have hardbounced, historically up to the current date.
mkt_email_contactslostratioMarketing email contacts lost ratio Marketing emailThe number of contacts that can no longer recive emails from the portal over the total number of selected contacts.
mkt_email_created_atMarketing email created time Marketing emailThe time the email was created
mkt_email_created_dateMarketing email created date Marketing emailThe date the email was created
mkt_email_deliveredMarketing email delivered Marketing emailThe number of emails succesfully delivered to an inbox
mkt_email_delivered_totalMarketing email delivered total Marketing emailTotal number of marketing emails succesfully delivered to an inbox historically up to the current date
mkt_email_deliveredratioMarketing email delivered ratio Marketing emailthe number of succesfull deliveries over the number of selected contacts.
mkt_email_droppedMarketing email dropped Marketing emailThe number of contacts that were not sent your email. This may be because they previously hard bounced, unsubscribed, marked you as spam, or because they have not engaged with any of your recent emails.
mkt_email_dropped_totalMarketing email dropped total Marketing emailThe number of contacts that were not sent your email. This may be because they previously hard bounced, unsubscribed, marked you as spam, or because they have not engaged with any of your recent emails, historically up to the current date.
mkt_email_from_nameMarketing email from name Marketing emailThe email from name
mkt_email_hardbouncedMarketing email hard bounced Marketing emailThese contacts were sent your email, but they didn’t receive it because either their address is invalid, your email hit their spam filter, or your email was marked as spam by other people.
mkt_email_hardbounced_totalMarketing email hard bounced total Marketing emailThese contacts were sent your email, but they didn’t receive it because either their address is invalid, your email hit their spam filter, or your email was marked as spam by other people, historically up to the current date.
mkt_email_hardbounceratioMarketing email hard bounce ratio Marketing emailThe number of contacts that hard bounced from the email over the total number of selected contacts.
mkt_email_idMarketing email ID Marketing emailThe id of the email
mkt_email_languageMarketing email language Marketing emailThe language of the email
mkt_email_nameMarketing email name Marketing emailThe name of the email
mkt_email_notsentMarketing email not sent Marketing emailThese contacts were not sent your email. This may be because they previously hard bounced, unsubscribed, marked you as spam, or because they have not engaged with any of your recent emails.
mkt_email_notsent_totalMarketing email not sent total Marketing emailThese contacts were not sent your email. This may be because they previously hard bounced, unsubscribed, marked you as spam, or because they have not engaged with any of your recent emails, historically up to the current date.
mkt_email_notsentratioMarketing email not sent ratio Marketing emailThe number of contacts that were selected but not sent to over the total number of selected contacts.
mkt_email_openMarketing email open Marketing emailThe total number of unique opens
mkt_email_open_totalMarketing email open total Marketing emailTotal number of marketing emails unique opens historically up to the current date
mkt_email_openratioMarketing email open ratio Marketing emailThe percentage of people who opened your email out of the people who were delivered your email.
mkt_email_pendingMarketing email pending Marketing emailThe number of emails still trying to reach a contact’s inbox.
mkt_email_pending_totalMarketing email pending total Marketing emailThe number of emails still trying to reach a contact’s inbox, historically up to the current date.
mkt_email_pendingratioMarketing email pending ratio Marketing emailThe number of contacts that soft bounced from the email over the total number of selected contacts.
mkt_email_reply_toMarketing email reply to Marketing emailThe email reply to
mkt_email_selectedMarketing email selected Marketing emailThe number of contacts selected to receive this email.
mkt_email_selected_totalMarketing email selected total Marketing emailThe number of contacts selected to receive this email, historically up to the current date.
mkt_email_sentMarketing email sent Marketing emailthe total number of sent emails
mkt_email_sent_totalMarketing email sent total Marketing emailTotal number of marketing emails sent historically up to the current date
mkt_email_softbouncedMarketing email soft bounced Marketing emailSoft bounces occur when a contact’s inbox has a temporary problem. You can still send to these people in the future. Contacts who hard bounce will be ineligible for later sends.
mkt_email_softbounced_totalMarketing email soft bounced total Marketing emailSoft bounces occur when a contact’s inbox has a temporary problem. You can still send to these people in the future. Contacts who hard bounce will be ineligible for later sends, historically up to the current date.
mkt_email_softbounceratioMarketing email soft bounce ratio Marketing emailThe number of contacts that soft bounced from the email over the total number of selected contacts.
mkt_email_spamreportMarketing email spam report Marketing emailThe number of contacts received your email and marked it as spam. They won’t be sent to in the future.
mkt_email_spamreport_totalMarketing email spam report total Marketing emailThe number of contacts received your email and marked it as spam. They won’t be sent to in the future, historically up to the current date.
mkt_email_spamreportratioMarketing email spam report ratio Marketing emailThe number of contacts that mark the email as spam over the total number of selected contacts.
mkt_email_stateMarketing email state Marketing emailThe email state
mkt_email_subcategoryMarketing email subcategory Marketing emailThe subcategory of the email
mkt_email_subjectMarketing email subject Marketing emailThe subject of the email
mkt_email_suppressedMarketing email suppressed Marketing emailThe number of contacts that did not receive your email due to graymail suppression.
mkt_email_suppressed_totalMarketing email suppressed total Marketing emailThe number of contacts that did not receive your email due to graymail suppression, historically up to the current date, historically up to the current date.
mkt_email_unsubscribedMarketing email unsubscribed Marketing emailThe number of contacts who received your email and unsubscribed. They won’t be sent to in the future.
mkt_email_unsubscribed_totalMarketing email unsubscribed total Marketing emailThe number of contacts who received your email and unsubscribed. They won’t be sent to in the future, historically up to the current date.
mkt_email_unsubscribedratioMarketing email unsubscribed ratio Marketing emailthe number of contacts that have unsubscribed over the total number of selected contacts
contactAnonymizedContact Anonymized ContactWhether or not this contact is anonymized.
contactAreaContact Area ContactContact Area
contactAutomationsAdddateContact Automation Added Date ContactContact Automation Added Date
contactAutomationsBatchidContact Automation Batch ID ContactContact Automation Batch ID
contactAutomationsCompletedContact Automation Completed ContactContact Automation Completed
contactAutomationsCompletedelementsContact Automation Completed Elements ContactContact Automation Completed Elements
contactAutomationsCompletevalueContact Automation Complete Value ContactContact Automation Complete Value
contactAutomationsIdContact Automation ID ContactContact Automation ID
contactAutomationsStatusContact Automation Status ContactContact Automation Status
contactAutomationsTimespanContact Automation Timespan ContactContact Automation Timespan
contactAutomationsTotalelementsContact Automation Total Elements ContactContact Automation Total Elements
contactBounced_hardContact Bounced Hard ContactNumber of times this contact has hard-bounced.
contactBounced_softContact Bounced Soft ContactNumber of times this contact has soft-bounced.
contactCdateContact Created Date ContactDate subscribed.
contactCityContact City ContactContact City
contactCountryCodeContact Country Code ContactContact Country Code
contactCreated_byContact Created By ContactContact Created By
contactCreated_utc_timestampContact Created At UTC Timestamp ContactContact Created At UTC Timestamp
contactDeletedContact Deleted ContactWhether or not this contact was deleted.
contactDeleted_atContact Deleted At ContactContact Deleted At
contactEmailContact Email ContactEmail address of contact.
contactEmail_domainContact Email Domain ContactContact Email Domain
contactEmail_localContact Email Local ContactContact Email Local
contactFirstnameContact First Name ContactContact First Name
contactGeoCountryContact Country ContactContact Geographical Country Code
contactIdContact ID ContactContact ID
contactLastnameContact Last Name ContactContact Last Name
contactLatContact Latitude ContactContact Latitude
contactListsCreated_byContact List Created By ContactContact List Created By
contactListsCreated_timestampContact List Created Timestamp ContactDate when contact was added to the list.
contactListsIdContact List Id ContactContact List Id
contactListsMessageContact List Message ContactContact List Message
contactListsStatusContact List Status ContactContact List Status
contactListsUnsubreasonContact List Unsubreason ContactContact List Unsubreason
contactListsUpdated_byContact List Updated By ContactContact List Updated By
contactListsUpdated_timestampContact List Updated Timestamp ContactDate when contact was updated to the list.
contactLonContact Longitude ContactContact Longitude
contactOrgidContact Organization ID ContactContact Organization ID
contactOrgnameContact Organization Name ContactContact Organization Name
contactPhoneContact Phone ContactContact Phone
contactSentcntContact Sends ContactContact Sends
contactStateContact State ContactContact State
contactTagsCdateContact Tag Created Date ContactDate when tag was added to this contact.
contactTagsCreated_byContact Tag Created By ContactContact Tag Created_by
contactTagsCreated_timestampContact Tag Created Timestamp ContactContact Tag Created Timestamp
contactTagsIdContact Tag Id ContactContact Tag Id
contactTagsUpdated_byContact Tag Updated By ContactContact Tag Updated_by
contactTagsUpdated_timestampContact Tag Updated Timestamp ContactContact Tag Updated Timestamp
contactTzContact Timezone ContactContact Timezone
contactTzOffsetContact Timezone Offset ContactContact Timezone Offset
contactUdateContact Updated Date ContactDate updated.
contactUpdated_byContact Updated By ContactContact Updated By
contactUpdated_utc_timestampContact Updated At UTC Timestamp ContactContact Updated At UTC Timestamp
contactZipContact Zip ContactContact Zip Code
deal_acvDeal annual contract value (ACV) Deal informationThe value of the deal over a 12-month period in the deal’s currency
deal_amountDeal amount Deal informationThe total value of the deal in the deal’s currency
deal_amount_closed_lostDeal amount lost Deal informationThe Amount value for deals marked as Closed Lost in the deal’s currency
deal_amount_closed_wonDeal amount won Deal informationThe Amount value for deals marked as Closed Won in the deal’s currency
deal_amount_in_home_currencyDeal amount in company currency Deal informationThe total value of the deal in your selected company currency
deal_arrDeal annual recurring revenue (ARR) Deal informationThe total amount of revenue earned annually for this deal
deal_close_dateDeal close date Deal informationThe day the deal is expected to close, or was closed
deal_closed_countDeal closed count Deal informationThe total count of deals
deal_closed_lostDeal closed lost Deal informationThe total count of lost deals
deal_closed_lost_reasonDeal closed lost reason Deal informationReason why the deal was lost
deal_closed_wonDeal closed won Deal informationThe total count of won deals
deal_closed_won_reasonDeal closed won reason Deal informationReason why the deal was won
deal_create_dateDeal create date Deal informationThe date the deal was created
deal_currency_codeDeal currency Deal informationtrue if the deal is in the closed won state, false otherwise
deal_descriptionDeal description Deal informationA brief description of the deal
deal_forecast_amountDeal forecast amount Deal informationThe deal amount multiplied by the forecast probability
deal_forecast_probabilityDeal forecast probability Deal informationThe custom percent probability that the deal will close
deal_hubspot_team_idDeal HubSpot team Deal informationThe team assigned to the deal owner for the deal
deal_idDeal ID Deal informationID of the deal
deal_is_closedIs Deal Closed? Deal informationtrue if the deal was won or lost.
deal_is_closed_wonDeal is closed won Deal informationtrue if the deal is in the closed won state, false otherwise
deal_last_modified_dateDeal last modified date Deal informationThe most recent date that any property on a deal was updated
deal_manual_forecast_categoryDeal forecast category Deal informationThe likelihood of the deal closing, categorized as Omit, Pipeline, Best case, Most likely, Commit, or Closed
deal_mrrDeal monthly recurring revenue (MRR) Deal informationThe recurring revenue each month for this deal
deal_nameDeal name Deal informationThe name you have given this deal
deal_next_stepDeal next step Deal informationThe next steps that you or another user will take to improve the deal’s likelihood to close
deal_notes_last_contactedDeal last contacted Deal informationThe last time a chat conversation, call, sales email, or meeting was logged for this deal
deal_notes_last_updatedDeal last activity date Deal informationThe last time a note, chat conversation, call, email, meeting, or task was logged for a deal
deal_notes_next_activity_dateDeal next activity date Deal informationThe date of the next upcoming activity for a deal
deal_num_associated_contactsDeal number of associated contacts Deal informationThe number of contacts associated with this deal
deal_num_contacted_notesDeal number of times contacted Deal informationThe total number of calls, emails, and meetings that are logged for associated contact records and are associated with the deal
deal_num_notesDeal number of sales activities Deal informationThe total number of sales activities (notes, calls, emails, meetings, or tasks) logged for a deal
deal_ownerDeal owner Deal informationThe user from your team that the deal is assigned to
deal_owner_assigned_dateDeal owner assigned date Deal informationThe date the most recent deal owner was assigned to a deal
deal_owner_idDeal owner ID Deal informationThe user ID from your team that the deal is assigned to
deal_pipelineDeal pipeline Deal informationThe pipeline a deal is in, which determines the deal stages the deal will move through
deal_priorityDeal priority Deal informationThe level of attention needed on the deal
deal_projected_amountDeal weighted amount Deal informationThe Amount multiplied by the Deal probability
deal_stageDeal stage Deal informationDeal stages allow you to categorize and track the progress of the deals that you are working on
deal_stage_probabilityDeal probability Deal informationThe probability that the deal will close
deal_tcvDeal total contract value (TCV) Deal informationThe total value of the deal, based on the line items associated to the deal, including any recurring revenue and one-time charges
deal_typeDeal type Deal informationDeal types allow you to categorize your deals
deal_ui_linkDeal link in HubSpot UI Deal informationLink to deal in HubSpot UI
total_dealsTotal deals Deal informationThe total deals
listIdList ID ListList ID
listsAnalytics_sourceList Analytics Source ListList analytics source
listsAnalytics_uaList Analytics UA ListLists Analytics UA
listsCdateList Created Date ListDate/time the list was created.
listsCreated_byList Created By ListLists Created By
listsCreated_timestampList Created Timestamp ListLists Created Timestamp
listsFulladdressList Full Address ListLists Full Address
listsGet_unsubscribe_reasonList Get Unsubscribe Reason ListWhether or not to ask for a reason when contacts UNsubscribe.
listsNameList Name ListInternal name of list.
listsOptinoptoutList Opt In Opt Out ListLists Opt In Opt Out
listsP_embed_imageList Embed Image ListWhether or not to embed images for campaigns send to this list.
listsP_use_analytics_linkList Use Analytics Link ListWhether or not to use analytics link
listsP_use_analytics_readList Use Analytics Read ListWhether or not to use analytics read
listsP_use_captchaList Use Captcha ListWhether or not to use captcha image verification when subscribing to this list.
listsP_use_facebookList Use Facebook ListWhether or not to use Facebook campaign auto-sharing.
listsP_use_trackingList Use Tracking ListWhether or not to use tracking
listsP_use_twitterList Use Twitter ListWhether or not to use Twitter campaign auto-sharing.
listsPrivateList Private ListWhether or not this list is private not visible on public side.
listsRequire_nameList Require Name ListWhether or not to require a name when subscribing to this list.
listsSend_last_broadcastList Send Last Broadcast ListWhether or not to send last broadcast message to new contacts of this list.
listsSender_addr1List Sender Address 1 ListSender’s Contact Information.
listsSender_addr2List Sender Address 2 ListSender’s Contact Information.
listsSender_cityList Sender City ListSender’s Contact Information.
listsSender_countryList Sender Country ListSender’s Contact Information.
listsSender_nameList Sender Name ListSender’s Contact Information.
listsSender_phoneList Sender Phone ListSender’s Contact Information.
listsSender_reminderList Sender Reminder ListSender’s Reminder to Contacts.
listsSender_stateList Sender State ListSender’s Contact Information.
listsSender_urlList Sender Url ListSender’s Contact Information.
listsSender_zipList Sender Zip ListSender’s Contact Information.
listsTo_nameList To Name ListDefault contact name used when contact has not entered a name.
listsUpdated_byList Updated By ListLists Updated By
listsUpdated_timestampList Updated Timestamp ListLists Updated Timestamp
line_item_acvLine item annual contract value (ACV) Line itemThe annual contract value (ACV) of the line item
line_item_amountLine item net price Line itemThe amount of the line item
line_item_arrLine item annual recurring revenue (ARR) Line itemThe annual recurring revenue (ARR) of the line item
line_item_cost_of_goods_soldLine item unit cost Line itemThe amount that sold goods cost the HubSpot customer
line_item_create_dateLine item created date Line itemThe time when line item was created
line_item_currency_codeLine item currency Line itemCurrency code for the line item
line_item_descriptionLine item description Line itemFull description of the line item
line_item_discountLine item unit discount Line itemThe discount amount applied
line_item_idLine item ID Line itemID of the line item
line_item_imagesLine item image URL Line itemImages of products used in the line item
line_item_marginLine item margin Line itemThe margin value of the line item
line_item_margin_acvLine item annual contract value margin Line itemThe margin annual contract value of the line item
line_item_margin_arrLine item annual recurring revenue margin Line itemThe margin annual recurring revenue of the line item
line_item_margin_mrrLine item monthly recurring revenue margin Line itemThe margin annual recurring revenue of the line item
line_item_margin_tcvLine item total contract value margin Line itemThe margin total contract value of the line item
line_item_mrrLine item monthly recurring revenue (MRR) Line itemThe monthly recurring revenue (MRR) of the line item
line_item_nameLine item name Line itemLine item name
line_item_priceLine item unit price Line itemCost of product in the line item
line_item_product_idLine item product ID Line itemID of the product this was copied from
line_item_quantityLine item quantity Line itemHow many units of a product are in the line item
line_item_recurring_billing_end_dateLine item end date Line itemRecurring billing end date for the line item
line_item_recurring_billing_frequencyLine item recurring billing frequency Line itemHow frequently the line item is billed
line_item_recurring_billing_periodLine item term Line itemProduct recurring billing duration
line_item_recurring_billing_start_dateLine item start date Line itemRecurring billing start date for the line item
line_item_skuLine item SKU Line itemUnique product identifier
line_item_taxLine item tax Line itemThe tax amount applied
line_item_tcvLine item total contract value (TCV) Line itemThe total contract value (TCV) of the line item
line_item_term_in_monthsLine item term in months Line itemThe number of months in the term of the line item
line_item_urlLine item URL Line itemProduct URL used in the line item
total_line_itemsTotal line items Line itemThe total line items
formCdateForm Cdate FormForm Cdate
formContactsForm Contacts FormForm Contacts
formDealsForm Deals FormForm Deals
formEntriesForm Entries FormForm Entries
formIdForm Id FormForm Id
formNameForm Name FormForm Name
formScreenshotForm Screenshot FormForm Screenshot
formUdateForm Udate FormForm Udate
formUrlForm Url FormForm Url
form_captcha_enabledForm is captcha enabled FormWill be set to true for forms with captcha enabled
form_created_atForm created date FormDate when the form was created
form_css_classForm CSS class FormThe default css classes added to the form when embedded
form_guidForm GUID FormThe internal ID of the form
form_ignore_current_valuesForm ignore current values FormIf true, the form pre-populates fields with known values for know contacts
form_inline_messageForm inline message FormA thank you message that is displayed on the page after the form is submitted
form_is_cloneableForm is clonable FormWhether or not the form can be cloned
form_is_deletableForm is deletable FormIf false, the form is a system form (such as a blog comment or subscription form) and cannot be deleted
form_is_editableForm is editable FormWhether or not the form can be edited
form_nameForm name FormThe name of the form
form_notify_recipientsForm notify recipients FormA comma-separated list of email addresses that should receive submission notifications
form_redirect_urlForm redirect URL FormThe URL that the visitor is redirected to after filling out the form
form_submission_dateForm submission date FormDate of the form submission
form_submissionsForm submissions FormNumber of form submissions
form_submit_textForm submit text FormThe text used for the submit button
form_updated_atForm last modified date FormDate when the form was last modified
averageDealValueWonAverage Deal Value Won DealAverage Deal Value Won
dealActivitycountDeal Activity Count DealDeal Activity Count
dealCdateDeal Created Date DealDate the deal was initially created.
dealCurrencyDeal Currency DealDeal Currency
dealDescriptionDeal Description DealDeal Description
dealGroupDeal Group DealDeal Group
dealHashDeal Hash DealDeal Hash
dealIdDeal ID DealDeal ID
dealIsdisabledDeal Is Disabled DealDeal Is Disabled
dealMdateDeal Last Modify Date DealDeal Last Modify Date
dealNextdateDeal Next Date DealDeal Next Date
dealNextdealidDeal Next Deal ID DealDeal Next Deal ID
dealNexttaskidDeal Next Task ID DealDeal Next Task ID
dealOrganizationDeal Organization DealDeal Organization
dealPercentDeal Percent DealDeal Percent
dealStageDeal Stage DealStage ID associated with the deal
dealStatusDeal Status DealDeal Status
dealTitleDeal Title DealTitle of the deal
dealValueDeal Value DealDeal Value
dealWinprobabilityDeal Win Probability DealDeal Win Probability
dealWinprobabilitymdateDeal Win Probability Date DealDeal Win Probability Date
product_cost_of_goods_soldProduct unit cost ProductThe amount that sold goods cost the HubSpot customer
product_create_dateProduct create date ProductDate when the product was created
product_descriptionProduct description ProductDescription of the product
product_discountProduct unit discount ProductDiscount of the product
product_discount_percentageProduct discount percentage ProductDiscount percentage of the product
product_idProduct ID ProductID of the product
product_last_modified_dateProduct last modified date ProductDate when the product was last modified
product_nameProduct name ProductName of the product
product_priceProduct unit price ProductPrice of the product
product_quantityProduct quantity ProductQuantity of the product
product_recurring_billing_frequencyProduct recurring billing frequency ProductRecurring billing frequency of the product
product_recurring_billing_periodProduct term ProductRecurring billing period of the product
product_skuProduct SKU ProductSKU of the product
product_taxProduct tax ProductTax of the product
total_productsTotal products ProductThe total products
contact_facebook_click_idContact Facebook click ID Contact conversion informationA value that indicates a contact’s first visit to your site came from a Facebook ad
contact_first_conversion_dateContact first conversion date Contact conversion informationThe date the contact first submitted a form
contact_first_conversion_event_nameContact first conversion Contact conversion informationThe first landing page and form the contact submitted on
contact_google_click_idContact Google ad click ID Contact conversion informationA value that indicates a contact’s first visit to your site came from a Google ad
contact_ip_cityContact IP city Contact conversion informationThe city reported by the contact’s IP address
contact_ip_countryContact IP country Contact conversion informationThe country reported by the contact’s IP address
contact_ip_country_codeContact IP country code Contact conversion informationThe country code reported by the contact’s IP address
contact_ip_stateContact IP state/region Contact conversion informationThe state or region reported by the contact’s IP address
contact_ip_state_codeContact IP state/region code Contact conversion informationThe state code or region code reported by the contact’s IP address
contact_ip_timezoneContact IP time zone Contact conversion informationThe timezone reported by the contact’s IP address
contact_num_unique_conversion_eventsContact number of unique forms submitted Contact conversion informationThe number of different HubSpot forms, pop-up forms, and collected forms the contact has submitted
contact_recent_conversion_dateContact recent conversion date Contact conversion informationThe date the contact last submitted a form
contact_recent_conversion_event_nameContact recent conversion Contact conversion informationThe last form the contact submitted
meeting_engagement_bodyMeeting engagement body Meeting EngagementsThe meeting description.
meeting_engagement_end_timeMeeting engagement end time Meeting EngagementsThe date and time when the meeting ends.
meeting_engagement_external_urlMeeting engagement esternal URL Meeting EngagementsThe external URL for the calendar event.
meeting_engagement_idMeeting engagement ID Meeting EngagementsThe ID of the meeting.
meeting_engagement_locationMeeting engagement location Meeting EngagementsWhere the meeting takes place. The value could be a physical address, a conference room, a videoconference link, or a phone number.
meeting_engagement_meeting_notesMeeting engagement notes Meeting EngagementsThe internal notes you take for your team during a meeting that are not included in the attendee meeting description.
meeting_engagement_outcomeMeeting engagement outcome Meeting EngagementsThe outcome of the meeting. The outcome values are scheduled, completed, rescheduled, no show, and canceled.
meeting_engagement_owner_idMeeting engagement owner id Meeting EngagementsThe ID of the owner associated with the meeting
meeting_engagement_start_timeMeeting engagement start time Meeting EngagementsThe date and time when the meeting starts.
meeting_engagement_timestampMeeting engagement timestamp Meeting EngagementsThe meeting’s due date.
meeting_engagement_titleMeeting engagement title Meeting EngagementsThe meeting’s title
meeting_engagement_typeMeeting engagement type Meeting EngagementsThe type of meeting. T
contact_list_created_atContact list created time Contact listThe time the list was created
contact_list_deleteableContact list is deleteable Contact listIf this is false, this is a system list and cannot be deleted
contact_list_dynamicContact list type Contact listOne of DYNAMIC or STATIC
contact_list_errorContact list error Contact listAny errors that happened the last time the list was processed
contact_list_idContact list ID Contact listThe unique ID of the list
contact_list_last_processing_state_change_atContact list last processing state change time Contact listThe last time that the processing state changed
contact_list_last_size_change_atContact list last size change time Contact listLast size change time
contact_list_nameContact list name Contact listThe name of the list
contact_list_processingContact list processing status Contact listOne of DONE, REFRESHING, INITIALIZING, or PROCESSING
contact_list_updated_atContact list updated time Contact listThe time that the list was last modified
dateDate DateDate
day_of_weekDay of week (Mon – Sun) DateDay of week (Mon – Sun)
hourHour of day DateHour of day
monthMonth DateMonth
quarterQuarter DateQuarter
weekWeek DateWeek
yearYear DateYear
year_monthMonth and year DateMonth and year
year_quarterQuarter and year DateQuarter and year
year_weekWeek and year DateWeek and year
tagCdateTag Created Date TagDate the tag was initially created.
tagCreated_byTag Created By TagTag Created By
tagCreated_timestampTag Created Timestamp TagTag Created Timestamp
tagDescriptionTag Description TagTag Description
tagIdTag ID TagTag ID
tagNameTag Name TagTag Name
tagSubscriber_countTag Subscriber Count TagTag Subscriber Count
tagTypeTag Type TagTag Type
tagUpdated_byTag Updated By TagTag Updated By
tagUpdated_timestampTag Updated Timestamp TagTag Updated Timestamp
automationCdateAutomation Cdate AutomationDate the automation was initially created.
automationEnteredAutomation Entered AutomationAutomation Entered
automationExitedAutomation Exited AutomationAutomation Exited
automationHiddenAutomation Hidden AutomationAutomation Hidden
automationIdAutomation Id AutomationAutomation Id
automationMdateAutomation Modified date AutomationAutomation modified date.
automationNameAutomation Name AutomationAutomation Name
automationScreenshotAutomation Screenshot AutomationAutomation Screenshot
automationStatusAutomation Status AutomationAutomation Status
contact_field_of_studyContact field of study Contact ads propertiesThe field of study as provided through a lead ad form
contact_genderContact gender Contact ads propertiesThe gender as provided through a lead ad form
contact_graduation_dateContact graduation date Contact ads propertiesThe graduation date of education as provided through a lead ad form
contact_marital_statusContact marital status Contact ads propertiesThe marital status as provided through a lead ad form
contact_relationship_statusContact relationship status Contact ads propertiesThe relationship status as provided through a lead ad form
contact_schoolContact school Contact ads propertiesThe school as provided through a lead ad form
contact_seniorityContact seniority Contact ads propertiesThe seniority in the company as provided through a lead ad form
contact_start_dateContact start date Contact ads propertiesThe start date of education as provided through a lead ad form
contact_work_emailContact work email Contact ads propertiesThe work email as provided through a lead ad form
userEmailUser Email UserUser Email
userFirstnameUser First Name UserUser First Name
userIdUser Id UserUser Id
userLangUser Language UserUser Language
userLastnameUser Last Name UserUser Last Name
userLocalzoneidUser Local Zone ID UserUser Local Zone ID
userPhoneUser Phone UserUser Phone
userSignatureUser Signature UserUser Signature
userUsernameUser Username UserUser Username
traffic_analytics_bounce_rateAnalytics traffic bounce rate (%) AnalyticsThe percentage of sessions that started on a page and did not move beyond that page
traffic_analytics_bouncesAnalytics traffic bounces AnalyticsThe number of sessions that started on a page and did not move beyond that page
traffic_analytics_new_session_rateAnalytics new traffic sessions (%) AnalyticsThe percentage of total sessions from new visitors
traffic_analytics_page_viewsAnalytics traffic page views AnalyticsThe total number of page views
traffic_analytics_page_views_per_sessionAnalytics avg. traffic page views per session AnalyticsAverage unique page views per session
traffic_analytics_session_avg_timeAnalytics avg. traffic session length (seconds) AnalyticsThe average time between the start and end of a session in seconds
traffic_analytics_session_contact_rateAnalytics traffic session to contact rate AnalyticsThe number of new contacts divided by the number of sessions
traffic_analytics_sessionsAnalytics traffic sessions AnalyticsThe number of times a user visited your website during this period
contact_email_last_click_dateContact last marketing email click date Contact email informationThe date of the most recent link click for any marketing email
contact_email_last_email_nameContact last marketing email name Contact email informationThe name of the last marketing email sent
contact_email_last_open_dateContact last marketing email open date Contact email informationThe date of the most recent email open for any marketing email
contact_email_last_send_dateContact last marketing email send date Contact email informationThe date of the most recent email delivery for any marketing email
contact_email_openContact marketing emails opened Contact email informationThe number of marketing emails opened
contact_email_opt_outContact unsubscribed from all email Contact email informationIndicates that the current email address has opted out of all email from the account
contact_email_quarantinedContact email address quarantined Contact email informationIndicates that the current email address has been quarantined for anti-abuse reasons
contact_email_sends_since_last_engagementContact sends since last engagement Contact email informationThe number of marketing emails that have been sent since the last engagement, specifically email open or link click
task_engagement_bodyTask engagement body Tasks EngagementsThe task notes
task_engagement_idTask engagement ID Tasks EngagementsThe ID of the task.
task_engagement_owner_idTask engagement owner id Tasks EngagementsThe owner ID of the user assigned to the task.
task_engagement_priorityTask engagement priority Tasks EngagementsThe status of the task, either COMPLETED or NOT_STARTED.
task_engagement_statusTask engagement status Tasks EngagementsThe status of the task, either COMPLETED or NOT_STARTED.
task_engagement_timestampTask engagement timestamp Tasks EngagementsThe task’s due date.
task_engagement_titleTask engagement title Tasks EngagementsThe title of the task.
task_engagement_typeTask engagement type Tasks EngagementsThe type of task. Values include EMAIL, CALL, or TODO.
email_engagement_bodyEmail engagement body Email EngagementsThe body of the email.
email_engagement_directionEmail engagement direction Email EngagementsThe direction the email was sent in.
email_engagement_idEmail engagement ID Email EngagementsThe ID of the email.
email_engagement_owner_idEmail engagement owner id Email EngagementsThe ID of the owner associated with the email.
email_engagement_statusEmail engagement status Email EngagementsThe send status of the email. The value can be BOUNCED, FAILED, SCHEDULED, SENDING, or SENT.
email_engagement_subjectEmail engagement subject Email EngagementsThe subject line of the logged email.
email_engagement_timestampEmail engagement timestamp Email EngagementsThe email’s due date.
contact_owner_emailContact owner email Contact ownerEmail of contact owner
contact_owner_first_nameContact owner first name Contact ownerFirst name of contact owner
contact_owner_last_nameContact owner last name Contact ownerLast name of contact owner
contact_owner_teams_idContact owner teams id Contact ownerTeams ID of contact owner
contact_owner_teams_membershipContact owner teams membership Contact ownerTeams name of contact owner
contact_owner_teams_nameContact owner teams name Contact ownerTeams name of contact owner
totalCurrentAccountsTotal Current Accounts Current Total ValuesTotal Current Accounts
totalCurrentCampaignsTotal Current Campaigns Current Total ValuesTotal Current Campaigns
totalCurrentContactsTotal Current Contacts Current Total ValuesTotal Current Contacts
totalCurrentDealsTotal Current Deals Current Total ValuesTotal Current Deals
totalCurrentListsTotal Current Lists Current Total ValuesTotal Current Lists
totalCurrentTagsTotal Current Tags Current Total ValuesTotal Current Tags
deal_owner_emailDeal owner email Deal ownerEmail of deal owner
deal_owner_first_nameDeal owner first name Deal ownerFirst name of deal owner
deal_owner_last_nameDeal owner last name Deal ownerLast name of deal owner
deal_owner_teams_idDeal owner teams id Deal ownerTeams ID of deal owner
deal_owner_teams_membershipDeal owner teams membership Deal ownerTeams name of deal owner
deal_owner_teams_nameDeal owner teams name Deal ownerTeams name of deal owner
note_engagement_bodyNote engagement body Notes EngagementsThe note’s text content
note_engagement_idNote engagement ID Notes EngagementsThe ID of the note.
note_engagement_owner_idNote engagement owner ID Notes EngagementsThe ID of the owner associated with the note. This field determines the user listed as the note creator on the record timeline in HubSpot.
note_engagement_timestampNote engagement timestamp Notes EngagementsThe note’s time of creation
deal_analytics_sourceDeal original source Deal analytics historyThe original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property
deal_analytics_source_data_1Deal original source data 1 Deal analytics historyAdditional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property
deal_analytics_source_data_2Deal original source data 2 Deal analytics historyAdditional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property
connectedAccountIdConnected Account ID Account InfoConnected Account ID
connectedAccountNameConnected Account Name Account InfoConnected Account Name
deal_closed_amountDeal closed amount Deals calculated informationReturns the amount if the deal is closed. Else, returns 0.
deal_days_to_closeDeal days to close Deals calculated informationThe time between Create date and Close date
total_companiesTotal companies Company informationThe total companies
owner_idOwner ID OwnerThe ID of the owner