Skip to content
Notis

Turn LinkedIn Ad Data into a Weekly Performance Review

Get a clear weekly read on the LinkedIn ad data you already store in ClickHouse, with the key results and changes summarized for you.

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

Ad performance data is spread across queries and dashboards, making it easy to miss a change until someone remembers to check.

  • See key performance results on a regular schedule.
  • Reduce manual query and report preparation.
  • Get a concise summary in your chosen report channel.

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 your ClickHouse LinkedIn ad performance data and summarize the results and notable changes.
  • 4Pick a recurring schedule as the trigger and choose where run reports should go.
  • 5Test with one real example and confirm the query returns the intended data.

Questions about this workflow

Does this workflow fetch ads from LinkedIn automatically?

It queries data available in ClickHouse. Use Adyntel to fetch LinkedIn ad data into your connected workflow or data store; the query can only report on data that is available to it.

Can Notis identify changes from the prior week?

It can compare periods when the queried data includes dates and both periods. If the required history is missing, the comparison cannot be made.

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.