Find the fields you need for your next report.
This connector can discover additional fields after you connect your account. Availability depends on your account and configuration; these fields are not included in the listing or counts below.
229 fields
| Field | Details |
|---|---|
Automation Created Date Automation created date. | Field IDautomations.cdate |
Automation Default Screenshot Automation defult screenshot. | Field IDautomations.defaultscreenshot |
Automation Entered Automation entered. | Field IDautomations.entered |
Automation Exited Automation exited. | Field IDautomations.exited |
Automation Hidden Automation hidden. | Field IDautomations.hidden |
Automation Id Automation id. | Field IDautomations.id |
Automation Name Automation name. | Field IDautomations.name |
Automation Screenshot Automation screenshot. | Field IDautomations.screenshot |
Automation Status Automation status. | Field IDautomations.status |
Automation Updated Date Automation update date. | Field IDautomations.mdate |
Automation User Id Automation user id. | Field IDautomations.userid |
Campaign Active RSS Interval If this is an activerss-type campaign, how often it checks for new feed items. Same options as for recurring mailings. Example: 'day1' | Field IDcampaigns.activerss_interval |
Campaign Active RSS Items The number of RSS items to display in the campaign. | Field IDcampaigns.activerss_items |
Campaign Active RSS Url The RSS URL used to check for new feed items that get inserted into the campaign. | Field IDcampaigns.activerss_url |
Campaign Address Id Address ID used for the campaign. | Field IDcampaigns.addressid |
Campaign Analytics Campaign Name The Google Analytics campaign name (used for organizing within Google Analytics). | Field IDcampaigns.analytics_campaign_name |
Campaign Automation Campaign automation. | Field IDcampaigns.automation |
Campaign Base Message Id Internal message ID used for the campaign. | Field IDcampaigns.basemessageid |
Campaign Base Template Id Campaign basetemplate id. | Field IDcampaigns.basetemplateid |
Campaign Bounce Id Campaign bounce id. | Field IDcampaigns.bounceid |
Campaign Clicks Rate Campaign Clicks Rate | Field IDcampaigns.click_rate |
Campaign Created Date Date the campaign was initially created. Example: 2015-11-01 15:34:28 | Field IDcampaigns.cdate |
Campaign Delete Stamp Campaign. | Field IDcampaigns.deletestamp |
Campaign Embed Images Campaign. | Field IDcampaigns.embed_images |
Campaign Facebook Whether or not this campaign auto-posted to Facebook. Possible values: Yes, No. | Field IDcampaigns.facebook |
Campaign Form Id Template used to create the campaign. | Field IDcampaigns.formid |
Campaign Forwards Count Total amount of forwards (via the %FORWARD2FRIEND% personalization link only) for this campaign (including multiple forwards initiated by the same contact). | Field IDcampaigns.forwards |
Campaign Hard Bounces Count Total number of hard bounces for this campaign. | Field IDcampaigns.hardbounces |
Campaign HTML Unsub Campaign HTML unsub. | Field IDcampaigns.htmlunsub |
Campaign HTML Unsub Data Campaign HTML unsub data. | Field IDcampaigns.htmlunsubdata |
Campaign Id ID of the campaign. | Field IDcampaigns.id |
Campaign IP4 Campaign IP4. | Field IDcampaigns.ip4 |
Campaign Last Step The last step of the campaign process saved. Example: 'summary' | Field IDcampaigns.laststep |
Campaign Link Clicks Count Total amount of link clicks for this campaign (including multiple link clicks by the same contact). | Field IDcampaigns.linkclicks |
Campaign Mail Cleanup Campaign mail cleaner. | Field IDcampaigns.mail_cleanup |
Campaign Mail Send Campaign mail send. | Field IDcampaigns.mail_send |
Campaign Mail Transfer Campaign mail transfer. | Field IDcampaigns.mail_transfer |
Campaign Mailer Log File Campaign mailer log file. | Field IDcampaigns.mailer_log_file |
Campaign Manage Text Campaign manage text. | Field IDcampaigns.managetext |
Campaign Modification Date Date the campaign was last modified. Example: 2015-11-01 15:38:28 | Field IDcampaigns.mdate |
Campaign Name Internal name of the campaign. | Field IDcampaigns.name |
Campaign open rate Campaign Open Unique rate | Field IDcampaigns.open_unique_rate |
Campaign Open Rate Campaign Open Rate | Field IDcampaigns.open_rate |
Campaign Opens Count Total amount of opens for this campaign (including multiple opens by the same contact). | Field IDcampaigns.opens |
Campaign Public Campaign public. | Field IDcampaigns.public |
Campaign Real CID Campaign real CID. | Field IDcampaigns.realcid |
Campaign Receive Count Total amount of contacts determined to receive this campaign. | Field IDcampaigns.total_amt |
Campaign Recurring If this is a recurring campaign, how often it repeats. Possible values: day1, day2, week1, week2, month1, month2, quarter1, quarter2, year1, year2. Values ending with 1 mean "every", and ending with 2 mean "every other. | Field IDcampaigns.recurring |
Campaign Reminder Field If this is an auto-reminder (subscriber date-based) type campaign, what contact field to look at. Possible values: 'cdate', 'sdate', 'udate', or an ID of a Date-type custom field. | Field IDcampaigns.reminder_field |
Campaign Reminder Format If this is an auto-reminder (subscriber date-based) type campaign, the format in which the date is represented in above contact field. Example: 'yyyy-mm-dd' | Field IDcampaigns.reminder_format |
Campaign Reminder Last Cron Run Campaign reminder last cron run. | Field IDcampaigns.reminder_last_cron_run |
Campaign Reminder Offset If this is an auto-reminder (subscriber date-based) type campaign, how many days/weeks/months/years from that date should it trigger. Example: 5 | Field IDcampaigns.reminder_offset |
Campaign Reminder Offset Sign If this is an auto-reminder (subscriber date-based) type campaign. Possible values: + and - | Field IDcampaigns.reminder_offset_sign |
Campaign Reminder Offset Type If this is an auto-reminder (subscriber date-based) type campaign. Possible values: 'day', 'week', 'month', 'year'. | Field IDcampaigns.reminder_offset_type |
Campaign Reminder Type If this is an auto-reminder (subscriber date-based) type campaign, match just a month and the day (yearly), or match year as well. Possible values: 'month_day', 'year_month_day'. | Field IDcampaigns.reminder_type |
Campaign Replies Count Total number of replies for this campaign (including multiple replies by the same contact). | Field IDcampaigns.replies |
Campaign Reply Sys Whether or not reply tracking is enabled for this campaign. Possible values: Yes, No | Field IDcampaigns.replysys |
Campaign Responder Existing Campaign responder existing. | Field IDcampaigns.responder_existing |
Campaign Responder Offset If this is an auto-responder type campaign, how many hours after subscription to send it. Example: 2 | Field IDcampaigns.responder_offset |
Campaign Responder Type Campaign responder type. | Field IDcampaigns.responder_type |
Campaign Schedule Whether or not this campaign is scheduled to send at a later date/time. | Field IDcampaigns.schedule |
Campaign Schedule Date The date the campaign is scheduled to send. | Field IDcampaigns.scheduleddate |
Campaign Segment Id Campaign segment id. | Field IDcampaigns.segmentid |
Campaign Send Count Total amount of contacts actually sent this campaign. | Field IDcampaigns.send_amt |
Campaign Send Date Date the campaign started sending. Example: 2015-11-01 15:45:28 | Field IDcampaigns.sdate |
Campaign Send Id Campaign send id. | Field IDcampaigns.sendid |
Campaign Series Id Automation ID that this campaign is associated with. | Field IDcampaigns.seriesid |
Campaign Social Shares Count Total number of social shares conducted for this campaign. | Field IDcampaigns.socialshares |
Campaign Soft Bounces Count Total number of soft bounces for this campaign. | Field IDcampaigns.softbounces |
Campaign Source How the campaign was created. Possible value: 'web', 'api', 'copy', 'recurr', 'system' | Field IDcampaigns.source |
Campaign Split Content Campaign split content. | Field IDcampaigns.split_content |
Campaign Split Offset If this is a split-type campaign, the number of units to wait before determining the winner. Example: 2 | Field IDcampaigns.split_offset |
Campaign Split Offset Type If this is a split-type campaign, the type of unit to wait before determining the winner. Possible values: 'hour', 'day', 'week', 'month'. | Field IDcampaigns.split_offset_type |
Campaign Split Type If this is a split-type campaign, the type of split mailing. Example: 'even' (send each message to even number of contacts). Possible values: 'even', 'read', 'click'. If 'read' or 'click' is used, 'split_offset' and 'split_offset_type' need to be present. In that case it will use a "winner" scenario. | Field IDcampaigns.split_type |
Campaign Split Winner Awaiting Whether or not a winner is still being determined. Possible values: Yes, No | Field IDcampaigns.split_winner_awaiting |
Campaign Split Winner Message Id The winning message ID. | Field IDcampaigns.split_winner_messageid |
Campaign Status Status of this campaign. Possible values: Draft, Scheduled, Sending, Paused, Stopped, Completed, Disabled, Pending Approval | Field IDcampaigns.status |
Campaign Subscriber Clicks Count Total amount of distinct (unique) contacts that clicked a link for this campaign. | Field IDcampaigns.subscriberclicks |
Campaign Survey The unique ID from the SurveyMonkey personalization tag, which is the URL ID for the survey. | Field IDcampaigns.survey |
Campaign Text Unsub Campaign text unsub. | Field IDcampaigns.textunsub |
Campaign Text Unsub Data Campaign text unsub data. | Field IDcampaigns.textunsubdata |
Campaign Thread Id Campaign thread id. | Field IDcampaigns.threadid |
Campaign Track Links Type of link tracking enabled for the campaign. Possible values: 'all', 'mime', 'html', 'text', 'none' | Field IDcampaigns.tracklinks |
Campaign Track Links Analytics Whether or not Google Analytics link tracking is enabled. Possible values: Yes, No | Field IDcampaigns.tracklinksanalytics |
Campaign Track Reads Whether or not read/open tracking is enabled for this campaign. Possible values: Yes, No | Field IDcampaigns.trackreads |
Campaign Track Reads Analytics Whether or not Google Analytics link tracking is enabled. Possible values: Yes, No | Field IDcampaigns.trackreadsanalytics |
Campaign Tweet Whether or not this campaign auto-posted to Twitter. Possible values: Yes, No | Field IDcampaigns.tweet |
Campaign Type Campaign type. | Field IDcampaigns.type |
Campaign Unique Clicks Rate Campaign Unique Clicks Rate | Field IDcampaigns.click_unique_rate |
Campaign Unique Forwards Count Total amount of distinct (unique) contacts that forwarded this campaign (via the %FORWARD2FRIEND% personalization link only). | Field IDcampaigns.uniqueforwards |
Campaign Unique Link Clicks Count Total amount of distinct (unique) links clicked for this campaign. | Field IDcampaigns.uniquelinkclicks |
Campaign Unique Opens Count Total amount of distinct (unique) contacts that opened this campaign. | Field IDcampaigns.uniqueopens |
Campaign Unique Replies Count Total number of distinct (unique) contacts that replied to this campaign. | Field IDcampaigns.uniquereplies |
Campaign Unsubscribe Reasons Count Total number of unsubscribe reasons provided for unsubscriptions for this campaign. | Field IDcampaigns.unsubreasons |
Campaign Unsubscribes Count Total number of unsubscribes for this campaign. | Field IDcampaigns.unsubscribes |
Campaign Updates Count Total number of contacts that updated their profile via this campaign (using the %UPDATELINK% personalization tag). | Field IDcampaigns.updates |
Campaign User Campaign user. | Field IDcampaigns.user |
Campaign User Id Campaign user id. | Field IDcampaigns.userid |
Campaign Wait Preview Campaign wait preview. | Field IDcampaigns.waitpreview |
Campaign Will Recur Campaign will recur. | Field IDcampaigns.willrecur |
Contact Add Date Contact adate. | Field IDcontacts.adate |
Contact Bounced Date Date of most recent bounce for this contact. | Field IDcontacts.bounced_date |
Contact Bounced Hard Number of times this contact has hard-bounced. Example: 0. | Field IDcontacts.bounced_hard |
Contact Bounced Soft Number of times this contact has soft-bounced. Example: 0 | Field IDcontacts.bounced_soft |
Contact Creation Date The date the contact has been created. | Field IDcontacts.cdate |
Contact Deleted Contact deleted. | Field IDcontacts.deleted |
Contact Edit Date Contact edate. | Field IDcontacts.edate |
Contact Email The contact email. | Field IDcontacts.email |
Contact Email Domain Contact email domain. | Field IDcontacts.email_domain |
Contact Email local Contact email local. | Field IDcontacts.email_local |
Contact First Name The first name of the contact. | Field IDcontacts.firstName |
Contact Gravatar Contact gravatar. | Field IDcontacts.gravatar |
Contact Hash Contact hash. | Field IDcontacts.hash |
Contact Id Id of the Contact. | Field IDcontacts.id |
Contact IP IP address of the contact. Example: 38.104.242.98 | Field IDcontacts.ip |
Contact Last Check Last time social data was fetched for this contact.. | Field IDcontacts.socialdata_lastcheck |
Contact Last Name the last name of the contact. | Field IDcontacts.lastName |
Contact Message Sent Count Contact sentcnt. | Field IDcontacts.sentcnt |
Contact Organisation Id The contact organisation id. | Field IDcontacts.orgid |
Contact Organization Contact organization. | Field IDcontacts.organization |
Contact Phone The contact phone. | Field IDcontacts.phone |
Contact Rating Time Contact rating_tstamp. | Field IDcontacts.rating_tstamp |
Contact Segment.io Id The Segment.id id of the contact. | Field IDcontacts.segmentio_id |
Contact UA Contact UA. | Field IDcontacts.ua |
Contact Unsubscribe Date Contact unsubscribe date. | Field IDcontacts.udate |
Date Year, month, and day. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY |
Day of the month Day of the year | Field ID_NORMALIZED_DATE_FIELD_DAY |
Day of the week Week of the year | Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK |
Deal Contact ID Deal Contact ID | Field IDdeals.contact_id |
Deal Created Date Deal Created Date | Field IDdeals.cdate |
Deal Currency Deal Currency | Field IDdeals.currency |
Deal Description Deal Description | Field IDdeals.description |
Deal ID Deal ID | Field IDdeals.id |
Deal Owner Email Deal Owner Email | Field IDdeals.owner_email |
Deal Owner First Name Deal Owner First Name | Field IDdeals.owner_first_name |
Deal Owner ID Deal Owner ID | Field IDdeals.owner_id |
Deal Owner Last Name Deal Owner Last Name | Field IDdeals.owner_last_name |
Deal Percent Deal Percent | Field IDdeals.percent |
Deal Pipeline ID Deal Pipeline ID | Field IDdeals.pipeline_id |
Deal Pipeline Title Deal Pipeline Title | Field IDdeals.pipeline_title |
Deal Stage Id Deal Stage Id | Field IDdeals.stage_id |
Deal Stage Name Deal Stage Name | Field IDdeals.stage_name |
Deal Status ID Deal Status ID | Field IDdeals.status_id |
Deal Status Name Deal Status Name | Field IDdeals.status_name |
Deal Title Deal Title | Field IDdeals.title |
Deal Updated Date Deal Updated Date | Field IDdeals.mdate |
Deal Value Deal Value | Field IDdeals.value |
Deal Win Probability Deal Win Probability | Field IDdeals.winProbability |
Hour of the day Hour of the day | Field ID_NORMALIZED_DATE_FIELD_HOUR |
List Analytics Domain List anaytics domain. | Field IDlists.analytics_domain |
List Analytics Source List analytics source. | Field IDlists.analytics_source |
List Analytics UA List analytics ua. | Field IDlists.analytics_ua |
List Carbon Copy Additional email addresses that campaigns for this list are sent to. | Field IDlists.carboncopy |
List Created Date Date/time the list was created. Example: 2011-03-02 14:46:40 | Field IDlists.cdate |
List Delete Stamp List deletestamp. | Field IDlists.deletestamp |
List Embed Image Whether or not to embed images for campaigns send to this list. Examples: yes, no | Field IDlists.p_embed_image |
List Facebook Session The Facebook session used to send updates to your Facebook account. | Field IDlists.facebook_session |
List Full Address List full address. | Field IDlists.fulladdress |
List Get Unsubscribe Reason Whether or not to ask for a reason when contacts UNsubscribe. Examples: yes, no | Field IDlists.get_unsubscribe_reason |
List Id List id. | Field IDlists.id |
List Name Internal name of list. Example: General List. | Field IDlists.name |
List Optin Message Id List optinmessageid. | Field IDlists.optinmessageid |
List P Use Tracking List. | Field IDlists.p_use_tracking |
List Private Whether or not this list is private (not visible on public side). Examples: yes, no | Field IDlists.private |
List Require Name Whether or not to require a name when subscribing to this list. Examples: yes, no | Field IDlists.require_name |
List Send Last Broadcast Whether or not to send last broadcast message to new contacts of this list. Examples: yes, no | Field IDlists.send_last_broadcast |
List Sender Address 1 Sender's Contact Information. | Field IDlists.sender_addr1 |
List Sender Address 2 Sender's Contact Information. | Field IDlists.sender_addr2 |
List Sender City Sender's Contact Information. | Field IDlists.sender_city |
List Sender Country Sender's Contact Information. | Field IDlists.sender_country |
List Sender Name Sender's Contact Information. | Field IDlists.sender_name |
List Sender Phone Sender's Contact Information. | Field IDlists.sender_phone |
List Sender Reminder Sender's Contact Information. | Field IDlists.sender_reminder |
List Sender State Sender's Contact Information. | Field IDlists.sender_state |
List Sender URL Sender's Contact Information. | Field IDlists.sender_url |
List Sender Zip Sender's Contact Information. | Field IDlists.sender_zip |
List String Id URL-friendly name of list. Example: general-list | Field IDlists.stringid |
List Subscription Notify Whenever a contact subscribes to this list, an email gets sent to this address. | Field IDlists.subscription_notify |
List To Name Default contact name (used when contact has not entered a name). Example: Recipient | Field IDlists.to_name |
List Twitter Token The Twitter token used to send updates to your Twitter account. | Field IDlists.twitter_token |
List Twitter Token Secret The Twitter token secret used to send updates to your Twitter account. | Field IDlists.twitter_token_secret |
List Unsubscription Notify Whenever a contact UNsubscribes to this list, an email gets sent to this address. | Field IDlists.unsubscription_notify |
List Update List update. | Field IDlists.update |
List Use Analytics Link List use analytics link. | Field IDlists.p_use_analytics_link |
List Use Analytics Read List use anaytics reads. | Field IDlists.p_use_analytics_read |
List Use Captcha Whether or not to use captcha image verification when subscribing to this list. Examples: yes, no | Field IDlists.p_use_captcha |
List Use Facebook Whether or not to use Facebook campaign auto-sharing. Examples: yes, no | Field IDlists.p_use_facebook |
List Use Twitter Whether or not to use Twitter campaign auto-sharing. Examples: yes, no | Field IDlists.p_use_twitter |
List User List user. | Field IDlists.user |
List User Id User ID who created this list. Example: 1 | Field IDlists.userid |
Message Charset Message charset. | Field IDmessages.charset |
Message Created Date Message created date. | Field IDmessages.cdate |
Message Ed Instance Id Message ed instance id. | Field IDmessages.ed_instanceid |
Message Ed Version Message ed version. | Field IDmessages.ed_version |
Message Encoding Message encoding. | Field IDmessages.encoding |
Message Format Message format. | Field IDmessages.format |
Message From Mail Message from mail. | Field IDmessages.fromemail |
Message From Name Message from name. | Field IDmessages.fromname |
Message Hidden Message hidden. | Field IDmessages.hidden |
Message HTML Message HTML. | Field IDmessages.html |
Message HTML Fetch Message HTML fetch. | Field IDmessages.htmlfetch |
Message Id Message id. | Field IDmessages.id |
Message Name Message name. | Field IDmessages.name |
Message Preheader Text Message preheader text. | Field IDmessages.preheader_text |
Message Preview Data Message preview data. | Field IDmessages.preview_data |
Message Preview MIME Message preview MIME. | Field IDmessages.preview_mime |
Message Priority Message priority. | Field IDmessages.priority |
Message Reply2 Message reply2. | Field IDmessages.reply2 |
Message Subject Message subject. | Field IDmessages.subject |
Message Text Message text. | Field IDmessages.text |
Message Text Fetch Message text fetch. | Field IDmessages.textfetch |
Message Updated Date Message update date. | Field IDmessages.mdate |
Message User Message User. | Field IDmessages.user |
Message User Id Message user id. | Field IDmessages.userid |
Month and day Month and day | Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY |
Month of the year Month of the year | Field ID_NORMALIZED_DATE_FIELD_MONTH |
Quarter of the year Quarter of the year | Field ID_NORMALIZED_DATE_FIELD_QUARTER |
Task ID Task ID | Field IDdealTasks.id |
Task Note Task Note | Field IDdealTasks.note |
Task Status ID Task Status ID | Field IDdealTasks.status_id |
Task Title Task Titl | Field IDdealTasks.title |
Task Type Task Type | Field IDdealTasks.type |
Week of the year Week of the year | Field ID_NORMALIZED_DATE_FIELD_WEEK |
Week of the year (start Sunday) Week of the year | Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY |
Year Year such as 2017. | Field ID_NORMALIZED_DATE_FIELD_YEAR |
Year month Year and month. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH |
Year month day hour Year, month, day, and hour. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR |
Year Quarter Year and quarter. | Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER |
Year week Year and week. | Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK |
Try another search or reset your filters.