Machine-readable ✓ llms.txt ✓ agents.json ✓ MCP endpoint OpenAPI spec
RSS

Blog

The Account Health Score HubSpot Can't Calculate: Using SQL to Surface Churn Signals Across Activity, Tickets, and Deal History
Your CSM notices that Acme Corp hasn't responded to two check-in emails. They log a manual task in HubSpot, flag the account for review, and put it on the next weekly team agenda. By the time that meeting happens, Acme...
The SQL Behind the Answer: Why Revenue Leaders Won't Present AI-Generated HubSpot Numbers Without an Audit Trail
The Quarterly Business Review (QBR) is two days away. Your RevOps analyst has spent the past month using AI-generated analytics to answer every major pipeline question: weighted forecasts by rep, stage velocity across...
HubSpot Forecast Accuracy by Rep: Why You Can't Know Whose Commits to Trust Without SQL
Every quarter, the same question surfaces in the revenue forecast meeting: is this Commit number real? HubSpot shows $2.1M sitting in the Commit stage. Three of your eight reps account for most of it. The system assigns...
The HubSpot Report Builder Can't Average Your Averages: Why RevOps Benchmarking Needs SQL
Imagine your VP of Sales walks into Thursday's regional review with a single question: which of your three regional teams is actually closing at the highest rate, measured fairly - one vote per rep, not one vote per...
HubSpot Has AI Now. So Why Can't It Answer a Cross-Object Revenue Question?
This spring, HubSpot rolled out Breeze AI across its platform. The pitch is straightforward: ask a question about your CRM data in plain English and get a useful answer. If you run a Revenue Operations (RevOps) team...
Why HubSpot Enterprise Still Can't Rank Reps Against Team Benchmarks: The Window Function Gap
Every quarter, a sales manager somewhere builds the same leaderboard in a spreadsheet. Copy deal data from HubSpot, paste into Excel, write a RANK formula, format it, and send it to the team before the quarterly...
Building the RevOps QBR Report HubSpot Can't Produce: One SQL Query Spanning Marketing, Sales, and Customer Success
Every quarter, RevOps teams at HubSpot shops go through the same ritual. Pull a deal export. Pull a contact export with source fields. Pull a ticket export from CS. Open Excel, write VLOOKUPs to connect them, discover...
Why Your HubSpot Reports Can't Calculate Complex Revenue Attribution
Every RevOps team eventually hits the same wall. Marketing wants to know which campaigns drove closed-won deals last quarter. Finance wants that number segmented by deal size and time-to-close. Sales leadership wants it...
Breaking the Association Cap: Using SQL Joins to Calculate Complex Multi-Object Revenue Metrics
HubSpot's native reporting is genuinely useful for the questions it was designed to answer. Stage-level deal counts, rep activity summaries, contact lifecycle reports: these work well. The limitation surfaces the moment...
Calculating Pipeline Velocity in HubSpot: Moving Beyond Static Weights to Real-Time Stage Progression Analysis
Your pipeline board shows a number. What it does not show is whether that number is moving. A deal sitting at 70% probability for eight months is not the same as a deal that entered that stage last week and is...