Grab free access to all the OWOX BI features for 14 days

Columns

The columns within the table are listed below.

Google BigQuery alias Google BigQuery data type
type STRING
customer_id INTEGER
event_id INTEGER
subaccount_id INTEGER
timestamp TIMESTAMP
event_category STRING
batch_id STRING
message_event RECORD
message_event.bounce_class INTEGER
message_event.campaign_id STRING
message_event.delv_method STRING
message_event.device_token STRING
message_event.error_code INTEGER
message_event.friendly_from STRING
message_event.ip_address STRING
message_event.message_id STRING
message_event.msg_from STRING
message_event.msg_size INTEGER
message_event.num_retries INTEGER
message_event.rcpt_meta RECORD
message_event.rcpt_meta.var_name STRING
message_event.rcpt_meta.var_value STRING
message_event.rcpt_tags STRING
message_event.rcpt_to STRING
message_event.raw_rcpt_to STRING
message_event.rcpt_type STRING
message_event.raw_reason STRING
message_event.reason STRING
message_event.routing_domain STRING
message_event.sms_coding STRING
message_event.sms_dst STRING
message_event.sms_dst_npi STRING
message_event.sms_dst_ton STRING
message_event.sms_src STRING
message_event.sms_src_npi STRING
message_event.sms_src_ton STRING
message_event.subject STRING
message_event.template_id STRING
message_event.template_version INTEGER
message_event.transmission_id INTEGER
message_event.queue_time INTEGER
message_event.sms_remoteids STRING
message_event.sms_segments INTEGER
message_event.sms_text STRING
message_event.dr_latency FLOAT
message_event.stat_type STRING
message_event.stat_state STRING
message_event.fbtype STRING
message_event.report_by STRING
message_event.report_to STRING
message_event.user_str STRING
message_event.remote_addr STRING
track_event RECORD
track_event.campaign_id STRING
track_event.delv_method STRING
track_event.ip_address STRING
track_event.message_id STRING
track_event.rcpt_meta RECORD
track_event.rcpt_meta.var_name STRING
track_event.rcpt_meta.var_value STRING
track_event.rcpt_tags STRING
track_event.rcpt_to STRING
track_event.raw_rcpt_to STRING
track_event.rcpt_type STRING
track_event.target_link_name STRING
track_event.target_link_url STRING
track_event.template_id STRING
track_event.template_version INTEGER
track_event.transmission_id INTEGER
track_event.user_agent STRING
track_event.geo_ip RECORD
track_event.geo_ip.country STRING
track_event.geo_ip.region STRING
track_event.geo_ip.city STRING
track_event.geo_ip.latitude STRING
track_event.geo_ip.longitude STRING
gen_event RECORD
gen_event.campaign_id STRING
gen_event.error_code STRING
gen_event.friendly_from STRING
gen_event.rcpt_meta RECORD
gen_event.rcpt_meta.var_name STRING
gen_event.rcpt_meta.var_value STRING
gen_event.rcpt_subs RECORD
gen_event.rcpt_subs.var_name STRING
gen_event.rcpt_subs.var_value STRING
gen_event.rcpt_tags STRING
gen_event.rcpt_to STRING
gen_event.raw_rcpt_to STRING
gen_event.raw_reason STRING
gen_event.reason STRING
gen_event.routing_domain STRING
gen_event.subject STRING
gen_event.template_id STRING
gen_event.template_version INTEGER
gen_event.transmission_id INTEGER
unsubscribe_event RECORD
unsubscribe_event.campaign_id STRING
unsubscribe_event.friendly_from STRING
unsubscribe_event.mailfrom STRING
unsubscribe_event.message_id STRING
unsubscribe_event.rcpt_meta RECORD
unsubscribe_event.rcpt_meta.var_name STRING
unsubscribe_event.rcpt_meta.var_value STRING
unsubscribe_event.rcpt_tags STRING
unsubscribe_event.rcpt_to STRING
unsubscribe_event.raw_rcpt_to STRING
unsubscribe_event.rcpt_type STRING
unsubscribe_event.template_id STRING
unsubscribe_event.template_version STRING
unsubscribe_event.transmission_id INTEGER
unsubscribe_event.user_agent STRING
relay_event RECORD
relay_event.rcpt_to STRING
relay_event.raw_rcpt_to STRING
relay_event.msg_size INTEGER
relay_event.routing_domain STRING
relay_event.msg_from STRING
relay_event.raw_reason STRING
relay_event.reason STRING
relay_event.error_code INTEGER
relay_event.relay_id STRING
relay_event.remote_addr STRING
relay_event.queue_time INTEGER
relay_event.num_retries INTEGER
relay_event.delv_method STRING
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.