Eloqua - How to upload your contacts into the database

Use this process to add your contacts to the Eloqua database with your group's contact label, so you can see and communicate with them.

IMPORTANT: To upload contacts, you must have an Excel document or .csv file with
at least the following data, in two separate columns:
  • Email address
  • Contact label
If you aren’t sure what your contact label is or how to format an upload document, please contact marketingautomation@wisc.edu.
UploadingContacts0.png
  1. Open Firefox and navigate to login.eloqua.com. Sign into UWMADISON using SSO (your NetID credentials).
  2. Click the hamburger menu in the upper left corner of the screen. Select Audience and then Contacts.

    UploadingContacts1b.png


  3. On the next screen, click the Upload button.

    UploadingContacts3.png


  4. You will be taken to the Contact Upload Wizard.
    • If you want to name your list, type a title in the Name: field.
    • If you will be uploading a file other than an Excel spreadsheet, change the dropdown next to Import Source:.
    • Leave Import Purpose: and Presets: alone.
  5. Click the cloud to upload your contacts file. (Note: If you have a multisheet Excel document, only the first sheet will be imported.)

    UploadingContacts4.png

  6. In the window that pops up, navigate to where your contacts file is saved and click Open.

    UploadingContacts5.png


  7. You will be taken to Step 2 of the Contact Upload Wizard, where you will see a preview of your data. Check it over, and if everything looks fine, click Next Step.

    UploadingContacts6.png


  8. In Step 3 of the Contact Upload Wizard, you will be asked to map your Source Fields (the columns of your contacts file) to the Target Field (fields on the contact records in Eloqua). Eloqua will attempt to match your columns to its fields. Leave Uniquely Match Contacts On: as Email Address.
  • If its mapping is correct, click Next Step.

    UploadingContacts7a.png
  • If you need to make changes to the mapping, double-click the Target Field you want to change and select the new field from the dropdown menu, then click Next Step.

    UploadingContacts7b.png
  1. In the last step of the Contact Upload Wizard, you will select if you are notified when the upload is complete.
    If you want to receive an email when the upload is complete, type your email address in the field under Send Upload Notification To:.
  2. Make sure Place Contacts into a Shared Contact List and Create in folder are both checked.
  3. Navigate to your folder.
  4. Click Finish.

    UploadingContacts8.png


    Eloqua will upload your contacts to your desired Shared List, and you will receive an email from support@eloqua with the subject line, The contacts requested have been successfully uploaded. This email will outline how many contacts were added as new contacts and how many existing contacts were edited.

  5. You can find this list of contacts in Shared Lists, by going to the main menu and selecting Audience, then Tools > and Shared Lists. Then navigate to your folder. You can rename, copy, move, delete or open lists in this view.
UploadingContacts10.pngUploadingContacts11.pngUploadingContacts12.png


Don't forget that it may take 15 minutes for the contacts to appear, if they do not already have your Contact Label.