Skip to content
/
Project 57 Analytics deep...
Last updated

Project 57 Analytics deep dive with ClickHouse

Task 1: Organization activity

Arc_2025-09-17_13-33_LsmhZisM@2x.png

Task 2: User activity

We can found what user is most active but we don't know how to see what he actually do

image copy 13.png

Task 3: Content & feature usage

We don't found the way to find this information in ClickHouse

Task 4: Onboarding efficiency

image copy 15.png

Task 5: Explore configiration usage from redocly.yaml

Arc_2025-09-17_15-10_tfNz7Z7u.png

What made you smile?

  • We need some time to undestand that database schema and how to search information in it

What did you find confusing?

  • Some event have organization slug equals '' So data looks wierd
  • Some event have strange names
image copy 12.pngimage copy 14.png

  • Some user is are Identyty id like auth0|622b662747f4880068fc4ef5 and sime event have ann_01D778KQYZ2B7ME52C74RYV2M8 or usr_xxxxxxx This make it hard to agreggate data since one user can have 3 or more ids

  • Some data are stored in reunite schemaa and some in default this is explained in docs but lead us to confusion Since we don't got any results becose we use wrong schema.

  • Our Webview not work thrue entire training

Arc_2025-09-17_14-37_VoYnVLZf@2x.png
Previous page
Next page