Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Creating a Waterfall Report in ACC v7

Avatar

Level 2

Hello, 

 

Does Adobe have the OOTB feature or capabilities to create a Waterfall report from Workflow activities? 

 

In a previous CRM system, I could easily create a Waterfall that would list all the activities and the quantities associated with them. 

 

Asking because I don't want to go down the route of creating Instance Variables for each activity and writing them out in an Alert. 

 

0 Replies

Avatar

Community Advisor

Hello @montezh2001,

you might try to read logs from workflow journal where you get lists of all activities and then simply query those lines to see the waterfall in separate technical workflow and send alert with waterfall data parsed

 

Marcel_Szimonisz_0-1657806317409.png

 

 

Or store the counts in a same variable and pass it as object down the stream and process it at the end.

With use of instance.vars. and JSON.stringify and JSON.parse 

var vaterfall = JSON.parse(instance.vars.waterfall);
vaterfall.push({activityName:"activity", count:vars.recCount});
instance.vars.waterfall = JSON.stringify(vaterfall);

 

 

Marcel Szimonisz

MarTech Consultant
for more tips visit my blog
https://www.martechnotes.com/

Avatar

Employee Advisor

Hi @montezh2001 and @Marcel_Szimonisz 

Be aware that using the logs, you might not have the exact waterfall as in the workflow editor because as there is no true start and true end in the logs and the logs don't have always the count associated to it

The current Workflow Editor is your waterfall representation of a workflow, I agree with the latest execution and not the past execution.

What is the use case to see the workflow execution for past execution as opposed the current?

Thanks

Denis

 

Avatar

Administrator

Hi @montezh2001,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!