Game Design, Programming and running a one-man games business…

Where do the wishlists for my game ACTUALLY come from?

I was this many days old when I discovered this stuff… Anyway, I have been trying to boost sales of Democracy 4, as you do, and thus have been experimenting a lot with the UTM tracking cookie stuff that steam now supports. The results have been mixed, and complex, and not the direct topic of this quick blog post, but one thing did come out of my analysis…

I’ve been tracking a bunch of different ad campaigns I have been running since the 6th april. Lots of spreadsheet crap later, I concluded that I can trace the relative effectiveness of multiple ad campaigns that have led to to be able to vouch for 167 wishlists adds for Democracy 4 during this period. Unfortunately there is a problem with this number:

In that period, Democracy 4 had over 8,000 new wishlists. That means I’m fussing and huffing over a stupid <2% of the total. Why do I give a damn about these -ad-generated wishlists when clearly I am getting so many more from other sources. But where?

The first place to look at is the graph, to see if we had any actual notable spikes in wishlist adds during that period:

Clearly the answer is YES. Around 30th april to the first few days in may there was a big spike in D4 wishlists. Its not earth shattering, but its pretty good. Sadly steam has no way of telling me directly where they came form, unless they came from people using UTM tracked links, which clearly they were not, or I would have spotted them earlier. So I had a hunch this might be youtube related, as I have done some promotion to youtubers lately. I narrowed down a google search for “youtube democracy 4” with a super tight date range, and the top hit was a bunch of lets play videos from a Turkish youtuber. How can I tell if this is the spike?

Well… this is what I learned today. You will not find this information ANYWHERE in the wishlist stats pages for steam. You might imagine if it was anywhere, it would be there…but no. To be fair, its explained in the steam docs, but its hardly intuitive. If you go to the regional sales reports for each app, and look at each country and then expand the little + icon you find it…

So as I understand it, I got a 2,600% increase in the usual number of wishlists per-day from Turkey over that period. Its actually *not a lot* in revenue or wishlist terms, but the percentage difference is pretty eye popping. This is handy because its not just saying I made $x extra revenue thanks to this youtube coverage, but also potentially more due to the wishlisters who would hopefully then buy the game on sale later.

Of course thats interesting…but it begs the question as to how effective is it compared to ads, and if its effective enough, how to encourage it in future. I got about 8,000 wishlists over my examined date range, and 513 seemed to come from this youtube vid. Total Turkish wishlists were 965, so over half of them came because of one youtube vid. That means its DEFINITELY worth trying to repeat that in other countries.

And of course there lies the issue. How to get youtubers to play my game? And not just the wannabes with 5 followers and 2 views per video (1 to check it uploaded, and 1 from your mother). This is the real problem. You can get your game in front of a lot of youtubers with ads on keymailer, but still, thats just a capsule. How to really get across to them that this is a GOOD video for lets plays?

FWIW I think the game is unusually good for youtub,e but especially twitch. You can literally poll your viewers on what laws to pass or spending to cut/increase. What could be better for hilarious results and interaction with your viewers? The trouble is, finding a way to tell that direct to youtubers without just shoveling money at PR companies to pester them for me. I’m still not 100% sure on the ROI there. (its so fuzzy).

Food for thought anyway. BTW if you *do* want a key and have thousands of followers/views, you can see our keymailer link here:

non-political environmentalism

I’m an enviornmentalist. No surprise, because I have solar panels and an electric car, and am even planning to build a solar farm. However I am not any of these things:

  • A Hippie
  • Into drugs
  • A vegan
  • An ‘outdoorsy’ person
  • LGBT
  • A pacifist
  • Into face painting and bongo drums / festivals
  • A Socialist

I have nothing against any of those traits. I have buddies with probably all of them. (Not sure about the bongos actually), and there is nothing negative about any of them. It just so happens that they are not me. But if you see news footage of environmental activists they pretty much are always someone with dreadlocks and bongo drums face-painted as an owl, talking about how sustainable living is incompatible with the ‘capitalist system’. These are the people who are chosen to be on TV. Why?

They make more interesting TV.

