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!
