Performance overview
Website figures are live from GA4 and respond to every filter above. The paid half stays empty until the new program launches, which is the agreed behaviour rather than a data fault.
Paid search
Prior SEM program, June 2025 to March 2026, responding to the date filter only. In production this tab renders nothing before the launch date.
Keywords
A separate query at grain='keyword' that never contributes to a headline total. Keyword totals are period-wide and do not respond to the date filter in this skeleton.
| Keyword | Impr | Clicks | CTR | Cost | CPC |
|---|
Website behavior
All figures respond to every filter. Scoped to an allowlist of the ten genuine ME domains, because the hostname field carries tens of thousands of referrer-spam hosts that would otherwise inflate every total. See Open Gaps.
Conversions and CTAs
Scoped to what survives the mapping audit. Two verified conversions plus the CTA intent layer standing in for the appointment funnel.
Open gaps
Everything here needs resolving before the dashboard goes to the client. Each is currently handled by showing nothing rather than a wrong number.
Appointment funnel absent from temp_me
The four appointment events are in Funnel but not in the five-event curated pivot. This is the outcome layer the client is asking for.
Three conversion columns measure the wrong thing
appointments_scheduled maps to navigation_open and counts nav menu opens. consultation_requests maps to search_result_conversion and is not MyChart. find_a_doctor maps to a renamed event and has returned 0 since May 2026.
The hostname field is contaminated with referrer spam
Verified 11 Sep 2026. August alone carries 59,029 distinct hostnames. The ten real ME domains account for 1,041,554 sessions; a further 375,362 sit beyond rank 50 on hosts Montefiore does not own. A sample of ranks 60 to 80: wallpapers.com, mubasher.info, mail.hotpepper.jp, istockphoto.com, islamicfinder.org, etrailer.com.
Any site-wide session total from this table is inflated by roughly 25%. August reads 1,491,069 but real ME traffic is nearer 1.08M. This dashboard uses an allowlist of the ten genuine properties, which is why its totals are lower than a naive query.
engaged_sessions is unusable
Exceeds sessions on 24,146 rows in August alone, maximum 45,142 engaged against maximum 3,542 sessions at the same grain. Engagement rate cannot be computed.
Average session duration looks too high
August computes to 9 minutes 48 seconds per session. total_session_duration_sec is likely scoped differently, same as engaged_sessions.
Conversions cannot be filtered by domain
The conversions table has brand but no hostname. Splitting the three montefiore-brand domains apart needs a hostname column upstream.
Paid launch date not set
Built against a placeholder constant. Setting it changes the default range and the start of every paid view.
Careers domain still included
montefiore.wd12.myworkdayjobs.com is job seekers, not patients. Filterable here, but it should probably be excluded at the query level.