total transaction calculation amount using enrichment in Adobe campaign classic

[DishaSharma]

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

[AnanthanJa]

Hi @DishaSharma ,

Refer to the following link for more information.

https://helpx.adobe.com/campaign/classic/how-to/compute-aggreates-in-acv6.html

[Marcel_Szimonisz · Accepted solution]

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

[rahulbabu]

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")

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