How to calculate Average order value of cart left behind and frequency a customer comes back and buys after abandoning cart | Community
Skip to main content
Level 5
June 6, 2022
Solved

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

  • June 6, 2022
  • 1 reply
  • 1495 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by yuhuisg

@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-sequential-build.html?lang=en#visitor-sequence-across-visits might help you get started too.

1 reply

yuhuisg
Community Advisor
yuhuisgCommunity AdvisorAccepted solution
Community Advisor
June 7, 2022

@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-sequential-build.html?lang=en#visitor-sequence-across-visits might help you get started too.