0 Replies Latest reply: Jul 10, 2017 5:39 AM by Michael Däubler RSS

    Calculate funnel conversion rate

    Michael Däubler

      Hi all,

       

      I am trying to create a conversion rate funnel for an ecommerce page. To achieve that I count visitors who visited a page and divide the number by total visitors of the previous page.

       

       

      My formula with first page = LandingPage and second page = UserInput


      idvisit = visits/ visitors

      page = name of the page


      Logic: Visitors of UserInput who came from LandingPage divided by total visitors of LandingPage

       

      count(
      {$<idvisit = p({1<page={'LandingPage'}>}),
      page={'UserInput'}>} distinct(idvisit)
      )
      /
      count(
      {$<page={'LandingPage'}>} distinct(idvisit)
      )
      
      
      

       

      Could somebody tell me if my formula is correct?

       

      Any help is much appreciated!