Use Case: Track Ad Campaign Performance with Conduit

Identifying and Evaluating Low-Performing Campaigns

In this use case, we have a dataset that comprises lists of advertising campaigns and their daily metrics like marketing spend.


Our goal is to identify and track Ad Campaigns with the lowest performance. Let’s have the AI reformat the sheet, to display days, as separate columns:


Now, our task is to filter the campaigns with 0 conversions in the three days in a row. Click 'Reply' to refine the dataset from Copilot's response and input this prompt
‘Filter the campaigns that have 0 conversions for not less than 3 days’

Automation capabilities

Now, we aim to optimize this process, enabling AI to automatically check the dataset of interest and notify us about low-performing campaigns via Slack. To achieve this, we would need to create a new Workflow on the corresponding tab:



Drag the 'Ask AI about the dataset' block.
Input the name of the dataset of interest from the Copilot tab.
Drag the 'Create Report / Aggregate' block and choose the source dataset.
Conclude the workflow with either the 'Send CSV to Slack' or 'Send CSV to Email' block.

There you have it – a fully equipped workflow at your fingertips!

Updated on: 08/03/2024