Expand my Community achievements bar.

SOLVED

Data Distiller: Audience Refresh

Avatar

Level 2

Hello People,

Is there a way to refresh the data distiller audience by a trigger or updating dataset, so that the audience will not get dropped after 30 days?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @SaurabhCh3,

 

This is totally feasible, you need to have a scheduled insert query(based on your need) to same audience for re-ingesting to have your lastQualificationTime updated.

Sample Query :

 INSERT INTO Audience <<audience name>>
SELECT <<business logic>>

Once the audience is re-ingested to Profile you be able to see that timestamp across the selected profiles will reflect new qualification time (lastQualificationTime).

#before insert state

"DDA": {
      "f1ddbcd1-f782-4b06-af7e-9bd99ef49630": {
        "lastQualificationTime": "2025-01-22T17:09:17Z",
        "status": "realized",
        "payload": {
          "payloadStringValue": "7673c681017aca41d03e93beee6a83a7",
          "payloadType": "String"
        }
      }

#after insert state

"DDA": {
      "f1ddbcd1-f782-4b06-af7e-9bd99ef49630": {
        "lastQualificationTime": "2025-01-22T18:41:37Z",
        "status": "realized",
        "payload": {
          "payloadStringValue": "7673c681017aca41d03e93beee6a83a7",
          "payloadType": "String"
        }
      }

 

Few use full links:

 

Query Scheduling : https://experienceleague.adobe.com/en/docs/experience-platform/query/ui/query-schedules#schedule-det...

 

Let me know if you need more help on this and also mark the thread accordingly.

 

~cheers,

NN

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hello @SaurabhCh3,

 

This is totally feasible, you need to have a scheduled insert query(based on your need) to same audience for re-ingesting to have your lastQualificationTime updated.

Sample Query :

 INSERT INTO Audience <<audience name>>
SELECT <<business logic>>

Once the audience is re-ingested to Profile you be able to see that timestamp across the selected profiles will reflect new qualification time (lastQualificationTime).

#before insert state

"DDA": {
      "f1ddbcd1-f782-4b06-af7e-9bd99ef49630": {
        "lastQualificationTime": "2025-01-22T17:09:17Z",
        "status": "realized",
        "payload": {
          "payloadStringValue": "7673c681017aca41d03e93beee6a83a7",
          "payloadType": "String"
        }
      }

#after insert state

"DDA": {
      "f1ddbcd1-f782-4b06-af7e-9bd99ef49630": {
        "lastQualificationTime": "2025-01-22T18:41:37Z",
        "status": "realized",
        "payload": {
          "payloadStringValue": "7673c681017aca41d03e93beee6a83a7",
          "payloadType": "String"
        }
      }

 

Few use full links:

 

Query Scheduling : https://experienceleague.adobe.com/en/docs/experience-platform/query/ui/query-schedules#schedule-det...

 

Let me know if you need more help on this and also mark the thread accordingly.

 

~cheers,

NN