account_url Accounts
Account Url
string created_timestamp Accounts
Created Timestamp
datetime updated_timestamp Accounts
Updated Timestamp
datetime contact_count Accounts
Contact Count
float deal_count Accounts
Deal Count
float links_notes Accounts
Links Notes
string links_account_custom_field_data Accounts
Links Account Custom Field Data
string links_account_contacts Accounts
Links Account Contacts
string links_email_activities Accounts
Links Email Activities
string links_contact_emails Accounts
Links Contact Emails
string links_owner Accounts
Links Owner
string defaultscreenshot Automations
Default Screenshot
string entered Automations
Entered
float screenshot Automations
Screenshot
string campaign Campaign Lists
Campaign
string campaignid Campaign Lists
Campaign ID
string cdate Campaign Lists
Created date
datetime list_amt Campaign Lists
list_amt
string listid Campaign Lists
List ID
string userid Campaign Lists
User ID
string campaign_name Campaign Messages
Campaign name
string campaign Campaign Messages
Campaign
string campaignid Campaign Messages
Campaign ID
string forwards Campaign Messages
Forwards
float hardbounces Campaign Messages
Hardbounces
float initial_split_percentage Campaign Messages
Initial split percentage
float linkclicks Campaign Messages
Link clicks
float message Campaign Messages
Message
string messageid Campaign Messages
Message ID
string opens Campaign Messages
Opens
float percentage Campaign Messages
Percentage
float replies Campaign Messages
Replies
float send_amt Campaign Messages
Send amt
float socialshares Campaign Messages
Social shares
float softbounces Campaign Messages
Softbounces
float sourcesize Campaign Messages
Source size
float spamcheck_max Campaign Messages
Spamcheck max
float spamcheck_score Campaign Messages
Spamcheck score
float subject Campaign Messages
Subject
string subscriberclicks Campaign Messages
Subscriber clicks
float total_amt Campaign Messages
Total amt
float uniqueforwards Campaign Messages
Unique forwards
float uniquelinkclicks Campaign Messages
Unique link clicks
float uniqueopens Campaign Messages
Unique opens
float uniquereplies Campaign Messages
Unique replies
float unsubreasons Campaign Messages
Unsubscribe reasons
float unsubscribes Campaign Messages
Unsubscribes
float updates Campaign Messages
Updates
float segmentid Campaigns
Segment ID
float bounceid Campaigns
Bounce ID
float threadid Campaigns
Thread ID
float seriesid Campaigns
Series ID
float basetemplateid Campaigns
Base template ID
string basemessageid Campaigns
Base message ID
float addressid Campaigns
Address ID
float cdate Campaigns
Created date
datetime send_amt Campaigns
Send amt
float total_amt Campaigns
Total amt
float uniqueopens Campaigns
Unique opens
float linkclicks Campaigns
Link clicks
float uniquelinkclicks Campaigns
Unique link clicks
float subscriberclicks Campaigns
Subscriber clicks
float forwards Campaigns
Forwards
float uniqueforwards Campaigns
Unique forwards
float hardbounces Campaigns
Hard bounces
float softbounces Campaigns
Soft bounces
float unsubscribes Campaigns
Unsubscribes
float unsubreasons Campaigns
Unsubscribe reasons
float socialshares Campaigns
Social shares
float uniquereplies Campaigns
Unique replies
float mail_transfer Campaigns
Mail transfer
float mail_send Campaigns
Mail send
float mail_cleanup Campaigns
Mail cleanup
float mailer_log_file Campaigns
Mailer log file
float tracklinks Campaigns
Track links
string tracklinksanalytics Campaigns
Track links analytics
float trackreads Campaigns
Track reads
float trackreadsanalytics Campaigns
Track reads analytics
float analytics_campaign_name Campaigns
Analytics campaign name
string facebook Campaigns
Facebook
float embed_images Campaigns
Embeded images
float htmlunsub Campaigns
Html unsubscribes
float textunsub Campaigns
Text unsubscribes
float htmlunsubdata Campaigns
Html unsubscribes data
string textunsubdata Campaigns
Text unsubscribes data
string recurring Campaigns
Recurring
string willrecur Campaigns
Will recur
float split_type Campaigns
Split type
string split_content Campaigns
Split content
float split_offset Campaigns
Split offset
float split_offset_type Campaigns
Split offset type
string split_winner_messageid Campaigns
Split winner message ID
float split_winner_awaiting Campaigns
Split winner awaiting
float responder_offset Campaigns
Responder offset
float responder_type Campaigns
Responder type
string responder_existing Campaigns
Responder existing
float reminder_field Campaigns
Reminder field
string reminder_format Campaigns
Reminder format
string reminder_type Campaigns
Reminder type
string reminder_offset Campaigns
Reminder offset
float reminder_offset_type Campaigns
Reminder offset type
string reminder_offset_sign Campaigns
Reminder offset sign
string reminder_last_cron_run Campaigns
Reminder last cron run
string activerss_interval Campaigns
Activerss interval
string activerss_url Campaigns
Activerss URL
string activerss_items Campaigns
Activerss items
float laststep Campaigns
Last step
string managetext Campaigns
Manage text
float schedule Campaigns
Schedule
float scheduleddate Campaigns
Scheduled date
datetime waitpreview Campaigns
Wait preview
float deletestamp Campaigns
Delete stamp
string replysys Campaigns
Reply sys
float automation Campaigns
Automation
string adddate Contact Automations
Add Date
datetime automation Contact Automations
Automation
string batchid Contact Automations
Batch Id
string completeValue Contact Automations
Complete Value
float completed Contact Automations
Completed
float completedElements Contact Automations
Completed Elements
float contact Contact Automations
Contact
string in_als Contact Automations
In Als
float lastblock Contact Automations
Last block
float lastdate Contact Automations
Last Date
datetime lastlogid Contact Automations
Last Log Id
string remdate Contact Automations
Rem date
datetime seriesid Contact Automations
Series ID
string startid Contact Automations
Start ID
string status Contact Automations
Status
float timespan Contact Automations
Timespan
string totalElements Contact Automations
Total Elements
float contact Contact Lists
Contact
string seriesid Contact Lists
Series ID
string status Contact Lists
Status
integer responder Contact Lists
Responder
integer unsubreason Contact Lists
Unsubreason
string campaign Contact Lists
Campaign
string message Contact Lists
Message
string first_name Contact Lists confidencial
First Name
string last_name Contact Lists confidencial
Last Name
string ip4Sub Contact Lists confidencial
Ip4 Sub
string sourceid Contact Lists
Source ID
string autosyncLog Contact Lists
Auto Sync Log
string ip4_last Contact Lists confidencial
Ip4 Last
string ip4Unsub Contact Lists confidencial
Ip4 Unsub
string created_timestamp Contact Lists
Created Timestamp
datetime updated_timestamp Contact Lists
Updated Timestamp
datetime created_by Contact Lists
Created By
string updated_by Contact Lists
Updated By
string unsubscribeAutomation Contact Lists
Unsubscribe Automation
string links_automation Contact Lists
Links Automation
string links_list Contact Lists
Links List
string links_contact Contact Lists
Links Contact
string links_form Contact Lists
Links Form
string links_autosyncLog Contact Lists
Links Auto Sync Log
string links_campaign Contact Lists
Links Campaign
string links_unsubscribeAutomation Contact Lists
Links Unsubscribe Automation
string links_message Contact Lists
Links Message
string automation Contact Lists
Automation
string cdate Contact tags
Creation date
datetime contact Contact tags
Contact
string created_by Contact tags
Created by
string created_timestamp Contact tags
Created timestamp
datetime updated_by Contact tags
Updated by
string updated_timestamp Contact tags
Updated timestamp
datetime email Contacts confidencial
Email
string phone Contacts confidencial
Phone
string name Contacts confidencial
Name
string cdate Contacts
Created date
datetime firstName Contacts confidencial
First Name
string lastName Contacts confidencial
Last Name
string segmentio_id Contacts
Segmentio ID
string bounced_hard Contacts
Bounced hard
float bounced_soft Contacts
Bounced soft
float bounced_date Contacts
Bounced date
datetime ip Contacts confidencial
IP
float email_local Contacts confidencial
Email local
string email_domain Contacts
Email domain
string sentcnt Contacts
Sent count
float organization Contacts
Organization
string udate Contacts
Updated date
datetime id Custom contact field values
ID
string cdate Custom contact field values
Creation date
datetime contact Custom contact field values
Contact
string created_by Custom contact field values
Created by
string field Custom contact field values
Field
string owner Custom contact field values
Owner
string udate Custom contact field values
Updated date
datetime updated_by Custom contact field values
Updated by
string value Custom contact field values
Value
string id Custom contact fields
ID
string cols Custom contact fields
Cols
float created_by Custom contact fields
Created by
string created_timestamp Custom contact fields
Created timestamp
datetime default_value Custom contact fields
Default value
string description Custom contact fields
Description
string isrequired Custom contact fields
Is required
float ordernum Custom contact fields
Order number
float perstag Custom contact fields
Perstag
string rows Custom contact fields
Rows
float service Custom contact fields
Service
string show_in_list Custom contact fields
Show in list
float title Custom contact fields
Title
string type Custom contact fields
Type
string updated_by Custom contact fields
Updated by
string updated_timestamp Custom contact fields
Updated timestamp
datetime visible Custom contact fields
Visible
float id Deal Custom Field Values
ID
string createdTimestamp Deal Custom Field Values
Created Time Stamp
datetime customFieldId Deal Custom Field Values
Custom Field ID
string dealCustomFieldMetumId Deal Custom Field Values
Deal Custom Field Metum ID
string dealId Deal Custom Field Values
Deal ID
string fieldValue Deal Custom Field Values
Field Value
string linksDeal Deal Custom Field Values
Links Deal
string linksDealCustomFieldMetum Deal Custom Field Values
Links Deal Custom Field Metum
string updatedTimestamp Deal Custom Field Values
Updated Time Stamp
datetime organization Deal Lists
Organization
string description Deal Lists
Description
string nextdate Deal Lists
Next Date
datetime nexttaskid Deal Lists
Next Task ID
string currency Deal Lists
Currency
string winProbability Deal Lists
Win Probability
float winProbabilityMdate Deal Lists
Win Probability M-date
datetime activitycount Deal Lists
Activity Count
string nextdealid Deal Lists
Next Deal ID
string assigned_date Deal Tasks
Assigned Date
datetime assignee Deal Tasks
Assignee
string automation Deal Tasks
Automation
string created_utc_timestamp Deal Tasks
Created Utc Timestamp
datetime dealTasktype Deal Tasks
Deal Task Type
string doneAutomation Deal Tasks
Done Automation
string done_utc_timestamp Deal Tasks
Done Utc Timestamp
datetime donedate Deal Tasks
Done Date
datetime duedate Deal Tasks
Due Date
datetime duration Deal Tasks
Duration
float links_activities Deal Tasks
Links Activities
string links_assignee Deal Tasks
Links Assignee
string links_automation Deal Tasks
Links Automation
string links_dealTasktype Deal Tasks
Links Deal Task Type
string links_doneAutomation Deal Tasks
Links Done Automation
string links_notes Deal Tasks
Links Notes
string links_owner Deal Tasks
Links Owner
string links_taskNotifications Deal Tasks
Links Task Notifications
string links_taskOutcome Deal Tasks
Links Task Outcome
string links_updatedBy Deal Tasks
Links Updated By
string links_user Deal Tasks
Links User
string outcomeId Deal Tasks
Outcome ID
string outcomeInfo Deal Tasks
Outcome Info
string owner_id Deal Tasks
Owner ID
string owner_type Deal Tasks
Owner Type
string relTitle Deal Tasks
Rel Title
string reltype Deal Tasks
Rel Type
string taskOutcome Deal Tasks
Task Outcome
string triggerAutomationOnCreate Deal Tasks
Trigger Automation On Create
float updatedBy Deal Tasks
Updated By
string updated_utc_timestamp Deal Tasks
Updated Utc Timestamp
datetime subscriberid Email Activities
Subscriber ID
string userid Email Activities
User ID
string account Email Activities
Account
string reltype Email Activities
Rel type
string relid Email Activities
Rel ID
float from_name Email Activities confidencial
From Name
string fromAddress Email Activities confidencial
From Address
string toAddress Email Activities confidencial
To Address
string ccAddress Email Activities confidencial
Cc Address
string subject Email Activities confidencial
Subject
string message Email Activities confidencial
Message
string messageHtml Email Activities confidencial
Message Html
string tstamp Email Activities
Tstamp
datetime sentiment Email Activities
Sentiment
string series_id Email Activities
Series ID
string subscriber_series_id Email Activities
Subscriber Series ID
string automation_name Email Activities
Automation Name
string service_provider Email Activities
Service Provider
string links_contact Email Activities
Links Contact
string links_deal Email Activities
Links Deal
string links_user Email Activities
Links User
string links_reference Email Activities
Links Reference
string links_account Email Activities
Links Account
string contact Email Activities
Contact
string reference_type Email Activities
Reference Type
string reference_id Email Activities
Reference ID
float unsubscribelink Groups
Unsubscribelink
string optinconfirm Groups
Optinconfirm
string pgListEdit Groups
PgListEdit
float pgListDelete Groups
PgListDelete
float pgListHeaders Groups
PgListHeaders
float pgListEmailaccount Groups
PgListEmailaccount
float pgListBounce Groups
PgListBounce
float pgMessageAdd Groups
PgMessageAdd
float pgMessageEdit Groups
PgMessageEdit
float pgMessageDelete Groups
PgMessageDelete
float pgMessageSend Groups
PgMessageSend
float pgContactAdd Groups
PgContactAdd
float pgContactEdit Groups
PgContactEdit
float pgContactDelete Groups
PgContactDelete
float pgContactMerge Groups
PgContactMerge
float pgContactImport Groups
PgContactImport
float pgContactApprove Groups
PgContactApprove
float pgContactExport Groups
PgContactExport
float pgContactSync Groups
PgContactSync
float pgContactFilters Groups
PgContactFilters
float pgContactActions Groups
PgContactActions
float pgContactFields Groups
PgContactFields
float pg_user_add Groups
Pg_user_add
float pg_user_edit Groups
Pg_user_edit
float pg_user_delete Groups
Pg_user_delete
float pgGroupAdd Groups
PgGroupAdd
float pgGroupEdit Groups
PgGroupEdit
float pgGroupDelete Groups
PgGroupDelete
float pgTemplateAdd Groups
PgTemplateAdd
float pgTemplateEdit Groups
PgTemplateEdit
float pgTemplateDelete Groups
PgTemplateDelete
float pgPersonalizationAdd Groups
PgPersonalizationAdd
float pgPersonalizationEdit Groups
PgPersonalizationEdit
float pgPersonalizationDelete Groups
PgPersonalizationDelete
float pgAutomationManage Groups
PgAutomationManage
float pgFormEdit Groups
PgFormEdit
float pgReportsCampaign Groups
PgReportsCampaign
float pgReportsList Groups
PgReportsList
float pgReportsUser Groups
PgReportsUser
float pgReportsTrend Groups
PgReportsTrend
float pgReportsDeal Groups
pgReportsDeal
string pgStartupReports Groups
PgStartupReports
float pgStartupGettingstarted Groups
PgStartupGettingstarted
float pgAccountAdd Groups
pgAccountAdd
string pgAccountEdit Groups
pgAccountEdit
string pgAccountDelete Groups
pgAccountDelete
string pgAccountManageCustomField Groups
pgAccountManageCustomField
string pgDealDelete Groups
PgDealDelete
float pgDealReassign Groups
PgDealReassign
float pgDealFields Groups
pgDealFields
string pgDealGroupAdd Groups
PgDealGroupAdd
float pgDealGroupEdit Groups
PgDealGroupEdit
float pgDealGroupDelete Groups
PgDealGroupDelete
float pgSavedResponsesManage Groups
PgSavedResponsesManage
float reqApproval Groups
ReqApproval
float reqApproval1st Groups
reqApproval1st
string reqApprovalNotify Groups
ReqApprovalNotify
string socialdata Groups
Socialdata
float pgMfaAdmin Groups
pgMfaAdmin
string pgDealExport Groups
pgDealExport
string pgDealManageRoles Groups
pgDealManageRoles
string pgAccountNoteAdd Groups
pgAccountNoteAdd
string pgAccountNoteEdit Groups
pgAccountNoteEdit
string pgAccountNoteDelete Groups
pgAccountNoteDelete
string pgDealNoteAdd Groups
pgDealNoteAdd
string pgDealNoteEdit Groups
pgDealNoteEdit
string pgDealNoteDelete Groups
pgDealNoteDelete
string pgDealListAll Groups
pgDealListAll
string pgTagManage Groups
pgTagManage
string pgContactResubscribe Groups
pgContactResubscribe
string pgDealImport Groups
pgDealImport
string pgAccountImport Groups
pgAccountImport
string pgAccountExport Groups
pgAccountExport
string pgLandingPagesAccess Groups
pgLandingPagesAccess
string pg_web_personalization_manage Groups
pg_web_personalization_manage
string pgAccountReassign Groups
pgAccountReassign
string links_userGroups Groups
Links UserGroups
string links_groupLimit Groups
Links groupLimit
string links_dealGroupGroups Groups
Links dealGroupGroups
string links_listGroups Groups
Links listGroups
string links_addressGroups Groups
Links addressGroups
string links_automationGroups Groups
Links automationGroups
string p_use_tracking Lists
P use tracking
float p_use_analytics_read Lists
P use analytics read
float p_use_analytics_link Lists
P use analytics link
float p_use_twitter Lists
P use twitter
float p_use_facebook Lists
P use facebook
float p_embed_image Lists
P embed image
float p_use_captcha Lists
P use captcha
float send_last_broadcast Lists
Send last broadcast
float analytics_domains Lists
Analytics domains
string analytics_source Lists
Analytics source
string analytics_ua Lists
Analytics UA
string twitter_token Lists
Twitter token
string twitter_token_secret Lists
Twitter token secret
string facebook_session Lists
Facebook session
string carboncopy Lists
Carboncopy
string subscription_notify Lists
Subscription notify
string unsubscription_notify Lists
Unsubscription Notify
string require_name Lists
Require name
float get_unsubscribe_reason Lists
Get unsubscribe reason
float optinoptout Lists
Opt in optout conf
string sender_name Lists
Sender name
string sender_addr1 Lists
Sender address line 1
string sender_addr2 Lists
Sender address line 2
string sender_city Lists
Sender city
string sender_state Lists
Sender state
string sender_zip Lists
Sender zip
string sender_country Lists
Sender country
string sender_phone Lists confidencial
Sender phone
string sender_url Lists
Sender URL
string sender_reminder Lists
Sender Reminder
string fulladdress Lists
Full address
string optinmessageid Lists
Opt in message ID
float optoutconf Lists
Opt out conf
float deletestamp Lists
Delete stamp
string created_timestamp Lists
Created Timestamp
datetime updated_timestamp Lists
Updated Timestamp
datetime created_by Lists
Created By
string updated_by Lists
Updated By
string links_contactGoalLists Lists
Links Contact Goal Lists
string links_user Lists
Links User
string links_addressLists Lists
Links Address Lists
string ed_instanceid Messages
ed Instance ID
float ed_version Messages
ed Version
float fromname Messages confidencial
From Name
string fromemail Messages confidencial
From Email
string preheader_text Messages
Preheader Text
string html Messages confidencial
Html
string htmlfetch Messages
Html Fetch
string textfetch Messages
Text Fetch
string preview_mime Messages
Preview Mime
string preview_data Messages
Preview Data
string has_predictive_content Messages
Has Predictive Content
float links_user Messages
Links User
string links_hyperlinks Messages
Links Hyperlinks
string allgroups Pipeline Lists
All Groups
string allusers Pipeline Lists
All Users
string autoassign Pipeline Lists
Auto Assign
string currency Pipeline Lists
Currency
string linksScoreCalcHistory Scores
Links scoreCalcHistory
string cardRegion1 Stages Lists
Card Region 1
string cardRegion2 Stages Lists
Card Region 2
string cardRegion3 Stages Lists
Card Region 3
string cardRegion4 Stages Lists
Card Region 4
string cardRegion5 Stages Lists
Card Region 5
string dealOrder Stages Lists
Deal Order
string created_timestamp Tags
Created timestamp
datetime description Tags
Description
string subscriber_count Tags
Subscriber count
float updated_timestamp Tags
Updated timestamp
datetime tasktype_id Task Type - Outcome Relations
Task Type ID
string outcome_id Task Type - Outcome Relations
Outcome ID
string display_order Task Type - Outcome Relations
Display Order
float created_by Task Type - Outcome Relations
Created By
string created_utc_timestamp Task Type - Outcome Relations
Created UTC Timestamp
datetime updated_by Task Type - Outcome Relations
Updated By
string updated_utc_timestamp Task Type - Outcome Relations
Updated UTC Timestamp
datetime links_tasktype Task Type - Outcome Relations
Links Task Type
string links_outcome Task Type - Outcome Relations
Links Outcome
string links_createdBy Task Type - Outcome Relations
Links Created By
string id Task Type - Outcome Relations
ID
string tasktype Task Type - Outcome Relations
Task Type
string outcome Task Type - Outcome Relations
Outcome
string dealTasktype_ids Tasks - Outcomes
Dealtasktype ID
string title Tasks - Outcomes
Title
string sentiment Tasks - Outcomes
Sentiment
string disabled Tasks - Outcomes
Disabled
float created_by Tasks - Outcomes
Created By
float updated_by Tasks - Outcomes
Updated By
float created_utc_timestamp Tasks - Outcomes
Created UTC Timestamp
datetime updated_utc_timestamp Tasks - Outcomes
Updated UTC Timestamp
datetime links_tasktypeOutcomeRels Tasks - Outcomes
Links Task Type Outcome Rels
string links_dealTasks Tasks - Outcomes
Links Deal Tasks
string defduration Tasks - Types
Defduration
float status Tasks - Types
Status
float created_by Tasks - Types
Created By
string updated_by Tasks - Types
Updated By
string created_utc_timestamp Tasks - Types
Created UTC Timestamp
datetime updated_utc_timestamp Tasks - Types
Updated UTC Timestamp
datetime display_order Tasks - Types
Display Order
float links_dealTasks Tasks - Types
Links Deal Tasks
string links_tasktypeOutcomeRels Tasks - Types
Links Task Type Outcome Rels
string firstName Users confidencial
First Name
string lastName Users confidencial
Last Name
string email Users confidencial
Email
string phone Users confidencial
Phone
string signature Users confidencial
Signature
string localZoneid Users
Local Zone ID
string mfaEnabled Users
mfaEnabled
float links_lists Users
Links Lists
string links_userGroup Users
Links User Group
string links_dealGroupTotals Users
Links Deal Group Totals
string links_dealGroupUsers Users
Links Deal Group Users
string links_configs Users
Links Configs
string links_dealConnection Users
Links Deal Connection
string links_userConversationsPermission Users
Links User Conversations Permission
string links_seatUser Users
Links Seat User
string