6.1. Email Opt-in Report#
The data package includes a report of data collected across all of an institution’s edx.org or edge.edx.org courses. This report is typically more useful to administrative or marketing teams, rather than research teams.
When learners enroll in a course on edx.org, they can specify whether they want to receive email from the organization that presents the course.
The email-opt-in/{org}-email_opt_in-{site}-analytics.csv file reports the
email preference selected by each learner enrolled in your institution’s
courses. You can use this information to develop a distribution list for
campaigns that introduce new or related courses to learners.
Note
Your data package includes a .csv file only for the edx.org
site. Learners can specify an email preference only on edx.org.
The file contains data in these columns.
user_id,username,email,full_name,course_id,is_opted_in_for_email,preference_set_datetime
6.1.1. user_id#
The learner’s ID in auth_user.id. For more information, see
Columns in the auth_user Table.
History: This column was added in Jan 2017.
6.1.2. username#
The learner’s username in auth_user.username. For more information, see
Columns in the auth_user Table.
History: This column was added in Jan 2017.
6.1.3. email#
The email address that the learner used to register a user account on the
site. For more information, see the auth_user.email
column.
6.1.4. full_name#
The name that the learner supplied. For more information, see the
auth_userprofile.name column.
6.1.5. course_id#
The ID of the course run in which the learner is enrolled. For more
information, see the student_courseenrollment.course_id
column.
6.1.6. is_opted_in_for_email#
True or False. By default, this preference is set to True. If a learner is enrolled in more than one course, the option that the learner selected most recently applies to all of the courses.
6.1.7. preference_set_datetime#
Indicates when the learner selected this preference. If a learner is enrolled in more than one of your institution’s courses, the date and time when the learner most recently selected an email preference applies to all of the courses.