All Collections
Partner Knowledge Base and Challenge Playbooks
Dashboard Articles
Partner Guide: How To Download A Report and Analyze Your Data
Partner Guide: How To Download A Report and Analyze Your Data
How to download your challenge numbers and create a participant list using PivotTables in Excel
Derrick Chew avatar
Written by Derrick Chew
Updated over a week ago

After running a challenge, you can download and look at your challenge information. If you're a free user, this data will only be your personal data. However, if you're an Impact/Inspire Admin, Citizen Science, or Campus Admin, you'll be able to pull your challenge data in its entirety.

Here are the steps on how to pull a report:

  1. Log into your Dashboard

  2. Make sure you're logged in as an Impact Admin (if you're in the correct admin role, you'll see "view as member")

  3. Click on "Reports" on the menu bar

  4. Select your challenge(s) in the Challenge drop-down menu

  5. Adjust the dates to make sure you encompass your entire challenge range

  6. Click on "Generate Report" and wait for the system to generate

  7. Then Click on "Download CSV" on the right side of the screen

That will pull a CSV of every piece of litter in your challenge.

To sort a list of participants, open the CSV in Excel (or any other spreadsheet software) and run a PivotTable. Here's how to do that:

  1. Select all items in your spreadsheet. You can click on the triangle at the top left of the column headers to quickly select all

  2. Click on the "Insert" menu in the menu bar and then click on the PivotTable icon

  3. Click on "OK" on the popup contextual menu

  4. From here, select "Litter" and move it to the "Values" box. Then select "Full Name" and drag it to the "Rows" Box.

  5. Then double click on "Sum of Litter" in cell B3 to open the "Value Field Settings" popup menu. Click on "Count" in the "summarize value field by" section and click "OK"

  6. Then to sort by largest to smallest litter numbers, right-click on any cell in the B column to open the contextual menu. Highlight Sort>Sort Largest to Smallest

  7. After that your list should be complete!

There are many other ways to slice and dice your data. For example, you can sort by Join code, Display Name, or Tags. Simply move different datasets between the different values to figure out the best way to display the data for your needs. Here is an article that helps explain how to use PiviotTables in more detail.

If you have any questions or need any more help, please reach out to your Client Success Manager!


Did this answer your question?