Importing relevant products to an offer by pasting product IDs

You can assign a list of relevant product IDs to an offer. Relevant products are products that are not explicitly part of the offer but which you intend to count as responses.

Procedure

  1. Choose Unica Campaign > Offers.
  2. Create an offer or open an offer for editing.
  3. Click Import product IDs in the Relevant products section of the New offer page.

    The Select products dialog opens.

  4. Copy product IDs from your source file.
    Note: The source content can include one or more of the following delimiters: tab, comma, linefeed, newline. Multiple consecutive delimiters are ignored. If product IDs are text strings, spaces are not stripped and case is preserved.
  5. Paste the IDs into the Import product IDs list. You can also manually add, edit, or delete entries from the list. There is no limit to the number of entries that you can add to the list.
  6. Click Import.

    The IDs from the Import product IDs area are imported and listed in the Select products where section, with "PRODUCTID =" prepended to each product ID. If any errors are detected during import (for example, alphabetic characters when the Product ID field is numeric, or exceeding the maximum string length for a text product ID), you see a pop-up for each error. Note each error and click OK to view the next error.

    Note: The Import feature only imports a product ID once. Duplicate occurrences of the same value are ignored.
  7. Click Save and test query to confirm that the query gets results.

    When the results are displayed in the View selected products dialog, you can either click Edit query to return to the Select products dialog or click Finish to save and exit.

    Note: You can continue to paste and import product IDs until you click Save in the Select products dialog or Finish in the View selected products dialog. After you close the View selected products or the Select products dialog, you cannot import additional IDs. If you click Import product IDs again, your existing IDs will be cleared unless you click Cancel.
    The product IDs from the Select products where list are saved as a query for the offer, and the IDs are added to the Relevant products list on the offer page.
  8. Save the offer.

What to do next

If you want to remove items from the list of Relevant products, select an item (or use Ctrl+click or Shift+click to select multiple items), then click Remove selected. If you want to test the query again, use Test query. If you want to edit the query, click Edit query. For instructions, see Using Edit query to create or edit relevant products for an offer.