Email tracking data available as an event

The following table lists the email tracking data that can be downloaded from UBX Toolkit to Unica Campaign.

Engage supports specific email events that provide tracking data for email messaging. Engage makes this data available as UBX events. You use UBX Toolkit to download the event data to Unica Campaign and load it into response tracking tables for Unica Campaign consumption. The Event name might differ between mailings. The Event code must appear in the tracking data exactly as shown.

Information from the Mailing - sent event and the Mailing - bounced event is processed to populate the Detailed contact history. These events are processed for different audience level history tables based on the audienceID.

Information from the Mailing - open event and Mailing - clicked event is processed to populate the Response history. These events are processed for different audience level history tables based on the audienceID.

Information from the mailing: opt-out event . WCA customers can receive opt-out links for opting out of WCA mailing, in the emails delivered to them, This event is now tracked by Unica Campaign via UBX. The Mailing Opt-Out Event (emailOptOut) is being tracked in the Unica Campaign system database in a new table called UA_EMAILOPTOUT

Email Opt-Out requirement from WCA - To track the email opt-out event, users must have an email template containing the 'Email OptOut' hyperlink of Type: Opt-out Email. The complete flow of opt-out events are as follows.1.The User receives the email with OptOut link.2. The User opens the email with OptOut link and click on the link.3. A reply email message to WCA is opened which the user will have to send back to WCA.4. After this email is sent respective contact is marked as ‘OptedOut’ in the WCA database .5. WCA Publishes the Mailing OptOut Event (emailOptOut) event to UBX .6. Unica Campaign downloads the events published to UBX to Unica Campaign system table "UA_EMAILOPTOUT".Note:At present emailOptOut event is not included in the ETL to Unica Campaign contact/detail history and response history tables. Offer Tracking code is not populating in email Optout events.

The following events are picked up by ETL tool and transferred in the history tables:
  • Mailing - sent event and Mailing - bounced event to populate Detailed contact history.
  • Mailing - open event and Mailing - clicked event to populate in Response History.
Table 1. Email tracking events through UBX
Event name Event code Unica Campaign system table
Mailing - sent emailSend UA_EmailSend
Mailing - opened emailOpen UA_EmailOpen
Mailing - clicked emailClick UA_EmailClick
Mailing - bounced emailBounce UA_EmailBounce
Mailing - optedout emailOptOut UA_EmailOptOut