+ Reply to Thread
Page 1 of 3 1 2 3 Last
Results 1 to 10 of 30
  1. #1

    Join Date
    Apr 2010
    Location
    Chicago, IL
    Posts
    1,379
    Rep Power
    13
    Vyrolan will become famous soon enough

    Team Stats (yay data mining ze armory)

    (Warning: Big post here...lots of data pulled from armory and stuff...may be interesting to some...maybe not to all...sorry.)

    So I'm a gigantic computer nerd IRL and work professionally with data...and I got bored so over the last couple of days I wrote an application to pull down tons of information from the armory...I'm still expanding this but I've gotten enough to put together some interesting team stats...I'm going to present them here just as a show and tell and to see what people think.

    I'm posting this in 5v5 because there's no great place for it and the stats are for a 5v5 team...I don't know how many people actually read this section but hopefully they will see it.

    Our team is Ele, MM, Unholy, DIsc, Holy... (We're considering changing the DK to an affi lock.) The data only covers the last 86 games because before that we had a different comp and so it's less relevant.

    My "feeling" as we've played games is that our performance ebbs and flows with the hunter's performance...when he plays well we win, when he gets shutdown bad, we lose. Consequently I've felt like we play well on maps like Ruins and bad on maps like Dalaran (where they can LoS him very hard). I wanted to see if the data supports this:
    Code:
    Map                  W   L  GP  Win%   AL ALW ALL
    ==================================================
    All Maps            50  36  86  58.1  129 126 135
    Blade's Edge Arena  13   6  19  68.4  124 111 154
    Dalaran Sewers      10  12  22  45.5  115 106 123
    Nagrand Arena        8   9  17  47.1  159 195 128
    Ruins of Lordaeron  10   1  11  90.9  116 111 171
    The Ring of Valor    9   8  17  52.9  132 125 141
    So you can see we're 10-1 on Ruins and 13-6 on Blade's Edge...both of which are good hunter maps...and 10-12 on Dalaran, our worst map. =( Clearly we need to abuse fear bombs and thunderstorms more on that map to get them out into the open.
    Surprising to me was Nagrand...I would have expected us to do better...but I think it's another map where the enemies easily LoS and our hunter and DK aren't the best at using LoS and get blown up particularly on Nagrand. I think in general we end up pulling the healers into bad spots but we tend to play aggressively to try to dissuade our opponents from going on the hunter.

    For the curious, the AL, ALW, and ALL columns are average length of the games. All games, wins, and losses respectively. The minute of preparation is removed from the times. I was wondering if we had particularly longer or shorter games on different maps to see if that would tell me anything...but I don't see anything of particular value there.

    Next, I wondered what our damage looked like...since pure damage can vary so greatly in a game depending on length/comp/etc...I wasn't expecting to find much here... I went through a few iterations and finally settled on a few metrics that seemed at least somewhat reasonable. I looked at average damage done per minute in wins (WAD) and losses (LAD) as well as "damage done per damage taken". My feeling has been that our hunter does very little damage when they are on him...and in many ways the same of the DK. So I was hoping that would play out in the numbers.
    Code:
    Name       WAD  WDDPDT  WD     LAD   LDDPDT   LD%
    ==================================================
    DW      71,283  9.654    0  51,190   1.845   71.8
    ET      45,656  2.292    0  22,263   0.722   48.8
    IH       4,809  0.286    1     443   0.016    9.2
    NI       1,962  0.163    0     647   0.029   33.0
    VY      59,160  3.109    0  27,249   0.924   46.1
    (DW is the DK, ET is the hunter, IH/NI are the healers, and VY is the ele.)

    Also in this table is the "times died in a game we won" in the WD column...as you can see...we only won one game when someone died...and that was when our priest died.

    As for the damage, all of us seem to less damage when we lose by a decent margin. I was very surprised by the DK's falloff...he does 9.654 damage per point of damage taken in wins...but only 1.845 in losses...that took me by surprise and I have no great explanation. The DDPDT numbers are lower in both for the hunter than for the elem though, which seems to support our idea of aggressively trying to keep the other team from going on the hunter since he seems to be shutdown more easily and completely than the others.

    It wasn't exactly the pattern I expected and wasn't really as insightful as I hoped...so I did a map-by-map analysis with the same data...here it is with the healers removed:
    Code:
    Map                 Name     WAD    WDDPDT   WD      LAD   LDDPDT     LD%
    ==========================================================================
    Blade's Edge Arena  DW    74,891    19.307    0   47,553    1.811    63.5
    Dalaran Sewers      DW    63,369     8.089    0   51,761    1.856    81.7
    Nagrand Arena       DW    72,625     7.205    0   55,959    1.961    77.1
    Ruins of Lordaeron  DW    75,594    13.431    0   59,766    2.765    79.1
    The Ring of Valor   DW    68,011     7.192    0   47,267    1.634    69.5
    --------------------------------------------------------------------------
    Blade's Edge Arena  ET    53,555     2.548    0   24,080    0.940    45.0
    Dalaran Sewers      ET    43,899     2.689    0   17,116    0.553    39.0
    Nagrand Arena       ET    42,580     1.862    0   22,393    0.885    52.6
    Ruins of Lordaeron  ET    42,181     1.426    0   30,707    0.663    72.8
    The Ring of Valor   ET    44,882     5.440    0   26,105    0.682    58.2
    --------------------------------------------------------------------------
    Blade's Edge Arena  VY    62,924     2.442    0   21,616    0.854    34.4
    Dalaran Sewers      VY    65,919     5.017    0   23,465    0.867    35.6
    Nagrand Arena       VY    53,554     2.432    0   25,309    0.671    47.3
    Ruins of Lordaeron  VY    60,073     3.907    0   49,692    3.620    82.7
    The Ring of Valor   VY    54,800     3.556    0   35,416    1.180    64.6
    The hunter sees his biggest falloffs of DDPDT in wins vs losses on Dalaran and RoV...this makes sense because if they go on him on either map (or use LoS well on Dalaran), he will end up doing almost no damage. The hunter has his highest damage map (in wins) as Blade's Edge which should come as no surprise because we move aggressively to control the bridge so he can just tee off on people.

    The shaman also sees a bad falloff in damage on Dalaran...clearly that's a bad map for us and we need to work on it. The shaman plays ruins very well and the data supports that observation.

    All 3 DPSers are on their low end in damage on Nagrand...clearly we don't play that map very well either...although in the last few sessions we've changed our mindset about that map and it's gone much better.

    So then I got to thinking about our opponents and wondering where our strengths and weaknesses are...first of all, I look at the numbers of healers on the enemy teams:
    Code:
    Heal DPS    W   L  GP  Win%   AL   ALW  ALL
    =============================================
     1    4      9  11  20  45.0    97   93  100
     2    3     38  24  62  61.3   142  138  149
     3    2      2   1   3  66.7   126   96  185
    First of all, we have improved our play against triple healer greatly...if I looked back further (including time before we had the DK), our record was 3-10 or something like that against triple healer. So I'm glad we've turned that around. While only 3 games is hardly a sufficient data set, one thing to note is that our average win against triple healer lasts 96 seconds...the one loss was 185 seconds...win early or go home?

    We're not as strong as we should be against single healer...those teams seem to magnify the survivability problems of some of our players, but I guess 9 and 11 isn't bad. To no surprise, also short games against single healer.

    Since the comps don't say too much interesting, I took a look at the classes we were playing against. Maybe every team with a rogue is good against us...or every team with a mage. In this data, for hybrid classes, if they did more damage than healing, they're a DPS.
    Code:
    Class            W   L  GP  Win%
    =================================
    DeathKnight     13   5  18  72.2
    Druid (DPS)      8   3  11  72.7
    Druid (Heal)    15   3  18  83.3
    Hunter          20   6  26  76.9
    Mage            23  19  42  54.8
    Paladin (DPS)   13   3  16  81.3
    Paladin (Heal)  27  33  60  45.0
    Priest (DPS)     3  13  16  18.8
    Priest (Heal)   30  16  46  65.2
    Rogue           15  13  28  53.6
    Shaman (DPS)    16  26  42  38.1
    Shaman (Heal)   20  10  30  66.7
    Warlock         24  15  39  61.5
    Warrior         19  13  32  59.4
    Wow...3 and 13 against teams with a shadowpriest...fml. Of interest is that we do well against druid healers (15-3), shaman healers (20-10), priest healers (30-16), but worse against paladin healers (27-33). The easiest class to interrupt and silence...I would have expected our best against holy pallies.

    Also it seems we destroy DPS paladins, DPS druids, hunters, and DKs. DPS shamans (could be either ele or enh) are bad for us.

    Lastly...I wanted to the same analysis per map...this is a big table but I'll present it anyway:
    Code:
    Map                  Class           W   L  GP    Win%
    =======================================================
    Blade's Edge Arena   DeathKnight     1   0   1   100.0
    Blade's Edge Arena   Druid (DPS)     2   0   2   100.0
    Blade's Edge Arena   Druid (Heal)    3   0   3   100.0
    Blade's Edge Arena   Hunter          7   0   7   100.0
    Blade's Edge Arena   Mage            8   6  14    57.1
    Blade's Edge Arena   Paladin (DPS)   3   0   3   100.0
    Blade's Edge Arena   Paladin (Heal)  8   5  13    61.5
    Blade's Edge Arena   Priest (DPS)    2   2   4    50.0
    Blade's Edge Arena   Priest (Heal)   7   4  11    63.6
    Blade's Edge Arena   Rogue           5   3   8    62.5
    Blade's Edge Arena   Shaman (DPS)    6   5  11    54.5
    Blade's Edge Arena   Shaman (Heal)   4   1   5    80.0
    Blade's Edge Arena   Warlock         7   3  10    70.0
    Blade's Edge Arena   Warrior         2   1   3    66.7
    -------------------------------------------------------
    Dalaran Sewers       DeathKnight     3   1   4    75.0
    Dalaran Sewers       Druid (DPS)     3   1   4    75.0
    Dalaran Sewers       Druid (Heal)    4   2   6    66.7
    Dalaran Sewers       Hunter          4   1   5    80.0
    Dalaran Sewers       Mage            6   7  13    46.2
    Dalaran Sewers       Paladin (DPS)   3   0   3   100.0
    Dalaran Sewers       Paladin (Heal)  5  11  16    31.3
    Dalaran Sewers       Priest (DPS)    0   6   6     0.0
    Dalaran Sewers       Priest (Heal)   5   5  10    50.0
    Dalaran Sewers       Rogue           2   4   6    33.3
    Dalaran Sewers       Shaman (DPS)    0  10  10     0.0
    Dalaran Sewers       Shaman (Heal)   6   2   8    75.0
    Dalaran Sewers       Warlock         6   5  11    54.5
    Dalaran Sewers       Warrior         3   4   7    42.9
    -------------------------------------------------------
    Nagrand Arena        DeathKnight     2   1   3    66.7
    Nagrand Arena        Druid (DPS)     0   2   2     0.0
    Nagrand Arena        Druid (Heal)    2   0   2   100.0
    Nagrand Arena        Hunter          3   3   6    50.0
    Nagrand Arena        Mage            2   3   5    40.0
    Nagrand Arena        Paladin (DPS)   2   1   3    66.7
    Nagrand Arena        Paladin (Heal)  5   8  13    38.5
    Nagrand Arena        Priest (DPS)    1   2   3    33.3
    Nagrand Arena        Priest (Heal)   5   5  10    50.0
    Nagrand Arena        Rogue           2   3   5    40.0
    Nagrand Arena        Shaman (DPS)    4   5   9    44.4
    Nagrand Arena        Shaman (Heal)   4   4   8    50.0
    Nagrand Arena        Warlock         3   4   7    42.9
    Nagrand Arena        Warrior         5   4   9    55.6
    -------------------------------------------------------
    Ruins of Lordaeron   DeathKnight     1   0   1   100.0
    Ruins of Lordaeron   Druid (DPS)     1   0   1   100.0
    Ruins of Lordaeron   Druid (Heal)    1   0   1   100.0
    Ruins of Lordaeron   Hunter          2   0   2   100.0
    Ruins of Lordaeron   Mage            4   0   4   100.0
    Ruins of Lordaeron   Paladin (DPS)   4   0   4   100.0
    Ruins of Lordaeron   Paladin (Heal)  5   1   6    83.3
    Ruins of Lordaeron   Priest (DPS)    0   1   1     0.0
    Ruins of Lordaeron   Priest (Heal)   9   0   9   100.0
    Ruins of Lordaeron   Rogue           4   0   4   100.0
    Ruins of Lordaeron   Shaman (DPS)    5   0   5   100.0
    Ruins of Lordaeron   Shaman (Heal)   2   1   3    66.7
    Ruins of Lordaeron   Warlock         5   1   6    83.3
    Ruins of Lordaeron   Warrior         4   1   5    80.0
    -------------------------------------------------------
    The Ring of Valor    DeathKnight     6   3   9    66.7
    The Ring of Valor    Druid (DPS)     2   0   2   100.0
    The Ring of Valor    Druid (Heal)    5   1   6    83.3
    The Ring of Valor    Hunter          4   2   6    66.7
    The Ring of Valor    Mage            3   3   6    50.0
    The Ring of Valor    Paladin (DPS)   1   2   3    33.3
    The Ring of Valor    Paladin (Heal)  4   8  12    33.3
    The Ring of Valor    Priest (DPS)    0   2   2     0.0
    The Ring of Valor    Priest (Heal)   4   2   6    66.7
    The Ring of Valor    Rogue           2   3   5    40.0
    The Ring of Valor    Shaman (DPS)    1   6   7    14.3
    The Ring of Valor    Shaman (Heal)   4   2   6    66.7
    The Ring of Valor    Warlock         3   2   5    60.0
    The Ring of Valor    Warrior         5   3   8    62.5
    Blah...0 and 10 against DPS shamans on Dalaran...they apparently thunderstorm much much better than we do. Also 0 and 6 against shadowpriests on Dalran. On Ring of Valor, 1-6 against DPS shamans and 4-8 against holy pallies...wow...we gotta do better than that...


    So yea...that's what I got...the armory is pretty easy...I wrote all of the stuff to pull all the data in just the last couple of days. It took hardly any time to pull down the full game history for our team. I'm expanding it more to pull down stats/gear/specs for all of the players involved...then I'll be able to do some more detailed analysis. I wish more information about each game was available but the armory only presents damage and healing statistics. =(

    What ya'll think?

  2. #2

    Join Date
    Apr 2010
    Location
    BC
    Posts
    465
    Rep Power
    0
    Spammer is an unknown quantity at this point

    Re: Team Stats (yay data mining ze armory)

    Very cool, nice work. Sure gives you alot to chew on.

  3. #3

    Join Date
    Apr 2010
    Location
    Chicago, IL
    Posts
    1,379
    Rep Power
    13
    Vyrolan will become famous soon enough

    Re: Team Stats (yay data mining ze armory)

    Quote Originally Posted by Spammer
    Very cool, nice work. Sure gives you alot to chew on.
    Yea I was discussing it with some of the guys and it's made us really think about what we should be trying to do on certain maps and/or against certain opponents.

    I also ran it for a few other teams on our battlegroup so I can look at their numbers and try to see what their weaknesses are. =) Pulling down the data is quick and simple and I've got all the queries saved. =)

  4. #4

    Join Date
    Mar 2010
    Location
    Oklahoma City
    Posts
    192
    Rep Power
    5
    Mirithal is an unknown quantity at this point

    Re: Team Stats (yay data mining ze armory)

    Is there any way i can get a copy of your program to run for my own teams? That would rock!

  5. #5

    Join Date
    Apr 2010
    Location
    Chicago, IL
    Posts
    1,379
    Rep Power
    13
    Vyrolan will become famous soon enough

    Re: Team Stats (yay data mining ze armory)

    Quote Originally Posted by Mirithal
    Is there any way i can get a copy of your program to run for my own teams? That would rock!
    I don't have it as a distributable thing...plus I'd have to distribute a backup of the SQL Server database and you'd have to one of those... I'd be glad to run it for anyone's team and give the numbers for them though...just need team size, realm name, and team name.

    I'm expanding it now to pull down stats/equipment/specs for all of the players it finds...and then I'm just going to unleash it on all the teams in the arena ladder. The biggest problems to overcome aren't technical at all...they have more to do with detecting if the character is logged in PVP gear (fairly easy by how much resil is present) but also which specs are the PVP ones. I'll probably just pull both specs/glyphs for each player so I can sort it out later on the query side. But the gear is a bigger problem because if someone is logged in PVE gear it's less useful. I'll probably keep multiple gear sets for each character in my database so I can hopefully identify the right ones...if all but a few pieces are the same I'll know that's just an update to existing set rather than a new set.

  6. #6

    Join Date
    Apr 2010
    Location
    Chicago, IL
    Posts
    1,379
    Rep Power
    13
    Vyrolan will become famous soon enough

    Re: Team Stats (yay data mining ze armory)

    So I got a PM from someone asking me to run the numbers for his 3v3 team... I've been continuing to expand both my collection and my reporting. I'll soon be pulling down snapshots of gear/spec/stats as I scan the teams/games... Then I'll be letting it run pretty much continuously across all teams in all ladders on all battlegroups (US only for now...dunno how many changes in the XMLs for EU armory). So soon I'll be able to answer a lot of the random questions like "What percentage of holy paladins above 2K playing TSG spec 3/3 into Sacred Cleansing? ...or spec 2/3...or 1/3...or 0/3?"

    Anyway, I've also made a program do pull the team report and format everything for this forum without me having to do it by hand like I did before...so here's an example I've done for the PM request...I've anonymized the names (he'll know who they are).

    A lot of the same information as before...a few abbreviations to note are that "ddpdt" is the "damage done per damage taken" metric. The "dtpm" in the opponent class analysis is "damage taken per minute"...this show how much damage you're putting into those classes.


    For what it's worth...this team is playing Disc / RDruid / Arms...


    Map Statistics
    Code:
    map                 won  loss  total  win_pct  avg_length  avg_length_win  avg_length_loss
    ===========================================================================================
    All Maps            123    91    214    57.50         189             213              156
    Blade's Edge Arena   22    20     42    52.40         172             217              122
    Dalaran Sewers       32    20     52    61.50         192             199              181
    Nagrand Arena        31    15     46    67.40         188             207              148
    Ruins of Lordaeron   17    12     29    58.60         227             236              214
    The Ring of Valor    21    24     45    46.70         178             222              140

    Player Statistics
    Code:
    player_name  win_avg_dmg  win_ddpdt  win_died  loss_avg_dmg  loss_ddpdt  loss_dmg_pct
    ======================================================================================
    Bub                8,971       0.24         0         3,731        0.09         41.60
    Jokr              55,922       4.86         0        14,630        0.41         26.20
    Jotrap                                                7,414        0.28
    Mcb               41,466       1.10         0        28,958        0.71         69.80
    Mri                3,132       0.21         0         1,484        0.06         47.40
    Mthal              3,896       0.25         0         1,422        0.05         36.50
    Ryd               67,320       1.96         0        59,515        1.37         88.40
    Shrap              6,926       0.53         0           684        0.02          9.90
    Shty                                                  3,345        0.08

    Player Statistics by Map
    Code:
    player_name  map                 win_dmg  win_ddpdt  loss_dmg  loss_ddpdt  loss_dmg_pct
    ========================================================================================
    Bub          Blade's Edge Arena    9,768       0.24     4,540        0.09         46.50
    Bub          Dalaran Sewers        8,284       0.23     3,051        0.07         36.80
    Bub          Nagrand Arena         9,080       0.34     4,187        0.12         46.10
    Bub          Ruins of Lordaeron    6,849       0.21     3,489        0.08         50.90
    Bub          The Ring of Valor    10,896       0.21     3,786        0.08         34.70
    ----------------------------------------------------------------------------------------
    Jokr         Blade's Edge Arena                           818        0.02
    Jokr         Dalaran Sewers       42,044       7.47    49,050        1.40        116.70
    Jokr         Nagrand Arena        67,450       4.12
    ----------------------------------------------------------------------------------------
    Jotrap       Blade's Edge Arena                        10,976        0.20
    Jotrap       Dalaran Sewers                             4,561        0.67
    Jotrap       Nagrand Arena                             10,673        0.30
    Jotrap       The Ring of Valor                          6,808        0.26
    ----------------------------------------------------------------------------------------
    Mcb          Blade's Edge Arena   47,447       0.97    38,424        0.74         81.00
    Mcb          Dalaran Sewers       28,720       1.05    30,967        0.78        107.80
    Mcb          Nagrand Arena        47,198       1.03    27,864        0.64         59.00
    Mcb          Ruins of Lordaeron   48,958       2.19    20,651        0.53         42.20
    Mcb          The Ring of Valor    38,389       1.13    25,058        0.78         65.30
    ----------------------------------------------------------------------------------------
    Mri          Blade's Edge Arena    3,623       0.21       783        0.03         21.60
    Mri          Dalaran Sewers        3,279       0.21     1,320        0.07         40.30
    Mri          Nagrand Arena         3,260       0.23     1,227        0.06         37.60
    Mri          Ruins of Lordaeron    2,354       0.22     1,361        0.07         57.80
    Mri          The Ring of Valor     2,978       0.18     2,245        0.07         75.40
    ----------------------------------------------------------------------------------------
    Mthal        Blade's Edge Arena    3,846       0.32     1,888        0.08         49.10
    Mthal        Dalaran Sewers        4,998       0.36     2,017        0.07         40.40
    Mthal        Nagrand Arena         2,398       0.21       956        0.08         39.90
    Mthal        Ruins of Lordaeron    3,678       0.17       382        0.01         10.40
    Mthal        The Ring of Valor     3,698       0.16     1,084        0.05         29.30
    ----------------------------------------------------------------------------------------
    Ryd          Blade's Edge Arena   66,120       2.39    60,932        1.62         92.20
    Ryd          Dalaran Sewers       69,259       2.21    64,705        1.40         93.40
    Ryd          Nagrand Arena        66,832       1.61    59,734        0.99         89.40
    Ryd          Ruins of Lordaeron   69,215       1.51    59,757        1.35         86.30
    Ryd          The Ring of Valor    64,966       2.50    52,741        1.65         81.20
    ----------------------------------------------------------------------------------------
    Shrap        Blade's Edge Arena                         1,448        0.03
    Shrap        Dalaran Sewers        4,696       0.20         0        0.00          0.00
    Shrap        Nagrand Arena         8,778       1.97
    Shrap        The Ring of Valor                              0        0.00
    ----------------------------------------------------------------------------------------
    Shty         Blade's Edge Arena                         4,166        0.11
    Shty         Dalaran Sewers                             5,630        0.11
    Shty         Nagrand Arena                                719        0.02
    Shty         The Ring of Valor                            504        0.01

    Opponent Composition Statistics
    Code:
    heal  dps  won  lost  total  win_pct  avg_length  avg_length_win  avg_length_loss
    ==================================================================================
       0    3    1     1      2    50.00         135             114              157
       1    2   95    59    154    61.70         179             200              144
       2    1    4     3      7    57.10         376             345              417

    Opponent Composition Statistics (minimum 3 games played)
    Code:
    comp                                     win  loss  total  win_pct
    ===================================================================
    Hunter / Paladin (Heal) / Shaman (DPS)     6     8     14    42.90
    Mage / Priest (Heal) / Rogue              11     3     14    78.60
    Druid (Heal) / Paladin (DPS) / Warrior     6     7     13    46.20
    DeathKnight / Paladin (Heal) / Warrior     8     3     11    72.70
    DeathKnight / Hunter / Paladin (Heal)      5     4      9    55.60
    Priest (DPS) / Rogue / Shaman (Heal)       5     4      9    55.60
    Druid (Heal) / Warlock / Warrior           5     2      7    71.40
    Mage / Priest (Heal) / Shaman (DPS)        4     3      7    57.10
    Paladin (Heal) / Shaman (DPS) / Warrior    6     1      7    85.70
    Rogue / Shaman (Heal) / Warlock            5     0      5   100.00
    Hunter / Paladin (DPS) / Priest (Heal)     2     2      4    50.00
    Hunter / Paladin (Heal) / Priest (DPS)     0     3      3     0.00
    Priest (DPS) / Shaman (Heal) / Warlock     3     0      3   100.00

    Opponent Class Statistics
    Code:
    class           won  lost  total  win_pct  win_dtpm  loss_dtpm
    ===============================================================
    DeathKnight      21    11     32    65.60    21,358     13,230
    Druid (DPS)       1     3      4    25.00     8,119      7,714
    Druid (Heal)     22    18     40    55.00    12,244      3,514
    Hunter           19    19     38    50.00    24,012     10,878
    Mage             23    12     35    65.70     9,263      2,842
    Paladin (DPS)    11    14     25    44.00    15,010     10,862
    Paladin (Heal)   33    23     56    58.90     9,787      3,106
    Priest (DPS)     13    10     23    56.50    29,300     13,631
    Priest (Heal)    26    15     41    63.40    22,315     20,466
    Rogue            27    13     40    67.50    23,549     16,104
    Shaman (DPS)     21    14     35    60.00    20,329     21,429
    Shaman (Heal)    22     9     31    71.00     5,571      2,071
    Warlock          25     8     33    75.80    30,341     44,359
    Warrior          36    20     56    64.30    26,018     21,860

    Opponent Class Statistics by Map
    Code:
    map                 class           wins  losses  total  win_pct  win_dtpm  loss_dtpm
    ======================================================================================
    Blade's Edge Arena  DeathKnight        4       3      7    57.10    22,598     27,320
    Blade's Edge Arena  Druid (Heal)       4       3      7    57.10    16,665      8,494
    Blade's Edge Arena  Hunter             4       3      7    57.10    26,532     13,851
    Blade's Edge Arena  Mage               3       1      4    75.00    15,073      7,272
    Blade's Edge Arena  Paladin (DPS)      3       5      8    37.50    15,129      8,788
    Blade's Edge Arena  Paladin (Heal)     8       5     13    61.50    10,207      6,587
    Blade's Edge Arena  Priest (DPS)       6       1      7    85.70    37,783      6,230
    Blade's Edge Arena  Priest (Heal)      2       4      6    33.30    46,083     24,367
    Blade's Edge Arena  Rogue              3       2      5    60.00    24,884     31,977
    Blade's Edge Arena  Shaman (DPS)       3       2      5    60.00    26,184     38,594
    Blade's Edge Arena  Shaman (Heal)      5       2      7    71.40     6,548      2,253
    Blade's Edge Arena  Warlock            4       0      4   100.00    47,436         -1
    Blade's Edge Arena  Warrior            5       8     13    38.50    41,228     34,491
    --------------------------------------------------------------------------------------
    Dalaran Sewers      DeathKnight        6       2      8    75.00    38,432     18,038
    Dalaran Sewers      Druid (DPS)        0       1      1     0.00        -1     14,877
    Dalaran Sewers      Druid (Heal)       4       6     10    40.00    21,108      7,781
    Dalaran Sewers      Hunter             5       5     10    50.00    29,403     21,759
    Dalaran Sewers      Mage               8       1      9    88.90    10,950      4,243
    Dalaran Sewers      Paladin (DPS)      2       4      6    33.30    11,718     10,830
    Dalaran Sewers      Paladin (Heal)     7       6     13    53.80    11,973      4,489
    Dalaran Sewers      Priest (DPS)       3       3      6    50.00    45,412     24,468
    Dalaran Sewers      Priest (Heal)     11       2     13    84.60    28,442     27,603
    Dalaran Sewers      Rogue              9       3     12    75.00    32,404     30,385
    Dalaran Sewers      Shaman (DPS)       4       4      8    50.00    19,086     33,492
    Dalaran Sewers      Shaman (Heal)      8       2     10    80.00     7,930      2,162
    Dalaran Sewers      Warlock            9       4     13    69.20    38,957     46,520
    Dalaran Sewers      Warrior            8       5     13    61.50    34,985     31,802
    --------------------------------------------------------------------------------------
    Nagrand Arena       DeathKnight        6       1      7    85.70    34,281      4,544
    Nagrand Arena       Druid (DPS)        0       1      1     0.00        -1      3,343
    Nagrand Arena       Druid (Heal)       5       2      7    71.40    16,532      9,747
    Nagrand Arena       Hunter             6       1      7    85.70    36,198     12,425
    Nagrand Arena       Mage               4       3      7    57.10     9,433      3,250
    Nagrand Arena       Paladin (DPS)      1       1      2    50.00    18,166     11,479
    Nagrand Arena       Paladin (Heal)     9       2     11    81.80    13,874        737
    Nagrand Arena       Priest (DPS)       2       1      3    66.70    20,860     33,620
    Nagrand Arena       Priest (Heal)      3       3      6    50.00    21,393     12,642
    Nagrand Arena       Rogue              8       2     10    80.00    34,187     18,972
    Nagrand Arena       Shaman (DPS)       6       1      7    85.70    25,304      6,884
    Nagrand Arena       Shaman (Heal)      6       0      6   100.00     6,105         -1
    Nagrand Arena       Warlock            5       1      6    83.30    38,907     43,250
    Nagrand Arena       Warrior           11       2     13    84.60    31,794     63,398
    --------------------------------------------------------------------------------------
    Ruins of Lordaeron  DeathKnight        2       1      3    66.70    11,426     39,097
    Ruins of Lordaeron  Druid (DPS)        1       0      1   100.00    11,271         -1
    Ruins of Lordaeron  Druid (Heal)       3       2      5    60.00    12,591      1,822
    Ruins of Lordaeron  Hunter             0       4      4     0.00        -1     16,823
    Ruins of Lordaeron  Mage               5       2      7    71.40     7,792        487
    Ruins of Lordaeron  Paladin (DPS)      3       0      3   100.00    32,703         -1
    Ruins of Lordaeron  Paladin (Heal)     3       4      7    42.90    11,896      4,691
    Ruins of Lordaeron  Priest (DPS)       2       2      4    50.00    37,809     17,947
    Ruins of Lordaeron  Priest (Heal)      7       3     10    70.00    23,590     39,988
    Ruins of Lordaeron  Rogue              5       1      6    83.30    26,463     10,182
    Ruins of Lordaeron  Shaman (DPS)       4       3      7    57.10    22,931     29,396
    Ruins of Lordaeron  Shaman (Heal)      1       0      1   100.00     3,976         -1
    Ruins of Lordaeron  Warlock            1       1      2    50.00    45,350     59,279
    Ruins of Lordaeron  Warrior            5       1      6    83.30    39,402      5,096
    --------------------------------------------------------------------------------------
    The Ring of Valor   DeathKnight        3       4      7    42.90    22,908     15,693
    The Ring of Valor   Druid (DPS)        0       1      1     0.00        -1     10,357
    The Ring of Valor   Druid (Heal)       6       5     11    54.50    14,583      2,042
    The Ring of Valor   Hunter             4       6     10    40.00    36,795     13,822
    The Ring of Valor   Mage               3       5      8    37.50    17,043      4,695
    The Ring of Valor   Paladin (DPS)      2       4      6    33.30    13,188     27,666
    The Ring of Valor   Paladin (Heal)     6       6     12    50.00    15,426      2,869
    The Ring of Valor   Priest (DPS)       0       3      3     0.00        -1     21,164
    The Ring of Valor   Priest (Heal)      3       3      6    50.00    20,322      8,865
    The Ring of Valor   Rogue              2       5      7    28.60    29,408     18,675
    The Ring of Valor   Shaman (DPS)       4       4      8    50.00    32,872     23,816
    The Ring of Valor   Shaman (Heal)      2       5      7    28.60     8,343      4,593
    The Ring of Valor   Warlock            6       2      8    75.00    30,862     62,112
    The Ring of Valor   Warrior            7       4     11    63.60    32,589     25,766

    My quick analysis of this team would be that they use LoS well...as seen by having their best maps be Nagrand and Dalaran and their map being RoV. =)

    They seem to be solid against a lot the major comps...RLS (5-0), RMP (11-3), TSG (8-3)...but they are even or struggle some against hunter teams...PHD (5-4), Beastcleave (6-8), Ret/MM (2-2)... They maybe struggle a bit against some shadowpriest comps.... Spriest/Rogue/Rsham is 5-4 and Spriest/Hunter/Hpala is 0-3.

    All in all, the worst specs for them to face seem to be DPS paladins, hunters, and tree druids.

    Looking at opponents by map, there are a few cases (Warriors on Nagrand, Warlocks on RoV) where that class takes much more damage in a loss than a win...so they're doing MORE damage when they lose than when they win in these instances. Only they know their approach against those classes on those maps, but it's possible they're tunneling a bit too hard and need to make some more switches. It's hard to say from this data without more insight from the team's members.

  7. #7

    Join Date
    Apr 2010
    Location
    Chicago, IL
    Posts
    1,379
    Rep Power
    13
    Vyrolan will become famous soon enough

    Re: Team Stats (yay data mining ze armory)

    I got another PM...2v2 stats this time... As before...a few abbreviations to note are that "ddpdt" is the "damage done per damage taken" metric. The "dtpm" in the opponent class analysis is "damage taken per minute"...this show how much damage you're putting into those classes.


    This one is Hunter / Healer (Priest)...


    Map Statistics
    Code:
    map                 won  loss  total  win_pct  avg_length  avg_length_win  avg_length_loss
    ===========================================================================================
    All Maps            118    89    207    57.00         182             164              206
    Blade's Edge Arena   24    17     41    58.50         178             163              199
    Dalaran Sewers       31    18     49    63.30         194             176              226
    Nagrand Arena        19    21     40    47.50         208             161              249
    Ruins of Lordaeron   27    20     47    57.40         173             171              175
    The Ring of Valor    17    13     30    56.70         150             136              168

    Player Statistics
    Code:
    player_name  win_avg_dmg  win_ddpdt  win_died  loss_avg_dmg  loss_ddpdt  loss_dmg_pct
    ======================================================================================
    Priest            10,144       0.65         1         4,541        0.20         44.80
    Hunter            43,118       2.12         1        39,938        1.29         92.60

    Player Statistics by Map
    Code:
    player_name  map                 win_dmg  win_ddpdt  loss_dmg  loss_ddpdt  loss_dmg_pct
    ========================================================================================
    Priest       Blade's Edge Arena    7,875       0.43     3,252        0.14         41.30
    Priest       Dalaran Sewers        8,070       0.45     4,446        0.18         55.10
    Priest       Nagrand Arena        11,704       0.88     3,644        0.17         31.10
    Priest       Ruins of Lordaeron   14,290       1.10     6,180        0.23         43.20
    Priest       The Ring of Valor     9,075       0.70     6,846        0.44         75.40
    ----------------------------------------------------------------------------------------
    Hunter       Blade's Edge Arena   45,203       2.21    35,306        1.35         78.10
    Hunter       Dalaran Sewers       49,788       2.31    37,608        1.10         75.50
    Hunter       Nagrand Arena        45,715       2.09    39,239        1.29         85.80
    Hunter       Ruins of Lordaeron   30,862       1.82    45,422        1.29        147.20
    Hunter       The Ring of Valor    44,905       2.04    44,386        1.69         98.80

    Opponent Composition Statistics
    Code:
    heal  dps  won  lost  total  win_pct  avg_length  avg_length_win  avg_length_loss
    ==================================================================================
       0    2   33    23     56    58.90          97             108               82
       1    1   75    62    137    54.70         225             198              258

    Opponent Composition Statistics (minimum 3 games played)
    Code:
    comp                          win  loss  total  win_pct
    ========================================================
    Priest (Heal) / Rogue          12    11     23    52.20
    Paladin (Heal) / Warrior        7    10     17    41.20
    Priest (DPS) / Rogue            7     7     14    50.00
    Druid (Heal) / Warrior          8     1      9    88.90
    Shaman (Heal) / Warlock         1     8      9    11.10
    DeathKnight / Druid (Heal)      5     3      8    62.50
    Druid (Heal) / Warlock          7     1      8    87.50
    Mage / Rogue                    6     1      7    85.70
    Priest (Heal) / Warlock         3     4      7    42.90
    DeathKnight / Paladin (Heal)    5     1      6    83.30
    Druid (DPS) / Priest (Heal)     3     3      6    50.00
    Mage / Priest (Heal)            3     2      5    60.00
    Priest (Heal) / Warrior         4     1      5    80.00
    Paladin (Heal) / Warlock        1     4      5    20.00
    Mage / Warlock                  1     3      4    25.00
    Priest (Heal) / Shaman (DPS)    3     1      4    75.00
    Druid (DPS) / Rogue             2     2      4    50.00
    Hunter / Priest (Heal)          2     2      4    50.00
    Hunter / Shaman (Heal)          2     2      4    50.00
    Mage / Priest (DPS)             3     1      4    75.00
    Druid (DPS) / Shaman (Heal)     1     2      3    33.30
    Rogue / Shaman (DPS)            1     2      3    33.30

    Opponent Class Statistics
    Code:
    class           won  lost  total  win_pct  win_dtpm  loss_dtpm
    ===============================================================
    DeathKnight      15     5     20    75.00    20,538     28,217
    Druid (DPS)       8     8     16    50.00    27,057     23,951
    Druid (Heal)     23     7     30    76.70    13,680     10,902
    Hunter            7     6     13    53.80    24,158     30,394
    Mage             16     8     24    66.70    12,678     12,362
    Paladin (DPS)     8     2     10    80.00    16,425     16,337
    Paladin (Heal)   13    16     29    44.80     8,890      4,943
    Priest (DPS)     13    12     25    52.00    10,907      6,246
    Priest (Heal)    32    24     56    57.10    11,910      9,478
    Rogue            30    25     55    54.50    17,813     21,295
    Shaman (DPS)      8     7     15    53.30    10,891     10,645
    Shaman (Heal)     7    15     22    31.80    11,615     14,035
    Warlock          15    22     37    40.50    26,831     13,898
    Warrior          20    12     32    62.50    33,899     27,744

    Opponent Class Statistics by Map
    Code:
    map                 class           wins  losses  total  win_pct  win_dtpm  loss_dtpm
    ======================================================================================
    Blade's Edge Arena  DeathKnight        3       1      4    75.00    30,582     29,033
    Blade's Edge Arena  Druid (DPS)        0       4      4     0.00        -1     24,012
    Blade's Edge Arena  Druid (Heal)       6       0      6   100.00    17,340         -1
    Blade's Edge Arena  Hunter             1       2      3    33.30    25,182     34,755
    Blade's Edge Arena  Mage               5       2      7    71.40    13,969      8,431
    Blade's Edge Arena  Paladin (DPS)      2       0      2   100.00    17,519         -1
    Blade's Edge Arena  Paladin (Heal)     3       1      4    75.00    14,852      5,363
    Blade's Edge Arena  Priest (DPS)       2       2      4    50.00     7,931     10,960
    Blade's Edge Arena  Priest (Heal)      4       6     10    40.00    21,824     17,527
    Blade's Edge Arena  Rogue              6       7     13    46.20    19,382     18,517
    Blade's Edge Arena  Shaman (DPS)       3       1      4    75.00    33,733      4,397
    Blade's Edge Arena  Shaman (Heal)      0       3      3     0.00        -1     16,469
    Blade's Edge Arena  Warlock            4       3      7    57.10    40,653     11,864
    Blade's Edge Arena  Warrior            3       1      4    75.00    59,325     28,859
    --------------------------------------------------------------------------------------
    Dalaran Sewers      DeathKnight        4       2      6    66.70    50,190     25,100
    Dalaran Sewers      Druid (DPS)        2       1      3    66.70    36,289     35,793
    Dalaran Sewers      Druid (Heal)       9       1     10    90.00    19,029     18,242
    Dalaran Sewers      Hunter             2       1      3    66.70    38,760     53,566
    Dalaran Sewers      Mage               3       2      5    60.00    15,830     17,022
    Dalaran Sewers      Paladin (DPS)      2       0      2   100.00    28,273         -1
    Dalaran Sewers      Paladin (Heal)     3       5      8    37.50    13,236      6,701
    Dalaran Sewers      Priest (DPS)       3       2      5    60.00    18,641      3,353
    Dalaran Sewers      Priest (Heal)      8       4     12    66.70    13,412      3,828
    Dalaran Sewers      Rogue              7       4     11    63.60    37,842     26,965
    Dalaran Sewers      Shaman (DPS)       2       3      5    40.00    15,141      8,692
    Dalaran Sewers      Shaman (Heal)      2       1      3    66.70     9,601      2,602
    Dalaran Sewers      Warlock            4       5      9    44.40    28,376     26,365
    Dalaran Sewers      Warrior            9       3     12    75.00    38,573     31,173
    --------------------------------------------------------------------------------------
    Nagrand Arena       DeathKnight        0       1      1     0.00        -1     43,810
    Nagrand Arena       Druid (DPS)        3       2      5    60.00    63,334     34,838
    Nagrand Arena       Druid (Heal)       5       2      7    71.40    14,084      5,552
    Nagrand Arena       Hunter             1       1      2    50.00    39,854     36,848
    Nagrand Arena       Mage               1       1      2    50.00    16,300     19,459
    Nagrand Arena       Paladin (DPS)      1       1      2    50.00    17,603     25,071
    Nagrand Arena       Paladin (Heal)     1       3      4    25.00     4,182      5,796
    Nagrand Arena       Priest (DPS)       3       4      7    42.90    18,474     12,075
    Nagrand Arena       Priest (Heal)      5       5     10    50.00    11,686     13,095
    Nagrand Arena       Rogue              4       5      9    44.40    29,333     31,106
    Nagrand Arena       Shaman (DPS)       0       2      2     0.00        -1     35,991
    Nagrand Arena       Shaman (Heal)      2       4      6    33.30    27,611     16,266
    Nagrand Arena       Warlock            3       5      8    37.50    39,985     14,120
    Nagrand Arena       Warrior            3       2      5    60.00    22,497     27,320
    --------------------------------------------------------------------------------------
    Ruins of Lordaeron  DeathKnight        4       1      5    80.00    14,562     57,394
    Ruins of Lordaeron  Druid (DPS)        2       1      3    66.70    21,100     33,421
    Ruins of Lordaeron  Druid (Heal)       3       3      6    50.00    15,875     10,843
    Ruins of Lordaeron  Hunter             3       2      5    60.00    27,203     68,733
    Ruins of Lordaeron  Mage               4       1      5    80.00    28,096      6,936
    Ruins of Lordaeron  Paladin (DPS)      3       1      4    75.00    42,490     27,780
    Ruins of Lordaeron  Paladin (Heal)     4       6     10    40.00    11,432      4,521
    Ruins of Lordaeron  Priest (DPS)       2       2      4    50.00    21,540      4,452
    Ruins of Lordaeron  Priest (Heal)      7       4     11    63.60    18,682     14,783
    Ruins of Lordaeron  Rogue              8       4     12    66.70    25,494     29,461
    Ruins of Lordaeron  Shaman (DPS)       2       0      2   100.00     6,151         -1
    Ruins of Lordaeron  Shaman (Heal)      2       3      5    40.00    13,914     21,107
    Ruins of Lordaeron  Warlock            1       6      7    14.30    57,966     16,750
    Ruins of Lordaeron  Warrior            4       4      8    50.00    63,255     55,352
    --------------------------------------------------------------------------------------
    The Ring of Valor   DeathKnight        4       0      4   100.00    43,369         -1
    The Ring of Valor   Druid (DPS)        1       0      1   100.00    31,224         -1
    The Ring of Valor   Druid (Heal)       0       1      1     0.00        -1     32,562
    The Ring of Valor   Mage               3       2      5    60.00    18,233     21,988
    The Ring of Valor   Paladin (Heal)     2       1      3    66.70     2,444      1,694
    The Ring of Valor   Priest (DPS)       3       2      5    60.00    21,790     12,974
    The Ring of Valor   Priest (Heal)      8       5     13    61.50    15,022      6,490
    The Ring of Valor   Rogue              5       5     10    50.00    26,901     43,076
    The Ring of Valor   Shaman (DPS)       1       1      2    50.00    25,548      2,594
    The Ring of Valor   Shaman (Heal)      1       4      5    20.00    13,237     19,989
    The Ring of Valor   Warlock            3       3      6    50.00    42,366     25,491
    The Ring of Valor   Warrior            1       2      3    33.30    85,239     20,597

    Highest number of games played on Dalaran and Ruins...lowest number of games played on RoV...how do you get that luck?

    Hunter seems to have solid damage...maintaining a respectable 90+% of damage in losses...so I would guess they don't lose much because he gets locked down hard. He has respectable damage done per damage taken as well... Interesting data point on ruins...average damage is higher in a loss than a win. Damage falls the most on Dalaran...which is also their best map by win percentage.

    Looking at high level compositions...against healer teams they're 75 and 62...but the average win is 198 seconds and the average loss is 258 seconds... Aside from heavy pressure forcing the hunter through all his major cooldowns (mainly deterrence), it seems like they should have decent longevity...why can't they win longer games? Does the priest oom or die?

    For opponent comps, look at the warrior teams...7 and 10 with pally healer...8 and 1 with druid healer...1 and 8 with shaman healer...4 and 1 with priest healer... Pally is going to be tough with magic dispel and freedom to keep the warrior on target. I would guess tremor and purge are giving the shaman teams the advantage...purged shields and negated fears are huge. Also of interest is the shaman is the one healer where the priest's offensive dispel is not as powerful. Dispelling hots against the druid may help them a ton...dispelling sacred shield and blessings and hands may be helping them a ton against pallies...similarly against priest healer. Without absorbs and earth shield a waste to dispel, maybe the priest should be offensive via dots and damage rather than dispels.

    They're destroying Mage/Rogue but splitting Spriest/Rogue...damn Psychic Horror...

    All in all, they're killing DKs, tree druids (go go dispel), dps paladins (lolz dps pallies in 2s...esp against hunter/priest), and mages (um, hunter?). They're weaker against shaman healers (tremor and offensive dispel not as effective) and warlocks. Looking at resto shamans, they take more damage when you lose to them than when you beat them...so they're probably good at LoSing the hunter's damage and living...maybe going on them isn't such a great idea...they've never beaten a resto shaman on Blade's Edge where he can bail off the bridge...but their second worst map is RoV where the shaman should have no escape. Looking at the warlocks overall and map by map, we see that pressuring the locks seems to work well as they take almost twice as much damage in your wins compared to losses. The ability to pressure the warlock is highlighted on Blade's Edge...and you can see it starkly as you do almost quadruple the damage to them in wins. When you fail the pressure the warlock, you lose. See a similar difference on Ruins...they take almost 58K damage per minute when you win...but only 16.75K per minute when you lose.

  8. #8

    Join Date
    Apr 2010
    Posts
    48
    Rep Power
    0
    Sirp

    Re: Team Stats (yay data mining ze armory)

    ^ That's the data for my 2v2.

    Thanks a lot for the analysis, very insightful, confirms some info on which comps we need to work on and sheds some light stuff I hadn't even thought about... I'm surprised we have such a high % win ration on Dalaran, but so low on Nagrand for instance.

    Good stuff dude.

  9. #9

    Join Date
    Apr 2010
    Location
    Chicago, IL
    Posts
    1,379
    Rep Power
    13
    Vyrolan will become famous soon enough

    Re: Team Stats (yay data mining ze armory)

    Quote Originally Posted by Sirp
    I'm surprised we have such a high % win ration on Dalaran, but so low on Nagrand for instance.
    Dalaran is a smaller map than Nagrand...your priest may have better positioning on it compared to Nagrand...you're closer to LoS from a random spot on Dalaran than you are from a random spot on Nagrand. Fear paths can also be a bit more devestating on Dalaran. It's also harder for you to overextend and pull him into a bad position on Dalaran compared to Nagrand.

  10. #10

    Join Date
    May 2010
    Posts
    30
    Rep Power
    0
    Gurgeeh

    Re: Team Stats (yay data mining ze armory)

    Really interesting work and may provide pointers for teams looking to squeeze every last ounce out of their performances. I would just add from a statistician's point of view - your sample sets/population of the raw data are far too limited to draw any sensible conclusions. You'd ideally need around a minimum of 30 games on each map, and even then I'd be concerned that the conclusions were skewed since many games could be done on the same night, against the same team where they were consistently better than you, or you were tired, or ...
    Just be careful into how you interperet your data with limited samples is all - I am sure you were aware of this beforehand in any case.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts