Data Collection Reports

Everything you need to know to access reports on Wooqer

Data Collection report will help you assess and analyze all data collection processes. Leveraging this report you can track parameters like Completion, Compliance (based on Cut-off & Geolocation), use various filters & graphs to slice and dice the aggregated data, create follow-up tasks for users incase of non compliance and also download the data in various file formats for further review.

Web Reports

Click on "Reports", which is the second tab on the Dashboard.
Select the "Process" tab. From this tab you can you can assess process across operations.
From this window you can choose between "Active processes" & "All Processes" using the filter option. Additionally, you can use the search option to search through the entire report listings to identify a specific process report.

Once the process is identified, leveraging the "Notification" option under "Action" column you can subscribe to various user level alerts based on various conditions. There are 3 conditions to choose from:

Submissions - This option is divided into to two types; "Each submission" & "Percentage submission". Former  allows you to get a notification every time a user submits a form and latter will allow you to get a notification when data is submitted for a certain percentage of participants. For the former one you can also choose to get an alert with a pdf attachment wherein you can further choose to have only answered questions. Whereas for the latter you can preset the percentage as per your business requirement.
Cut-off - The second alert option again is further divided into "Incomplete by end period" & "Complete by end period". Former, will send an alert with a list of participants who HAVE NOT submitted the data by cut-off and latter will send an alert with a list of participants who HAVE submitted the data by cut-off.
Before cut-off - The third type of alert "Notify before end period" will allow you to receive an alert as per predefined time (days before the cut-off / end period) at which to receive list of users who have not yet responded. For this alert to function properly you need to key-in the no of days in the "Days before end period" section and also enter time in "Time" section.

For a process with levels enabled(MLRA) , you will have an option to subscribe to 3 more alerts -

Notify not actioned before - You can get to know if the individuals have taken action before the due date (you can preset the day and time for the same)
Notify not actioned after - You can get to know if the individuals have taken action after the due date (you can preset the day and time for the same)
Notify blank due date - You will come to know if individuals have filled the due date or not (you can preset day and time).

Once the alerts are set as per your preference, you can choose the mode in which you want to be notified for any of the above conditions. You will have two options, one being "Email" which is free of cost and the other being "SMS" which is an add-on feature and will be charged as per your carrier.
As soon as you configure the alerts as per your preference, you need to click on "Apply" to subscribe to the alert.

Click on the "Pie" icon under Analyze column. The next screen that you land on will give you a quick peek of the completion over 6 consecutive frequencies for all the stores that are part of coverage. If its a daily process, then it will show 6 days, if weekly, then weeks and vice versa.

The first row of this screen, houses all the filters and export options. Leveraging the "funnel" icon you can filter the data based on "Location" & "Resources". Location will show the data for all the countries/cities and resources will show the data for all the custom made clusters.

The icon next to funnel option allows you to see the summarized data for all the coverages individually, over 6 frequencies on one screen.

Further to its right is an icon that allows you to see the consolidated data for all coverages over 6 frequencies.

Further right, is a store filter option that will help you see all the submissions/records for a particular coverage during a set time period. Once you click on this store filter option, the next window will let you select a store and set a time period for which you want to see the submissions.

The 2nd row on the report screen, showcases the name of the process creator, coverage, frequency and objective of the process. Additionally, it also gives you information about the number of submissions made during the below set 6 frequencies along with the most recent date when the process was last updated.

The third row, along with highlighting the name of the process report, also has a "Search" & "Pending Actions Summary" (If a process has levels enabled and there are any non actioned requests pending on certain users they show up here) options. With the help of search option you can further slice and dice the data based on various filters. On this screen, you can analyze the data based on "Report Date", "Response to Questions", "Submission Date", "Stores", "Submitted By" and "Columns". Once you choose the required filter you will need to hit "Apply Filter" to generate the report on the screen. As soon as the report is generated, you will also have an option to sort the data based on various data parameters and moreover, you can also save the filter using "Save this filter"; so that in future if you need to analyze the data in the similar manner instead of creating a new a filter you can use the existing filters to analyze the data.

The 4th row, gives you a calendar option using which you can go back and forth on the set process frequencies to see the summarized tabled data over 6 occurrences. Right next to the calendar are the 6 frequencies that once clicked on, take you to the records screen - wherein you see all the submissions made against all entities for a particular frequency.

