for reasons we want to discontinue that and would like to know the impact it would have on our user base. is there an easy way to find that out?

These Data Explorer queries can help in these cases. 1ª List of users per login with Facebook WITH target_user_ids AS ( SELECT id FROM users WHERE staged = false AND active = true AND last_seen_at IS NOT NULL) SELECT provider_name, user_id, info->>'name' name_user, info->>'email' email_user, info->>'image' image_user FROM user_associated_accounts ua WHERE user_id IN (SELECT id FROM target_user_ids) AND provider_name = 'facebook' provider_name user_id name email image facebook 1 User1 user1@gmail.com https://graph.facebook.com/.../photo1.jpg facebook 2 User2 user2@yahoo.com https://graph.facebook.com/.../photo2.jpg 2ª List of users per external login method discord facebook github google_oauth2 twitter WITH target_user_ids AS ( SELECT id FROM users WHERE staged = false AND active = true AND last_seen_at IS NOT NULL) SELECT provider_name, user_id, info->>'name' AS name, info->>'email' AS email, info->>'image' AS image FROM user_associated_accounts ua WHERE user_id IN (SELECT id FROM target_user_ids) provider_name user_id name email image google_oauth2 1 User1 user1@gmail.com https://lh3.googleusercontent.com/.../p1.jpg facebook 2 User2 user2@yahoo.com https://graph.facebook.com/.../p2.jpg twitter 3 User3 user3@gmail.com http://pbs.twimg.com/profile_img/.../p1.jpg 3ª Number of users per external login method WITH target_user_ids AS ( SELECT id FROM users WHERE staged = false AND active = true AND last_seen_at IS NOT NULL) SELECT provider_name, COUNT(user_id) AS qtd FROM user_associated_accounts ua WHERE user_id IN (SELECT id FROM target_user_ids) GROUP BY provider_name UNION SELECT 'github', COUNT(user_id) FROM github_user_infos WHERE user_id IN (SELECT id FROM target_user_ids) ORDER BY provider_name provider_name qtd discord 10 facebook 100 github 400 google_oauth2 500 twitter 200

There’s some discussion about this here [画像] How do I see Facebook signups? Support Hi, is there any way to see who of my new forum sign-ups have used the Facebook login/sign-up plugin? Many thanks, Torsten

@david once your work consolidating is done, can you add a quick built-in report to data explorer that counts users per auth method. I think it can help make decisions in some cases.

Definitely :+1:. Once the new stuff is done we will also be able to report on “last used date”, which should be useful for deciding which methods are important.

Thank you for posting these queries! 2ª just answered a question I had. (Keyword boost: list oauth users, find oauth users, report of oauth users)

「Facebook でログイン」を使用したすべてのユーザーを検索

コミュニティデータとレポート

Johani (Joe) 2018 年 12 月 30 日午後 2:10 2

There’s some discussion about this here

トピック		返信	表示
Count number of Facebook logins? Product Support	2	681	2020 年 12 月 12 日
Login type report / list? Product Support	4	635	2023 年 6 月 14 日
How to check how many users are using Facebook login? Product Support	1	854	2018 年 9 月 28 日
How to find all users using a specific login provider? Community Building	3	1452	2019 年 9 月 2 日
Is there a way of finding users who authenticated with Facebook? Product Support	1	631	2020 年 12 月 17 日

「Facebook でログイン」を使用したすべてのユーザーを検索

関連トピック