Why Transpose Data?
In some cases, transposing data is the best way to create a cleaner and more usable dataset. Suppose you have a dataset showing Facebook Ads Custom Conversions, organized by campaign and conversion type. However, the data is structured in rows, with a separate entry for each custom conversion within a campaign.
To view this data more effectively, you want to display each custom conversion as its own column, grouped by campaign.
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 in to TapClicks and, on the Data Menu, click Calculations.
2] The Calculations overview page appears. Here you can review existing calculations or create new ones.
3] Click the Add New Calculation button (plus icon) in the upper right corner to open the New Calculation screen.
4] Enter a name for the calculation in the Name textbox.
5] Select the appropriate Data Type, Data Category, and Data View for the dataset you want to transpose. For example, to transpose All Page Views, choose the data type Number from the Custom Conversions data view in the Facebook Ads category.
6] In the Calculation Builder, create the following calculation.
7] Repeat this calculation for each custom conversion you want to display as a column, such as chat_submit, downloads, and form_submit.
8] Once complete, view the widget output. You can filter for a single campaign to verify that each custom conversion appears in its own column.