Once you click on any frequency in row 4, the system will redirect you to records screen. On this screen all the options in row 1 (add-on attachments option),2 & 3 remain the same as screen 1. However, in row 4 and 5; you will see "Store Name", Record ID, Record Date and all the questions and responses related to the process against which data has been registered by all entities.

Under "Record Details" column, you will see two options, "Click to edit record"(if you are a process owner or administrator) & "Click to view details". Former will allow you to edit the report of all submissions (responses & attachments) and latter will help you further deep dive into individual submissions.

Using the "Click to view details" option, as soon as you land on the final screen, along with having an addition of two options in row one (Edit report & Resubmit - former allows you to edit the submission in the report and latter allows you to resubmit the same report post modification), you will also see addition of a few more fields like Reference ID, Filled By (gives you the information about name, date, time and the device of user), Report By and Report On in row 2. Additionally, the tabular section below row 3 will showcase the entire data related to the particular submission of this entity. Furthermore, using the filters in row 3 you can filter the data based on "Filled & All Questions".
Lastly, incase of any non compliance, to put the right measures in place, from this screen you can use the "New Task" option below "Follow Up Task" column to create a follow up task against every non complaint parameter.
On the first screen post clicking on "Analyze", row 5 will give you the completion percentage of the process over all the 6 highlighted frequencies. Completion figures show the fill percentage of all entities over a particular periodicity. Additionally, if you click on the completion percentage figures, you will land on a window which showcases the data of both "Completed" and "Not-Completed" entities. Furthermore, if there are multiple people assigned against one entity; this window will not only show you which entity the submission was made against but it will also give you the name of the person who filled the process against a particular entity for a specific frequency. Moreover, if need be, this data can also be extracted in the form a excel file by using the excel extract option stationed at the top right corner of this window.
On Wooqer, for a data collection process you can track compliance based on "Cut-off" & "Geolocation". This data can be seen and further analyzed using row no 6 and 7; however, it will be available only if these functionalities have been enabled on the process while creating the process. Just like how Completion row gives you the "Completed" & "Not-Completed" data of all entities associated with the process, in a similar manner "Cut-off" & "Geolocation" options will allow you to see the "Compliant" & "Non-Compliant" entity data (as per Cut-off & Geolocation).
Just below row 7, you will find the count of submissions in a tabular format, against each entity for a particular periodicity. If you click on any number, the system will redirect you to the respective records screen (of this entity); from where you can further deep dive into the individual records.
If there are any attachments or comments associated with various questions in a process, you can see all the attachments below the questions section and comments on the final reports screen, by hovering on the cloud icon, wherever it is visible in the "Response" column.

On the final report screen, using the "New Task" option you can create numerous follow-up tasks against any non compliant parameters.
To achieve this, identify any non compliant question, click on "New Task" and then from the New Task window, key-in all the mandatory information like Title, Assignee and finally click on "Create Task".
"Title" gives you a space to describe the task in brief. For example, if the lights are not working on Aisle 1, you can key-in "Lights not working".
"Assignee" section will allow you to assign the task in 3 ways. Firstly, if you feel that this task can be fixed by an individual, then you can choose to look him/her up using the initials of their name in the Assignee section. Secondly, if you think that the task can be better handled by a bunch of people working collectively, then you can choose to assign it to more than one person by keying-in their initials in the Assignee section. Finally, if you have created a Team or a group already and are of the opinion that the issue is better suited for a Team of specialists; then you need to check the "Assign to Group" checkbox (Stationed below Assignee section) and then search for the respective Team in the Assignee section and assign the task to this Team.
"Links To" basically works as a reference for the task assignee. Once the task is assigned to them; this option allows them to determine the process and the non compliant parameter to which this task is associated to.
"Due Date", will allow you to set the date by which the task needs to be completed.
"Description" along with giving you an option to expound on the issue, will also allow you to attach a reference file for the task assignees.
Once the task is created, you will have an option to see the status of the task in two ways. Firstly, you can see the status on the final report screen window (against every line item wherein you have created this task). Secondly, from your ToDo screen under "Pending with Others" tab. Using the second option you can not only see the task status but also communicate with the task assignees and nudge them in case they tend to be complacent.
Once the task is completed, you as a task creator will have an option to review it and then "Conclude" it.
Furthermore, if a task has been assigned to multiple people, all the task assignees will have an option to work on the task and mark it as "Complete" and also the task creator can choose to "Conclude' the task anytime, regardless of whether all users have completed the task or not. However, in case of a "Group Task", once a task is assigned to a group, only one person from the group can claim the task and complete it, by clicking on "I'm on it". Additionally, once a task has been claimed by someone, other members of the group get notified that the task has been taken up by another user and thus they do not get an option to work on it mark it as complete. Howbeit, if the claimant feels that the task is not within his/her skillset; they have an option to release it by clicking on "Release". Once its released all users that are part of group again get notified that the task is unclaimed and they can choose to jump on it.
In a Group task even though non claimants don't have an option to work on the task and mark it complete, however; they can support the claimant by communicating on the chat channel of the task and also by sharing any attachments on the same thread to aid the claimant close the task in a timely fashion.
Finally, in order to keep all the assignees and creators of the tasks updated with the status of the task throughout its lifecycle, there are various system generated alerts that go to every user involved in the task, at various stages.

