Oracle Eloqua Connector Objects

Objects Supported

Application API Entities

Name	Description
Account Groups	Query the available account groups in Eloqua.
Campaigns	Query the available campaigns in Eloqua.
Content Sections	Query the available content sections in Eloqua.
Email Folders	Query the available email folders in Eloqua.
Email Footers	Query the available email footers in Eloqua.
Email Groups	Query the available email groups in Eloqua.
Email Headers	Query the available email headers in Eloqua.
Emails	Query the available emails in Eloqua.
Forms	Query the available forms in Eloqua.
Images	Query the available images in Eloqua.
Landing Pages	Query the available landing pages in Eloqua.
Microsites	Query the available microsites in Eloqua.
Option Lists	Query the available option lists in Eloqua.
Users	Query the available users in Eloqua.
Visitors	Query the available visitors in Eloqua.

Bulk API Entities

Name	Description
Accounts	Query the available accounts in Eloqua via Bulk API.
Contacts	Query the available contacts in Eloqua via Bulk API.
Events	Query the available custom events in Eloqua via Bulk API.

Activity Entities

Name	Description	Filter
Activities Web Visit	Query web visit activities in Eloqua.	`'{{Activity.Type}}'='WebVisit'`
Activities Unsubscribe	Query unsubscribe activities in Eloqua.	`'{{Activity.Type}}'='Unsubscribe'`
Activities Subscribe	Query subscribe activities in Eloqua.	`'{{Activity.Type}}'='Subscribe'`
Activities Page View	Query page view activities in Eloqua.	`'{{Activity.Type}}'='PageView'`
Activities Form Submit	Query form submit activities in Eloqua.	`'{{Activity.Type}}'='FormSubmit'`
Activities Email Send	Query email send activities in Eloqua.	`'{{Activity.Type}}'='EmailSend'`
Activities Email Open	Query email open activities in Eloqua.	`'{{Activity.Type}}'='EmailOpen'`
Activities Email Clickthrough	Query email clickthrough activities in Eloqua.	`'{{Activity.Type}}'='EmailClickthrough'`
Activities Bounceback	Query bounceback activities in Eloqua.	`'{{Activity.Type}}'='Bounceback'`

Account Groups

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the account group.
type	String	False	No	The type of the account group.
depth	String	False	No	The depth of the account group.
createdAt	Datetime	False	No	When the account group was created.
createdBy	String	False	No	Who created the account group.
updatedAt	Datetime	False	No	When the account group was last updated.
updatedBy	String	False	No	Who last updated the account group.
name	String	False	No	The name of the account group.
permissions	String	False	No	Permissions for the account group.
count	Integer	False	No	The count of accounts in the group.
currentStatus	String	False	No	The current status of the account group.
description	String	False	No	Description of the account group.
folderId	String	False	No	The folder Id of the account group.
isArchived	Boolean	False	No	Whether the account group is archived.
scheduledFor	String	False	No	When the account group is scheduled for.
sourceTemplateId	String	False	No	The source template Id.

Return to Top

Campaigns

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the campaign.
type	String	False	No	The type of the campaign.
depth	String	False	No	The depth of the campaign.
createdAt	Datetime	False	No	When the campaign was created.
createdBy	String	False	No	Who created the campaign.
updatedAt	Datetime	False	No	When the campaign was last updated.
updatedBy	String	False	No	Who last updated the campaign.
permissions	String	False	No	Permissions for the campaign.
folderId	String	False	No	The folder ID of the campaign.
actualCost	Decimal	False	No	The actual cost of the campaign.
budgetedCost	Decimal	False	No	The budgeted cost of the campaign.
campaignCategory	String	False	No	The category of the campaign.
campaignType	String	False	No	The type of the campaign.
crmId	String	False	No	The CRM Id of the campaign.
currentStatus	String	False	No	The current status of the campaign.
description	String	False	No	Description of the campaign.
endAt	Datetime	False	No	When the campaign ends.
firstActivation	Datetime	False	No	When the campaign was first activated.
isEmailMarketingCampaign	Boolean	False	No	Whether this is an email marketing campaign.
isIncludedInROI	Boolean	False	No	Whether the campaign is included in ROI.
isMemberAllowedReEntry	Boolean	False	No	Whether members are allowed re-entry.
isReadOnly	Boolean	False	No	Whether the campaign is read-only.
isSyncedWithCRM	Boolean	False	No	Whether the campaign is synced with CRM.
name	String	False	No	The name of the campaign.
product	String	False	No	The product associated with the campaign.
region	String	False	No	The region of the campaign.
startAt	Datetime	False	No	When the campaign starts.

Return to Top

Content Sections

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the content section.
type	String	False	No	The type of the content section.
depth	String	False	No	The depth of the content section.
createdAt	Datetime	False	No	When the content section was created.
createdBy	String	False	No	Who created the content section.
updatedAt	Datetime	False	No	When the content section was last updated.
updatedBy	String	False	No	Who last updated the content section.
currentStatus	String	False	No	The current status of the content section.
description	String	False	No	Description of the content section.
name	String	False	No	The name of the content section.
folderId	String	False	No	The folder Id of the content section.
permissions	String	False	No	Permissions for the content section.
contentText	String	False	No	The text content of the content section.
contentHtml	String	False	No	The HTML content of the content section.
scope	String	False	No	The scope of the content section.
size.type	String	False	No	The size type of the content section.
size.width	String	False	No	The width of the content section.
size.height	String	False	No	The height of the content section.

Return to Top

Email Folders

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the email folder.
type	String	False	No	The type of the email folder.
depth	String	False	No	The depth of the email folder.
createdAt	Datetime	False	No	When the email folder was created.
createdBy	String	False	No	Who created the email folder.
updatedAt	Datetime	False	No	When the email folder was last updated.
updatedBy	String	False	No	Who last updated the email folder.
name	String	False	No	The name of the email folder.
description	String	False	No	Description of the email folder.
permissions	String	False	No	Permissions for the email folder.
currentStatus	String	False	No	The current status of the email folder.
isSystem	Boolean	False	No	Whether the email folder is a system folder.
sourceTemplateId	String	False	No	The source template Id.
scheduledFor	String	False	No	When the email folder is scheduled for.
folderId	String	False	No	The parent folder Id.
archive	Boolean	False	No	Whether the email folder is archived.

Return to Top

Email Footers

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the email footer.
type	String	False	No	The type of the email footer.
depth	String	False	No	The depth of the email footer.
createdAt	Datetime	False	No	When the email footer was created.
createdBy	String	False	No	Who created the email footer.
currentStatus	String	False	No	The current status of the email footer.
description	String	False	No	Description of the email footer.
name	String	False	No	The name of the email footer.
permissions	String	False	No	Permissions for the email footer.
body	String	False	No	The body content of the email footer.
text	String	False	No	The text content of the email footer.
updatedAt	Datetime	False	No	When the email footer was last updated.
updatedBy	String	False	No	Who last updated the email footer.
folderId	String	False	No	The folder Id of the email footer.

Return to Top

Email Groups

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the email group.
type	String	False	No	The type of the email group.
depth	String	False	No	The depth of the email group.
currentStatus	String	False	No	The current status of the email group.
name	String	False	No	The name of the email group.
description	String	False	No	Description of the email group.
permissions	String	False	No	Permissions for the email group.
createdAt	String	False	No	When the email group was created.
createdBy	String	False	No	Who created the email group.
updatedAt	String	False	No	When the email group was last updated.
updatedBy	String	False	No	Who last updated the email group.
emailHeaderId	String	False	No	The email header Id associated with the group.
emailFooterId	String	False	No	The email footer Id associated with the group.
subscriptionLandingPageId	String	False	No	The subscription landing page Id.
unsubscriptionLandingPageId	String	False	No	The unsubscription landing page Id.
isVisibleInOutlookPlugin	Boolean	False	No	Whether visible in Outlook plugin.
isVisibleInPublicSubscriptionList	Boolean	False	No	Whether visible in public subscription list.
emailIds	String	False	No	The email IDs associated with the group.
displayName	String	False	No	The display name of the email group.
subscriptionListId	String	False	No	The subscription list Id.
unSubscriptionListId	String	False	No	The unsubscription list Id.
subscriptionListDataLookupId	String	False	No	The subscription list data lookup Id.
unSubscriptionListDataLookupId	String	False	No	The unsubscription list data lookup Id.

Return to Top

Email Headers

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the email header.
type	String	False	No	The type of the email header.
depth	String	False	No	The depth of the email header.
createdAt	Datetime	False	No	When the email header was created.
createdBy	String	False	No	Who created the email header.
currentStatus	String	False	No	The current status of the email header.
description	String	False	No	Description of the email header.
name	String	False	No	The name of the email header.
permissions	String	False	No	Permissions for the email header.
body	String	False	No	The body content of the email header.
text	String	False	No	The text content of the email header.
updatedAt	Datetime	False	No	When the email header was last updated.
updatedBy	String	False	No	Who last updated the email header.
folderId	String	False	No	The folder Id of the email header.

Return to Top

Emails

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the email.
type	String	False	No	The type of the email.
depth	String	False	No	The depth of the email.
createdAt	Datetime	False	No	When the email was created.
createdBy	String	False	No	Who created the email.
updatedAt	Datetime	False	No	When the email was last updated.
updatedBy	String	False	No	Who last updated the email.
currentStatus	String	False	No	The current status of the email.
description	String	False	No	Description of the email.
name	String	False	No	The name of the email.
permissions	String	False	No	Permissions for the email.
emailFooterId	String	False	No	The email footer Id.
bounceBackEmail	String	False	No	The bounce back email address.
emailGroupId	String	False	No	The email group Id.
emailHeaderId	String	False	No	The email header Id.
encodingId	String	False	No	The encoding Id.
isPlainTextEditable	Boolean	False	No	Whether the plain text is editable.
isTracked	Boolean	False	No	Whether the email is tracked.
layout	String	False	No	The layout of the email.
folderId	String	False	No	The folder Id of the email.
plainText	String	False	No	The plain text content of the email.
replyToEmail	String	False	No	The reply-to email address.
replyToName	String	False	No	The reply-to name.
senderEmail	String	False	No	The sender email address.
senderName	String	False	No	The sender name.
sendPlainTextOnly	Boolean	False	No	Whether to send plain text only.
style	String	False	No	The style of the email.
subject	String	False	No	The subject of the email.
archived	Boolean	False	No	Whether the email is archived.
isContentProtected	Boolean	False	No	Whether the content is protected.
isPrivate	Boolean	False	No	Whether the email is private.
renderMode	String	False	No	The render mode of the email.
brandId	String	False	No	The brand Id.
virtualMTAId	String	False	No	The virtual MTA Id.

Return to Top

Forms

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the form.
type	String	False	No	The type of the form.
depth	String	False	No	The depth of the form.
currentStatus	String	False	No	The current status of the form.
name	String	False	No	The name of the form.
description	String	False	No	Description of the form.
permissions	String	False	No	Permissions for the form.
folderId	String	False	No	The folder Id of the form.
sourceTemplateId	String	False	No	The source template Id.
createdBy	String	False	No	Who created the form.
createdAt	Datetime	False	No	When the form was created.
updatedBy	String	False	No	Who last updated the form.
updatedAt	Datetime	False	No	When the form was last updated.
scheduledFor	String	False	No	When the form is scheduled for.
htmlName	String	False	No	The HTML name of the form.
processingType	String	False	No	The processing type of the form.
submitFailedLandingPageId	String	False	No	The submit failed landing page Id.
size.type	String	False	No	The size type of the form.
size.width	String	False	No	The width of the form.
size.height	String	False	No	The height of the form.
html	String	False	No	The HTML content of the form.
style	String	False	No	The style of the form.
customCSS	String	False	No	The custom CSS of the form.
isHidden	String	False	No	Whether the form is hidden.
formJson	String	False	No	The JSON representation of the form.
isResponsive	Boolean	False	No	Whether the form is responsive.
archived	Boolean	False	No	Whether the form is archived.
isFormSpamProtectionEnabled	String	False	No	Whether spam protection is enabled.
defaultKeyFieldMapping.type	String	False	No	The default key field mapping type.
defaultKeyFieldMapping.sourceFormFieldId	String	False	No	The source form field Id for key mapping.
defaultKeyFieldMapping.targetEntityFieldId	String	False	No	The target entity field Id for key mapping.

Return to Top

Images

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the image.
type	String	False	No	The type of the image.
depth	String	False	No	The depth of the image.
createdAt	Datetime	False	No	When the image was created.
createdBy	String	False	No	Who created the image.
updatedAt	Datetime	False	No	When the image was last updated.
updatedBy	String	False	No	Who last updated the image.
currentStatus	String	False	No	The current status of the image.
description	String	False	No	Description of the image.
name	String	False	No	The name of the image.
permissions	String	False	No	Permissions for the image.
fullImageUrl	String	False	No	The full URL of the image.
size.type	String	False	No	The size type of the image.
size.width	String	False	No	The width of the image.
size.height	String	False	No	The height of the image.
thumbnailUrl	String	False	No	The thumbnail URL of the image.

Return to Top

Landing Pages

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the landing page.
type	String	False	No	The type of the landing page.
depth	String	False	No	The depth of the landing page.
createdAt	Datetime	False	No	When the landing page was created.
createdBy	String	False	No	Who created the landing page.
updatedAt	Datetime	False	No	When the landing page was last updated.
updatedBy	String	False	No	Who last updated the landing page.
currentStatus	String	False	No	The current status of the landing page.
description	String	False	No	Description of the landing page.
folderId	String	False	No	The folder Id of the landing page.
deployedAt	Datetime	False	No	When the landing page was deployed.
autoCloseWaitFor	String	False	No	Auto close wait time.
autoRedirectUrl	String	False	No	The auto redirect URL.
autoRedirectWaitFor	String	False	No	Auto redirect wait time.
layout	String	False	No	The layout of the landing page.
micrositeId	String	False	No	The microsite Id.
permissions	String	False	No	Permissions for the landing page.
refreshedAt	Datetime	False	No	When the landing page was refreshed.
relativePath	String	False	No	The relative path of the landing page.
style	String	False	No	The style of the landing page.
htmlContent.type	String	False	No	The HTML content type.
htmlContent.contentSource	String	False	No	The HTML content source.
htmlContent.html	String	False	No	The HTML content.
excludeFromAuthentication	Boolean	False	No	Whether to exclude from authentication.
isContentProtected	Boolean	False	No	Whether the content is protected.
isHidden	Boolean	False	No	Whether the landing page is hidden.
thumbnailUrl	String	False	No	The thumbnail URL.
expiresAt	Datetime	False	No	When the landing page expires.
expiryRedirectUrl	String	False	No	The expiry redirect URL.
isExpiryEnabled	Boolean	False	No	Whether expiry is enabled.
displayTimeZoneId	String	False	No	The display time zone ID.

Return to Top

Microsites

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the microsite.
type	String	False	No	The type of the microsite.
depth	String	False	No	The depth of the microsite.
createdBy	String	False	No	Who created the microsite.
createdAt	Datetime	False	No	When the microsite was created.
updatedBy	String	False	No	Who last updated the microsite.
updatedAt	Datetime	False	No	When the microsite was last updated.
currentStatus	String	False	No	The current status of the microsite.
name	String	False	No	The name of the microsite.
description	String	False	No	Description of the microsite.
permissions	String	False	No	Permissions for the microsite.
domains	String	False	No	The domains of the microsite.
defaultLandingPageId	String	False	No	The default landing page Id.
isAllowedInFrame	Boolean	False	No	Whether the microsite is allowed in a frame.

Return to Top

Option Lists

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the option list.
type	String	False	No	The type of the option list.
depth	String	False	No	The depth of the option list.
createdAt	Datetime	False	No	When the option list was created.
createdBy	String	False	No	Who created the option list.
updatedAt	Datetime	False	No	When the option list was last updated.
updatedBy	String	False	No	Who last updated the option list.
name	String	False	No	The name of the option list.
description	String	False	No	Description of the option list.
permissions	String	False	No	Permissions for the option list.
currentStatus	String	False	No	The current status of the option list.

elements (nested object array):

type (String): The type of the element.
displayName (String): The display name of the element.
value (String): The value of the element.

Return to Top

Users

