Watterfall count in adobe campaign classic v8

Question

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

RCh2_ · Accepted Answer

Hi @adobewisdomwarrior,

Please refer to this :

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/creating-a-waterfall-report-in-acc-v7/td-p/460425#:~:text=According%20to%20the%20Adobe%20Experience%20League%20Community%2C,pass%20it%20as%20object%20down%20the%20stream**

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

Thanks,

ParthaSarathy · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded