Calculating New Visitors for the whole website vs. specific page using adobe datafeed? | Community
Skip to main content
M
MrigayaSi
March 12, 2020
Solved

Calculating New Visitors for the whole website vs. specific page using adobe datafeed?

  • March 12, 2020
  • 2 replies
  • 3772 views

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.

 

@gigazelle @mihnead @andrew_wathen_ @urs_boller @michaelwon @jarnorossilux2 @sessoms25 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ForgotPassword4Times

This rough approach uses dplyr in R, but could be adapted for a different tool:

 

group_by(userID, post_pagename) %>%

filter(!is.na(post_pagename) %>%
arrange(hit_time_gmt) %>%
mutate(pageViewNum = 1,
pageViewNum = cumsum(pageViewNum),
firstVisitToPage = ifelse(pageViewNum == 1, 1, 0)) %>%
ungroup()

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.

2 replies

F
ForgotPassword4TimesAccepted solution
Level 4
March 25, 2020

This rough approach uses dplyr in R, but could be adapted for a different tool:

 

group_by(userID, post_pagename) %>%

filter(!is.na(post_pagename) %>%
arrange(hit_time_gmt) %>%
mutate(pageViewNum = 1,
pageViewNum = cumsum(pageViewNum),
firstVisitToPage = ifelse(pageViewNum == 1, 1, 0)) %>%
ungroup()

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.

Urs_Boller
Community Advisor
Urs_BollerCommunity Advisor
Community Advisor
April 6, 2020

If you beed just a number. you could try the following: calculate the "new visitors" based on "unique visitors since xx month" minus "unique visitors since xx month but not the month in question".

 

example: if you define "new visitor as someone who hasn't been on a single site since 12 month", you would calculate the new visitors for last month with

a) UV in the last 13 month (12 + 1 month)

b) UV in the ladt 13 month but not last month

the difference is the amount of UV in the desired month

 

remark: you can get the numbers by following this steps:

1) create the rolling date ranges

2) create segments for each of the date ranges

3 create the calculate metric using the segments

 

side note: this solution only gives you a number, not really a segment to work with. I haven't found an easy solution to create a similar segment just using the default analytic dimensions...

Terms & ConditionsAccessibility statement

Loading footer...