then operator between the profile attributes | Community
Skip to main content
D
Deepak_Kv
March 6, 2024
Solved

then operator between the profile attributes

  • March 6, 2024
  • 1 reply
  • 1471 views

Hi All,

 

I'm planning to create a filter in CJA using the "then" operator. Can I use only event attributes between the "then" operator? When I tried with profile attributes, it only gave me empty results. let me know if you need more details.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Kumar29917170hcyp

CJA stores only the latest Profile attribute data available, one way I know of to achieve this is to run a daily Query Service job that takes the daily exported data from UPS Dataset and convert each profile value into time-series data, then insert that into a separate dataset and then use this dataset in the CJA connection.

1 reply

K
Adobe Employee
Kumar29917170hcypAdobe Employee
Adobe Employee
March 6, 2024

Hi @deepak_kv ,

The THEN operator lets you define Sequential Filters.
Sequential Filter:-
Sequential filters let you identify persons based on navigation (page views across your site, interactions with scenes in your mobile app, or using a menu on a set-top box). Sequential filters provide a filter of defined actions and interactions and help you identify what a person likes and what a person avoids. When building sequential filters, the THEN operator is used to define and order person navigation.

Here is an example:

Session One Session Two Session Three
The person went to the main landing page A, excluded the campaign page B, and then viewed the Product page C.The person again went to the main landing page A, excluded the campaign page B, and went again to the Product page C, and then to a new page D.The person entered and followed that same path as in the first and second visits, then excluded page F to go directly to a targeted product page G.

 Doc Link- https://experienceleague.adobe.com/docs/analytics-platform/using/cja-components/cja-filters/filters-overview.html?lang=en#sequential

    D
    Deepak_KvAuthor
    March 8, 2024

    Thanks for your reply.

    You were talking only about events. Let me elaborate on my question. Let's say I have a profile attribute XYZ with the value ABC, and I'm sending a specific email using AJO to that particular people who have ABC value on XYZ. After sending the emails, I want to know how many profile attributes XYZ changed to PQR.

    I created a filter in CJA like below:

    XYZ equals "ABC"
    then
    email = sent
    then
    XYZ = PQR

    Is this possible? Do you have any other approach? Basically, I want to see the impact of the profile attribute after a particular event."

    J
    jm_11
    March 19, 2024

    CJA stores only the latest Profile attribute data available, one way I know of to achieve this is to run a daily Query Service job that takes the daily exported data from UPS Dataset and convert each profile value into time-series data, then insert that into a separate dataset and then use this dataset in the CJA connection.


    Hi @kumar29917170hcyp , can you please elaborate some more on this approach:

    What is the UPS Dataset named in AJO?

     

    Also, is there a way to retrieve the last date a profile was modified from some OOTB field in the schema? We checked the _repo.modifyDate from one of our custom profile schemas that we created. However, we are note able to query this field:
    select _repo.modifyDate from profile_dataset;

     

    We get an error stating: 

    •  Column _repo.modifydate does not exist.
    Can you please let me know why this might be the case. 
     
    Thank you.


     

      Terms & ConditionsAccessibility statement

      Loading footer...