Column to join Delivery and Tracking logs for Push | Community
Skip to main content
Silvio6
Silvio6
Level 6
April 16, 2026
Question

Column to join Delivery and Tracking logs for Push

  • April 16, 2026
  • 1 reply
  • 21 views

Hi, I want to join delivery and tracking logs for push. For email I know we can use “messageProfileId” but I can’t see that column in Push tracking logs.

 

Do you know if there’s an specific column (or maybe a concatenation of ids) to join both Delivery and Tracking for push?

 

My goal is to see the opens or clicks for a profile who received the push.

 

Thanks.

    1 reply

    SatheeskannaK
    Community Advisor
    SatheeskannaKCommunity Advisor
    Community Advisor
    April 17, 2026

    ​@Silvio6 Use this example query as a starting point and adjust it to fit your specific requirements.

    https://data-distilller.gitbook.io/adobe-data-distiller-guide/unit-2-data-distiller-data-exploration/explore-300-exploring-adobe-journey-optimizer-system-datasets-with-data-distiller

     

    SELECT
        -- Profile identity
        MF.identityMap,

        -- Message & Journey metadata (from entity dataset)
        ED._experience.customerJourneyManagement.entities.channelDetails.push.title AS pushTitle,
    ED._experience.customerJourneyManagement.entities.journey.journeyName AS journeyName,
    ED._experience.customerJourneyManagement.entities.journey.journeyActionID AS journeyActionID,
    ED._experience.customerJourneyManagement.entities.journey.journeyVersionID AS journeyVersionID,

        -- Delivery feedback (from message feedback dataset)
        MF._experience.customerJourneyManagement.messageExecution.messageExecutionID AS messageExecutionID,    MF._experience.customerJourneyManagement.messageDeliveryfeedback.feedbackStatus AS deliveryStatus,
    MF.timestamp AS deliveryTimestamp,

        -- Engagement tracking (from push tracking dataset)
        PT._experience.customerJourneyManagement.messageInteraction.interactionType AS interactionType,
    PT.timestamp AS interactionTimestamp

    FROM
        ajo_message_feedback_event_dataset MF

    -- Join entity dataset for message metadata
    INNER JOIN ajo_entity_dataset ED
        ON ED._experience.customerJourneyManagement.entities.channelDetails.messageID = MF._experience.customerJourneyManagement.messageExecution.messageID

    -- Join push tracking for opens/clicks
    LEFT JOIN ajo_push_tracking_experience_event_dataset PT
    ON PT._experience.customerJourneyManagement.messageExecution.messageExecutionID = MF._experience.customerJourneyManagement.messageExecution.messageExecutionID

    WHERE
        -- Filter to push channel only
        MF._experience.customerJourneyManagement.messageProfile.channel._id = 'https://ns.adobe.com/xdm/channels/push'

        -- Only successfully sent pushes
    AND MF._experience.customerJourneyManagement.messageDeliveryfeedback.feedbackStatus = 'sent'

        -- Exclude test executions

    AND MF._experience.customerJourneyManagement.messageProfile.isTestExecution = FALSE

        -- Only opens or clicks (NULL covers delivered-but-not-interacted if you want those too)
        AND (PT._experience.customerJourneyManagement.messageInteraction.interactionType IN ('open', 'click')
            OR PT._experience.customerJourneyManagement.messageInteraction.interactionType IS NULL)

    ORDER BY MF.timestamp DESC
    LIMIT 100;

     

    Thanks, Sathees
    Terms & ConditionsAccessibility statement

    Loading footer...