Turn Campaign Metrics into a Clear Stakeholder Update
Get a ready-to-review update from campaign data without manually collecting numbers and rewriting them for each audience.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Execute ClickHouse Query
Runs a database query and returns the results.
Why this helps
Stakeholder updates take time when campaign numbers must be gathered, checked, and translated into a concise narrative.
- Draft a concise update from queried metrics.
- Keep statements tied to returned data.
- Surface missing inputs before sharing the update.
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 requested campaign metrics and draft a concise stakeholder update using only supported results and stating data gaps.
- 4Pick the Notis webhook as the trigger and choose where run reports should go.
- 5Test with one real update request and review the figures against the query results.
Questions about this workflow
Can the update include context about goals or targets?
Yes, when you provide that context or it is available in queried data. The workflow should not invent targets or outcomes.
Is the update sent to stakeholders automatically?
The automation produces a run report in the channel you choose. The setup described here does not send a separate stakeholder message.
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.