Creating reports

Created: - Updated:

When in the reports view, you can easily define a custom report.

To create a new report:

  1. Enter the reports view (for example, in the projects list, click a project and then, in the toolbar above the list, click see reports).
  2. Click the reports tab.
  3. Click create custom report.
  4. Set the report options, as described below.
  5. Click create.

Option

Description

Report name

Enter a name for the report (this is mandatory, although the name does not have to be unique).

Display data (single/slider/ranking questions)

Applies to single-coded, multi-coded, slider and ranking questions.

Determines the format of the data displayed in the report:

  • Text label: the actual text of each choice option;
  • Alias: any alias values that you have defined for the choice;
  • Id: the answer ID for each choice.

Display 'selected' for multi questions

Applies to multi-coded questions. If you select this option, the following information is included in the report:

  • 1: displays binary 1/0 giving 1 for selected choices and 0 for non-selected ones
  • Text label: displays the label of the selected choices and 0 for non-selected ones
  • Alias: displays the alias value of the selected choices and 0 for non-selected ones
  • ID: displays the id of the selected choices and 0 for non-selected ones

Time & date format

Defines the format for time and date questions included in the report.

Meta-data

Select the meta-data items, including local variables, to be included in the report as columns in the report. You can quickly select all (or none) of the meta-data items by selecting meta-data (select all/none). For details of each of the meta-data items, please see report columns below.

Tip: To include global variables in the report, you should save its value in a local variable within the survey.

Question list

Select the questions you want to include in the report. You can quickly select all (or none) of the questions by selecting questions (select all/none).

Include media

If this option is selected, a zip file will be included with the report, containing any images and videos uploaded by respondents.

Remote server

When you specify a remote server, the data is automatically pushed to it, in JSON or CSV format.

Report columns

You can choose to add any of the following meta-data as a column in your report, by selecting the corresponding box.

Meta-data item Description
Entry ID A unique ID, that distinguishes each entry in the report (each survey run).

Entry Type

Indicates the entry type (this is the status code assigned to each data entry coming from a mobile device). The possible entry types are as follows:

Complete: an accepted entry, where the respondent is qualified for the study and he has completed all the questions.

  • Screened-out: an entry made by a respondent who did not qualify for the study.
  • Quota-full: an entry where the respondent was qualified for the study, but where the target quota has already been achieved.
  • Incomplete: an entry where the respondent has started the survey, but hasn't completed it.
  • Paused: an entry where the respondent has paused the survey before completing it.
Username

This is the username used by the respondent to log in into the app (it is unique per respondent).

Upload time The time when this entry was uploaded to the server.

Start time

The time when the respondent started making this entry.

End time

The time when the respondent completed the survey (i.e. finished the last entry, before the upload).

Device Timezone The time zone of the respondent's device.
Device Timezone offset

The time zone, in the format of GMT offset (e.g. GMT+2 for Finland).

Survey revision The revision number of the survey, as stated in the survey XML (this is useful if you modified your survey after some entries were made).
Survey wave The wave number, as stated in the survey XML.
Length (sec)

The duration of the entry in seconds. If surveys are paused, the pause time is not taken into account.

Entry location The GPS location of the respondent (longitude and latitude).

Raw location data

String containing the raw location data as uploaded from the device.
Preview Flag for preview entries 
Geo-fence name Name of the geo-fence that generated the survey entry . For further details on Geo-location reports, please see Geo-location reports.
Trigger location latitude Latitude of the geo-fence that generated the survey entry. For further details on Geo-location reports, please see Geo-location reports.
Trigger location longitude Longitude of the geo-fence that generated the survey entry. For further details on Geo-location reports, please see Geo-location reports.
Trigger location accuracy Accuracy of the GPS measurement when the current survey entry was triggered. For further details on Geo-location reports, please see Geo-location reports.
App version The version of the Lumi Say app used to take this survey (e.g. 2.7).
OS name The Operating System of the respondent's device (e.g. Android).
OS version The version of the Operating System of the respondent's device (e.g. 6.0.1).
Device make The name of the respondent's device manufacturer (e.g. Apple).
Device model The name of the respondent's device model (e.g. iPhone7,2).

Device type

The name of the respondent's device type (e.g. iPhone7,2). For more details, see device type below.

Device type details

The device type report column displays the model of the respondent's device. iOS devices return things like "iPhone7,2" (see the list below) while Android devices return a model name or number.

Model ID

Device

iPhone1,1

iPhone (Original)

iPhone1,2 iPhone 3G
iPhone2,1 iPhone 3GS
iPhone3,1 iPhone 4 (GSM)
iPhone3,2 iPhone 4
iPhone3,3 iPhone 4 (CDMA)
iPhone4,1 iPhone 4S
iPhone5,1 iPhone 5 (GSM)
iPhone5,2 iPhone 5 (CDMA)
iPhone5,3 iPhone 5C (GSM)
iPhone5,4 iPhone 5C (Global)
iPhone6,1 iPhone 5S (GSM)
iPhone6,2 iPhone 5S (Global)
iPhone7,2 iPhone 6
iPhone7,1  iPhone 6 Plus
iPhone8,1 iPhone 6s
iPhone8,2 iPhone 6s Plus
iPhone9,1 iPhone 7
iPhone9,2 iPhone 7 Plus
iPhone9,3 iPhone 7
iPhone9,4 iPhone 7 Plus
iPhone10,1 iPhone 8
iPhone10,2 iPhone 8 Plus
iPhone10,3 iPhone X
iPhone10,4 iPhone 8
iPhone10,5 iPhone 8 Plus
iPhone10,6 iPhone X
iPod1,1 iPod Touch (1st generation)
iPod2,1 iPod Touch (2nd generation)
iPod3,1 iPod Touch (3rd generation)
iPod4,1 iPod Touch (4th generation)
iPod5,1 iPod Touch (5th generation)
iPad1,1 iPad (Original)
iPad2,1 iPad 2 (WiFi)
iPad2,2 iPad 2 (GSM)
iPad2,3 iPad 2 (CDMA)
iPad2,4 iPad 2 (Early 2012)
iPad2,5 iPad Mini (WiFi)
iPad2,6 iPad Mini (4G)
iPad2,7 iPad Mini (4G)
iPad3,1 iPad (3rd generation) (WiFi)
iPad3,2 iPad (3rd generation) (4G)
iPad3,3 iPad (3rd generation) (4G)
iPad3,4 iPad (4th generation) (WiFi)
iPad3,5 iPad (4th generation) (4G)
iPad3,6 iPad (4th generation) (4G)
i386 iPhone Simulator
x86_64 iPhone Simulator