Adobe Customer Journey Analytics Finding difference between two metrics

Question

Hi,

Consider a scenario where I want to get the occurrence count for events occurring between the difference of two metrics of the type datetime.

E.g. ingested records in aep contains two fields 'timestamp' and 'purchaseTimestamp'. I want to find the count of records for which the difference in 'timestamp' and 'purchaseTimestamp' lies between the category of '0-5 Min', '5-10Min', '10-15 min'.

Any suggestions, help is much appreciated

Josh Stephens · Accepted Answer

I don't believe there's currently a way to do to this in CJA. The derived field functions that work with datetime fields are limited. As @manojsingh-tech mentioned, Query Service may be the best approach for now.

Alternatively, you could perform a full table export with both timestamps, but it'd probably be easier to use query service.

manojsingh-tech · Answer

You can achieve this using Adobe Experience Platform Query Service (SQL) by categorizing records based on the time difference between timestamp and purchaseTimestamp

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded