Data request: Average number of SBC Connect Accounts per profile

[atronse]

Looking to see if ONE user has created multiple businesses..
For example - a law firm

[atronse]

We would like to query the data to find out the average number of SBC Connect accounts per profile. Would also be nice to know the median number, the max number of accounts possible, and highest number of accounts in one profile.

[atronse]

@janisrogers @mbertucci Created this ticket as per our conversation yesterday. Thanks!

[janisrogers]

In addition to the above, it would also be good to know the distribution, i.e. what percent of users only have 1 account, what percent have 2-3, what percent have 3-5, what percent have more than 5, ...

[atronse]

Chatted with Genevieve about his today and she is going to have her new coop student look into it.

[mbertucci]

@gprimeau Hey Genevieve. Any news on the statistics? Thank you :)

[gprimeau]

@mbertucci my coop student doesn't really start working with me until next week.
Is there a specific date this request is required?

[thorwolpert]

So 88876 people only have 1 account they are associated with:

number of accounts	number of users
1	88876
2	3238
3	331
4	60
5	21
6	22
7	38
8	5
9	4
10	2
11	2
12	1
14	2
19	1
20	1
23	2
28	2
52	1
53	1
56	2
57	1

[gprimeau]

@thorwolpert Thank you! for doing this for them.. Much appreciated

[atronse]

This is great! Thank you @thorwolpert and thank you @gprimeau

[atronse]

Added stats to new Quantitative Metrics document here: https://bcgov.sharepoint.com/:w:/r/teams/09399/Shared%20Documents/Product%20Team%20Chat/User%20research/Quantitative%20data.docx?d=wa775a8ef1f714b34894ddfcf2b0e9f9a&csf=1&web=1&e=6eUdxG

[atronse]

96% of users have 1 account. 99.9% of users have 4 or less accounts.

[mbertucci]

Thank you Alexis From: Alexis Ronse ***@***.***> Sent: Thursday, May 9, 2024 10:50 AM To: bcgov/entity ***@***.***> Cc: Bertucci, Mikaela CITZ:EX ***@***.***>; Mention ***@***.***> Subject: Re: [bcgov/entity] Data request: Average number of SBC Connect Accounts per profile (Issue #21058) [EXTERNAL] This email came from an external source. Only open attachments or links that you are expecting from a known sender. 96% of users have 1 account. 99.9% of users have 4 or less accounts. - Reply to this email directly, view it on GitHub<#21058 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ANF3VCYVJ3OG3R2NYVURPALZBOZK5AVCNFSM6AAAAABHAZXCGKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMBTGE2DCOBUHA>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>