Expand my Community achievements bar.

SOLVED

total transaction calculation amount using enrichment in Adobe campaign classic

Avatar

Level 4

Hi All,

 

 

@AndreaBriceno

@ParthaSarathy

@ParthaSarathy 

@ParthaS 

@AkshayAnand 

@Craig_Thonis 

@Manoj_Kumar_ 

@Amine_Abedour 

@Marcel_Szimonisz

@DavidKangni 

@Amit_Kumar 

@ShashankNigam02

@Ganesh5067

@Jonathon_wodnicki

 

@ParthaSarathy

@ParthaSarathy 

@ParthaS 

@AkshayAnand 

@Craig_Thonis 

@Manoj_Kumar_ 

@Amine_Abedour 

@Marcel_Szimonisz

@DavidKangni 

@Amit_Kumar 

@ShashankNigam02

@Ganesh5067

@Jonathon_wodnicki

 

we are  stuck in one situation

please help

 

we need to find out total transactions made my customers

 

we have customer details stored in customer schemas

and transaction details like transaction Amount,transaction id is stored in Transaction schema

so i have tried to create this as below

 

1.Query activity to fetch the recipient details like first name, last name etc

2.enrichment Activity to create a link with Transaction schema

3.another enrichment activity i have used aggregate function : sum(Transaction amount)

 

But now here in output m not able to get total sum of transaction made by customer,m getting count in output transaction as 0.

so basically I am stuck here

 

please help me here

what i need to add in

 

 

 

 

Thanks in advance

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @DishaSharma,

have transactions as targeting dimension, aggregate them by deduplicating on recipient id and using sum().

You might have some issues with not adding id to aggregate function that can be solved by checking option within additional data, but only in query.

The enrichment sum should also work when using aggregate join select sum exactly as on the video posted by @AnanthanJa 

 

Marcel Szimonisz

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

Hello @DishaSharma,

have transactions as targeting dimension, aggregate them by deduplicating on recipient id and using sum().

You might have some issues with not adding id to aggregate function that can be solved by checking option within additional data, but only in query.

The enrichment sum should also work when using aggregate join select sum exactly as on the video posted by @AnanthanJa 

 

Marcel Szimonisz

Avatar

Level 2

Hi @DishaSharma  ,
1. Use query1 to get customer details like customer id(primary key),name,age.
2. Use query2 to get customer id and sum of transactions from transaction table.(check "disable automatic adding of primary keys of the targeting dimension")

rahulbabu_0-1708628365606.png

3.Then do enrichment and combine both query with 1-1 cardinality on customer ID.