BanklessDAO
BanklessDAO
/
📊
Analytics Guild
/
📈
The DAO Dash Project
/
Dao Dash Standup 12/14/21

Dao Dash Standup 12/14/21

Guild
Analytics
Date
Dec 14, 2021
Members Present
Members without tags
joker, itamar
Announcements
  1. Welcome ItamarGo
Agenda
  • Coordinape API Update
  • stg_bankless_subgraph table missing initial rows?
  • Superset Public access now?
    • Maybe too public? Needs a bit of work before linking to community
    • Testing and QA
  • Shloked Charts are erroring
  • S3 Spec - Review
New/Open Items:
Build a 3 layer analysis of Treasury→ Project/Guild → Individuals
Joker - Saul get together on Coordinape nodes to be completed by December
RTJ to make a post in DAO Dash channel to bounty this question
  • First quest 4600 new joiners , 80% drop off before completing
  • How many get a guest pass role? how long does this take? what is this %?
  • How many get L1 role? how long does this take? what is this %?
  • How many get L2 role? how long does this take? what is this %?
    • activated_at - timestamp for the role being added to a discord user
  • note - This failed on bounty board - is it suck?
Paul - get review on snapshot pipeline & review scheduler code
Saul to bring in RTJ for next sales call
Notes:
  • McKethanor
    • working with Coordinape team, got credentials to hit API
    • In a month they are headed to GraphQL
    • Can get Raw JSONs now, need to be translated to Postgre
    • Data Quality - Shlocked had a query that didnt have the right count for Level 1s, which led to an analysis of the subgraph and found missing data
    • Should we have a role do do Data Quality and QA? (Yes!)
    • Bot split into 2 parts -
      • Data Gathering (which can be deployed to many DAOs)
        • To get GuildID
        • To protect against bans
      • Parsing Bot -
        • Read off queue, parse into multi tenancy DB
    • Deploy to talentDAO and to DAOPunks servers before end of season
    • McKethanor is getting bills now for Digital Ocean which will be reimbursed from the project ($60USD last month)
  • Spec note - The database on Digital Ocean needs to be updated
  • Paul - Engagement metric post from last week shows that we are delivering what the S2
New Action Items:
Paul to incorporate comments to S3 Spec
Saul/RTJ add budget forecasting to S3 Spec
Paul to circle back to Coordinape API - build pipeline (after S3 Spec)
 
 
BanklessDAO
BanklessDAO
/
📊
Analytics Guild
/
📈
The DAO Dash Project
/
Dao Dash Standup 12/14/21

Dao Dash Standup 12/14/21

Guild
Analytics
Date
Dec 14, 2021
Members Present
Members without tags
joker, itamar
Announcements
  1. Welcome ItamarGo
Agenda
  • Coordinape API Update
  • stg_bankless_subgraph table missing initial rows?
  • Superset Public access now?
    • Maybe too public? Needs a bit of work before linking to community
    • Testing and QA
  • Shloked Charts are erroring
  • S3 Spec - Review
New/Open Items:
Build a 3 layer analysis of Treasury→ Project/Guild → Individuals
Joker - Saul get together on Coordinape nodes to be completed by December
RTJ to make a post in DAO Dash channel to bounty this question
  • First quest 4600 new joiners , 80% drop off before completing
  • How many get a guest pass role? how long does this take? what is this %?
  • How many get L1 role? how long does this take? what is this %?
  • How many get L2 role? how long does this take? what is this %?
    • activated_at - timestamp for the role being added to a discord user
  • note - This failed on bounty board - is it suck?
Paul - get review on snapshot pipeline & review scheduler code
Saul to bring in RTJ for next sales call
Notes:
  • McKethanor
    • working with Coordinape team, got credentials to hit API
    • In a month they are headed to GraphQL
    • Can get Raw JSONs now, need to be translated to Postgre
    • Data Quality - Shlocked had a query that didnt have the right count for Level 1s, which led to an analysis of the subgraph and found missing data
    • Should we have a role do do Data Quality and QA? (Yes!)
    • Bot split into 2 parts -
      • Data Gathering (which can be deployed to many DAOs)
        • To get GuildID
        • To protect against bans
      • Parsing Bot -
        • Read off queue, parse into multi tenancy DB
    • Deploy to talentDAO and to DAOPunks servers before end of season
    • McKethanor is getting bills now for Digital Ocean which will be reimbursed from the project ($60USD last month)
  • Spec note - The database on Digital Ocean needs to be updated
  • Paul - Engagement metric post from last week shows that we are delivering what the S2
New Action Items:
Paul to incorporate comments to S3 Spec
Saul/RTJ add budget forecasting to S3 Spec
Paul to circle back to Coordinape API - build pipeline (after S3 Spec)