A relational table is a table of fields that describe a listing of data, enabling you to expand the data available on your contact records exponentially. When you use this feature, you can conveniently utilize large bunches of data in queries and segmentation, dynamic content, and personalization in emails.
Example: email campaign based on location data from purchase history
Purchase history or any other data that you have from other systems can also be placed into a relational table and used to qualify contacts for queries, emails, automated messages, or programs.
When you have a long list of items, such as zip codes, use a relational table with all zip codes that are classified by region, state, or city instead of listing them all. Create a relational table and upload a .zip code database list. Link that table to your database by your contact's zip code field.
When you build a query or create a rule for a program step, select Relational table, then create the criteria of all contacts in the desired region, state, city, or area.
Note: Contact sources for programs do not include child relational tables.
If you are unable to add a query that contains relational table criteria as the contact source for a program, then contact client support to enable this feature.