Deduplicated visits for a classification field in Adobe Analytics

Question

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?

Jackie_DiStasi · Accepted Answer

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!

PratheepArunRaj · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO