1. SQL Queries

• Ease of Use: Medium
• Flexibility: Very high
• Persona: Marketing Analyst, Data Analyst, Data Scientist
• Skills: SQL
• Business Value: Save time importing Hubspot data and keep your charts and presentations up to date.
• Main Use Case: Pull reports that you normally would export as CSV from Hubspot and build on top of those. Most of our customers leverage this method to build pivot tables and charts on top of these data. Data will update automatically so you don't have to keep doing this manually for your daily, weekly or monthly reports.

How to Use Queries

We have created a Google Function or formula, just like =sum(A1:A10) or =average(A1:A10) that will allow you and your team to pull the data with a formula directly on the spreadsheet. This function is called =sage() and takes 5 parameters:

=sage("Data Source", # of Rows, # of Columns, "SQL Query", [today()])

Schema

Your Hubspot data is stored in a database with a specific schema (columns and tables) corresponding to the entities we are getting from Hubspot. In order to get your table and column names, go to this spreadsheet and copy the tab (schemas) to a spreadsheet where you have the Demand Sage plugin installed:

<aside> 💡 Note: This specific spreadsheet is empty and the data will only appear once you have copied this over to a working spreadsheet with Demand Sage installed.

</aside>

Parameters

Data Source (text) - refers to the data source you want to run the query for. Currently we only support "hubspot" as a value, but we are working on adding more sources in the near future.

Tell us what sources you'd like us to add 👉Tell us now!