# Please let us use SQL for reporting

**URL:** <https://community.hubspot.com/t/please-let-us-use-sql-for-reporting/37483>\
**Category:** HubSpot Ideas\
**Tags:** reports\
**Created:** [May 18, 2021, 5:43am UTC](https://community.hubspot.com/t/please-let-us-use-sql-for-reporting/37483 "2021-05-18T05:43:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![song](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/song/32/69256_2.png) [@song](https://community.hubspot.com/u/song)\
**Post date:** [May 18, 2021, 5:43am UTC](https://community.hubspot.com/t/please-let-us-use-sql-for-reporting/37483/1 "2021-05-18T05:43:44Z")

</div>

hubspot reporting isn’t the best, lots and lots of room for improvements, especially with the old report builder going away and being replaced by a new report builder

it’d be nice for us to use SQL to join whatever objects we want to join, and do whatever calculations we need. it is quite inconvenient to build complicated joined objects reports with the current filters set up hubspot has

also, that’d allow us to do calculations! it’d be very nice to do simple calculations like conversion rates in a report. i can’t believe a crm tool doesn’t allow for custom conversion rates calculations

---

<div class="post-metadata">

**Author:** ![johnelmer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/johnelmer/32/55984_2.png) [@johnelmer](https://community.hubspot.com/u/johnelmer)\
**Post date:** [January 3, 2024, 3:08pm UTC](https://community.hubspot.com/t/please-let-us-use-sql-for-reporting/37483/2 "2024-01-03T15:08:13Z")

</div>

There is an app for this in the HubSpot App Marketplace called [MS SQL Server for HubSpot](https://ecosystem.hubspot.com/marketplace/listing/mssql-replicator) . The app pulls your HubSpot data into a SQL data warehouse via prebuilt API connectors. A SQL data warehouse in Azure is included in the cost.

Once your HubSpot data is in the data warehouse, it automatically refreshes on a scheduled basis. You can connect the SQL data warehouse to any other application that has a SQL connector, such as BI software like Power BI or Tableau.