CONNECTOR · HUBSPOT

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

CONNECTOR · HUBSPOT

HubSpot

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

categoriaOrigem · CRM
alvo de frescorHourly batch.
modelo de authToken de private app.
modo de syncBackfill + incremental em lastmodifieddate.

TABELAS SINCRONIZADAS

contacts, companies, deals, engagements, tickets.

SCHEMA · EXEMPLO

schema.sqlSQL

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

QUERY · EXEMPLO

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 é timezone-naive. Normalize para UTC no staging ou espere drift de 1h em DST.

RELATED · CONNECTORS

Origem · Tracking de eventos

Segment

Conecte um pipeline real ao seu warehouse

Revisão de stack de 30 min. Voltamos com escopo, owner e contrato de frescor. Sem SDR, sem deck.

Agendar revisão de 30 min Abrir o playground