Oddbean

I need to build a query to collect data from Nostr to understand if “social onboarding” actually results in better retention than the control data charted on nostr.band “retention of trusted users”. (Below) With “social onboarding” being already practiced by (what I call) nostr advocates, who invite and mentor their friends to nostr. The query would identify an advocate by looking at first posts and follows of all accounts: Advocate = is the first follow of a new account + follows the new account within 24 hours + is author or recipient of first Note or DM with the new account + “engages” with new account “regularly” during a period + is “trusted” by trust.nostr.band For use in upcoming Advocate Awards: @The Nostr Advocate A bit of consultation (for this noob nostr dev) would be appreciated. @brugeman ? Anybody? nostr:note1sdqu263xaq95fkdlnejgrgkqnpf2rapte8nfq6v3kzc37jw2npsqv5vr2u

I built a cruddy tool for this: https://github.com/coracle-social/navigatr You could potentially stand up a relay, scrape the network, then query your database. I think nostr:nprofile1qyghwumn8ghj7vf5xqhxvdm69e5k7tcppemhxue69uhkummn9ekx7mp0qyfhwumn8ghj7ur4wfcxcetsv9njuetn9uqzp75cf0tahv5z7plpdeaws7ex52nmnwgtwfr2g3m37r844evqrr6jm89g02 was working on something like this.

@brugeman maybe I could work with you to (build a query) that powers another graph on stats.nostr.band? “retention of trusted users onboarded by trusted users” (for comparison to “retention of trusted users”) Such a graph could reinforce Nostr’s budding “social onboarding” community (which also brings new users into existing “webs of trust”) through “proof of benefit” that word of mouth is actually effective and worthwhile to support.

This is a great idea. But calculating it based on your criteria won't be trivial: > is the first follow of a new account This can't be calculated with certainty, because clients can rearrange contacts, but most of them don't, so might be ok. > follows the new account within 24 hours Not possible unless we track the full history of contact list editing by the advocates. We don't. > is author or recipient of first Note or DM with the new account OK > “engages” with new account “regularly” during a period A bit complex but ok. > is “trusted” by trust.nostr.band OK. If we replace the second condition with just 'Follows the new account' then it might work. But I can't promise to deliver this soon - quite complex endeavor with an obvious result. Do you really need the confirmation in numbers to keep building your onboarding tool?

>”Do you really need the confirmation in numbers to keep building your onboarding tool?” Due diligence. This is all. I’m building already.… It’s one thing for me (as a know nothing nobody) to assert that “social onboarding” is nostr’s super power. But evidence speaks louder than words. If the numbers demonstrate it’s effectiveness … then more tools will be developed to support. … then advocates will work in earnest rather than with small hopes … then nostr leverages it’s close community to accelerate the growth of a trusted user base … then nostr has real networks of trusted friends to buffer the coming onslaught of bots and bad actors to its open protocol. Open is hard. Connecting humans is key. Evidence helps motivate. IMHO Let’s work together on this …

>”If we replace the second condition with just 'Follows the new account' then it might work. But I can't promise to deliver this soon “ The historical data “for all users” is gonna be the most challenging. After this, Getting data for new users will be easier. - “First follow of new account” can be “assumed” to be first in contact list. - “Follows new account within 24 hours” can be changed to “follows new account” - “is author or recipient of first note or DM with new account” will be challenging when NIP-44/17 gift wrapped private messages takes main stage…. But that’s a tomorrow problem?