How can i link nms:deliveryLogs and nms:trackedUrls (Delivery URL Tracking) Schemas | Community
Skip to main content
S
SurabattulaSr
Level 6
May 20, 2019

How can i link nms:deliveryLogs and nms:trackedUrls (Delivery URL Tracking) Schemas

  • May 20, 2019
  • 2 replies
  • 12180 views

Hello Folks,

I am trying to establish a link between nms:broadLog (Recipient Delivery Logs) and nms:trackedUrls (Delivery URL Tracking) schemas together. My requirement is to identify whom all delivery is targeted and what are the URL's that are getting tracked for that particular Email Delivery. My query filter would be on the field Delivery Internal name.

Ultimately My output should be like:

Recipient ID|Recipient Email Address|Contact Date (From Recipient Delivery Logs) and Source URL|Label (From Tracked URL's).

abc|abc@gmail.com |2019-05-20 |https://www.adobe.com |Visit Site

abc|abc@gmail.com |2019-05-20 |https://www.forums.com |Visit Forums and so on.

Could someone please help me on how can i accomplish this, it would be great if you let me know how it can be implemented using a workflow.

Regards,

Sri Bhargav

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity Advisor
    Community Advisor
    May 20, 2019

    Hi,

    Use a query activity on nms:trackingLogRcp. From there you'll have access to all the tables and fields in your list via 'Add data...' (select clause).

    Thanks,

    -Jon

      A
      AbdulZa
      Level 3
      May 20, 2019

      That's correct. Since the tracking log recipient (TrackingLogRcp) is the lowest level, you query activity node has to be set at that level so you can pull attributes/columns from other higher level tables such as BroadLogRcp, Delivery, etc.

      Thanks.

        S
        SurabattulaSrAuthor
        Level 6
        May 21, 2019

        Thank You AbdulZa

        kapilKochar
        kapilKochar
        Level 6
        June 20, 2019

        Hi Sri,

        broadlogRcp is connected to Tracking URL as 1:N. So, create your first query where targeting dimension delivery and  filtering dimension tracking log

        Hope this will help. Do let me know if this works.

        Thanks.

        Kapil

        S
        SurabattulaSrAuthor
        Level 6
        July 1, 2019

        Thank You for the response Kapil!

        A
        AbdulZa
        Level 3
        July 1, 2019

        Hi,

        There is the joining/linking path

        BROADLOGRCP --> TRACKINGLOGRCP (via IBROADLOGID)

        TRACKINGLOGRCP --> NMSTRACKINGURL (via ITRACKINGURLID/IURLID)

        BROADLOGRCP --> DELIVERY (via IDELIVERYID)

        TRACKINGLOGRCP  --> DELIVERY (via IDELIVERYID)

        You should be able to review/export the desired data (people who were promoted, sent an email, open/click, what they clicked on, etc.)

        Thanks.

          Terms & ConditionsAccessibility statement

          Loading footer...