| A | B | |
|---|---|---|
1 | What is it? | |
2 | Idea | This data can help you better understand the current situation on the PC platform, you can look up some popular or unpopular trends on the market and maybe even make decisions about which genre to choose for your future game! Feel free to use it however you want. Please give us credits if you use our data in your work, we would really appreciate it. |
3 | Sample Info | • This sample data contains lots of basic information about all released games until 20/08/2022. • We used https://www.gamedatacrunch.com/ and https://steamspy.com/ for gathering the data. Kudos to the creators! • Sample size is 54048 games. • All reviews in the sample are FILTERED -- that means they exclude review bombs and reviews from players who got the game for free. • Revenues estimates based on the famous Boxleiter method. • Not only developers adds tags for their games. Players adds them too. So don't be surprised if you see the "Strategy" tag for "Counter Strike". |
4 | Excluded Games | • All Coming Soon games. It is ~20 000 titles. Unreleased games don't have any open useful data. • Several dosens of anomalies, like games without tags. They are all pretty obscure games so their erasure is statistically insignificant. • Games that have always been F2P. For example, CS:GO is in the sample, but Apex Legends is not. If included, F2P games makes data very noisy. |
5 | How to Use | File > Make a copy > Play around! |
6 | Yellow Headers | You can freely change the values under YELLOW headers. |
7 | Blue Headers | Usually some formulas. Change them at your own risk. |
8 | READ THIS BEFORE USE | |
9 | Before using this data you need to understand several important things: • The values in this spreadsheet are NOT EXACT NUMBERS, they are ESTIMATES. So keep in mind margins of error. • Review Score in sample may differ from Steam. It's because GameDataCrunch Review Score is calculated by only using reviews from customers that purchased the game and weren't part of a review bomb (ignore free keys, ignore review bombs, but keys sold off platform are not ignored). Additionally, a confidence factor is applied so games with lower amounts of reviews are worth less to better compare across all games. • Review Coeffs may differ drastically by Year. For example, in 2017 median coeff was close to 75 sales to 1 review, but in 2020 it's around 38 (based on Simоn Carness data). Change them yourself if needed. • Do not try to use the same review to sales ratio coefficient for indie and AAA games. AAA is completely different in terms of marketing and is not relying on Steam featuring much. These games use different methods to gather traffic, and because of that, they have a much higher reviews to sales ratio. You can try to use coeffs from this article (https://vginsights.com/insights/article/further-analysis-into-steam-reviews-to-sales-ratio-how-to-estimate-video-game-sales), but data will be very unreliable because of the very big difference between min and max values. Keep this in mind when you change Reviews Coeff. • Data sample is really big. We might miss something. Please contact us if you think you found a mistake. • When changing the values Google sheets sometimes freeze. Reload the page if it happens. | |
10 | What included | |
11 | Games Data | Full data sample with filters. |
12 | Competitors Comparison | Choose up to 3 tags and get all games with these tags. You will see estimated revenues and various median data. Change the review threshold to narrow the sample. |
13 | Tags Comparison | Choose tags and get various median data about games with those tags. Compare tags by revenue and owners. |
14 | Trends Comparison | Contains data that shows the different tags' popularity and prices from 2017 to 2021. 2022 is also included, but the data is predicted (the linear trend is used). |
15 | Tags | Simply all Steam tags used as a named range. |
16 | Hidden Coeffs | Coefficients for revenues estimates. |
17 | References | |
18 | GameDataCrunch | by Lars Doucet and Level Up Labs, LLC. Support them on Patreon! |
19 | SteamSpy | by Sergey Galyonkin! Support him too! |
20 | Simon Carness | We use revenue to sales numbers from Simon's 2020 article as variables in our comparison lists. |
21 | VG Insights | Another source of our review coeffs. You can use these if you think they are closer to truth, it's up to you. |
22 | Credits | |
23 | Alex «Sadari» Barabanov | Lead Game Designer @ Sad Cat Studios ex-Game Designer @ ITT, My.Games & some indie Email: sadari.chan@gmail.com LinkedIn: https://www.linkedin.com/in/alexander-barabanov-869b1a146/ Twitter: @Sadari_sama tg: @Sadaris |
24 | Lev «evlko» Kobelev | Game Designer @ Whalekit, My.Games Also Indie games: I hate this game & Who is Awesome Twitter: @evllko tg: @evlko email: evlko.oklve@gmail.com |