Archive > Uncategorized > Data Extension Field Names and Usage

please note that everything in bold is a required field

General Data Extension

  • email_address – Email – 254 – Maps to Subscriber Key
  • subscriber_key – text – 254
  • first_name – text – 50
  • last_name – text – 50
  • phone_number – text – 50
  • phone_number – phone – used possibly for SMS in Journeys
  • street_address_1 – text – 100
  • street_address_2 – text – 100
  • city – text – 100
  • state – text – 50
  • zip_code – text – 50
  • gender – text – 50
  • birth_year – text – 50
  • date_created – datetime – Current Date
  • category – text – 50
  • subcategory – text – 50
  • all_data – text – 3
  • utm_source – text – 50
  • utm_term – text – 50
  • utm_content – text – 50
  • utm_medium – text – 50
  • utm_campaign – text – 50
  • is_test_data – text – 50 – false
  • schedule_appointment- text – 50 – false
  • more_information – text – 50 – false
  • has_processed – text – 50 – false

API Data Extension

  • email_address – Email – 254 – Maps to Subscriber Key
  • subscriber_key – text – 254
  • first_name – text – 50
  • last_name – text – 50
  • phone_number – text – 50
  • phone_number – phone – used possibly for SMS in Journeys
  • street_address_1 – text – 100
  • street_address_2 – text – 100
  • city – text – 100
  • state – text – 50
  • zip_code – text – 50
  • gender – text – 50
  • birth_year – text – 50
  • date_created – datetime – Current Date
  • category – text – 50
  • subcategory – text – 50
  • all_data – text – 3
  • utm_source – text – 50 query string parameter
  • utm_term – text – 50 query string parameter
  • utm_content – text – 50 query string parameter
  • utm_medium – text – 50 query string parameter
  • utm_campaign – text – 50 query string parameter
  • is_test_data – text – 50 – false We will clean out any record with a value of true in the processing pixel
  • schedule_appointment- text – 50 – false
  • more_information – text – 50 – false
  • has_processed – text – 50 – false This will get set to true once leads get processed

Trigger Send Data Extension Thank You Email

  • EmailAddress- Email – 254 – Maps to Subscriber Key
  • SubscriberKey – text – 254
  • date_created – datetime – Current Date
  • category – text – 50
  • subcategory – text – 50
  • all_data – text – 3

Trigger Send Data Extension Service Email

  • EmailAddress- Email – 254 – Maps to Subscriber Key
  • SubscriberKey – text – 254
  • user_email – text – 254
  • date_created – datetime – Current Date
  • category – text – 50
  • subcategory – text – 50
  • all_data – text – 3

Journey Entry Data Extension

  • email_address – EmailAddress – 254
  • category – Text – 50
  • subcategory – Text – 50
  • all_data – Text – 3
  • date_created – Date – Current Date

Your email address will not be published. Required fields are marked *