Data Transformation allows you to create your very own custom metrics, which can be used inside your Whatagraph reports to make the metric names consistent. This article will take you through the setup process and explain every step of the way.
1. Navigate to the 'Transform data' space in the top navigational bar:
2. Select 'Create new metric' under the '+ Create new' button:
3. Set up the name for your dimension:
Display name - this is the name your custom dimension will be reflected with in the reporting environment when setting up your widgets;
Description - this can act as your internal reference to explain the purpose behind the metric rule.
4. Select the transformation level:
Channel level - this transformation level would make the custom metrics visible across all selected channels in your account. This is relevant for cases where you want to apply rules to update all sources related to specific channels at once (e.g. you create a rule which includes Google Ads & you have 15 Google Ads sources connected. You can use the rule in every single report containing any of the 15 sources);
Source level - this transformation level would make the custom metrics visible only for specific data sources. This is relevant where some of your clients have specific needs (e.g. I have 15 Google Ads accounts but selected just one. The dimension will not be available for the remaining 14 Google Ads sources).
5. Select the rule type:
Unify names - this rule type allows you to select multiple metrics from different sources or channels and give them a consistent unified name (e.g. the same dimension is called differently across different channels Device for Google Ads & Device Platform for Facebook Ads, so you can name both of them Device;
Condition - this rule type is greyed out at the moment, as the team is working to have it supported as well.
6. Create the rule:
You will have to specify the channels (or sources) that you want to select for creating your custom metrics on the left and indicate what metrics you wish to unify. So in this instance, Engaged sessions and Engaged users from two separate integrations will now be reflected as Unique Engagements, universally.
7. Apply it to widgets inside the reports
Once the rule is created, just add a new metric to any widgets that belong to GA4 or Facebook Page (or any other channels that you chose previously) widget setup like you normally would.
After clicking 'Add new' you will see Custom & Premade metric tabs. The custom tab will include all dimensions transformation rules set by anyone on your team, and pre-made will include the ones already prepared by Whatagraph.
If you have any questions or feedback about Data Transformation, please get in touch with our customer support via live chat or email@example.com