Skip to content

Column reference ​

Schema snapshot: 21 September 2026. Ini nama teknis yang dipakai SQL, bukan nama brand. Kolom nullable tidak otomatis menunjukkan bug; baca grain dan event contract.

raw_butics.events ​

ColumnBigQuery type
event_idSTRING
payloadSTRING
environmentSTRING
test_run_idSTRING
received_atTIMESTAMP

raw_butics.journeys ​

ColumnBigQuery type
bm_click_idSTRING
event_idSTRING
crm_utm_info_idINT64
generated_codeSTRING
environmentSTRING
test_run_idSTRING
created_atTIMESTAMP

raw_ga.events ​

ColumnBigQuery type
event_dateSTRING
event_timestampINT64
event_nameSTRING
event_paramsARRAY<STRUCT<key STRING, value STRUCT<string_value STRING, int_value INT64, float_value FLOAT64, double_value FLOAT64>>>
event_previous_timestampINT64
event_value_in_usdFLOAT64
event_bundle_sequence_idINT64
event_server_timestamp_offsetINT64
user_idSTRING
user_pseudo_idSTRING
privacy_infoSTRUCT<analytics_storage STRING, ads_storage STRING, uses_transient_token STRING>
user_propertiesARRAY<STRUCT<key STRING, value STRUCT<string_value STRING, int_value INT64, float_value FLOAT64, double_value FLOAT64, set_timestamp_micros INT64>>>
user_first_touch_timestampINT64
user_ltvSTRUCT<revenue FLOAT64, currency STRING>
deviceSTRUCT<category STRING, mobile_brand_name STRING, mobile_model_name STRING, mobile_marketing_name STRING, mobile_os_hardware_model STRING, operating_system STRING, operating_system_version STRING, vendor_id STRING, advertising_id STRING, language STRING, is_limited_ad_tracking STRING, time_zone_offset_seconds INT64, browser STRING, browser_version STRING, web_info STRUCT<browser STRING, browser_version STRING, hostname STRING>>
geoSTRUCT<city STRING, country STRING, continent STRING, region STRING, sub_continent STRING, metro STRING>
app_infoSTRUCT<id STRING, version STRING, install_store STRING, firebase_app_id STRING, install_source STRING>
traffic_sourceSTRUCT<name STRING, medium STRING, source STRING>
stream_idSTRING
platformSTRING
event_dimensionsSTRUCT<hostname STRING>
ecommerceSTRUCT<total_item_quantity INT64, purchase_revenue_in_usd FLOAT64, purchase_revenue FLOAT64, refund_value_in_usd FLOAT64, refund_value FLOAT64, shipping_value_in_usd FLOAT64, shipping_value FLOAT64, tax_value_in_usd FLOAT64, tax_value FLOAT64, unique_items INT64, transaction_id STRING>
itemsARRAY<STRUCT<item_id STRING, item_name STRING, item_brand STRING, item_variant STRING, item_category STRING, item_category2 STRING, item_category3 STRING, item_category4 STRING, item_category5 STRING, price_in_usd FLOAT64, price FLOAT64, quantity INT64, item_revenue_in_usd FLOAT64, item_revenue FLOAT64, item_refund_in_usd FLOAT64, item_refund FLOAT64, coupon STRING, affiliation STRING, location_id STRING, item_list_id STRING, item_list_name STRING, item_list_index STRING, promotion_id STRING, promotion_name STRING, creative_name STRING, creative_slot STRING, item_params ARRAY<STRUCT<key STRING, value STRUCT<string_value STRING, int_value INT64, float_value FLOAT64, double_value FLOAT64>>>>>
collected_traffic_sourceSTRUCT<manual_campaign_id STRING, manual_campaign_name STRING, manual_source STRING, manual_medium STRING, manual_term STRING, manual_content STRING, manual_source_platform STRING, manual_creative_format STRING, manual_marketing_tactic STRING, gclid STRING, dclid STRING, srsltid STRING>
is_active_userBOOL
batch_event_indexINT64
batch_page_idINT64
batch_ordering_idINT64
session_traffic_source_last_clickSTRUCT<manual_campaign STRUCT<campaign_id STRING, campaign_name STRING, source STRING, medium STRING, term STRING, content STRING, source_platform STRING, creative_format STRING, marketing_tactic STRING>, google_ads_campaign STRUCT<customer_id STRING, account_name STRING, campaign_id STRING, campaign_name STRING, ad_group_id STRING, ad_group_name STRING>, cross_channel_campaign STRUCT<campaign_id STRING, campaign_name STRING, source STRING, medium STRING, source_platform STRING, default_channel_group STRING, primary_channel_group STRING>, sa360_campaign STRUCT<campaign_id STRING, campaign_name STRING, source STRING, medium STRING, ad_group_id STRING, ad_group_name STRING, creative_format STRING, engine_account_name STRING, engine_account_type STRING, manager_account_name STRING>, cm360_campaign STRUCT<campaign_id STRING, campaign_name STRING, source STRING, medium STRING, account_id STRING, account_name STRING, advertiser_id STRING, advertiser_name STRING, creative_id STRING, creative_format STRING, creative_name STRING, creative_type STRING, creative_type_id STRING, creative_version STRING, placement_id STRING, placement_cost_structure STRING, placement_name STRING, rendering_id STRING, site_id STRING, site_name STRING>, dv360_campaign STRUCT<campaign_id STRING, campaign_name STRING, source STRING, medium STRING, advertiser_id STRING, advertiser_name STRING, creative_id STRING, creative_format STRING, creative_name STRING, exchange_id STRING, exchange_name STRING, insertion_order_id STRING, insertion_order_name STRING, line_item_id STRING, line_item_name STRING, partner_id STRING, partner_name STRING>>
publisherSTRUCT<ad_revenue_in_usd FLOAT64, ad_format STRING, ad_source_name STRING, ad_unit_id STRING>
event_original_occurrence_timestampINT64
export_suffixSTRING
property_idSTRING
environmentSTRING

staging_butics.stg_events ​

ColumnBigQuery type
schema_versionINT64
analytics_consentBOOL
collection_modeSTRING
event_idSTRING
environmentSTRING
test_run_idSTRING
received_atTIMESTAMP
occurred_atTIMESTAMP
anonymous_idSTRING
session_idSTRING
page_view_idSTRING
event_nameSTRING
page_keySTRING
page_entity_idSTRING
component_idSTRING
entity_idSTRING
whatsapp_click_idSTRING
ga_client_idSTRING
ga_session_idSTRING
config_versionINT64
positionINT64
interaction_triggerSTRING
destination_typeSTRING
depth_percentINT64
form_statusSTRING
directionSTRING
utm_sourceSTRING
utm_mediumSTRING
utm_campaignSTRING
utm_termSTRING
utm_contentSTRING

staging_butics.stg_whatsapp_references ​

ColumnBigQuery type
whatsapp_click_idSTRING
event_idSTRING
crm_utm_info_idINT64
generated_codeSTRING
environmentSTRING
test_run_idSTRING
created_atTIMESTAMP

staging_ga.stg_events ​

ColumnBigQuery type
environmentSTRING
property_idSTRING
stream_idSTRING
event_dateSTRING
occurred_atTIMESTAMP
event_nameSTRING
user_pseudo_idSTRING
ga_session_idINT64
bm_event_idSTRING
bm_anonymous_idSTRING
bm_session_idSTRING
bm_page_view_idSTRING
page_keySTRING
page_entity_idSTRING
component_idSTRING
engagement_time_msecINT64
page_locationSTRING
device_categorySTRING
browserSTRING
operating_systemSTRING
countrySTRING
regionSTRING
citySTRING
first_user_sourceSTRING
first_user_mediumSTRING
first_user_campaignSTRING
session_sourceSTRING
session_mediumSTRING
session_campaignSTRING
event_bundle_sequence_idINT64
batch_event_indexINT64
batch_page_idINT64
batch_ordering_idINT64
export_suffixSTRING

core_butics.dim_base_pages ​

ColumnBigQuery type
page_keySTRING
page_nameSTRING

core_butics.dim_base_components ​

ColumnBigQuery type
page_keySTRING
component_idSTRING
component_nameSTRING

core_butics.fact_base_events ​

ColumnBigQuery type
schema_versionINT64
analytics_consentBOOL
collection_modeSTRING
event_idSTRING
environmentSTRING
test_run_idSTRING
received_atTIMESTAMP
occurred_atTIMESTAMP
anonymous_idSTRING
session_idSTRING
page_view_idSTRING
event_nameSTRING
page_keySTRING
page_entity_idSTRING
component_idSTRING
entity_idSTRING
whatsapp_click_idSTRING
ga_client_idSTRING
ga_session_idSTRING
config_versionINT64
positionINT64
interaction_triggerSTRING
destination_typeSTRING
depth_percentINT64
form_statusSTRING
directionSTRING
utm_sourceSTRING
utm_mediumSTRING
utm_campaignSTRING
utm_termSTRING
utm_contentSTRING