At various stages of analyzing the reports you will also have an option to extract different types of reports from different windows, leveraging numerous filters.
To begin with, from row 1 of the 1st reports screen you can download the screen view of this screen in a PDF format by clicking on the "Export to PDF" option.
However, if you want to extract the data in the form of excel, you can download it by clicking on "Export to Excel". Once you click on this option, the next window will give you 3 ways in which you can download the data, "Screen view", "Submission date", "Periodicity (Monthly)". First option, will once again allow you to download the screen view on an excel file. Using the second option, you will be able to download the excel report based on submission date by setting the from and to date on the calendar. Additionally, you will also have a few options below to download this data along with these parameters. These parameters are, "Include inactive coverages" (if you want to see the data against the entities that were active earlier but are inactive now), "With comments" (for all questions wherein the users have keyed-in the data in comments section and you want to see that data on excel report),"With task status" (will showcase the status of the task throughout its transition on a separate excel sheet), "With pending action summary" (If there are any tasks at different levels that are yet to be actioned by the users assigned at those respective levels), "Include responses from another process" (If this process is a Master-Child process, then if you want to see the data of a child process in this process excel report then this option will allow you to do so).
The third and final way that the excel export option allows you to download the report in is "Periodicity (Monthly)". Using this option you can download the excel report based on the periodicity of the process by setting the from and to date on the calendar.
Once you set either of the three options on the Export window; you will need to click on "Export" option to download the report.
As soon as this report is downloaded, you will get to see detailed data of every entity (all submissions) in various rows. The data points that the excel report will showcase are Report generation Date, Reference No, EntityID, Enity Name, Questions, Responses, Comments, Submitted By, Submitted By (login_id), Submission, Levels (if enabled), Due Date (levels), Closed By (levels), Closed On (levels), State, City, Time taken for submission and Period.
Furthermore, if you choose to download the report along with the task status and if there are any pending actions on various levels (if added and assigned) then once you download the excel report, you will see 3 sheets. First sheet "raw_data", will showcase all the data related to the process, second sheet, "task status", will showcase the status of the task through its transition in various rows and finally the third sheet will showcase all the pending action items that haven't been acted on yet at different levels (will show only if levels are enabled on this process).
In row 3, once you click on "Search" option, on the following window you will have a provision to download the data in the form of excel and ppt. Before downloading the data, you can leverage various filters to sift the data and then download it accordingly. The excel report will download the data along with various aforementioned data points whereas using the "Export to PPT" option you can download a readymade ppt (works well for a process with pictures). The ppt report will give you an option to download a readymade report in 3 ways. Firstly, you can download the entire process report wherein you will see questions, responses and attachments on different slides (along with other relevant information). Secondly, you can download a report wherein you will have a comparison of reference image and attachment image on the same slide for every questions (this will also work for reference image and no attachment uploaded question). Finally, the third option will allow you to create a couplet between a two attachment related questions/attachment and non attachment question.
In row 5, 6 and 7, you will also have an option to download the excel data of "Completed", "Not-Completed", & "Compliant", "Non-Compliant" entities. In order to achieve this, you need to click on the percentage of completion, cut-off compliance or geo-compliance and then on the following screen from top right corner click on excel download to download the respective data.
On the final reports screen, in row 1; along with various filters, you will also see a PDF and Excel export option. To download the data from using these option on this screen you can follow the same steps as followed on screen 1. Moreover, these options are available almost on every screen and can be used in similar manner almost on every screen.
Next to PDF & Excel export options, on every screen you will also have an option to "Print" the report. Once you click on this "Print" icon, then the following screen will allow you to configure your print preferences, and finally print the reports.
Lastly, if there are any attachments that are part of the process reports you can either download all of them in one go (for all the entities) for a particular frequency from the Records screen; or you can download the same for individual submission from the final reports screen. The files will be downloaded in a Zip format which later on you'll need to extract into a more readable format (JPG etc) using any file extractor tool.

