Introduction to RevOpsQL

What is RevOpsQL?

RevOpsQL is a query language designed specifically for Revenue Operations teams. It lets you query your HubSpot data with the precision of SQL, without needing a developer for every data extraction.

With RevOpsQL, you can answer questions like:

• "Which companies with more than €1M in annual revenue have at least one closed-won deal above €10,000 this year?"
• "Which contacts were created this quarter and have more than 3 active deals in progress?"
• "Give me the top 3 closed-won deals per company, along with the associated decision-maker contacts."

These analyses would take hours in the HubSpot interface. With RevOpsQL, it's a query of a few lines.

The RevOpsQL philosophy

RevOpsQL is built on two core ideas:

1. A familiar SQL syntax If you've used Excel, HubSpot reports, or even heard of SQL, the syntax will feel natural. Keywords like SELECT, FROM, WHERE mean exactly what you'd expect.

2. The power of HubSpot associations HubSpot is a relational CRM: your contacts are linked to companies, your companies to deals, your deals to tickets. RevOpsQL leverages these relationships natively through the WITH keyword, which lets you join multiple objects in a single query.

General structure of a query

A RevOpsQL query is made up of logical blocks:

SELECT   → Which properties do you want to see?
FROM     → Which HubSpot object type?
WHERE    → What filtering conditions?
LIMIT    → How many primary objects at most?
WITH     → Which associated objects to include?

Beginner tip: Always start by asking yourself these questions in order. "What do I want to see?", "On what?", "With what conditions?".