List Data Tables

List data tables are a variation of normal data tables. They allow data to be imported to a list, and for that data to stay specific and accessible to that list only. This allows you to use the same fields across an account, but to maintain siloed, list-specific, data that can co-exist without being overwritten.

Note: List Data Tables are not compatible with the Automation Program Builder and our Zapier integration

On this page:

Benefits of a List Data Table

The data imported will only be visible when browsing that list or a launch that went to that list. This means that multiple users can import different data to a list data table, mapping to the same field, using different lists, and all of the values can co-exist without being overwritten.

For example, many marketing systems make use of a "segment" code that is different for each use of the contact; list data tables can be useful if you need to preserve details like this, when multiple users are working with lists that could potentially contain the same contacts, but with different "segment" codes.

Once created, list data tables appear alongside normal data tables in the data table list.

Example Use of List Data Tables

Many marketing systems make use of a "segment" code that is different for each use of the contact; list data tables can be useful if you need to preserve details like this, when multiple users are working with lists that could potentially contain the same contacts, but with different "segment" codes.

For example: I have a landlord (John Smith), he has multiple houses in different authoritative regions. My account is set up so that I have a list for every authoritative region, but they all use separate Landlord IDs.

With my list data table, I use the fields: "authority", "member_id" and "residence_count".

Then, when importing to a list, my data for John Smith is retained only for the list I imported to. Meaning I can hold all of his Authority information, maintain the dedupe on his email address, and use only one data table.

List Name authority member_id residence_count
West Ox Landlords West Ox WOX378 4
Bedfordshire Landlords Bedfordshire BEDS-2004 2
Notts Landlords Nottingham LL-45-9 7

Once created, list data tables appear alongside normal data tables in the data table list.

Creating List Data Tables

Creating a list data table follows the same process as creating a normal data table, using the 'Create Data Table' link in the data table list.

Note: Like normal data tables, once created a list data table cannot be deleted. Also, data tables cannot later be changed to list data tables; this must be done during the initial creation.

To create a list data table, select the List data check box in the creation form.

When you import data into a list, you map fields to a list data table in exactly the same way as a normal data table. For help on mapping data fields, please refer to the Importing help documentation.

FAQ

Note: This FAQ applies to both data tables and list data tables

Can I delete data tables?

No, it is not possible to delete data tables. If you need help organising your account, contact your account manager or Adestra Customer Support (adestra-support@uplandsoftware.com).

How many data tables can I create?

You can create as many data tables as you need, however if you think you need to create a significant number, contact Adestra Customer Support (adestra-support@uplandsoftware.com).

How many fields can a data table contain?

Data tables can contain up to approximately 100 fields, however tables this large could potentially be slow or cause problems due to their size.

Is there a character limit to the field contents?

Yes, all fields are limited to 255 characters, the only exception being 'Large Text' fields, which have a limit of 9,999 characters.

Can I rearrange the order of the fields in data tables?

No, the data table fields cannot be rearranged, they will appear in the order in which they were added.

Can I change the workspace a data table is assigned to?

If the visibility of the data table is set to a specific workspace, you have the option to change it to be available in all workspaces.

Note: Once you have changed the visibility to all workspaces, this cannot be reversed.