CONNECTOR · HUBSPOT

HubSpot — Contacts, companies, deals, engagements. CRM-of-record.

CONNECTOR · HUBSPOT

HubSpot

Contacts, companies, deals, engagements. CRM-of-record.

categoríaOrigen · CRM
target de frescuraHourly batch.
modelo de authToken de private app.
modo de syncBackfill + incremental en lastmodifieddate.

TABLAS SINCRONIZADAS

contacts, companies, deals, engagements, tickets.

SCHEMA · MUESTRA

schema.sqlSQL

CREATE TABLE hubspot.deals (
  id              TEXT PRIMARY KEY,
  dealstage       TEXT,
  amount          NUMERIC,
  closedate       TIMESTAMP,
  hs_object_source TEXT
);

QUERY · MUESTRA

query.sqlSQL

SELECT dealstage, COUNT(*) AS deals, SUM(amount) AS pipeline
FROM hubspot.deals
WHERE closedate >= now() - interval 0
GROUP BY 1 ORDER BY 3 DESC;

OPS NOTES

lastmodifieddate es timezone-naive. Normalizar a UTC en staging o esperar drift de 1h en DST.

RELATED · CONNECTORS

Origen · Tracking de eventos

Segment

Conectá un pipeline real a tu warehouse

Revisión de stack de 30 min. Volvemos con scope, owner y contrato de frescura. Sin SDR, sin slide deck.

Agendar revisión de 30 min Abrir el playground