Before you begin: The Field Share Breakdowns 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 Field Share Breakdowns Transformation allows you to calculate the proportional share of a metric within a grouped field. This is useful for identifying how much each item (e.g., campaign, ad set, creative) contributes to a total, enabling a more detailed understanding of relative performance across dimensions.
How to Use the Field Share Breakdowns Transformation
1] Log in to TapClicks and, on the Data Menu, click Transformation Hub.
2] From the list of available transformations, click Field Share Breakdowns.
3] The Field Share Breakdown 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] Enter a value in the Decimal Precision field to control rounding. A value of 1 displays one decimal place (e.g., 0.1), while a value of 5 displays five decimal places (e.g., 0.00001).
7] Complete the Calculation Builder fields.
- Replace the first placeholder with the field containing the metric you want to calculate share for.
- Replace the second placeholder with the same metric field used for the total.
- Replace "total" with the dimension used to group the values.
Example:
Cost / SUM(Cost, "Campaign Name") * 100
8] When finished, click Save at the bottom of the page.