Sign in to access the dashboard
Create your administrator account
Save your API key - you'll only see it once
This key grants full API access. Store it securely.
admin| Event | Brand | Date | Target | Booked | Revenue Pacing | Sponsors | Anchor | Churn% | ML Renewal | Audience | Gov:Sponsor | Health | Actions | |||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
·
·
|
|
⚠ -- | -- | -- | -- | -- |
|
|||||||||||||||||||||||||||||||||||||||||||||||
|
Loading event detail...
Resign
Churned
Downgraded
Net New
Returning
⚠
Anchor-Tier Gap
Floor plan & table assignment
Floor planning now lives in the
Logistics tab
of the Events department. Open it and pick this event to upload the map, place & assign tables,
and generate sponsor seating links.
Tier pacing, lapses & inventoryTier Pacing
Historical anchor-tier buyers of this series with zero current-year footprint. Ranked by lifetime anchor spend.
Inventory
loading tiers…
no inventory record for this event
Open Opps
—
Advisory Board
Open Sessions
Dates & Deadlines
Level Inventory
Notes
Churned, sponsors & prospects
CHURNED
STAGED
CHURNED
NET NEW
Pipeline & audiencePipeline by Stage
Sponsor Retention:
Audience
—
government registered
/ target
· gov:sponsor
No audience data available
Contract Fill Velocity
First Dollar
Last Dollar (100%)
Days to Fill
Contracts
0%50%100%
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||
Stored separately from the Mass-Outflow template so this surface can carry an early-stage prospecting message. Used by every Apply Template prebake AND the per-account compose drawer.
| Account | Top Stage | Amount | Opps | Owner | Close Date | |
|---|---|---|---|---|---|---|
|
0 prior
draft ready
|
Compose → |
| Opportunity | Account | Stage | Amount | Close Date | Age | Last Activity | ML Renewal | Intelligence |
|---|---|---|---|---|---|---|---|---|
|
|
|
STALE | -- |
1 cat
|
||||
|
Account Intelligence
Segment
Churn Risk
Revenue (LTM)
Predicted Revenue
Years Active
Product Categories
Cross-Sell Propensity
--
Subscription Propensity
--
ML Renewal Forecast
Prior Spend (Series)
Consecutive Years
No M10 renewal prediction available for this account/series pair.
Sales Coaching Signals
|
||||||||
| Opportunity | Account | Event | Stage | Amount | Close Date | Age | Last Activity |
|---|---|---|---|---|---|---|---|
|
|
STALE |
| Event | Date | Brand | Target | Booked | PY Booked | YoY | Verdict | Sponsors | Retained | Churned | Net New | Fill Velocity | Exports | Actions | ||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
-- |
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Loading event detail...
Resign
Churned
Downgraded
Net New
Returning
⚠
Anchor-Tier Gap
Floor plan & table assignment
Floor planning now lives in the
Logistics tab
of the Events department. Open it and pick this event to upload the map, place & assign tables,
and generate sponsor seating links.
Tier pacing, lapses & inventoryTier Pacing
Historical anchor-tier buyers of this series with zero current-year footprint. Ranked by lifetime anchor spend.
Inventory
loading tiers…
no inventory record for this event
Open Opps
—
Advisory Board
Open Sessions
Dates & Deadlines
Level Inventory
Notes
Churned, sponsors & prospects
CHURNED
STAGED
CHURNED
NET NEW
Pipeline & audiencePipeline by Stage
Sponsor Retention:
Audience
—
government registered
/ target
· gov:sponsor
No audience data available
Contract Fill Velocity
First Dollar
Last Dollar (100%)
Days to Fill
Contracts
0%50%100%
Event recap — ROI questionnaire
Exports unlock after Submit
Ops report
Newsletter
Send to
Loading form…
Submitted
· Report
· Newsletter
Last saved
·
This form does not auto-fill your name or email. Optional contact details can be added in the fields above if you choose. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
YoY event-sponsor count is not the right number. It conflates "did this event keep its sponsors" with "did the underlying account stay engaged with us" — and our portfolio shifts. An account drops Event A and picks up Event B, and the per-event metric flags churn even though the relationship is intact.
The defensible number is account-level retention. Take every account that bought a sponsorship in ; ask whether they bought again in — any event, any tier, any brand. That's . Layer dollars on top: Gross Revenue Retention caps each retained account at no-expansion-credit so it isolates "did we keep last year's money"; Net Revenue Retention rolls in expansion. The cohorts then localize the leak.
First-year sponsors renew at — not the multi-year cohort's . Once an account makes it past their second sponsorship, they tend to stay. The renewal motion is failing in year two, not year five.
came back in but spent at least 25% less than the prior year. They're still customers — but the relationship is visibly cooling. These are the ones whose disinterest you can intervene on before it becomes churn.
An account that paid us $30K for Event A in PY and now pays us $30K for Event B in CY is retained, even though Event A's sponsor count went down. Per-event YoY metrics will under-count this account's loyalty. The Logo Retention Rate above — portfolio-agnostic — is the only metric that gets it right.
that bought from us in have zero won revenue in so far. Some have an open opp; many do not. Either way, the absence of a CY conversation is the signal — the Action Queue → Relationship Risk feed surfaces the silent ones with prior-year value behind them.
Download every value behind these KPIs as an Excel workbook: one sheet per intermediate computation (PY & CY universes, won line items, secondary-line exclusions, bucket assignments, cohort lists, account × year revenue pivot) with raw + 18-char Salesforce IDs and friendly names. Hand to your SF administrators to reproduce the headline numbers from raw CRM data. Honors the toggle above.
White glove lists Closed Won first-time buyers only. Closed-lost attempts and open opps without a win do not appear here — those stories live under Retention → Action Queue → Year-2 Watch. Next calendar year, today’s white-glove accounts either show a CY win or they stay on that rescue queue.
Operational framing — not automated sends. Rep-owned cadence tied to event timing.
| Urgency | Account | Owner | CY $ | Open opp $ | CY event | Phase | Opp | Signal | |
|---|---|---|---|---|---|---|---|---|---|
|
|
Open Closed No opp | ||||||||
|
Last event sponsored
on
()
Last year's won opportunity
This year's event
in days
today
days ago
•
•
Sales assets
Trajectory
PY:
→
CY:
·
declining 2+ years
Activity since event
Last logged activity:
No CY-event activity logged
Recommended action
|
|||||||||
| No rows match your search (or the cohort is empty). | |||||||||
LastYearsEventId or matching EventSeriesName at year − 1). Each line counts a prior-year won sponsor on the paired instance who does not have Closed Won on the current instance (event-slot basis; matches Command Center).
· paired,
skipped (no prior-year baseline — inaugural or unlinked series)
This is the one question every renewal conversation comes back to: last year’s sponsors — did they come back this year? We take every account that sponsored a paired event in and follow that logo into — anywhere in the series, at any level. The account is the unit, not the individual line item, so an anchor that moved to a smaller package still counts as a kept logo (it just shows as contracted, not lost).
We split the book by when the event runs: First Half (Jan–Jun) is mostly settled — those events already happened, so it reads as realized retention. Second Half (Jul–Dec) is still in flight — the book you can still close. That’s the “waitlist says one thing, logic says another” gap: H1 is history, H2 is forecast.
| Rep | H1 retained | H2 retained | In play $ | Not re-engaged $ | Lapsed $ | PY book |
|---|---|---|---|---|---|---|
| Rep | H1 retained | H2 retained | In play $ | Not re-engaged $ | Lapsed $ | PY book |
|---|---|---|---|---|---|---|
| Series | Brand | Churned | Lost Revenue | Prior | Retained | Net New | Churn % | Level Movement | Movement | |||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
▲
▼
=
?
|
|
|||||||||||||||||||||||||||||||||||||||||||||||
|
No retained accounts on completed events.
No churned accounts.
No net-new accounts on this series.
|
||||||||||||||||||||||||||||||||||||||||||||||||
| Account | Owner | Company Size | Prior Revenue | Level | Series Lost | ML Risk | Tenure | Status | Lost Reasons |
|---|---|---|---|---|---|---|---|---|---|
| -- |
|
In Pipeline Gone |
|
| Owner | Churned | Lost Revenue | Retained | Churn Rate | Severity |
|---|---|---|---|---|---|
|
|
| Sales Team | Churned | Lost Revenue |
|---|---|---|
| Brand | Churned | Lost Revenue | Prior | Churn Rate | Severity |
|---|---|---|---|---|---|
|
|
| State | Churned | Lost Revenue | Prior | Churn Rate |
|---|---|---|---|---|
| Close-Lost Reason | Accounts | Revenue Impact | Share |
|---|---|---|---|
|
|
| Transition | PY accts | CY accts | Retained | Churned | Truly new | Returned | Churn % | Replacement % |
|---|---|---|---|---|---|---|---|---|
| YTD |
| Transition | Series-pair churn | Account active in CY (different series) | % rotated |
|---|---|---|---|
| YTD |
items.parquet joined to events.parquet, filtered to stage_class == "won", non-webinar event types, valid year/account/series.AccountId. No de-duplication of related-org records.| Transition | PY accts | CY accts | Retained | Churned | Truly new | Returned | Churn % | Replacement % |
|---|---|---|---|---|---|---|---|---|
| YTD |
| Transition | Series-pair churn | Account active in CY (different series) | % rotated |
|---|---|---|---|
| YTD |
items.parquet joined to events.parquet, filtered to stage_class == "won", non-webinar event types, valid year/account/series.AccountId. No de-duplication of related-org records.| Urgency | Account | Owner | Last series | First-yr $ | First yr | Days since | CY event | Opp | Signal | |
|---|---|---|---|---|---|---|---|---|---|---|
|
Got away
—
|
Open Closed No opp | |||||||||
|
Last event sponsored
on
()
Last year's won opportunity
This year's event
in days
today
days ago
•
•
Sales assets
Trajectory
PY:
→
CY:
·
declining 2+ years
Activity since event
Last logged activity:
No CY-event activity logged
Recommended action
|
||||||||||
| No rows match your filters. | ||||||||||
| Urgency | Account | Owner | Last series | Prior $ | Open opp $ | Days silent | CY event | Opp | Signal | |
|---|---|---|---|---|---|---|---|---|---|---|
|
|
Open Closed No opp | |||||||||
|
Last event sponsored
on
()
Last year's won opportunity
This year's event
in days
today
days ago
•
•
Sales assets
Trajectory
PY:
→
CY:
·
declining 2+ years
Activity since event
Last logged activity:
No CY-event activity logged
Recommended action
|
||||||||||
| No rows match your filters. | ||||||||||
| Urgency | Account | Owner | PY $ | CY $ | Δ YoY | Series PY→CY | Open opp $ | CY event | Opp | Signal | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| → |
|
Open Closed No opp | |||||||||
|
Last event sponsored
on
()
Last year's won opportunity
This year's event
in days
today
days ago
•
•
Sales assets
Trajectory
PY:
→
CY:
·
declining 2+ years
Activity since event
Last logged activity:
No CY-event activity logged
Recommended action
|
|||||||||||
| No rows match your filters. | |||||||||||
invalidate_cache()).
| Account | Owner | Event | Brand | Year | Date | Revenue | Level | Status |
|---|---|---|---|---|---|---|---|---|
| No sponsors match the current filters | ||||||||
| Event | Notes | Open Opps | Open Sess | Sold $ | Open $ | Date | Ad Bd | ||
|---|---|---|---|---|---|---|---|---|---|
|
|
— | Sold — |
| Name & Title | Jurisdiction | Pop. | IT Budget | Function · Level |
|---|---|---|---|---|
| Name & Title | Account · Tier | Vs your DNA | Shared / Distinct vertical tags |
|---|---|---|---|
|
Shared:
Distinct:
No DNA on file
|
Event_Session2__c speaker from indexes/speakers.parquet, enriched with
planning-doc title/org where uploaded. Session JSON names are joined to Registration__c
(Reg_Speaker__c) by exact or normalized badge name — expand a row for session history.
No reg match = no speaker registration aligned to that session name at that event.
SF Account comes from Registration → Contact (may differ from planning org).
indexes/speakers.parquet.
| Speaker | Title | Organization | SF account | Reg match | Sessions | Events | Last seen | Topics | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Gov | — | ||||||||||||||||||
|
Loading sessions…
Showing
of
sessions (current filters).
|
|||||||||||||||||||
Event__c link on the Contract record may be blank.
| Sponsor | Tier | Roles |
|---|---|---|
| Event | Sponsor | Role | Tier | Contact | |
|---|---|---|---|---|---|
| primary |
Placeholders:
{{first_name}},
{{event_name}},
{{inquiry_phrase}},
{{signature}}.
Set bake tone to Custom, then generate for the visible set or per owner below.
| Stage | Account / Opp | Amount | Close | Next event | Stage age | Idle | Recipient | Subject | Status | Actions | |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|||||||||||
|
Account Map
|
|||||||||||
|
How this works:
Click a numbered step (or any contact below) — that contact's opps light up.
Compose one email per contact. Repeat until covered.
No actionable contacts found — every contact on these opps lacks an email address.
Selection
Products
Contacts (click one to start)
No actionable contacts (no email on file for any contact in scope).
Opportunities in this send
contact reaches
contact does NOT reach (greyed)
↑ Pick a contact above — opp cards will light up to show what they reach
Sending to
Pick a contact above to enable Compose
✓ this send covers every opp
Combined draft
To:
Cc:
×
Bcc:
×
Subject:
Test Mode — recipient overridden, SF logging skipped
|
|||||||||||
|
|
⚠ Thread-active ≠ OCR primary
|
— no draft — | |||||||||
|
(real: )
×
×
Version:
Switching…
Generating…
Signature
From Outflow Personalization for this row’s Send-as choice. Edits apply to this email only.
unsaved changes
✓ Sent
View in Engagements →
Recipient signals
⚠ Thread-active contact differs from OCR primary
No automatic recipient — type one in the To field above.
Events on this opp
SHARED
Datasheet
Datasheet (no price)
Agenda
Website
Anchor Overview
Exhibitor Overview
Patron Overview
Other Overview
Anchor UW
Collateral
Keynote
Sessions
Recharge
Inventory
Coaching
|
|||||||||||
The brief table at hasn't been
built. Trigger a full ETL run (or wait for the next nightly) so
etl/build_event_outflow_briefs.py can land the parquet.
Should we add — or take on — an event? Compose a regional feasibility brief, evaluate an incoming event pitch (any type, incl. higher-ed), and plan around competing dates.
No past in-state events in this window/type. Widen the lookback or clear the type filter.
No past events to trend for this type filter.
No captured leads for the events in this window/type.
| Sponsor | Industry | Revenue | Events |
|---|---|---|---|
No won sponsorships for the events in this window/type.
Should we take on this event? Paste the pitch and we benchmark its economics against our comparable events, profile the in-region audience we could promote to, resolve its pitched sponsors against our CRM (existing relationships vs. net-new), and flag date conflicts. Works for any event type, including higher-education.
Pre-filled with a sample event — hit Evaluate to see it work, paste a pitch above, or start typing in any field to clear the sample and enter your own.
Pick a subject. Every state is scored on demand we can measure — government procurement volume, readership of our topic content, government contacts we have already captured on the subject, and the in-state vendor bench — then set against what we actually stage there. A candidate is a state with no dedicated event of its own whose demand sits at or above the median of the states where we already run one.
With no served market there is no peer bar to clear, so nothing is flagged as a candidate. The demand ranking below still holds — read it as where the subject would land first, and check whether a co-located track is the cheaper test.
| Gov contacts captured on topic | |
| Topic readership, 12 mo | |
| In-state vendors on topic | |
| Proven buyers, in-state | |
| All event revenue written, 3 yr | |
| Demand index |
| State | Posture | Demand | Solicitations | Gov contacts | Readership | Vendors | Topic written 3 yr | |
|---|---|---|---|---|---|---|---|---|
Demand is the mean of four percentile ranks within this topic (solicitations, readership, captured government contacts, in-state vendors) — a relative position among states, not a dollar forecast. Contact counts measure reach we have already built through purchased engagements, not sales engagement.
The "dates to avoid" calendar. Add competing industry/education conferences and the event types they conflict with. Our own upcoming events are folded in automatically (read-only) so the planner never double-books.
| Date | Event | State | Conflicts with | Source | |
|---|---|---|---|---|---|
No dates on the calendar yet.
registration_journeys.parquet.
| Event | Date | Series | Registrants | Type Mix | New | Returning | Return Rate | Next-Yr Retention |
|---|---|---|---|---|---|---|---|---|
| No events match the current filter. | ||||||||
| Name | Type | Function / Role | Events | Series | Years | Span | |
|---|---|---|---|---|---|---|---|
| series return | |||||||
| No individuals match the current filter. | |||||||
| Name | Type | Function | Role | Attended | Returning |
|---|---|---|---|---|---|
| yesno | yesno | ||||
| No registrants. | |||||
The Event Operations Suite is a unified operational intelligence layer for managing eRepublic's events business. It connects revenue targets, CRM pipeline, sponsor behavior, ML predictions, and AI-powered sales tooling into a single surface — replacing the fragmented spreadsheet and Salesforce report workflow that preceded it.
The events business generates ~$46M in annual revenue across 284 events spanning 5 brands. Before this suite, answering basic questions required cross-referencing 4+ Salesforce reports, a master spreadsheet, and tribal knowledge:
The suite makes all of this queryable in real time, and layers ML predictions and AI-generated sales intelligence on top.
The matrix view shows every event with real-time operational health:
All open event-related opportunities grouped by event series:
Completed events for the selected fiscal year: KPI strip, searchable grid, and row expansion that mirrors the
Command Center drill-down (tier pacing, inventory snapshot, audience composition, current sponsors by level, churned sponsors with ML renewal). Each event carries a persistent
ROI questionnaire (saved in ops_state) with Word and PDF export plus Send to Teams (Adaptive Card with deep link).
The unified retention workspace. Anchors on account-level retention math (not per-event YoY sponsor count) so portfolio composition shifts don't pollute the headline number. Subtabs:
The Exclude BTB / IICA / IITX toggle (Overview + Action Queue
only) drops Beyond the Beltway, Industry Insider California, and Industry
Insider Texas line items so the headline retention number reflects flagship
sponsorship behavior rather than briefing/insider-series volume. Default ON
for the leadership-defensible posture; flip OFF to compare. Full methodology
and rationale: docs-current/features/RETENTION.md.
Multi-year trajectory analysis:
Per-event deep intelligence for sales preparation. Given an event series, the engine:
Click "Draft Email" on any account or "Generic Email" to open the Sales Kit modal:
Flat list of every sponsor × event with movement classification and export:
| Model | Name | What It Does | Where It Surfaces |
|---|---|---|---|
| M1 | Whale Revenue Forecast | Predicts next-year revenue per account | Pipeline intelligence badges |
| M2 | Account Retention Risk | Churn probability per account | Pipeline coaching signals, retention page |
| M3 | Account Segmentation | Behavioral segment classification | Pipeline account tags |
| M4 | Category Expansion | Propensity to buy a new product category | Intelligence badges |
| M6 | Event Market Intelligence | State × category procurement momentum | Tearsheet scoring, activation targeting |
| M8 | Cross-Sell Graduation | Single→multi-product graduation probability | Pipeline coaching signals |
| M10 | Event Series Renewal | Per-sponsor renewal probability for event series | Pipeline ML Renewal column, event matrix |
| M11 | Subscription Renewal | Renewal probability for Navigator/Insider | Retention intelligence |
Every user gets a $5.00/day AI budget. Each AI call (tearsheet synthesis, email generation, chat) is tracked to the authenticated user. The budget resets at midnight. Per-conversation caps ($0.50 default) prevent runaway single sessions.
ETL Pipeline
├── events.parquet ──────────────────────┐
├── products.parquet ────────────────────┤
├── opportunities.parquet ───────────────┤── services/event_operations.py
├── account.parquet ─────────────────────┤ │
└── ml/ml_inference.parquet ─────────────┘ │
├── Command Center
ML Pipeline ├── Pipeline (+ coaching)
├── M10 (event_series_renewal) ──────────────────├── Post-Event Performance Review
└── M2 (churn_prediction) ───────────────────────├── Trends
└── Detail Drilldowns
events.parquet ──────────────────────────┐
products.parquet ────────────────────────┤── services/event_intelligence.py
account_intelligence.parquet ────────────┤ │
jurisdiction research ───────────────────┘ ├── Tearsheet Report
awards/bids data ────────────────────────────────├── AI Synthesis (LLM)
├── Sales Kit (LLM)
├── Library Publish
└── HTML/PDF/CSV Export
/api/event-operations| Endpoint | Method | Description |
|---|---|---|
/summary | GET | Portfolio KPIs for current fiscal year |
/matrix | GET | All events with health, pacing, sponsor movement |
/detail/<event_id> | GET | Deep dive: sponsors, pipeline, close-lost, audience |
/pipeline | GET | All open opportunities with ML enrichment |
/postmortem?year= | GET | Completed events analysis by fiscal year (powers Post-Event Performance Review tab) |
/post-event-review/<event_id>/form | GET, PUT | Persistent ROI questionnaire (Firestore/PG ops_state) |
/post-event-review/<event_id>/export-docx | GET | Word download (questionnaire + Command Center metrics) |
/post-event-review/<event_id>/export-pdf | GET | PDF download (Playwright on host) |
/post-event-review/<event_id>/push-teams | POST | Adaptive Card summary to a configured Teams destination |
/trends | GET | Multi-year revenue, sponsor, retention trends |
/retention-overview?exclude_secondary= | GET | Account-level retention KPIs (LRR, GRR, NRR, cohorts, buckets) |
/retention-overview/export?exclude_secondary= | GET | "Show your work" .xlsx (separate eo_export_api blueprint, same URL prefix) |
/action-queue?exclude_secondary= | GET | Year-2 Watch / Relationship Risk / Early Warning feeds |
/churn-analysis?year= | GET | Multi-lens churn diagnosis (composition, series, level, owner…) |
/sessions/upload | POST | Upload & parse session planning .docx |
/sessions | GET | List events with session data |
/sessions/<series> | GET | Full session detail for an event |
/sessions/<series>/prospects | GET | Match open sessions to sponsor prospects |
/sponsor-status?year= | GET | Flat sponsor×event list with movement status |
/sponsor-status/export?year= | GET | CSV download of sponsor status report |
/api/event-intelligence| Endpoint | Method | Description |
|---|---|---|
/series | GET | List available event series |
/tearsheet | POST | Generate tearsheet report for an event |
/synthesize | POST | LLM refinement of tearsheet sections |
/generate-email | POST | AI-drafted sales kit (targeted or generic) |
/export-html | POST | Self-contained HTML tearsheet |
/recommend-events | POST | Match an account to upcoming events |
/similar-accounts | POST | Find lookalike accounts for an event |
