See how many unique wallets are behind the activity
Separate broad participation from repeat activity with a scheduled count of distinct wallet addresses.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Count Distinct Metric
Why this helps
A large activity count does not tell you whether many wallets participated or a small number repeated actions.
- Counts unique values for a selected field.
- Helps distinguish participant breadth from record volume.
- Produces a recurring summary for campaign review.
Setup
Build it in a few focused steps.
- 1Connect ActiveCampaign and Bitquery once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name the unique wallet review.
- 3Tell Notis the network, activity query, and address field whose unique values should be counted.
- 4Pick a recurring schedule and choose where run reports should go.
- 5Test with one real query and confirm the distinct count reflects the intended wallet population.
Questions about this workflow
Is this count exact?
The count distinct metric is intended to aggregate unique values for a field. Define the field and query carefully for the population you want.
Can it compare with a target?
Yes, if you provide the target or baseline in your instruction. A missing baseline cannot be inferred from the query alone.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Active campaign to Bitquery. A trigger fires from one place; an action lands in another.
Active campaign 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.
Active campaign 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.