{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/85bfab5b71024826aa6e583ca63d2458\" frameborder=\"0\" width=\"1664\" height=\"1248\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1248,"width":1664,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1248,"thumbnail_width":1664,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/85bfab5b71024826aa6e583ca63d2458-4a2fe19fae40fed2.gif","duration":211.9355,"title":"Calculating Time Between Profile Creation and Event Completion ⏳","description":"In this video, I walk you through how to calculate the time between when a profile was created and when a specific event, like our custom DemoSchedule event, occurred. I demonstrate how to pull up the relevant data, download it as a CSV, and then import it into a new spreadsheet for analysis. You'll need to clean up the data a bit to ensure everything aligns correctly, especially if you have more events than rows in your sheet. Please follow the link in the article below to access the template I used, and remember to make a copy for your own use. This process will help you understand the engagement timeline of your profiles with our marketing efforts."}