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 27, 2024

    Hi @jm_11,

     

    The Profile Snapshot dataset is available in AEP. Another dataset that AJO writes is - AJO push profile dataset.

    Below is the list of all the automatically created dataset that is used by AJO (available in AEP):

     

     

    To create a report in CJA on a Profile attribute to see the trend of updates (from value AAA to BBB), there are 2 ways:


    Option 1- Run/Schedule a daily Query Service job in AEP that takes the daily exported data from the Profile Snapshot Dataset and convert each profile value into time-series data, then insert that into a separate dataset and then uses this dataset in the CJA connection.
    The Profile Snapshot Dataset mentioned above is available in AEP which gets refreshed daily with the latest Profile data ingested in Individual Profile Datasets.

     

    Option 2- When the data is ingested in AEP for an Individual Profile Dataset, ingest the same data using another dataflow to a time series dataset (Experience Event) along with a timestamp value i.e. ingestion time.

    This Experience Event dataset should not be enabled for profile. When you use this dataset in the CJA connection, you will see the previous values for all the profile attribute.


    Hi @kumar29917170hcyp 

     

    Can you please confirm that adhoc created datasets from Query Service will show up as potential datasets to add in a connection. 

     

    I created 2 datasets using the CTA functionality in query service, yet they were not showing up as datasets that I could add to the connection. Please let me know. 

    Terms & ConditionsAccessibility statement

    Loading footer...