hubspot-revops-skill

Integrate HubSpot API with a SQL warehouse to analyze revenue analytics.

28|3|Updated Dec 10, 2025
One-click install
npx skills add https://github.com/ScientiaCapital/skills --skill hubspot-revops-skill
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: hubspot-revops-skill
Source: https://github.com/ScientiaCapital/skills/tree/main/active/hubspot-revops-skill
Command: npx skills add https://github.com/ScientiaCapital/skills --skill hubspot-revops-skill

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

HubSpot-centric revenue analytics often require stitching CRM data to a SQL data warehouse to deliver scalable, actionable insights across ICP validation, lead scoring, competitive intelligence, activity analysis, and pipeline forecasting.

Core Features & Use Cases

  • ICP validation: segment contacts and accounts to measure conversion efficiency by segment.
  • Lead scoring: train a predictive model on historical deals and write scores back to HubSpot.
  • Competitive intelligence: monitor closed deals for competitor patterns and trigger alerts.
  • Pipeline forecasting: compute weighted revenue forecasts from stage-specific win rates.

Quick Start

Create and configure a HubSpot Private App with required CRM scopes, connect your SQL warehouse, and run ICP validation and pipeline forecast queries to produce initial results.

Frequently Asked Questions about hubspot-revops-skill

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate pipeline forecasts directly from HubSpot CRM data?

Pipeline forecasting analyzes HubSpot data by computing weighted revenue forecasts from stage-specific win rates. It requires connecting your HubSpot CRM to a SQL data warehouse to process historical deal data and generate scalable revenue projections.

Can I write lead scoring models back to HubSpot from a SQL warehouse?

Yes, lead scoring trains predictive models on historical deals within a SQL warehouse and writes the resulting scores back to HubSpot. This requires a HubSpot Private App with CRM scopes and automated data pipelines to sync the enrichments.

What do I need to set up HubSpot revenue analytics for ICP validation?

ICP validation requires a HubSpot Private App with CRM scopes, a connected SQL data warehouse with a defined schema prefix, and automated data pipelines. This setup segments contacts and accounts to measure conversion efficiency by segment.

Does HubSpot RevOps analytics work without a SQL data warehouse?

No, a connected SQL data warehouse with a defined schema prefix is required. The analytics logic integrates the HubSpot API with the warehouse to process CRM data at scale and write back enrichments for ICP validation and forecasting.

How does competitive intelligence track closed deals in HubSpot?

Competitive intelligence monitors closed HubSpot deals within a SQL warehouse to identify competitor patterns and trigger alerts. This requires automated data pipelines to continuously sync deal records from the CRM for analysis.

What are the limitations of using HubSpot API for revenue analytics?

HubSpot API integration requires a Private App with specific CRM scopes and depends on automated data pipelines to a SQL warehouse. Without a properly configured schema prefix and continuous sync, pipeline forecasts and ICP validation cannot generate actionable insights.