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

How to calculate Average order value of cart left behind and frequency a customer comes back and buys after abandoning cart

Avatar

Level 6

How to calculate Average order value of cart left behind and frequency a customer comes back and buys after abandoning cart in adobe analytics?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@aagk123 wrote:

How to calculate Average order value of cart left behind


First, you need to track the cart value to a Success Event of "Currency" type. How you set this is up to you. For example, you could set it whenever you set the "scView" event. On the other hand, remember that a user can view his shopping cart more than once before finally purchasing, so you could end up tracking duplicate cart values in that new Success Event.

Once you have this Success Event setup and tracking values, you can then create a Calculated Metric to calculate this average cart value, in combination with a Segment that excludes visitors or visits that have purchases.


@aagk123 wrote:

frequency a customer comes back and buys after abandoning cart in adobe analytics?


A Sequential Segment could help here, for example, something like this:

Visitor-scoped

  • Visit-scoped
    • Visits exists
    • AND
    • Purchase does not exist
  • THEN
  • Visit-scoped
    • Visits exists
    • AND
    • Purchase exists

The example at https://experienceleague.adobe.com/docs/analytics/components/segmentation/segmentation-workflow/seg-... might help you get started too.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

@aagk123 wrote:

How to calculate Average order value of cart left behind


First, you need to track the cart value to a Success Event of "Currency" type. How you set this is up to you. For example, you could set it whenever you set the "scView" event. On the other hand, remember that a user can view his shopping cart more than once before finally purchasing, so you could end up tracking duplicate cart values in that new Success Event.

Once you have this Success Event setup and tracking values, you can then create a Calculated Metric to calculate this average cart value, in combination with a Segment that excludes visitors or visits that have purchases.


@aagk123 wrote:

frequency a customer comes back and buys after abandoning cart in adobe analytics?


A Sequential Segment could help here, for example, something like this:

Visitor-scoped

  • Visit-scoped
    • Visits exists
    • AND
    • Purchase does not exist
  • THEN
  • Visit-scoped
    • Visits exists
    • AND
    • Purchase exists

The example at https://experienceleague.adobe.com/docs/analytics/components/segmentation/segmentation-workflow/seg-... might help you get started too.