Response event feed layout definition

System of Record Name

sor_name

Name of the system that is the authoritative data source for a record. 

char(100)

Rp Contact Id

rp_contact_id

Uniquely identifies marketing campaign event within RPI that the response event is related to.  To support response attribution, this value is used to link a response event to a promotion event.

number

Rp Event Id

rp_event_id

Uniquely identifies response event within RPI.

number

Client Campaign Event ID

client_campaign_event_id

(Required) This field is the natural primary key (plus source_id from the API feed configuration; must match source that the campaign event comes from).

Uniquely identifies marketing campaign event the response event is related to. To support response attribution, this value is used to link a response event to a promotion event.

This field is used in aggregate calculations.

char(150)

Client Response Event ID

client_response_event_id

(Required) Uniquely identifies a response event for the identity ID listed below in the system of record.  

char(150)

Response Event Datetime

response_event_datetime

(Required) Response Datetime: YYYY-MM-DD HH:mm:ss.

This field is used in aggregate calculations.

datetime

Channel Code

channel_code

Uniquely identifies a communication channel used for response such as direct mail, email, phone, social media, web, mobile, call center, display media, etc.

Values are defined as part of on-boarding, in CHANNEL_LOOKUP. Refer to Channel for details.

char(100)

Event Disposition Code

event_disposition_code

(Required) Uniquely identifies a disposition code for phone (wrong number, not valid phone, etc.), for direct mail (mail returned, undeliverable as addressed, etc.), or for email (hard bounce, soft bounce, opened, click through, delivered).

Values are defined as part of on-boarding, in EVENT_DISPOSITION_LOOKUP. Refer to Event disposition for details.

This field is used in aggregate calculations.

char(50)

Destination URL Address

destination_url_address

A destination URL is the address of the webpage people reach when they click on the ad.

char(4000)

Referral URL Address

referral_url_address

The address of the webpage where a person clicked a link that sent them to the destination page. The referrer is the webpage that sends visitors to your site using a link.

char(4000)

Search Keyword Text

search_keyword_text

Search keyword captured.

char(100)

Source Record Create Datetime

source_rec_create_datetime

The datetime when the record was created at source system (YYYY-MM-DD HH:mm:ss). 

datetime

Source Record Update Datetime

source_rec_update_datetime

The datetime of the latest update of the record at source system (YYYY-MM-DD HH:mm:ss).

datetime