Calculate days between events in Office Autopilot or Ontraport

Home » Calculate days between events in Office Autopilot or Ontraport

Calculate days between events in Office Autopilot or Ontraport

If you want to calculate the number of days between 2 events in Office Autopilot (OAP) then use this script.

Use case example:

I’ve got a funnel that will take people down 1 of 2 paths depending on how fast they are consuming content.

If the user is consuming the content quickly we will keep the content coming. This is the fast path. We determine if they should go down that path if the days since they joined the list and the days they watched the first video are 0.

It looks like:
[DATE WATCHED VIDEO 1] – [DATE ADDED] = x

So let’s assume they joined today, watched the first video to completion it would be:

2013-08-13 minus 2013-08-13 = 0 days

So they go down the fast path sequence and are delivered the next piece of content.

The Normal Path
If the user joined yesterday but didn’t watch until today, then their ‘days since’ would be 1. Since it is not 0 we send them down the regular path and they get the next piece tomorrow.

Posted in

Darren Crawford

Darren is a guy who loves marketing technology.

Leave a Comment

Your email address will not be published. Required fields are marked *

Let's connect.

Scroll to Top