Total amount in shopping carts

[petey2501]

Hello experts,

I was working on segmentation for my users in marketing, the example I got was that we need to segment al the abandoned shopping carts with the amount higher than 70 euros, so I tried to do it 2 ways;

Campaign

and

Campaign

in both cases, as you see, I used trigger based campaign and build live group in the segmentation, but i would get e-mail if I had more than 70 euros or if iI would have less than 70 euros- so that means that each time we have abandoned shopping Cart I get an e-mail, which is not good at all.

Please help me to get the right segmentation.

[petey2501]

We use on premise version of SAP MKT.

[SCHNEIDERT]

Hi Petar,

so, do you have the "Amount" in your "Abandoned Cart" interaction?

In my opinion you have to use the segmentation profile "All Interactions" to build your live target group instead of "All Consumers (B2C)".

BR Tobias

[petey2501]

Hello Tobias,

I have used Total amount, I have not amount in abandoned shopping cart, I have no option to choose All Interactions profile in test

but I tried in my Development environment but still do not have Amount in my abandoned cart interaction.

If you have that possibility could you put the picture so I can see how it would look like?

[SCHNEIDERT]

Hi petey2501,

sorry, think I did not communicate it correclty.

My question is if your "SHOP_CART_ABANDONED" interaction holds the amount of the products in the shopping cart. If so, in which field? Do you maybe have a sample interaction at hand?

Usually you have two data sources available for the Interactions Segmentation Object (SAP_CE_INTERACTIONS):

SAP_CE_PRODUCT_RELATED_IA_KF

SAP_CE_PRODUCT_IA_HEADER_KF

In both of them there's a AMOUNT or a TOTAL_AMOUNT field. Think you have to check which is the right one for you.

BR Tobias

[petey2501]

Hello Tobias,

as I put yesterday we do not have any other possible filter after I choose interaction Type Shopping_Cart_ abandoned

Here is the example.

[Katharinam]

Hi Petar,

did you make the fields "Amount" and "Total Amount" visible for the segmentation object "Interactions" with the App "segmentation configuration"?

Then you could select this as the next attributes in your image.

Kind Regards

Katharina