Estimate unique participants in a wallet activity dataset
Get a compact estimate of unique values in a defined activity set when an approximate count suits the research question.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Uniq Metric
Why this helps
Large activity datasets can take time to summarize, and an estimated unique count is easier to review than a long list.
- Use the uniq metric for an estimated unique count where appropriate.
- Keep the counted field and query scope visible.
- Avoid manual counting of a large activity result.
Setup
Build it in a few focused steps.
- 1Connect Aeroleads and Bitquery once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it.
- 3In one instruction, ask Notis to estimate unique values for a named field in the supplied wallet activity dataset, with chain and period stated.
- 4Choose a Notis cron schedule, then choose where run reports go.
- 5Test against a dataset where an approximate count is useful and clearly label the result as an estimate.
Questions about this workflow
Is uniq an exact count?
The uniq metric is used to estimate the count of unique values; the report should label it as an estimate.
When should I use count distinct instead?
Use count distinct when you need to count unique occurrences rather than use the uniq estimate.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Aeroleads to Bitquery. A trigger fires from one place; an action lands in another.
Aeroleads triggers
Bitquery actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Archive Database Query
Queries historical blockchain data from an archive database.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Combined Database Query
Queries real-time and historical blockchain data across supported networks.
Conditional Metrics Snippet
Generates a metric snippet with conditional logic.
Database Selection
Selects the database for a GraphQL request.
Early Access Program Query
Queries real-time blockchain data through an early access program.
Network Selection
Selects the blockchain network for a query.
Options Query
Retrieves available GraphQL dataset options.
Price Asymmetry Metric
Generates a PriceAsymmetry filter snippet for GraphQL queries.
Connect any two apps with Notis in the middle.
Aeroleads and Bitquery, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Bitquery.