Name	Type	ReadOnly	FilterOnly	Description
id [KEY]	String	True	No	The Id of the user.
type	String	False	No	The type of the user.
depth	String	False	No	The depth of the user.
currentStatus	String	False	No	The current status of the user.
createdAt	Datetime	False	No	When the user was created.
createdBy	String	False	No	Who created the user.
updatedAt	Datetime	False	No	When the user was last updated.
updatedBy	String	False	No	Who last updated the user.
description	String	False	No	Description of the user.
name	String	False	No	The name of the user.
defaultAccountViewId	String	False	No	The default account view Id.
defaultContactViewId	String	False	No	The default contact view Id.
emailAddress	String	False	No	The email address of the user.
loginName	String	False	No	The login name of the user.
loggedInAt	Datetime	False	No	When the user last logged in.
preferences.timezoneId	String	False	No	The preferences timezone Id.
preferences.type	String	False	No	The preferences type.
folderId	String	False	No	The folder Id of the user.
address1	String	False	No	Address line 1.
address2	String	False	No	Address line 2.
sourceTemplateId	String	False	No	The source template Id.
scheduledFor	String	False	No	When the user is scheduled for.
federationId	String	False	No	The federation Id.
firstName	String	False	No	The first name of the user.
lastName	String	False	No	The last name of the user.
capabilities	String	False	No	The capabilities of the user.
betaAccess	String	False	No	The beta access of the user.
isUsingBrightenTemplate	Boolean	False	No	Whether using Brighten template.
shortcuts	String	False	No	The shortcuts of the user.
isDeleted	Boolean	False	No	Whether the user is deleted.
isDisabled	Boolean	False	No	Whether the user is disabled.
jobTitle	String	False	No	The job title of the user.
companyDisplayName	String	False	No	The company display name.
companyUrl	String	False	No	The company URL.
phone	String	False	No	The phone number of the user.
crmUsername	String	False	No	The CRM username.
crmUserNames.type	String	False	No	The CRM user names type.
crmUserNames.MSDUserName	String	False	No	The MSD user name.
crmUserNames.OSCUserName	String	False	No	The OSC user name.
crmUserNames.SFDCUserName	String	False	No	The SFDC user name.
crmUserNames.SODUserName	String	False	No	The SOD user name.
passwordExpires	Boolean	False	No	Whether the password expires.
sendWelcomeEmail	Boolean	False	No	Whether to send welcome email.
cellPhone	String	False	No	The cell phone number.
replyToAddress	String	False	No	The reply-to address.
department	String	False	No	The department of the user.
fax	String	False	No	The fax number.
personalUrl	String	False	No	The personal URL.
personalMessage	String	False	No	The personal message.
ssoOnly	Boolean	False	No	Whether SSO only.
digitalSignatureId	String	False	No	The digital signature Id.
personalPhotoId	String	False	No	The personal photo Id.
city	String	False	No	The city of the user.
state	String	False	No	The state of the user.
country	String	False	No	The country of the user.
zipCode	String	False	No	The zip code of the user.
senderEmailAddress	String	False	No	The sender email address.
senderDisplayName	String	False	No	The sender display name.

Return to Top

Visitors

Name	Type	ReadOnly	FilterOnly	Description
type	String	False	No	The type of the visitor.
visitorId [KEY]	String	True	No	The Id of the visitor.
createdAt	Datetime	False	No	When the visitor was created.
V_IPAddress	String	False	No	The IP address of the visitor.
V_LastVisitDateAndTime	Datetime	False	No	The last visit date and time.
externalId	String	False	No	The external Id of the visitor.
contactId	String	False	No	The contact Id associated with the visitor.

Return to Top

Accounts

Name	Type	ReadOnly	References	FilterOnly	Description
Dynamic Fields	Various	False		No	Account fields are dynamically loaded from Eloqua based on your account configuration.

Note: The Accounts entity uses the Bulk API and fields are retrieved dynamically at runtime based on your Eloqua instance configuration.

Return to Top

Contacts

Name	Type	ReadOnly	References	FilterOnly	Description
Dynamic Fields	Various	False		No	Contact fields are dynamically loaded from Eloqua based on your account configuration.

Note: The Contacts entity uses the Bulk API and fields are retrieved dynamically at runtime based on your Eloqua instance configuration.

Return to Top

Events

