Столбцы

Таблицы содержат следующие столбцы.

Google BigQuery заголовок Google BigQuery тип данных
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 из 0
Еще есть вопросы? Отправить запрос

0 Комментарии

Войдите в службу, чтобы оставить комментарий.