Skip to main content
Poonam_Dogra
Level 4
Dec 15, 2022 3:14 PM UTC
Question

Personalized csv attachment in adobe campaign classic

Hi team,

Is there a way to personalize a csv attachment in adobe campaign classic? Or if we can create a personalized csv file via jssp and send that as a link in deliveries. If someone might have achieved it by any other way, it will be helpful if some insights can be shared.

Thanks in advance!

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

9 replies

Amine_Abedour
Community Advisor and User Group Leader
Amine_AbedourCommunity Advisor and User Group Leader
Community Advisor and User Group Leader
Dec 15, 2022 4:26 PM UTC

hello @poonam_dogra 

 

If you mean by personalize a csv attachment like send csv1 to recipient1, recipient2 and recipient3, send csv2 to recipient4 and recipient5, you can do this by :

  • creating the different csv files in your workflow beforehand
  • enrich your target with a column that contains the path to your different CSVs for each recipient (to have something like this)

     

  •  then il the delivery configure the attachement like this :

 

  • you can even go further and script the name of the file so that all recipients receive the same file name here:

 

Hope it's what you are looking for.

Br,

Amine

 

Translate
Amine ABEDOUR
    Poonam_DograAuthor
    Level 4
    Dec 22, 2022 9:38 PM UTC

    Hi @amine_abedour ,

    Thanks so much for your time over the reply, really grateful for that.

    I tried using the option "File name is computed during delivery for each message (it can be depend on the recipient profile)" and tried the csvPath from the previous activity

    Static file try-

    or

    Dynamic file name try-

    Unfortunately I am unable to receive the email. Most probably it should be the syntax I might be doing wrong, please let me know how can I receive the email. Attachments are present in the "export/" folder.

    Or is it something applicable only for recipient schema and not for other custom schemas?

    Thanks once again!

    Translate
    Amine_Abedour
    Community Advisor and User Group Leader
    Amine_AbedourCommunity Advisor and User Group Leader
    Community Advisor and User Group Leader
    Dec 23, 2022 10:01 AM UTC

    Hello @poonam_dogra,

     

    Could you share the error message from de broadlog table?

    Also are you in a Mid Sourcing architecture ? 

     

    Br,

    Amine

    Translate
    Amine ABEDOUR
    David_Loyd
    Adobe Employee
    David_LoydAdobe Employee
    Adobe Employee
    Dec 16, 2022 12:42 PM UTC

    What is the goal of the request?
    If email marketing, its not suggested to attach files to outbound emails. It can hurt IP and email reputation. In general it would be better to host those files and just link to them from the email.

    Translate
    Poonam_DograAuthor
    Level 4
    Dec 22, 2022 9:47 PM UTC

    Hi @david_loyd ,

    Thank you for looking into it and your valuable time over the reply, really appreciate that!

    Goal- We want to send personalized csv attachments to the end users, which will be different for each user.

    "Host those files and link from the email" - Are you suggesting to place those files on some server and provide that server url? Will you be kind to help me understand how can we make those hosted files as personalized to open a different excel from link in the email ? Or should it be hosted differently and different links should be send to the users from email? I think it should be the later one but please correct me if wrong.

     

    Thanks once again!

    Translate
    Shubham_Goyal__
    Shubham_Goyal__
    Level 6
    Dec 20, 2022 8:52 AM UTC

    Hi @poonam_dogra ,

     

    The major challenge that occurs when sending personalized attachments per recipient is uploading the files to the campaign server as that is a main requirement by the adobe campaign: link

    So in your case, you may try to Query the recipients and add the columns that you like to be included in the csv.file and upload each csv file/per recipient in a loop via File Extraction activity which will send the files to export directory of adobe campaign server and once all the files of each recipient are uploaded then call these attached files via export/<filename> in your delivery.
    e.g. of a loop workflow that I thought roughly for your use-case:

     

    P.S additional source of info: link

     

     

    Br,

    Shubham

    Translate
    ~Thanks - Shubham Goyal (Enterprise Architect)
      Poonam_DograAuthor
      Level 4
      Dec 22, 2022 10:02 PM UTC

      Hi @shubham_goyal__ ,

      Thanks a lot for taking your time for responding, grateful for the efforts!

      After trying the approach, it is working fine for static file name, but since this should be automated each time the file name also changes as per the individual, but this option "The file name is computed during delivery analysis (it cannot depend on the recipient profile)" does not allow customizing the file selection from server, it supports only the static file name provided.

      Please let me know if I misunderstood anything here.

      If above suggested only works for static file, unless I am missing any step, I think I need to upload the file to server and as soon as it uploads it should be sent to that person and in the next loop the same file should be replaced for the next person?

      Thanks once again!

      Translate
      Sukrity_Wadhwa
      Sukrity_Wadhwa
      Level 4
      Jan 13, 2023 7:45 AM UTC

      Hi,

      @shubham_goyal__, @amine_abedour & @david_loyd 

      Could anyone please help @poonam_dogra further with their query here? 

      Thanks!

      Translate
      Sukrity Wadhwa
      Terms & ConditionsAccessibility statement

      Loading footer...