Under the 'data' tab, you'll find an overview of all exports or you can create an export. Only persons with the role of data-analyst or data-officer can create an export.

Be aware that a data officer can export, edit, distribute and store all privacy-sensitive information present in the platform. Be very careful when assigning someone to this group!

Data exports

  • This documentation is meant to explain how to interpret the data that is available. For practical purposes we will show you examples in excel, but the more durable solution for working with bigger amounts of data would be to connect with a (BI)tool via our REST API
  • Please also note Minddistrict already has a beta version of a data dashboard that might already show you the information you need. If you would like to request access to this dashboard, please contact the Minddistrict Servicedesk via the regular route. 

Basics of data exports

Creating an export

When you have the role of data analyst or data officer, you have the option to create an export. The exports are divided into different categories:  

  • Users
  • Tools
  • Communication
  • Signups (if it is configured on a platform that clients can register themselves (anonymously). 

You can select an export and continue to step 2 (fields).
  1. Step 1 - Select the export you want to run
    Which exports you see here depends on the configurations of your platform.
    For example: you can only select an export on videocalling if this feature is available on your platform
  2. Step 2 - Select the fields you want
    In this step 2 you will see which fields the export can contain. Some fields are selected by default. When you hover over the information icon with your mouse, you'll see more information about the fields.
  3. Step 3 - Select output type
    Default CSV is selected, you can change this to Excel.
    In the right column you can find more information about the export. Missing fields or are there to much fields? You can return to step 2.
    Note: Larger data files may take quite some time to download. You will receive a notification when the task is completed.

Excel tips

We will not provide you with explanations on manage data in Excel, but we will share some helpful Microsoft documentation links on functions that can be helpful if you do decide to work with Excel.

Adding (sum)https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89
How to combine 2 exports into one using V.Lookuphttps://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
How to make a pivot tablehttps://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576

Mobile modules

In order to work with the data of (mobile) modules we would like to explain more about Minddistrict (mobile) modules. We will show you three perspectives:

  1. The way modules are built by the content editor in the Content Management system (CMS)
  2. The way modules are shown to the end-user (professional)
  3. What you will find in the data exports

We will start with the first two, because it gives a good idea on the perspective of these users and helps you to translate their questions into a data report. We will also provide you with an example of an actual module; the module ‘Learn to relax’ (so if all fails, please follow that module to keep calm…). 

1.    Module creation; perspective from a content editor

In the Content Management System (CMS) a content editor can built a module consisting of chapters. Every chapter consists of one or more pages. A content editor can add ‘special’ pages to a module:

  1. A milestone, intended to ‘reward’ the client for their progress.
  2. A sending moment, lets a client finish the steps and submit his answers. Answers cannot be changed anymore. Depending on the setup of the module possibly the professional is asked for feedback or the client can proceed without a feedback step in between.
  3. An optional section, displaying content the client can choose to do or not do 
  4. Reusable pages, ‘building blocks’ with generic content that can be used in multiple modules (for example: a block of 3 pages showing an explanation on how to do a relaxation exercise)

The Module as seen in the CMS, in this case a sending moment (submission)

A content editor can look at a module set up based on:

  1. Division in chapters
  2. Division in milestones
  3. Division in sending moments (submissions)

The Module as seen by the CMS user, divided into chapters, milestones and submission moments

2.    Perspective for the end-user (professional)

For the professional there is the concept of a module consisting of chapters. Every chapter contains one or more pages. A page can show content elements (e.g. text/multimedia/questions), a milestone or a sending moment. 

 The first step of the module Learn to relax, as seen by the professional in the catalogue

There are ways to customize the module for a client. For example, a professional has the possibility to add more than 1 module to a client; either parallel or behind one another. A professional also has the possibility to turn off chapters. Also, some content can be optional for the client and the client can therefor decide to skip certain parts. 

Configuration page of a module where a professional can (1) turn off a chapter and (2) can add a moduleExample of an optional section where a client can choose to skip parts of the module or to follow them all

3.   What you will find in a data export: information on ‘Modules in module list’

In the export file ‘modules in module list’ you will find more information on the (mobile) modules that are used in your platform.

As this file does not contain private information, it can be downloaded by both the data analyst and the data officer. Of course you still need to handle this file with care.

Why does this file exist? I thought there was already an export for mobile module data?

You are right, there is also the file ‘module steps’. There are three differences between these files worth mentioning:

  1. The file ‘modules in module list’ shows you information on when a modules was added while the file ‘module steps’ does not.
  2. The file ‘modules in module list’ contains information on both the person that activated the module and is currently guiding the module whilst the ‘module steps’ only shows the current guidance and, probably most important:
  3. If you are interested in ‘basic’ information like when a module was offered by who and how far along is that module, the ‘modules in module list’ is nice lightweight alternative to all the details shown in the ‘module steps’ file, making it an easier file to download and process.

What do the different columns show?

Per column we will share the most important information on how to interpret the available information.

  1. client database id
    Each client account in Minddistrict is automatically given a unique, anonymized platform ID. This ID is shown in this column. With the information in this column, you can for example:
    • Find out how many unique clients were offered a (mobile) module. 
    • Find out how many modules were offered per client, as every module gives you 1 line in the datafile.
  2. professional database id

    Each professional account in Minddistrict is automatically given a unique, anonymized platform ID. If this column is filled it means that the mentioned professional is currently linked to this particular module.

    Good to know: the data only shows the current linked professional and it could be that the module was previously guided by another professional. If the column is empty there currently is no guided professional.
    Please note that the fact that a module is guided by a professional does not necessarily mean the feedback function is activated; these are two separate functionalities.
  3. module list id and module id
    A client is offered a module (so module id) within a module list (so module list id). So, a module list can contain one or more modules. But a client can also be offered multiple module lists.
    This difference has to do with the question if you offer modules simultaneously or sequentially. If a therapist offered a client 2 modules simultaneously you will see
    -    m.1 – l.1
    - m.1 – l.2
    In this case the client has 2 modules available at the same time and the client can choose which one to open.
    If the therapist offered a client 2 modules sequentially you will see:
    -    m.1 – l.1
    -    m.2 – l.1
    In this case the client has 1 module available and can only start with the second one if the first one is finished.

  4. creation
    This column shows the date and time of when the module was activated for the client.

  5. completion
    This column shows the date and time of when the module was 100% finished by the client; the very last page will get the status ‘done’.

     In practice we see a lot of clients not reaching the exact last page of a module, as they do not click the button on the last page to fully finish.
  6. content id
    This column shows the content ID of every separate module offered. This is the ID that is automatically created when the content editor creates the module in the Content Management System (CMS).

  7. content title
    This column shows the content title of every separate module offered. This is the title that is created by the content editor when they created the module in the Content Management System (CMS).

  8. content version
    Whenever a content editor decides to make changes in a module these changes can be released which leads to a new content version. Changes in a module can be either very small (a typo was fixed) or bigger (content was revised, more pages were added or pages were deleted). In case of bigger changes this can have an effect on the column ‘total steps’.

  9. latest completed step offset
    The column latest completed step shows you the last step the client completed.

  10. total steps
    The column  total steps shows you all steps that that that version of the module consists of.

  11. latest completed step timestamp
    This column shows you the last moment the client completed the latest completed step.

  12. creator and creator user type
    These column shows you the database ID of who activated the module and, for a quick and dirty overview, show you the type of user that activated the module. In case the client did this themselves this can mean 2 things:
    1. The client went to the self-help catalogue to select a module. In this case the module will be added in a new module list. (and the client will have l.1-m.1, l.2-m.1)
    2.    The client got the chance to select a module in another module via the optional content section and thereby activating a trigger. In this case the module will be added in the existing module list (and the client will have l1 – m2).

How can I use the available data to calculate the completion percentage?

You can’t.

Ok, but how can I get a rough estimate?

You can calculate the general feeling for completion percentage of a module by dividing last completed step by total steps.

Why do you need to be careful in interpreting the completion percentage?

There are three things important to consider when looking at the completion percentage:

  1. A (part of) a module can only get the status ‘done’ if it is submitted. For example: if a module consists of 25 pages and only 1 sending moment at the very end, none of the pages will get the status ‘done’ until the client reaches that very last page. Until then, the pages before will get the status ‘queued’.
  2. A professional can customize a module. For example, he can allow a client to skip a chapter. This does not have an effect on the ‘total steps’, but it does have an effect on ‘latest completed step’; as soon as a client is past the skipped chapter, the number of completed steps can jump up.
  3. A client can also customize a module by choosing which parts of an optional section to use. This has the same effect as the customization by a professional; as soon as the client proceeds, the number of completed steps can jump up. 

How can I use the available data to calculate dropout?

If you combine the information from the calculation of the completion percentage with the column ‘last completed step timestamp’ You can use this information to calculate dropout.

At Minddistrict we define dropout as follows:
A module will be considered completed if 80% of the steps/sessions have been completed.
A user will be considered as having dropped-out a module when:
•    The module is not completed
•    AND more than 60 days have passed since the last step/session completion when next action is on the client (eg. feedback is available, or session/step is active)

We chose 60 days as we have seen in (historical) usage data that this timeframe pretty accurately predicts clients not proceeding anymore altogether.