To view active LINE followers and users who have blocked your brand, query the data view in Automation Studio. With Contact Subscriptions, you can view your current subscribers each day.
Prerequisites
Enable the business rule SYSTEM_DATA_VIEWS on your account and set it to 1. Your account is checked upon load of the GroupConnect app, and if it doesn't exist, it’s created. To access this view for the first time, a user or admin within the Business Unit must navigate to the GroupConnect channel app. This step triggers the creation of the view.
Follow these steps to view LINE follower information.
- 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 _MobileLineAddressContactSubscriptionView data view
and select the target data extension you created in the first step. For example:
Select convert(varchar, getDate(), 20) as NowDate,* from _MobileLineAddressContactSubscriptionView.
Tip All times listed are Central Standard Time.
Tip To track
LINE followers who have blocked your channel, compare daily lists to look for users who are no
longer listed.
Columns
| Name | Description | DataType | Data Extension Data Type | Nullable |
|---|---|---|---|---|
| ChannelID | Channel ID of LINE account | nvarchar | Text | |
| ContactID | Marketing Cloud Engagement ContactId (system generated) linked to LINE UID | bigint | Number | |
| ContactKey | Marketing Cloud Engagement contact key (system generated) linked to LINE UID | nvarchar | Text | |
| AddressID | LINE UID | nvarchar | Text | |
| IsActive | Active flag: (1 = true, 0 = false) | bit | Number | |
| CreatedDate | Date and time record created in Central Standard Time. Date the customer started following LINE account. | datetime | Date | |
| ModifiedDate | Date and time record modified in Central Standard Time | datetime | Date | X |