Overview
This document describes the standard fields available within the EVENT and CAMPAIGN tables in Marigold's Engagement Data Platform (EDP).
Event Table
The EVENT table is used to store information about Events. An Event in EDP is conceptually similar to an Activity in that it represents some action or behavior that the consumer takes, and that the platform is able to capture and track. An Event is essentially a lightweight, high- volume version of an Activity that's used mainly for reporting and auditing purposes.
Field Name | Spec | Description | Sample |
environment_id |
number |
Customer identifier |
100 |
organization_id |
number |
Sub Customer Identifier |
100383 |
member_id |
string |
Member Identifier |
K-020981645 |
integration_id |
string |
Event Identifier To identify a send record |
8227927:100:1752025474 |
event_ts |
datetime |
Datetime the event occured |
2020-04-16T20:27:44.844Z |
local_tz |
string |
Timezone ID for the event |
Etc/UTC |
camp_id |
number |
Campaign identifier |
17271 |
camp_name |
string |
Campaign name |
20200416-FPS-FiletLob |
channel_type_name |
string |
Channel used by the campaign |
Email Message |
campaign_type_name |
string |
Campaign type used. Either one-time, date triggered or event triggered |
Regular (one-time) |
content_body_type_name |
string |
Content type the event is clicked on. Either HTML or Text. This is only applicable for click event. |
HTML |
content_id |
number |
Content Id the event is clicked on. This is only applicable for click event. |
237323 |
content_name |
string |
Content Name the event is clicked on. This is only applicable for click event. |
MahiFamilyBundle_CONTENT |
user_agent_raw |
string |
User Agent String for the open or click event. This is only applicable for click and open event |
Mozilla/5.0 (iPhone; CPU iPhone OS 13_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 |
ip_address |
string |
IP address for the open or click event. This is only applicable for click and open event |
10.24.71.6 |
click_link_url |
string |
URL Link of the click event. This is only applicable for click event |
https://infini.core.windows.net/menu/ |
click_link_name |
string |
URL Link Name of the click event. This is only applicable for click event |
Link 02 - /menu/FamilyBundles-r3.pdf |
click_link_tags |
JSON |
Link tags applied to the link. This is only applicable for click event. |
["20PercentOff", "3Course", "BloodyMaryMiniBar", "in-store", "Reservations", "ThrowbackThursday"] |
category_name |
string |
Category applied to the link. This is only applicable for click event. |
|
web_event_id |
number |
Web event indentifier to the web event it refers to. Only applicable for bounce event. |
1 |
web_event_url_referrer |
string |
URL the web event refers from. Only applicable for bounce event. |
https://infini.com/pysearch?q=best+ev er+bread+pudding+5+stars&wunv=2 |
bounce_category_hard_bou nce |
string |
Is this bounce event hard bounce. Only applicable for bounce event. |
FALSE |
params_number |
JSON |
list of number paramaters for the event. |
"{ ""bounce_type_id"":2500, ""base_cont_id"":182813 ""is_precache_open""=1 }" |
params_string |
JSON |
list of string paramaters for the event. |
"{ ""Bus_Unit"":""search"", ""Device"":""MOBILE"", ""Type"":""search"" ""precache_group"":""Apple"" /*or ""yahoo"" or ""google"" */ }" |
params_date |
JSON |
list of date paramaters for the event. |
|
params_json |
JSON |
list of all paramaters for the event. All data type applied. |
"{ ""bounce_type_id"":2500, ""base_cont_id"":182813, ""Bus_Unit"":""search"", ""Device"":""MOBILE"", ""Type"":""search"" }" |
send_time |
datetime |
Date and Time the event is sent. For Send event, event_ts is the same as send_time. |
2020-04-16T20:27:44.844Z |
business_unit |
string |
The business unit name the event is sent from. It refers to a sub customer name. |
AFG |
time_partition |
string |
Index field for the table. Time partition record the year and month. YYYY-MM |
2020-04 |
event_type |
string |
The type of event. send, open, click, bounce, unsubscribe, web, inbound |
send |
Campaign Table
The CAMPAIGN table is used to store information about Engage+ Campaigns.
Field Name | Spec | Description | Sample |
organization_id |
number |
Customer identifier |
100000 |
environment_id |
number |
Sub Customer Identifier |
100 |
campaign_id |
number |
Campaign identifier |
17536 |
campaign_name |
string |
Campaign name |
Nation Fest |
campaign_type |
string |
Campaign type used. Either one-time, date triggered or event triggered |
Regular (one-time) |
content_type |
string |
Content type the event is clicked on. Either HTML or Text. This is only applicable for click event. |
HTML |
channel |
string |
Channel used by the campaign |
Email Message |
tags |
JSON |
Campaign tags applied to the campaign. |
["national", "nascar"] |
params_number |
JSON |
list of number paramaters for the campaign |
"{ ""base_content_id"":235000, ""content_id"":235685, ""filter_id"":276395, ""base_filter_id"":275385 }" |
params_string |
JSON |
list of string paramaters for the campaign |
"{ ""subject_line"":""{[FinalEaster_DYN_S ubj|235024]}"", ""folder"":""/My Files/Campaigns/Bulk/2020/National/ "", ""filter_name"":""20200411-FPS- FinalEaster_Audience"" }" |
params_date |
JSON |
list of date paramaters for the campaign |
|
params_json |
JSON |
list of all paramaters for the campaign. All data type is applied. |
"{ ""base_content_id"":235000, ""content_id"":235685, ""filter_id"":276395, ""base_filter_id"":275385, ""subject_line"":""{[FinalEaster_DYN_S ubj|235024]}"", ""folder"":""/My Files/Campaigns/Bulk/2020/National/ "", ""filter_name"":""20200411-FPS- FinalEaster_Audience"" }" |
meta_data_number |
JSON |
list of number metadata for the campaign |
"{ ""price"": null }" |
meta_data_string |
JSON |
list of string metadata for the campaign |
"{ ""category_subtype"":""Manual "", ""utm_campaign_name"":""Halloween- Fallback"", ""message_type"":""light-personalized "", ""category"":""National"", ""primary_message"":""Holiday "", ""utm_medium"":""email-instore"" }" |
meta_data_date |
JSON |
list of date metadata for the campaign |
|
meta_data_json |
JSON |
list of all metadata for the campaign. All data type is applied. |
"{ ""price"": null, ""category_subtype"":""Manual "", ""utm_campaign_name"":""Halloween- Fallback"", ""message_type"":""light-personalized "", ""category"":""National"", ""primary_message"":""Holiday "", ""utm_medium"":""email-instore"" }" |
send_start_ts |
datetime |
The date and time the campaign is launched. |
2020-04-16T20:27:44.844Z |
end_tz |
string |
The timezone for the campaign is launched |
Etc/UTC |