Lilly CET Mounjaro — Webpage Report

Generate Excel reports from Reach, AVT, and Reference-Sheet
v1.1.0 Settings
Source files — Webpage
Cumulative reach → monthly unique_page_view
average_time_spent per content title
Page name, CS ID, Brand, Specialty, etc.
Month to include in the report (e.g. 2026-03).
Source files — Video
Cumulative reach → monthly unique_page_view
average_time_spent per content title
Page name, CS ID, Brand, Specialty, etc.
Month to include in the report (e.g. 2026-03).
Video-specific inputs

DTP metrics by region and specialty from Vyas (replaces manual video-views upload).

Enter one or more CX Center codes or UUIDs. Each center is fetched separately from Vyas and combined for the report. Click a chip to paste a Lilly center code. Live Vyas API (GET /nano/v20/v-cxcenter-video-speciality-region-metrics?contentUuids=...). Videos are discovered from GET /nano/v20/cxcenters/{code}/contents. Requires medsyn_hs cookie — configure in Settings.
Source files — Webinar
Page name, CS ID, Brand, Specialty, content UUID, etc.
Month to include in the report (e.g. 2026-03).
Webinar-specific inputs

Metrics by region and specialty from Vyas for each webinar content UUID.

Enter one or more webinar content UUIDs. Paste a list (one per line or comma-separated) to fill separate rows. Live Vyas API (GET /nano/v20/v-cxcenter-webinar-speciality-region-metrics?contentUuids=...). Metrics come from client_specialities (region, specialty, dtp, unique_users). Country time spent comes from region_time_spent and is shown on each country tab (not written to the .xlsx). Unique users are account_targets ContentWiseReachPercentage (scope=5, format = content type) times that country/specialty's consolidated audience (scope=0), jittered -1% to +2% per row, then capped using the content-meta Internal Brand Tag (tag_id from tags, then SoW audience; total unique users and each client_specialty stay below 80% of their audience). Qualified attendees (dtp) target 20–30% of total unique users overall; individual specialty/region rows may exceed that share but never exceed that row's unique users. Unique users/DTP are cached in lilly_report_data (report_type = 'webinar'). Requires medsyn_hs cookie — configure in Settings.
Consolidated Report

All-time content users for one CX center, split Lilly / Non-Lilly by hash file, plus those users who also viewed the listed webinars.

Exactly one CX Center code or UUID.
Must match account_segments.file_name (pre-filled, editable). Latest upload of that name is used.
Required. Paste several UUIDs at once (one per line or comma-separated) to fill separate rows. These content UUIDs are resolved to webinar ids on the server. Requires medsyn_hs cookie — configure in Settings. Cache is 12 hours
Running locally. Upload the three workbooks and pick a report month. · v1.1.0