In a single visit, How do I know if users are buying the product which they added to Cart?

[rsane1]

I am trying to understand if we have any velocity products.

I want to know if the users do the following in a single visit:

Visit the Product page, Add product to Cart and then Purchase the same product.

I do NOT want this for 1 particular product. That is possible using a simple segment where we use the "then" condition to add steps in addition to using the Product ID for mapping the product.

I need such a report for all the products available on the site. Can someone please chime in with the best approach?

[ezhil_raja]

Create a visit level segment with product view exists, cart additions exists and orders exists, and apply this segment to your product performance report. 

[rsane1]

I don't think this will work, as it will consider these 3 conditions without being specific to the Product.
If my understanding is correct, the Last Column in the following setup will show Orders for the particular product(in Row) when there was a "Product visit and Cart Add for any product during the visit" and NOT specific to the product seen in that row.

[Josh__Stephens]

I believe you could accomplish this with merchandising eVars bound to the product and expiring at the end of the visit.  Have one that's set with the product view and another with the cart add.  You could then report on each step with those merchandising eVars.  This would identify those orders placed during the same visit, or on subsequent visits.

In CJA, you can do this retroactively.  But in Analytics, I don't know of another way of doing this off hand.

[rsane1]

Thanks Josh.

The merch eVars approach is interesting, but I am unsure about how we would be able to use it for reporting.

What would the values in different merch eVars need to be so that we can tie it together? 

• If we use "Visit ID" as the merch eVar value, the solution won't be scalable
• If we use the "Date" as the merch eVar value, the solution won't be scalable
• If we use generic values, how could we certainly assert that the events are happening in the same visit?

[Josh__Stephens]

hi @rsane1 - good thought exercise.  You might need to play around with it, but thinking aloud, or should I say typing aloud...

Let's say a customer has a product view for a KC Chiefs Jersey..

  -You set eVar15 to "1", on the product view, bound to the productID, with a visit expiration

In the same visit, the customer adds that item to cart

  -You set eVar87 to "1", on the cart add, bounce to the productID, with a visit expiration

In the same visit, the customer makes a purchase that includes the jersey.

In your reporting, you'd have the cart add where eVar15 = 1 (which I believe would only happen when same product was viewed during the same visit)

You'd also have the purchase where eVar15 = 1 and eVar87 = 1 (which I believe would indicate both the prodView and the cartAdd for that product happened in the same visit)

In the above scenarios, if the cart add and the purchase happened in subsequent visits, I believe your reporting would show you this where the eVar isn't set to 1.

Definitely test it out and might need to play around with it a bit, but seems like it should (or might) work.  You could validate it with using the segment you mentioned above for with a couple of different products.

[rsane1]

Hi @Josh__Stephens Conceptually, I agree it should work. My concern is about feasibility.

The goal was to report on it using Adobe workspace. As there will be millions of values in these 2 eVars, it would make it near impossible to segment in workspace.

If we need to use clickstream data, we can do it even without these two eVars as we could use the visitID to figure out the various activities in a single visit.

[abhijithr]

hi @rsane1

option#1

WIthin your s.product string, have eVar10(visit expiry) copying the SKU, event11 on product view, e12 on AddToCart, and e13 on purchase. While standard metrics such as PV, ATC, Orders gives the intra-session counts for the same product, I hope event11,12,13 could give you counts bounded by same session as persistence expires at the end of the session.

Segment may not be helpful here as eVar10 would demand specific SKU, in that case the solu won't be scalable.

Am unsure if Adobe has this end of the session processing rules, if so you could have a rule to trigger eVar with SKU IF that SKU had all 3 std metrices ProductView, CartAddition, Order. That way your eVar would tell you the list of SKU viewed-purchased in the same session.

option#2

You could capture time diff between PV & Purchase(reset) into a merchandizing eVar within s.products, with session expiry.

Please share what solu worked finally. Thanks