Deduplicated visits for a classification field in Adobe Analytics | Community
Skip to main content
K
KASSIANI
January 19, 2022
Solved

Deduplicated visits for a classification field in Adobe Analytics

  • January 19, 2022
  • 1 reply
  • 1613 views

Hi,

 

Is there any way to calculate deduplicated visits using a classification field as the dimension?

 

For example, I want to get the total deduplicated Visits for the Product1 (classification field):

 

Dimension Product SKU -> Classification Product Model

 

Product1/A  5 Visits -> Product1

Product1/B  7 Visits -> Product1

Both Product1/A and Product/B in 4 Visits of 12 -> Product1

 

How can I get the deduplicated total (8 instead of 12 Visits) for the classified value Product1?

 

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 Jackie_DiStasi

Hi @kassiani , 

 

Not entirely sure I am following the question, but the gray "Totals" row for a Classification dimension in Workspace should show the deduped visit total of the attributes contained within. 

 

If you want to go the segment route as @pratheeparunraj suggested, you may be able to try one of the following:

  • Use the "exists" operator if you need the full list of classified values to be deduped

 

  • Use the "equals any of" operator (shown below).  You will need to separate your values with a comma, you can paste the full list into a column in Excel and concatenate with a comma to create the list easily.  I believe you can enter up to 500, so you would only need to do this two to three times if your list is ~1k

 

Hope that helps!

1 reply

PratheepArunRaj
Community Advisor and Adobe Champion
PratheepArunRajCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
January 20, 2022

Dear KASSIANI,

Create a segment with Product A OR Product B, you should be getting only 8 visits.

The important advantage of using segmentation is to de-duplicate the visits and visitors. To understand more, you can also check out my blog.

Thank You, Pratheep Arun Raj B (Arun) | NextRow Digital | Terryn Winter Analytics

Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
J
Jackie_DiStasiAccepted solution
Level 2
January 20, 2022

Hi @kassiani , 

 

Not entirely sure I am following the question, but the gray "Totals" row for a Classification dimension in Workspace should show the deduped visit total of the attributes contained within. 

 

If you want to go the segment route as @pratheeparunraj suggested, you may be able to try one of the following:

  • Use the "exists" operator if you need the full list of classified values to be deduped

 

  • Use the "equals any of" operator (shown below).  You will need to separate your values with a comma, you can paste the full list into a column in Excel and concatenate with a comma to create the list easily.  I believe you can enter up to 500, so you would only need to do this two to three times if your list is ~1k

 

Hope that helps!

Terms & ConditionsAccessibility statement

Loading footer...