---
schema_version: "1"
id: 908602a87b13ed67002385ce573324311662d2b20a517ad3ba401a1b0a8bd206
title: "Data View: GroupConnect MobileLineOrphanContactView"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_as_data_view_orphaned_contact.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_orphaned_contact.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: aa6cc61c62ef58f17012b38560493894656c811427353f8ed2515ff21b7b1d7c
description: 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.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Data View: GroupConnect MobileLineOrphanContactView

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](https://help.salesforce.com/s/articleView?id=mktg.mc_cab_create_a_new_data_extension.htm&language=en_US) 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_use_the_sql_query_activity.htm&release=264.0.0&type=5 "In Automation Studio, build a SQL query activity that retrieves the data that you’re interested in, and then add it to an automation.").
- 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 |  |