The following example shows how to create an exploration to count the number of product events users perform and then categorize them based on the number of interactions they make:
- In the Catalog, go to Datasets > Product Events.
- Double-click Product Events and type count. This will display the total number of product events. (Double-clicking anything in the catalog copies the syntax in the builder. )
- To count the number of product events by user, enter count by and double-click the Users dataset.
- Save the previous result as a variable called eventsByUser and use the if..then..else syntax to create bins. Save this as a variable called eventsByUserBinned.
- Double-click Users on the catalog and type count by eventsByUserBinned to count users by the bin they belong to.
- Click Save.
Please sign in to leave a comment.