Put historical blockchain activity beside an affiliate reporting period
Review a completed affiliate period with historical blockchain context and a clear note of any data needed to compare results.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Archive Database Query
Queries historical blockchain data from an archive database.
Why this helps
Looking back at commissions without the relevant chain history makes it harder to explain what happened during a reporting period.
- Query full historical blockchain data for retrospective analysis.
- Highlight missing dates, networks, or identifiers before drawing conclusions.
- Prepare a concise period review without reconstructing context manually.
Setup
Build it in a few focused steps.
- 1Connect Adtraction and Bitquery once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name the period review.
- 3In one instruction, request a summary of the chosen Adtraction period and relevant Bitquery archive activity, specifying that unavailable matching fields should be reported.
- 4Pick a recurring schedule and choose where run reports should go.
- 5Test with one real reporting period and confirm the date range and network.
Questions about this workflow
How current is archive data?
Archive data can be delayed by tens of minutes to hours, so it is intended for historical analysis rather than instant monitoring.
Will this prove that a commission came from a particular transfer?
No, unless the source data includes a reliable identifier or you supply a defensible matching rule. The summary should distinguish correlation from confirmed attribution.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Adtraction to Bitquery. A trigger fires from one place; an action lands in another.
Adtraction 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.
Adtraction 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.