In 2017, I was the data engineer behind user acquisition reporting at PlayStudios. We ran four games: myVEGAS, Konami Slots, Blackjack, and POP. They shipped on iOS, Android, Amazon and WebGL, plus a myVEGAS web version. The UA team had to decide every week which ad networks to scale and which to cut. The numbers they had came from different sources, in different shapes, and they followed the usual rule: if a network claims an install, it's paid. Everything else is organic, and organic is free.
That rule was costing us money. When we increased spend on a game, store traffic and search went up with it. Paid campaigns were pulling organic installs along with them, and none of that showed up against the network that caused it. Some networks looked weak only because we weren't crediting the organic installs they drove.
I built the attribution and ARPI model that fixed this, end to end and on my own. The SQL wasn't the hard part.…