@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.