1. Home
  2. Samba
  3. User Guides
  4. Database Administration

Database Administration

With Samba, administration of your database is all done by you, including reassigning a user’s subscription preferences, importing databases, or simply deleting a user.

In this guide, we’ll show you how its all done.

DATABASE ADMINISTRATION

To get started, click the gear icon on the top-right corner of the screen, which will tak you to your Settings. From there, click the “Database” tab to open it (as shown below).

From here, you can enter the email addresses you wish to change the settings of one by one or upload an entire list.

Please note that when uploading a list, it must be a CSV file and can only contain e-mail addresses (one address per line) without delimiters. Here’s an example of that format:

test1@eshop.cz
test2@eshop.cz
test3@eshop.cz
test4@eshop.cz

After you’ve entered the list of email addresses, select the desired Action you wish to be performed.

The entire list of email addresses you input (regardless of how they’re added) will be affected by the same Action:

  • Add customers to message distribution –  this will subscribe your customers to your email/newsletter distribution (even if they previously unsubscribed). For unknown addresses, the system will offer their import (see “Add new customers”).
  • Remove customers from message distribution – this will unsubscribe your customers from the distribution list.
  • Add new customers – Imports email addresses and adds them as customers. If they’re already listed as customers, they will be subscribed to your email/newsletter distribution by default.
  • Delete customers  – The customer linked to the email will be irretrievably removed from your database (this deletion also affects future attempts to import such an address).



After you’ve selected the desired Action, press the “Execute action” button (as shown below) to confirm the action.

If you wish to export your database, click the “Export database to CSV” button, which will be exported as a CSV file.

Please note!

Duplicate emails (regardless of uppercase / lower case) will be automatically removed.

Changes made to your database will take effect during the next update (usually within 24 hours).

Audience

In the “Database” section you will also find a sub-section called “Audience”, which allows you to filter you customer based on your segments.

Using the button “Apply Filter” you can confirm your filtering and in the bottom part of the screen you will see every customer who fits into the chosen segment.

Under the Filtering part of the screen you can also choose the newsletter frequency: Every Day for people who are subscribed to your newsletter, or Special Occasions. In the Samba Enterprise version you will also find frequency called Never, which will segment only those customers, who are not subscribed to any kind of newsletters in your e-shop.

On the right side of the e-mail address you can (under the “Detail” button) find detailed information about specific customer: When did he register, what exactly did he buy or how much was his total spending on your e-shop.

In the Samba Enterprise version you can also export all audiences into the .CSV file for your own purposes.

This post is also available in: Čeština (Czech)

Updated on October 21, 2019

Was this article helpful?

Related Articles