Watterfall count in adobe campaign classic v8

[AdobeWisdomWarrior]

Hi Team,

I’ve been trying to capture and export waterfall counts at different stages of my workflow in Adobe Campaign v8. For example:

• After the Query activity, the count is 100 records.
• After the Exclusion activity, it reduces to 75.
• After the Delivery activity, it becomes 50.

I want to export these counts within the same workflow for tracking and reporting purposes.

I attempted using the WorkflowTask and Workflow schemas, but unfortunately, it didn’t work as expected in v8. Could anyone guide me on how to achieve this logic effectively?

@ParthaSarathy  @Jyoti_Yadav @Rch_ @SushantTrimukheD @Parvesh_Parmar @DavidKangni @ccg1706 

[ParthaSarathy]

Hi @AdobeWisdomWarrior ,

After each activity use a JavaScript code activity and get the count using vars.recCount . For example, after query activity use the below script to get Query's count:

vars.queryCount = vars.recCount;

And in the end of your same WKF, use Alert activity and call the query count as below,

Query count:  <%= vars.queryCount %> 

Enrichment count:  <%= vars.enrichmentCount %> 

Also instead of using JS actovity after each activity, you can have the same script in next activity's advanced tab > initialization script.

Example, if you have Query > enrichment > dedup > delivery, calculate Query's count in enrichment activity's advanced tab's initialization script.

[AdobeWisdomWarrior]

Hi @ParthaSarathy ,

Anything is possible like this in V8? Below page is exactly in my use case but unfortunately  is not working in v8.

Boost Analysis with Waterfall count in Adobe Campaign 

[RCh2_]

Hi @AdobeWisdomWarrior,

Please refer to this :

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/creating-a-waterfa...

We also have this activity in our instance. Kindly reach out to Adobe Support team for further assistance.

Thanks,