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