Mobile Reports

From the Homescreen, click on "Reports"; which is the second icon on the bottom counter.
Select the "Process" tab. Further you can either select "Quick Access" or "All Processes" tab. Former will show you the latest used 10 processes, whereas latter showcases the entire active process list.
If you can't find the process in the listing, you can also use the search icon (stationed at top right corner of the screen) to find the process. Once you have identified a Data Collection process, just below the name of the process; as a cautionary measure the system will highlight the progress of the process using either of the 3 labels - "Low completion", "Yet to be filled" and All well". "Low completion "will highlight the completion percentage of the process being low, "Yet to be filled" will indicate that none of the users have submitted it yet and lastly "All well" indicates that the process has been submitted by all assignees. Furthermore,, just next to each line item you will also see a progress bar, which indicates the completion of the process for its respective frequency.
As soon as you tap on any Data Collection process, the system will redirect you to the next screen from where you can see consolidated data (based on a few filters), subscribe to various submission related alerts, see the trend in a graphical manner over 5 consecutive frequencies, View detailed Analysis leveraging various filters and also send in the moment reminders to drive participation.

From the screen 1, leveraging the "Bell" icon (stationed in top right corner) you can subscribe to various user level alerts based on various conditions.
For a Data Collection process the system will ideally give you 4 conditions to choose from, namely - "For each submission made (everytime a submission is made on a process), "When completion reaches set percentage" (you can preset the percentage, once it reaches that number you will get an alert), "If filling is complete by cut-off time" (if the process has been completed by preset cut-off time), and lastly "If filling is not complete by cut-off time" (if the process has not been completed by preset cut-off time).
Once the alerts are set as per your preference, you can choose the mode in which you want to be notified for any of the above conditions. You will have two options, one being "Email" which is free of cost and the other being "SMS" which is an add-on feature and will be charged as per your carrier.
As soon as you configure the alerts as per your preference, you need to click on "back arrow" to save your preference. Additionally, if you want to remove an existing alerts, then you need to click on "Clear" to remove your earlier set preference.

On report screen 1, to the left of bell icon, you will see a Sigma icon. Using this icon you can see summarised data trend leveraging 3 filters; "Year-to-Date", "Quarter-to-Date" and "Like-to-Like".
Just below this is a small graph, which will give you an indicaton of the trend in a graphical manner over 5 frequencies.
Further below in red highlighting the percentage of completion, is an indicator of completion of the process for the selected frequency. If you click on "View Details", the system will redirect you to a screen wherein you will see the list of entities that havent given a submission yet. Above that section is the "Remind All" which once clicked sends allows you to send a custom reminder text to all the assignees of the respective entities over Talk channel. Using this channel, you can also choose to attach any type of files for the users reference.
If you choose to communicate with the assignees of indvidual entities then you can click on the cloud icon next to each entity under "Not yet filled" section.
On screen 1, below "Remind All" option is the list of all the Score type questions (over here you dont see data for other type of questions) with the collective responses of all entities; however, if you choose to see the data of individual entities on this screen you need to click on the "Funnel icon" which is stationed right next to "Remind All" button.
Once you click on the funnel icon, on the following screen you will see the list of all entities. If the list is short then you can identify & choose a specific entity quite easily; but, if the list is too long you can leverage the search icon above to sift through the listing. As soon as you find your entity, you need to tap once to check it and then click on "Apply". Instantly, the system will take you back to screen 1 from where you can now only see the responses to all the questions captured for the selected entity.
The icon below the questions section is "View Detailed Analysis". This will help you deep dive into individual submissions coming from various entities.
On "Detailed Analysis" screen to analyse the data you can scroll between 5 frequencies at a time. Moreover, you will also have 3 filters dropdown icons from where you can choose to slice and dice the data further based on various filters.
For a Data Collection process, the first icon will always be Completion (as score is not something that is being captured in DC), whereas the second dropdown will give you two filter options - "Entity" & Resource. Former will showcase the submissions with various Entities as reference and latter will showcase the data in the form of custom made clusters (if the clusters/groups have not been created, then it wont show any listing using that filter).
The thirs filter option allows you to filter the entity submissions based on All, Non filled Entities and Filled Entities. "All" will show all the entities in the list regardless of whether the data has been submitted against them or not, "Non filled Entities" will only show the list of Entities that haven't filled the data yet and lastly "Filled Entities" will show a listing of all the filled ones.
Once you have chosen a frequency and identified the entity (with submissions) leveraging various filters; to devlve deeper into various records you need to click on the entity once. As soon as you do that, the system will redirect you to the records screen; from where you can click on "View" to see a detailed report for the particular record for this entity. This screen will show Sections, sub-sections, questions, all the answer options (incase of MCQ, Rating etc), users responses and even the attachments if there are any uploaded by the user whilst submitting the data.
Lastly, this screen will also allow you to create follow-up tasks in case of any non compliance.

