Subpage under development, new version coming soon!
Subject: [idea] Plus and non-plus users
add an else/if to check if their team name changed in the past X weeks is all i can think of (checks match page vs current team name)
we can assume 1 week would do it as registration plus doesnt last long afaik...
obviously its best to do this only on the list of generated teams with plus :)
also it would filter out teams who legitimately did a team name change, but i think there is less who do this than actual new users
we can assume 1 week would do it as registration plus doesnt last long afaik...
obviously its best to do this only on the list of generated teams with plus :)
also it would filter out teams who legitimately did a team name change, but i think there is less who do this than actual new users
It seems that promo plus lasts more than month or the team was assigned a month after date-created (the Indonesian examples was created in first week of June and it had promo plus in first week of April). Moreover, there are some users (like example of Polish user I posted some posts ago) who have real plus since or almost since the beginning of existence of their team.
I will, but next week, I have to update my script and execute it two or three times within five or six days to exclude those fake-plus users.
it looks more or less like that (data from days: 27.08, 30.08 and 2.09 was merged and I did intersection of all three datasets so there should be only teams existing in all datasets included)
Country.................Users.....PLUS.....noPLUS.....Ratio....Banned
Al Maghrib.................25........1.........24......0.04.........0
Andorra.....................6........1..........5......0.17.........0
Argentina.................550.......28........522......0.05.........3
Australia..................56.......11.........45......0.20.........1
Belarus....................22........0.........22......0.00.........0
Bolivia....................30........3.........27......0.10.........0
Bosna i Hercegovina.......299........5........294......0.02.........0
Brasil...................2291......113.......2178......0.05.........4
Bulgaria..................266.......16........250......0.06.........0
Cameroun....................8........0..........8......0.00.........0
Canada.....................38........1.........37......0.03.........0
Chile.....................275.......13........262......0.05.........0
Colombia..................342.......10........332......0.03.........1
Costa Rica.................44........1.........43......0.02.........1
Crna Gora..................49........0.........49......0.00.........0
Cuba......................149........3........146......0.02.........1
Cymru......................16........3.........13......0.19.........1
Daehan Minguk...............7........0..........7......0.00.........0
Danmark...................124.......43.........81......0.35.........0
Deutschland...............400.......93........307......0.23.........0
Ecuador....................66........2.........64......0.03.........0
Eesti.....................224.......31........193......0.14.........0
El Salvador................27........0.........27......0.00.........0
England...................174.......36........138......0.21.........0
France....................588......118........470......0.20.........0
Ghana......................17........0.........17......0.00.........0
Guatemala..................24........0.........24......0.00.........0
Hayastan..................107.......13.........94......0.12.........0
Hellas....................540.......39........501......0.07.........0
Honduras...................26........0.........26......0.00.........0
Hong Kong..................16........0.........16......0.00.........1
Hrvatska..................315.......24........291......0.08.........0
India......................40........0.........40......0.00.........0
Indonesia.................356........5........351......0.01.........3
Ireland....................26........4.........22......0.15.........1
Israel.....................87.......12.........75......0.14.........0
Italia...................1944......465.......1479......0.24.........0
Jamaica....................16........0.........16......0.00.........0
Kenya......................11........0.........11......0.00.........0
Kypros.....................48........5.........43......0.10.........0
Latvija....................65........6.........59......0.09.........0
Lietuva...................107........8.........99......0.07.........2
Makedonija.................60........1.........59......0.02.........0
Malaysia..................211........1........210......0.00.........0
Malta......................87.......19.........68......0.22.........2
Misr.......................96........0.........96......0.00.........3
Moldova....................53........4.........49......0.08.........1
Nederland.................441.......52........389......0.12.........3
New Zealand................13........2.........11......0.15.........1
Nicaragua..................28........0.........28......0.00.........0
Nigeria.....................9........0..........9......0.00.........0
Nippon.....................10........0.........10......0.00.........1
Norge......................81.......27.........54......0.33.........0
Paraguay..................123........2........121......0.02.........2
Pilipinas..................48........1.........47......0.02.........0
Polska...................9908......528.......9380......0.05........24
Portugal.................1011.......16........995......0.02.........3
Prathet Thai...............15........0.........15......0.00.........0
Rossiya...................140........8........132......0.06.........1
Sakartvelo.................43........0.........43......0.00.........0
Schweiz...................165.......57........108......0.35.........1
Scotland...................40........9.........31......0.23.........0
Singapore..................23........0.........23......0.00.........2
Slovenija..................39........0.........39......0.00.........1
Slovensko.................452.......28........424......0.06.........2
South Africa...............10........1..........9......0.10.........1
Srbija....................256.......15........241......0.06.........0
Suomi.....................237.......43........194......0.18.........1
Sverige....................79.......17.........62......0.22.........0
U.A.E......................11........0.........11......0.00.........0
Ukraina...................113........3........110......0.03.........2
Uruguay...................300.......28........272......0.09.........2
USA.......................114.......17.........97......0.15.........0
Venezuela.................224........6........218......0.03.........5
ALL.....................33856.....2582......31274......0.08.......119
Country.................Users.....PLUS.....noPLUS.....Ratio....Banned
Al Maghrib.................25........1.........24......0.04.........0
Andorra.....................6........1..........5......0.17.........0
Argentina.................550.......28........522......0.05.........3
Australia..................56.......11.........45......0.20.........1
Belarus....................22........0.........22......0.00.........0
Bolivia....................30........3.........27......0.10.........0
Bosna i Hercegovina.......299........5........294......0.02.........0
Brasil...................2291......113.......2178......0.05.........4
Bulgaria..................266.......16........250......0.06.........0
Cameroun....................8........0..........8......0.00.........0
Canada.....................38........1.........37......0.03.........0
Chile.....................275.......13........262......0.05.........0
Colombia..................342.......10........332......0.03.........1
Costa Rica.................44........1.........43......0.02.........1
Crna Gora..................49........0.........49......0.00.........0
Cuba......................149........3........146......0.02.........1
Cymru......................16........3.........13......0.19.........1
Daehan Minguk...............7........0..........7......0.00.........0
Danmark...................124.......43.........81......0.35.........0
Deutschland...............400.......93........307......0.23.........0
Ecuador....................66........2.........64......0.03.........0
Eesti.....................224.......31........193......0.14.........0
El Salvador................27........0.........27......0.00.........0
England...................174.......36........138......0.21.........0
France....................588......118........470......0.20.........0
Ghana......................17........0.........17......0.00.........0
Guatemala..................24........0.........24......0.00.........0
Hayastan..................107.......13.........94......0.12.........0
Hellas....................540.......39........501......0.07.........0
Honduras...................26........0.........26......0.00.........0
Hong Kong..................16........0.........16......0.00.........1
Hrvatska..................315.......24........291......0.08.........0
India......................40........0.........40......0.00.........0
Indonesia.................356........5........351......0.01.........3
Ireland....................26........4.........22......0.15.........1
Israel.....................87.......12.........75......0.14.........0
Italia...................1944......465.......1479......0.24.........0
Jamaica....................16........0.........16......0.00.........0
Kenya......................11........0.........11......0.00.........0
Kypros.....................48........5.........43......0.10.........0
Latvija....................65........6.........59......0.09.........0
Lietuva...................107........8.........99......0.07.........2
Makedonija.................60........1.........59......0.02.........0
Malaysia..................211........1........210......0.00.........0
Malta......................87.......19.........68......0.22.........2
Misr.......................96........0.........96......0.00.........3
Moldova....................53........4.........49......0.08.........1
Nederland.................441.......52........389......0.12.........3
New Zealand................13........2.........11......0.15.........1
Nicaragua..................28........0.........28......0.00.........0
Nigeria.....................9........0..........9......0.00.........0
Nippon.....................10........0.........10......0.00.........1
Norge......................81.......27.........54......0.33.........0
Paraguay..................123........2........121......0.02.........2
Pilipinas..................48........1.........47......0.02.........0
Polska...................9908......528.......9380......0.05........24
Portugal.................1011.......16........995......0.02.........3
Prathet Thai...............15........0.........15......0.00.........0
Rossiya...................140........8........132......0.06.........1
Sakartvelo.................43........0.........43......0.00.........0
Schweiz...................165.......57........108......0.35.........1
Scotland...................40........9.........31......0.23.........0
Singapore..................23........0.........23......0.00.........2
Slovenija..................39........0.........39......0.00.........1
Slovensko.................452.......28........424......0.06.........2
South Africa...............10........1..........9......0.10.........1
Srbija....................256.......15........241......0.06.........0
Suomi.....................237.......43........194......0.18.........1
Sverige....................79.......17.........62......0.22.........0
U.A.E......................11........0.........11......0.00.........0
Ukraina...................113........3........110......0.03.........2
Uruguay...................300.......28........272......0.09.........2
USA.......................114.......17.........97......0.15.........0
Venezuela.................224........6........218......0.03.........5
ALL.....................33856.....2582......31274......0.08.......119
Hmmm, it looks like the situation didn't change much since first days of July.
Also, something went wrong and not all teams are included. The ones with unicode characters in their names are not. Nevertheless, the summary should be proper. I will made some fixes tomorrow.
table with missing countries:
Country.................Users.....PLUS.....noPLUS.....Ratio....Banned
Al Maghrib.................25........1.........24......0.04.........0
al-Jazā’ir.................20........2.........18......0.10.........0
Andorra.....................6........1..........5......0.17.........0
Argentina.................550.......28........522......0.05.........3
as-Saʻūdiyya................5........0..........5......0.00.........0
Australia..................56.......11.........45......0.20.........1
Azərbaycan................210........3........207......0.01.........9
Belarus....................22........0.........22......0.00.........0
België....................646.......74........572......0.11.........0
Bolivia....................30........3.........27......0.10.........0
Bosna i Hercegovina.......299........5........294......0.02.........0
Brasil...................2291......113.......2178......0.05.........4
Bulgaria..................266.......16........250......0.06.........0
Cameroun....................8........0..........8......0.00.........0
Canada.....................38........1.........37......0.03.........0
Česká republika...........939.......84........855......0.09.........5
Chile.....................275.......13........262......0.05.........0
Colombia..................342.......10........332......0.03.........1
Costa Rica.................44........1.........43......0.02.........1
Crna Gora..................49........0.........49......0.00.........0
Cuba......................149........3........146......0.02.........1
Cymru......................16........3.........13......0.19.........1
Daehan Minguk...............7........0..........7......0.00.........0
Danmark...................124.......43.........81......0.35.........0
Deutschland...............400.......93........307......0.23.........0
Ecuador....................66........2.........64......0.03.........0
Eesti.....................224.......31........193......0.14.........0
El Salvador................27........0.........27......0.00.........0
England...................174.......36........138......0.21.........0
España...................1016.......77........939......0.08.........4
France....................588......118........470......0.20.........0
Ghana......................17........0.........17......0.00.........0
Guatemala..................24........0.........24......0.00.........0
Hayastan..................107.......13.........94......0.12.........0
Hellas....................540.......39........501......0.07.........0
Honduras...................26........0.........26......0.00.........0
Hong Kong..................16........0.........16......0.00.........1
Hrvatska..................315.......24........291......0.08.........0
India......................40........0.........40......0.00.........0
Indonesia.................356........5........351......0.01.........3
Īrān........................8........0..........8......0.00.........0
Ireland....................26........4.........22......0.15.........1
Ísland......................7........2..........5......0.29.........0
Israel.....................87.......12.........75......0.14.........0
Italia...................1944......465.......1479......0.24.........0
Jamaica....................16........0.........16......0.00.........0
Kazakhstán.................11........0.........11......0.00.........0
Kenya......................11........0.........11......0.00.........0
Kypros.....................48........5.........43......0.10.........0
Latvija....................65........6.........59......0.09.........0
Lëtzebuerg..................7........1..........6......0.14.........0
Lietuva...................107........8.........99......0.07.........2
Magyarország..............938.......54........884......0.06.........7
Makedonija.................60........1.........59......0.02.........0
Malaysia..................211........1........210......0.00.........0
Malta......................87.......19.........68......0.22.........2
México....................183........5........178......0.03.........0
Misr.......................96........0.........96......0.00.........3
Moldova....................53........4.........49......0.08.........1
Nederland.................441.......52........389......0.12.........3
New Zealand................13........2.........11......0.15.........1
Nicaragua..................28........0.........28......0.00.........0
Nigeria.....................9........0..........9......0.00.........0
Nippon.....................10........0.........10......0.00.........1
Norge......................81.......27.........54......0.33.........0
Österreich.................99.......24.........75......0.24.........0
O‘zbekiston.................5........0..........5......0.00.........0
Panamá.....................57........1.........56......0.02.........2
Paraguay..................123........2........121......0.02.........2
Perú......................315........5........310......0.02.........2
Pilipinas..................48........1.........47......0.02.........0
Polska...................9908......528.......9380......0.05........24
Portugal.................1011.......16........995......0.02.........3
Prathet Thai...............15........0.........15......0.00.........0
República Dominicana.......17........0.........17......0.00.........0
România..................2678......144.......2534......0.05.........5
Rossiya...................140........8........132......0.06.........1
Sakartvelo.................43........0.........43......0.00.........0
Schweiz...................165.......57........108......0.35.........1
Scotland...................40........9.........31......0.23.........0
Sénégal....................21........0.........21......0.00.........0
Shqipëria..................33........1.........32......0.03.........0
Singapore..................23........0.........23......0.00.........2
Slovenija..................39........0.........39......0.00.........1
Slovensko.................452.......28........424......0.06.........2
South Africa...............10........1..........9......0.10.........1
Srbija....................256.......15........241......0.06.........0
Suomi.....................237.......43........194......0.18.........1
Sverige....................79.......17.........62......0.22.........0
Tūnis.......................9........0..........9......0.00.........0
Türkiye..................1637.......63.......1574......0.04.........3
U.A.E......................11........0.........11......0.00.........0
Ukraina...................113........3........110......0.03.........2
Uruguay...................300.......28........272......0.09.........2
USA.......................114.......17.........97......0.15.........0
Venezuela.................224........6........218......0.03.........5
Việt Nam..................437........9........428......0.02.........0
Zhōngguó..................281.......19........262......0.07.........5
ALL.....................33856.....2582......31274......0.08.......119
Country.................Users.....PLUS.....noPLUS.....Ratio....Banned
Al Maghrib.................25........1.........24......0.04.........0
al-Jazā’ir.................20........2.........18......0.10.........0
Andorra.....................6........1..........5......0.17.........0
Argentina.................550.......28........522......0.05.........3
as-Saʻūdiyya................5........0..........5......0.00.........0
Australia..................56.......11.........45......0.20.........1
Azərbaycan................210........3........207......0.01.........9
Belarus....................22........0.........22......0.00.........0
België....................646.......74........572......0.11.........0
Bolivia....................30........3.........27......0.10.........0
Bosna i Hercegovina.......299........5........294......0.02.........0
Brasil...................2291......113.......2178......0.05.........4
Bulgaria..................266.......16........250......0.06.........0
Cameroun....................8........0..........8......0.00.........0
Canada.....................38........1.........37......0.03.........0
Česká republika...........939.......84........855......0.09.........5
Chile.....................275.......13........262......0.05.........0
Colombia..................342.......10........332......0.03.........1
Costa Rica.................44........1.........43......0.02.........1
Crna Gora..................49........0.........49......0.00.........0
Cuba......................149........3........146......0.02.........1
Cymru......................16........3.........13......0.19.........1
Daehan Minguk...............7........0..........7......0.00.........0
Danmark...................124.......43.........81......0.35.........0
Deutschland...............400.......93........307......0.23.........0
Ecuador....................66........2.........64......0.03.........0
Eesti.....................224.......31........193......0.14.........0
El Salvador................27........0.........27......0.00.........0
England...................174.......36........138......0.21.........0
España...................1016.......77........939......0.08.........4
France....................588......118........470......0.20.........0
Ghana......................17........0.........17......0.00.........0
Guatemala..................24........0.........24......0.00.........0
Hayastan..................107.......13.........94......0.12.........0
Hellas....................540.......39........501......0.07.........0
Honduras...................26........0.........26......0.00.........0
Hong Kong..................16........0.........16......0.00.........1
Hrvatska..................315.......24........291......0.08.........0
India......................40........0.........40......0.00.........0
Indonesia.................356........5........351......0.01.........3
Īrān........................8........0..........8......0.00.........0
Ireland....................26........4.........22......0.15.........1
Ísland......................7........2..........5......0.29.........0
Israel.....................87.......12.........75......0.14.........0
Italia...................1944......465.......1479......0.24.........0
Jamaica....................16........0.........16......0.00.........0
Kazakhstán.................11........0.........11......0.00.........0
Kenya......................11........0.........11......0.00.........0
Kypros.....................48........5.........43......0.10.........0
Latvija....................65........6.........59......0.09.........0
Lëtzebuerg..................7........1..........6......0.14.........0
Lietuva...................107........8.........99......0.07.........2
Magyarország..............938.......54........884......0.06.........7
Makedonija.................60........1.........59......0.02.........0
Malaysia..................211........1........210......0.00.........0
Malta......................87.......19.........68......0.22.........2
México....................183........5........178......0.03.........0
Misr.......................96........0.........96......0.00.........3
Moldova....................53........4.........49......0.08.........1
Nederland.................441.......52........389......0.12.........3
New Zealand................13........2.........11......0.15.........1
Nicaragua..................28........0.........28......0.00.........0
Nigeria.....................9........0..........9......0.00.........0
Nippon.....................10........0.........10......0.00.........1
Norge......................81.......27.........54......0.33.........0
Österreich.................99.......24.........75......0.24.........0
O‘zbekiston.................5........0..........5......0.00.........0
Panamá.....................57........1.........56......0.02.........2
Paraguay..................123........2........121......0.02.........2
Perú......................315........5........310......0.02.........2
Pilipinas..................48........1.........47......0.02.........0
Polska...................9908......528.......9380......0.05........24
Portugal.................1011.......16........995......0.02.........3
Prathet Thai...............15........0.........15......0.00.........0
República Dominicana.......17........0.........17......0.00.........0
România..................2678......144.......2534......0.05.........5
Rossiya...................140........8........132......0.06.........1
Sakartvelo.................43........0.........43......0.00.........0
Schweiz...................165.......57........108......0.35.........1
Scotland...................40........9.........31......0.23.........0
Sénégal....................21........0.........21......0.00.........0
Shqipëria..................33........1.........32......0.03.........0
Singapore..................23........0.........23......0.00.........2
Slovenija..................39........0.........39......0.00.........1
Slovensko.................452.......28........424......0.06.........2
South Africa...............10........1..........9......0.10.........1
Srbija....................256.......15........241......0.06.........0
Suomi.....................237.......43........194......0.18.........1
Sverige....................79.......17.........62......0.22.........0
Tūnis.......................9........0..........9......0.00.........0
Türkiye..................1637.......63.......1574......0.04.........3
U.A.E......................11........0.........11......0.00.........0
Ukraina...................113........3........110......0.03.........2
Uruguay...................300.......28........272......0.09.........2
USA.......................114.......17.........97......0.15.........0
Venezuela.................224........6........218......0.03.........5
Việt Nam..................437........9........428......0.02.........0
Zhōngguó..................281.......19........262......0.07.........5
ALL.....................33856.....2582......31274......0.08.......119
I will update soon, on Friday or on Saturday this week.
(edited)
(edited)