A Global Data Table is typically used to store content that is not recipient specific. This could be publication data, product data, or brand data. You use Global Data Tables to store a series of Global Data in Global Data Table fields.
When creating a new Global Data Table, you choose what types of data the Global Data Table fields can contain. The data types you can choose to use for the are number, date, timestamp, string, and boolean. You can also see the type of data fields in Table 1 below.
It's important to note that Global Data Tables are not linked to recipients by default, but a link can be made by creating a data lookup.
How to Create a Global Data Table
- Log into Staging.
- Open the Data module.
- Open the Global Data section.
- Click the Global Data Tables folder.
- Click the Create icon in the Folders toolbar.
- Select 'Global Data Table'.
- The start of your new Global Data Table will appear in the work area to the right.
- Fill in a name for your Global Data Table in the 'Name' Field.
- Optional: add a description of your Global Data Table.
- Click 'Save'.
Creating a new Global Data Table in the 'Data' module
- Click on the Global Data Table in the list in the middle work area.
- Click the Create icon in the 'Folders' toolbar.
- Choose 'Number' or 'String' - this will create the Primary Key used for your Global Data Table.
- The Primary Key for your Global Data Table will appear in the work area to the right. The Primary Key is used to identify the different rows of your Global Data table such as when importing data. Because of this, the Primary Key will always be unique.
Adding an ID to the Global Data Table 'BRAND_CATALOG'
- Fill in a name for your Primary Key in the Name field.
- Optional: add a description in the Description field.
- Click 'Save'.
Your Primary Key has been created and you're ready to add the Global Data Fields used to contain your data.
- Click on the Global Data Table in the list in the middle work area.
- Click the Create icon in the 'Folders' toolbar.
- Choose the data type you want to create your next Global Data Table field as. See Table 1.
- Fill in a name for your Global Data Table field in the Name field. If you plan to use an Advanced Lookup with two different Global Data Tables, we recommend you make the names of the fields unique across the two Global Data Tables.
- Optional: add a description in the Description field.
- Click 'Save'.
- Repeat the steps until you have as many Global Data Table fields as you need.
- Do a Publish to Production to make your Global Data Table ready for Production recipients.
We advise you to never create your Global Data Table directly on Production. Always create it on Staging and then do a publish to Production. Read more about our Best Practice on Workflow here.
A Global Data Table named 'BRAND_CATALOG' with a Primary key called 'ID' and several other Global Data Fields used to store Global Data about brands
Your Global Data Table is now ready to have data imported. Learn how to import data here.
Data Type: | Description: | Example Global Data Table Field | Example Value: |
Boolean | Can either be true or false | ACTIVE | TRUE |
Date | Can contain a date | ANNIVERSARY | 01.06.2019 |
Number | Can contain numbers | ID | 2 |
String | Can contain any value including letters and numbers | NAME |
Agillic Candy |
Timestamp | Can contain a date and time | NEXT_SALE |
23.11.2018 12:00:00 |
Table 1: Data Types in Agillic with Global Data Table Field as examples