Data utilisation across workflows

[TristanBerthon]

Hello,

I'm looking for a way to identify what tables (and ideally fields) are being used across  a selection of campaign workflows. I'm guessing we can access the workflow data and possibly export the full XML. Then make an analysis outside of Campaign.

The goal is to understand what data is used the most and validate if the data model could be optimised for the users.

Has anyone done something similar already?

Thanks

[TristanBerthon]

Hello,

I'm looking for a way to identify what tables (and ideally fields) are being used across  a selection of campaign workflows. I'm guessing we can access the workflow data and possibly export the full XML. Then make an analysis outside of Campaign.

The goal is to understand what data is used the most and validate if the data model could be optimised for the users.

Has anyone done something similar already?

Thanks

[_Manoj_Kumar_ · Accepted solution]

Hello @TristanBerthon  If you have selected fields that you want to look at. The easiest way would be to query the workflow data to look for the the field and  see how many workflow appear in the result.

Exporting the XML for 100s of WFs and parsing it will be very manual tasks given the XML structure won't be the same for all WFs.

[_Manoj_Kumar_ · Accepted solution]

Hello @TristanBerthon  If you have selected fields that you want to look at. The easiest way would be to query the workflow data to look for the the field and  see how many workflow appear in the result.

Exporting the XML for 100s of WFs and parsing it will be very manual tasks given the XML structure won't be the same for all WFs.