Salesforce Marketing Cloud Data Views: _MobileLineAddressContactSubscriptionView (GroupConnect – LINE Channel)

Posted on by admin

The _MobileLineAddressContactSubscriptionView data view in Salesforce Marketing Cloud (SFMC) allows users to track active LINE followers and those who have blocked your LINE account via the GroupConnect channel. This view is essential for analyzing subscription status and maintaining an accurate contact base for LINE-based communications.

⚠️ Prerequisites:

  • Ensure the business rule SYSTEM_DATA_VIEWS is enabled and set to 1 on your account.
  • A user or admin must access the GroupConnect app in the business unit to initialize the creation of this data view.

What is the _MobileLineAddressContactSubscriptionView Data View?

This data view contains contact subscription data for LINE (via GroupConnect), showing whether users are actively subscribed (i.e., following) or have blocked your brand. It enables marketers to identify, segment, and manage their LINE messaging audiences.

Key Benefits

  • Follower Tracking: Know exactly who is still following your LINE account.
  • Block Awareness: Identify contacts who have blocked your brand.
  • Audience Health Analysis: Improve segmentation and campaign targeting.
  • Cross-Channel Contact Matching: Use ContactID or ContactKey to join with other channel data.

Fields in _MobileLineAddressContactSubscriptionView

FieldTypeDescription
ContactIDNumberSFMC system-generated Contact ID linked to the LINE UID.
ContactKeyTextExternal identifier (usually mapped to LINE UID). Used for cross-channel joins.
ChannelIDTextChannel ID of the LINE account (e.g., your business LINE channel).
AddressIDTextLINE UID of the user. Unique identifier for each LINE user.
IsActiveNumberIndicates active subscription status (1 = following, 0 = blocked).
CreatedDateDateTimestamp when the user started following the LINE account. (CST timezone)
ModifiedDateDateLast modification to the subscription status. (CST timezone)

When and Why to Use _MobileLineAddressContactSubscriptionView

When to Use?

  • To identify current active LINE followers.
  • To segment users who have blocked your brand.
  • When building audiences for LINE messages.
  • To audit subscription growth or decline over time.

Why Use It?

  • Improve Deliverability: Focus on active users to maintain high engagement.
  • Cross-Channel Matching: Link LINE behavior with email, SMS, and push using ContactID.
  • Behavior Analysis: Understand who blocks/unfollows and when.
  • Campaign Optimization: Suppress inactive or blocked users.

Sample SQL Queries

1. List All Active LINE Followers

SELECT ContactKey, AddressID, CreatedDate 
FROM _MobileLineAddressContactSubscriptionView 
WHERE IsActive = 1

2. List Users Who Blocked the LINE Account

SELECT ContactKey, AddressID, ModifiedDate 
FROM _MobileLineAddressContactSubscriptionView 
WHERE IsActive = 0

3. New LINE Followers This Week

SELECT ContactKey, CreatedDate 
FROM _MobileLineAddressContactSubscriptionView 
WHERE IsActive = 1 
AND CreatedDate >= DATEADD(day, -7, GETDATE())

4. Active vs. Blocked LINE Users

SELECT IsActive, COUNT(*) AS TotalUsers 
FROM _MobileLineAddressContactSubscriptionView 
GROUP BY IsActive

5. Track Modified Subscriptions in the Last 30 Days

SELECT ContactKey, IsActive, ModifiedDate 
FROM _MobileLineAddressContactSubscriptionView 
WHERE ModifiedDate >= DATEADD(day, -30, GETDATE())

Conclusion

The _MobileLineAddressContactSubscriptionView data view is an invaluable tool for businesses using LINE through GroupConnect in Salesforce Marketing Cloud. It empowers marketers to track user engagement, analyze channel health, and make data-driven decisions when sending LINE messages.

Combine this view with Contact Builder data and campaign performance insights to build a comprehensive multi-channel engagement strategy.

Related Posts