Why Transpose Data?
In some cases, transposing data can be the best way to create a clean data set. Imagine you have a dataset displaying Facebook Ads Custom Conversions data, organized by campaign and custom conversion. However, the information is currently structured in rows, with separate entries for each custom conversion within a campaign (see example below).
Now, you want to present the data differently. Instead of having separate rows for each custom conversion, you want to display custom conversions as their own columns while grouping the information by campaign (see example below).
To achieve this, you'll perform two advanced calculations to create new conditional metrics. These metrics will serve as columns representing specific custom conversions. After that, you'll construct a widget that groups the data solely by the campaign.
How to Transpose Data
1] Log into TapClicks and on the Data Menu, click Calculations.
2] You are taken to the Calculations overview page. Here is where you can review all previously created calculations and create new calculations.
3] To create a new calculation, click the Add New Calculation (i.e., plus sign) icon in the upper right corner. The New Calculation screen opens.
4] Enter a name for the calculation in the Name textbox.
5] Select a data type, data category, and data view from their respective dropdown menus. These should be the ones appropriate for the specific data you want to transpose. For the example above, you are transposing All Page Views which has the data type Number and comes from the data view Custom Conversions in the Facebook Ads data category.
6] In the Calculation Builder, create the following calculation.
7] Repeat the calculation for each data category you want to transpose. For the example above, repeat for Custom Conversions = chat_submit, downloads and form_submit.
8] View sample output (example below when filtering for campaign one only).