{"repo":"fivetran/dbt_hubspot","free":true,"listed":false,"github":"https://github.com/fivetran/dbt_hubspot","clone":"git clone https://github.com/fivetran/dbt_hubspot.git","description":"Data models for Hubspot built using dbt.","language":null,"stars":46,"topics":["dbt","dbt-packages","fivetran","hubspot"],"license":"Apache-2.0","category":"data-pipelines","readme_excerpt":"HubSpot dbt Package This dbt package transforms data from Fivetran's HubSpot connector into analytics-ready tables. Resources - Number of materialized models¹: 193 - Connector documentation - HubSpot connector documentation - HubSpot ERD - dbt package documentation - GitHub repository - dbt Docs - DAG - Changelog - dbt Core™ supported versions - =1.3.0, Example Analytics Questions: Which companies receive many emails but send few replies? Which industries or regions have the most engaged companies? hubspot company history Each record represents a change to a company in Hubspot, with valid to and valid from information. Example Analytics Questions: Which companies change owners or lifecycle stages most often? How long after updating company details do deals typically get created? hubspot daily company history Each record represents a company's day in HubSpot with owner, lifecycle stage, daily engagement activity counts, and other selected properties pivoted into columns. Example Analytics Questions: How long have companies spent in each lifecycle stage on average? Which companies have the highest engagement activity relative to their lifecycle stage? hubspot contacts Each record represents a contact in Hubspot, enriched with metrics about email and engagement activities. Example Analytics Questions: Which job titles have the highest email open and click rates? Do contacts prefer calls and meetings or email? hubspot contact history Each record represents a change to a contact i","default_branch":null,"files":null,"tree":[],"storefront":"/r/fivetran","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/fivetran/dbt_hubspot/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}