I’m a fairly boring looking stereotypical middle aged dude with rapidly thinning grey-ish hair and glasses. I’m an office-bound company director. If you HAD to guess by looking at me, you would assume I’m middle-management, married, 2 kids, semi detached house, and listens to dire straits on his commute in his Ford Mondeo. You would not assume I’m an environmentalist.

The reason I’m an environmentalist is practical. Climate change is fucking up the environment, and I happen to live in the environment. I’m also 51. if I was 81, maybe I wouldn’t care (I suspect I would actually…), but in PURE SELF INTEREST, I am aware that unless we sort this issue, my retirement years are fucked.

There are a bunch of myths about the environment that are believed by most people in my position. Such as:

I’m too old to worry about it. I’ll be dead before it gets bad.

Firstly…you don’t have kids? I hope not, because you are just letting them have a fucked up life instead of you. Seriously, do NOT bother including them in your will, or educating them. Who cares right? whats the point of a house and an education if we hit 2 degrees warming in their life. (clue: none, they will be dead before needing either).

Secondly… even if you do NOT have kids…. your timescales are off. We are not ‘waiting’ for climate change to start wrecking us. its started. Do you not even *watch* the news. Sure…a catastrophic freeze in TEXAS that bursts pipes, and wipes out the power grid for days at a time is just normal right? (no). The number and severity of extreme weather events is accelerating. Already. And its going to get way way worse before it gets better even if we take this seriously. Like I said, if you are under 80, yes, it will fuck up your life. Also, just the texas event cost $195billion. Just 1 year, One state.

Texas weather: Deadly winter storm sweeps Texas and US southern states -  BBC News

This is all just socialism in disguise.

My close buddies would laugh at me having to argue this. NO. There is NO link between left/right politics and environmentalism as a goal. Sure, a powerful state could ‘fix’ climate change with massive taxes and massive state investment. SO could a revenue-neutral carbon tax that shifts the tax base purely towards pollutants and away from income. One of the most effective companies doing something abouit climate change is the car company tesla. A capitalist company run by a billionaire, and occasional worlds richest man. Elon isnt doing this because he is a communist.

True, a lot of left-wingers are also environmentalists. But there is NOTHING incompatible about capitalism and fixing climate change. It should be seen as a huge business and economic shift that is an opportunity for canny investors to make a fortune. My Tesla shares are up 800%. Thats not socialism.

Elon Musk: 620-Mile Tesla Roadster Will Be 'Part Rocket' & Can Fly 'A  Little'

Its an excuse for big government to control us.

Doesn’t have to be. We already have most of the tools in government to take drastic action. fossil-fuel cars are taxed (at different rates), gasoline is taxed, electricity consumption is taxed. Car efficiency is regulated. Major changes to the way we approach climate change can happen literally by changing some numbers in a database by the government. More drastic measures like a carbon tax would involve new laws/tax policy, but that can be a headache for power-plant operators and oil refineries. The government does not have to VAGUELY get more involved in anybodies life to fix this issue.

It will not affect my country / be good for my country

No. It doesn’t matter where you live, 2 degrees of warming is BAD news for the human race. It sounds like its trivial, whats 2 degrees right? The reason for it is simple, but not talked about, and its nothing top do with sea-level rise (although yup, your beach-side house is FUCKED btw). Its Food production. Food is VERY sensitive both to temperature, and to extreme weather events. Crop yields are vastly affected by climate change. And extreme weather events are generally infrequent enough that we tend to get a decent harvest almost every year. As that ramps up, food yields go down, combined with temperature change to yields and…our food production is going to start to collapse while our population continues to rise.

Crop failure and bankruptcy threaten farmers as drought grips Europe |  Drought | The Guardian

Honestly, even if food prices double, I’m fine.

Great news for you! But I hope you enjoy the idea of living in a gated community with armed guards then, because the fact that YOU can afford food does not mean your neighbors can. Also…even if they can, their disposable income has now collapsed, because food takes up so much of it. That basically collapses the economy. Not your economy, the global economy. Your retirement fund is now worth zero. How are you paying for that food now? Oh and… when entire regions and countries become useless for food production…people leave. They are desperate, hungry, poor and need somewhere else to live. If people think the last decade or so of problems with migration into Europe is bad, its going to get way way worse unless we do something.


