| 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 28/07/2023 • Sample size is 65112 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 add tags for their games. Players add them too. So don't be surprised if you see the "Strategy" tag for "Counter Strike". |
4 | Changes from 2022 version | • More games than in 2022 (obviously) • We are gathering the data directly from Steam API instead using third party resources like last year -- https://www.gamedatacrunch.com/ and https://steamspy.com/ ( Still kudos to the creators! ) • For same reasons Review Score now taken from Steam, not adjusted. • D7/10/30 Review count excluded due missing a lot of data for old games and unconsistant results for new ones. • Small cosmetic changes in Competitors Comparison list because of previous changes. |
5 | Excluded Games | • All Coming Soon games. It is ~22 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. |
6 | How to Use | File > Make a copy > Play around! |
7 | Link | Original link for sharing purposes -- Steam Trends 2023 by @evlko and @Sadari |
8 | Yellow Headers | You can freely change the values under YELLOW headers. |
9 | Blue Headers | Usually some formulas. Change them at your own risk. |
10 | READ THIS BEFORE USE | |
11 | 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 Coeffs may differ drastically by Year. For example, in 2017 median coeff was close to 75 sales to 1 review, but in 2023 it's around 32 (based on Simоn Carness data from here -- https://newsletter.gamediscover.co/p/what-steam-review-count-tells-us). Latest data shows that current coeff is closer to 30-35. 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. | |
12 | What included | |
13 | Games Data | Full data sample with filters. |
14 | 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. |
15 | Tags Comparison | Choose tags and get various median data about games with those tags. Compare tags by revenue and owners. |
16 | Trends Comparison | Contains data that shows the different tags' popularity and prices from 2017 to 2022. 2023 is also included, but the data is predicted (the linear trend is used). |
17 | Tags | Simply all Steam tags used as a named range. |
18 | Hidden Coeffs | Coefficients for revenues estimates. |
19 | References | |
20 | Simon Carness | We use revenue to sales numbers from Simon's 2021 and 2023 articles 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, Product Analyst twitter: @evllko tg: @evlko email: evlko.oklve [at] gmail.com |