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 |
0 Comments