Activity fields

Activity elements behave differently from other Eloqua elements. Each activity type has its own set of associated fields which are detailed below.

For activity field type and length, see activity field details.

EmailOpen activity fields

{
  "ActivityId": "{{Activity.Id}}",
  "ActivityType": "{{Activity.Type}}",
  "ActivityDate": "{{Activity.CreatedAt}}",
  "EmailAddress": "{{Activity.Field(EmailAddress)}}",
  "ContactId": "{{Activity.Contact.Id}}",
  "IpAddress": "{{Activity.Field(IpAddress)}}",
  "VisitorId": "{{Activity.Visitor.Id}}",
  "EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
  "AssetType": "{{Activity.Asset.Type}}",
  "AssetName": "{{Activity.Asset.Name}}",
  "AssetId": "{{Activity.Asset.Id}}",
  "SubjectLine": "{{Activity.Field(SubjectLine)}}",
  "EmailWebLink": "{{Activity.Field(EmailWebLink)}}",
  "VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
  "CampaignId": "{{Activity.Campaign.Id}}",
  "ExternalId": "{{Activity.ExternalId}}",
  "DeploymentId": "{{Activity.Field(EmailDeploymentId)}}",
  "EmailSendType": "{{Activity.Field(EmailSendType)}}",
  "CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
  "CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
}

EmailClickthrough activity fields

{
  "ActivityId": "{{Activity.Id}}",
  "ActivityType": "{{Activity.Type}}",
  "ActivityDate": "{{Activity.CreatedAt}}",
  "EmailAddress": "{{Activity.Field(EmailAddress)}}",
  "ContactId": "{{Activity.Contact.Id}}",
  "IpAddress": "{{Activity.Field(IpAddress)}}",
  "VisitorId": "{{Activity.Visitor.Id}}",
  "EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
  "AssetType": "{{Activity.Asset.Type}}",
  "AssetName": "{{Activity.Asset.Name}}",
  "AssetId": "{{Activity.Asset.Id}}",
  "SubjectLine": "{{Activity.Field(SubjectLine)}}",
  "EmailWebLink": "{{Activity.Field(EmailWebLink)}}",
  "EmailClickedThruLink": "{{Activity.Field(EmailClickedThruLink)}}",
  "VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
  "CampaignId": "{{Activity.Campaign.Id}}",
  "ExternalId": "{{Activity.ExternalId}}",
  "DeploymentId": "{{Activity.Field(EmailDeploymentId)}}",
  "EmailSendType": "{{Activity.Field(EmailSendType)}}"
  "CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
  "CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
}

EmailSend activity fields

{
  "ActivityId": "{{Activity.Id}}",
  "ActivityType": "{{Activity.Type}}",
  "ActivityDate": "{{Activity.CreatedAt}}",
  "EmailAddress": "{{Activity.Field(EmailAddress)}}",
  "ContactId": "{{Activity.Contact.Id}}",
  "EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
  "AssetType": "{{Activity.Asset.Type}}",
  "AssetId": "{{Activity.Asset.Id}}",
  "AssetName": "{{Activity.Asset.Name}}",
  "SubjectLine": "{{Activity.Field(SubjectLine)}}",
  "EmailWebLink": "{{Activity.Field(EmailWebLink)}}",
  "CampaignId": "{{Activity.Campaign.Id}}",
  "ExternalId": "{{Activity.ExternalId}}",
  "DeploymentId": "{{Activity.Field(EmailDeploymentId)}}",
  "EmailSendType": "{{Activity.Field(EmailSendType)}}"
  "CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
  "CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
}

Subscribe activity fields

{
  "ActivityId": "{{Activity.Id}}",
  "ActivityType": "{{Activity.Type}}",
  "AssetId": "{{Activity.Asset.Id}}",
  "ActivityDate": "{{Activity.CreatedAt}}",
  "EmailAddress": "{{Activity.Field(EmailAddress)}}",
  "ContactId": "{{Activity.Contact.Id}}",
  "EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
  "AssetType": "{{Activity.Asset.Type}}",
  "AssetName": "{{Activity.Asset.Name}}",
  "CampaignId": "{{Activity.Campaign.Id}}",
  "ExternalId": "{{Activity.ExternalId}}"
}

Unsubscribe activity fields

