Feb 11, 2012

Family Spreadsheets & Facts

Share:

A few days ago, the Family Ranks Spreadsheet was updated. A few new features were added and some facts were gathered as well. What Martin terms “Pageanation” was added to the bottom of the spreadsheet. You can now scroll through 100 families at a time. As of Feb 9th, there are a total of 16,598 registered families.

fr2

You can now view the averages of each family. Simply click on “Show Averages” and the number of Ices, Kills, Fights and Fights Won for each family will be divided by the number of members. To come back to the totals, click on “Hide Averages”.

fr4fr5

When you click on any family name, you will be directed to their unique Family Rank Page. This page provides the family name, a working link to the in game Family Profile Page, the ranking in each category, a  Ice/Kill progress graph, and each data point that has been generated in the past 218 days.

fr13

There is no need to worry if your family or the one you want to view isn’t in the Top 100 or even the Top 1,000. All you need to find the unique page for any family is the Family ID. To get this, use the Family ID Spocklet. Go the the Mafia Wars Family Profile Page of any family (your own included). From your Spockholm Tool Bar, type in Family ID and click on it.

fr7

You will then get the unique Family ID. Just remember the number.

fr8

Go back to the Family Rank Spreadsheet and paste the following into your browser bar.

http://spockon.me/familyrank/family-familyidnumber

No remove the “familyidnumber” and replace it with the Family ID number you just looked up.

fr9

Click enter and you will land on the Family Rank Page. It would have taken a lot of scrolling to find this family but using the method described above makes it easy.

fr10

The Family Rank Spreadsheet lists families in order of their fighting statistics and is updated by Team Spockholm at least once a week. Mike Nestor updates the Family List Spreadsheet which list families in the order they were created and displays their description. The Family List can be found here.

fr11

If you go to the bottom of the Skirmish/Battle Leaderboard, you will only find 15,505 families. The discrepancy of the two numbers could mean one of two things. Either Zynga doesn’t update the list or families aren’t placed on the leaderboards until they participate in a battle. From running the script that pulls up all the families, Mike noticed there were over 17,000 Family ID numbers but only 16,598 families currently exist. We aren’t sure what happened to these missing families.

fr15

There are 905 families with a battle score of 100.

fr16

Mike calculated the number of players registered to families and the total is 564,841. This number doesn’t quite match the application metrics but we all know these are extremely inflated. I can’t imagine there is a large number of actual players who aren’t in a family. Most who oppose the Family Module create a family of one. The total number of players registered in families is probably a more accurate monthly player statistic.

fr12

The total number of players registered in families is probably a more accurate monthly active user statistic which is dwindling away.

fr14

For review, the following chart lists some of the important numbers generated from the Family Data and compares them to the reported application data.

Statistic #
Registered Families 16,598
Player In Families 564,841
Reported Daily Players 520,000
Reported Monthly Players 2,200,000

4 comments:

  1. Reason for so big differences in active accounts with and without family is that few people have 10000 accounts used only to collect WP from lv15 WD.

    ReplyDelete
  2. if it wasn't for all the minis... these numbers would look much, much worst.

    ReplyDelete
  3. Why would the Mutants clan ID 44 be left off this list??

    ReplyDelete

Comments are moderated and will not be published until they are reviewed. Please don't use bad language or insult others. For faster feedback on questions, visit our fan page.