Jupiter DEX User Analysis for Targeted Token Incentives

    This dashboard seeks to help Jupiter understand its users better to reward them with tokens in a smart way. It helps unlock these secrets: ๐Ÿ‘‰ Meet the average user: See what they trade, how they trade, and what makes them tick. ๐Ÿ‘‰ Uncover different user groups: Group users based on their behavior, like "High Rollers" who love big trades or "Cautious Cats" who play it safe. ๐Ÿ‘‰ Rewarding the right way: Design token rewards that each user group actually wants and uses. With this dashboard, Jupiter can turn data into action and build a happier, more engaged community.

    Loading...
    Loading...
    Loading...
    Loading...

    This overview tab utilizes SQL queries to analyze key metrics pertaining to user engagement and trading activity on the Jupiter DEX over the past year.

    The focus is on understanding: ๐Ÿ‘‰ Active user base: How many unique users engage with the platform on a daily and monthly basis? ๐Ÿ‘‰ Trading volume: What's the daily and cumulative USD volume traded across the platform? ๐Ÿ‘‰ User stickiness: How consistently do users return to the platform, measured by the daily percentage of MAU actively engaging?

    All queries follow a similar structure:

    Data Selection: Fetch relevant data from the solana.defi.fact_swaps table, focusing on transactions involving Jupiter (swap_program ILIKE '%jupiter%').

    Time Filtering: Restrict results to the desired timeframe, typically the last 12 months (configurable).

    Filtering Successful Swaps: Only include successful swaps in calculations by ensuring succeeded = 'true'.

    Date Manipulation: Utilize date_trunc functions to group data by day or month as needed for specific metrics.

    Aggregation and Calculations: Perform calculations based on the desired metric, such as counting distinct users, summing volume, or calculating percentages.

    Joining and Ordering (Optional): Join results with temporary tables or external data as needed, and finally order results by date for chronological analysis.

    Specific Queries: ๐Ÿ‘‰ Daily Active Users (DAU): Counts the number of unique swappers per day. ๐Ÿ‘‰ Monthly Active Users (MAU): Counts the number of unique swappers per month. ๐Ÿ‘‰ Daily Trading Volume: Calculates the daily USD volume traded on the platform. ๐Ÿ‘‰ Cumulative Trading Volume: Calculates the cumulative USD volume traded over the entire timeframe. ๐Ÿ‘‰ Daily Stickiness Percentage: Combines DAU and MAU data to measure the percentage of monthly active users engaging daily.

    Methodology
    Findings

    โœจKey Takeawaysโœจ

    ๐Ÿ‘‰Soaring Engagement: Daily stickiness consistently fell between 6-14%, demonstrating strong user retention. ๐Ÿ‘‰Explosive Growth: MAU catapulted from 95k-120k range to 750k in December, a 6x increase. January maintained strong momentum with 595k MAU. ๐Ÿ‘‰DAU Surge: Similar growth, 10k-20k range to a high of 149k in December, a near 10x increase. January remains above November's average.

    Driving Factors: ๐Ÿ‘‰Solana Outperformance: $SOL's bullish run fueled ecosystem activity, attracting new users.

    ๐Ÿ‘‰Memecoin Frenzy: $BONK, $WIF, and $GUAC drew massive interest, propelling Jupiter as a key trading platform.

    ๐Ÿ‘‰Aggregator Advantage: User preference for Jupiter's aggregation features further boosted activity.

    Further Analysis

    ๐Ÿ‘‰Trend Sustainability: Assess whether December's exceptional numbers were driven by temporary factors or reflect a sustained upwards trend. ๐Ÿ‘‰User Segmentation: Deep-dive into different user segments' behavior and engagement patterns to tailor incentive strategies. Check next tab ๐Ÿ‘‰Volume Drivers: Uncover specific token pairs or trading activities contributing most to the daily trading volume. Check next tab

    db_img
    Overview of Jupiter

    Jupiter is a leading DeFi Aggregator built on the Solana blockchain. It allows users to trade cryptocurrencies directly with each other, without relying on a central authority. Here's a quick breakdown:

    Popular: One of the top defi application on Solana, known for its high liquidity and efficient trading.

    Focus: Mainly caters to Solana-based tokens, including popular ones like SOL, USDC, BONK, and HNT.

    Features: Offers a user-friendly interface that allows users to SWAP, DCA and bridge assets, and many more.

    Token: Its expected to launch the JUP token in the 4th week of January.

    Community: Boasts a thriving community of traders and investors.

    In short, Jup.ag is a trusted platform for anyone looking to trade crypto on the Solana blockchain.