Mobile apps: where are they in the website?

Community
1

i knew they exist since i use it daily on my smartphone.

i wanted to send the link to download it to some friends… but it was difficult to find them in the official website! they are listed in the middle of Discourse features | Discourse - Civilized Discussion

maybe they deserve a line in the footer?

here they are:

question: could we know in the reports how many use the mobile apps? is there a tag somewhere?

10 Likes
2

Great point, thanks @StefanoCecere! We should definitely improve the visibility of our mobile apps on the website.

@rishabh can you drive this, please?

We don’t have a report yet, but you can get this info using Data Explorer. This query will give you a list of authenticated users using the mobile app:

-- [params]
-- date :start_date = 2024-11-30
-- date :end_date = 2024-12-26

WITH hub_visits AS (
  SELECT 
    user_id,
    MIN(created_at) as first_visit,
    MAX(created_at) as last_visit,
    COUNT(*) as total_visits
  FROM user_auth_token_logs
  WHERE user_agent LIKE '%DiscourseHub%'
    AND created_at BETWEEN :start_date AND :end_date
  GROUP BY user_id
)
SELECT 
  hv.user_id,
  u.username,
  hv.first_visit,
  hv.last_visit,
  hv.total_visits
FROM hub_visits hv
JOIN users u ON u.id = hv.user_id
ORDER BY hv.last_visit DESC
4 Likes
3

thank you!!!
(PS. in a 1300 users forum… i am the only one using the mobile Hub!
let’s see if someone else will try it after my advertising :wink:

4 Likes
4

The Hub is okey when a user uses several forums or need an url other than from topics.

PWA is easier solution.

5 Likes
6

Is this platform-independent? Running the query on our forum, it seems to be missing the users who are using Discourse Hub on Android.

Is there a query to separate PWA access from other mobile access?

Thanks! We’re pushing use of Discourse Hub/PWA to our users and being able track like this is very useful!

3 Likes
7

On Android, Hub launches either the default browser or the PWA. So these stars are for iOS only. We can get Android app user stats differently though, I will take a look and post a separate query shortly.

PWA visit data collection needs to go a different route as well.

2 Likes
8

Thanks @pmusaraj! I’d love a query that would let me see:

  • iOS Discourse Hub
  • iOS Discourse PWA
  • Android Discourse Hub
  • Android PWA

We’ve just published a how-to on the forum showing members how to set up any of those four methods. Really like to be able to track change in usage! Thanks!

3 Likes