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 Convention:
Standardize campaign, ad group, or advertiser names across multiple platforms for consistent and clean reporting. -
Campaign Names:
Classify campaign names into standardized categories based on keyword matching, replacing inconsistent raw values with clean, reportable labels. -
Creative Sizes:
Normalize creative size values reported in different formats across platforms into a single, consistent label. -
Device Types:
Standardize device type values reported differently across platforms into one consistent set of categories. -
Field Share Breakdowns:
Calculate the percentage distribution of any metric across selected dimensions to highlight performance contribution by category. -
Data Cleaning:
Fix formatting issues and unify inconsistent field values to ensure data is accurate and easy to use. -
Data Segmentations:
- Group data logically, by region, brand, product, or your own custom criteria, to surface deeper insights.
-
Budget Pacing Setup:
Build the foundational calculation set used to monitor how a campaign is spending against its total budget across its flight. -
Budget Pacing Tracker:
- Track expected spend against actual spend across campaign timelines, helping you monitor performance in real time.
-
Monthly Budget Pacing:
Build the calculations needed to monitor campaign spend pacing within the current calendar month. -
Attribution:
- Measure the true performance of your marketing activities across campaigns and channels using actual data, not modeled assumptions.
Transformation Features
These tools are available directly in the Transformation Hub and offer flexibility to build and manage your own logic:
-
SmartCampaigns™:
- Group and manage campaigns across multiple data sources into a single, unified view for streamlined reporting and performance tracking. For more information, see SmartCampaigns™ Overview.
-
Margin Rules:
- Apply custom margin logic to calculate profitability and track performance across your data sources. For more information, see How to Use Margin and Markup Rules.
-
Data Lookups:
- Map and replace field values across your data sources to standardize inputs and ensure consistency throughout your reports and dashboards. For more information, see How to Use Data Lookups to Enrich Your Data Set.
-
Channels:
- Categorize and organize your campaigns into unified channel groupings for cross-platform insights. For more information, 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, 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 opens, displaying pre-built data transformations at the top of the page. You can select one of these pre-built transformations or build your own using the features listed below them.