Making data transformations more accessible
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.
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.
Making complex data analysis more accessible
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.
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.
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.
Adverity GmbH
2023-2026
VP Experience