All Collections
Analytics User Guide
1. Overview of the Analytics
1. Overview of the Analytics

How to use the web3 analytics tool

S
Written by Saehyun Yoo
Updated over a week ago

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

  1. 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.

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

2) Add Query blocks

  1. Metric

    1. 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.

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

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

  2. Where

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

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

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

  3. Group by

    1. 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.

    2. 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

  1. Multiple Query blocks

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

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

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

  2. Edit Result

    1. 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

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

  2. 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.

Did this answer your question?