HomeGuidesRecipesAPI
HomeGuidesAPILog In

Interaction Drop Off Log

Returns forms that were forcibly terminated. It includes the last page the user was on together with the last question the user interacted with. If no questions were interacted with on the page question columns will resolve to null.

A drop-off is defined as a form that is terminated in a manner other than the following:

  • Submitted
  • Reassigned
  • Go to Project (Tile Question)
  • Saved (A saved form can be exited without counting as a drop off).
NameDescription
FormName of the Fortm
Log_GuidID for the session
PageDrop of Page
PageFocusTimeUTCWhen the user navigated to the drop off page (UTC)
QuestionLast question the user interacted with before drop off
QuestionFocusTimeUTCWhen the user interacted with the above question

📘

Database Raw Data

Access to the raw data can be achieved using the query below:
SELECT TOP (1000) [Business_Unit_GUID]
,[Log_Guid]
,[Form]
,[Page]
,[PageFocusTimeUTC]
,[Question]
,[QuestionFocusTimeUTC]
FROM [vwInteractionLog_DropOff]