Database Architecture Identifiers
To capture client API transactions, add the TM: Begin Tran completed, TM: Commit Tran completed, and TM: Rollback Tran completed events in the trace along with the TransactionID column. Queries with the same TransactionID are part of the same transaction. 

Note that Profiler is deprecated so I suggest you move to Extended Event tracing. The events are similarly named.

Use datetime2(7) to avoid loss of fractional second accuracy.