Creating a Member Profile Table

Overview

MessageGears enables clients to work directly off of existing data schemas, requiring no data mapping or additional synchronization. This can be done through direct SQL queries utilizing the native SQL functionality of each distinct database, allowing users to leverage the power of their internal databases directly.

However, in many cases a small amount of foundational work can enable the marketing team to fully leverage the functionality of our Drag & Drop Audience Builder, providing autonomy to the Marketing team. Below are a few recommendations for developing a client view that best supports an independent marketing team.

Table of Contents

• Member Profile Attributes
• Customer Identifier
• Opt-in / Suppression Attributes
• Engagement Metrics
• Additional Fields

Member Profile Attributes

Customer Identifier

Used as the RecipientId within our platform. This value is returned with each activity generated by our platform.

customer_id (integer)

Opt-in / Suppression Attributes

Used to identify the status of each recipient, to avoid mailing invalid or unsubscribed users.

opt_in_status (boolean)
opt_in_timestamp (timestamp)
opt_out_timestamp (timestamp)
invalid_email (timestamp)

Engagement Metrics

Used to perform segmentation of recipients based on engagement date / rates. Important for deliverability monitoring and segmentation.

last_open (timestamp)
last_click (timestamp)
last_mailing (timestamp) 

Localization Fields

Used to localize message content and optimize delivery windows.

locale (varchar(20)) 
user_timezone (varchar(20))

Contact Fields & Preferences

Used to identify which contact channels are available to each recipient, and set a designated preferred contact channel for marketing or transactional alerts.

email_address (varchar(256))
sms_address (varchar(256))
device_id (varchar(256))
device_service (varchar(256))
channel_preference (varchar(256))

Additional Fields

There might be additional fields that are vital to support your marketing team's day-to-day activities. If you want to consult with us about the best solution for your needs, please feel free to open up a ticket with Support or send a note at support@messagegears.com and someone from our Solutions team will be happy to help.