Name	Type	ReadOnly	References	FilterOnly	Description
Dynamic Fields	Various	False		No	Event fields are dynamically loaded from Eloqua based on your custom event definitions.

Note: The Events entity uses the Bulk API and represents custom events. Fields and table names are determined dynamically at runtime based on your Eloqua instance configuration.

Return to Top

Activities Web Visit

Name	Type	ReadOnly	References	FilterOnly	Description
ActivityId [KEY]	Integer	True	{{Activity.Id}}	No	The Id of the activity.
ActivityType	String	False	{{Activity.Type}}	No	The type of the activity (WebVisit).
ActivityDate	Datetime	False	{{Activity.CreatedAt}}	No	The date of the activity.
ContactId	Integer	False	{{Activity.Contact.Id}}	No	The contact Id associated with the activity.
VisitorId	Integer	False	{{Activity.Visitor.Id}}	No	The visitor Id associated with the activity.
VisitorExternalId	String	False	{{Activity.Visitor.ExternalId}}	No	The external visitor Id.
ReferrerUrl	String	False	{{Activity.Field(ReferrerUrl)}}	No	The referrer URL.
IpAddress	String	False	{{Activity.Field(IpAddress)}}	No	The IP address.
NumberOfPages	Integer	False	{{Activity.Field(NumberOfPages)}}	No	The number of pages visited.
FirstPageViewUrl	String	False	{{Activity.Field(FirstPageViewUrl)}}	No	The first page view URL.
Duration	String	False	{{Activity.Field(Duration)}}	No	The duration of the web visit.
ExternalId	String	False	{{Activity.ExternalId}}	No	The external Id of the activity.

Return to Top

Activities Unsubscribe

Name	Type	ReadOnly	References	FilterOnly	Description
ActivityId [KEY]	Integer	True	{{Activity.Id}}	No	The Id of the activity.
ActivityType	String	False	{{Activity.Type}}	No	The type of the activity (Unsubscribe).
AssetId	Integer	False	{{Activity.Asset.Id}}	No	The asset Id.
ActivityDate	Datetime	False	{{Activity.CreatedAt}}	No	The date of the activity.
EmailAddress	String	False	{{Activity.Field(EmailAddress)}}	No	The email address.
EmailRecipientId	String	False	{{Activity.Field(EmailRecipientId)}}	No	The email recipient Id.
AssetType	String	False	{{Activity.Asset.Type}}	No	The asset type.
AssetName	String	False	{{Activity.Asset.Name}}	No	The asset name.
CampaignId	Integer	False	{{Activity.Campaign.Id}}	No	The campaign Id.
ExternalId	String	False	{{Activity.ExternalId}}	No	The external Id of the activity.

Return to Top

Activities Subscribe

Name	Type	ReadOnly	References	FilterOnly	Description
ActivityId [KEY]	Integer	True	{{Activity.Id}}	No	The Id of the activity.
ActivityType	String	False	{{Activity.Type}}	No	The type of the activity (Subscribe).
AssetId	Integer	False	{{Activity.Asset.Id}}	No	The asset Id.
ActivityDate	Datetime	False	{{Activity.CreatedAt}}	No	The date of the activity.
EmailAddress	String	False	{{Activity.Field(EmailAddress)}}	No	The email address.
EmailRecipientId	String	False	{{Activity.Field(EmailRecipientId)}}	No	The email recipient Id.
AssetType	String	False	{{Activity.Asset.Type}}	No	The asset type.
AssetName	String	False	{{Activity.Asset.Name}}	No	The asset name.
CampaignId	Integer	False	{{Activity.Campaign.Id}}	No	The campaign Id.
ExternalId	String	False	{{Activity.ExternalId}}	No	The external Id of the activity.

Return to Top

Activities Page View

