What is Data Transformation?

This article explains exactly what data transformation means and how it can help your agency or business

Laurynas Arminas avatar
Written by Laurynas Arminas
Updated over a week ago

We are excited to announce that Whatagraph released a new function in beta that you might be interested in. There are many different terms to describe it, such as unifying, aggregating, formatting, and cleaning the data, as well as many others. But we chose to call it Data Transformation.

Simply speaking, it should help you organize data inside the reports in a way that is easy to digest for your teammates and the end reader. Here are a few examples of tasks that Data Transformation can help you with:

  • Bringing order to cross-channel data;

  • Making the reports easier to read;

  • Grouping data in a way that makes sense.

To be precise, we can even look into some real problems that can be easily solved via Transformation.

  1. Dimension names are different for each integration, confusing the end reader of the report;

  2. Campaign names use confusing abbreviations that are not reader-friendly;

  3. Different integrations do not return the exact same names for specific countries;

  4. Being unable to group campaign results by specific keywords or campaigns;

  5. Being unable to segment countries into specific target groups or tiers;

  6. The API output in tables sometimes gives back values like [not set] or [unknown], which need to be changed for the reader to be understood;

  7. Metric names are different across various integrations, so remembering what each client considers as a conversion can be tricky;

  8. And many more...

You will find the 'Transform data' button on the top navigation bar:

You can find a full video walkthrough on how this new part of Whatagraph can benefit you or your business:

If you have any questions or need additional help, please get in touch with our customer support via live chat or hi@whatagraph.com

Did this answer your question?