Common data models for segment data such as
sessions and a user roll up table built from
Add the package to your
package.json file in your Dataform project. You can find the most up to package version on the releases page.
Create a new JS file in your
definitions/ folder and create the segment tables with the following example:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
For more advanced uses cases, see the example.js.
This primary outputs of this package are the following data models (configurable as tables or views).
Contains a combined view of tracks and pages from segment. Each session is a period of sustained activity, with a new session starting after a 30min+ period of inactivity. Each session contains a repeated field of records which are either tracks or pages. Common fields are extracted out into the top level and type specific fields are kept within two structs:
Aggregates all identifies calls to give a table with one row per user_id. Identify calls with only an anonymous_id are mapped to the matching user_id where possible.