[IDEA] Implement a User retention tool(cohort analysis and funnel analysis) for Opyn V1 and V2 protocol.

[tech-nerd]

Idea

Implement a User retention tool(cohort analysis and funnel analysis) for Opyn V1 and V2 protocol.

Introduction

Implement User retention tool(cohort analysis and funnel analysis) for Opyn V1 and V2 protocol.

Details

Team Size : 3

Importance of User Retention Analysis

• Cohort analysis will help measure the user engagement of Opyn users over time. It will help track repeat users on Opyn platform and understand what makes them happy.
• The tool will help understand vital metrics such as churn, users lifecycle and customer lifetime value.
• The analysis can be used to identify the success of the feature adoption rate.
• A funnel report gives information on how Opyn users progress through different stages and where they drop off. Funnel analysis help identify barriers that cause users to leave before reaching a conversion point.

Features

• Display aggregated metrics e.g. total Deposit transactions, Total unique users doing deposit
• Monthly Cohort analysis of unique user DepositCollateral transactions.
• Monthly Cohort analysis of unique user WithdrawCollateral transactions.
• Monthly Cohort analysis of the total Deposit Collateral amount.
• Monthly Cohort analysis of the total withdrawn Collateral amount.
• DepositCollateral Funnel analysis and graph.
• WithdrawCollateral Funnel analysis and graph.

Please see the user retention tool implemented for AAVE protocol.
https://github.com/dappquery/aave-user-retention-analytics

Milestones

• Data will be pulled from Opyn V1 and V2 protocol subgraph and after transformation, data will be populated in SQL tables in the Postgres database.
• SQL queries will be written to query data from the Postgres database.
• Graph will be displayed on the SQL query result.
• DepositCollateralAction subgraph entity will be used for tracking the user's deposit on a month-by-month basis.
• WithdrawCollateralAction subgraph entity will be used for tracking the user's deposit on a month-by-month basis.
• The dashboard/tool will be hosted on a subdomain e.g. opyn.dappquery.com.

Ideal Launch Date

2-3 weeks

Funding Request and Budget Breakdown

12k USDT

Grant will cover below features:

• Development efforts for the above-mentioned features.
• Infrastructure cost for running and maintaining the dashboard on the AWS cloud.
• Hosting the project on remote servers.
• Postgres database cost.
• Maintenance and support for a year.
• Dappquery is TheGraph Indexer. We will be indexing Opyn V2 subgraph

[haythemsellami]

This is great! can you make a PR for this. I guess you meant to make a proposal, and the way to submit a proposal is by creating a pull request. Issues are meant to share ideas that anyone can build and apply for through a proposal :)

[tech-nerd]

This is great! can you make a PR for this. I guess you meant to make a proposal, and the way to submit a proposal is by creating a pull request. Issues are meant to share ideas that anyone can build and apply for through a proposal :)

sure, I was asked to create a issue for the grant program.
I will create a PR for the same

[haythemsellami]

This is great! can you make a PR for this. I guess you meant to make a proposal, and the way to submit a proposal is by creating a pull request. Issues are meant to share ideas that anyone can build and apply for through a proposal :)

sure, I was asked to create a issue for the grant program.
I will create a PR for the sa,e

Great, thank u! and sorry for the confusion :D