Response event feed layout sample

The following table provides sample values for the feed layout definition.

Required fields are marked as (Required) in the field description column; fields not marked as required are optional.

Business name	Field name	Description	Field data type/length	Sample value
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`
Rp Event ID	`rp_event_id`	Uniquely identifies response event within RPI.	`number`
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)`
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)`
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`