Compare token transfer totals with affiliate commission reporting
Get a clear transfer total for a defined chain and period, with commission context and data limits stated in the report.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Sum Metric
Why this helps
Total token movement and affiliate commissions are reported separately, leaving founders to compare them by hand.
- Calculate the sum of a specified field across query dimensions.
- Keep the chain and period explicit in the report.
- Call out when commission data cannot be reliably linked to transfers.
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 transfer review.
- 3In one instruction, ask for the specified token transfer sum and a comparison with relevant Adtraction commissions where a supported link exists.
- 4Pick a recurring schedule and choose where run reports should go.
- 5Test with one real example and verify the field, network, and period.
Questions about this workflow
Can the sum be compared directly with commission totals?
Only if the units, time period, and attribution relationship are compatible. Otherwise, the report should show the figures separately and explain the gap.
What does the sum metric calculate?
It totals a specified field across the dimensions in the query.
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.