User Data Table

A user data table is an additional source of characteristics (Eg: Email, Address) of your contacts that can be then used to personalize and target campaigns.

The contact details added to a user data table does not alter or impact a contacts details that is available on the CE panel contact master.

Campaign Targeting

Campaigns with user data table as the target audience can run on the following:

Campaigns:

• Email
• SMS
• APN

Thumb rule

Users associated in a user data table MUST be present in the contact master for them to be communicated to.

In essence, if a user exists in a user data table but is not present in the panel contact master - the user will be automatically be added to the contact master. However, only the primary key of the user gets added, attributes pertaining to the user remain in the user data table.

Creating a User Data Table

The process of creating a user data table and uploading contacts into it follows the same pattern as uploading list on CE.

📘

Points of note

• CSV to be uploaded into a user data table must include the panel primary key as the first column.
• For executing SMS and Email campaigns on user data table, email and mobile handles must be present on the user data table.
• Editing a User Data Table: Updating or editing users on a existing data table is not supported.
• Attribute values on a data table once set cannot be altered.
• No limit to the number of user data tables, however 45 days “non-usage” archival policy will be in place.

Campaigns

Campaigns with user data table as the target audience can run on the following:

Campaigns:

• Email
• SMS
• APN

Campaign

A campaign on CE is setup in the following manner:

Reports

As user data table is an additional data source of targeting and personalizing a campaign, reports for such campaign will be from the same source.

While downloading a custom detailed report or scheduling a detailed report, the data source will need to be selected.

For a contact master campaign report, select “Contact master. For a User Data Table campaign report, select “User Data Table” (With all attributes being sent on the report).

📘

Points of note:

• If a User data table is deleted, reports for campaigns which used said user data table will not be available.
• For a custom detailed report or a report scheduled with multiple campaigns, report will consist of a zip file with separate CSVs for the campaigns.

Other Impact areas

• Segmentation
  Segmentation on user data table attributes is not supported currently. However, segmentation on activity can be done.
• Following features work as is and would see no changes
  Suppression list
  Slicing
  Frequency capping
  Set limit
  Hepf
  STO
  Maker - checker