The Tables are used to store data held structured format within a Database. There are different aspects to tables which can be used for writing MYSQL queries. Tables are formed with the insertion of Columns and Rows.
A table has a specified number of columns but can have N number of rows. Each row is identified by one or more values appearing in a particular column subset. The columns subset which uniquely identifies a row is called the primary key. In Maropost, tables are the very useful aspect of storing data and based on that different queries can be written to fetch details.
In order to create a new Table in Maropost please follow the mentioned steps.
(Note: The feature has to be activated with special request.)
- Hover on the ‘M’ logo at the top-left side and click on ‘Email’ option from the drop-down menu.
- Here, hover over ‘Contacts‘ and click on ‘Tables‘, again hover over contacts and click on ‘New table’.
- An entirely new page will open, on the paged opened there is an option to give a name to the table and add as many columns to it.
The first empty space is to give a name to the column of the table, i.e. email, ID, sex etc. The next option is to select the Datatype for the associated column. There are different datatypes which are defined briefly below.
(i) String: The String is a sequence of characters, which can either be a constant or a variable. The strength for the datatype is 255. The value can also be left blank for the datatype.
(ii) Integer: An Integer is a whole number which can be positive, negative, or zero. The maximum value for the data type is 11. The value for the datatype can be left blank.
(iii) Boolean: The datatype has two values True or False. The algebra is denoted as 1 or 0 respectively.
(iv) DateTime: The datatype is used to set the column for DateTime. The datatype can also be set as null.
(v) Text: The datatype is used to put the ‘Text‘ entities in the column. The maximum limit for the datatype is 65535 bytes.
(vi) Email: An Email is a datatype which can only store the email address of the contact. It is the only column in Maropost which can be set as sendable for tables.
- After selecting the datatype for the column, correspondingly we can give a Default value to it. The default value depends upon the datatype selected. The column can also be kept blank.
- The next option found on the page is of ‘Feild length‘. Here, we can set the maximum value for the column, keeping a thing in mind, there is already a maximum value set for every datatype at the backend which cannot be exceeded.
- Now, we can set a behaviour for the column created for the table. The first option is of ‘Auto-Increment’. It works as the automated process to increase the value for the column.
‘Primary Key‘ is a uniquely identifying constraint for each record in the database. It should contain unique values. The primary key cannot contain a null value. A table can only have one primary key set.—–
The column can be set ‘Allow Null’ if no value needs to be provided. An empty data can be imported if the column has been set as allow null.
In all the data types, an email can be set as ‘Sendable’. It is also identified as a unique entity for the contact.
In Maropost, tables can be used in Campaigns, Segments, and Workflows. There are separate API’s for Tables in Connections, also for every specific table. Please follow below the usage for the option.
Campaigns: We’ve the option to send the campaign to a particular table. It can be selected from the first page of the campaign creation.—–
Segments: Active contacts can be fetched from segments using the tables filter. In segments, columns for the corresponding table can be selected to add the specification for the contacts.—–