_MobileLineOrphanContactView
Orphaned ContactKeys from GroupConnect imports when multiple contacts share the same LINE Address ID.
Schema last reviewed 2026-06-17
Opens _MobileLineOrphanContactView in the interactive canvas with SQL Sandbox.
Orphaned ContactKeys from GroupConnect imports when multiple contacts share the same LINE Address ID.
Schema last reviewed 2026-06-17
Opens _MobileLineOrphanContactView in the interactive canvas with SQL Sandbox.
| Field | Type | Flags | Relations | Description |
|---|---|---|---|---|
ContactID |
Number | PK, FK | _MobileLineAddressContactSubscriptionView.ContactID | Marketing Cloud Contact ID. |
ContactKey |
Text(255) | PK, FK | _Subscribers.SubscriberKey | Orphaned contact key. |
AddressID |
Text(255) | PK, FK | _MobileLineAddressContactSubscriptionView.AddressID | LINE UID shared with the retained contact. |
CreatedDate |
Date | — | — | Record creation timestamp (CST). |
SELECT TOP 100
ContactID, ContactKey, AddressID, CreatedDate
FROM _MobileLineOrphanContactView
WHERE CreatedDate >= DATEADD(day, -30, GETDATE())
ORDER BY CreatedDate DESCValid 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.