Announcement

Collapse
No announcement yet.

A Basic Analysis Of European PUG Statistics In 2015 (#UT4.eu)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    A Basic Analysis Of European PUG Statistics In 2015 (#UT4.eu)

    One month ago I wrote a A Basic Analysis Of North American PUG Statistics In 2015 (#ut4pugs). Interestingly enough, most North American gamers that I spoke with seemed equally interested in what kind of PUG action European gamers were getting. So I've written this up in hopes of shedding some light on this topic.

    Note: It has come to my attention that PUGs for the European Community are often organized outside of the channel on the HUBs themselves. Usually public matches or chance gatherings that evolve into actual PUGs. Unfortunately, such matches cannot be reliably tracked and the scope of this project only recognizes matches organized in the official IRC channels. This data was generated directly from the PUGbot logs for the #UT4.pug and #UT4.eu IRC channels. It is painstakingly accurate and 100% complete.

    How Was The Number Of Unique PUGs Determined?
    When each PUG starts, the PUGbots say something unique in chat that I can use to identify the start of each match; pug has been filled. If I count these unique lines I will have a grand total. Unfortunately, some PUGs will stop before teams can be picked because one player leaves. When this happens LBot says something else unique; pug stopped because. Those occurrences are tallied and subtracted from the previous grand total. Furthermore, this list is manually scanned to remove any instances of people quoting LBot saying, pug has been filled. What we have left is the exact amount of legitimate PUGs. The data is then formatted to be exported into Microsoft Excel.

    So What Did You Discover?
    The very first PUG was held on May 18th, 2015. I followed the PUG activity all the way up to December 31st 2015. So this analysis covers 7.5 months of PUGing. What I have below is what I thought folks would find useful. If you can think of another statistic that this data might reveal, please let me know and I'd be happy to figure the percentages.
    1. What are the best days of the week to try and PUG?
      • Saturday and Sunday
         
    2. During what hours do the majority of PUGs happen?
      • 8:00AM to 12:00PM CET (GMT +1) / 1:00AM to 5:00AM EST (GMT -5)
        60.19% of all PUGs in 2015 occurred during this time frame.
         
    3. How many PUGs were held in 2015?
      • 1188
         
    4. What is the most popular game type?
      • Instagib Capture The Flag
         
    5. Over the last 7.5 months, what was the most active period of time?
      • 10/25/15 - 11/28/15; 49.33% of all PUGs occurred during these 5 weeks, out of 15 weeks total.
         
    6. How much time does this data cover exactly?
      • Percentage of 2015: 62.23%
      • Start Of Data: May 18, 2015 @ 02:15:07 PM CET (GMT +1)
      • End Of Data: December 31, 2015 @ 11:59:59 PM CET (GMT +1)
      • Total Time: 227 days, 3 hours, 44 minutes and 52 seconds
      • Total Weeks: 32 (first & last week of data are partial weeks)
      • Total Days: 227 (rounded down)
      • Total Hours: 5,451 (rounded down)
      • Total Minutes: 327,104 (rounded down)
      • Total Seconds: 19,626,292


    Can I See The Rest Of Your Data?
    All of the data collected is available in an Excel spreadsheet. What follows are the grand totals for the entire time period of activity, broken down into different categories. Enjoy!

    Game Type PUGs Percentage
    Assault 3 0.25%
    CTF 1 0.08%
    NW CTF 3 0.25%
    iCTF 747 62.88%
    2iCTF 79 6.65%
    iCTF 5x5 1 0.08%
    DM 2v2 1 0.08%
    2DM 1 0.08%
    2iDM 3 0.25%
    iDM 2v2 8 0.67%
    Duel 46 3.87%
    NW Duel 5 0.42%
    iDuel 50 4.21%
    LTS 14 1.18%
    SD 6 0.51%
    TAM 2 0.17%
    2TAM 1 0.08%
    TDM 162 13.64%
    2TDM 22 1.85%
    iTDM 24 2.02%
    iTDM 3x3 2 0.17%
    iTDM 4x4 7 0.59%
    Weekday PUGs Percentage
    Sunday 242 20.37%
    Monday 157 13.22%
    Tuesday 167 14.06%
    Wednesday 154 12.96%
    Thursday 139 11.70%
    Friday 131 11.03%
    Saturday 198 16.67%
    Total PUGs 1188
    Hour (CET/GMT+1) PUGs Percentage Hour (EST/GMT-5) PUGs Percentage
    12:00 AM 71 05.98% 12:00 AM 79 06.65%
    01:00 AM 27 02.27% 01:00 AM 113 09.51%
    02:00 AM 7 00.59% 02:00 AM 159 13.38%
    03:00 AM 4 00.34% 03:00 AM 169 14.23%
    04:00 AM 1 00.08% 04:00 AM 157 13.22%
    05:00 AM 0 00.00% 05:00 AM 117 09.85%
    06:00 AM 0 00.00% 06:00 AM 71 05.98%
    07:00 AM 0 00.00% 07:00 AM 27 02.27%
    08:00 AM 0 00.00% 08:00 AM 7 00.59%
    09:00 AM 5 00.42% 09:00 AM 4 00.34%
    10:00 AM 5 00.42% 10:00 AM 1 00.08%
    11:00 AM 19 01.60% 11:00 AM 0 00.00%
    12:00 PM 17 01.43% 12:00 PM 0 00.00%
    01:00 PM 28 02.36% 01:00 PM 0 00.00%
    02:00 PM 36 03.03% 02:00 PM 0 00.00%
    03:00 PM 58 04.88% 03:00 PM 5 00.42%
    04:00 PM 55 04.63% 04:00 PM 5 00.42%
    05:00 PM 61 05.13% 05:00 PM 19 01.60%
    06:00 PM 79 06.65% 06:00 PM 17 01.43%
    07:00 PM 113 09.51% 07:00 PM 28 02.36%
    08:00 PM 159 13.38% 08:00 PM 36 03.03%
    09:00 PM 169 14.23% 09:00 PM 58 04.88%
    10:00 PM 157 13.22% 10:00 PM 55 04.63%
    11:00 PM 117 09.85% 11:00 PM 61 05.13%
    Week # PUGs Percentage Duration
    Week 01 12 1.01% 05/17/15 - 05/23/15
    Week 02 13 1.09% 05/24/15 - 05/30/15
    Week 03 8 0.67% 05/31/15 - 06/06/15
    Week 04 9 0.76% 06/07/15 - 06/13/15
    Week 05 5 0.42% 06/14/15 - 06/20/15
    Week 06 23 1.94% 06/21/15 - 06/27/15
    Week 07 2 0.17% 06/28/15 - 07/04/15
    Week 08 2 0.17% 07/05/15 - 07/11/15
    Week 09 2 0.17% 07/12/15 - 07/18/15
    Week 10 0 0.00% 07/19/15 - 07/25/15
    Week 11 0 0.00% 07/26/15 - 08/01/15
    Week 12 0 0.00% 08/02/15 - 08/08/15
    Week 13 0 0.00% 08/09/15 - 08/15/15
    Week 14 0 0.00% 08/16/15 - 08/22/15
    Week 15 5 0.42% 08/23/15 - 08/29/15
    Week 16 7 0.59% 08/30/15 - 09/05/15
    Week 17 5 0.42% 09/06/15 - 09/12/15
    Week 18 11 0.93% 09/13/15 - 09/19/15
    Week 19 23 1.94% 09/20/15 - 09/26/15
    Week 20 29 2.44% 09/27/15 - 10/03/15
    Week 21 30 2.53% 10/04/15 - 10/10/15
    Week 22 56 4.71% 10/11/15 - 10/17/15
    Week 23 61 5.13% 10/18/15 - 10/24/15
    Week 24 100 8.42% 10/25/15 - 10/31/15
    Week 25 135 11.36% 11/01/15 - 11/07/15
    Week 26 121 10.19% 11/08/15 - 11/14/15
    Week 27 121 10.19% 11/15/15 - 11/21/15
    Week 28 109 9.18% 11/22/15 - 11/28/15
    Week 29 62 5.22% 11/29/15 - 12/05/15
    Week 30 56 4.71% 12/06/15 - 12/12/15
    Week 31 70 5.89% 12/13/15 - 12/19/15
    Week 32 58 4.88% 12/20/15 - 12/26/15
    Week 33 53 4.46% 12/27/15 - 01/02/16
    Last edited by Mulsiphix; 02-09-2016, 12:39 AM. Reason: Complete Revision Of Data. See Post #17 For More Info.
    Mulsiphix's Guide To PUGing In UT4
    What is the difference between a Public server and a PUG? PUG stands for Pick Up Game. A more organized way of playing, teams are selected by Captains and voice communication is used to achieve better team coordination. These clan-style matches involve the same regulars, week after week. The community aspect, of PUGing with friends, really adds to the fun factor of a match. Want to know more or get your friends involved in PUGing? Check out my guide.

    #2
    I'm not surprised at all that nw CTF is close to 0%

    As I said, these stats are not representative at all. Most organized CTF are not using irc.
    Cunni, 37 years old, 16 years of UT, 90% CTF, 10% Duel
    https://www.twitch.tv/cunni_ut
    http://plays.tv/u/Cunni
    Discord PUG Community

    Comment


      #3
      Originally posted by Cunni View Post
      I'm not surprised at all that nw CTF is close to 0%

      As I said, these stats are not representative at all. Most organized CTF are not using irc.
      As I mentioned above, these stats are purely derived from IRC. I'm very curious. What kind of percentage or number of matches do you think we're looking at for NW CTF game play? If you had to guess. Also, compared to the 1219 matches that were recorded here during this three months span, how many PUGs would you guess have taken place that were organized on the HUBs directly? Lastly, what is your estimation based upon? Are you guessing or do you spend a lot of time on the HUBs and see the matches get organized or do you hear a lot of talk of matches being organized there or? I would love to learn more about the matches I am unable to track .
      Last edited by Mulsiphix; 01-15-2016, 07:13 AM. Reason: added a sentence to the end
      Mulsiphix's Guide To PUGing In UT4
      What is the difference between a Public server and a PUG? PUG stands for Pick Up Game. A more organized way of playing, teams are selected by Captains and voice communication is used to achieve better team coordination. These clan-style matches involve the same regulars, week after week. The community aspect, of PUGing with friends, really adds to the fun factor of a match. Want to know more or get your friends involved in PUGing? Check out my guide.

      Comment


        #4
        Most organized CTF are not using irc
        IRC in 2016 ?

        Comment


          #5
          Mulsiphix,

          You did a good job, I just want to raise the limits of these stats and say that the nw CTF community is active in EUR.

          I'm not guessing I'm one the most active CTF players in Europe and part of almost all PUGs.

          Skilled CTF matchs are played every night on official EUR Epic hubs. Most of them are played without TS but roles are defined, items are timed...and when enough skilled players are iin, we join TS. That's it
          Cunni, 37 years old, 16 years of UT, 90% CTF, 10% Duel
          https://www.twitch.tv/cunni_ut
          http://plays.tv/u/Cunni
          Discord PUG Community

          Comment


            #6
            Originally posted by Cunni View Post
            Mulsiphix,

            You did a good job, I just want to raise the limits of these stats and say that the nw CTF community is active in EUR.

            I'm not guessing I'm one the most active CTF players in Europe and part of almost all PUGs.

            Skilled CTF matchs are played every night on official EUR Epic hubs. Most of them are played without TS but roles are defined, items are timed...and when enough skilled players are iin, we join TS. That's it
            I wish we had that kind of HUB activity here in N.A. We're lucky to get in three or four matches in a single night. I'm sorry if my question came across as rude or implied I didn't trust your feedback. It drives me crazy that I can't track all the Euro PUGs properly. I'm glad to hear that NW CTF is getting some love too. We N.A. guys often comment on how it seems you Euro guys only play iCTF and we only play NW CTF.

            If you guys don't already have one you should create a PUG category in game types. Whenever a PUG is organized on the HUB or IRC you should switch over a match in that game type. Then I can read your server logs, subtract the IRC totals, and have a solid idea of what kind of action the HUB is getting . Probably too involved but the stat junkie in me had to throw it out there .
            Mulsiphix's Guide To PUGing In UT4
            What is the difference between a Public server and a PUG? PUG stands for Pick Up Game. A more organized way of playing, teams are selected by Captains and voice communication is used to achieve better team coordination. These clan-style matches involve the same regulars, week after week. The community aspect, of PUGing with friends, really adds to the fun factor of a match. Want to know more or get your friends involved in PUGing? Check out my guide.

            Comment


              #7
              We play on official HUB so I don't see how we could create a PUG category.

              Epic stats would include all CTF games, 7vs7 or almost empty CTF games. Not sure it would be representative...
              Cunni, 37 years old, 16 years of UT, 90% CTF, 10% Duel
              https://www.twitch.tv/cunni_ut
              http://plays.tv/u/Cunni
              Discord PUG Community

              Comment


                #8
                Originally posted by Cunni View Post
                Skilled CTF matchs are played every night on official EUR Epic hubs.
                Originally posted by Cunni View Post
                We play on official HUB so I don't see how we could create a PUG category.
                I'm sorry. I completely missed you were playing on Official Epic hubs. I assumed it was the dedicated #UT4.eu servers. Yeah those logs would be way too much trouble to pick through in order to find just the PUGs.

                 
                Originally posted by cafe
                I think they have full stats, with player names and everything. I don't think it would be very hard to sort through that data to find the competitive games.
                I'm not sure how you could tell the PUGs apart from the normal Public matches
                Mulsiphix's Guide To PUGing In UT4
                What is the difference between a Public server and a PUG? PUG stands for Pick Up Game. A more organized way of playing, teams are selected by Captains and voice communication is used to achieve better team coordination. These clan-style matches involve the same regulars, week after week. The community aspect, of PUGing with friends, really adds to the fun factor of a match. Want to know more or get your friends involved in PUGing? Check out my guide.

                Comment


                  #9
                  Cafe, thanks to have joined EUR CTF pug yesterday night. Joris and I already love your sniper

                  BTW, you mentioned a software that merges Teamspeak and irc chat functionalities. What is it ? That could help organizing matchs when people are missing like yesterday ...to be discussed.
                  Cunni, 37 years old, 16 years of UT, 90% CTF, 10% Duel
                  https://www.twitch.tv/cunni_ut
                  http://plays.tv/u/Cunni
                  Discord PUG Community

                  Comment


                    #10
                    Ok I found it : discordapp.com

                    Gotta test it.
                    Cunni, 37 years old, 16 years of UT, 90% CTF, 10% Duel
                    https://www.twitch.tv/cunni_ut
                    http://plays.tv/u/Cunni
                    Discord PUG Community

                    Comment


                      #11
                      So some good news. Loque has turned over the logs to his PUGbots. They include all the data for the old Quakenet channel as well, which existed almost as long as the #ut4pugs channel. I've been working on them all week as the logs were time stamped but did not include dates on each line. Since my Excel formulas rely on this information I've been trying to find a way to add it in. Given that there are over 1 million lines of text, doing this manually has been out of the question. I've finally figured out a way to do it and should be able to finish these up sometime next weekend. So yay!

                      On a sad note, Loque has disabled the chat logging feature of his bots. Doing so improved their responsiveness quite a bit, so I understand. Unfortunately, this will be the only time we have uninterrupted access to chat logs for #ut4.eu .
                      Mulsiphix's Guide To PUGing In UT4
                      What is the difference between a Public server and a PUG? PUG stands for Pick Up Game. A more organized way of playing, teams are selected by Captains and voice communication is used to achieve better team coordination. These clan-style matches involve the same regulars, week after week. The community aspect, of PUGing with friends, really adds to the fun factor of a match. Want to know more or get your friends involved in PUGing? Check out my guide.

                      Comment


                        #12
                        Great stats there mate!
                        Obviously iCTF is most active, but also because of the tourneys we pushed until now.
                        Once weapons community is quite happy about how weapons are balanced and play we surely focus as much on weapons tourneys! We have more than enough time

                        Oh and to Cunni about lot of players playing CTF on epic hubs without pugging: I sincerely hope you get those players to our platform because I`m sure the more you will play, the more active other players get, the more active CTF gets. Dont underestimate the amount of players we have online, together you are strong
                        We have an insanely active iCTF community but do you ever see any iCTF game on epic hub? They all pug!

                        As for having IRC (at the moment) as chat platform: Not in any way I am relying or pushing to have IRC, its just by far the most active network out there at the moment with good bots providing games.
                        Once something is build in in UT4 itself I see us moving directly to that new chat platform
                        Discord itself is not adding something substantially to the tools we use now (with 1 click you have webchat openend, 2 clicks u are in our TS chan).
                        Really the only big opportunity is when something is build in UT4 itself.

                        See you around players!
                        Last edited by Loque-; 01-24-2016, 05:26 AM.
                        Visit our website unreal-battles.net
                        Join the
                        European UT4 community on Facebook @ www.ut4.eu/fb-group-page/ and webchat + games @ click here


                        Comment


                          #13
                          Concerning My First Analysis Of EU PUGs
                          Alright guys I've got some big news concerning the EU stats posted above. Turns out that the number of PUGs previously reported was incorrect. If you remember, there is a part of this process where I identify and remove false PUGs (see the How Was The Number Of Unique PUGs Determined? section in the first post). Unfortunately, due to an oversight on my part, quite a few of these false PUGs made it into the final results. If you're intrested in exactly what happened, check out the end of this post for more details.

                          Of the original 1,219 pugs originally reported, about two thirds of PUGs that should have been removed during the false PUGs portion of the process, were instead added to the list due to a simple mistake. After fixing the macro the actual number of authentic pugs remaining was 1,070. However, this is not the big news I have to report. Previously all chat logs came from BlueCloud, which were only about 95% complete, and only covered the #UT4.eu channel. The big news is that Loque- has sent me the chat logs from the PUGbots themselves, which are 100% complete, and they cover both #UT4.eu and the original Quakenet channel #ut4.pug!

                          These logs have been a nightmare to process because each line contains a timestamp but does not include a date. It was possible to figure out the date and apply it to each line, but doing this has taken me over three weeks to figure out and two more to process. During this time the macro was greatly expanded. Rather than being built for speed it was reeingineered to work for both Loque-'s and BlueCloud's logs, and is now extremely slow as it is painstakingly thorough and redundantly cautious. It was during this time that I discovered the issue that led to my previously incorrect total PUGs number.

                          I won't bore you with the fine details of why the total PUG number is now unquestionably perfect, but it is and I hope you all can feel as confident with these revised numbers as I do. As always, I am happy to answer any questions or provide details or work history on any part of this process. The original data in the first post was removed and replaced with the updated data. Enjoy!

                          Note: On a sad note, Loque- found that having the bots log chat in the channel was greatly slowing down their response time. After sending me their logs he permenantely disabled their logging abilities for good. Any future analysis of 2016 PUGs will be based on BlueCloud's 95% complete logs.

                          So Tell Me More About How You Screwed Up!
                          I use an IDE called UltraEdit to process the massive chat logs. It allows me to build macros to automate the tedious and repetitive process of extracting the data I need to build my Excel spreadsheet. False PUGs are identified by searching for PUGbot saying "macro stopped because". That line is deleted and a search is performed upwards for the most recent "pug has been filled" occurrence. That is then deleted and when that process is finished, no false PUG starts remain. All remaining instances of "pug has been filled" are tallied and this is the total number of authentic PUGs.

                          So , lets say I'm in the middle of a text file and I perform a search. If the string I'm looking for is not found by the end of the file, UltraEdit simply goes to the top of the file and continues to search until it reaches the line where the search was originally initiated. Turns out that if you perform a find and replace from within a macro, UltraEdit simply stops searching when it reaches the end of the file. Unlike the #ut4pugs channel which has a single PUGbot, #UT4.eu has used five different names for their two PUGbots throughout the history of their channel.

                          The macro is written to find false pugs for each of the five names, one bot at a time. After it finishes searching for the first name, the cursor is somewhere in the middle of the chat log. It then begins searching for the second PUGbot name. If any "pug stopped because" lines exist for this second name above my current position in the file, they are ignored. I assumed that UltraEdit was searching the entire file, top to bottom, for each name. This is how I screwed up.

                          To address this problematic behavior I needed to force the macro to return to the first line in the file before it performs the next round of find and replace commands for the next PUGBot name on the list. After I added this behavior to the macro, no "pug has been stopped" lines remained. Unfortunately, about two thirds of the "pug stopped because" occurrences were never touched by my macro in my original numbers. This is why the total number of PUGs is actually lower in these revised numbers compared to my first release of the #UT4 Community data.
                          Mulsiphix's Guide To PUGing In UT4
                          What is the difference between a Public server and a PUG? PUG stands for Pick Up Game. A more organized way of playing, teams are selected by Captains and voice communication is used to achieve better team coordination. These clan-style matches involve the same regulars, week after week. The community aspect, of PUGing with friends, really adds to the fun factor of a match. Want to know more or get your friends involved in PUGing? Check out my guide.

                          Comment


                            #14
                            This is very nice to see actually I think it gives players a more detailed look into our channel & what's going on! I also like to thank you for spending so much of your personal time doing all these guides & statistics it really does help people get a good idea of pugging & other stuff.

                            Comment


                              #15
                              Originally posted by WeeDMaN View Post
                              This is very nice to see actually I think it gives players a more detailed look into our channel & what's going on! I also like to thank you for spending so much of your personal time doing all these guides & statistics it really does help people get a good idea of pugging & other stuff.
                              Thank you . My hope is to introduce more people to the joys of PUGing and expand overall knowledge and awareness
                              Mulsiphix's Guide To PUGing In UT4
                              What is the difference between a Public server and a PUG? PUG stands for Pick Up Game. A more organized way of playing, teams are selected by Captains and voice communication is used to achieve better team coordination. These clan-style matches involve the same regulars, week after week. The community aspect, of PUGing with friends, really adds to the fun factor of a match. Want to know more or get your friends involved in PUGing? Check out my guide.

                              Comment

                              Working...
                              X