Get stats to measure TRIBES success rate

[Analysislearning]

As TRIBE PM, I need a way to see the metrics to measure success of TRIBES in Sphinx Chat. This will allow TRIBES PM to understand conversion rate from the marketing campaigns and outreach efforts.

STATS:

1. How many TRIBES exist in Sphinx chat under Sphinx nodes?
   • Total amount TRIBES
   • Total amount of Messages in TRIBES
   • Total amount of Payments in TRIBES (transactions in the lightning network)
2. How many TRIBES under Sphinx nodes are ACTIVE?
   • Date of last message of a Tribe
   • Name or link of Tribes that are ACTIVE
   • Total amount of Messages of the ACTIVE tribe
   • Total amount of Payments of the ACTIVE tribe (transactions in the lightning network)

Deliverables/ Phasing: v1 - get stats via dev v2 - periodically get stats to understand changes via dev v3 - build a UI somewhere or automate an email that you can trigger to understand stats without having to have a dev do it (once its built)

[Evanfeenstra]

tribe stats

• we can pull stats from the DB (1837 tribes in total, 1712 from full nodes, 125 from lite nodes)
• how many messages? we can see that in the tribe owner relay DB
• we have /stats (member count. the largest is Planet Sphinx with 6087)
• we have latest message in a tribe (which tribes are most recently active)

user stats

• user count on main proxy: 3991
• user count on swarm4: 206

[Analysislearning]

@Evanfeenstra Can we please get,

Count of total messages in TRIBES?

Messages count of total TRIBES ? Messages count of active TRIBES ? Messages count of Lite Node TRIBES ? Messages count of Full nodes TRIBES ?   Messages count of the largest TRIBE ?   and ,

Count of feature usage (from most popular to least popular)??

and,

Count of top 10 recent active TRIBES?

and,

Count of top 10 largest members in TRIBES?