Net products purchased

[prerna]

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?

[amgup · Accepted solution]

@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...

[jantzen_b]

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?