What is the Transformation Hub?
The Transformation Hub is a centralized workspace in TapClicks designed to streamline your data preparation process. It brings together powerful tools that help you clean, segment, standardize, and enhance your data to make it analysis-ready and reliable across your dashboards and reports.
Whether you're applying naming conventions, segmenting by logic, tracking budget pacing, or resolving data inconsistencies, the Transformation Hub simplifies and accelerates your workflow.
What Can You Do in the Transformation Hub?
Data Transformations
These are ready-to-use workflows built to solve common marketing data challenges:
-
Naming conventions:
Standardize campaign, ad group, or advertiser names across multiple platforms for consistent and clean reporting. -
Metric share breakdown:
Calculate the percentage distribution of any metric across selected dimensions to highlight performance contribution by category. -
Data cleanup:
Fix formatting issues and unify inconsistent field values to ensure data is accurate and easy to use. -
Data segmentation:
- Group data logically—by region, brand, product, or your own custom criteria—to surface deeper insights.
-
Budget pacing tracking:
Set up rules and calculations to monitor spend versus plan, helping you track performance in real time.
Transformation Features
These tools are available directly in the Transformation Hub and offer flexibility to build and manage your own logic:
-
Margin Rules:
Apply custom margin logic to calculate profitability and track performance across your data sources. For more information, please see How to Use Margin and Markup Rules. -
Channels:
Categorize and organize your campaigns into unified channel groupings for cross-platform insights. For more information, please see How to Create and Manage Channels. -
Calculations:
Create custom fields and formulas to add new KPIs, blended metrics, or apply business logic. For more information, please see How to Create Calculations, FAQs: Calculations, or Advanced Calculation Function Reference & FAQs.
How to Access the Transformation Hub
1] Log in to TapClicks and click Data. On the Data menu, click Transformation Hub.
2] The Transformation hub will open. Here, you can choose from one of our pre-built data transformations at the top of the page or build your own using the features listed at the bottom.