back to catalogGet code
works in free trial | Built on 8.1.0.cl
HubSpot Marketing Analytics Get code
The HubSpot TML Blocks provides sales and marketing analytics Liveboards and ad-hoc search capabilities. Data is extracted from HubSpot using the HubSpot API’s and staged in tables in SnowFlake (or other CDW). A series of views are used to transform the data. ThoughtSpot connects directly to the views using an Embrace connection.
Installation instructions
Complete the following steps to install this TML Block.
SnowFlake
- Use the DDL Scripts to create the tables and views in SnowFlake. ("SnowFlakeTables Embrace v1.6.sql" and "SnowFlakeViews Embrace v1.6.sql")
- Load the dim_Date table from the CSV file provided
Extracting Hubspot Data
- Refer to the "Hubspot Data Extraction.pdf" for the Snowflake Table and the corresponding API Call and Data Items.
- Using the API calls detailed in the HubSpot Data Extraction.pdf to load the data into the tables using your ETL.
ThoughtSpot
- Using Embrace connect to the Views specified in the Cloud Data Warehouse section of this guide.
- Execute the ThoughtSpot script to create the relationships in ThoughtSpot
TML BLocks
Import the workshop zip "HubSpot - Worksheets.zip" into Thoughtspot. Import the pinboard zip "HubSpot - Liveboards .zip" into Thoughtspot.
Liveboards Included
HubSpot BDR/SDR
HubSpot CMO
HubSpot Health
HubSpot Marketing
ThoughtSpot is the Search & AI-driven Analytics platform for the enterprise. Anyone can use search to analyze company data in seconds and get automated insights when you need them.
