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:

MASTER_SUBSCRIBER

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 <thead> </thead> <tbody> </tbody>
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 <thead> </thead> <tbody> </tbody>
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.
}