Mozillians/Phonebook/Exact-Target

From MozillaWiki
Jump to: navigation, search

This wiki captures the details of Mozillians integration with exact target (ET)

Summary

When a new user is vouched, they are automatically added to an ET mailing list and specific profile data is sent to ET. Users can opt-out of this mailing list by following the unsubscribe links contained in emails and going to the mozilla.org newsletter management page.

Subscribe & Unsubscribe

  • Users are subscribed and data is sent to ET upon vouch
  • To unsubscribe users must follow the links sent in ET emails
  • If a user deletes their vouched account on mozillians they are unsubscribed from this ET list
  • If either subscribe or unsubscribe requests fail (due to timeout etc), we will retry the request or if it continues to fail throw an email error

Default ET List

The name of the newsletter we subscribe users to: MOZILLA_PHONE

ET Data

Data is written to the following tables:

  1. MASTER_SUBSCRIBER
  2. PHONEBOOK

If you don't want the welcome email to be sent, send trigger_welcome='N' along with your other data.

Master_Subscriber Data

The following data is written to the MASTER_SUBSCRIBER table

Field Description
Email Email address of subscriber
Token Unique token of user
MOZILLA_PHONE_FLG Y
MOZILLA_PHONE_DATE Date flag set
Country User country
Modified date Date record last updated
Email Format T or H for Text or HTML

Phonebook Data

The following data is written to the PHONEBOOK

Field Description
Country country of subscriber
City city of subscriber
SYSTEMS_ADMINISTRATION 'Y' if user belongs to this group.
BOOT2GECKO 'Y' if user belongs to this group.
LOCALIZATION 'Y' if user belongs to this group.
QUALITY_ASSURANCE 'Y' if user belongs to this group.
CREATIVE 'Y' if user belongs to this group.
METRICS 'Y' if user belongs to this group.
MARKETING 'Y' if user belongs to this group.
POLICY 'Y' if user belongs to this group.
WEB_DEVELOPMENT 'Y' if user belongs to this group.
CODING 'Y' if user belongs to this group.
SUPPORT 'Y' if user belongs to this group.
UX 'Y' if user belongs to this group.
COMMUNICATIONS 'Y' if user belongs to this group.
PROGRAM_MANAGEMENT 'Y' if user belongs to this group.
LABS 'Y' if user belongs to this group.
WEBFWD 'Y' if user belongs to this group.
SECURITY 'Y' if user belongs to this group.
DEVELOPER_DOCUMENTATION 'Y' if user belongs to this group.
DEVELOPER_TOOLS 'Y' if user belongs to this group.
MOBILE 'Y' if user belongs to this group.
THUNDERBIRD 'Y' if user belongs to this group.
APPS 'Y' if user belongs to this group.
EVANGELISM 'Y' if user belongs to this group.
GRAPHICS 'Y' if user belongs to this group.
LEGAL 'Y' if user belongs to this group.
ADD-ONS 'Y' if user belongs to this group.
AUTOMATION 'Y' if user belongs to this group.
RECRUITING 'Y' if user belongs to this group.
PERSONA 'Y' if user belongs to this group.
BUSINESS_DEVELOPMENT 'Y' if user belongs to this group.
PEOPLE 'Y' if user belongs to this group.
ACCESSIBILITY 'Y' if user belongs to this group.
FUNDRAISING 'Y' if user belongs to this group.