Segment shows no data while Query Service show for same time and dates

Last update: 2023-01-05

Description

Environment
Experience Platform

Issue/Symptoms
Sometimes, a segment shows no profiles, whereas the Query Service shows some data for the same time and dates.

Resolution

While this may not be the case for every ticket, an investigation may indicate the dataset was enabled and disabled (for Profile) at times and this would explain why some timeframes are gathering data and some not.

Note that the segment estimate would only show you what was ingested in Profile as opposed to Query Service only looking into the Data Lake, this would explain the discrepancy. If some data was ingested into the Data Lake at a point in time where the dataset was NOT enabled for Profile, the data wouldn’t have been promoted to the Unified Profile Service (UPS).

Also, you may be able (with the correct permissions) to access the Audit Logs feature in Adobe Experience Platform (AEP), where you would potentially see the historical data, we have for a dataset.

This requires the ‘View User Activity Log access’ control permission granted in Data Governance. - See Admin Console

Resources:

  1. Audit logs: https://experienceleague.adobe.com/docs/experience-platform/landing/governance-privacy-security/audit-logs/overview.html
  2. Audit Query API documentation: https://developer.adobe.com/experience-platform-apis/references/audit-query/
  3. Audit Logs Postman collection available at: https://github.com/adobe/experience-platform-postman-samples/blob/master/apis/experience-platform/Audit%20Query%20API%20(Beta).postman_collection.json

On this page