core_butics.fact_base_page_visits ​

ColumnBigQuery type
environmentSTRING
anonymous_idSTRING
session_idSTRING
page_view_idSTRING
page_keySTRING
page_entity_idSTRING
test_run_idSTRING
first_event_atTIMESTAMP
last_event_atTIMESTAMP
viewed_atTIMESTAMP
event_countINT64

core_butics.fact_base_sessions ​

ColumnBigQuery type
environmentSTRING
anonymous_idSTRING
session_idSTRING
first_observed_atTIMESTAMP
last_observed_atTIMESTAMP
landing_pageSTRUCT<page_key STRING, page_entity_id STRING>
page_visit_countINT64
event_countINT64
observed_span_secondsINT64

core_butics.fact_base_whatsapp_references ​

ColumnBigQuery type
whatsapp_click_idSTRING
event_idSTRING
crm_utm_info_idINT64
generated_codeSTRING
environmentSTRING
test_run_idSTRING
created_atTIMESTAMP

core_butics.fact_enrichment_component_visits ​

ColumnBigQuery type
environmentSTRING
anonymous_idSTRING
session_idSTRING
page_view_idSTRING
component_idSTRING
entity_idSTRING
positionINT64
first_impression_atTIMESTAMP
impression_countINT64
click_countINT64
interaction_countINT64
has_observed_impressionBOOL

core_butics.fact_enrichment_page_visits ​

ColumnBigQuery type
environmentSTRING
anonymous_idSTRING
session_idSTRING
page_view_idSTRING
page_keySTRING
page_entity_idSTRING
test_run_idSTRING
first_event_atTIMESTAMP
last_event_atTIMESTAMP
viewed_atTIMESTAMP
event_countINT64
max_page_depthINT64
max_article_depthINT64
click_countINT64
form_success_countINT64
form_validation_error_countINT64
form_server_error_countINT64

core_butics.fact_enrichment_page_transitions ​

ColumnBigQuery type
environmentSTRING
anonymous_idSTRING
session_idSTRING
page_view_idSTRING
page_keySTRING
page_entity_idSTRING
test_run_idSTRING
first_event_atTIMESTAMP
last_event_atTIMESTAMP
viewed_atTIMESTAMP
event_countINT64
destination_page_keySTRING
destination_page_entity_idSTRING
next_page_atTIMESTAMP

core_butics.fact_attribution_session_campaigns ​

ColumnBigQuery type
environmentSTRING
anonymous_idSTRING
session_idSTRING
utm_sourceSTRING
utm_mediumSTRING
utm_campaignSTRING
utm_termSTRING
utm_contentSTRING
evidence_event_idSTRING
attribution_ruleSTRING

core_ga.dim_base_streams ​

ColumnBigQuery type
property_idSTRING
stream_idSTRING
environmentSTRING

core_ga.fact_base_events ​

ColumnBigQuery type
environmentSTRING
property_idSTRING
stream_idSTRING
event_dateSTRING
occurred_atTIMESTAMP
event_nameSTRING
user_pseudo_idSTRING
ga_session_idINT64
bm_event_idSTRING
bm_anonymous_idSTRING
bm_session_idSTRING
bm_page_view_idSTRING
page_keySTRING
page_entity_idSTRING
component_idSTRING
engagement_time_msecINT64
page_locationSTRING
device_categorySTRING
browserSTRING
operating_systemSTRING
countrySTRING
regionSTRING
citySTRING
first_user_sourceSTRING
first_user_mediumSTRING
first_user_campaignSTRING
session_sourceSTRING
session_mediumSTRING
session_campaignSTRING
event_bundle_sequence_idINT64
batch_event_indexINT64
batch_page_idINT64
batch_ordering_idINT64
export_suffixSTRING

core_ga.fact_base_sessions ​

ColumnBigQuery type
property_idSTRING
stream_idSTRING
user_pseudo_idSTRING
ga_session_idINT64
first_observed_atTIMESTAMP
last_observed_atTIMESTAMP
event_countINT64
page_view_countINT64
engagement_time_msecINT64

