JAMIEL
All projectsHubSpot Rolling Forecast

HubSpot Rolling Forecast

Driver-based rolling forecast and variance engine for HubSpot, built purely from SEC EDGAR filings and earnings calls.

Challenge

Static annual plans go stale the moment the quarter turns. For HubSpot the live question was concrete: which revenue driver carries the highest forecast risk into 2026-Q3 → 2027-Q2?

Solution

Built entirely from public SEC data — 30 quarters of actuals (2019-Q1 → 2026-Q2) from EDGAR Company Facts, 8-Ks and call transcripts. An 18-vantage rolling forecast with accuracy gates, 11 driver scenarios off a validated revenue identity (0.13% mean error), and 62-pair variance splits on price, volume and mix behind a pinned noise floor. Answer: ASRPC (price) — 37 of 62 quarters above the floor; net income is an opex story, not a revenue story. Five-view Streamlit dashboard where every chart traces to engine outputs through automated gates.

View GitHub Repo
HubSpot Rolling Forecast gallery 1
HubSpot Rolling Forecast gallery 2
HubSpot Rolling Forecast gallery 3
HubSpot Rolling Forecast gallery 4

See more projects

All projects →