Skip to content
Notis

Review creative campaign performance with ClickHouse

Turn a creative launch into a focused performance check, with the results summarized where your team can act on them.

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

Creative launches create follow-up work, and checking campaign data by hand makes it easy to miss a result that needs attention.

  • Summarize launch results without switching tools to run a query.
  • Keep the analysis tied to campaign context included in the webhook request.
  • Surface missing campaign identifiers or metrics before drawing conclusions.

Setup

Build it in a few focused steps.

  • 1Connect Abyssale and ClickHouse once in the Notis portal.
  • 2Create an automation in Automations, New Automation, and give it a name.
  • 3Tell Notis to query ClickHouse for the campaign metrics named in each request and summarize results, noting any missing identifiers or baselines.
  • 4Pick the webhook trigger and choose where run reports should go.
  • 5Test with one real campaign request and confirm the query uses the supplied campaign details.

Questions about this workflow

Does Abyssale provide the trigger for this workflow?

Abyssale has no listed trigger events here. A Notis webhook starts the automation when an HTTP request is sent with the campaign context.

Can the workflow know which campaign to query?

The webhook request needs to include enough identifying context, such as a campaign name or identifier and the relevant ClickHouse tables or query scope.

Will it claim a campaign improved without a baseline?

No. If a comparison period or baseline is not supplied or available in ClickHouse, the summary should say that comparison is missing.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

Notis builds workflows that link Abyssale to ClickHouse. A trigger fires from one place; an action lands in another.

Abyssale 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.

Abyssale 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.