MDW Batch Event Table Spec: batch_event
batch_event
Term | Definition | Datatype |
date_time | Timestamp | timestamp |
rmc_cookie_id | Third Party Cookie ID | varchar(4000) |
ip_address | Masked IP Address | varchar(4000) |
channel_id | Not being used currently | varchar(4000) |
col5 | Referrer | varchar(65000) |
col6 | Landing Page | varchar(65000) |
url | Original copy of the information Measured Tag Captures | varchar(65000) |
user_agent | Standard Browser user agent | varchar(4000) |
language_encoding | Optional internal field | varchar(4000) |
col10 | Optional internal field | varchar(4000) |
cookie_response | Third Party Cookie ID | varchar(4000) |
batch_id | Batch ID of the file | varchar(4000) |
cohort_type | Test or Control information for Measured Retargeting DOE | varchar(4000) |
semantic_seg | URL encoded page URL | varchar(4000) |
event_name | Defaulted to url path | varchar(4000) |
rmc_segment_id | Cohort assignment segment ID | varchar(4000) |
v_pixels | Vendor pixels | varchar(4000) |
ga_uid | Google analytics cookie ID | varchar(4000) |
revenue | Revenue of transaction | varchar(4000) |
ga_custid | Optional internal field | varchar(4000) |
margin | Transaction related field | varchar(4000) |
order_id | Order ID of the transaction | varchar(4000) |
order_skus | Order category | varchar(4000) |
rmc_event_category | Event category | varchar(4000) |
cohort | Cohort name | varchar(4000) |
hashed_id | Hashed email ID | varchar(4000) |
cust_id | Customer ID | varchar(4000) |
create_dttm | Timestamp of the request | Timestamp |
doe_id | Brand DOE ID | varchar(4000) |
opt_out | Opted out user | varchar(4000) |
