Launching email campaign from unlinked list | Community
Skip to main content
V
veram34903487
Level 2
February 7, 2017
Solved

Launching email campaign from unlinked list

  • February 7, 2017
  • 10 replies
  • 8043 views

Is there a way to launch an email delivery (email campaign) from an external csv file that I want to keep unlinked from the recipient table?

Meaning, importing a csv list with a single column containing just email adresses, create a list from there, and launch a campaign from that list?

I know it's not best practice as you usually should link delivery to recipients for also delivery logs. But this is an exception.

    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 vraghav

    Hi Vera,

    Yes this is possible. 

    For it to happen you can make use of External File target mapping. Internal name of this mapping is mapAny.

    You can locate this mapping at Administration > Campaign management > Target mappings.

     

    • Let's say you have a CSV file with single column containing email addresses. Say the column name is email.
    • Go to mapAny target mapping and on the Mapping tab, for the Email attribute enter email in it.
    • Inside delivery, click on To link to change target mapping from nms:recipient to External File.
    • Execute your workflow.

    Hope this helps.

    Regards,Vipul

    10 replies

    vraghav
    Adobe Employee
    vraghavAdobe EmployeeAccepted solution
    Adobe Employee
    February 7, 2017

    Hi Vera,

    Yes this is possible. 

    For it to happen you can make use of External File target mapping. Internal name of this mapping is mapAny.

    You can locate this mapping at Administration > Campaign management > Target mappings.

     

    • Let's say you have a CSV file with single column containing email addresses. Say the column name is email.
    • Go to mapAny target mapping and on the Mapping tab, for the Email attribute enter email in it.
    • Inside delivery, click on To link to change target mapping from nms:recipient to External File.
    • Execute your workflow.

    Hope this helps.

    Regards,Vipul

      V
      veram34903487Author
      Level 2
      February 7, 2017

      This is very helpful, will try!

      florentlb
      florentlb
      Level 10
      February 7, 2017

      Hi Vera,

      In addition to what Vipul said, have you seen the "from an external file" option which is available when defining the recipients of a delivery? See screenshot below:

      From there, you are able to define which fields from the file correspond to email, etc.

      Target would be considered as recipients but would not be imported in the database as long as you check the "Do not import recipients into the database" option.

      Depending on your specific requirements, this could also do the trick.

      Hope this helps,

      Florent

        V
        veram34903487Author
        Level 2
        February 7, 2017

        Hi Florent,

        I didn't have the chance to test this yet. I assume I have to upload the csv beforehand and save it into a list (without linking) before doing this? Or can I upload and, in "File format definition", define/assign the email column. I work with an older version of AC, this is why it doesn't show up as in your screenshot.

        vraghav
        Adobe Employee
        vraghavAdobe Employee
        Adobe Employee
        February 8, 2017

        Hi Vera,

        Florent's suggestion is for a standalone delivery. Something that is not associated with a workflow. 

        In the case a file with email addresses and other personalization information is loaded on to the delivery directly and processed from there.

        The option of target mapping provided by me helps you upload a file using Data Loading activity, do some transformation on it (if needed) and then send out the delivery.

        Hope this clarifies.

        Regards,Vipul

          V
          veram34903487Author
          Level 2
          March 31, 2017

          florentlb wrote...

          Hi Vera,

          In addition to what Vipul said, have you seen the "from an external file" option which is available when defining the recipients of a delivery? See screenshot below:

          From there, you are able to define which fields from the file correspond to email, etc.

          Target would be considered as recipients but would not be imported in the database as long as you check the "Do not import recipients into the database" option.

          Depending on your specific requirements, this could also do the trick.

          Hope this helps,

          Florent

           

          Hi Florent,

          topic got dropped and surfaced again. I was able to do as you suggested, just with the field mapping I encounter the problem that I am not able to enter a destination path for the different columns. For some strange reason the wizard works (when it is able to guess the field), but I am not able to set it manually. It just won't open a dropdown. Any ideas? Transformation I am able to open.

          In addition to email, I need some other information from the file such as name and Salutation.

          R
          raultorga
          Level 2
          September 20, 2018

          How can I do the same thing in Adobe Campaign Standard?

          bhavanar3720270
          bhavanar3720270
          October 24, 2018

          Tried this approach. Its giving me the below error in the delivery email.

          Could anyone please mention if any additional settings must be done in the delivery template to accommodate this in the workflow?

          Thanks in advance.

          soniag66764829
          soniag66764829
          Level 2
          November 22, 2018

          Hello Vipul Raghav,

          Thank you for your help on that issue, sadly i did not manage to send a delivery with emails from a csv file.

          I followed your advise (I m using Adobe Campaign standard), I edited the mapAny targeting dimension as you suggested, but when i launch the workflow, the delivery task stays in pending status.

          Do you have any idea to achieve this with ACS ?

          Thank in advance

            asish_kumarp599
            asish_kumarp599
            Level 4
            January 7, 2019

            I don't think you can achieve this in Adobe campaign standard. It looks like Vipul and Florent's comments are referring to ACC only. You can't send emails in ACS to recipients without storing them into profiles.  In ACS the target mapping field is Non Editable inside Email Delivery. There is a similar discussion in the below thread.

            Re: ACS deliveries to list from csv

            Terms & ConditionsAccessibility statement

            Loading footer...