Demographics: Tables

Virtual Database Tables are database views that you can create and populate with data. You can create an unlimited number of these virtual tables, and they will all be available for use as tables within the Demographics system.

Path: Admin Toolbar > Advanced > Demographics > Tables

(1) Edit Virtual Table Name

This screen lets you define/edit a Demographic Virtual Table. At present, the only field to define for a Demographic Virtual Table is the name of the table. The shorter the name, the better.

  • Table Name (*): This is the name of your table. It is best of this is as short as possible.
  • Description: (Optional)
  • Virtual Table: Actual name of database, it is view-only field
  • Save Record

The actual name of the Virtual Table, which will be slightly different than the name you enter, is also be displayed as a view-only field.

(2) Add Demographic Table

Once a Demographic Virtual Table is created you can begin adding records to that virtual table and you can connect the virtual table to a Demographic Field.

 

  • Table Name (*): This is the name of your table. It is best of this is as short as possible.
  • Description: (Optional)
  • Virtual Table: Actual name of database, it is view-only field
  • Save Record
  • Deleted: Use this option to review deleted Virtual Tables

(3) Record Count

Add Demographic Record Tables

This screen allows you to create new Demographic Data records in a Virtual  Demographic Table. The records you enter here can be used as data fields in a Demographic Data Sets pull down fields.

  • Name: Name the field that will be part of the pull down fields
  • Save Record

To return back to the Demographics Table screen click on Virtual Tables.

Attaching a Virtual Database Table to a Demographic Field

If you have created a Virtual Database Table you must go into the Demographics Fields section and attached the Virtual Database Table to the Field Name.

Path: Admin Toolbar > Advanced > Demographics > Fields > [Select Name of Field]

To attach a Virtual Database Table to a Demographic Field you will need to complete the following steps:

  1. Name: Click on the Name that you would like to attach the newly created Table to.
  2. Data Type: Must be set to T - Linked to a table
  3. Click on the Table dropdown and select the Table you would like to attach to the Demographic Field
  4. Click Save Record