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?”