search

bcgov / entity

ServiceBC Registry Team working on Legal Entities
Apache License 2.0
23 stars 57 forks source link

Data request: Average number of SBC Connect Accounts per profile #21058

Open atronse opened 2 weeks ago

atronse commented 2 weeks ago

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

atronse commented 2 weeks ago

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 commented 2 weeks ago

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

janisrogers commented 2 weeks ago

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 commented 2 weeks ago

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

mbertucci commented 1 week ago

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

gprimeau commented 1 week ago

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

thorwolpert commented 1 week ago

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 commented 1 week ago

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

atronse commented 1 week ago

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

atronse commented 1 week ago

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 commented 1 week ago

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

mbertucci commented 1 week ago

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 GitHubhttps://github.com/bcgov/entity/issues/21058#issuecomment-2103141848, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ANF3VCYVJ3OG3R2NYVURPALZBOZK5AVCNFSM6AAAAABHAZXCGKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMBTGE2DCOBUHA. You are receiving this because you were mentioned.Message ID: @.**@.>>