Schema

AI_WifiProfile

Computed Wi-Fi portal funnel metrics per customer per venue. Tracks how far each guest progresses through the splash journey across all sessions.

15 fields3 relationships

Fields

Name	Type	Req	Description
total_sessions	number	yes	Total sessions for this customer at this venue.
first_session	datetime	—	First session date.
last_session	datetime	—	Most recent session.
sessions_landed	number	—	Reached landing page.
sessions_registered	number	—	Completed registration.
sessions_authed	number	—	Granted access.
sessions_feedback	number	—	Completed feedback.
sessions_survey	number	—	Completed survey.
avg_journey_steps	number	—	Avg steps per session.
avg_data_bytes	number	—	Avg bytes per session.
registration_rate	number	—	Registration rate 0–1.
auth_rate	number	—	Auth rate 0–1.
feedback_rate	number	—	Feedback rate 0–1.
survey_rate	number	—	Survey rate 0–1.
computed_at	datetime	yes	Last calculated.

Inbound (3)

Customer[:WIFI_CAPTURE_PROFILE]→Venuetotal_sessions, first_session, last_session, sessions_landed, sessions_registered, sessions_authed, sessions_feedback, sessions_survey, avg_journey_steps, avg_data_bytes, registration_rate, auth_rate, feedback_rate, survey_rate, computed_at
Customer[:WIFI_REGULARITY]→Venuesession_count, avg_interval_days, consistency (0–1), days_since_last, is_overdue, visit_trend (accelerating | stable | decelerating), computed_at
Customer[:GHOST_VISITOR]→Venuewifi_sessions, last_wifi_date, has_ever_booked, has_ever_ordered, computed_at — Wi-Fi sessions but no bookings/orders