We are trying to cross check the Interaction Summary table against the Dialer Call History table.
We are using the InteractionKeyId (InteractionSummary) and callidkey (dialer.callhistory) to match the records between both tables.
We first run a query on Interaction Summary table and use the InteractionKeyID. We use this to then check for the matching callidkey in the call history table, all the times are different by seconds and/or miliseconds. But they should match?
I have checked the InteractionSummary.StartDTOffset, but even if this is 0 , the following times are all different between Interaction Summary and Dialer CallHistory
InitiatedDateTimeUTC -> callplacedtimeUTC
ConnectedDateTimeUTC -> callconnectedtimeUTC
TerminatedDateTimeUTC -> calldisconnectedtimeUTC
Anyone know any reason these times are different between tables?
Thanks,
Marian
#Reporting/Analytics