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.
Solved! Go to Solution.
Views
Replies
Total Likes
Yes, I was able to get the "Snapshot" activity added to my instance and this is providing the results I desire.
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
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/
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
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!
Views
Replies
Total Likes
Yes, I was able to get the "Snapshot" activity added to my instance and this is providing the results I desire.
Thanks for letting us know!
Views
Replies
Total Likes
Views
Replies
Total Likes
@wendywtay - Do you have the Snapshot activity as part of your instance?
If s - you would add a snapshot after the transition you would like to capture.
Configure the Snapshot with Label and Description
Once the WF has run, if you search for the WF under Administration > All > Workflows and you will see the tab that says "Snapshot", there you will find your counts.
You can then export the counts as *.csv into Excel. Hope this helps.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies