Siebel Marketing Installation and Administration Guide > Installing and Configuring Email Marketing >

Configuring the Status of Email Addresses


This topic describes how to configure the status of email addresses. Table 21 lists the email status columns which were added to the S_CONTACT table to track details about email addresses. These fields are automatically updated by the Siebel Email Marketing Server processes when an email bounce result or response record is logged for a contact.

Table 21. Email-Related Columns in the S_CONTACT Table
Column Name
Data Type
Description

EMAIL_STATUS_CD

VARCHAR(30)

Shows the current status of the email address. LOV values are Bad Address, Undeliverable, Valid, First Opt in, Confirmed Opt in.

LST_EMLADR_UPD_TS

TIMESTAMP

Shows the date and time of the last update to the email fields.

NUM_HARD_BNCE

NUMERIC(10,0)

Number of hard bounces that have been received for the email address.

NUM_SOFT_BNCE

NUMERIC(10,0)

Number of soft bounces that have been received for the email address.

You can configure the circumstances in which the status of a contact's email address is set to Bad Address or Undeliverable in the EMAIL_STATUS_CD field. The email address for a contact is set to a status of Bad Address if the number of hard bounces logged for the address exceeds a defined threshold and is set to a status of Undeliverable if the number of soft bounces logged for the email address exceeds a defined threshold. To configure the value of this threshold, perform the steps in the following procedure.

To configure how the email address status is determined

  1. Navigate to the Administration - Business Process screen, Workflow Policies, and then the Policies view.
  2. In the Policies list, query for the Update Contact Email Status object in the Workflow Object field.
  3. Select either the Update Contact Email Hard Bounce Status policy or the Update Contact Email Soft Bounce Status policy.
  4. Scroll down to the Conditions list, then enter a number in the Value field, for example, 10.

    The number you enter becomes the threshold used to determine when a contact's email address is assigned a status of Bad Address (hard bounces) or Undeliverable (soft bounces).

Siebel Marketing Installation and Administration Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.