I am trying to calculate New Visitors for the whole website as well as a particular page, I was thinking of using the below logic:
Visit_num = 1 (New Visitor)
Visit_num > 1 (Repear Visitor)
But this will give me new vs. repeat for the whole website; is there a way to calculate the same for a particular page on the website, I was thinking of using Visit_page_num; but not sure if that logic would work.
Would appreciate any guidance around calculating New vs. Repeat directly from data warehouse in Adobe.
Group by userID and page name Remove rows without a post_pagename value (to get page views only) Order by hit time Set a dummy value of 1 for each instance of a page name. Then over-write that value with the cumulative value (the first time a user sees the page 1, second time 2, etc) Create a column that says if this is the first time a user has viewed the page 1, otherwise 0.