How to set a new attribute as a date and use it in a workflow

Thanks a lot Felix.

I forgot to mention something important: The data that are sent to CIO as attributes are coming from Google Sheet via Zappier. So let’s say that cell A2 is a date & time field in Google sheet, I’d like that cell value to also be reflected as a date attribute in CIO. Is that possible?

Many thanks,

Hey Gregh,

yes. In order to make it a timestamp you simply have to convert the Google Sheet date & time format to a unix timestamp before importing. Check out this page to implement the fomula (lower part).

Make sure to only import the unix timestamp to CIO 😉 There is nothing you have to do to mark it as timestamp in CIO once imported.

Felix

Awesome! :) Thanks a lot

Have a great day

Actually, Felix, one last question on the same topic.

In my workflow, can I use _created_in_customerio_at to trigger an email to be sent via “wait until”.

E.g. Wait until 22 hours after _created_in_customerio_at , then send the email.

Couldn’t find how to achieve this.

Many thanks,

Hey Gregh,

you can do this, but it allows you only to specifiy days, not hours nor minutes:

You can create a segment that includes people that got created in CIO (see e.g. the sample segment “Signed up” and use a “time delay” in the beginning of your campaign.

Best,
Felix

Thanks Felix!