This article lists the different email states in the database.

Introduction

After an invitation (or reminder) mailing has been sent to a batch of respondents from a sample list, CCA provides a fast way to view the email status (email read, email bounced, email has lead to a finished interview, etc.).

This view is the list monitor, which provides a "statistics on mails" tab.

But sometimes this is not precise enough and a specific respondent email status is required. This information about an individual email state can be found in the SQL Lists database.

How to

To access the details for a specific sample list . . .

1. Check the list's ID by double clicking on the list from the Supervisor interface:
   
2. Open SQL management studio and browse the Lists database. The information about the list with ID XX will be contained in the table named AskEmailXX

AskType field

0 = invitation mail.
1 = first reminder.
2 = second reminder, etc.

AskState field

Here, CCA codes the last state for a specific address.
The result will give the emailing status:

AskLastWebResult field