Data Dictionary

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

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