Fields Reference · ActiveCampaign
ActiveCampaign Fields List
556 fields · 0 dimensions · 0 metrics · 33 groups
| Field name | Label | Category | Description |
|---|---|---|---|
accountAccounturl | Account Account Url | Account | Account Account Url |
accountContactcount | Account Contact Count | Account | Account Contact Count |
accountCreatedtimestamp | Account Created Date | Account | Account Created Date |
accountDealcount | Account Deal Count | Account | Account Deal Count |
accountId | Account ID | Account | Account ID |
accountName | Account Name | Account | Account Name |
accountUpdatedtimestamp | Account Updated Date | Account | Account Updated Date |
campaignActiverss_interval | Campaign Activerss Interval | Campaign | If this is an activerss-type campaign, how often it checks for new feed items. Same options as for recurring mailings. |
campaignActiverss_items | Campaign Activerss Items | Campaign | The number of RSS items to display in the campaign. |
campaignActiverss_url | Campaign Activerss Url | Campaign | The RSS URL used to check for new feed items that get inserted into the campaign. |
campaignAnalytics_campaign_name | Campaign Analytics Campaign Name | Campaign | The Google Analytics campaign name, used for organizing within Google Analytics. |
campaignCan_skip_approval | Campaign Can Skip Approval | Campaign | Campaign Can Skip Approval |
campaignCdate | Campaign Created Date | Campaign | Date the campaign was initially created. |
campaignCreated_by | Campaign Created By | Campaign | Campaign Created By |
campaignEd_version | Campaign Edit Version | Campaign | Campaign Edit Version |
campaignFacebook | Campaign Facebook | Campaign | Whether or not this campaign auto-posted to Facebook. |
campaignForwards | Campaign Forwards | Campaign | Total amount of forwards for this campaign, including multiple forwards initiated by the same contact. |
campaignHardbounces | Campaign Hard Bounces | Campaign | Total number of hard bounces for this campaign. |
campaignHas_predictive_content | Campaign Has Predictive Content | Campaign | Campaign Has Predictive Content |
campaignId | Campaign ID | Campaign | Campaign ID |
campaignLaststep | Campaign Last Step | Campaign | The last step of the campaign process saved. |
campaignLinkclicks | Campaign Link Clicks | Campaign | Total amount of link clicks for this campaign, including multiple link clicks by the same contact. |
campaignMdate | Campaign Modified Date | Campaign | Date the campaign was last modified. |
campaignName | Campaign Name | Campaign | Internal name of the campaign. |
campaignOpens | Campaign Opens | Campaign | Total amount of opens for this campaign, including multiple opens by the same contact. |
campaignPublic | Campaign Public | Campaign | Whether or not this campaign is public. |
campaignRecurring | Campaign Recurring | Campaign | If this is a recurring campaign, how often it repeats. Possible values: day1, day2, week1, week2, month1, month2, quarter1, quarter2, year1, year2. |
campaignReminder_offset | Campaign Reminder Offset | Campaign | If this is an auto-reminder type campaign, how many days/weeks/months/years from that date should it trigger. |
campaignReminder_offset_sign | Campaign Reminder Offset Sign | Campaign | If this is an auto-reminder type campaign. |
campaignReminder_offset_type | Campaign Reminder Offset Type | Campaign | If this is an auto-reminder type campaign. |
campaignReminder_type | Campaign Reminder Type | Campaign | If this is an auto-reminder type campaign, match just a month and the day, or match year as well. |
campaignReplies | Campaign Replies | Campaign | Total number of replies for this campaign, including multiple replies by the same contact. |
campaignReplysys | Campaign Reply Sys | Campaign | Whether or not reply tracking is enabled for this campaign. |
campaignResponder_offset | Campaign Responder Offset | Campaign | If this is an auto-responder type campaign, how many hours after subscription to send it. |
campaignSchedule | Campaign Schedule | Campaign | Whether or not this campaign is scheduled to send at a later date/time. |
campaignScheduleddate | Campaign Scheduled Date | Campaign | Campaign Scheduled Date |
campaignScreenshot | Campaign Screenshot | Campaign | Campaign Screenshot |
campaignSdate | Campaign Send Date | Campaign | Date the campaign started sending. |
campaignSegmentname | Campaign Segment name | Campaign | Campaign Segment name |
campaignSend_amt | Campaign Sends | Campaign | Total amount of contacts actually sent this campaign. |
campaignSocialshares | Campaign Social Shares | Campaign | Total number of social shares conducted for this campaign. |
campaignSoftbounces | Campaign Soft Bounces | Campaign | Total number of soft bounces for this campaign. |
campaignSource | Campaign Source | Campaign | How the campaign was created. Possible value: ‘web’, ‘api’, ‘copy’, ‘recurr’, ‘system’. |
campaignSplit_offset | Campaign Split Offset | Campaign | If this is a split-type campaign, the number of units to wait before determining the winner. |
campaignSplit_offset_type | Campaign Split Offset Type | Campaign | If this is a split-type campaign, the type of unit to wait before determining the winner. Possible values: ‘hour’, ‘day’, ‘week’, ‘month’ |
campaignSplit_type | Campaign Split Type | Campaign | If 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_awaiting | Campaign Split Winner Awaiting | Campaign | Whether or not a winner is still being determined. |
campaignStatus | Campaign Status | Campaign | Status of this campaign. Possible values: 0 = Draft, 1 = Scheduled, 2 = Sending, 3 = Paused, 4 = Stopped, 5 = Completed, 6 = Disabled, 7 = Pending Approval |
campaignSubscriberclicks | Campaign Subscriber Clicks | Campaign | Total amount of distinct contacts that clicked a link for this campaign. |
campaignTracklinks | Campaign Track Links | Campaign | Type of link tracking enabled for the campaign. Possible values: ‘all’, ‘mime’, ‘html’, ‘text’, ‘none’ |
campaignTracklinksanalytics | Campaign Track Links Analytics | Campaign | Whether or not Google Analytics link tracking is enabled. |
campaignTrackreads | Campaign Track Reads | Campaign | Whether or not read/open tracking is enabled for this campaign. |
campaignTrackreadsanalytics | Campaign Track Reads Analytics | Campaign | Whether or not Google Analytics read tracking is enabled. |
campaignTweet | Campaign Twitter Mentions | Campaign | Whether or not this campaign auto-posted to Twitter. |
campaignType | Campaign Type | Campaign | Type of campaign. Possible values: ‘single’, ‘recurring’, ‘responder’, ‘reminder’, ‘split’, ‘activerss’, ‘text’ |
campaignUniqueforwards | Campaign Unique Forwards | Campaign | Total amount of distinct contacts that forwarded this campaign. |
campaignUniquelinkclicks | Campaign Unique Link Clicks | Campaign | Total amount of distinct links clicked for this campaign. |
campaignUniqueopens | Campaign Unique Opens | Campaign | Total amount of distinct contacts that opened this campaign. |
campaignUniquereplies | Campaign Unique Replies | Campaign | Total number of distinct contacts that replied to this campaign. |
campaignUnsubreasons | Campaign Unsub Reasons | Campaign | Total number of unsubscribe reasons provided for unsubscriptions for this campaign. |
campaignUnsubscribes | Campaign Unsubscribes | Campaign | Total number of unsubscribes for this campaign. |
campaignUpdated_by | Campaign Updated By | Campaign | Campaign Updated By |
campaignUpdates | Campaign Updates | Campaign | Total number of contacts that updated their profile via this campaign. |
campaignUse_quartz_scheduler | Campaign Use Quartz Scheduler | Campaign | Campaign Use Quartz Scheduler |
campaignVerified_opens | Campaign Verified Opens | Campaign | Campaign Verified Opens |
campaignVerified_unique_opens | Campaign Verified Unique Opens | Campaign | Campaign Verified Unique Opens |
gaCampaignContent | GA Campaign Content | Campaign | Google Analytics Campaign Content (utm_content) |
gaCampaignCustomsegment | GA Campaign Custom Segment | Campaign | Google Analytics Campaign Custom Segment |
gaCampaignMedium | GA Campaign Medium | Campaign | Google Analytics Campaign Medium (utm_medium) |
gaCampaignName | GA Campaign Name | Campaign | Google Analytics Campaign Name (utm_campaign) |
gaCampaignSource | GA Campaign Source | Campaign | Google Analytics Campaign Source (utm_source) |
gaCampaignTerm | GA Campaign Term | Campaign | Google Analytics Campaign Term (utm_term) |
day_of_month | Day of month | Time | Day of month |
contact_engagements_last_meeting_booked | Contact date of last meeting booked in meetings tool | Contact information | The date of the meeting that is booked the farthest out from the current date |
contact_engagements_last_meeting_booked_campaign | Contact campaign of last booking in meetings tool | Contact information | This 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_medium | Contact medium of last booking in meetings tool | Contact information | This 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_source | Contact source of last booking in meetings tool | Contact information | This UTM parameter shows which site (e.g. Twitter) referred the contact to the meetings tool for their most recent booking |
contact_fax | Contact fax number | Contact information | The contact’s primary fax number |
contact_first_deal_created_date | Contact first deal created date | Contact information | The create date of the first deal the contact is associated to |
contact_first_name | Contact first name | Contact information | The contact’s first name |
contact_hubspot_score | Contact HubSpot score | Contact information | The number that shows qualification of contacts to sales readiness based on the criteria set in HubSpot’s lead scoring tool |
contact_hubspot_team_id | Contact HubSpot team | Contact information | The team assigned to the contact owner for the contact |
contact_id | Contact ID | Contact information | The unique visitor ID of the contact |
contact_industry | Contact industry | Contact information | The contact’s industry |
contact_is_unworked | Contact unworked | Contact information | An indication if the contact has been worked |
contact_job_title | Contact job title | Contact information | The contact’s job title |
contact_language | Contact preferred language | Contact information | the contact’s preferred language for communications. This might be set via import, form, or integration |
contact_last_modified_date | Contact last modified date | Contact information | The last date and time that a property related to the contact was modified |
contact_last_name | Contact last name | Contact information | The contact’s last name |
contact_last_sales_activity_timestamp | Contact last engagement date | Contact information | The 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_enrolled | Contact last sequence enrolled | Contact information | The unique ID of the last sequence that the contact was enrolled in |
contact_lead_status | Contact lead status | Contact information | The contact and company property that indicates where the contact or company is within a buying cycle as a lead |
contact_lifecycle_stage | Contact lifecycle stage | Contact information | A property used to indicate at what point the contact is within the marketing/sales process |
contact_lifecycle_stage_customer_date | Contact became a customer date | Contact information | The date that the contact’s lifecycle stage changed to Customer |
contact_lifecycle_stage_evangelist_date | Contact became an evangelist date | Contact information | The date that the contact’s lifecycle stage changed to Evangelist |
contact_lifecycle_stage_lead_date | Contact became a lead date | Contact information | The date that the contact’s lifecycle stage changed to Lead |
contact_lifecycle_stage_marketing_qualified_lead_date | Contact became a marketing qualified lead date | Contact information | The date that the contact’s lifecycle stage changed to Marketing Qualified Lead |
contact_lifecycle_stage_opportunity_date | Contact became an opportunity date | Contact information | The date that the contact’s lifecycle stage changed to Opportunity |
contact_lifecycle_stage_other_date | Contact became an other lifecycle date | Contact information | The date that the contact’s lifecycle stage changed to Other |
contact_lifecycle_stage_sales_qualified_lead_date | Contact became a sales qualified lead date | Contact information | The date that the contact’s lifecycle stage changed to Sales Qualified Lead |
contact_lifecycle_stage_subscriber_date | Contact became a subscriber date | Contact information | The date that the contact’s lifecycle stage changed to Subscriber |
contact_marketable_until_renewal | Contact marketing status | Contact information | Indicates if the contact is currently a marketing or non-marketing contact |
contact_message | Contact message | Contact information | A default property to be used for any message or comments the contact may want to leave on a form |
contact_mobile_phone | Contact mobile phone number | Contact information | The contact’s mobile phone number |
contact_notes_last_contacted | Contact last contacted | Contact information | The last date and time a chat conversation, call, sales email, or meeting was logged for the contact |
contact_notes_last_updated | Contact last activity date | Contact information | The 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_date | Contact next activity date | Contact information | The date of the next upcoming activity for the contact |
contact_num_associated_deals | Contact number of associated deals | Contact information | The total number of all associated deals |
contact_num_contacted_notes | Contact number of times contacted | Contact information | The total number of times the contact received a sales email, received a call, or had a chat conversation |
contact_num_employees | Contact number of employees | Contact information | The number of company employees |
contact_num_notes | Contact number of sales activities | Contact information | The total number of sales activities (notes, calls, emails, meetings, tasks, or chats) logged for the contact |
contact_owner | Contact owner | Contact information | The owner of the contact |
contact_owner_assigned_date | Contact owner assigned date | Contact information | The most recent date that the contact owner was assigned to the contact |
contact_owner_id | Contact owner ID | Contact information | The owner ID of the contact |
contact_persona | Contact persona | Contact information | The contact’s persona |
contact_phone | Contact phone number | Contact information | The contact’s primary phone number |
contact_predictive_contact_score | Contact Likelihood to close (Marketing Hub Enterprise and Sales Hub Enterprise only) | Contact information | The probability that the contact will become a customer within the next 90 days |
contact_predictive_scoring_tier | Contact priority (Marketing Hub Enterprise, Sales Hub Enterprise, and Service Hub Enterprise only) | Contact information | A ranking system of contacts evenly assigned into four tiers |
contact_recent_deal_amount | Contact recent deal amount | Contact information | The value of the last closed-won deal associated with that contact |
contact_recent_deal_close_date | Contact recent deal close date | Contact information | The date of the last associated deal that was closed as won |
contact_sales_email_last_clicked | Contact recent sales email clicked date (Sales Hub Professional and Enterprise only) | Contact information | The date of the last time that the contact clicked on a sales email |
contact_sales_email_last_opened | Contact recent sales email open date | Contact information | The date of the last time that the contact opened a sales email |
contact_sales_email_last_replied | Contact recent sales email replied date | Contact information | The 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_salutation | Contact salutation | Contact information | The title used to address the contact |
contact_sequences_enrolled_count | Contact number of sequences enrolled | Contact information | The number of times a contact was enrolled into a sequence |
contact_state | Contact state/region | Contact information | The contact’s state of residence |
contact_time_between_contact_creation_and_deal_close | Contact time between creation and deal close | Contact information | The 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_creation | Contact time between creation and deal creation | Contact information | The amount of time between when a contact was created and when the contact was associated with a deal |
contact_total_revenue | Contact total revenue | Contact information | Total dollar amount of all associated deals that have been closed as won |
contact_website | Contact website URL | Contact information | The contact’s company website |
contact_zip | Contact postal code | Contact information | The contact’s zip code |
total_contacts | Total contacts | Contact information | The total contacts |
total_lead | Total leads | Contact information | Total leads |
total_mql | Total marketing qualified leads | Contact information | Total marketing qualified leads |
total_sql | Total sales qualified leads | Contact information | Total sales qualified leads |
mkt_email_body | Marketing email body | Marketing email | The email body |
mkt_email_bounce | Marketing email bounce | Marketing email | The 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_total | Marketing email bounce total | Marketing email | The 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_bounceratio | Marketing email bounce ratio | Marketing email | The number of contacts that bounced from the email over the total number of selected contacts. |
mkt_email_campaign_id | Marketing email campaign Id | Marketing email | The email campaign Id |
mkt_email_campaign_name | Marketing email campaign name | Marketing email | The email campaign name |
mkt_email_click | Marketing email click | Marketing email | The number of unique recipients who clicked on any link in your email, excluding the Unsubscribe and Subscription Preferences links. |
mkt_email_click_total | Marketing email click total | Marketing email | The 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_clickratio | Marketing email click ratio | Marketing email | Click rate is the percentage of people who clicked a link in your email out of the people who were delivered your email. |
mkt_email_clickthroughratio | Marketing email click through ratio | Marketing email | This is the percentage of people who clicked a link in your email out of the people who opened your email. |
mkt_email_contactslost | Marketing email contacts lost | Marketing email | The sum of contacts that have unsubscribed, marked the email as spam, or have hardbounced. |
mkt_email_contactslost_total | Marketing email contacts lost total | Marketing email | The sum of contacts that have unsubscribed, marked the email as spam, or have hardbounced, historically up to the current date. |
mkt_email_contactslostratio | Marketing email contacts lost ratio | Marketing email | The number of contacts that can no longer recive emails from the portal over the total number of selected contacts. |
mkt_email_created_at | Marketing email created time | Marketing email | The time the email was created |
mkt_email_created_date | Marketing email created date | Marketing email | The date the email was created |
mkt_email_delivered | Marketing email delivered | Marketing email | The number of emails succesfully delivered to an inbox |
mkt_email_delivered_total | Marketing email delivered total | Marketing email | Total number of marketing emails succesfully delivered to an inbox historically up to the current date |
mkt_email_deliveredratio | Marketing email delivered ratio | Marketing email | the number of succesfull deliveries over the number of selected contacts. |
mkt_email_dropped | Marketing email dropped | Marketing email | The 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_total | Marketing email dropped total | Marketing email | The 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_name | Marketing email from name | Marketing email | The email from name |
mkt_email_hardbounced | Marketing email hard bounced | Marketing email | These 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_total | Marketing email hard bounced total | Marketing email | These 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_hardbounceratio | Marketing email hard bounce ratio | Marketing email | The number of contacts that hard bounced from the email over the total number of selected contacts. |
mkt_email_id | Marketing email ID | Marketing email | The id of the email |
mkt_email_language | Marketing email language | Marketing email | The language of the email |
mkt_email_name | Marketing email name | Marketing email | The name of the email |
mkt_email_notsent | Marketing email not sent | Marketing email | These 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_total | Marketing email not sent total | Marketing email | These 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_notsentratio | Marketing email not sent ratio | Marketing email | The number of contacts that were selected but not sent to over the total number of selected contacts. |
mkt_email_open | Marketing email open | Marketing email | The total number of unique opens |
mkt_email_open_total | Marketing email open total | Marketing email | Total number of marketing emails unique opens historically up to the current date |
mkt_email_openratio | Marketing email open ratio | Marketing email | The percentage of people who opened your email out of the people who were delivered your email. |
mkt_email_pending | Marketing email pending | Marketing email | The number of emails still trying to reach a contact’s inbox. |
mkt_email_pending_total | Marketing email pending total | Marketing email | The number of emails still trying to reach a contact’s inbox, historically up to the current date. |
mkt_email_pendingratio | Marketing email pending ratio | Marketing email | The number of contacts that soft bounced from the email over the total number of selected contacts. |
mkt_email_reply_to | Marketing email reply to | Marketing email | The email reply to |
mkt_email_selected | Marketing email selected | Marketing email | The number of contacts selected to receive this email. |
mkt_email_selected_total | Marketing email selected total | Marketing email | The number of contacts selected to receive this email, historically up to the current date. |
mkt_email_sent | Marketing email sent | Marketing email | the total number of sent emails |
mkt_email_sent_total | Marketing email sent total | Marketing email | Total number of marketing emails sent historically up to the current date |
mkt_email_softbounced | Marketing email soft bounced | Marketing email | Soft 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_total | Marketing email soft bounced total | Marketing email | Soft 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_softbounceratio | Marketing email soft bounce ratio | Marketing email | The number of contacts that soft bounced from the email over the total number of selected contacts. |
mkt_email_spamreport | Marketing email spam report | Marketing email | The number of contacts received your email and marked it as spam. They won’t be sent to in the future. |
mkt_email_spamreport_total | Marketing email spam report total | Marketing email | The 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_spamreportratio | Marketing email spam report ratio | Marketing email | The number of contacts that mark the email as spam over the total number of selected contacts. |
mkt_email_state | Marketing email state | Marketing email | The email state |
mkt_email_subcategory | Marketing email subcategory | Marketing email | The subcategory of the email |
mkt_email_subject | Marketing email subject | Marketing email | The subject of the email |
mkt_email_suppressed | Marketing email suppressed | Marketing email | The number of contacts that did not receive your email due to graymail suppression. |
mkt_email_suppressed_total | Marketing email suppressed total | Marketing email | The 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_unsubscribed | Marketing email unsubscribed | Marketing email | The number of contacts who received your email and unsubscribed. They won’t be sent to in the future. |
mkt_email_unsubscribed_total | Marketing email unsubscribed total | Marketing email | The 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_unsubscribedratio | Marketing email unsubscribed ratio | Marketing email | the number of contacts that have unsubscribed over the total number of selected contacts |
contactAnonymized | Contact Anonymized | Contact | Whether or not this contact is anonymized. |
contactArea | Contact Area | Contact | Contact Area |
contactAutomationsAdddate | Contact Automation Added Date | Contact | Contact Automation Added Date |
contactAutomationsBatchid | Contact Automation Batch ID | Contact | Contact Automation Batch ID |
contactAutomationsCompleted | Contact Automation Completed | Contact | Contact Automation Completed |
contactAutomationsCompletedelements | Contact Automation Completed Elements | Contact | Contact Automation Completed Elements |
contactAutomationsCompletevalue | Contact Automation Complete Value | Contact | Contact Automation Complete Value |
contactAutomationsId | Contact Automation ID | Contact | Contact Automation ID |
contactAutomationsStatus | Contact Automation Status | Contact | Contact Automation Status |
contactAutomationsTimespan | Contact Automation Timespan | Contact | Contact Automation Timespan |
contactAutomationsTotalelements | Contact Automation Total Elements | Contact | Contact Automation Total Elements |
contactBounced_hard | Contact Bounced Hard | Contact | Number of times this contact has hard-bounced. |
contactBounced_soft | Contact Bounced Soft | Contact | Number of times this contact has soft-bounced. |
contactCdate | Contact Created Date | Contact | Date subscribed. |
contactCity | Contact City | Contact | Contact City |
contactCountryCode | Contact Country Code | Contact | Contact Country Code |
contactCreated_by | Contact Created By | Contact | Contact Created By |
contactCreated_utc_timestamp | Contact Created At UTC Timestamp | Contact | Contact Created At UTC Timestamp |
contactDeleted | Contact Deleted | Contact | Whether or not this contact was deleted. |
contactDeleted_at | Contact Deleted At | Contact | Contact Deleted At |
contactEmail | Contact Email | Contact | Email address of contact. |
contactEmail_domain | Contact Email Domain | Contact | Contact Email Domain |
contactEmail_local | Contact Email Local | Contact | Contact Email Local |
contactFirstname | Contact First Name | Contact | Contact First Name |
contactGeoCountry | Contact Country | Contact | Contact Geographical Country Code |
contactId | Contact ID | Contact | Contact ID |
contactLastname | Contact Last Name | Contact | Contact Last Name |
contactLat | Contact Latitude | Contact | Contact Latitude |
contactListsCreated_by | Contact List Created By | Contact | Contact List Created By |
contactListsCreated_timestamp | Contact List Created Timestamp | Contact | Date when contact was added to the list. |
contactListsId | Contact List Id | Contact | Contact List Id |
contactListsMessage | Contact List Message | Contact | Contact List Message |
contactListsStatus | Contact List Status | Contact | Contact List Status |
contactListsUnsubreason | Contact List Unsubreason | Contact | Contact List Unsubreason |
contactListsUpdated_by | Contact List Updated By | Contact | Contact List Updated By |
contactListsUpdated_timestamp | Contact List Updated Timestamp | Contact | Date when contact was updated to the list. |
contactLon | Contact Longitude | Contact | Contact Longitude |
contactOrgid | Contact Organization ID | Contact | Contact Organization ID |
contactOrgname | Contact Organization Name | Contact | Contact Organization Name |
contactPhone | Contact Phone | Contact | Contact Phone |
contactSentcnt | Contact Sends | Contact | Contact Sends |
contactState | Contact State | Contact | Contact State |
contactTagsCdate | Contact Tag Created Date | Contact | Date when tag was added to this contact. |
contactTagsCreated_by | Contact Tag Created By | Contact | Contact Tag Created_by |
contactTagsCreated_timestamp | Contact Tag Created Timestamp | Contact | Contact Tag Created Timestamp |
contactTagsId | Contact Tag Id | Contact | Contact Tag Id |
contactTagsUpdated_by | Contact Tag Updated By | Contact | Contact Tag Updated_by |
contactTagsUpdated_timestamp | Contact Tag Updated Timestamp | Contact | Contact Tag Updated Timestamp |
contactTz | Contact Timezone | Contact | Contact Timezone |
contactTzOffset | Contact Timezone Offset | Contact | Contact Timezone Offset |
contactUdate | Contact Updated Date | Contact | Date updated. |
contactUpdated_by | Contact Updated By | Contact | Contact Updated By |
contactUpdated_utc_timestamp | Contact Updated At UTC Timestamp | Contact | Contact Updated At UTC Timestamp |
contactZip | Contact Zip | Contact | Contact Zip Code |
deal_acv | Deal annual contract value (ACV) | Deal information | The value of the deal over a 12-month period in the deal’s currency |
deal_amount | Deal amount | Deal information | The total value of the deal in the deal’s currency |
deal_amount_closed_lost | Deal amount lost | Deal information | The Amount value for deals marked as Closed Lost in the deal’s currency |
deal_amount_closed_won | Deal amount won | Deal information | The Amount value for deals marked as Closed Won in the deal’s currency |
deal_amount_in_home_currency | Deal amount in company currency | Deal information | The total value of the deal in your selected company currency |
deal_arr | Deal annual recurring revenue (ARR) | Deal information | The total amount of revenue earned annually for this deal |
deal_close_date | Deal close date | Deal information | The day the deal is expected to close, or was closed |
deal_closed_count | Deal closed count | Deal information | The total count of deals |
deal_closed_lost | Deal closed lost | Deal information | The total count of lost deals |
deal_closed_lost_reason | Deal closed lost reason | Deal information | Reason why the deal was lost |
deal_closed_won | Deal closed won | Deal information | The total count of won deals |
deal_closed_won_reason | Deal closed won reason | Deal information | Reason why the deal was won |
deal_create_date | Deal create date | Deal information | The date the deal was created |
deal_currency_code | Deal currency | Deal information | true if the deal is in the closed won state, false otherwise |
deal_description | Deal description | Deal information | A brief description of the deal |
deal_forecast_amount | Deal forecast amount | Deal information | The deal amount multiplied by the forecast probability |
deal_forecast_probability | Deal forecast probability | Deal information | The custom percent probability that the deal will close |
deal_hubspot_team_id | Deal HubSpot team | Deal information | The team assigned to the deal owner for the deal |
deal_id | Deal ID | Deal information | ID of the deal |
deal_is_closed | Is Deal Closed? | Deal information | true if the deal was won or lost. |
deal_is_closed_won | Deal is closed won | Deal information | true if the deal is in the closed won state, false otherwise |
deal_last_modified_date | Deal last modified date | Deal information | The most recent date that any property on a deal was updated |
deal_manual_forecast_category | Deal forecast category | Deal information | The likelihood of the deal closing, categorized as Omit, Pipeline, Best case, Most likely, Commit, or Closed |
deal_mrr | Deal monthly recurring revenue (MRR) | Deal information | The recurring revenue each month for this deal |
deal_name | Deal name | Deal information | The name you have given this deal |
deal_next_step | Deal next step | Deal information | The next steps that you or another user will take to improve the deal’s likelihood to close |
deal_notes_last_contacted | Deal last contacted | Deal information | The last time a chat conversation, call, sales email, or meeting was logged for this deal |
deal_notes_last_updated | Deal last activity date | Deal information | The last time a note, chat conversation, call, email, meeting, or task was logged for a deal |
deal_notes_next_activity_date | Deal next activity date | Deal information | The date of the next upcoming activity for a deal |
deal_num_associated_contacts | Deal number of associated contacts | Deal information | The number of contacts associated with this deal |
deal_num_contacted_notes | Deal number of times contacted | Deal information | The total number of calls, emails, and meetings that are logged for associated contact records and are associated with the deal |
deal_num_notes | Deal number of sales activities | Deal information | The total number of sales activities (notes, calls, emails, meetings, or tasks) logged for a deal |
deal_owner | Deal owner | Deal information | The user from your team that the deal is assigned to |
deal_owner_assigned_date | Deal owner assigned date | Deal information | The date the most recent deal owner was assigned to a deal |
deal_owner_id | Deal owner ID | Deal information | The user ID from your team that the deal is assigned to |
deal_pipeline | Deal pipeline | Deal information | The pipeline a deal is in, which determines the deal stages the deal will move through |
deal_priority | Deal priority | Deal information | The level of attention needed on the deal |
deal_projected_amount | Deal weighted amount | Deal information | The Amount multiplied by the Deal probability |
deal_stage | Deal stage | Deal information | Deal stages allow you to categorize and track the progress of the deals that you are working on |
deal_stage_probability | Deal probability | Deal information | The probability that the deal will close |
deal_tcv | Deal total contract value (TCV) | Deal information | The total value of the deal, based on the line items associated to the deal, including any recurring revenue and one-time charges |
deal_type | Deal type | Deal information | Deal types allow you to categorize your deals |
deal_ui_link | Deal link in HubSpot UI | Deal information | Link to deal in HubSpot UI |
total_deals | Total deals | Deal information | The total deals |
listId | List ID | List | List ID |
listsAnalytics_source | List Analytics Source | List | List analytics source |
listsAnalytics_ua | List Analytics UA | List | Lists Analytics UA |
listsCdate | List Created Date | List | Date/time the list was created. |
listsCreated_by | List Created By | List | Lists Created By |
listsCreated_timestamp | List Created Timestamp | List | Lists Created Timestamp |
listsFulladdress | List Full Address | List | Lists Full Address |
listsGet_unsubscribe_reason | List Get Unsubscribe Reason | List | Whether or not to ask for a reason when contacts UNsubscribe. |
listsName | List Name | List | Internal name of list. |
listsOptinoptout | List Opt In Opt Out | List | Lists Opt In Opt Out |
listsP_embed_image | List Embed Image | List | Whether or not to embed images for campaigns send to this list. |
listsP_use_analytics_link | List Use Analytics Link | List | Whether or not to use analytics link |
listsP_use_analytics_read | List Use Analytics Read | List | Whether or not to use analytics read |
listsP_use_captcha | List Use Captcha | List | Whether or not to use captcha image verification when subscribing to this list. |
listsP_use_facebook | List Use Facebook | List | Whether or not to use Facebook campaign auto-sharing. |
listsP_use_tracking | List Use Tracking | List | Whether or not to use tracking |
listsP_use_twitter | List Use Twitter | List | Whether or not to use Twitter campaign auto-sharing. |
listsPrivate | List Private | List | Whether or not this list is private not visible on public side. |
listsRequire_name | List Require Name | List | Whether or not to require a name when subscribing to this list. |
listsSend_last_broadcast | List Send Last Broadcast | List | Whether or not to send last broadcast message to new contacts of this list. |
listsSender_addr1 | List Sender Address 1 | List | Sender’s Contact Information. |
listsSender_addr2 | List Sender Address 2 | List | Sender’s Contact Information. |
listsSender_city | List Sender City | List | Sender’s Contact Information. |
listsSender_country | List Sender Country | List | Sender’s Contact Information. |
listsSender_name | List Sender Name | List | Sender’s Contact Information. |
listsSender_phone | List Sender Phone | List | Sender’s Contact Information. |
listsSender_reminder | List Sender Reminder | List | Sender’s Reminder to Contacts. |
listsSender_state | List Sender State | List | Sender’s Contact Information. |
listsSender_url | List Sender Url | List | Sender’s Contact Information. |
listsSender_zip | List Sender Zip | List | Sender’s Contact Information. |
listsTo_name | List To Name | List | Default contact name used when contact has not entered a name. |
listsUpdated_by | List Updated By | List | Lists Updated By |
listsUpdated_timestamp | List Updated Timestamp | List | Lists Updated Timestamp |
line_item_acv | Line item annual contract value (ACV) | Line item | The annual contract value (ACV) of the line item |
line_item_amount | Line item net price | Line item | The amount of the line item |
line_item_arr | Line item annual recurring revenue (ARR) | Line item | The annual recurring revenue (ARR) of the line item |
line_item_cost_of_goods_sold | Line item unit cost | Line item | The amount that sold goods cost the HubSpot customer |
line_item_create_date | Line item created date | Line item | The time when line item was created |
line_item_currency_code | Line item currency | Line item | Currency code for the line item |
line_item_description | Line item description | Line item | Full description of the line item |
line_item_discount | Line item unit discount | Line item | The discount amount applied |
line_item_id | Line item ID | Line item | ID of the line item |
line_item_images | Line item image URL | Line item | Images of products used in the line item |
line_item_margin | Line item margin | Line item | The margin value of the line item |
line_item_margin_acv | Line item annual contract value margin | Line item | The margin annual contract value of the line item |
line_item_margin_arr | Line item annual recurring revenue margin | Line item | The margin annual recurring revenue of the line item |
line_item_margin_mrr | Line item monthly recurring revenue margin | Line item | The margin annual recurring revenue of the line item |
line_item_margin_tcv | Line item total contract value margin | Line item | The margin total contract value of the line item |
line_item_mrr | Line item monthly recurring revenue (MRR) | Line item | The monthly recurring revenue (MRR) of the line item |
line_item_name | Line item name | Line item | Line item name |
line_item_price | Line item unit price | Line item | Cost of product in the line item |
line_item_product_id | Line item product ID | Line item | ID of the product this was copied from |
line_item_quantity | Line item quantity | Line item | How many units of a product are in the line item |
line_item_recurring_billing_end_date | Line item end date | Line item | Recurring billing end date for the line item |
line_item_recurring_billing_frequency | Line item recurring billing frequency | Line item | How frequently the line item is billed |
line_item_recurring_billing_period | Line item term | Line item | Product recurring billing duration |
line_item_recurring_billing_start_date | Line item start date | Line item | Recurring billing start date for the line item |
line_item_sku | Line item SKU | Line item | Unique product identifier |
line_item_tax | Line item tax | Line item | The tax amount applied |
line_item_tcv | Line item total contract value (TCV) | Line item | The total contract value (TCV) of the line item |
line_item_term_in_months | Line item term in months | Line item | The number of months in the term of the line item |
line_item_url | Line item URL | Line item | Product URL used in the line item |
total_line_items | Total line items | Line item | The total line items |
formCdate | Form Cdate | Form | Form Cdate |
formContacts | Form Contacts | Form | Form Contacts |
formDeals | Form Deals | Form | Form Deals |
formEntries | Form Entries | Form | Form Entries |
formId | Form Id | Form | Form Id |
formName | Form Name | Form | Form Name |
formScreenshot | Form Screenshot | Form | Form Screenshot |
formUdate | Form Udate | Form | Form Udate |
formUrl | Form Url | Form | Form Url |
form_captcha_enabled | Form is captcha enabled | Form | Will be set to true for forms with captcha enabled |
form_created_at | Form created date | Form | Date when the form was created |
form_css_class | Form CSS class | Form | The default css classes added to the form when embedded |
form_guid | Form GUID | Form | The internal ID of the form |
form_ignore_current_values | Form ignore current values | Form | If true, the form pre-populates fields with known values for know contacts |
form_inline_message | Form inline message | Form | A thank you message that is displayed on the page after the form is submitted |
form_is_cloneable | Form is clonable | Form | Whether or not the form can be cloned |
form_is_deletable | Form is deletable | Form | If false, the form is a system form (such as a blog comment or subscription form) and cannot be deleted |
form_is_editable | Form is editable | Form | Whether or not the form can be edited |
form_name | Form name | Form | The name of the form |
form_notify_recipients | Form notify recipients | Form | A comma-separated list of email addresses that should receive submission notifications |
form_redirect_url | Form redirect URL | Form | The URL that the visitor is redirected to after filling out the form |
form_submission_date | Form submission date | Form | Date of the form submission |
form_submissions | Form submissions | Form | Number of form submissions |
form_submit_text | Form submit text | Form | The text used for the submit button |
form_updated_at | Form last modified date | Form | Date when the form was last modified |
averageDealValueWon | Average Deal Value Won | Deal | Average Deal Value Won |
dealActivitycount | Deal Activity Count | Deal | Deal Activity Count |
dealCdate | Deal Created Date | Deal | Date the deal was initially created. |
dealCurrency | Deal Currency | Deal | Deal Currency |
dealDescription | Deal Description | Deal | Deal Description |
dealGroup | Deal Group | Deal | Deal Group |
dealHash | Deal Hash | Deal | Deal Hash |
dealId | Deal ID | Deal | Deal ID |
dealIsdisabled | Deal Is Disabled | Deal | Deal Is Disabled |
dealMdate | Deal Last Modify Date | Deal | Deal Last Modify Date |
dealNextdate | Deal Next Date | Deal | Deal Next Date |
dealNextdealid | Deal Next Deal ID | Deal | Deal Next Deal ID |
dealNexttaskid | Deal Next Task ID | Deal | Deal Next Task ID |
dealOrganization | Deal Organization | Deal | Deal Organization |
dealPercent | Deal Percent | Deal | Deal Percent |
dealStage | Deal Stage | Deal | Stage ID associated with the deal |
dealStatus | Deal Status | Deal | Deal Status |
dealTitle | Deal Title | Deal | Title of the deal |
dealValue | Deal Value | Deal | Deal Value |
dealWinprobability | Deal Win Probability | Deal | Deal Win Probability |
dealWinprobabilitymdate | Deal Win Probability Date | Deal | Deal Win Probability Date |
product_cost_of_goods_sold | Product unit cost | Product | The amount that sold goods cost the HubSpot customer |
product_create_date | Product create date | Product | Date when the product was created |
product_description | Product description | Product | Description of the product |
product_discount | Product unit discount | Product | Discount of the product |
product_discount_percentage | Product discount percentage | Product | Discount percentage of the product |
product_id | Product ID | Product | ID of the product |
product_last_modified_date | Product last modified date | Product | Date when the product was last modified |
product_name | Product name | Product | Name of the product |
product_price | Product unit price | Product | Price of the product |
product_quantity | Product quantity | Product | Quantity of the product |
product_recurring_billing_frequency | Product recurring billing frequency | Product | Recurring billing frequency of the product |
product_recurring_billing_period | Product term | Product | Recurring billing period of the product |
product_sku | Product SKU | Product | SKU of the product |
product_tax | Product tax | Product | Tax of the product |
total_products | Total products | Product | The total products |
contact_facebook_click_id | Contact Facebook click ID | Contact conversion information | A value that indicates a contact’s first visit to your site came from a Facebook ad |
contact_first_conversion_date | Contact first conversion date | Contact conversion information | The date the contact first submitted a form |
contact_first_conversion_event_name | Contact first conversion | Contact conversion information | The first landing page and form the contact submitted on |
contact_google_click_id | Contact Google ad click ID | Contact conversion information | A value that indicates a contact’s first visit to your site came from a Google ad |
contact_ip_city | Contact IP city | Contact conversion information | The city reported by the contact’s IP address |
contact_ip_country | Contact IP country | Contact conversion information | The country reported by the contact’s IP address |
contact_ip_country_code | Contact IP country code | Contact conversion information | The country code reported by the contact’s IP address |
contact_ip_state | Contact IP state/region | Contact conversion information | The state or region reported by the contact’s IP address |
contact_ip_state_code | Contact IP state/region code | Contact conversion information | The state code or region code reported by the contact’s IP address |
contact_ip_timezone | Contact IP time zone | Contact conversion information | The timezone reported by the contact’s IP address |
contact_num_unique_conversion_events | Contact number of unique forms submitted | Contact conversion information | The number of different HubSpot forms, pop-up forms, and collected forms the contact has submitted |
contact_recent_conversion_date | Contact recent conversion date | Contact conversion information | The date the contact last submitted a form |
contact_recent_conversion_event_name | Contact recent conversion | Contact conversion information | The last form the contact submitted |
meeting_engagement_body | Meeting engagement body | Meeting Engagements | The meeting description. |
meeting_engagement_end_time | Meeting engagement end time | Meeting Engagements | The date and time when the meeting ends. |
meeting_engagement_external_url | Meeting engagement esternal URL | Meeting Engagements | The external URL for the calendar event. |
meeting_engagement_id | Meeting engagement ID | Meeting Engagements | The ID of the meeting. |
meeting_engagement_location | Meeting engagement location | Meeting Engagements | Where the meeting takes place. The value could be a physical address, a conference room, a videoconference link, or a phone number. |
meeting_engagement_meeting_notes | Meeting engagement notes | Meeting Engagements | The internal notes you take for your team during a meeting that are not included in the attendee meeting description. |
meeting_engagement_outcome | Meeting engagement outcome | Meeting Engagements | The outcome of the meeting. The outcome values are scheduled, completed, rescheduled, no show, and canceled. |
meeting_engagement_owner_id | Meeting engagement owner id | Meeting Engagements | The ID of the owner associated with the meeting |
meeting_engagement_start_time | Meeting engagement start time | Meeting Engagements | The date and time when the meeting starts. |
meeting_engagement_timestamp | Meeting engagement timestamp | Meeting Engagements | The meeting’s due date. |
meeting_engagement_title | Meeting engagement title | Meeting Engagements | The meeting’s title |
meeting_engagement_type | Meeting engagement type | Meeting Engagements | The type of meeting. T |
contact_list_created_at | Contact list created time | Contact list | The time the list was created |
contact_list_deleteable | Contact list is deleteable | Contact list | If this is false, this is a system list and cannot be deleted |
contact_list_dynamic | Contact list type | Contact list | One of DYNAMIC or STATIC |
contact_list_error | Contact list error | Contact list | Any errors that happened the last time the list was processed |
contact_list_id | Contact list ID | Contact list | The unique ID of the list |
contact_list_last_processing_state_change_at | Contact list last processing state change time | Contact list | The last time that the processing state changed |
contact_list_last_size_change_at | Contact list last size change time | Contact list | Last size change time |
contact_list_name | Contact list name | Contact list | The name of the list |
contact_list_processing | Contact list processing status | Contact list | One of DONE, REFRESHING, INITIALIZING, or PROCESSING |
contact_list_updated_at | Contact list updated time | Contact list | The time that the list was last modified |
date | Date | Date | Date |
day_of_week | Day of week (Mon – Sun) | Date | Day of week (Mon – Sun) |
hour | Hour of day | Date | Hour of day |
month | Month | Date | Month |
quarter | Quarter | Date | Quarter |
week | Week | Date | Week |
year | Year | Date | Year |
year_month | Month and year | Date | Month and year |
year_quarter | Quarter and year | Date | Quarter and year |
year_week | Week and year | Date | Week and year |
tagCdate | Tag Created Date | Tag | Date the tag was initially created. |
tagCreated_by | Tag Created By | Tag | Tag Created By |
tagCreated_timestamp | Tag Created Timestamp | Tag | Tag Created Timestamp |
tagDescription | Tag Description | Tag | Tag Description |
tagId | Tag ID | Tag | Tag ID |
tagName | Tag Name | Tag | Tag Name |
tagSubscriber_count | Tag Subscriber Count | Tag | Tag Subscriber Count |
tagType | Tag Type | Tag | Tag Type |
tagUpdated_by | Tag Updated By | Tag | Tag Updated By |
tagUpdated_timestamp | Tag Updated Timestamp | Tag | Tag Updated Timestamp |
automationCdate | Automation Cdate | Automation | Date the automation was initially created. |
automationEntered | Automation Entered | Automation | Automation Entered |
automationExited | Automation Exited | Automation | Automation Exited |
automationHidden | Automation Hidden | Automation | Automation Hidden |
automationId | Automation Id | Automation | Automation Id |
automationMdate | Automation Modified date | Automation | Automation modified date. |
automationName | Automation Name | Automation | Automation Name |
automationScreenshot | Automation Screenshot | Automation | Automation Screenshot |
automationStatus | Automation Status | Automation | Automation Status |
contact_field_of_study | Contact field of study | Contact ads properties | The field of study as provided through a lead ad form |
contact_gender | Contact gender | Contact ads properties | The gender as provided through a lead ad form |
contact_graduation_date | Contact graduation date | Contact ads properties | The graduation date of education as provided through a lead ad form |
contact_marital_status | Contact marital status | Contact ads properties | The marital status as provided through a lead ad form |
contact_relationship_status | Contact relationship status | Contact ads properties | The relationship status as provided through a lead ad form |
contact_school | Contact school | Contact ads properties | The school as provided through a lead ad form |
contact_seniority | Contact seniority | Contact ads properties | The seniority in the company as provided through a lead ad form |
contact_start_date | Contact start date | Contact ads properties | The start date of education as provided through a lead ad form |
contact_work_email | Contact work email | Contact ads properties | The work email as provided through a lead ad form |
userEmail | User Email | User | User Email |
userFirstname | User First Name | User | User First Name |
userId | User Id | User | User Id |
userLang | User Language | User | User Language |
userLastname | User Last Name | User | User Last Name |
userLocalzoneid | User Local Zone ID | User | User Local Zone ID |
userPhone | User Phone | User | User Phone |
userSignature | User Signature | User | User Signature |
userUsername | User Username | User | User Username |
traffic_analytics_bounce_rate | Analytics traffic bounce rate (%) | Analytics | The percentage of sessions that started on a page and did not move beyond that page |
traffic_analytics_bounces | Analytics traffic bounces | Analytics | The number of sessions that started on a page and did not move beyond that page |
traffic_analytics_new_session_rate | Analytics new traffic sessions (%) | Analytics | The percentage of total sessions from new visitors |
traffic_analytics_page_views | Analytics traffic page views | Analytics | The total number of page views |
traffic_analytics_page_views_per_session | Analytics avg. traffic page views per session | Analytics | Average unique page views per session |
traffic_analytics_session_avg_time | Analytics avg. traffic session length (seconds) | Analytics | The average time between the start and end of a session in seconds |
traffic_analytics_session_contact_rate | Analytics traffic session to contact rate | Analytics | The number of new contacts divided by the number of sessions |
traffic_analytics_sessions | Analytics traffic sessions | Analytics | The number of times a user visited your website during this period |
contact_email_last_click_date | Contact last marketing email click date | Contact email information | The date of the most recent link click for any marketing email |
contact_email_last_email_name | Contact last marketing email name | Contact email information | The name of the last marketing email sent |
contact_email_last_open_date | Contact last marketing email open date | Contact email information | The date of the most recent email open for any marketing email |
contact_email_last_send_date | Contact last marketing email send date | Contact email information | The date of the most recent email delivery for any marketing email |
contact_email_open | Contact marketing emails opened | Contact email information | The number of marketing emails opened |
contact_email_opt_out | Contact unsubscribed from all email | Contact email information | Indicates that the current email address has opted out of all email from the account |
contact_email_quarantined | Contact email address quarantined | Contact email information | Indicates that the current email address has been quarantined for anti-abuse reasons |
contact_email_sends_since_last_engagement | Contact sends since last engagement | Contact email information | The number of marketing emails that have been sent since the last engagement, specifically email open or link click |
task_engagement_body | Task engagement body | Tasks Engagements | The task notes |
task_engagement_id | Task engagement ID | Tasks Engagements | The ID of the task. |
task_engagement_owner_id | Task engagement owner id | Tasks Engagements | The owner ID of the user assigned to the task. |
task_engagement_priority | Task engagement priority | Tasks Engagements | The status of the task, either COMPLETED or NOT_STARTED. |
task_engagement_status | Task engagement status | Tasks Engagements | The status of the task, either COMPLETED or NOT_STARTED. |
task_engagement_timestamp | Task engagement timestamp | Tasks Engagements | The task’s due date. |
task_engagement_title | Task engagement title | Tasks Engagements | The title of the task. |
task_engagement_type | Task engagement type | Tasks Engagements | The type of task. Values include EMAIL, CALL, or TODO. |
email_engagement_body | Email engagement body | Email Engagements | The body of the email. |
email_engagement_direction | Email engagement direction | Email Engagements | The direction the email was sent in. |
email_engagement_id | Email engagement ID | Email Engagements | The ID of the email. |
email_engagement_owner_id | Email engagement owner id | Email Engagements | The ID of the owner associated with the email. |
email_engagement_status | Email engagement status | Email Engagements | The send status of the email. The value can be BOUNCED, FAILED, SCHEDULED, SENDING, or SENT. |
email_engagement_subject | Email engagement subject | Email Engagements | The subject line of the logged email. |
email_engagement_timestamp | Email engagement timestamp | Email Engagements | The email’s due date. |
contact_owner_email | Contact owner email | Contact owner | Email of contact owner |
contact_owner_first_name | Contact owner first name | Contact owner | First name of contact owner |
contact_owner_last_name | Contact owner last name | Contact owner | Last name of contact owner |
contact_owner_teams_id | Contact owner teams id | Contact owner | Teams ID of contact owner |
contact_owner_teams_membership | Contact owner teams membership | Contact owner | Teams name of contact owner |
contact_owner_teams_name | Contact owner teams name | Contact owner | Teams name of contact owner |
totalCurrentAccounts | Total Current Accounts | Current Total Values | Total Current Accounts |
totalCurrentCampaigns | Total Current Campaigns | Current Total Values | Total Current Campaigns |
totalCurrentContacts | Total Current Contacts | Current Total Values | Total Current Contacts |
totalCurrentDeals | Total Current Deals | Current Total Values | Total Current Deals |
totalCurrentLists | Total Current Lists | Current Total Values | Total Current Lists |
totalCurrentTags | Total Current Tags | Current Total Values | Total Current Tags |
deal_owner_email | Deal owner email | Deal owner | Email of deal owner |
deal_owner_first_name | Deal owner first name | Deal owner | First name of deal owner |
deal_owner_last_name | Deal owner last name | Deal owner | Last name of deal owner |
deal_owner_teams_id | Deal owner teams id | Deal owner | Teams ID of deal owner |
deal_owner_teams_membership | Deal owner teams membership | Deal owner | Teams name of deal owner |
deal_owner_teams_name | Deal owner teams name | Deal owner | Teams name of deal owner |
note_engagement_body | Note engagement body | Notes Engagements | The note’s text content |
note_engagement_id | Note engagement ID | Notes Engagements | The ID of the note. |
note_engagement_owner_id | Note engagement owner ID | Notes Engagements | The 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_timestamp | Note engagement timestamp | Notes Engagements | The note’s time of creation |
deal_analytics_source | Deal original source | Deal analytics history | 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_1 | Deal original source data 1 | Deal analytics history | Additional 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_2 | Deal original source data 2 | Deal analytics history | Additional 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 |
connectedAccountId | Connected Account ID | Account Info | Connected Account ID |
connectedAccountName | Connected Account Name | Account Info | Connected Account Name |
deal_closed_amount | Deal closed amount | Deals calculated information | Returns the amount if the deal is closed. Else, returns 0. |
deal_days_to_close | Deal days to close | Deals calculated information | The time between Create date and Close date |
total_companies | Total companies | Company information | The total companies |
owner_id | Owner ID | Owner | The ID of the owner |