Do you often copy/paste lists of addresses into your queries? Tags are for you. Tags can be specific and provable, e.g. "OpenSea user", or simply a tool to group addresses and clean up your code.
Your tags. Your rules.
How are tags different than labels?
Tags are more unstructured and free-form than labels. An address's tags can be provable and durable, or subjective and temporary. An address can have as many tags as desired.
In contrast labels serve as a "source of truth" for an address, and are used to label known addresses that are associated with a CEX, DEX, NFT project, liquidity pool, or other entity. An address can have only one label.
What do our tags look like?
Our tags use a 2-level hierarchy, just like our labels.
A high-level category describing the address' main function or ownership
(i.e. NFT Holder)
A sub-category of tag_type providing further detail
(e.g. Moonbird Holder)
Using tag_type you can pull all celebrities tagged by the Flipside community, or use tag_name to pull a specific celebrity.
Who created the tag. Use your Flipside username, shown in your Flipside profile URL, for tags you create.
The address of the contract or wallet the tag describes.
Tag name (sub-category)
Tag type (high-level category)
Date the tag first applies. For tags that are permanent, this might be the date the address had its first behavior that warrants its tag, or the addresses' first transaction (e.g. if the tag identifies a celebrity NFT address).
Date the tag no longer applies (for tags that are permanent or currently active, end_date can be NULL)
Timestamp for when the tag was inserted into our data.
How to add tags
There are 3 ways to add tags to our data!
1. Add a SQL statement to our GitHub
You can use a Flipside query to create a tag set that will run on a reoccurring basis. This is a very powerful and scalable way to create a dynamic tag set that can update regularly.
Please see our Github ------------------------------------------ for how to upload your tag set queries.
2. Add a DBT seed file to our GitHub
If you have a static list of addresses that need a tag, a DBT seed file is the best route. This is the most efficient method to tag a list of addresses that will not change and don't rely on a SQL query.
Please see our Github ------------------------------------------ for how to upload your own DBT seed files.
3. I know what I want but I don't know how to tag
Flipside has a very active community and extraordinarily helpful employees. Reach out to the community, or to @gto, in Discord and someone will help you set up your tags.
How to query tags
It's important to remember that a particular address can (and should) have multiple tags.
BE CAREFUL WHEN JOINING TO THE TAGS TABLE, SO YOU DON'T DUPLICATE ROWS.
Check back here for example analysis queries using tags.
----------- add queries when data is available -----------