Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Adhiyan
AdhiyanAccepted solution
Adobe Employee
February 12, 2018

Hello Priyanka,

Delivery ID - Primary key or Unique identifier of the delivery . A delivery may contain multiple recipients and correspondingly multiple delivery log entries.

BroadLog iD : The primary key for each delivery log sent to recipients.

Eaxmple : Say you have sent an Delivery to 100 recipients . It will have one delivery ID and 100 BroadLog IDs.

Regards,
Adhiyan

View in thread

8 replies

Adhiyan
Adobe Employee
AdhiyanAdobe EmployeeAccepted solution
Adobe Employee
February 12, 2018

Hello Priyanka,

Delivery ID - Primary key or Unique identifier of the delivery . A delivery may contain multiple recipients and correspondingly multiple delivery log entries.

BroadLog iD : The primary key for each delivery log sent to recipients.

Eaxmple : Say you have sent an Delivery to 100 recipients . It will have one delivery ID and 100 BroadLog IDs.

Regards,
Adhiyan

Translate
    ChannaAn
    November 8, 2023

    Does a BroadLog iD  get created for quarantined emails? assume it does not get created as the delivery is not successful, but would like to double confirm, thanks!

    Translate
    priyankah586599Author
    Level 4
    February 12, 2018

    Hi Adhiya,

    Thank you. Which schema has broadLog ID and tracking details together?

    Regards,

    Priyanka

    Translate
    Adhiyan
    Adobe Employee
    AdhiyanAdobe Employee
    Adobe Employee
    February 12, 2018

    Hi Priyanka,

    The Schema broadLogRcp has all the details about the BroadLog and this is linked 1:N to TrackingLog . so you can get all the information from here.

    Regards,
    Adhiyan

    Translate
      priyankah586599Author
      Level 4
      February 14, 2018

      Thanks Adhiyan. I just have one more question may be related or unrelated to this thread. I wanted to know which is the broadLog ID in

      1.eventHisto table

      2.trackingLogEventHisto table

      Regards,

      Priyanka

      Translate
      priyankah586599Author
      Level 4
      February 14, 2018

      Awaiting a reply!

      Translate
      Adhiyan
      Adobe Employee
      AdhiyanAdobe Employee
      Adobe Employee
      February 22, 2018

      Hello Priyanka,

      BroadLog ID is the primary key for the broadLogRcp table . Similarly , for eventHisto the BroadLogId would be the primary key of that table.

      In the same way the primary key of trackingLogEventHisto table would be the broadLog ID.

      Regards,

      Adhiyan

      Translate
        punits79985783
        punits79985783
        August 3, 2022

        Is there a public link to the "schema/structure" of the delivery logs from adobe campaign standard?

        My use-case is to keep getting a incremental flow of the "raw data" from the delivery of campaigns and its tracking status. For this, I intend to use the workflow builder including extract file and transfer file. Is this correct? and what is the schema of the output csv file?

        Translate
        Terms & ConditionsAccessibility statement

        Loading footer...