Data Distiller: Audience Refresh | Community
Skip to main content
Level 2
January 17, 2025
Solved

Data Distiller: Audience Refresh

  • January 17, 2025
  • 1 reply
  • 516 views

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?

Best answer by nnakirikanti

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-details

 

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

 

~cheers,

NN

1 reply

nnakirikanti
Community Advisor
nnakirikantiCommunity AdvisorAccepted solution
Community Advisor
January 22, 2025

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-details

 

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

 

~cheers,

NN