Name	Type	ReadOnly	References	FilterOnly	Description
ActivityId [KEY]	Integer	True	{{Activity.Id}}	No	The Id of the activity.
ActivityType	String	False	{{Activity.Type}}	No	The type of the activity (PageView).
ActivityDate	Datetime	False	{{Activity.CreatedAt}}	No	The date of the activity.
ContactId	Integer	False	{{Activity.Contact.Id}}	No	The contact Id.
CampaignId	Integer	False	{{Activity.Campaign.Id}}	No	The campaign Id.
VisitorId	Integer	False	{{Activity.Visitor.Id}}	No	The visitor Id.
VisitorExternalId	String	False	{{Activity.Visitor.ExternalId}}	No	The external visitor Id.
WebVisitId	Integer	False	{{Activity.Field(WebVisitId)}}	No	The web visit Id.
Url	String	False	{{Activity.Field(Url)}}	No	The URL of the page viewed.
ReferrerUrl	String	False	{{Activity.Field(ReferrerUrl)}}	No	The referrer URL.
IpAddress	String	False	{{Activity.Field(IpAddress)}}	No	The IP address.
IsWebTrackingOptedIn	Boolean	False	{{Activity.Field(IsWebTrackingOptedIn)}}	No	Whether web tracking is opted in.
ExternalId	String	False	{{Activity.ExternalId}}	No	The external Id of the activity.

Return to Top

Activities Form Submit

Name	Type	ReadOnly	References	FilterOnly	Description
ActivityId [KEY]	Integer	True	{{Activity.Id}}	No	The Id of the activity.
ActivityType	String	False	{{Activity.Type}}	No	The type of the activity (FormSubmit).
ActivityDate	Datetime	False	{{Activity.CreatedAt}}	No	The date of the activity.
ContactId	Integer	False	{{Activity.Contact.Id}}	No	The contact Id.
VisitorId	Integer	False	{{Activity.Visitor.Id}}	No	The visitor Id.
VisitorExternalId	String	False	{{Activity.Visitor.ExternalId}}	No	The external visitor Id.
AssetType	String	False	{{Activity.Asset.Type}}	No	The asset type.
AssetId	Integer	False	{{Activity.Asset.Id}}	No	The asset Id.
AssetName	String	False	{{Activity.Asset.Name}}	No	The asset name.
RawData	String	False	{{Activity.Field(RawData)}}	No	The raw form data.
CampaignId	Integer	False	{{Activity.Campaign.Id}}	No	The campaign Id.
ExternalId	String	False	{{Activity.ExternalId}}	No	The external Id of the activity.

Return to Top

Activities Email Send

Name	Type	ReadOnly	References	FilterOnly	Description
ActivityId [KEY]	Integer	True	{{Activity.Id}}	No	The Id of the activity.
ActivityType	String	False	{{Activity.Type}}	No	The type of the activity (EmailSend).
ActivityDate	Datetime	False	{{Activity.CreatedAt}}	No	The date of the activity.
EmailAddress	String	False	{{Activity.Field(EmailAddress)}}	No	The email address.
ContactId	Integer	False	{{Activity.Contact.Id}}	No	The contact Id.
EmailRecipientId	String	False	{{Activity.Field(EmailRecipientId)}}	No	The email recipient Id.
AssetType	String	False	{{Activity.Asset.Type}}	No	The asset type.
AssetId	Integer	False	{{Activity.Asset.Id}}	No	The asset Id.
AssetName	String	False	{{Activity.Asset.Name}}	No	The asset name.
SubjectLine	String	False	{{Activity.Field(SubjectLine)}}	No	The subject line of the email.
EmailWebLink	String	False	{{Activity.Field(EmailWebLink)}}	No	The email web link.
CampaignId	Integer	False	{{Activity.Campaign.Id}}	No	The campaign Id.
ExternalId	String	False	{{Activity.ExternalId}}	No	The external Id of the activity.
DeploymentId	Integer	False	{{Activity.Field(EmailDeploymentId)}}	No	The email deployment Id.
EmailSendType	String	False	{{Activity.Field(EmailSendType)}}	No	The email send type.

Return to Top

Activities Email Open

Name	Type	ReadOnly	References	FilterOnly	Description
ActivityId [KEY]	Integer	True	{{Activity.Id}}	No	The Id of the activity.
ActivityType	String	False	{{Activity.Type}}	No	The type of the activity (EmailOpen).
ActivityDate	Datetime	False	{{Activity.CreatedAt}}	No	The date of the activity.
EmailAddress	String	False	{{Activity.Field(EmailAddress)}}	No	The email address.
ContactId	Integer	False	{{Activity.Contact.Id}}	No	The contact Id.
IpAddress	String	False	{{Activity.Field(IpAddress)}}	No	The IP address.
VisitorId	Integer	False	{{Activity.Visitor.Id}}	No	The visitor Id.
EmailRecipientId	String	False	{{Activity.Field(EmailRecipientId)}}	No	The email recipient Id.
AssetType	String	False	{{Activity.Asset.Type}}	No	The asset type.
AssetName	String	False	{{Activity.Asset.Name}}	No	The asset name.
AssetId	Integer	False	{{Activity.Asset.Id}}	No	The asset Id.
SubjectLine	String	False	{{Activity.Field(SubjectLine)}}	No	The subject line of the email.
EmailWebLink	String	False	{{Activity.Field(EmailWebLink)}}	No	The email web link.
VisitorExternalId	String	False	{{Activity.Visitor.ExternalId}}	No	The external visitor Id.
CampaignId	Integer	False	{{Activity.Campaign.Id}}	No	The campaign Id.
ExternalId	String	False	{{Activity.ExternalId}}	No	The external Id of the activity.
DeploymentId	Integer	False	{{Activity.Field(EmailDeploymentId)}}	No	The email deployment Id.
EmailSendType	String	False	{{Activity.Field(EmailSendType)}}	No	The email send type.

Return to Top

Activities Email Clickthrough

Name	Type	ReadOnly	References	FilterOnly	Description
ActivityId [KEY]	Integer	True	{{Activity.Id}}	No	The Id of the activity.
ActivityType	String	False	{{Activity.Type}}	No	The type of the activity (EmailClickthrough).
ActivityDate	Datetime	False	{{Activity.CreatedAt}}	No	The date of the activity.
EmailAddress	String	False	{{Activity.Field(EmailAddress)}}	No	The email address.
ContactId	Integer	False	{{Activity.Contact.Id}}	No	The contact Id.
IpAddress	String	False	{{Activity.Field(IpAddress)}}	No	The IP address.
VisitorId	Integer	False	{{Activity.Visitor.Id}}	No	The visitor Id.
EmailRecipientId	String	False	{{Activity.Field(EmailRecipientId)}}	No	The email recipient Id.
AssetType	String	False	{{Activity.Asset.Type}}	No	The asset type.
AssetName	String	False	{{Activity.Asset.Name}}	No	The asset name.
AssetId	Integer	False	{{Activity.Asset.Id}}	No	The asset Id.
SubjectLine	String	False	{{Activity.Field(SubjectLine)}}	No	The subject line of the email.
EmailWebLink	String	False	{{Activity.Field(EmailWebLink)}}	No	The email web link.
EmailClickedThruLink	String	False	{{Activity.Field(EmailClickedThruLink)}}	No	The link that was clicked through.
VisitorExternalId	String	False	{{Activity.Visitor.ExternalId}}	No	The external visitor Id.
CampaignId	Integer	False	{{Activity.Campaign.Id}}	No	The campaign Id.
ExternalId	String	False	{{Activity.ExternalId}}	No	The external Id of the activity.
DeploymentId	Integer	False	{{Activity.Field(EmailDeploymentId)}}	No	The email deployment Id.
EmailSendType	String	False	{{Activity.Field(EmailSendType)}}	No	The email send type.

Return to Top

Activities Bounceback

Name	Type	ReadOnly	References	FilterOnly	Description
ActivityId [KEY]	Integer	True	{{Activity.Id}}	No	The Id of the activity.
ActivityType	String	False	{{Activity.Type}}	No	The type of the activity (Bounceback).
ActivityDate	Datetime	False	{{Activity.CreatedAt}}	No	The date of the activity.
EmailAddress	String	False	{{Activity.Field(EmailAddress)}}	No	The email address.
AssetId	Integer	False	{{Activity.Asset.Id}}	No	The asset Id.
AssetType	String	False	{{Activity.Asset.Type}}	No	The asset type.
AssetName	String	False	{{Activity.Asset.Name}}	No	The asset name.
CampaignId	Integer	False	{{Activity.Campaign.Id}}	No	The campaign Id.
ExternalId	String	False	{{Activity.ExternalId}}	No	The external Id of the activity.

Return to Top