Skip to content
Notis

Walk Into Campaign Reviews with the Data Brief Ready

Request a focused campaign data brief before a meeting and spend less time assembling context at the last minute.

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

Meeting prep gets squeezed between other work, leaving founders to search for campaign context right before the discussion.

  • Prepare a focused brief when a meeting is coming up.
  • Keep metrics and context together in one report.
  • Identify unanswered questions before the discussion starts.

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 use the request context to query specified campaign metrics and prepare a short briefing with unanswered questions.
  • 4Pick the Notis webhook as the trigger and choose where run reports should go.
  • 5Test with one real campaign briefing request and confirm the summary is ready to share.

Questions about this workflow

Does this automatically know the meeting agenda?

Only if the request or prompt provides the agenda context. The workflow should query the campaign data relevant to the supplied topics.

Can the report include comparisons?

Yes, when the query can retrieve the necessary periods and the comparison is specified. Missing history should be called out.

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.

TriggerScheduled

Execute ClickHouse Query

Runs a database query and returns the results.

ActionInstant

Webhook trigger

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

TriggerInstant

Get Database Schema

Retrieves an overview of a database's schema and tables.

ActionInstant

Get Table Schema

Gets the schema and column details for a table.

ActionInstant

Get ClickHouse Play Interface

Returns the ClickHouse Play interface for writing queries and viewing results.

ActionInstant

List ClickHouse Databases

Lists the databases in an instance.

ActionInstant

List ClickHouse Tables

Lists tables in databases with basic details.

ActionInstant

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.