1 Reply Latest reply: Jan 17, 2013 2:26 AM by Dai-Phuc Ha RSS

    revenue distribution

      hi everybody,

       

      how can I distribute a revenue to previous contacts?

       

      Table with tagging already exists:

       

      SessionCountryChannelContactBuyOrderIDRevenueTaggingResult for Channel 'C1' : Revenue after distribution
      123ACAA11---F
      123ACAB12---X
      123ACAA13---X
      123ACAC14---Y20€
      123ACAC151121212100€L20€
      123ACAS16---X
      456BCAC11---F120€
      456BCAA12---X
      456BCAB13---Y
      456BCAC141121213200€L40€
      456BCAS15---X

       

      Tags description:

      F = FirstContact
      Y = LastContactBeforeBuy

      L = LastContact

       

      What I wanna do is:
      How I can distribute the revenue made by session '123A' and '456B' to channel C1 percentage to the FirstContact, LastContactBeforeBuy and LastContact.

      E.g.: Distribution only for channel 'C1':
              FirstContact 60%, LastContactBeforeBuy 20%, LastContact 20%

       

       

       

      I have try this but is not working:

       

      if(Tagging = 'F', sum(Revenue)*0.6,

      if(Tagging = 'Y', sum(Revenue)*0.2,

      if(Tagging = 'L', sum(Revenue)*0.2)))

       

      I think the problem is that I dont have any revenue in 'FirstContact' and 'LastContactBeforeBuy'.

      How I can move the revenue for calculation?

       

       

      PLEASE HELP & THX in Advance!

        • Re: revenue distribution

          My table with result (last column) I need:

           

           

          SessionCountryChannelContactBuyOrderIDRevenueTaggingResult for Channel 'C1' : Revenue after distribution
          123ACAA11---F
          123ACAB12---X
          123ACAA13---X
          123ACAC14---Y20€
          123ACAC151121212100€L20€
          123ACAS16---X
          456BCAC11---F120€
          456BCAA12---X
          456BCAB13---Y
          456BCAC141121213200€L40€
          456BCAS15---X