I have the following requirement. I have a query result that is in this format:
|Month Number||Landing Page URL||Transactions||Page Type||Revenue||Conversion Rate|
I want another column / field in there that assigned a certain Page Type based on the Landing Page URL. For example, if the Landing Page URL is / then the Page Type should be set to “Home”, if the Landing Page URL begins with /cart then the Page Type should be set to “Cart”.
How can I achieve this?
Any help/guidance would be of great help.