core_ga.fact_enrichment_event_context ​

ColumnBigQuery type
environmentSTRING
property_idSTRING
stream_idSTRING
event_dateSTRING
occurred_atTIMESTAMP
event_nameSTRING
user_pseudo_idSTRING
ga_session_idINT64
bm_event_idSTRING
bm_anonymous_idSTRING
bm_session_idSTRING
bm_page_view_idSTRING
page_keySTRING
page_entity_idSTRING
component_idSTRING
engagement_time_msecINT64
page_locationSTRING
device_categorySTRING
browserSTRING
operating_systemSTRING
countrySTRING
regionSTRING
citySTRING
first_user_sourceSTRING
first_user_mediumSTRING
first_user_campaignSTRING
session_sourceSTRING
session_mediumSTRING
session_campaignSTRING
event_bundle_sequence_idINT64
batch_event_indexINT64
batch_page_idINT64
batch_ordering_idINT64
export_suffixSTRING

core_ga.fact_enrichment_session_context ​

ColumnBigQuery type
property_idSTRING
stream_idSTRING
user_pseudo_idSTRING
ga_session_idINT64
landing_pageSTRING
device_categorySTRING
browserSTRING
operating_systemSTRING
countrySTRING

core_ga.fact_attribution_first_user_acquisition ​

ColumnBigQuery type
property_idSTRING
user_pseudo_idSTRING
first_user_sourceSTRING
first_user_mediumSTRING
first_user_campaignSTRING

core_ga.fact_attribution_session_acquisition ​

ColumnBigQuery type
property_idSTRING
stream_idSTRING
user_pseudo_idSTRING
ga_session_idINT64
session_sourceSTRING
session_mediumSTRING
session_campaignSTRING
ColumnBigQuery type
event_idSTRING
environmentSTRING
anonymous_idSTRING
session_idSTRING
page_view_idSTRING
property_idSTRING
stream_idSTRING
user_pseudo_idSTRING
ga_session_idINT64
ga_event_nameSTRING
ColumnBigQuery type
environmentSTRING
anonymous_idSTRING
session_idSTRING
property_idSTRING
stream_idSTRING
user_pseudo_idSTRING
ga_session_idINT64
linked_event_countINT64
ColumnBigQuery type
environmentSTRING
whatsapp_click_idSTRING
event_idSTRING
crm_utm_info_idINT64
generated_codeSTRING
message_idSTRING
crm_session_idSTRING
yellow_user_idSTRING
chat_timeDATETIME
match_methodSTRING
ColumnBigQuery type
environmentSTRING
yellow_user_idSTRING
customer_idSTRING
identity_match_methodSTRING
identity_confidence_levelSTRING

core_master_analytics.fact_enrichment_customer_touchpoints ​

ColumnBigQuery type
event_idSTRING
environmentSTRING
anonymous_idSTRING
session_idSTRING
occurred_atTIMESTAMP
event_nameSTRING
page_keySTRING
component_idSTRING
customer_idSTRING
whatsapp_click_idSTRING
crm_session_idSTRING

core_master_analytics.fact_enrichment_order_context ​

ColumnBigQuery type
company_nameSTRING
transaction_numberSTRING
customer_idSTRING
paid_atTIMESTAMP
is_paidBOOL
is_refundedBOOL
order_revenueFLOAT64
total_paymentFLOAT64
transaction_typeSTRING
clinic_codeSTRING
crm_session_idsARRAY<STRING>
source_environmentSTRING

core_master_analytics.fact_attribution_conversion_credits ​

ColumnBigQuery type
conversion_touchpoint_credit_idSTRING
conversion_idSTRING
company_nameSTRING
transaction_numberSTRING
customer_idSTRING
crm_session_idSTRING
session_touchpoint_idSTRING
paid_atTIMESTAMP
channel_sourceSTRING
channel_mediaSTRING
channel_campaign_identifierSTRING
first_touch_creditFLOAT64
last_touch_creditFLOAT64
last_non_crm_creditFLOAT64
linear_creditFLOAT64
early_touch_decay_creditFLOAT64
first_touch_revenueFLOAT64
last_touch_revenueFLOAT64
last_non_crm_revenueFLOAT64
linear_revenueFLOAT64
early_touch_decay_revenueFLOAT64
attribution_sourceSTRING

Bumame Engineering · Butics — Butech Analytics