Skip to main content

File Import: Unsubscribe Profiles

Unsubscribe many Profiles at once from one or more Subscriptions, using a CSV or XLSX file.

File Import: Unsubscribe Profiles

The Unsubscribe import is a streamlined version of the File Import Wizard: pick a file, choose which Unique Identifier to use, choose which Subscription to unsubscribe from, map the identifier column, and review. The Profiles stay in Audience — only their consent for the chosen Subscription is removed.

In this Article

Before you begin

💡 Check your file first: The file needs a column with the same Unique Identifier you use to recognise the Profiles in Apsis One (Email, Mobile or CRM ID). Other columns are ignored. Make sure there are no duplicates in the identifier column. See the File Import Checklist for full preparation steps.

ℹ️ What Unsubscribe does: Unsubscribe removes the Profile's consent from the chosen Subscription. The Profile and all its data remain in Audience — only its Subscription state changes. To remove a Profile and its data entirely, use Delete Profiles instead.

💡A tip: Ensure you use proper naming of the file as the name of the file is what you see in the report overview page.

How to Unsubscribe Profiles with File Import

Start the import

  1. Go to Audience Profile tab and click Add a new Profile to find all import options.

  2. Select to import From File.

  3. Choose Unsubscribe.
    ​

    OR

  1. Go to Audience - Imports tab and click Import profiles to find all import options

  2. Choose Unsubscribe.

File

  1. Click Insert file and select the file from your computer. We support CSV and XLSX files up to 50 MB. Read more about supported file formats.
    ​

ℹ️ Note: The file must contain a Unique Identifier (email, phone or CRM ID) used to recognise the Profile — regardless of any other columns in the file.


​

Unique ID & Subscription

  1. Select the Unique ID for the Profiles you wish to unsubscribe.
    ​


    ​

  2. Choose which Subscription the Profiles should be unsubscribed from.
    ​

  3. Click Next.

Mapping

  1. Map the Unique Identifier column in the file so the system can identify which Profiles to unsubscribe.
    ​


    ​

  2. Check that the Consent address mapping is auto-mapped or pick the correct column from the drop-down. Click Next.
    ​

Overview

  1. Review your choices. When ready, click Unsubscribe — or click Cancel to quit.
    ​

File Import Report

Take a look at the File Import Report to learn more about the results of your import — how many Profiles were successfully unsubscribed and how many failed.

Use Cases

Honouring opt-outs collected outside Apsis One

Your customer service team logs opt-outs in your CRM. Export the list, import with Unsubscribe using CRM ID as the Unique Identifier, and remove them from the relevant Subscriptions in one go.
​

Suppressing competitors or internal addresses

Maintain a list of email addresses you do not want to send to, and import it as an Unsubscribe whenever the list changes.
​

Unsubscribing from one Subscription, keeping another

A list of Profiles no longer wants Product Updates but still wants the Newsletter. Run an Unsubscribe import targeting only the Product Updates Subscription — Newsletter consent is unaffected.
​

Cleaning up after a campaign that prompted opt-outs by other means

Some recipients replied "remove me" by email. Compile the list, import it as Unsubscribe to ensure the next send respects their request, then keep the Profiles around for analytics.

Troubleshooting

❓ Some Profiles in my file were not unsubscribed.
Open the File Import Report and check the Failed and Not Changed tabs. Common causes: the identifier in the file does not match any Profile in Apsis One, the identifier column was not mapped correctly, or the Profile was not subscribed to the chosen Subscription to begin with.
​

❓ I unsubscribed Profiles by mistake — can I undo it?
Unsubscribing is reversible. Use File Import: Add & Update with the same file, place the Profiles in the same Subscription, and tick Re-subscribe Profiles who have opted out from Subscription. You must have documented consent before re-subscribing anyone.
​

❓ I want to unsubscribe Profiles from all my Subscriptions at once.
The Unsubscribe wizard works on one Subscription at a time. Either run the import once per Subscription, or use the same file repeatedly with a different target Subscription each time.
​

❓ Should I use Unsubscribe or Delete?
Use Unsubscribe when you just want to stop sending to the Profile but keep its history. Use Delete when you need to remove the Profile and all its data entirely — for example, to honour a GDPR right-to-erasure request.
​

❓ My identifier column did not auto-map.
If column headers in your file are unusual, the wizard may not detect the right column. Manually pick it from the drop-down in the Mapping step.

What's Next?

Did this answer your question?