You will not be ‘ok’ if we hit bad levels of climate change, and the current forecasts are catastrophic. You might not be ‘interested’ in it (you really think I’m interested in climatology?), you might think ‘its no big deal’ you might think ‘its just for people like X’, but I urge you to rethink all that. Like anything in 2021, Climate Change has been shoehorned into the culture wars and social justice wars. PICK YOUR SIDE! Except actually you don’t have to. People on twitter shout very loudly that sustainability is incompatible with capitalism! Just because its in a hashtag doesn’t make it true. No more than an Ayn Rand advocate saying freedom is impossible without capitalism. Do not let other people decide that environmentalism is ‘not for you’. At its heart, its actually just practical self-interest.

Updated Democracy 4 to build 1.28. Lots of super cool balance tweaks.

Soooo… I just uploaded the latest build of Democracy 4 everywhere, after 2 days of non stop testing. Lucky I did that because I found a few little visual anomalies that I could fix straight away, like some missing text in one dialog, and some occasionally ‘leaky’ underlined buttons in other places. Anyway…apart from some (minor) bug fixes, this was mostly a big run through all the stats in the game balancing things. First here is the complete list of changes:

1) Removed duplicate impact on security from mandatory microchip implants (2 appearances on security screen)
2) Reduced Technology impact of driverless car laws by 50%.
3) Doubled the cost of Stem Cell policy.
4) Reduced Technology impact of Technology Colleges by 25%
5) Boosted Technology impact of Rare Earth Refinement by 100%.
6) Reduced Technology impact of Technology Grants by 25%.
7) Illegal immigration situation is now slightly harder to trigger, easier to solve.
8) The Private Space Program,Armed Religious Communities and Doctors Strike situations are now harder to trigger.
9) Egalitarian society situation no longer influenced by Education, but needs Gender Equality and low Generational Wealth Gap.
10) Reduced link between Rare Earth Refinement and Productivity.
11) Reduced impact of Alcohol Consumption on Productivity.
12) Reduced default level of Productivity.
13) Slowed most inputs to the Corporate Exodus situation by 50%.
14) Slightly easier now to trigger the Teachers Strike.
15) Plastics Tax and Packaging Tax are now also inputs to the Black Market situation.
16) Homelessness,Antibiotics-ResitantBacteria,Class War and Food Banks situations now trigger more easily.
17) Dilemmas rebalanced so some are more frequent, others less frequent.
18) Bug fix for theoretically fixed situations like EU monetary policy stopping or starting.
19) Media Monopoly situation now reduces Democracy.
20) Fixed bug where some values on the ‘disposable income’ screen were inaccurate, or garbled (esp for South Korea).
21) Car Emissions limit’s impact on motorists income is now scaled by inverse of EV transition.
22) Cost of body cameras now scaled to numbers of police,community police & armed police.
23) Fake news now increases chance/effect of Contagious disease situation and boosts racial tension.
24) Fixed links for minister icons on main screen to correctly show inputs and outputs from them and their sympathy groups.
25) Education now takes time (2 years) to feed through into a change in Productivity.
26) Air travel now slower to respond to GDP, but boosts pollution more.
27) Worker productivity impact on GDP now a gentler curve.
28) GDP impact on unemployment now a gentler curve.
29) GDP has a steeper impact on pollution, homelessness and car usage now.
30) Corruption and average minister effectiveness now shown at the bottom of finance screen. Corruption affects policy costs/income now.
31) Corruption and minister effectiveness now shown at bottom of finance history for each policy, mouseover shows cost impact of each.
32) Corruption slightly boosts tax evasion now.
33) Rebalanced many inputs from state services to state employee membership and unemployment to make them more accurate.
34) Voter turnout is now generally higher in all situations.

Quite a list this time… but that’s because a lot of it was small statistical nudges here and there. Actually this is one of the most time consuming things about developing a game like this. I don’t have any fancy new particle effects to show you, or any new horse-armor options or new fireball spells or laser upgrades. All I can offer you is “After careful consideration and spreadsheet analysis, Corruption is X% more likely when Press Freedom is below Y”. This is actually stupidly important because its getting all those numbers right that makes the game playable and fun and not a mess.

