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.