Data collection methods at the metric level

This article talks about the various options available to add data on impact metrics for one or more projects or investments.

Pre-requisites:

  • Impact strategy with metrics.
  • Impact Maker has at least one project (portfolio company).
  • You have assigned at least one metric to your project (portfolio company).

There are three fundamental ways of collecting  data in Impact Metrics

  1. Self-reporting data in the metrics/indicators from the data view screen of an investment
  2. Sending an online survey of impact metrics to a list of investments/projects. The investment/project manager fills up the data for the metric on this survey
  3. Calculating the results in the indicators by connecting the indicator and raw data collected on Impact cloud through a formula configuration

1. Self-reporting data

  1. Once you have created the metrics and assigned them to your projects or investments, navigate to the relevant investment/project for which you want to add the data (Your overview screen looks something like below

2. Click on the relevant investment. The screen, as shown below, will open up. In the absence of data, the screen appears empty.

3. Choose the frequency from the first drop-down and the created TOC from the second. The screen should look something like the one below.

4. Choose the period for which you want to enter the data from the 3rd drop-down(You may select one or more periods). The screen looks like the below after the selection is made

5. Click on the "EDIT" button right below the period for which you want to enter the data. On clicking "EDIT," the screen looks like this: (Notice that Target is checked and that is the reason a text-box for target also shows up. It may or may not show up depending on what you have chosen)

6. Enter the data and click on "SAVE." The screen would look like this. 

7. Click on "BACK." That's it! Next time you navigate to this investment, the system brings back data for the previously chosen settings.

2. Sending an online metric Survey to one or more Projects/Investments

To create your own survey email notification template, follow this tutorial.

  1. This is the easiest way to collect data on the impact metrics. Just navigate to the projects/investments overview screen (Shown below)

  2. Click on the investment for which you want to collect data(You will be able to initiate data collection for multiple investments at once). The screen looks like below.

3. Click on the Collect button, you get two options

  • Survey Preview
  • Send Survey

4. To have a quick look at how the survey would look, click on the Preview Survey. You should see a screen that looks something like below:

5. Select the frequency and the year and click on ADD RESULTS.

Preview of the survey looks like this

6 . To set the Title/Description for the survey, click on the icon in the left sidebar (You will see a popup that looks like this) - Set it to your choice and "Save." 

NOTE: Each page can have its own Title/Description

You will notice that at the top of your screen, there is a countdown of the number of days remaining for the link to expire. All surveys expire in 30 days. 

The system automatically sends automatic reminders to the portfolio companies that haven't submitted their data every week and 3 days before the survey expiration. The reminders will stop once the data is submitted or if the portfolio company clicks on "Stop Reminders."

NOTE: To learn how to configure a reminder template, please review the article on how to configure an email template.

7. Once you are done setting up the Title/Description, to send the survey, click on the button Collect

Children's Education Fund 
O Import Data 
Reporting Period 
2020 
Collect 
Profile 
Frequency 
Data 
Impact Scorecard 
TOC Name 
Education Example 
Annually 
Search metrics

8. By clicking on Send Survey, you can send a survey that will collect data according to the metrics and ToC that you have previously configured and assigned to the companies. You can select one or multiple companies to send the survey to:

9. Then you can select the template that you will use to send out the survey. 

NOTE: To learn how to create a new email template, please review the article on how to configure an email template.  
10. If you want to set up the survey to go out every reporting period automatically, click on the Advanced (Recommended) to open the advanced options. Click on the drop-down Repeat to select how often to send out the survey automatically, and fill out the rest of the fields. 

11. Once you click on Collect Results, an email will be sent to the "Contact Email" entered on the "Project Overview" tab. Here is an example of the email received by the portfolio company using the default email template: 


Alex Son requires your data 
Sopact 
to me — 
Dear Equity for Farmers, 
D 
Inbox 
It is data collection time! Alex Son requires your collaboration to report your data as soon as possible. 
Please complete the entire survey before submitting. 
If you have any issue during this process, please contact support@sopagt.gqm 
You will find your survey form here: Survey_Link 
The link to your Survey will be valid for 30 days only, be Sure to enter your data during this period. 
Your unique login information to enter data is: 
user Name: skson@wharton.upenn.edu 
password: 
Thank you in advance for your timely response. 
Alex Son via Sopact. 
Reply 
Forward

12. To track which portfolio companies have sent out their data, click on the left menu and scroll down until Quick Links. Then click on Results Tracker.

 

 

 

 

13. The tracker screen looks something like this. It shows how many of the investees are in states,  "Not Started," "In Progress," "Completed."

3. Metric results from raw data

Pre-requisites

  • Raw data from stakeholders in your project tables
  1. To calculate metrics results from the raw data collected directly from stakeholders, navigate to the particular project or investment from your overview screen, as shown below

2. Click on the project on which you want to calculate results from the raw data (You should have imported raw data in the project)

Note: The purpose of this section is to show you the possibility and not every formula configuration that's possible (click here for the types of formula that can be set up)

3. Click on  Metrics and Results. Select the relevant TOC, and you should be able to see the metrics within the TOC

4. To connect a metric to the Table containing raw data, click on the pencil icon on the left-hand side of the metric (Shown in the picture above). 

5. Change the metric format to Formula Aggregation and then click on Formula Wizard.

6. Configure the formula and click on Save.

NOTE: For detailed instructions on how to create a formula behind a metric, review the article Connecting metrics to raw data with formulas.