File Formats


The preferred format is character delimited files. Tea Leaves also accepts fixed-length records on an as needed basis. All files should be submitted in standard ASCII text file format

File Format Requirement
Delimited Delimited files must be submitted in standard comma, pipe or tab delimited formats. Microsoft Excel and relation formats like DBF are not accepted.

Format details:
  • -Please include a header row with field names
  • -Use backslash (\) as the escape character for embedded double quotes (")
  • -No other backslashes allowed
  • -No non-printable characters


Field Formats

Field Format Requirement
Name Must be provided as 2 separate fields.
  • -first_name
  • -last_name
Address Must be provided in separate fields:
  • -address1: Street number and street name
  • -address2: Apartment or suite number
  • -zip: 5-digit character field, Zip + 4 optional
Phone Accepted with or without hyphens and parentheses
Dates Format as a 8-character string field:
"YYYYMMDD"



File Naming Conventions

  • -Template: '{Client ID}_{Description}_Touchpoint_{Data Period}_{Date of Submission}.txt'
  • -Example: 'UHS_PrimaryUpload_Touchpoint_2011Q1-2012Q4_20130129.txt'
  • -NOTE: The keyword 'Touchpoint' or 'TPFile' must be present in the filename for our automated system to process your submission.

Format Component Description
Client ID Short Name/ID of organization
Description
  • -Use any description such as call center name, class name, event name etc.
  • -Name of file will appear on the API for selecting, sorting, including, excluding, deleting, viewing file stats.
Date Period Start and End dates of data included in file
Date of Submission
  • -Date the file is submitted to Tea Leaves
  • -Can be a single date stamp for one-time or non-routine submissions



Touch Point Data File Layout and Data Dictionary

Download Template

Legend: R = Required Field

Field Field # R Field
Type
Notes / References
date 1 R Date YYYYMMDD
first_name 2 R Alpha
last_name 3 R Alpha
address1 4 R Alpha
address2 5 Alpha
city 6 R Alpha
state 7 R Alpha
zip 8 R Alpha Both 5-digit and 9-digit (Zip+4) accepted
dob 9 Date YYYYMMDD
email 10 Alpha
phone 11 Alpha ##########; 10 digit number no spaces or dashes
mobile 12 Alpha ##########; 10 digit number no spaces or dashes
tlh_campaign_id 13 Alpha This is the campaign ID generated for your TLH outbound communications
ip_address 14 Alpha IP address in standard format
type 15 R Alpha This value will represent the top level organizational folder structure that will appear in the Query Builder under Touch Points inside of the folder named inbound/Affinity. Values should be one of the following:
Call Center, Classes and Events, Lists, Web, Other
sub_type 16 R Alpha This value will represent the primary selection of this touch point in the TLH application and should be representative of a value the end user will find easy to use. Example of use would be April 2013 Classes, Google Pay Per Click, Referral, etc.
sub_type_list 17 Alpha This set of values will define the multi select values available for additional selection options. Examples might include specific class names or sources from your PPC campaigns, Call Center Referral type, etc.
dns 18 Alpha Set this value to 'Y' if the person is to be marked as Do Not Solicit for future mailings. The person will still be included in reporting of already ran campaigns and research queries.
**If the purpose of the whole list is do not solicit and not appear for selection on query builder or show up on reporting use type "Lists" sub_type "DNS".

Need full access to this site?

To get a username / password for this site please contact Don Larson. don.larson@welltok.com


Important Notice

TEA LEAVES HEALTH ACCEPTS NO LIABILITY AND EXPRESSLY DISCLAIMS RESPONSIBILITY FOR ANY DATA POSTED BY USERS CONTAINING **ANY** INDIVIDUALLY IDENTIFIABLE HEALTH INFORMATION (IIHI) OR PROTECTED HEALTH INFORMATION (PHI). ANYONE DESIRING TO POST IIHI OR PHI DATA OR IF THEY ARE NOT AWARE IF THE DATA CONTAINS IIHI OR PHI SHOULD CONTACT TEA LEAVES HEALTH AT 404-526-8307 PRIOR TO ANY POSTING.