Temporal Joins

A replacement for foreign key joins that uses time and customer to pair activities

Diagram showing a single table (the activity stream) with plots depending on it

Connect filtered activities in one table

A diagram describing how temporal joins work by showing 1. filtering by customer, then 2. by time, then 3. picking a row and appending

Temporal joins...

Don't add or remove rows
Temporal joins add columns from additional activities. They cannot duplicate or drop rows.

Don't require modeling the join in advance
Traditional joins require a foreign key between tables. Temporal joins only use customer and time, which is present in all activities.

Can bring in any data
Because they follow the same structure, any activity can be joined to any other activities.

Learn about activities
Improved Accuracy

All temporal joins

Appends the FIRST EVER append activity for each customer in your dataset, regardless of when the primary activity occurred.
First Ever
Appends the FIRST append activity, but only if it happened BEFORE the primary activity.
First Before
This relationship adds the FIRST time the append activity happened AFTER the primary activity.
First After
Appends the FIRST append activity that happened IN BETWEEN that primary activity and the next instance of the primary activity. Said another way, append the first activity that happened before the next primary activity.
First In Between
Appends the LAST EVER append activity for each customer in your dataset, regardless of when the primary activity occurred.
Last Ever
Appends the LAST append activity that happened BEFORE the primary activity.
Last Before
This relationship adds the LAST time the append activity happened AFTER the primary activity.
Last After
Appends the LAST append activity that happened IN BETWEEN that primary activity and the next instance of the primary activity. Said another way, append the last activity that happened before the next primary activity.
Last In Between
Appends an AGGREGATION of ALL the append activities that happened EVER regardless of when the primary activity occurred.
Aggregate All Ever
Appends an AGGREGATION of all the append activities that happened BEFORE the primary activity occurred.
Aggregate Before
Appends an AGGREGATION of ALL the append activities that happened AFTER the primary activity occurred (opposite of Aggregate Before).
Aggregate After
Appends an AGGREGATION of all the append activities that happened IN BETWEEN that primary activity and the next instance of the primary activity.
Aggregate In Between