Before you begin: The Data Cleaning Transformation is part of the Transformation Hub. If you do not see the Transformation Hub under the Data menu, please contact your TapClicks Account Manager to have it enabled. For more information about the Transformation Hub in general, please refer to Transformation Hub Overview.
Overview
The Data Cleaning Transformation allows you to clean up inconsistent or messy text data by applying standard naming conventions. This transformation is useful for replacing variations, correcting typos, or grouping similar values under a single user-friendly label.
How to Use the Data Cleaning Transformation
1] Log in to TapClicks and, on the Data Menu, click Transformation Hub.
2] From the list of available transformations, click Data Cleaning.
3] The Data Cleaning calculation workspace will open.
4] Enter a name for this calculation in the Name textbox.
5] Use the dropdown menus to select a Data Category and View.
6] Complete the fields in the Calculation Builder.
- Replace placeholder with the field you want to clean or standardize.
- In each WHEN line, replace the first quoted value with a known messy or inconsistent value, and the second quoted value with the clean, standardized version.
- Use ELSE to assign a default value to all remaining entries that don’t match the specified conditions.
Example:
CASE Campaign Name WHEN CONTAINS "FB - Campaign" THEN "Facebook" WHEN CONTAINS "IG_AdSet" THEN "Instagram" ELSE "Other" END
7] When finished, click Save at the bottom of the page.