This shows you the differences between two versions of the page.
— |
advanced_transformations:renaming_medium [2021/09/01 09:33] (current) windsor_ai created |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== How to rename medium or other columns ====== | ||
+ | |||
+ | |||
+ | Sometimes the medium column needs to be renamed because the revenue and the spend do not match. | ||
+ | Here we see an example for snapcht. | ||
+ | |||
+ | {{: | ||
+ | |||
+ | |||
+ | 1. For this we need to rename the column so we click " | ||
+ | |||
+ | {{: | ||
+ | |||
+ | 2. Then we click "Edit dataset" | ||
+ | {{: | ||
+ | |||
+ | 3. Then we click " | ||
+ | |||
+ | {{: | ||
+ | |||
+ | In this case we add the rule for snapchat: | ||
+ | |||
+ | < | ||
+ | |||
+ | So the whole Expressions looks like: | ||
+ | < | ||
+ | Case when (source=' | ||
+ | WHEN source=' | ||
+ | WHEN (medium=' | ||
+ | WHEN source=' | ||
+ | ELSE medium END | ||
+ | </ | ||
+ | |||
+ | 4. Then we save and re-run the query and make sure its not coming from cache and then we have spend and revenue for snapchat on the same row and a multi-touch attributed ROAS. | ||
+ | |||
+ | {{: | ||