Schema Overview
RAW LAYER
raw_listings
raw_web_sessions
→
DIMENSIONS
dim_property
dim_region
dim_date
dim_listing_type
dim_price_tier
dim_device
dim_traffic_source
dim_geography
dim_consent
→
FACTS
fact_listings
fact_booking_events
fact_web_sessions
→
MART / ML
mart_ml_features
mart_regional_summary
mart_seo_pages
mart_gtm_tags
vw_regional_opportunity
vw_consent_compliance
vw_channel_performance
Table Details — click to expand
Key Metrics
25+
Tables & Views
1,011
Listings
28,628
Booking Events
30,000
Web Sessions
114
Regions
africa-south1
BigQuery Region