How do I export data from my intervention?
How to export data from your intervention on the LifeGuide Server
Please note that downloading a large amount of data can slow down the server (for LifeGuide researchers and study participants) so we recommend specifically selecting the variables that you need and only downloading data when it is necessary.
- Log in and select your intervention by clicking on the image or the magnifying glass
- Under the Interventions Operations table, click on View/Export Detailed Statistics. This will open a new page called Intervention Sessions. This page includes general details of the use of the intervention including the number of individual sessions (these are the number of times end-users have logged on and used the intervention) and a list of all the individual sessions, including the date the end-user logged on and the total duration of time they spent in that session. To see detailed statistics from individual sessions, including a diagram showing the pages visited by the end-user, click on the ID number of an end-user. To export the data please follow the instructions below.
- Click on Export Data
- This will open a new page called Export Intervention Data.
You will have several options available to you:
- File Format: Select either Excel (2007+) or Comma Separated Value (CSV).
- Data sheets to export: All four options are selected by default:
- Sessions Details: This option creates a data sheet that shows the responses given to interactions on pages, e.g. responses to single-choice and multiple-choice questions, the date picked on a calendar.
- Session Page Flow: Shows the order each end-user viewed the pages in the intervention and the time (in seconds) they spent on each page. This sheet will list each session on a separate row and will group all the sessions for each user together. In the sheet, the last page viewed is always 'unknown' because the page name and duration can only be recorded when a button is click on a page - end-users' typically close their browsers or shut down their computer when they finish using a website.
- Page Durations: Shows the total time (in seconds) that users spent on each page.
- User data: Shows the data collected from variables you have specified in the logic of your intervention, e.g. whenever you use the 'savevalue' logic function, this information is saved and can be exported to the User Data sheet. Variables are listed in alphabetical order in User data.
- Export all sessions since: This allows you to export sessions from a given date. The default option is the date the intervention was uploaded.
- Session sheet style: This allows you to choose between exporting with One line per session where each intervention session appears on a separate row (so the data for one user who logged in several times will be displayed in different rows - one line per session), or One line per user where multiple sessions for each end-user appear on the same row. There is a session count to One line per user so if the same variable is used more than once, you can see all the data entered for that variable, e.g. if you asked an end-user to enter their weight on the same page every week, the variable "weight" will show as weight#1, weight#2, etc., for each session - #1 is their first session, #2 is their second session and so on.
- Include anonymous sessions: This option allows you to choose whether to include sessions that are not associated with a registered user.
- Column header format: This allows you to select between 3 different formats for the Session Details column titles.
- Variable Names Only: Only displays the name of your variables. This is the best option if each variable in your intervention has a unique name and you know what it relates to.
- Prefix Page Name (e.g. page.variable): Displays the page name, then the variable name. If you have variables which have the same name and appear on different pages, select this option or Suffix Page Name.
- Suffix Page Name (e.g. variable.page). Displays the variable name, then the page name.
- Extra Columns: This allows you to export additional information about users.
- User identifier: This is the end-user's username.
- User number: This is an automatically generated number which is unique across all LifeGuide interventions on the server. You may wish to use this if you need a unique identifier between interventions (Usernames may not be unique as the same username can be used to register with different interventions).
- Session number: This option will annotate an end-user's sessions incrementally (i.e. their first session will be labelled 1, their second 2, and so on).
- Session time: This is the date and time each session started.
Fields to include in Session Details
Intervention variable names
Here you will see a list of the user variables which are written in your logic, e.g. if you have added sections to your logic (
begin ... end ) , you will see these duration variable names here.
Page variable name Here you will see a list of all the variable names (or unique response names) of the interactions in the intervention.
- Select the data you wish to export. You can choose the Select/Deselect all option at the top of the page or select only the variables you wish to include in your data set.
- Click on Export and you can then choose to open or save the file that is generated.