A list's columns hold your contacts' information (company, first name, birthday…). To choose which ones are shown, add, rename, move, retype or delete columns, open the list in Sarbacane Contacts, then ••• › Manage columns.
Access to Sarbacane Contacts.
A standard list, or a list fed by the API.
Important: on a list synchronized with another tool, the columns come from that tool. Don't change them in Sarbacane Contacts: the next synchronization would overwrite your changes. Change them in the source tool. Lists fed by the API are the exception: you can manage their columns here.
In the left menu, open Contact lists, then click the list.
At the top left, next to the list name, click •••, then Manage columns. The Manage the columns window opens.
To show or hide a column in the list table, tick or untick the box to the left of its name.
To add a column, click New column at the bottom and give it a name.
To rename a column, click its name and edit it. To move it, hover over its row and drag it with the ⠿ handle that appears on the left.
To change a column's type, open the Type list on its row and choose Simple text field, Number type field or Date type field. For a date, then choose the format that matches your data (for example DD/MM/YYYY): an Example: is shown for each format.
Caution: deleting a column permanently erases its data for every contact in the list. To simply stop seeing it, untick it instead (step 3).
To delete a column, hover over its row and click the trash icon that appears on the right.
At the bottom of the window, click Validate. If you deleted a column, confirm the deletion.
Note: greyed-out columns (Email, Mobile phone number, Engagement score, Source, consent…) are managed by Sarbacane. You can show or hide them, but not rename, retype or delete them.
The list table shows the ticked columns, in the order you chose. Hiding a column only changes the table display: its data stays in the list. After a type change, a confirmation message appears (on a large list, « Your columns are being updated » appears first).
Best practice: give your date columns the date type. A targeting can then use date conditions ("is later than", "is between"…).
The list is synchronized with another tool: the synchronization replaced your changes with the source tool's columns. Make the changes in that tool.
Switch the column to Date type field and choose exactly the format of your data (order of day, month and year, separator, optional time).
Some values in the column don't match the chosen type: for example text in a number column, or a date in a different format from the one selected. Correct these values or choose the right format, then try again.
It is a Sarbacane column (greyed out). You can only show or hide it.