Response event feed layout sample

System of Record Name

sor_name

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

char(100)

 "Source ESP Name"

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

N/A

Rp Event ID

rp_event_id

Uniquely identifies response event within RPI.

number

N/A

Client Campaign Event ID

client_campaign_event_id

(Required) 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.

char(150)

"80500abb-b102-4334-94f5-5e9587b69454"

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)

"5355d603-5e86-4ee1-8864-360361fe1f75"

Response Event Datetime

response_event_datetime

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

datetime

2023-12-20 21:26:36

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.

char(100)

"email"

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).

char(50)

"opened"

Destination URL Address

destination_url_address

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

char(4000)

N/A

Referral URL Address

referral_url_address

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

char(4000)

N/A

Search Keyword Text

search_keyword_text

Search keyword captured.

char(100)

N/A

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

N/A

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

N/A