Uploading contacts directly to segments
You can use an upload file to add contacts to a segment. Any new contacts are automatically added to your contact database. Depending on how your configure the upload wizard, any existing contact records could be updated with new information you provide in the upload file.
Before you begin:
- Create your upload file (.txt, .csv, .xls, .xlsx). The upload file should only contain the contacts that you want to add or update.
- Separate contact fields in a .csv or .txt file using a comma (,), pipe (|), tab, or semi-colon (;).
- Any field may be quoted (with double quotes).
- Fields containing a line-break, double-quote or the selected delimiter must be quoted.
- If double-quotes are used to enclose fields, then a double-quote in a field must be represented by two double-quote characters.
- The first row of the file must be column headings. Oracle Eloqua will attempt to map the headings to existing contact fields.
- Make sure that you can map the data in your upload file to contact fields in Oracle Eloqua. Use similar naming conventions in your upload file to make this mapping easier.
- Make sure that contacts in your upload file have a unique identifier (such as an email address).
To upload contacts to a segment:
- Navigate to Audience
, then click Segments.
- Open an existing segment, or create a new one.
- Click Add
in the left pane, then click Upload Contacts
.
- Click
and browse to the upload file.
The upload wizard continues to step 2.
- Verify the contents of the file on the Review tab and click Next Step.
- Complete the Map Fields window.
- Make sure you map all the data in your upload file to the applicable contact field.
- Make sure that you select when you want the contact fields to update using the All Fields Update Type drop-down list. For example, update the field if it is blank or not blank. Using Set to default will use the default configuration for each field. If a specific field should be updated differently than the rest, you can double-click the field and configure the update type for that specific field.
- Click Next Step.
- Complete the final step of the wizard and click Finish.
- To give your criteria a descriptive name or brief description, in the left pane, double-click the filter name or description. This will help you easily identify the segment's criteria.
Click the icon in the left pane to add more contacts using filter criteria, an upload file, or by choosing individual contacts.
Troubleshooting