CoC: More fun with numbers! Also spots open in our clan

(Writeup and stats by Delpez. Also our clan, “Supreme Cream!” has a few open spots due to recent roster cleanup. Please mention the blog when applying).

Supreme Cream Performance

During a previous CoC blog post, a comment was made that we should start tracking individual war performance. That sounded like great fun to me – another opportunity to gather and play with large amounts of data! I also didn’t have to reinvent the wheel, because a while ago we played against JTJU, and they already tracked lots of metrics which I took as a starting point. I only used their output sheet to get the metrics – the raw data capturing is manual (takes about 30 minutes per war) and the rest is calculated by a new Excel macro. So a big hats off to JTJU for saving me the trouble of finding metrics by myself. They also have a really cool website and YouTube channel where all kinds of strategies are discussed. We might consider joining their affiliate program – you get a clan advertisement on their site, and also access to various war tools. The most useful seems to be the ‘one tree’ – a decision tree to help decide what attack to use and a checklist on how to execute the attack. If nothing else it’s a decent place to recruit (via the clan add), since players from a site like that usually have an interest in wars and improving their game.

But on to the performance tracker. Here’s a link to a picture of the final output file:

If you want to have a look at the Excel files behind these numbers, just drop your email in the comments or chat and I’ll send it along. The VBA macro and formats don’t seem to play well with Google Drive. I would appreciate any comments, spot checks or troubleshooting; it’s a ton of data, and although I’ve checked as much as I can, it’s quite possible that errors have crept in. So view this as an early beta version.

So what’s the use of this? I don’t think it should become a measuring stick to punish people – as far as I’m concerned, players only need to execute proper attacks (no barcher!) and try to improve. However, this should give you something to measure your performance against. Obviously you can’t compare an early TH8 with a late TH9, so I think it’s best if you compare with your peers. Look at the performance of players with similar experience and TH levels, and see how you match up – or pat yourself on the back if you are already the best! Currently the numbers are organized by TH level, but I may split it into experience level at a later stage. Also, JTJU have seasons and careers stats – I’m thinking of letting a season last for 10 wars, after which the seasonal tracker resets. On to an explanation of the metrics:

Wars: The number of wars a player participated in.

Attacked: Was the player attacked or not in a war? This is a yes or no trigger (1 or 0).

Bleeds: How many times a player was attacked over and above the first. So if you are attacked three times in a war, you score two bleeds. This is an indication of how many attacks are wasted on your base. There are big differences between high and low level bases here, because typically a clan will keep attacking TH8’s until they get 3-stars (or run out of attacks), but usually won’t bleed much against a high level base with some stars against it.

Holds: How many stars did the player manage to hold onto – if your base is 2-starred at the end of a war you score one hold. If you were not attacked you don’t get any holds, but you’re also not penalized in the normalized numbers. Holds are the opposite of bleeds, in that high level bases usually score high holds and low bleeds, whereas low level bases score low holds and high bleeds.

Overall Closer: The first player to score the highest number of stars against a base will get the closer stars for that base. For example, if player A scores a 2-star and later in the war player B scores a 3-star, B will get three closer stars and A none. However, if B also scored a 2-star, A will get two closer stars (he was first) and B none. Overall Closer just means that all attacks are considered, whether the player attacked up, down or sideways.

Overall All Stars: This just adds all the stars a player scored – doesn’t matter if it’s closer, up, down or sideways.

Overall 3 Stars: The total number of 3-stars achieved, irrespective of up, down or sideways.

>= Same Level Closer, All Stars and 3-stars: This tracks exactly the same metrics as before, but you don’t get credit for attacking down.

MIA: Missing in action – the number of attacks a player has missed in wars he participated in. Sometimes a player will miss attacks when opted in by Syncaine to make up numbers. I don’t have a way to track it here, but it is recorded in a separate activity sheet.

In the second half of the spreadsheet these numbers are normalized by using the attacked trigger (for defensive stats) and war participation (for offensive stats). These normalized numbers should be analyzed for any performance based comparison or discussions.

In the context of wars, Overall Closer is an indication of how much a player contributed to the overall war result, while Overall All Stars show how well a player attacks in general, irrespective of the effect it had on wars. If Overall and Same Level attacks look similar, it means the player attacks mostly sideways and up, whereas a significant difference means the player is attacking down a lot. As mentioned before, you should compare yourself with your peers and keep in mind the type of attacks you’re doing. We need players to take out same level bases, but we also need players who hit down and clean up. Issues with players hitting too low should be picked up during wars and addressed in chat – these numbers don’t give enough context to make assumptions regarding the suitability of an attack.

