Reports
      Back to home
      1. Knowledge Base
      2. Investigator Knowledge Base
      3. Reports

      Circle Raw Data Export

      Only Circle administrators have access to Circle full raw data export.

      In this article you will find:

      Full raw Circle data export contains all the data collected by all Сircle members within the Сircle. Additionally, the report will contain the full list of questions and PROMs, which may be customized for each specific Сircle member. 

      Circle Administrators have the ability to download the Circle’s full raw data report from the Circle Details Screen. This report contains all Circle data with no cohort division. 

      How to export the full raw report: 

      1. Navigate to Circles and select the preferred Circle from the list 

        

      Select Circle

      2. Click FULL RAW EXPORT at the top right of the Circle Overview Screen

      Export Report 7

      Feel free to move to any other tab if required. When the report is ready, you’ll see a notification banner at the top of the page. 

      Export Ready_banner

      Clicking VIEW on the banner will take you directly to the EXPORT HISTORY tab where you can find your report at the top of the reports list and download it. 

      Export History

      You can click CLOSE on the banner to close it and access your report later.  

       

      How to download the existing report 

        

      All the Report builder and Circle raw data exports are stored in the EXPORT HISTORY of the Reports tab. 

      Export History

        

      There’s a table where you can find the details of your report: 

      • Report name 
      • Circle name: click the Circle name to go to the Circle Details page 
      • The person initiated the export, the time and the date the export initiated 
      • The time and the date the export completed 
        • The time is displayed according to the user's local time set on the device
      • The status (Failed, Pending or Ready to download) 
      • Action: the button DOWNLOAD activates when the report is ready to download 

      Click the arrow near the required column to put the items in the ascending / descending order. Ascending order

      Initially, the sorting is applied only to the visible results (about 25 items). To see the whole list, scroll down the page in order to load the rest (missing) items and then sort them. 

       

      To download the existing report

      To get the latest data in the report, re-export it on the Circle’s detail page. 

      1. Go to Reports and click EXPORT HISTORY tab 
      2. Find the report you’d like to download 

      Use Search to find your report faster 

      Find report


        3. Click DOWNLOAD next to the required report to download it on your device in the .xsls format

        Export History

        Reports Troubleshooting 

        • If the latest cases are not included in the report, re-export the report. 
        • If you don’t see PI data and/or the data of other Circle members in the report, your access to these data could have been limited. Contact your Circle administrator for more details. 
        • If you were granted access to the data, re-export the report to see the missing info. 
        • If the access to PI data was disabled, you won’t see the PI data when downloading the existing report. 

         

        How to read the exported report 

        The data ownership level can be adjusted for Circle Admin and Circle members to make data visible/non-visible in the exported Excel report. 

        In the exported report you’ll find two tabs: 

        • Protocol-related data 
        • Legend 

        The first tab contains: 

         

        Case-related info: 

        • Case ID  
        • Patient ID*  
        • Subscriber ID - the ID of the Subscriber to whom the given case belongs   
        • Patient Last Name*  
        • Patient Middle Name*  
        • Patient First Name*  
        • Birthdate*  
        • Email*  
        • Mobile Number*  
        • Country*  
        • PI Region  
        • Language of Communication  
        • Case Creation Data  
        • Case Commencement Date  
        • Treatment Date  

        *the visibility depends on the data ownership settings. 

         

        Survey-related info: 

        • Survey-related info (the information for each survey):  
        • Scoring group/s scores   

          Export Report 3

        • Survey due date  
          • The survey due dates are displayed for both: completed and not completed surveys
        • Survey completed date  
        • By whom the survey was completed  
        • Survey language  
           Export Report 4
        • The answers to the survey questions (for “decoding” the keys refer to the Legend tab)  
        • The visibility depends on the data ownership settings  
        Export Report 5

        Example: S217QT1Q569, where  

        S217 - Survey title (“Demographic and Diagnostic Survey”),  

        QT1 - Single selection question  

        Q569 - question “Smoking status?”‍  

         

        The Legend information is presented as follows:  

        • Survey keys and their names  

           

          

          

        • Keys to Scoring groups and their names  

         

        • Keys to the questions, where:  

        The questions in the legend go in the same order as in the protocol.

          

         

          

        1. Key column presents the key of the question:   

        S - number of a Survey  

        QT - Question type number (the number is static):  

        QT1-  Single Selection  

        QT2 - Multiple Selection  

        QT3-  Group Question  

        QT5 - Text  

        QT6 - Number  

        QT7 - Date  

        QT9 - Analog  

        QT10 - Image  

        QT11- PDF  

        Q (Q- 962) - question number  

        2. Survey name 
        3. Question type
        4. Question name 
        5. Additional Information: indicates the units of measurements or the answer options to the questions used in scoring groups with the corresponding scorings for each option