PostHog

Most active users

We want to find who are our most active users and how long they have been visiting Tably. To find our most active users, we can find users with the most events per sessions.

Extract data from properties

We can use the "JSON Extract" step to retrieve values from a JSON object.

We will duplicate the timestamp column. So that we can use one column to find the earliest and another to find the latest date user visited us.

We can group this data by distinct_id which is unique for each user and add different aggregations for the other columns for each value.

We can use the "Max" and "Min" aggregations to find the earliest and latest timestamps and we can use the "Unique count" aggregation to measure how many total sessions a user has.

Calculate events per session

Select top 20 users by number of events per session

Dashboard

Top 20 users by files uploaded

Let's get rid of columns we don't need for analysis, so that we are not distracted by useless information. Type / and click on the "Select" command.

Filter upload events

In order to filter out everything except a specific event, hover over the column summary (the interactive bar chart) and click on the bar that represents upload_file.

Calculate files per user

We now need to group our table by unique distinct_id. There are two icons next to column name, one for grouping and another for sorting. Click on the group icon.

Select top 20 users by file count

Click on sort button and make sure that we are sorting in descending order.

Let's select 20 users with the highest uploads. Type / and click on the "Top" command.

Dashboard

Let's chart the top 20 users to visualise them. Type / and click on the "Chart" command.