Tab Label vs Page Title vs Page Slug

Since it turns out that last login isn’t really a reliable metric to track (cf. Last Login Date is available on Usage dashboards. Any chance we can get this in our apps?), I’ll approcah this question from a slightly different angle :stuck_out_tongue:

I’m not a PostHog expert, but from what I’ve seen, this kind of analysis isn’t available natively.

That’s said, it’s fairly easy to build your own using SQL (technically HogQL cf. Introducing HogQL: Direct SQL access for PostHog - PostHog). You can query the latest event captured for each user, which givs you a solid last seen timestamp. It’s not the exact login time, but it’s clide enought for most needs.

-- Basic example: get the latest activity timestamp per user
SELECT 
    person_id,
    max(timestamp) AS last_activity
FROM events
GROUP BY person_id
ORDER BY last_activity DESC
LIMIT 100

Glide also offers several built-in ito track user behaviour which might better match your needs depending on your context. You might want to explore:

  • Google Analytics & Tag Manager
  • Koala
  • Mixpanel
  • PostHog
  • Segment

More details available here: https://www.glideapps.com/integrations :wink:

4 Likes