Finally, I really don’t want to mention names (for fear of leaving someone out!), but I do like to point out some numbers as an example of what to look out for. I’ve been tracking performance for the past four wars (last one was Kosarmaniacs), and three of those were non-events. Thus, the values are skewed by players hitting for loot or practicing new attacks. Having said that, Mikrakov’s attack numbers at TH9 is really impressive, and they were all done against same or higher level bases. At TH8 Zelazny is averaging 5.5 closer stars per war, and all against same level bases. Alistair is average 6 closer stars per war – a perfect record! The difference between his Overall and Same Level stats means that some of those attacks were clean-up against TH7’s, but as a low TH8 that’s part of the job. On defense people seem to like Caldazar’s base, even though they struggle to crack it – he has recorded 12 bleeds! Not many bleeds at TH9, but Adam and Saate have both managed to hold onto 8 stars in four wars.

Lots of other interesting stuff, but I’ll let this run for a couple more wars before commenting further. Any thoughts or suggestions?

About SynCaine

Former hardcore raider turned casual gamer.
This entry was posted in Clash of Clans. Bookmark the permalink.

11 Responses to CoC: More fun with numbers! Also spots open in our clan

  1. Delpez says:

    Correction – the link is up to date until after the last war (against excelentes)

  2. Jonneh says:

    I love this

  3. Mikrakov says:

    Love these stats! Of course, sometimes they can be slightly misleading, for example Exile, being the top 9, will always be matched against a tough base, sometimes even a 10, whereas I get to hit one 10 further down the map despite having almost the same offensive capabilities. Having said that, if over the long term you can see your base is always 3 starred on the first attempt, or you consistently get only 1-2 stars per war it might be time to reconsider things, so overall I think that this is really great. if you are having trouble keeping it up to date I’m sure some of us would be willing to help.

  4. Alistair says:

    Big fan of the stats also… I know my position in the clan is conducive to racking up 6 stars per war but it is definitely better for me to clean up the low level THs than our higher level folks.

    So is there any interest in strategy posts? Not to say I am an expert but I would be glad to write up a dragon attack post. I think I have a great feel for them now and have a few comments on spells and using balloons and the BK to max advantage.

    Not pointing fingers but I shake my head every time when I see someone use two lightning spells on and AD and don’t kill it…total waste. Either kill the AD with three lightning or use all three rages (not advised but smarter than 2 lightning and a rage).

    Again, thanks for the effort on the stats… definitely adds to my enjoyment.

    • SynCaine says:

      Search using the “Clash of Clans” tag for posts here first Ali, there have been a few strat posts already, including one for drags I believe. But if you search and still feel something good can be written, feel free and email it over to me.

    • Saate says:

      I think a refresher on dragon attacks would be great for some of our TH8 (even just a list of links and good youtube clips). You’ve been doing great :)

      Mik and I have discussed those fail-strategy attacks in the past and always agreed that the main issue is not so much that they don’t know how. It’s more that they don’t know how, don’t seem to participate in guild chat (including asking for advice) and repeat the same ‘drop all 10 dragons in one spot and pray’ types of attacks you referred to.

      It’s also worth having some discussion about how dragon attacks change from early TH8 to late TH8 and when we’re up against hard clans when to realise you’re up against an anti-dragon base that might prevent a 3-star.

      With the more developed bases time can become a big issue too so getting out of the habit of measuring your lightnings (eg drop one, wait and see what it does, drop another, wait, drop the last) needs to turn into dropping all 3 at once and usually after your funnel dragons are already doing damage. The same goes for getting all your dragons out on the field sooner rather than later.

  5. Delpez says:

    Some general comments and replies:

    Derp clans are really screwing with the numbers, but for now I’ll include them to troubleshoot the macro. However, as soon as we have more decent wars behind us I’m going to exclude these one-sided affairs. Maybe only include a war if the opposition use at least 70% of their attacks (or something similar)? So for now view this as the Beta performance – it will probably change in future.

    It’s not possible to compare the performance of bases at different strengths with this system. I can’t see an easy way to bring opponent base strength into this – even experience level is misleading with 8.5 and rushed bases. So for now the only solution is to compare yourself with your peers and try to improve your own ratings, irrespective of where you are ranked.

    I really like the JTJU attack strategies, and they have lots on TH8 dragons. Some of it’s a bit outdated with air sweepers, but the principles are still sound. They cover about 8 (!) different types of dragon attacks with attack selection, general strategy, approach angles etc. Here’s the link to their website, but there are more on their YouTube channel.

    Another great source is OneHive raids:

  6. Ellroy says:

    Thanks again, Delpez. This should really help our clan to get to the next level (in terms of quality play and being able to identify weaknesses).

    I have recently created a little performance tool in excel as well but am thinking about deleting it now that you have published your way more sophisticated version ;-)

    • Delpez says:

      Any other metrics you think we should be tracking?

      • Anonymous says:

        No idea so far, you got everything i had too plus some additional stuff. Let’s see what extra information we may need when we got some more experience with the data…

        • Ellroy says:

          (Sorry for appearing anonymously, logged in from another device and did not have my name set as default…)

Comments are closed.