{
  "ActivityId": "{{Activity.Id}}",
  "ActivityType": "{{Activity.Type}}",
  "AssetId": "{{Activity.Asset.Id}}",
  "ActivityDate": "{{Activity.CreatedAt}}",
  "EmailAddress": "{{Activity.Field(EmailAddress)}}",
  "ContactId": "{{Activity.Contact.Id}}",
  "EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
  "AssetType": "{{Activity.Asset.Type}}",
  "AssetName": "{{Activity.Asset.Name}}",
  "CampaignId": "{{Activity.Campaign.Id}}",
  "ExternalId": "{{Activity.ExternalId}}"
}

Bounceback activity fields

{
  "ActivityId": "{{Activity.Id}}",
  "ActivityType": "{{Activity.Type}}",
  "ActivityDate": "{{Activity.CreatedAt}}",
  "EmailAddress": "{{Activity.Field(EmailAddress)}}",
  "ContactId": "{{Activity.Contact.Id}}",
  "AssetType": "{{Activity.Asset.Type}}",
  "AssetName": "{{Activity.Asset.Name}}",
  "AssetId": "{{Activity.Asset.Id}}",
  "CampaignId": "{{Activity.Campaign.Id}}",
  "ExternalId": "{{Activity.ExternalId}}",
  "EmailRecipientId": "{{Activity.Field(EmailRecipientId)}}",
  "DeploymentId": "{{Activity.Field(EmailDeploymentId)}}",
  "SmtpErrorCode": "{{Activity.Field(SmtpErrorCode)}}",
  "SmtpStatusCode": "{{Activity.Field(SmtpStatusCode)}}",
  "SmtpMessage": "{{Activity.Field(SmtpMessage)}}"
}

WebVisit activity fields

{
  "ActivityId": "{{Activity.Id}}",
  "ActivityType": "{{Activity.Type}}",
  "ActivityDate": "{{Activity.CreatedAt}}",
  "ContactId": "{{Activity.Contact.Id}}",
  "VisitorId": "{{Activity.Visitor.Id}}",
  "VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
  "ReferrerUrl": "{{Activity.Field(ReferrerUrl)}}",
  "IpAddress": "{{Activity.Field(IpAddress)}}",
  "NumberOfPages": "{{Activity.Field(NumberOfPages)}}",
  "FirstPageViewUrl": "{{Activity.Field(FirstPageViewUrl)}}",
  "Duration": "{{Activity.Field(Duration)}}",
  "ExternalId": "{{Activity.ExternalId}}",
  "LinkedToContactDate": "{{Activity.Field(LinkedToContactDate)}}",
  "WebVisitSavedId": "{{Activity.Field(WebVisitSavedId)}}"
}

PageView activity fields

{
  "ActivityId": "{{Activity.Id}}",
  "ActivityType": "{{Activity.Type}}",
  "ActivityDate": "{{Activity.CreatedAt}}",
  "ContactId": "{{Activity.Contact.Id}}",
  "CampaignId": "{{Activity.Campaign.Id}}",
  "VisitorId": "{{Activity.Visitor.Id}}",
  "VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
  "WebVisitId": "{{Activity.Field(WebVisitId)}}",
  "Url": "{{Activity.Field(Url)}}",
  "ReferrerUrl": "{{Activity.Field(ReferrerUrl)}}",
  "IpAddress": "{{Activity.Field(IpAddress)}}",
  "IsWebTrackingOptedIn": "{{Activity.Field(IsWebTrackingOptedIn)}}",
  "ExternalId": "{{Activity.ExternalId}}",
  "LinkedToContactDate": "{{Activity.Field(LinkedToContactDate)}}",
  "PageViewSavedId": "{{Activity.Field(PageViewSavedId)}}",
  "CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
  "CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
}

FormSubmit activity fields

{
  "ActivityId": "{{Activity.Id}}",
  "ActivityType": "{{Activity.Type}}",
  "ActivityDate": "{{Activity.CreatedAt}}",
  "ContactId": "{{Activity.Contact.Id}}",
  "VisitorId": "{{Activity.Visitor.Id}}",
  "VisitorExternalId": "{{Activity.Visitor.ExternalId}}",
  "AssetType": "{{Activity.Asset.Type}}",
  "AssetId": "{{Activity.Asset.Id}}",
  "AssetName": "{{Activity.Asset.Name}}",
  "RawData": "{{Activity.Field(RawData)}}",
  "CampaignId": "{{Activity.Campaign.Id}}",
  "ExternalId": "{{Activity.ExternalId}}",
  "CampaignResponseDate": "{{Activity.CampaignResponse.CreatedAt}}",
  "CampaignResponseMemberStatus": "{{Activity.CampaignResponse.Field(MemberStatus)}}"
}

Activity field details

Field type Data type Max length Description
{{Activity.Id}} Integer (big Integer for page views) - The unique identifier of the activity per activity type, except for EmailSend

The activity ID is not unique across activity types, or for EmailSend.

{{Activity.Type}} String 100 The type of activity. The activity types are EmailOpen, EmailClickthrough, EmailSend, Subscribe, Unsubscribe, Bounceback, WebVisit, PageView, and FormSubmit.
{{Activity.CreatedAt}} Date/time stamp - The date and time of the activity
{{Activity.Field(EmailAddress)}} String 400 The email address of the contact who performed the activity
{{Activity.Contact.Id}} Integer - The ID of the contact who performed the activity
{{Activity.Field(EmailRecipientId)}} String 38 The recipient ID associated with an email activity

The recipient ID is present on every link in an email in the format of elq=GUID. At the time of sending the email, a GUID is generated and injected into the link. Learn more about the RecipientId.

{{Activity.Asset.Type}} String 100 The type of asset associated with the activity, such as email and form
{{Activity.Asset.Name}} String 100 The name of the asset associated with the activity
{{Activity.Asset.Id}} Integer - The ID of the asset associated with the activity
{{Activity.Field(SubjectLine)}} String 500 The subject line for an email activity
{{Activity.Field(EmailWebLink)}} String 1000 The link for viewing the email in a web browser window for an email activity
{{Activity.Campaign.Id}} Integer - The ID of the campaign associated with the activity
{{Activity.Campaign.Field(CRMCampaignId)}} String 100 The ID of the CRM campaign associated with the activity
{{Activity.Campaign.Field(CampaignName)}} String 100 The name of the campaign associated with the activity
{{Activity.Field(EmailDeploymentId)}} Integer - The ID of the email deployment for an email activity
{{Activity.Field(IpAddress)}} String 50 The IP address of the visitor who performed the activity
{{Activity.Visitor.Id}} Integer - The ID of the visitor who performed the activity
{{Activity.Visitor.ExternalId}} String 38 The GUID of the visitor who performed the activity
{{Activity.Field(EmailClickedThruLink)}} String 1000 The link clicked through for an EmailClickthrough activity
{{Activity.Field(RawData)}} String 64000 The raw data submitted with a FormSubmit activity. Includes the HTML field name and the submitted values in a query string format.
{{Activity.Field(ReferrerUrl)}} String 1000 The URL or form submission a PageView or WebVisit activity was referred from. Example form submission: "Form Submitted: <FormName>"
{{Activity.Field(WebVisitId)}} Integer - The ID of the WebVisit associated with a PageView activity
{{Activity.Field(Url)}} String 1000 The URL viewed with a PageView activity
{{Activity.Field(IsWebTrackingOptedIn)}} Boolean - Indicates if visitor who performed activity is opted-in to web tracking
{{Activity.Field(NumberOfPages)}} Integer - The number of pages viewed with a WebVisit activity
{{Activity.Field(FirstPageViewUrl)}} String 1000 The URL of the first page viewed in a WebVisit activity
{{Activity.Field(Duration)}} String (ISO-8601 Duration) 100 The duration of a WebVisit activity returned using the ISO-8601 standard for specifying durations
{{Activity.Field(EmailSendType)}} String 100 The type of email send for an email activity. Email send types are BatchWizard, Quicksend, SOAPAPI, Salestools, FormProcessingStep, DCOServicesStep, ExternalTest, TestCenter, Deliverability, LowVolumeAPI, and Campaign.
{{Activity.ExternalId}} String 20 The unique identifier of the activity across activity types
{{Activity.Field(SmtpErrorCode)}} String 9 The SMTP Status Code for the email bounceback
{{Activity.Field(SmtpStatusCode)}} String 3 The SMTP Response Code for the email bounceback
{{Activity.Field(SmtpMessage)}} String 510 The SMTP message for the email bounceback
{{Activity.Field(LinkedToContactDate)}} Date and time stamp - The date and time the visitor was linked to the contact
{{Activity.Field(WebVisitSavedId)}} Integer -- The unique identifier of the web visit session.
{{Activity.Field(PageViewSavedId)}} Integer -- The unique identifier of the page view.
{{Activity.CampaignResponse.CreatedAt}} Date/time stamp - The date and time the campaign response was created.
{{Activity.CampaignResponse.Field(MemberStatus)}} String 150 The status of the campaign member.

Related

Exporting activities

Activities export definitions