Work with data at a liquid staking protocol on Arbitrum. In August we ran our first big marketing push.
Founders spent almost a month choosing web3 marketing agency for it, and in the end they used ICODA for content and KOLs, Coinbound for quests.
Now they want to know how many new stakers each agency brought. I tried to match wallets to sources. Quest wallets were easy because the quest platform gives an export. Referral codes were also easy. For KOL posts we had UTM links, so I matched them to wallets that connected in the same session.
All of this together explains less than half of the new stakers. The others staked through aggregators or came without any link, so I can’t see where they came from.
Then I added a 7 day window. If a wallet clicked a UTM link and then staked through an aggregator in the next 7 days, I counted it for marketing. With this the number grows a lot, and I don’t really believe it.
Is a fixed window normal in DeFi?…