Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Net products purchased

Avatar

Level 2

Suppose I'm trying to found out the  total number of products purchased on my website, (counting in the cart additions and subtracting the cart removals), would 'product' dimension be the one I go to?

Does Adobe do these calculations on backend ?

 

Currently, I'm using approximate count distinct function with products dimension and it gives me all products added to cart without excluded cart removals.

 

Any ideas?

1 Accepted Solution

Avatar

Correct answer by
Level 7

@prerna  To get the total number of products purchased I will suggest using the 'Orders' metric along with 'Product' dimension as it takes the values of product variable to calculate the 'units' sold. 

Check the below doc :-

https://experienceleague.adobe.com/docs/analytics/implementation/vars/page-vars/events/events-overvi...

https://experienceleague.adobe.com/docs/analytics/implementation/vars/page-vars/events/event-purchas...

View solution in original post

2 Replies

Avatar

Correct answer by
Level 7

@prerna  To get the total number of products purchased I will suggest using the 'Orders' metric along with 'Product' dimension as it takes the values of product variable to calculate the 'units' sold. 

Check the below doc :-

https://experienceleague.adobe.com/docs/analytics/implementation/vars/page-vars/events/events-overvi...

https://experienceleague.adobe.com/docs/analytics/implementation/vars/page-vars/events/event-purchas...

Avatar

Level 10

Do any of the answers provided answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?