_MobileLineAddressContactSubscriptionView

GroupConnect LINE follower subscriptions (active and blocked). Requires SYSTEM_DATA_VIEWS business rule and GroupConnect app visit to provision.

Schema last reviewed 2026-06-17

Open Interactive Workspace All data views

Opens _MobileLineAddressContactSubscriptionView in the interactive canvas with SQL Sandbox.

Fields (7)

Field	Type	Flags	Relations	Description
`ChannelID`	Text(255)	PK	—	LINE channel ID.
`ContactID`	Number	PK, FK	_MobileAddress._ContactID	Marketing Cloud Contact ID linked to LINE UID.
`ContactKey`	Text(255)	FK	_Subscribers.SubscriberKey	Contact key linked to LINE UID.
`AddressID`	Text(255)	PK	—	LINE user ID (UID).
`IsActive`	Number	—	—	Active follower flag (1 = true, 0 = false).
`CreatedDate`	Date	—	—	Follow / record creation timestamp (CST).
`ModifiedDate`	Date	NULL	—	Last modification timestamp (CST).

Example query

SELECT TOP 100
  ChannelID, ContactID, ContactKey, AddressID, IsActive, CreatedDate
FROM _MobileLineAddressContactSubscriptionView
WHERE CreatedDate >= DATEADD(day, -30, GETDATE())
ORDER BY CreatedDate DESC

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.