Heap Connect is an analytics infrastructure that allows you to tackle complex analysis and directly query your raw event data. A few things you might want to use Connect for include:
- Joining Heap data with other sources (revenue data, Salesforce data, marketing automation, etc.)
- Performing ad-hoc, custom analysis with SQL
- Creating custom visualizations and dashboards in your BI tool of choice (e.g. Looker, Mode, Chartio, Periscope, and more)
- Building predictive user models
Because Heap Connect includes all historical data from the day you installed Heap, it gives you a uniquely complete and always up-to-date dataset for all of your teams’ analysis needs.
How to Use this Guide
To help you make the best use of this powerful tool, we teamed up with Mode to bring you an interactive guide featuring several common queries you can run, whether you’d like to access metrics like average time on site, perform detailed revenue analysis, or build lists using a particular attribution model. The visualizations can take a few seconds to load within our docs, but you can view all the reports on the Mode Reports page.
To view the actual queries behind our embedded interactive visualizations, just click the link in the bottom-left of each visualization or the menu in the top-right hand corner to expand and explore. When copying over the query to your BI tool, make sure to update the schema name from heap to _mainproduction (or any other schema you are querying).
Just Getting Started with SQL?
If you’re not already a SQL pro, don’t worry! It doesn’t take long to learn the basics. Here are some resources we recommend to get you started.