2 Replies Latest reply on Jul 20, 2016 7:21 AM by faris meghani

    Parsing Text - Custom Calculation

    faris meghani

      Hello Everyone,

       

      I'm trying to see if anyone can help me with the calculation of parsing text. Here's what i'm trying to do:

       

      I would like to begin tracking our marketing at more granular level. To do this I need to create a new column with custom calculation in the data source that contains “Campaign Name”. I can call the new column “Campaign Category” or something along those lines. What I need to do is to find the following values within campaign name and replace entire record with following:

       

      Find this

      Replace with this

      SR

      Search

      RLSA

      Search Retargeting

      RLSAC

      Search Retargeting Custom Audience

      DIS

      Display

      RT

      Retargeting

      RH

      Rehash

      LA

      Lookalike Audience

      CA

      Custom Audience

      SU

      Sponsored Updates

       

      Here are a few examples of what campaign name might look like and what data “Campaign Category” needs to contain:

       

      Campaign Name

      Campaign Category

      arizona_bus_all_x_sr_gen

      Search

      asu_all_all_x_dis_gen

      Display

      asu_all_all_x_rlsa_gen

      Search Retargeting

      boisestate_all_all_x_rlsac_gen

      Search Retargeting Custom Audience

      boisestate_bus_mba_m_rt_gen

      Retargeting

      lamar_cj_all_x_su_gen

      Sponsored Updates

       

      Any help you can provide would be great! Thank you so much.