Cogo Nation — LENS Dashboard Index

Data freshness

Numbers show how old the server cache is (when the blob was last built). TV dashboards still poll the API every 60s — they just receive the same payload until the next sync runs. This index page rechecks every 60s while open.

LAS sales (Snowflake)

GET /api/lasSalesData?period=wtd

checking…

Cache rebuild: pre-aggregated blob is replaced when /api/lasSalesSync runs (HTTP trigger — ops or your scheduler; no fixed interval shipped in this repo). Board refresh: LAS Snowflake TV boards refetch every 60s.

RingCentral

GET /api/ringcentralData?period=today

checking…

Cache rebuild: rolling blob is refreshed when /api/ringcentralSync runs (HTTP trigger; incremental sync with a time overlap in the API implementation). Board refresh: RC TV boards refetch every 60s.

HubSpot-backed boards (cert sales, lead management) query live on each page load and are not represented above. Cert “current week” does not auto-refresh after load unless you reload the tab.

COGO NATION

LENS — Dashboard Index

Visibility layer for TV walls (1920×1080) and browsers. Open a card for the full dashboard.

Internal · OptiSigns / web
Azure Static Web Apps + API

How this page is organized

Sales collected (LAS) — Snowflake-backed certification collections: scoreboards, goals across periods, and channel mix (some views include RingCentral pacing).

Cert product sales — HubSpot deals for BCP, CFCP, CMI/REO vs weekly goals.

Call activity — RingCentral dials, answer rates, talk time, SMS by rep (LAS ~17 reps; Cogo ~9).

Lead management — HubSpot CRM Search for speed-to-lead and pipeline health by BDC.

Each card lists a goal (why to open it) and what you see (what is on screen). Tags call out data source and primary surface.

LAS sales — certification collections Snowflake → pre-aggregated API cache · primary TV boards for LAS revenue

BDC-level collected dollars, weekly targets, and pacing. WTD and Last Week use the same layouts with different period slices from /api/lasSalesData.

BDC scoreboard (leaderboard + hero KPIs)

Ranked reps, two-column board, rotating pages when there are more than 16 BDCs. Hero strip: team sold, collected vs full-week goal, refunds, weekly and pace gaps.

Week to date

Run the week — see who is on pace to weekly collected targets before the week closes.

16 BDCs per page, progress vs goal bars, auto page rotation (~30s), optional ?page=N to pin.

Snowflake Refreshes TV →

Last week

Close the books on the prior week with the same scoreboard layout as WTD.

Identical UI to WTD; data for the completed calendar week from the last-week blob.

Snowflake TV →

Goal performance (multi-period)

One screen for last week through YTD: period cards vs goals plus MTD team vs channel with pacing context.

Goal performance

Compare time horizons and channel mix without opening several single-period boards.

Multiple period tiles, team/channel breakdown, pacing gaps — uses several LAS cache periods in one view.

Snowflake Refreshes TV →

Channel detail (per rep)

Each rep card: collected, channel stack (In-House, FT, Certs, JV, Other), and optional RingCentral dial/talk pacing. Eight reps per page; pages rotate when needed.

Channel detail — week to date

Explain the shape of collected revenue by channel while the week is still open.

Large rep grid, channel pills and stacked bars; RC metrics when the RC cache returns data for WTD.

Snowflake RC Refreshes TV →

Channel detail — last week

Review channel mix and activity for the closed week, aligned with last-week LAS and RC caches.

Same layout as WTD; LAS and RingCentral both use period=lastweek.

Snowflake RC TV →

Not built in LENS yet

Outstanding collections

When ready: monitor WTD outstanding balances by aging bucket and BDC, alongside refunds.

Still on lens-poc only; not production-ready for migration. Same LAS API family when it ships.

lens-poc TV Snowflake

Cert product sales HubSpot CRM Search · BCP, CFCP, CMI/REO programs

Weekly program performance vs goals, department and channel breakdown, top sellers — current week for pacing, last week for review.

Current week

Steer the active week — sold vs goal, vs prior week, and who is leading.

Program tiles with progress bars, department split, channel mix, top three sellers leaderboard.

HubSpot Live TV →

Last week

Retrospective — same metrics as current week for the completed Mon–Sun window.

Same card design as current week; CRM Search filtered to last week.

HubSpot TV →

Call activity (RingCentral) GET /api/ringcentralData · dials, answer %, talk time, SMS

Operational visibility for managers: today for intraday, WTD for the working week, last week for Monday reviews. LAS and Cogo Capital are separate boards (different rep rosters).