Skip to content
Notis

Estimate unique addresses tied to new subscribers

Add a fast reach estimate to subscriber onboarding.

Trigger

Subscribe Trigger

Triggered when a subscriber subscribes to Mailchimp

Action

Uniq Metric

Tool to estimate the count of unique values using the uniq metric. use when you need approximate or exact unique counts for analytics on blockchain datasets.

Why this helps

Manual address deduplication delays simple onboarding analysis.

  • Reduce manual deduplication
  • Get a fast unique address estimate
  • Make onboarding analysis repeatable

Setup

Build it in a few focused steps.

  • 1Connect Mailchimp and Bitquery once in the Notis portal.
  • 2Create an automation named Subscriber unique address estimate.
  • 3Describe the address field, network, and dataset that Notis should analyze.
  • 4Pick the Mailchimp Subscribe Trigger and choose where run reports go.
  • 5Test with one real subscription event.

Questions about this workflow

Is uniq an exact count?

Bitquery uniq is intended to estimate unique values, so treat the result as an estimate unless your query specifies an exact method.

Can I use this for several networks?

Yes. State the networks and whether you want separate or combined results.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

Notis builds workflows that link Mailchimp to Bitquery. A trigger fires from one place; an action lands in another.

Mailchimp triggers

Bitquery actions

Recurring trigger

Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.

TriggerScheduled

Aliases Metric

Tool to use graphql aliases to rename fields in the response for clarity and disambiguation. use when you need to query multiple metrics with identical field names in one call.

ActionInstant

Webhook trigger

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

TriggerInstant

Archive Database Query

Tool to query the archive database. use when you need full historical blockchain data (delayed by tens of minutes to hours).

ActionInstant

Campaign Trigger

Triggered when a campaign is sent or experiences an event in Mailchimp

TriggerInstant

Combined Database Query

Tool to query the combined database, which merges archive and real-time databases. use when you need both historical and up-to-the-second blockchain data in one request.

ActionInstant

Profile Update Trigger

Triggered when a subscriber's profile is updated in Mailchimp

TriggerInstant

Conditional Metrics Snippet

Tool to generate a graphql metric snippet with conditional logic. use when you need to apply filters directly on metric calculations via the `if` attribute.

ActionInstant

Subscribe Trigger

Triggered when a subscriber subscribes to Mailchimp

TriggerInstant

Count Distinct Metric

Tool to use the count distinct metric to aggregate unique values for a field. use when you need to count the number of unique occurrences in a dataset.

ActionInstant

Unsubscribe Trigger

Triggered when a subscriber unsubscribes from Mailchimp

TriggerInstant

Count Metric

Tool to use the count metric to aggregate the number of records matching a graphql query. use when you need simple record counts.

ActionInstant

Database Selection

Tool to select the database (archive, realtime, combined) to query at the top level of a graphql request. use after determining whether you need live, historical, or combined blockchain data.

ActionInstant

Early Access Program Query

Tool to access streaming data across various blockchain networks for evaluation purposes. use when querying chains not available via the v2 endpoint; limited to real-time data only.

ActionInstant

Connect any two apps with Notis in the middle.

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