8 Replies Latest reply on Apr 5, 2017 11:05 AM by Yuriy Fal

    Apply first value to all entries of a user (First click attribution)

    Albrecht Kühn

      Hallo,

       

      I have a question regarding tableau. I'm working on a report for controlling of online campaigns.

       

      Currently we use a so called last-click attribution. Which means: The conversion is assigned to the campaign of the same session, e.g. the clientiD = 1 did a conversion (= /success) on 25.01.17 --> The conversion is assigned to the campaign "social". Now we would like to change the attribution model to the first click. Which means that the conversion is assigned to the campaign of the first visit of the client to our website.

       

      To do so I want to add an extra column (1stCampaign) where I put in the campaign of the first visit of the user.

      I could do so with the VisitDate {fixed ClientID: MIN(VisitDate)} - but I don't know how to get the campaign title in all rows of the user.

       

              

      ClientIDVisitDatePagePathCampaign1stCampaign
      123.01.17/displaydisplay
      124.01.17/angebotedirectdisplay
      125.01.17/successsocialdisplay
      201.01.17/crmcrm
      202.01.17/sogehtscrmcrm
      208.01.17/successsocialcrm

       

       

       

      Thank you for your help!

      Albrecht