Overview

Introducing our Blockchain Cohort Analysis and Query Tool – a groundbreaking solution designed to revolutionize how users interact with blockchain data.

Cohort Analytics Tool

Cohort enables the tracking of specific groups of addresses over time. By grouping transactions or addresses based on shared characteristics such as transaction, balance, or originating wallet, cohort analysis unveils valuable insights into how different segments of the blockchain network behave. Additionally, it facilitates comparisons between cohorts, enabling analysts to evaluate changes in transaction behavior in response to protocol upgrades, regulatory changes, or market trends.

1) Metric and Cohort Selection

Implementing cohort analysis is seamless with our cohort analysis tool. Simply navigate to the tool and select the preset metrics and cohorts of your choice. This streamlined process allows for quick and efficient utilization of cohort analysis to gain valuable insights.

Step 1 : Select a metric

Step 2 : Select a pre-defined cohort

Step 3 : Select a metric to compare with cohort data

Step 4 : Start analysing the cohort data

2) Custom Cohort Creation

Create your custom cohort by adding addresses of interest. Once your custom cohort is established, you can readily access calculated metrics tailored to your specific cohort, providing insightful analysis and comprehensive data.

Step 1 : Click create cohort or manage my cohort button

Step 2 : Add cohort title and wallet addresses belongs to the cohort

Step 3 : Check your own cohort on the cohort menu

3) Edit Visualization and Publish

The data is presented in a serial chart format, enabling you to swiftly discern insights at a glance. Moreover, you have the flexibility to customize the visual representation to align with the specific objectives of your analysis, ensuring that the visualization effectively communicates the information most pertinent to your needs.

Step 1 : Save and publish your cohort analysis

Step 2 : You can see the saved cohort in My Creations page

Step 3 : Edit the chart

Step 4 : Cohort chart can also be added to your dashboard

No-code Analytics Tool

CryptoQuant's no-code analytics does not require prior knowledge of data tools and provides a short learning time compared to any other data platform. Even without prior experience, you can quickly learn to perform advanced data analysis by reading the guide for just about an hour.

If you have a basic understanding of SQL or Excel pivot tables, you can start using the platform immediately without any additional guidance.

1) Start by selecting a table

The analysis starts by selecting a table that contains the data you would like to see. Options range from raw blockchain data to abstraction tables that organize and categorize complex project data.

Click ‘table preview’ to check the columns and data contained in the table to find out which table to select.

2) Add Query blocks

Metric

This section is where you determine how to process and summarize the chosen data table. In SQL, it is equivalent to a 'SELECT' statement. It supports various arithmetic operations such as sum, count, average, etc.

Data will be calculated by the selected time frame(day, hour, minute…) automatically without the need for additional coding.

ex) If you set the time frame to 'day' and calculate the sum of transaction volume, the daily transaction volume will be displayed automatically.

Where

This section is where you can add conditions and filters to the data selected in Metrics.

ex) If you add an address filter to transaction volume data, transactions related to certain addresses will be calculated.

Use Advanced Filtering feature to get access to CryptoQuant’s wallet label, meta data(basic information on token, NFT, smart contact, etc.), and more.

Group by

This section is where you can create a dimension of the data with a column. The selected data is calculated by the categories in the column.

ex) If you add an address column to group by section when calculating transaction volume, the transaction volume of each address will be displayed.

3) Get the aggregated result

Multiple Query blocks

You can add a new block to the query window if you want to compare data in multiple tables. For example, suppose you want to compare the number of transactions between Ethereum and Bitcoin. In that case, you can add two query blocks, one containing Ethereum data and the other containing Bitcoin data, and compare them.

The added two or more blocks are automatically compared on the time axis based on the time unit set.

The relationship function is used to combine two query blocks based on criteria other than time.

Edit Result

Click Edit Result to carry out arithmetic operations on result tables of 2 query blocks. A new column will be added to the table to allow you to do more than a comparison.

4) Add visualizations

Expand your data using various visualization tools such as combination charts, pie charts, pivot tables, and more.

The options and specifications are customizable to fit your specific needs. Once the charts are created, you can add them to your dashboard for sharing with others.

---

SQL Mode For Developers

CryptoQuant also offers SQL mode for developers and individuals who are more comfortable using SQL. The syntax is based on BigQuery and additional information can be found in the relevant documentation.