How to track, view, export the data you requested

With rogr.io, it is really easy to request, track and consolidate ad-hoc structured data. In our last post, we showed you how to set up project reporting and send it out to your recipients in three simple steps.

Now let's have a look at how easy it is to track, view, and export the data you requested—and how you can download individual data from potentially hundreds of recipients in one, easy-to-process data set.

Status Overview

After logging in to rogr.io, you see the list of fetches you sent and received. In the example below, you see that already 50% of respondents replied to your status report request.

Clicking on the fetch, opens up the details. You see all the recipients, and whether they replied or not. The envelope symbols allow you to send out reminders.

View individual data

To see what each of the respondents reported, just click on view data next to their name. You see their input in the same format that they filled it out.

Exporting data

More useful is probably to get all the data you received together, in one document, ready to be used and processed further. Click on the export symbol on the right. You have two options:

• Classic format which is optimized to be easy to read.
• Pivot format which has all data in one spreadsheet, for Pivot tables or DWH import.

 Let's look at the classic format. The file you download has one spreadsheet for all simple data elements, and additional spreadsheets for all data elements with dimensions.

The first data elements is a nice overview of the project names and managers.

The last spreadsheet, for example, contains the data of the three-dimensional data elements that we created to capture the financial data.

We prefer an easy-to-read format and create a Pivot table with a few clicks looking like this:

All data from all respondents is combined in one data set. In this example. we used only two respondents, but in real-world scenarios there can easily be hundreds. Imagine the amount of time, errors, and double-checking that this saves you!