AI, MarTech

Transformations Copilot and Data Conversations – AI-powered features in Adverity.


Transformations Copilot

Making data transformations more accessible

Challenge

Data Transformations are a critical part of the ETL process and are used by a broad spectrum of users, from Python-savvy experts to absolute newcomers.

UX research showed that Transformations were the third most complex area of Adverity. The complexity was particularly challenging for less technical users, partly because some transformations required knowledge of regular expressions (regex).

Users frequently relied on extensive documentation or Adverity Support to complete transformation tasks.

Reducing support dependency was also strategically important, as reducing support tickets was a top-level OKR linked to improving ROI.

Evolution

2024 — Copilot v1
A conversational assistant that helped users understand and configure transformations by providing answers and guidance.

2025 — Integrated Copilot
The assistant evolved from an information tool into an actionable part of the interface: users could directly copy and paste the generated instructions into the Transformation UI.

 


Data Conversations

Making complex data analysis more accessible

Challenge

CMOs and digital marketing leaders often need to answer complex questions about their marketing data, but getting those answers can require help from data experts.

Examples include:

“Compare the CTR of all my advertising channels over the last six months and create a bar chart.”

The challenge was to make this type of analysis accessible without requiring users to understand the underlying data structure or rely on a data expert.

Evolution

2025 — Embedded in Adverity
We introduced a conversational interface with access to the data context already loaded into Adverity, allowing users to ask questions and generate insights directly.

2026 — Integrated into Dashboards
The experience was moved into the Dashboards module, bringing the conversational capability directly into the context of existing dashboards and data explorations.

This made AI assistance more contextual: users could ask questions about the data while already looking at it.
 

Main Achievements

Approx −43% support tickets: Transformation-related tickets reduced in 3 months.

40% Copilot adoption of users landing in Transformations used Copilot.

Positive user sentiment emerged from qualitative interviews.

Project Info
Client

Adverity GmbH

Date

2023-2026

Role

VP Experience