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?