File Import Wizard

The File Import Wizard is one of the ways you can add profiles into your Audience. With it you can import a file containing profile data that you have previously gathered with consent. You may add, update, delete or unsubscribe the profiles contained in the file.

Have you created a Consent list and Topics yet? This is necessary in order to import profiles, since they must be imported into a Topic in an existing Consent list. Jump to Consent lists and Topics...

Click on the Add a New Profile button on the Profiles tab in Audience to begin the File Import Wizard.

Adding & Updating Profiles

How to Add and Update Profiles

You can enter the File Import Wizard either by clicking Import Profiles on the Profiles tab in Audience:

FileImportWizard01.jpg

 

Or by clicking Add a New Profile anywhere in Audience:

shortcuts_02.jpg

 

Import Type

1. Click Add & Update on the first step of the wizard.

FileImportWizard02.jpg

 

To Add means to import a file containing profiles that do not exist in your APSIS One Audience, and to Update is to import a file containing new or additional information on profiles that already exist in your APSIS One Audience. Whether you will be adding new profiles, updating existing ones, or both, depends on the contents of the file you import.

 


 

Import File

1. Click on Choose file and select the file from your computer. The file format must be in a .CSV format, (UTF-8). A regular CSV file set to show as columns will look roughly like this:

CSV_02.jpg

 

By choosing a file to import, you guarantee that you have collected the information in the file with consent, and that all individuals have chosen to opt-in for your communications.

The maximum file size for imports is 10MB.

FileImportWizard03.jpg

 

The file may contain as many fields as you find necessary. The first row in the file must be the type of data, and the following rows must contain the data.

The date format supported is ISO-8601.

Make sure the phone numbers contain the country code and phone number in the same column, with no spaces or zeros at the start. The country code is mandatory.

For example: +460793699558, +46793699558, 460793699558, 46793699558.

 

2. Click Next after choosing your file.

FileImportWizard04.jpg

 


 

Consent list & Topics

1. Choose which communication channels are present in the list you're importing.

If you have consent for SMS communications, tick the SMS box. For Email communications, tick the Email box. You may skip this step if you don't want to add the profiles into a Consent list

FileImportWizard05-1.jpg

 

  Do you have consent?

If you intend to add profiles into a Consent list, you must make sure that you indeed have their consent. Importing profiles that have previously unsubscribed into a Consent list will re-subscribe them. Remove any profiles you don't wish to re-subscribe from your file before importing. For now, this is an option that cannot be changed.

resubs_02_02.jpg

 

2. Expand the select Consent list drop-down menu and choose a list, then hover over it and click on the Topics you wish to add profiles into. The Topics chosen will have a green dot next to their name.

If you wish to remove a Topic, simply click on it again.

Consent lists and Topics must be created in advance. Read more about Consent lists and Topics...

 

FileImportWizard06.jpg

  

3. Click Next to add the profiles to a Consent list. If you don't want to add these profiles into a Consent list, click Skip instead.

FileImportWizard07.jpg

 


 

Mapping

Let's make sure all the information in the file gets imported into APSIS One by matching the data fields with profile properties.

Begin by taking a look at your file separately; it might also help to look into your account's data sections and go through your profile attributes and tags settings.

 

1. Choose a key column from the drop-down menu.

Key Columns are those which contain the data that you will be identifying or creating the profiles with.

This option is only for those who clicked Skip in the previous step.

This does not necessarily mean that these profiles have provided their consent for you to communicate with them through those channels, but rather it serves as an identifying factor. Choose between CRM-Id, Mobile or Email.

FileImportWizard08.jpg

 

2. Choose a channel consent column from the drop down menu, to match a column from your file with an APSIS One consent channel.

The Channel Consent column will show the channel or channels that you chose on the previous step. Here you will map out Email address or phone number the profiles provided with their consent with their corresponding profile attributes in APSIS One.

FileImportWizard10.jpg

 

3. Click the drop-down menu under Attribute and select the attribute that matches the data from your file's column.

The wizard will auto-detect the columns and their names. Match your columns with the right profile properties.

FileImportWizard11.jpg

 

4. Once you're done, click Next.

FileImportWizard12.jpg

 


 

Import Options

1. Tick the corresponding boxes to implement different rules to the logic of your file import in the case of duplicates, empty fields, existing lists and Topics.

FileImportWizard13.jpg

 

These are the options:

Update profile attributes

Tick this box if you want the profile data imported to overwrite data on existing profiles in APSIS One. This would only affect the existing information, so if the file contains data that the existing profile doesn't, it will add it into the profile. If left unticked, there will be profile duplicates with different data.

updateoptions_02.jpg

 

Reset profile attributes

If your file does not contain information that exists in a profile in your present Audience, this option will erase the information in the platform that is not present in the file. This option allows users to bulk erase data from profiles existing in Audience while, at the same time, updating the information on new and existing profiles.

If you don't what to erase conflicting fields, simply do not tick this option. Conflicting fields will be ignored.

updateoptions_03.jpg

 

 About Tags

Tags are internal markers that can be manually applied to profiles. In the File Import Wizard you have the option to tag the profiles you import so that later you can locate them easily.

Another advantage is to tag the profiles in order to create a segment for your next sending, although in the Send to step of both Email and SMS tool you can also filter the recipients by tag. Some businesses may have recurrent imports to match their internal data systems, and tagging the profiles in this Wizard will simplify the task of communicating with the right audience. Read more about segmentation...

2. Click on the Select tag drop-down menu to Tag the profiles created as a result of the import, so that they can be easily found in the future.

To create a new tag, click Create new tag, add your tag text and click Save.

FileImportWizard14.jpg

 

3. Done? Click next.

FileImportWizard15.jpg

 


 

Overview

1. Take a last look at your file import. Make sure that you chose the correct Consent list, channel, import options, etc.

If you need to modify anything, you are free to track back to any step on the left side navigation.

FileImportWizard18.jpg

 

2. Have you double checked everything? Once you click Import, the changes cannot be undone.

FileImportWizard16.jpg

 

3. When you're ready, click Import. Click Cancel to quit the File Import Wizard.

FileImportWizard19.jpg

 

Unsubscribing Profiles

How to Unsubscribe Profiles

You can enter the File Import Wizard by clicking Add a New Profile on the Profiles tab in Audience.

FileImportWizard20.jpg

 


 

Import type

1. Click on Unsubscribe on the first step of the wizard.

To Unsubscribe the profiles in your file means to remove them from one or more lists and Topics they have subscribed to.

FileImportWizard21.jpg

 


 

Import File

1. Click on Choose file and select the file from your computer. The file must be in CSV format.

The maximum file size for imports is 10MB.

FileImportWizard22.jpg

 

The file must contain the channel data in order to unsubscribe the profiles, regardless of what other fields there are in the file. The channel data is an Email, phone number or CRM ID.

 


 

Mapping

1. Choose a key column from the drop-down menu to match with profile properties.

Key Columns are those which contain the data that you will be identifying the profiles with. Choose between CRM-Id, Mobile or Email.

FileImportWizard23.jpg

 

2. Click on the attributes drop down menu to select an attribute to match your key column.

FileImportWizard24.jpg

 

3. Done? Click Next.

FileImportWizard25.jpg

 


 

Overview

1. Take a last look at your file import. Make sure that you chose the correct Consent lists and Topics to unsubscribe the profiles from.

If you need to modify anything, you are free to track back to any step on the left side navigation.

FileImportWizard26.jpg

 

2. Have you double checked everything? Once you click Unsubscribe, the changes cannot be undone.

When you're ready, click Unsubscribe. Click Cancel to quit the File Import Wizard.

FileImportWizard26.1.jpg

 

Deleting Profiles

How to Delete Profiles

You can enter the File Import Wizard by clicking Add a New Profile on the Profiles tab in Audience.

FileImportWizard27.jpg

 


 

Import type

1. Click on Delete on the first step of the wizard.

Deleting profiles will remove all the data you've gathered into the profiles you import in the file. This will also unsubscribe them from all communications they've subscribed to in any point in time.

FileImportWizard28.jpg

 


 

Import File

1. Click on Choose file and select the file from your computer. The file must be in .CSV format.

The maximum file size for imports is 10MB.

FileImportWizard29.jpg

 

The file must contain the channel data in order to delete the profile, regardless of what other fields there are in the file.

 


 

Mapping

1. Choose a key column from the drop-down menu to match with profile properties.

Key Columns are those which contain the data that you will be identifying the profiles with. Choose between CRM-Id, Mobile or Email.

FileImportWizard30.jpg

 

2. Click on the attributes drop down menu to select an attribute to match your key column.

 

 

3. Done? Click Next.

FileImportWizard31.jpg

 


 

Overview

1. Take a last look at your file import. The number of profiles about to be deleted will show up in the warning, so make sure that number matches the number of profiles in your file before you confirm.

If you need to modify anything, you are free to track back to any step on the left side navigation.

FileImportWizard32.jpg

 

2. Have you double checked everything? Once you click Delete, the changes cannot be undone.

When you're ready, click Delete. Click Cancel to quit the File Import Wizard.

FileImportWizard33.jpg

 


 

 

Was this article helpful?