Save in Database Segment Code of an Split activity before a Delivery | Community
Skip to main content
CampaignerForLife
CampaignerForLife
Level 5
July 3, 2023
Solved

Save in Database Segment Code of an Split activity before a Delivery

  • July 3, 2023
  • 1 reply
  • 1518 views

Hello, I want to save the Segment Code of a Delivery Activity to use it later 

For example, I split a query in two: Segment1 and Segment2, and each one creates a Delivery. How should I proceed to save that Delivery1 was created by Segment1, and Delivery2 was created by Segment2?

 

Thank you very much! @_manoj_kumar_ 

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

    Hi @campaignerforlife ,

    Step-1:

    In your broad log schema, create an attribute @segmentCode with data type as string.

    Step-2:

    Update database structure > disconnect - reconnect

    Step-3:

    Then, in your target mapping, storage tab > Additional fields, add as below

    Source expression: [targetData/@segmentCode]

    Destination: @segmentCode

    So now in broadLog schema, you can able to see which recipients got targeted using which segment and belongs to which delivery

     

     

    1 reply

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity AdvisorAccepted solution
    Community Advisor
    July 3, 2023

    Hi @campaignerforlife ,

    Step-1:

    In your broad log schema, create an attribute @segmentCode with data type as string.

    Step-2:

    Update database structure > disconnect - reconnect

    Step-3:

    Then, in your target mapping, storage tab > Additional fields, add as below

    Source expression: [targetData/@segmentCode]

    Destination: @segmentCode

    So now in broadLog schema, you can able to see which recipients got targeted using which segment and belongs to which delivery

     

     

    ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
      CampaignerForLife
      CampaignerForLifeAuthor
      Level 5
      July 4, 2023

      Hello Partha, this worked for the Delivery Logs, but not for the Exlcusion one. I added the same Segment Code in the excludeLogRcp schema, but is empty while the broadLogRcp is showing me the result. May you tell me how this works? How could I make it work for Exclusion and other log schemas?

      Thank you in advance!! 

       

      @parthasarathy @_manoj_kumar_ 

        ParthaSarathy
        Community Advisor
        ParthaSarathyCommunity Advisor
        Community Advisor
        July 5, 2023

        Hi @campaignerforlife ,

        It will work for exclusion Log schema as well.

        Make sure you had created Segment code attribute with name as segmentCode (case sensitive, so it should be same as what you had created for broadLog schema and what you had mentioned in target mapping additional fields) with data type as string.

        Then, update database structure > disconnect-reconnect

         

        And once cross check your target mapping, whether your exclusion log is mentioned in mapping > storage tab > Rejection schema: exclusion Log schema where you had created segmentCode

         

        Now in the workflow add segment code and run a delivery, and check in exclusion Log schema.

         

         

        ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
        Terms & ConditionsAccessibility statement

        Loading footer...