To view orphaned contacts, query the _MobileLineOrphanContactView data view in Automation Studio. Contacts are orphaned when a GroupConnect contact import has multiple ContactKeys for the same LINE Address ID.
- In Contact Builder, create a data extension with the fields in the data view and add a column of NowDate with type Date.
- In Automation Studio, create an automation and add a SQL query.
- Within the SQL Query activity, query the _MobileLineOrphanContactView data view and
select the target data extension you created in the first step. For example:
Select convert(varchar, getDate(), 20) as NowDate, * from _MobileLineOrphanContactView..
Columns
| Name | Description | DataType | Data Extension Data Type | Nullable |
|---|---|---|---|---|
| ContactID | Marketing Cloud Engagement ContactId (system generated) linked to LINE UID | bigint | Number | |
| ContactKey | ContactKey is either system-generated or provided by user during import. Linked to LINE UID | nvarchar | Text | |
| AddressID | LINE UID | nvarchar | Text | |
| CreatedDate | Date and time record created (in Central Standard Time). Date the customer started following LINE account. | datetime | Date |