The only big noticeable changes that players will see rather than *experience* are that bureaucracy is now a thing (triggered by having a LOT of policies, or not so many if you are the weirdly bureaucracy-obsessed Italians), and I added some extra data at the bottom of the finance charts to show you that corruption also affects policy effectiveness along with ministerial effectiveness.

In theory Democracy 4 gets easier to balance over time, because we are slowly homing in on the ‘perfect’ game balance, by pruning obvious dumb edge cases as they are reported or spotted by me, and also I get more and more data from players on what happens too often, what happens too rarely. For example each update should have you experiencing a larger and larger percentage of the dilemmas and events in the game. They may *feel* random, but they are actually being triggered by various in-game parameters. Balancing those so that they show up at appropriate times, but you also get to experience most of them is really tricky…

As always, don’t forget to voter on priorities from the games main menu screen, and like I always say, leaving a positive steam review is a really big help, as is telling your friends about the game if you are enjoying it. Its also really great to get helpful feedback. The best possible feedback is stuff like “When playing country Y as a conservative, it feels too easy to keep voter group X happy by doing Z, even though it doesn’t upset anybody else” or whatever…

Improving accuracy of state employee & unemployment effects in Democracy 4

One of the problems with making a vidoe game with one person doing the development, where you try to model the entire world in inter-connecting detail…is that its impossible, so you end up doing a lot og guessing and thinking ‘yeah that looks ok to me’. Then eventually you find the free time (ha! its the weekend, who am I kidding?) to go back and check that the wild ass guesses you made were just wrong, and not OMG emebarrasingly badly wrong. Its a low bar, but i’m determiend to hit it.

My game Democracy 4 has a lot of policies that affect two important variables in the game – The membership of the ‘State Employees’ group, and the level of unemployment. For hopefully obvious reasons, these numbers are important in a government/ politics sim. They have to make some vague sense. Until now, the numbers in the game have kind of been guesswork, and result in equations like this:


That means that the effect of that policy will vary between a 2 percent and 7 percent boost to the number of voters who identify as state employees, depending how the policy slider is set. In other words, this policy assumes that at max capacity, this policy represents a seven percent higher chance of any voter joining that voting group, although in practice its much more complex than this, due to internal algebra that I wont bore everyone with…

The problem for me is that although I do not mind that seven percent figure being possibly inaccurate, I DO want the games model of this stuff to be internally consistent. To put this another way, if in the real world, a state health service employs 10x the people of a state postal service, the game should attempt to get that ratio correct, at the very least. With this in mind I have done some research, using the USA as my base case for the policies most impacting state employees:

These figures are NOT 100% accurate. This is mostly because the US does not have a state health service in the same way the UK does, so I had to take NHS figures and then adjust for population. I also had trouble getting energy figures, so I extrapolated from the top 10 companies employees and adjusted on a per-household basis. The point is that although the figures (like all figures) are a bit wrong (probably) they are massively less wrong than my guesses!

So now to make the game values make sense, I need to work out how to adjust those values in the second and third columns, which are my current effects (at max slider) on state employees and unemployment. Given that I do not want top massively unbalance the game, I thought it was prudent to keep the total combined effects of all of these policies the same (93% and 126% respectively) and just adjust the figures internally to fix the relative impact,

The way I’ve done this is to use the employment percentage (the actual percentage as a portion of total employment of all these policies) and multiply that by the total current in-game effect (93 or 126) to give me the new adjusted effects. That looks like this:

In some cases its not too big a change but in others its hilariously different. Currently the game is giving a HUGE (18%!) boost to state employees from armed police when it reality it should be about 3%. On the other hand state schools were set to have a 10% boost to employees, and should be having a 29% boost instead! So many teachers! Its also evident that in the grand scheme of things, prisons and a state broadcaster employ virtually nobody. (I scaled up the BBC employment figures to USA size to get that data too).

I have just done the data so far, but later today I’ll go through all the policies and adjust the values in each equation. I guess the takeaway from all this as a player is that if you really want to cut unemployment when you spend money on public services, you want to splurge cash on the health service and schools/universities. Everything else is trivial.

Keen-eyed economists might note that the REAL employment impact would be different. For example, the direct employment from the US military may be 1.3 million, but defense contractors etc will employ many more, and the knock-on effects from the contractors CEOs buying new ferraris is even higher. I agree, but that is best dealt with through a GDP boost I think.