Is there a way to delete recipients delivery data from the broadlog

[rvnth]

Hi everyone, 

Please suggest on how to delete/clear the broadlog delivery data for a certain recipients. I have to initiate an another delivery for testing purposes and cannot do that since I have broaldlog exclusion set in my workflow. i do not want to make any changes to my workflow , because it was built on a certain use case. 

Thank you in advance

[ParthaSarathy · Accepted solution]

Hi @rvnth ,

In query have targeting and filtering dimension as broad log schema. And in filtering condition, fetch the records you want to delete.

And After Query activity, use Update data activity and

select operation type as 'Delete', 

Record identification: 'using reconciliation keys' and select primary key in destination and identifier.

Updated dimension: your broad log schema 

(Before running the Workflow, disable update data activity and in Query's output transition make sure the results are same records as what you expect to get deleted and then execute 'Update data' to delete the records from Broad log)