Expand my Community achievements bar.

SOLVED

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

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

@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

@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