Marketo Field Limits by Field Type | Community
Skip to main content
A
Anonymous
June 22, 2017

Marketo Field Limits by Field Type

  • June 22, 2017
  • 19 replies
  • 23752 views

Issue


Several types of fields in Marketo have requirements for the type of data that can be stored, as well as the limit to how much data can be contained in that field type. The Custom Field Type Glossary can tell you what fields are available, and this article will show you details on the type and maximum limits for those fields. 

 

Field Types & Limits

Boolean

Can only be set to “true” or “false” (stored in the database as 1 or 0).

 

Currency

Maximum value of 9223370000000000000.  Will be displayed with the currency set in your instance under Admin -> Location.

 

Date

Must be formatted “MM/DD/YYYY”.

 

Datetime

Must be formatted “MM/DD/YYYY HH:MM:SS”.

 

Email

Must be a properly formatted email (user@example.com).

 

Float

Can include decimals up to the hundredths place.  The value will round to the nearest hundredth (eg. 99.999 rounds to 100, 99.985 rounds to 99.99).  Maximum value of 10000000000.

 

Formula

See this guide: Create and Use a Concatenated String (Formula) Field 

 

Integer

Values are limited to between -2147483647 to 2147483647.

 

Percent

Must be a full number without decimals.  Maximum value of 9223370000000000000.

 

Phone

Can have letters, numbers, or characters.  Maximum of 2,000 characters.

 

Score

Maximum score of 2147483647.  If the score is increased higher than that, the score will reset to -2147483647.

 

String

Can contain letters, numbers and special characters.  Limit of 255 total characters

 

Text Area 

Can contain letters, numbers and special characters.   Limit of 65,535 total characters

 

URL

"http://"  will automatically be appended to the value if the value doesn't have that prefix or "https://" already.  Does not have to be formatted any further (Generic top-level domain not required).

 

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    19 replies

    A
    Anonymous
    June 22, 2017

    Are you sure the date restrictions are right? Back when I was at Marketo, I saw a list of the accepted formats for importing into date fields and there were at least half a dozen options if not more. Are you talking about how Marketo will reformat it once you put it in? Clarification on that would be great.

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    June 22, 2017

    They're definitely not right, Kristen. Dates are input as ISO. Some other range issues here as well... going to do a response on my blog.

    T
    TMatrix11
    Level 3
    July 28, 2017

    @Sanford Whiteman​  Hi Sanford,  Can you point me to the response on your blog for this topic? 

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    July 28, 2017

    I haven't pubbed it yet, but do you have specific questions/clarifications? I can answer them here.

    T
    TMatrix11
    Level 3
    July 28, 2017

    At the moment no, but interested in the blog when you are ready.   I have tons of questions about other things, most specifically the sync between Marketo/SFDC (which can relate to field mapping best practices--would that be in your blog?) 

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    July 28, 2017

    Not sure that I'll get too far into the SFDC side, but I'll mention two concerns now.

    One is that SFDC long text area can be allocated either fewer characters or more characters than a Marketo Text Area's (fixed) maximum. Both will cause sync problems.

    Similarly, an SFDC int (which is Int32) cannot sync with a Marketo Int64 without potential data loss. You have to use an SFDC double.

    Kelly_Sheetz
    Kelly_Sheetz
    Level 2
    August 21, 2017

    Does URL field type have a character limit?

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    August 21, 2017

    Yes, it's 255 characters.

    This isn't only Marketo's doing, since syncing to an SFDC URL type field has the same restriction. Plus, in technical DNS terms a domain name cannot exceed 253 characters.

    You'd think, then, this wouldn't cause any problems. Just be wary of using this data type for for full URLs, because they do not have a 255-character real-world restriction. You could have truncated data and, in rare cases, an unusable URL.  For example, say you try to store the full referrer URL as the website (lacking the inbuilt ability to truncate to just the domain name):

         www.example.com/some/long/pathname/and/?query=parameters&that=end&up=being_longer_than_255_characters

    It's feasible that the query string contains some value that, if arbitrarily truncated, makes the URL return a 404.

    Also see Marketo field limits in the real world, Part II: URL is for domain names, not full URLs

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    June 22, 2018

    @Roxann McGlumphy​ not all String fields are limited to 255 characters. In fact some have a lower limit, and some can store up to 2000 characters. This latter point can cause immense confusion when building a data warehouse, since the API does not reflect limits above 255 even though actual stored values can be longer (so you'd truncate data if you limited the field to 255).

    Roxann_McGlump1
    Roxann_McGlump1
    Level 5
    June 22, 2018

    I didn't write this article, but my understanding is that it is specific to how Marketo handles string fields, not on string fields in general.  Do you have an example of a Marketo string field with a limit higher or lower than stated in the article?

    Show more replies
    Terms & ConditionsAccessibility statement

    Loading footer...