Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Workspace: Cumulative De-Duped Function

Avatar

Avatar
Boost 5
Level 2
anne_saylor
Level 2

Likes

13 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 2
anne_saylor
Level 2

Likes

13 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
View profile
anne_saylor
Level 2

08-03-2019

Currently within Analysis Workspace, there is the ability to use the "cumulative" function to get a running total of a metric, such as unique visitors, over a period of time and divide within that period of time, such as by month. However, this does not take into account that several of those visitors are the same visitors, returning from one month to the next.

Request is to have an option to deduplicate the grouped results over time so that it would be possible to have a running total of values that takes into account de-duplicated data, so that rather than adding up to the individual totals from each month, the total across the time period with this metric would potentially be less than the total by month.

Example:

Month
Unique Visitors (Base Metric)Unique Visitors (Cumulative function as it exists today)Unique Visitors (Cumulative Distinct proposed metric across entire time period)
Jan 2019100100100
Feb 2019150250230 (20 of these visitors overlap with ones we've already recognized from the January row)
Mar 2019200450400 (30 of the March visitors have previously been recognized from previous months)

There is currently no easy/direct way to produce this sort of reporting, and it would go a long way toward seeing true over-time accumulation of visitors (or other items viewed in a similar manner.)

2 Comments

Avatar

Avatar
Level 1
Helene_D
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
Helene_D
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
Helene_D
Level 1

03-03-2020

Hi Anne, I found this solution as I had the same question as you: https://experienceleaguecommunities.adobe.com/t5/Adobe-Analytics-Questions/Excluding-returning-visit...

 

I know your post is from last year, but just in case it can still help!

Avatar

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

355 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

355 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Level 10

27-10-2020

 
Status changed to: Archived