On the final reports screen, you can create a task for every question using the "Create Task" option. Moreover, you can create numerous followup tasks against any non compliant parameters.
Unlike web app in mobile app, once you click on "Create Task", you need to select the assignee(s) first and then from "New Task" window, key-in the Title of the task followed by a click on "Create" from top right corner. However, if you choose to add more information about the task, you can click on "More Options" drop down and enter Description, Due By data and also upload any attachment (Audio, video, image, document etc) for users reference.
"Title" gives you a space to describe the task in brief. For example, if the lights are not working on Aisle 1, you can key-in "Lights not working".
Additionally, "Assignee" screen will allow you to assign the task in 3 ways. Firstly, if you feel that this task can be fixed by an individual, then you can choose to look him/her up using the initials of their name in the Assignee section. Secondly, if you think that the task can be better handled by a bunch of people working collectively, then you can choose to assign it to more than one person by keying-in their intitals in the Assignee section. Finally, if you have created a Team or a group already and are of the opinion that the issue is better suited for a Team of specialists; then you need to search for the respective Team in the Assignee section and assign the task to this Team.
"Links To" basically works as a reference for the task assignee. Once the task is assigned to them; this option allows them to determine the process and the non compliant parameter to which this task is associated to.
"Due Date", will allow you to set the date by which the task needs to be completed.
"Description" alongwith giving you an option to expound on the issue, will also allow you to attach a reference file for the task assignees.
Once the task is created, you will have an option to see the status of the task in two ways. Firstly, you can see the status on the final report screen window (against every line item wherein you have created this task). Secondly, from Homescreen you can click on Social icon from the counter below and then select "TASKS" tab. The Tasks tab is further divided into three smaller tabs; "View All" (showcases all tasks), "Upcoming"(shows only the tasks that are to be filled soon) and "Overdue"(showcases only the tasks that are long-delayed). On this screen from above you can also use Search and the Funnel icon (filter option that allows you to filter tasks "By Assignee" and By Task Status") to find the task in question; once identified you need to click on it once, then the following screen will allow you to see the task status and also communicate with the task assignees and nudge them in case they tend to be complacent.
Once the task is completed, you as a task creator will have an option to review it and then "Conclude" it.
Furthermore, if a task has been assigned to multiple people, all the task assignees will have an option to work on the task and mark it as "Complete" and also the task creator can choose to "Conclude' the task anytime, regardlless of whether all users have completed the task or not. However, in case of a "Group Task", once a task is assigned to a group, only one person from the group can claim the task and complete it, by clicking on "I'm on it". Additonally, once a task has been claimed by someone, other members of the group get notified that the task has been taken up by another user and thus they do not get an option to work on it mark it as complete. Howbeit, if the claimant feels that the task is not within his/her skillsket; they have an option to release it by clicking on "Release". Once its released all users that are part of group again get notified that the task is unclaimed and they can choose to jump on it.
In a Group task even though non claimants don't have an option to work on the task and mark it complete, however; they can support the claimant by communicating on the chat channel of the task and also by sharing any attachments on the same thread to aid the claimant close the task in a timely fashion.
Finally, inorder to keep all the assignees and creators of the tasks updated with the status of the task throughout its lifecycle, there are various system generated alerts that go to every user involved in the task, at various stages.