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 will create a data sheet which 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.

- Aggregated 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.

• 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, 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" where each variable which is used more than once is numbered, 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 time they enter their weight.

• 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.