Field Types

Here is a description of field types in Marketo.

Field Type

Description

Example

Datetime Used for a date & time. Follows W3C format (ISO 8601). The best practice is to always include the time zone offset.

Complete date plus hours and minutes:

YYYY-MM-DDThh:mmTZD

where TZD is “+hh:mm” or “-hh:mm”

2010-05-07T15:41:32-05:00
Email A string type field which accepts email addresses example@example.com
Float A number field which contains of Real Numbers and can use a decimal place. 10.4
Integer Whole numbers 10
Formula Fields whose values are generated by manipulating data from other fields present on a lead record. They are not exported and can not be used in a Smart Campaigns. Please see this article on docs.marketo.com
Percent A percentage expressed as an integer 30
URL A text type field which restricts input to URLs, including the protocol of the URL. http://example.com/
Phone Phone number 111-111-1111
Textarea Longer text.

Supports up to 30,000 bytes.

Standard ASCII characters use 1 byte per character (allowing up to 30,000 characters).

Unicode characters may use up to 4 bytes per character (reducing the  number of characters allowed to less than 30,000 characters).

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
String Shorter text (up to 255 characters) Lorem ipsum dolor sit amet
Score An integer type field which can be manipulated with the Change Score flow step 10
Boolean(previously Checkbox) Allows users to select a True (checked) or False (unchecked) value. True
Currency A float type field which represents the default currency type selected for the Marketo Subscription 10.40
Date Used for date. Follows W3C format. 2010-05-07
Reference A string type field containing a key to another record (a foreign key). Contact Company