Catch Campaign Spend Values That Need a Closer Look
Turn a daily spend query into a short exception report, using thresholds or comparison rules your team supplies.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Execute ClickHouse Query
Runs a database query and returns the results.
Why this helps
A founder can miss a spend issue between manual checks, while a full dashboard review adds another recurring task.
- Review spend exceptions without scanning every campaign manually.
- Apply a threshold or baseline defined by your team.
- Get a compact report focused on unusual returned values.
Setup
Build it in a few focused steps.
- 1Connect Adyntel and ClickHouse once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis the outcome in plain language from any channel.
- 3Ask Notis to query campaign spend and flag values against a threshold or baseline that you provide, stating when comparison data is missing.
- 4Pick a daily recurring schedule as the trigger and choose where run reports should go.
- 5Test with one real example and confirm the threshold and query results behave as intended.
Questions about this workflow
Can Notis decide what counts as unusual by itself?
The workflow needs a threshold or comparison rule from you, or enough historical data and an explicit rule in the prompt. It should identify when a required baseline is missing.
Does this pause or change campaigns?
No. The selected action runs a ClickHouse query and returns results for a report.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Adyntel to ClickHouse. A trigger fires from one place; an action lands in another.
Adyntel triggers
ClickHouse actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Execute ClickHouse Query
Runs a database query and returns the results.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Database Schema
Retrieves an overview of a database's schema and tables.
Get Table Schema
Gets the schema and column details for a table.
Get ClickHouse Play Interface
Returns the ClickHouse Play interface for writing queries and viewing results.
List ClickHouse Databases
Lists the databases in an instance.
List ClickHouse Tables
Lists tables in databases with basic details.
Connect any two apps with Notis in the middle.
Adyntel and ClickHouse, 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 ClickHouse.