Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.
SOLVED

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

Avatar

Level 5

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.

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.