_MobileAddress

MobileConnect contact demographics (unsupported but still populated). BU-scoped; underscore-prefixed column names required.

Schema last reviewed 2026-06-17

Open Interactive Workspace All data views

Opens _MobileAddress in the interactive canvas with SQL Sandbox.

Fields (20)

Field	Type	Flags	Relations	Description
`_MobileID`	Number	PK, NULL	—	MobileConnect contact ID.
`_ContactID`	Number	—	—	Global Contact ID.
`_MobileNumber`	Text(15)	—	—	Mobile number with country dial code, no + prefix.
`_Status`	Number	NULL	—	Contact status code.
`_Source`	Number	NULL	—	Contact source code.
`_SourceObjectId`	Text(255)	NULL	—	Source object ID when _Source = 10.
`_Priority`	Number	NULL	—	Priority among multiple numbers (1 = primary).
`_Channel`	Text(50)	NULL	—	Legacy channel field.
`_CarrierID`	Number	—	—	Mobile carrier code.
`_CountryCode`	Text(2)	—	—	Two-letter country code.
`_CreatedDate`	Date	—	—	Contact created date.
`_CreatedBy`	Date	—	—	Created-by metadata (legacy type).
`_ModifiedBy`	Text(255)	NULL	—	Last modifier.
`_City`	Text(100)	NULL	—	City.
`_State`	Text(100)	NULL	—	State.
`_ZipCode`	Text(20)	NULL	—	Postal code.
`_FirstName`	Text(100)	NULL	—	First name.
`_LastName`	Text(100)	NULL	—	Last name.
`_UTCOffset`	Number	NULL	—	Hours offset from UTC.
`_IsHonorDST`	Boolean	NULL	—	Whether the timezone observes DST.

Example query

SELECT TOP 100
  _MobileID, _ContactID, _MobileNumber, _Status, _Source, _SourceObjectId
FROM _MobileAddress

Valid in Query Studio and Automation Studio Query Activities. GROUP BY is only needed for aggregates; ORDER BY is optional but recommended with TOP so rows are meaningful. Narrow date ranges on large tracking views to avoid timeouts.