Introduction

Datasources and destinations

Fields listing for ActiveCampaign

Contact Creation Date
The date the contact has been created.
Field IDcontacts.cdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Email
The contact email.
Field IDcontacts.email
TypeTEXT
Data Typedimension
Contact Phone
The contact phone.
Field IDcontacts.phone
TypeTEXT
Data Typedimension
Contact First Name
The first name of the contact.
Field IDcontacts.firstName
TypeTEXT
Data Typedimension
Contact Last Name
the last name of the contact.
Field IDcontacts.lastName
TypeTEXT
Data Typedimension
Contact Organisation Id
The contact organisation id.
Field IDcontacts.orgid
TypeTEXT
Data Typedimension
Contact Segment.io Id
The Segment.id id of the contact.
Field IDcontacts.segmentio_id
TypeTEXT
Data Typedimension
Contact Bounced Hard
Number of times this contact has hard-bounced. Example: 0.
Field IDcontacts.bounced_hard
TypeNUMBER
Data Typemetric
Contact Bounced Soft
Number of times this contact has soft-bounced. Example: 0
Field IDcontacts.bounced_soft
TypeNUMBER
Data Typemetric
Contact Bounced Date
Date of most recent bounce for this contact.
Field IDcontacts.bounced_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact IP
IP address of the contact. Example: 38.104.242.98
Field IDcontacts.ip
TypeTEXT
Data Typedimension
Contact UA
Contact UA.
Field IDcontacts.ua
TypeTEXT
Data Typedimension
Contact Hash
Contact hash.
Field IDcontacts.hash
TypeTEXT
Data Typedimension
Contact Last Check
Last time social data was fetched for this contact..
Field IDcontacts.socialdata_lastcheck
TypeTEXT
Data Typedimension
Contact Email local
Contact email local.
Field IDcontacts.email_local
TypeTEXT
Data Typedimension
Contact Email Domain
Contact email domain.
Field IDcontacts.email_domain
TypeTEXT
Data Typedimension
Contact Sent Cnt
Contact sentcnt.
Field IDcontacts.sentcnt
TypeNUMBER
Data Typedimension
Contact Rating Tstamp
Contact rating_tstamp.
Field IDcontacts.rating_tstamp
TypeTEXT
Data Typedimension
Contact Gr Avatar
Contact gravatar.
Field IDcontacts.gravatar
TypeTEXT
Data Typedimension
Contact Deleted
Contact deleted.
Field IDcontacts.deleted
TypeTEXT
Data Typedimension
Contact Add Date
Contact adate.
Field IDcontacts.adate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Unsubscribe Date
Contact unsubscribe date.
Field IDcontacts.udate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Edit Date
Contact edate.
Field IDcontacts.edate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Id
Id of the Contact.
Field IDcontacts.id
TypeTEXT
Data Typedimension
Contact Organization
Contact organization.
Field IDcontacts.organization
TypeTEXT
Data Typedimension
Campaign Type
Campaign type.
Field IDcampaigns.type
TypeTEXT
Data Typedimension
Campaign User Id
Campaign user id.
Field IDcampaigns.userid
TypeTEXT
Data Typedimension
Campaign Segment Id
Campaign segment id.
Field IDcampaigns.segmentid
TypeTEXT
Data Typedimension
Campaign Bounce Id
Campaign bounce id.
Field IDcampaigns.bounceid
TypeTEXT
Data Typedimension
Campaign Real CID
Campaign real CID.
Field IDcampaigns.realcid
TypeTEXT
Data Typedimension
Campaign Send Id
Campaign send id.
Field IDcampaigns.sendid
TypeTEXT
Data Typedimension
Campaign Thread Id
Campaign thread id.
Field IDcampaigns.threadid
TypeTEXT
Data Typedimension
Campaign Series Id
Automation ID that this campaign is associated with.
Field IDcampaigns.seriesid
TypeTEXT
Data Typedimension
Campaign Form Id
Template used to create the campaign.
Field IDcampaigns.formid
TypeTEXT
Data Typedimension
Campaign Base Template Id
Campaign basetemplate id.
Field IDcampaigns.basetemplateid
TypeTEXT
Data Typedimension
Campaign Base Message Id
Internal message ID used for the campaign.
Field IDcampaigns.basemessageid
TypeTEXT
Data Typedimension
Campaign Address Id
Address ID used for the campaign.
Field IDcampaigns.addressid
TypeTEXT
Data Typedimension
Campaign Source
How the campaign was created. Possible value: 'web', 'api', 'copy', 'recurr', 'system'
Field IDcampaigns.source
TypeTEXT
Data Typedimension
Campaign Name
Internal name of the campaign.
Field IDcampaigns.name
TypeTEXT
Data Typedimension
Campaign Created Date
Date the campaign was initially created. Example: 2015-11-01 15:34:28
Field IDcampaigns.cdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Campaign Modification Date
Date the campaign was last modified. Example: 2015-11-01 15:38:28
Field IDcampaigns.mdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Campaign Send Date
Date the campaign started sending. Example: 2015-11-01 15:45:28
Field IDcampaigns.sdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Campaign Send Amt
Total amount of contacts actually sent this campaign.
Field IDcampaigns.send_amt
TypeNUMBER
Data Typemetric
Campaign Total Amt
Total amount of contacts determined to receive this campaign.
Field IDcampaigns.total_amt
TypeNUMBER
Data Typemetric
Campaign Opens
Total amount of opens for this campaign (including multiple opens by the same contact).
Field IDcampaigns.opens
TypeNUMBER
Data Typemetric
Campaign Unique Opens
Total amount of distinct (unique) contacts that opened this campaign.
Field IDcampaigns.uniqueopens
TypeNUMBER
Data Typemetric
Campaign Link Clicks
Total amount of link clicks for this campaign (including multiple link clicks by the same contact).
Field IDcampaigns.linkclicks
TypeNUMBER
Data Typemetric
Campaign Unique Link Clicks
Total amount of distinct (unique) links clicked for this campaign.
Field IDcampaigns.uniquelinkclicks
TypeNUMBER
Data Typemetric
Campaign Subscriber Clicks
Total amount of distinct (unique) contacts that clicked a link for this campaign.
Field IDcampaigns.subscriberclicks
TypeNUMBER
Data Typemetric
Campaign Forwards
Total amount of forwards (via the %FORWARD2FRIEND% personalization link only) for this campaign (including multiple forwards initiated by the same contact).
Field IDcampaigns.forwards
TypeNUMBER
Data Typemetric
Campaign Unique Forwards
Total amount of distinct (unique) contacts that forwarded this campaign (via the %FORWARD2FRIEND% personalization link only).
Field IDcampaigns.uniqueforwards
TypeNUMBER
Data Typemetric
Campaign Hard Bounces
Total number of hard bounces for this campaign.
Field IDcampaigns.hardbounces
TypeNUMBER
Data Typemetric
Campaign Soft Bounces
Total number of soft bounces for this campaign.
Field IDcampaigns.softbounces
TypeNUMBER
Data Typemetric
Campaign Unsubscribes
Total number of unsubscribes for this campaign.
Field IDcampaigns.unsubscribes
TypeNUMBER
Data Typemetric
Campaign Unsubscribe Reasons
Total number of unsubscribe reasons provided for unsubscriptions for this campaign.
Field IDcampaigns.unsubreasons
TypeNUMBER
Data Typemetric
Campaign Updates
Total number of contacts that updated their profile via this campaign (using the %UPDATELINK% personalization tag).
Field IDcampaigns.updates
TypeNUMBER
Data Typemetric
Campaign Social Shares
Total number of social shares conducted for this campaign.
Field IDcampaigns.socialshares
TypeNUMBER
Data Typemetric
Campaign Replies
Total number of replies for this campaign (including multiple replies by the same contact).
Field IDcampaigns.replies
TypeNUMBER
Data Typemetric
Campaign Unique Replies
Total number of distinct (unique) contacts that replied to this campaign.
Field IDcampaigns.uniquereplies
TypeNUMBER
Data Typemetric
Campaign Status
Status of this campaign. Possible values: Draft, Scheduled, Sending, Paused, Stopped, Completed, Disabled, Pending Approval
Field IDcampaigns.status
TypeTEXT
Data Typedimension
Campaign Public
Campaign public.
Field IDcampaigns.public
TypeTEXT
Data Typedimension
Campaign Mail Transfer
Campaign mail transfer.
Field IDcampaigns.mail_transfer
TypeTEXT
Data Typedimension
Campaign Mail Send
Campaign mail send.
Field IDcampaigns.mail_send
TypeTEXT
Data Typedimension
Campaign Mail Cleanup
Campaign mail cleaner.
Field IDcampaigns.mail_cleanup
TypeTEXT
Data Typedimension
Campaign Mailer Log File
Campaign mailer log file.
Field IDcampaigns.mailer_log_file
TypeTEXT
Data Typedimension
Campaign Track Links
Type of link tracking enabled for the campaign. Possible values: 'all', 'mime', 'html', 'text', 'none'
Field IDcampaigns.tracklinks
TypeTEXT
Data Typedimension
Campaign Track Links Analytics
Whether or not Google Analytics link tracking is enabled. Possible values: Yes, No
Field IDcampaigns.tracklinksanalytics
TypeTEXT
Data Typedimension
Campaign Track Reads
Whether or not read/open tracking is enabled for this campaign. Possible values: Yes, No
Field IDcampaigns.trackreads
TypeTEXT
Data Typedimension
Campaign Track Reads Analytics
Whether or not Google Analytics link tracking is enabled. Possible values: Yes, No
Field IDcampaigns.trackreadsanalytics
TypeTEXT
Data Typedimension
Campaign Analytics Campaign Name
The Google Analytics campaign name (used for organizing within Google Analytics).
Field IDcampaigns.analytics_campaign_name
TypeTEXT
Data Typedimension
Campaign Tweet
Whether or not this campaign auto-posted to Twitter. Possible values: Yes, No
Field IDcampaigns.tweet
TypeTEXT
Data Typedimension
Campaign Facebook
Whether or not this campaign auto-posted to Facebook. Possible values: Yes, No.
Field IDcampaigns.facebook
TypeTEXT
Data Typedimension
Campaign Survey
The unique ID from the SurveyMonkey personalization tag, which is the URL ID for the survey.
Field IDcampaigns.survey
TypeTEXT
Data Typedimension
Campaign Embed Images
Campaign.
Field IDcampaigns.embed_images
TypeTEXT
Data Typedimension
Campaign HTML Unsub
Campaign HTML unsub.
Field IDcampaigns.htmlunsub
TypeNUMBER
Data Typemetric
Campaign Text Unsub
Campaign text unsub.
Field IDcampaigns.textunsub
TypeNUMBER
Data Typemetric
Campaign HTML Unsub Data
Campaign HTML unsub data.
Field IDcampaigns.htmlunsubdata
TypeTEXT
Data Typedimension
Campaign Text Unsub Data
Campaign text unsub data.
Field IDcampaigns.textunsubdata
TypeTEXT
Data Typedimension
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
TypeTEXT
Data Typedimension
Campaign Will Recur
Campaign will recur.
Field IDcampaigns.willrecur
TypeTEXT
Data Typedimension
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
TypeTEXT
Data Typedimension
Campaign Split Content
Campaign split content.
Field IDcampaigns.split_content
TypeTEXT
Data Typedimension
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
TypeNUMBER
Data Typemetric
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
TypeTEXT
Data Typedimension
Campaign Split Winner Message Id
The winning message ID.
Field IDcampaigns.split_winner_messageid
TypeTEXT
Data Typedimension
Campaign Split Winner Awaiting
Whether or not a winner is still being determined. Possible values: Yes, No
Field IDcampaigns.split_winner_awaiting
TypeTEXT
Data Typedimension
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
TypeNUMBER
Data Typemetric
Campaign Responder Type
Campaign responder type.
Field IDcampaigns.responder_type
TypeTEXT
Data Typedimension
Campaign Responder Existing
Campaign responder existing.
Field IDcampaigns.responder_existing
TypeTEXT
Data Typedimension
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
TypeTEXT
Data Typedimension
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
TypeTEXT
Data Typedimension
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
TypeTEXT
Data Typedimension
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
TypeNUMBER
Data Typemetric
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
TypeTEXT
Data Typedimension
Campaign Reminder Offset Sign
If this is an auto-reminder (subscriber date-based) type campaign. Possible values: + and -
Field IDcampaigns.reminder_offset_sign
TypeTEXT
Data Typedimension
Campaign Reminder Last Cron Run
Campaign reminder last cron run.
Field IDcampaigns.reminder_last_cron_run
TypeTEXT
Data Typedimension
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
TypeTEXT
Data Typedimension
Campaign Active RSS Url
The RSS URL used to check for new feed items that get inserted into the campaign.
Field IDcampaigns.activerss_url
TypeTEXT
Data Typedimension
Campaign Active RSS Items
The number of RSS items to display in the campaign.
Field IDcampaigns.activerss_items
TypeNUMBER
Data Typemetric
Campaign IP4
Campaign IP4.
Field IDcampaigns.ip4
TypeTEXT
Data Typedimension
Campaign Last Step
The last step of the campaign process saved. Example: 'summary'
Field IDcampaigns.laststep
TypeTEXT
Data Typedimension
Campaign Manage Text
Campaign manage text.
Field IDcampaigns.managetext
TypeTEXT
Data Typedimension
Campaign Schedule
Whether or not this campaign is scheduled to send at a later date/time.
Field IDcampaigns.schedule
TypeTEXT
Data Typedimension
Campaign Schedule Date
The date the campaign is scheduled to send.
Field IDcampaigns.scheduleddate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Campaign Wait Preview
Campaign wait preview.
Field IDcampaigns.waitpreview
TypeTEXT
Data Typedimension
Campaign Delete Stamp
Campaign.
Field IDcampaigns.deletestamp
TypeTEXT
Data Typedimension
Campaign Reply Sys
Whether or not reply tracking is enabled for this campaign. Possible values: Yes, No
Field IDcampaigns.replysys
TypeTEXT
Data Typedimension
Campaign Id
ID of the campaign.
Field IDcampaigns.id
TypeTEXT
Data Typedimension
Campaign User
Campaign user.
Field IDcampaigns.user
TypeTEXT
Data Typedimension
Campaign Automation
Campaign automation.
Field IDcampaigns.automation
TypeTEXT
Data Typedimension
Automation Name
Automation name.
Field IDautomations.name
TypeTEXT
Data Typedimension
Automation Created Date
Automation created date.
Field IDautomations.cdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Automation Updated Date
Automation update date.
Field IDautomations.mdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Automation User Id
Automation user id.
Field IDautomations.userid
TypeTEXT
Data Typedimension
Automation Status
Automation status.
Field IDautomations.status
TypeTEXT
Data Typedimension
Automation Entered
Automation entered.
Field IDautomations.entered
TypeTEXT
Data Typedimension
Automation Exited
Automation exited.
Field IDautomations.exited
TypeTEXT
Data Typedimension
Automation Hidden
Automation hidden.
Field IDautomations.hidden
TypeTEXT
Data Typedimension
Automation Default Screenshot
Automation defult screenshot.
Field IDautomations.defaultscreenshot
TypeTEXT
Data Typedimension
Automation Screenshot
Automation screenshot.
Field IDautomations.screenshot
TypeTEXT
Data Typedimension
Automation Id
Automation id.
Field IDautomations.id
TypeTEXT
Data Typedimension
Message User Id
Message user id.
Field IDmessages.userid
TypeTEXT
Data Typedimension
Message Ed Instance Id
Message ed instance id.
Field IDmessages.ed_instanceid
TypeTEXT
Data Typedimension
Message Ed Version
Message ed version.
Field IDmessages.ed_version
TypeTEXT
Data Typedimension
Message Created Date
Message created date.
Field IDmessages.cdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Message Updated Date
Message update date.
Field IDmessages.mdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Message Name
Message name.
Field IDmessages.name
TypeTEXT
Data Typedimension
Message From Name
Message from name.
Field IDmessages.fromname
TypeTEXT
Data Typedimension
Message From Mail
Message from mail.
Field IDmessages.fromemail
TypeTEXT
Data Typedimension
Message Reply2
Message reply2.
Field IDmessages.reply2
TypeTEXT
Data Typedimension
Message Priority
Message priority.
Field IDmessages.priority
TypeTEXT
Data Typedimension
Message Charset
Message charset.
Field IDmessages.charset
TypeTEXT
Data Typedimension
Message Encoding
Message encoding.
Field IDmessages.encoding
TypeTEXT
Data Typedimension
Message Format
Message format.
Field IDmessages.format
TypeTEXT
Data Typedimension
Message Subject
Message subject.
Field IDmessages.subject
TypeTEXT
Data Typedimension
Message Preheader Text
Message preheader text.
Field IDmessages.preheader_text
TypeTEXT
Data Typedimension
Message Text
Message text.
Field IDmessages.text
TypeTEXT
Data Typedimension
Message HTML
Message HTML.
Field IDmessages.html
TypeTEXT
Data Typedimension
Message HTML Fetch
Message HTML fetch.
Field IDmessages.htmlfetch
TypeTEXT
Data Typedimension
Message Text Fetch
Message text fetch.
Field IDmessages.textfetch
TypeTEXT
Data Typedimension
Message Hidden
Message hidden.
Field IDmessages.hidden
TypeTEXT
Data Typedimension
Message Preview MIME
Message preview MIME.
Field IDmessages.preview_mime
TypeTEXT
Data Typedimension
Message Preview Data
Message preview data.
Field IDmessages.preview_data
TypeTEXT
Data Typedimension
Message Id
Message id.
Field IDmessages.id
TypeTEXT
Data Typedimension
Message User
Message User.
Field IDmessages.user
TypeTEXT
Data Typedimension
List String Id
URL-friendly name of list. Example: general-list
Field IDlists.stringid
TypeTEXT
Data Typedimension
List User Id
User ID who created this list. Example: 1
Field IDlists.userid
TypeTEXT
Data Typedimension
List Name
Internal name of list. Example: General List.
Field IDlists.name
TypeTEXT
Data Typedimension
List Created Date
Date/time the list was created. Example: 2011-03-02 14:46:40
Field IDlists.cdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
List P Use Tracking
List.
Field IDlists.p_use_tracking
TypeTEXT
Data Typedimension
List Use Analytics Read
List use anaytics reads.
Field IDlists.p_use_analytics_read
TypeTEXT
Data Typedimension
List Use Analytics Link
List use analytics link.
Field IDlists.p_use_analytics_link
TypeTEXT
Data Typedimension
List Use Twitter
Whether or not to use Twitter campaign auto-sharing. Examples: yes, no
Field IDlists.p_use_twitter
TypeTEXT
Data Typedimension
List Use Facebook
Whether or not to use Facebook campaign auto-sharing. Examples: yes, no
Field IDlists.p_use_facebook
TypeTEXT
Data Typedimension
List Embed Image
Whether or not to embed images for campaigns send to this list. Examples: yes, no
Field IDlists.p_embed_image
TypeTEXT
Data Typedimension
List Use Captcha
Whether or not to use captcha image verification when subscribing to this list. Examples: yes, no
Field IDlists.p_use_captcha
TypeTEXT
Data Typedimension
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
TypeTEXT
Data Typedimension
List Private
Whether or not this list is private (not visible on public side). Examples: yes, no
Field IDlists.private
TypeTEXT
Data Typedimension
List Analytics Domain
List anaytics domain.
Field IDlists.analytics_domain
TypeTEXT
Data Typedimension
List Analytics Source
List analytics source.
Field IDlists.analytics_source
TypeTEXT
Data Typedimension
List Analytics UA
List analytics ua.
Field IDlists.analytics_ua
TypeTEXT
Data Typedimension
List Twitter Token
The Twitter token used to send updates to your Twitter account.
Field IDlists.twitter_token
TypeTEXT
Data Typedimension
List Twitter Token Secret
The Twitter token secret used to send updates to your Twitter account.
Field IDlists.twitter_token_secret
TypeTEXT
Data Typedimension
List Facebook Session
The Facebook session used to send updates to your Facebook account.
Field IDlists.facebook_session
TypeTEXT
Data Typedimension
List Carbon Copy
Additional email addresses that campaigns for this list are sent to.
Field IDlists.carboncopy
TypeTEXT
Data Typedimension
List Subscription Notify
Whenever a contact subscribes to this list, an email gets sent to this address.
Field IDlists.subscription_notify
TypeTEXT
Data Typedimension
List Unsubscription Notify
Whenever a contact UNsubscribes to this list, an email gets sent to this address.
Field IDlists.unsubscription_notify
TypeTEXT
Data Typedimension
List Require Name
Whether or not to require a name when subscribing to this list. Examples: yes, no
Field IDlists.require_name
TypeTEXT
Data Typedimension
List Get Unsubscribe Reason
Whether or not to ask for a reason when contacts UNsubscribe. Examples: yes, no
Field IDlists.get_unsubscribe_reason
TypeTEXT
Data Typedimension
List To Name
Default contact name (used when contact has not entered a name). Example: Recipient
Field IDlists.to_name
TypeTEXT
Data Typedimension
List Sender Name
Sender's Contact Information.
Field IDlists.sender_name
TypeTEXT
Data Typedimension
List Sender Address 1
Sender's Contact Information.
Field IDlists.sender_addr1
TypeTEXT
Data Typedimension
List Sender Address 2
Sender's Contact Information.
Field IDlists.sender_addr2
TypeTEXT
Data Typedimension
List Sender City
Sender's Contact Information.
Field IDlists.sender_city
TypeTEXT
Data Typedimension
List Sender State
Sender's Contact Information.
Field IDlists.sender_state
TypeTEXT
Data Typedimension
List Sender Zip
Sender's Contact Information.
Field IDlists.sender_zip
TypeTEXT
Data Typedimension
List Sender Country
Sender's Contact Information.
Field IDlists.sender_country
TypeTEXT
Data Typedimension
List Sender Phone
Sender's Contact Information.
Field IDlists.sender_phone
TypeTEXT
Data Typedimension
List Sender URL
Sender's Contact Information.
Field IDlists.sender_url
TypeTEXT
Data Typedimension
List Sender Reminder
Sender's Contact Information.
Field IDlists.sender_reminder
TypeTEXT
Data Typedimension
List Full Address
List full address.
Field IDlists.fulladdress
TypeTEXT
Data Typedimension
List Optin Message Id
List optinmessageid.
Field IDlists.optinmessageid
TypeTEXT
Data Typedimension
List Delete Stamp
List deletestamp.
Field IDlists.deletestamp
TypeTEXT
Data Typedimension
List Update
List update.
Field IDlists.update
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
List Id
List id.
Field IDlists.id
TypeTEXT
Data Typedimension
List User
List user.
Field IDlists.user
TypeTEXT
Data Typedimension
Deal ID
Deal ID
Field IDdeals.id
TypeTEXT
Data Typedimension
Deal Title
Deal Title
Field IDdeals.title
TypeTEXT
Data Typedimension
Deal Description
Deal Description
Field IDdeals.description
TypeTEXT
Data Typedimension
Deal Status ID
Deal Status ID
Field IDdeals.status_id
TypeTEXT
Data Typedimension
Deal Created Date
Deal Created Date
Field IDdeals.cdate
TypeYEAR_MONTH_DAY
Data Typedimension
Deal Updated Date
Deal Updated Date
Field IDdeals.mdate
TypeYEAR_MONTH_DAY
Data Typedimension
Deal Win Probability
Deal Win Probability
Field IDdeals.winProbability
TypeTEXT
Data Typedimension
Deal Currency
Deal Currency
Field IDdeals.currency
TypeTEXT
Data Typedimension
Deal Value
Deal Value
Field IDdeals.value
TypeTEXT
Data Typedimension
Deal Contact ID
Deal Contact ID
Field IDdeals.contact_id
TypeTEXT
Data Typedimension
Deal Owner ID
Deal Owner ID
Field IDdeals.owner_id
TypeTEXT
Data Typedimension
Deal Owner First Name
Deal Owner First Name
Field IDdeals.owner_first_name
TypeTEXT
Data Typedimension
Deal Owner Last Name
Deal Owner Last Name
Field IDdeals.owner_last_name
TypeTEXT
Data Typedimension
Deal Owner Email
Deal Owner Email
Field IDdeals.owner_email
TypeTEXT
Data Typedimension
Deal Pipeline ID
Deal Pipeline ID
Field IDdeals.pipeline_id
TypeTEXT
Data Typedimension
Deal Pipeline Title
Deal Pipeline Title
Field IDdeals.pipeline_title
TypeTEXT
Data Typedimension
Deal Percent
Deal Percent
Field IDdeals.percent
TypePERCENT
Data Typedimension
Deal Stage Id
Deal Stage Id
Field IDdeals.stage_id
TypeTEXT
Data Typedimension
Deal Stage Name
Deal Stage Name
Field IDdeals.stage_name
TypeTEXT
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension
Campaign Open Rate
Campaign Open Rate
Field IDcampaigns.open_rate
TypePERCENT
Data Typemetric
Campaign Clicks Rate
Campaign Clicks Rate
Field IDcampaigns.click_rate
TypePERCENT
Data Typemetric
Campaign open rate
Campaign Open Unique rate
Field IDcampaigns.open_unique_rate
TypePERCENT
Data Typemetric
Campaign Unique Clicks Rate
Campaign Unique Clicks Rate
Field IDcampaigns.click_unique_rate
TypePERCENT
Data Typemetric