Workspace: Cumulative De-Duped Function

anne_saylor 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.)

1 Comment (1 New)
1 Comment
Helene_D 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!