This feature is only available to customers on the Premier Plan or the Pro Plan as an add-on. To upgrade, contact your Customer Success Manager or firstname.lastname@example.org.
Joining Heap Connect Tables
Given the hierarchical nature of the data model, joining user information with event data is simple in Heap Connect. All you need to do is join the user table using Heap’s unique User ID with the table(s) you are analyzing.
main_production.users JOIN main_production.[event_name] ON main_production.users.user_id = main_production.[event_name].user_id
The same approach can be taken using a combination of the user and session ID by joining the sessions table with any event table(s) of interest.
Joining With Other Data Sets
Similarly, Heap Connect allows you to easily combine user interaction data with data from other sources such as support, marketing automation, or revenue data. We recommend sending an internal user ID shared between these sources via our Identify API, which is then exposed retroactively on the users table in Heap and ready to join with other sources. In most cases, you’ll need to join the event and users tables first so that the internal ID is available on the event level.
SELECT main_production.users.email, is_won FROM main_production.users JOIN main_production.viewed_customer_page ON main_production.users.user_id=main_production.viewed_costumer_page.user_id JOIN salesforce_.accounts ON main_production.users.email=salesforce._account.name
Depending on the structure of your data, this query would show the account email of users who had viewed the customer page and whether or not that contract was won. Analyzing these two sources together can reveal whether or not the customers’ page is correlated with the number of deals won and help you answer questions like, “How can my sales team push more prospects to view this documentation?” or “How can I change my page to make it a more valuable resource?”